Embedded Files
Course Details
Course Details
Course Title
Advanced Excel Training
Duration
20 Hours
Overview
Overview
If you know the basics of Excel, including entering data, formatting cells, using functions and formulae and inserting charts and graphs, this Advanced Excel course will really unlock the power of the program and its advanced functionality.
Microsoft Excel is a very powerful spreadsheet application designed to save you time and make easy work of calculating, displaying and sharing data.
This Advanced Excel training course will introduce you to some of Excel's more powerful features.
Prerequisites
Prerequisites
Before attending our Advanced Excel Course you must first attend our Beginners Excel Training Course or have equivalent experience.
Course Objectives
Course Objectives
After attending our Advanced Excel course you will be able to:
- Use the advanced features of Excel
- Create advanced charts and tables
- Use advanced functions and calculations
Prerequisites
Prerequisites
Before attending our Advanced Excel Course you must first attend our Beginners Excel Training Course or have equivalent experience.
Course Objectives
Course Objectives
After attending our Advanced Excel course you will be able to:
- Use the advanced features of Excel
- Create advanced charts and tables
- Use advanced functions and calculations
Onsite Training
Onsite Training
This course can be run in-company anywhere & we can tailor the content to focus on your requirements.
Who is this course for?
Who is this course for?
This course is for delegates who are familiar with the basic concepts of creating an Excel Spreadsheet, or have attended our Excel Beginners Training Course.
Related Courses
Related Courses
Outline Details
Outline Details
Advanced Excel Training Course Content
Advanced Excel Training Course Content
Absolute Cell Addressing
- Using Absolute References
Naming Cells and Ranges
- Using the Create Method to Name Cells
- Using the Names Box to Name Cells
- Using Insert Name Define
- Working with Named Ranges
Data Consolidation
- Consolidating Data across Worksheets
- Consolidating Data across Workbooks
Conditional Functions
- Introduction to If
- Using Nested If's
- Using SumIf and CountIf
Lookup Functions
- Using Vlookup
- Using Hlookup
Data Validation
- Using the Data Validation feature
- Finding Invalid Data
Conditional Formatting
- Setting Up Conditional Formats
- Using Formulae in Conditional Formats
- Using Conditional Formats to find MIN and MAX
Working with Data Lists
- Sorting
- Subtotals
- Filtering
Pivot Tables
- Using the Pivot Table Wizard
- Modifying the Pivot Table
Data Tables
- Creating Data Tables
- One Way and Two Way Tables
Google Sites
Report abuse