Microsoft Excel Power User Course

Overview

‍

Duration

1 Day

‍

Aims

This course is aimed at attendees who want to expand their knowledge into some of the more complex functions, build reports using form controls, work with Power Pivots and use built-in automation offered by Microsoft Excel.

Prerequisites

Attendees who wish to attend this Microsoft Excel course should have attended our Excel Advanced course or be competent with the following advanced functions: IF, VLOOKUP, HLOOKUP, SUMIF and COUNTIF and have created and edited Pivot Tables.

Objectives

‍On completion of this course, delegates will be able to:

• Use Statistical, Lookup, Date, and text functions
• Working with Form Controls
• Carryout "What-If Analysis" using Scenario Manager and Goal Seek
• Get and load data from CSV/Text file
• Use advanced features of Pivot Tables
• Working with Power Pivots

‍

Course Content

Introduction and Objectives

Using Statistical, Lookup, Text, and Date Functions

• Using COUNTIFS, SUMIFS, AVERAGEIFS, MAXIFS, MINIFS, LARGE, SMALL, and IFS
• Use XLOOKUP, INDEX, MATCH and UNIQUE
• TEXT and TEXTJOIN
• Calculate dates using NETWORKDAYS, EMONTH, EDATE, WEEKDAY and WORKDAY

‍Form Controls

• How to insert form controls like a Combo box, checkbox, spin button and list box to build reports
• How to use form controls with Formulas

What If Analysis Tools

• Obtaining the desired result to a formula using Goal Seek and Scenario Manager
• Creating a scenario summary report

Get and Transform Data

• Import Text/CSV

Advanced features of Pivot Tables

• Apply Conditional Formatting to a Pivot table
• Creating Formulas in a Pivot Table
• Show report filter pages
• Adding Slicers and Timeline across multiple Tables
• Creating Pivot Tables using multiple worksheets

Power Pivots

• What is Power Pivot?
• How to add Power Pivot to the ribbon tabs
• How to add Excel data to the data model
• Create a Pivot table using the related tables

Hints and Tips

‍

Download PDF Outline

‍

Frequently Asked Questions (FAQs)

Who should attend the Excel Power User course?

Users who are confident with Excel at Advanced level and want to master complex functions, form controls, What-If analysis, advanced Pivot Tables, and data modelling with Power Pivot.

What are the prerequisites?

You should be comfortable with advanced functions (e.g., IF, VLOOKUP/HLOOKUP, SUMIF/COUNTIF), absolute references, multi-sheet formulas, and creating/editing Pivot Tables.

How is the course delivered?

Live online via Microsoft Teams with an expert instructor, demonstrations and guided practical exercises.

Which Excel version do I need?

Any current desktop version of Microsoft Excel (Microsoft 365 or Excel 2016+) is suitable. A Windows PC is recommended for the best experience.

Will I receive a certificate?

Yes — you’ll receive an ExperTrain certificate of completion after the course.

Does the price include VAT?

No. The price (£150) excludes VAT at 20%. VAT is added at checkout for UK customers where applicable.

How do I book a place?

Use the booking/enquiry options on this page, choose your preferred date and we’ll confirm availability and send joining instructions.

‍