Microsoft Excel Advanced

Provided by

  • Sector IT
  • Course Type Online
  • Duration 25 online lessons (12 Months)
  • Price £20.00

Enquire about this course

About the course

Have some experience with Excel and want to improve your skills, or taken our Basic Excel course? This online course will help you learn intermediate and advanced Excel techniques.

In 25 engaging lessons you will learn how to find a value with VLOOKUP, create and format Pivot Tables, record basic Macros and more.

Whether you use Excel for work or study, these tutorials will help you on your journey to becoming an Excel Ninja!

  • Microsoft Excel 2016, 2013 and 2010 compliant
  • Award winning Microsoft MVP instructor Ken Puls
  • Certificate of training upon completing the course
  • Accredited with CPD UK
  • Bite sized video tutorials, cheat sheets, exercise files and quizzes
  • Unlimited testing
  • Self-paced course can be completed in your own time over 12 months


Essential Formula Knowledge

  • Understanding Dates
  • Understanding Time

Intermediate Formula Knowledge

  • Formula Auditing
  • Temporal Functions
  • VLOOKUP with Approximate Match
  • VLOOKUP with Exact Match
  • Other Lookup Methods

Optimizing Data

  • Naming Ranges
  • Excel Tables
  • Recording Macros

Data Analysis

  • Creating Pivot Tables
  • Formatting Pivot Tables
  • Calculated Fields in Pivot Tables
  • What-If Analysis

Presenting and Reporting

  • Outlining
  • Custom Number Formats
  • Conditional Formats with Built-In Rules
  • Conditional Formats with Custom Rules
  • Building Combination Line and Area Charts

Validating and Updating

  • Data Validation
  • Data Validation Lists
  • Styles

Preparing to Deploy

  • Custom Views
  • Page Setup Options
  • Security Considerations


Start date Location / delivery
No fixed date Online Book now

Related article

Bag yourself a course this Black Friday