Excel For Data Analysis

Module 1—What is Data Analysis?

Module 2: Beginner Excel Interface, Excel Ribbons, Tabs, Data Sources

Module 3: Common Excel functions SUM AVERAGE MAX MIN COUNT

Module 4: Working with cell ranges, Autofill, Arithmetic, and logic Operators

Module 5 Microsoft Excel—AverageIF, CountIF, Cell Referencing, Data Validation

Module 6: SUMIFS, Data validation & Creating Drop-Downs in Microsoft Excel

Module 7—Fixing Empty Cells, Duplicates, VLOOKUP, Xlookup, REPT

Module 8 Xlookup, Hlookup, Trend Analysis using – What If Analysis, Scenario Manager

Module 9 – Intro to Visualization and Pivot Tables

Module 10: Creating Dashboards, Pivot Table Analysis, Filters, Display Top 10 Reports

Module 11—Working with Excel Dashboards, KPIs, and Key Insights on Data