1-day – £225 + vat

This Advanced Excel Training course will teach you how to use Excel to manage a spreadsheet, create advanced charts, use some of the advanced functions of MS Excel.

Advanced Excel Training Course Content

Advanced Excel – Absolute Cell Addressing

• Using Absolute References

Advanced Excel – Naming Cells and Ranges

• Working with Named Ranges
• Using the Names Box to Name Cells
• Using the Create Method to Name Cells
• Using Insert Name Define

Data Consolidation in Advanced Excel

• Consolidating Data across Workbooks
• Consolidating Data across Worksheets

Conditional Functions in Advanced Excel

• Introduction to If
• Using SumIf and CountIf
• Using Nested If’s

Lookup Functions in Advanced Excel

• Using Hlookup
• Using Vlookup

Data Validation in Advanced Excel

• Using the Data Validation feature
• Find Invalid Data

Conditional Formatting in Advanced Excel

• Setting Up Conditional Formats
• Using Conditional Formats to find MIN and MAX
• Using Formulae in Conditional Formats

Working with Data Lists in Advanced Excel

• Filtering
• Sorting
• Subtotals

Pivot Tables in Advanced Excel

• Using Pivot Table Wizard
• Modifying Pivot Table

Data Tables in Advanced Excel

• Creating Data Tables
• One Way & Two Way Tables

Advanced Excel Training Course Prerequisites

Attendees should know the basic concepts of creating an Excel Spreadsheet or have attended our Beginners Excel Training course.