Advanced Excel for Professionals
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
- INDEX & MATCH Lookup functions
- What-If:
- Scenarios and Scenario management
- Goal Seek
- Advanced Data Analysis and Presentation:
- Using Sparklines
- Create and manage PivotTables
- Filters in PivotTables
- Creating and managing Slicers
- Create and manage PivotCharts
- Manipulating options in existing PivotCharts
- Multiple PivotTables on same WorkSheet
- Grouping Data to analyse data by Year/Quarter/Month
- Building a BI Dashboard
- Trend Analysis:
- Using Scatter Charts and Trend Analysis
- Automating processes with Macros:
- Recording and Running Basic Macros
- Saving Work with Macros
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
- INDEX & MATCH Lookup functions
- What-If:
- Scenarios and Scenario management
- Goal Seek
- Advanced Data Analysis and Presentation:
- Using Sparklines
- Create and manage PivotTables
- Filters in PivotTables
- Creating and managing Slicers
- Create and manage PivotCharts
- Manipulating options in existing PivotCharts
- Multiple PivotTables on same WorkSheet
- Grouping Data to analyse data by Year/Quarter/Month
- Building a BI Dashboard
- Trend Analysis:
- Using Scatter Charts and Trend Analysis
- Automating processes with Macros:
- Recording and Running Basic Macros
- Saving Work with Macros
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: