Course Overview

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

Outline

    1. Course Files

    1. Advanced Charts - Secondary Axis

      FREE PREVIEW

    2. Scenarios

    3. Data Tables

    4. Conditional Formatting Formulas

    5. Pivot Tables

    6. Logical Functions

    7. Mathematical Functions - SUMIF

    8. Nested Functions - IF and OR

    9. Statistical Functions - COUNTIF

    10. Text Functions

    11. VLOOKUP and HLOOKUP

Microsoft PowerPoint Advanced

  • £99.00
  • 12 lessons
  • Online self-paced

Start Learning Today

Uninterrupted 24/7 access for 12 months

Buy £99.00

Meet Your Trainer

Senior Microsoft Application Instructor Richard Walters

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.

Frequently Asked Questions

  • 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.

Success Stories

⭐⭐⭐⭐⭐

Rebecca Mollart

I run a charity and my very small team needed some tailor made Teams training rather than an off the shelf package as we knew the basics but were struggling with functionality. Rob was perfect and delivered a workshop/surgery interspersed with some formal input. Well worth the expenditure especially after wasting time trying to work things out ourselves for a couple of months. Will save us money on the long run. Pre-training arrangements were great too - efficient, responsive, friendly.

⭐⭐⭐⭐⭐

Tim Bainbridge

I have recently completed training in the International Computer Driving Licence (Microsoft Office), Levels 1 & 2. The standard of the service and training I received from NILC was excellent, throughout. Karim Dastgir and Julie Jones were always very friendly, supportive and flexible and as a result of completing the training, I have recently secured employment as an Administrative Assistant, with Cardiff University. The training directly enabled me to do this job.

Trusted By

Related Courses