MS Excel Advance 2010

Course Description

This module is designed for intermediate to advanced users of Excel who are seeking to enhance their skills in data analysis, visualization, and automation. It provides a comprehensive exploration of advanced Excel features and techniques, preparing students for roles that require proficient use of Excel for data analysis, reporting, and decision-making.
Course Modules

  • Advanced Functions and Formulas:
  • Data Analysis Techniques
  • Data Visualization
  • Data Consolidation and Analysis
  • Advanced Data Manipulation
  • Macros and Automation
  • Data Analysis with Power Pivot
  • Collaboration and Sharing
  • Advanced Formulas and Functions
  • Scenario Analysis and Solver
  • Dashboards and Reporting
  • Project Development

Exit Profile
Upon completion of the Advanced Excel course with a strong proficiency in utilizing Microsoft Excel for advanced data analysis, visualization, and automation. Their ability to manipulate and transform data efficiently, along with their skills in data modeling and Power tools such as Power Pivot and Power Query, positions them as valuable assets in roles requiring data analysis, reporting, and decision-making. their advanced Excel skills, are well prepared to pursue rewarding careers in finance, analytics, consulting, and other fields where proficiency in data analysis and Excel is essential.


1. Understanding the basics of computer management

2. Managing free space on the server

  • Configuring tiered storage
  • Extending and shrinking partitions