Microsoft Excel Expertise: Advanced Training Course

Who Would Benefit

This course is ideal for professionals in fields such as finance, data analysis, project management, and administration who are already familiar with basic and intermediate Excel operations but wish to expand their expertise. It is also suited for students and academics who require advanced data manipulation capabilities for research or coursework.

Course Description

This advanced course is designed for individuals looking to elevate their spreadsheet skills to a professional level. This comprehensive course delves into the intricacies of Excel, empowering delegates to harness its full potential for data analysis, management, and presentation.

Course Category: IT, Microsoft and Social Media
Recommended No. of Days: 1
Course Location: To be determined by Client

Learning Outcomes

Develop proficiency in using both relative and absolute cell addressing to create dynamic and adaptable worksheets.
Apply advanced statistical and logical functions, including array formulas and if-statements, to analyse and interpret data effectively.
Utilise auditing techniques and comments to enhance collaboration.
Leverage Excel's powerful tools such as Goal Seeker, What-if scenarios, and pivot tables.
Automate tasks using macros, and enhance data visualisation through conditional formatting, linking, and the creation of standard, combined, and subtotals charts.

The Programme Includes:

Relative & Absolute Addressing
Statistical Functions
Logical Functions - If Statements
Array Formulas
Auditing & Comments
Named Ranged
Goal Seeker & What-if Scenarios
Pivot Tables
Conditional Formatting
Macros
Linking
Standard & Combined Charts
Subtotals
Further Functions
Vlookup & Hlookup, Xlookup
Date Functions
Rank Function