inquire@insightsmanila.com
​0977.103.1800

MS Excel: Data Analytics Tool

This training includes a thorough review of the use of MS Excel in connecting and transforming data, performing basic DAX calculations, and presenting in charts.


Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Office 365, Microsoft 365

I.  Using MS Excel Functions and Tools for Data Analytics

Review of Excel Functions
• Text Functions
• Logical Functions
• Math and Statistical Functions
• Lookup Functions

Data Tab Tools
• Conditional Formatting
• Subtotal Tool

II.  Using Charts and Pivot Tables to Create Dashboards
• Review of Charts
• Creating Advanced Charts
• Pivot Table Features
• Grouping
• Slicers
• Calculated Fields
• Using “Show Values As”
• Pivot Charts
• Creating Dashboards
• Using Get Data Tool

III.  What If Analysis Tools
  • Goal Seek and Solver
  • Scenario Manager

IV.  Forecasting Tools
  • Forecast Sheet
  • Performing a Regression Analysis
  • Manual Linear Regression Analysis
  • Presenting Data Using Scatter Charts
  • Using Regression Analysis in Toolpak

V.  Data Modeling using PowerPivot
Importing Data using PowerPivot
Essential Power Query Tools
Data Modeling in PowerPivot
Creating PivotTables and PivotCharts in PowerPivot
Creating Measures and KPIs

Related Courses

Extensive MS Excel

Basic MS Excel

​Macros and VBA Programming