The Advanced Microsoft Excel training course is designed for students to gain the skills necessary to use pivot tables, audit and analyse worksheet data, utilise data tools, collaborate with others, and create and manage macros. 

After completing this course, students will be able to: 

- Create pivot tables and charts. Trace precedents and dependents

- Convert text and validate and consolidate data

- Collaborate with others by protecting worksheets and workbooks

- Create, use, edit, and manage macros

- Import and export data


  • 01

    Course Files

    • Course Files

  • 02

    Microsoft Excel Advanced

    • Advanced Charts - Secondary Axis

    • Scenarios

    • Data Tables

    • Conditional Formatting Formulas

    • Pivot Tables

    • Logical Functions

    • Mathematical Functions - SUMIF

    • Nested Functions - IF and OR

    • Statistical Functions - COUNTIF

    • Text Functions



Richard Walters is one of NILC's senior level Microsoft Office trainer's and has more than a decade of experience in IT and Business Skills training. Richard has an advanced-level understanding of all Microsoft Office packages and specialises in Excel, Word, PowerPoint, Visio and Project.

Richard Walters

Senior Microsoft Application Instructor


  • When does the course start and finish?

    The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.

  • How long do I have access to the course?

    How does 1 years access sound? After enrolling, you have unlimited access to this course for 365 days - across any and all devices you own.

  • What if I am unhappy with the course?

    We would never want you to be unhappy! If you are unsatisfied with your purchase, contact us in the first 14 days and we will give you a full refund.