The Intermediate Microsoft Excel training course is designed for students who want to advance their skill set by learning to work with advanced formulas, lists, and illustrations. Students will also work with charts and advanced formatting including styles. 

After completing this course, students will be able to: 

- Learn to use formulas and functions

- Create and modify charts. Convert, sort, filter, and manage lists

- Insert and modify illustrations in a worksheet

- Learn to work with tables

- Learn to use conditional formatting and styles.


  • 01

    Course Files

    • Course Files

  • 02

    Microsoft Excel Intermediate

    • Paste Special

    • Conditional Formatting

    • Locking and Protection

    • Filtering and Sub-totalling

    • Named Ranges

    • Database Functions - Multiple Functions

    • Grouping Worksheets

    • Worksheet Linking

    • Advanced Filtering

    • Freeze Panes


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.