Advanced Excel for Professionals
Associated Courses
Course Description
Learn the best ways to use Microsoft Excel for data analysis, reporting and modeling for decision making using real-world business scenarios. Designed for supervisors, managers or team members who need to summarise, report and analyse data, this course will present helpful tools to evaluate investments and financial decisions, ensure accurate data entry by creating a list of values, summarise data using histograms and PivotTables, estimate business variables using trend curves and present the data.
Course Structure
This course is split over the following modules:
Advanced Functions:
- Name Manager, Naming Ranges and Using them in Formulas
- Formula Auditing
- SUMIF, SUMIFS, AVERAGEIF, AVERAGEIFS
What-If:
- Scenarios and Scenario management
- Goal Seek
Working with Data:
- Advanced Relative & Absolute Cell References
- Restricting Cell Entries to Certain Data Types
- Data Validation Tools
Using Formulas:
- Introduce XLOOKUP function
- Advanced Date Functions (take into consideration weekends & PHs)
Advanced Data Analysis and Presentation:
- Using Sparklines
- Advanced PivotTables
- Grouping Data to analyse data by Year/Quarter/Month
- Summarise/calculations embedded in Pivot Tables
- Introduce, create, and manage Slicers
- Create and manage multiple PivotCharts
- Manipulating options in existing PivotCharts
- Multiple PivotTables linked to the same slicer
- Building a BI Dashboard
Power Query:
- Get Data
- Transform Data
- Load Data
- Create relationships between tables
Should Attend
This course is ideal for any person interested in enhancing their Excel skills.
Prerequisites
Applicants should have completed Excel Intermediate Level.
Assessment
There is no final assessment. Students will be guided during the course.
Key Features
There are no key features
Course Structure
This course is split over the following modules:
Advanced Functions:
- Name Manager, Naming Ranges and Using them in Formulas
- Formula Auditing
- SUMIF, SUMIFS, AVERAGEIF, AVERAGEIFS
What-If:
- Scenarios and Scenario management
- Goal Seek
Working with Data:
- Advanced Relative & Absolute Cell References
- Restricting Cell Entries to Certain Data Types
- Data Validation Tools
Using Formulas:
- Introduce XLOOKUP function
- Advanced Date Functions (take into consideration weekends & PHs)
Advanced Data Analysis and Presentation:
- Using Sparklines
- Advanced PivotTables
- Grouping Data to analyse data by Year/Quarter/Month
- Summarise/calculations embedded in Pivot Tables
- Introduce, create, and manage Slicers
- Create and manage multiple PivotCharts
- Manipulating options in existing PivotCharts
- Multiple PivotTables linked to the same slicer
- Building a BI Dashboard
Power Query:
- Get Data
- Transform Data
- Load Data
- Create relationships between tables
Should Attend
This course is ideal for any person interested in enhancing their Excel skills.
Prerequisites
Applicants should have completed Excel Intermediate Level.
Assessment
There is no final assessment. Students will be guided during the course.
Key Features
There are no key features
Register Your Interest: