Microsoft Excel - Advanced - Knowledgecom Corporation

Microsoft Excel – Advanced

Home > Courses > Microsoft Excel – Advanced

Course Objectives

After completing this course, students will be able to: 

Creating, Maintaining, Filtering and using Subtotals in a List 
Recording, Assigning and Using Macros 
Creating and Using User-Defined Functions 
Performing “What If” Analyses 
Working with Scenarios 
Querying a Database 
Importing and Exporting Files and Data 
Protecting Data 
Pivot Tables, Reports and Charts. 
Other Advanced Business Analysis Tools

Who Should Attend?

This course takes users to a high level of knowledge using financial topics available in Excel such as Financial functions, auditing and Charts. 

Pre-requisite

Delegates should understand any of the following operating systems: Windows 2000 or above  
Delegates should have a good understanding of Microsoft Excel or alternatively should have attended our Essentials course.

Module 01: Working with Named Ranges 

Understanding Named Ranges 
Defining Named Ranges 
Editing Named Ranges 
Deleting Named Ranges 
Using Named Ranges in Formulas

Module 02: Resolving Formula Errors 

Module 03: Sort and Filter 

Module 04: Managing Data 

Module 05: Outlining and Grouping Data

Module 06: Working with Scenarios 

Module 07: Using Solver 

Module 08: Managing Data 

Module 09: Advanced PivotTable Features 

Module 10: Using PowerPivot

Module 11: Using Macros 

Not Available

Course Detail

Calendar 2025

15-16 Jan

19-20 Feb

12-13 Mar

16-17 Apr

15-16 May

11-12 Jun

9-10 Jul

13-14 Aug

10-11 Sept

8-9 Oct

12-13 Nov

8-9 Dec

Have Any Question?

If you need further information about this course, please contact: