Go from starter analyst to a seasoned analyst when you take this course.

This Data Analysis with Excel for the Data Analyst takes you through 10 modules – exposing you to basic concepts of data modeling, data wrangling, create data cubes and building Business reports from scratch.

  • Module I: Introduction to Data Analysis in Excel using Data Analysis ToolPack, Solver Addin and What If Analysis – Goal seek
  • Module II: Introduction to the Microsoft Excel Data Model
  • Module III: Importing Excel Data from other workbooks, Databases, Web applications and Google sheets
  • Module I: Introduction to Measures and KPIs in Power Pivot
  • Module V: Data Transformation using Power Query
  • Module VI: Data Visualization – Building Dashboards, Super charts and Data Visuals in Excel
  • Module VII: Introduction to Visualization using Power BI (Basic Visuals and Measures)
  • Module VIII: Automation using Macros and introduction to VBA
  • Module IX: Querying Data using SQL
  • Module X: Data Forecasting Tools and Excel Formulas for Forecasting
OCL Learning