Microsoft Office 2016: Excel Part 2 (Advanced)

Microsoft Office 2016: Excel Part 2 (Advanced)

Deepen your Excel 2016 skills with advanced data analysis and visualization. Preparing for the Expert exam

Sonic Performance Support
Updated Jul 20, 2024

What you'll learn

  • Use advanced Excel functions to perform complex mathematical and logical operations.
  • Analyze large data sets using advanced tools such as PivotTables and PivotCharts.
  • Visualize data effectively using advanced charting techniques and conditional formatting.
  • Organize and analyze data using sorting, filtering, and database functions.
  • Create and manipulate dynamic reports and dashboards that meaningfully summarize data for decision making.
Course Description

"Microsoft Office Excel 2016 Part 2 - Advanced" is detailed course designed for those who want to deepen their understanding and use of Excel for comprehensive data analysis and presentation. This 2-hour, 27-minute course goes beyond basic functionality to explore advanced techniques in data manipulation, visualization, and analytical capabilities that help transform raw data into actionable insights.

You will learn how to cover key Microsoft Office Specialist exam objectives, prepare for the Excel 2016 Expert exam, and make informed, intelligent decisions based on your data analysis.



  • You have a basic knowledge of Excel and are ready to explore its advanced features for deeper data analysis.
  • You want to improve your ability to analyze and present data to contribute to strategic business decisions.
  • You are preparing for the Excel 2016 Expert exam and need to master the more advanced features of Excel.