The Pivot Tables and Advanced Filtering training manual has been designed to provide examples of how to use the Microsoft Excel features Pivot Tables and Filtering. All examples demonstrated in the book have been produced as “Step by Step” examples, with each example explained using easy to follow skill descriptions. The demonstration method in the book has been designed to provide easy to follow visual examples, to support training skill development in a very visual manner. 

Each training skill demonstrated in this book have easy to follow examples. Suggestions are provided in the Introduction section in to how to use this book, so purchasers get the best out of the book.

This book has been produced to provide all those who want to learn how to develop a thorough understanding of Pivot Tables and Filtering including Advanced Filtering. The book is suitable for those who have experience in the use of Microsoft Excel and want to develop useful new skills.


  • 01

    Microsoft Excel Pivot Tables & Advanced Filtering

    • Microsoft Excel Pivot Tables and Advanced Filtering


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.