Excel Intermediate in 1 day

Instructor-Led Excel Course

This course covers the essential Excel Intermediate, in our interactive, instructor led Live Virtual Classroom.
You already know your way around Excel e.g. you understand some of the functionality on the Home Ribbons, can move around and format cells. etc.
In the Excel intermediate course we cover in-depth functions and Formulae so that you will be able to create fantastic spreadsheets like budgets, forecasts, and more. You will be able to understand and unravel the complicated formulae created by your colleagues.
During the course you will excellent spreadsheets so that you have examples to take away.

Who should attend the Excel Intermediate Course?

This course is for Excel users with working knowledge of Excel, and data analysts, who would like to master in-depth Excel formulas.

Excel Intermediate Course Outline

Working with Functions and Formulas
The Excel Function Wizard
Using Functions in Excel: The 5 Popular functions
If-else function
Working with Names and Ranges
Copying formulae

Creating Formulae in Excel, general calculations.

Excel Lookups:
Excel Vlookup,
Hlookup,
Index,
Match.

Excel Formatting a Range as a Table:
Properties and behaviour of a table.

Managing Excel Tables:
Working with Tables.

Working with Excel Tables:
Working with Records and Fields.
Filters and Sorting, Freeze panes, split, protecting and unprotecting.

Using Excel as a Database:
Advanced filter: copy only specified rows and columns from a large data set, auto mate this selective copy.

Excel Pivot tables:
Create Pivot Table, Refresh Data.
Amend, Filter, Sort,
Format Pivot Tables,
Add additional Pivot formulae.

Excel Pivot Charts:
Excel Pivot Charts and Sparklines.
Examples and exercises with Pivot Charts and Sparklines.

Book the Excel Intermediate 1-day course

Contact us / Customise your Excel course

Powered byEMF HTML Contact Form

What makes the Excel course special?

Contact PCWorkshops