Microsoft Excel is the industry leading spreadsheet software program, a powerful data visualization and analysis tool. This private 8-hour program (4 sessions x 2 hours) will continue your Excel journey with intermediate-level tools and functions.

Learning Outcomes for Intermediate Level:

• Provides intermediate level of Excel functionalities
• Use of advanced features in the software
• Prepare for specialized fields

FULL COURSE OUTLINE: INTERMEDIATE

• Basic Functionalities
  • Working with tables & Creating table appearance
  • Understanding and creating table structures
  • Validating cell data
  • Advanced Filters
  • Customize the ribbon
  • Making a copy of the formula, formula to values
  • What if Analysis
  • Pivot table
  • Pivot table options
  • Power Query
  • Power Pivot
  • Pivot table analyse and design
  • Working with Pivot Chart
  • Pivot Chart Options
  • Data Analysis with Excel
  • Working with Forecast function and sheet
  • Outline (Group, ungroup)
  • Working with forms and the form tools.
• Reporting
  
  • Excel Dashboards
  • Working with slicers
  • Develop user interactive dashboards
• Charts
  
  • Advanced concept in charts and reports
  • Waterfall Chart
  • Combo Chart
  • Funnel Charts
  • Box and Whisker Chart
• Project 1
  
  • Project related to data analysis based on the subjects studied above
• Project 2
  
  • Project related to charting based on the subjects studied above
• Project 3
  
  • Project related to Dashboard based on the subjects studied above