Menu
Insights Training
  • Home
  • Webinars
  • Public Schedules
  • Course List
  • Clients / Class Pictures
    • 2017 Class Pics / Clients
    • 2018 Class Pics / Clients
    • 2019 Class Pics/ Clients
    • 2020 Class Pictures
    • 2021 Class Pics
  • Testimonials
  • Convert Courses to Online
  • Request for Proposal
  • Insights Online
  • Take an Assessment
  • Blog
  • Contact Us
  • OTHER SERVICES
  • Privacy Policy
  • Code Verifier
  • Blog
  • Refer and Earn
  • Home
  • Webinars
  • Public Schedules
  • Course List
  • Clients / Class Pictures
    • 2017 Class Pics / Clients
    • 2018 Class Pics / Clients
    • 2019 Class Pics/ Clients
    • 2020 Class Pictures
    • 2021 Class Pics
  • Testimonials
  • Convert Courses to Online
  • Request for Proposal
  • Insights Online
  • Take an Assessment
  • Blog
  • Contact Us
  • OTHER SERVICES
  • Privacy Policy
  • Code Verifier
  • Blog
  • Refer and Earn

Excel for Data Analysis and Presentation

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
Download Outline
Find Public Class
Send Email

Home

Courses

Public Classes

Contact

Copyright © 2022