Formulas break when you copy them
Relative and absolute cell addressing, the $ sign, explained so it finally makes sense. IFERROR hides the error messages.
Microsoft Excel
Intermediate Excel
You can find your way around Excel. Now learn to build spreadsheets that check themselves, flag what needs attention and summarise thousands of rows in a few clicks.
£550at your premises, up to 10 delegates
Up to 6: £500 | Up to 3: £450
£500live online, up to 10 delegates
Up to 6: £450 | Up to 3: £400
1 day, per session, not per person. Smaller teams pay less. With a full group that is as little as £55 a person in person, or £50 online.
Problems this course fixes
You count and add things up manually
COUNTIF, SUMIF and AVERAGEIF, and their IFS versions, count, total and average only the rows you choose.
You cannot see what needs attention
Conditional formatting, data bars, colour scales and icon sets show the story at a glance.
People type anything into your columns
Data validation and drop-down lists keep entries consistent, with helpful messages when something is wrong.
Reports take hours to build by hand
PivotTables summarise big lists in seconds, and slicers and timelines let anyone filter them.
Data arrives in a mess
Text to Columns and other data cleansing hacks tidy up what other systems give you.
Your numbers do not convince anyone
Combination KPI charts, Gantt charts and sparklines turn numbers into something a manager can read in seconds.
What you will learn
You build real working files: a sickness-tracking summary, an application tracker with check boxes and a PivotTable dashboard.
Formulas and functions
- Relative and absolute cell addressing
- Hiding errors with IFERROR
- COUNTIF and COUNTIFS
- SUMIF and SUMIFS
- AVERAGEIF and AVERAGEIFS
- Named ranges with GROUPBY and PIVOTBY
Conditional formatting
- Pre-set rules
- Data bars, colour scales and icon sets
- Creating your own rules
- Project: an application tracker with check boxes
Data validation
- Building validation rules
- Drop-down lists
- Information and warning messages
PivotTables
- Building and formatting PivotTables
- Slicers and timelines
- Auto-updating PivotTables
- Creating a dashboard
Data cleansing hacks
- Text to Columns
- Extra functions: TEXT, FILTER, VSTACK and HSTACK
Data analysis
- Combination KPI charts
- Gantt charts
- Sparklines
How the day works
1 daytaught live by me, from start to finish
Up to 10delegates in the room or on screen
Your venueat your business in Nottingham, Derby, Leicester and Loughborough, or live online
Taught by me, Rachel
After 20 years in the workplace and 12 years teaching, I know what people actually need from Excel and Power BI.
Who it is for: People who are comfortable with the basics and want to build more practical, functional spreadsheets for work.
What you need: A current version of Microsoft 365 Excel. Some of the functions we use (GROUPBY, PIVOTBY, FILTER, VSTACK and HSTACK) are only in recent Microsoft 365 versions.
Before the course: your checklist
A few minutes of preparation means we spend the whole day learning. Tick things off as you go.
Organiser and IT
Each delegate
What delegates said
So many new skills and shortcuts. A massive help to save time. The course instructor was really good and engaging, and made the day great.
I really enjoyed that you took the time to help us with specific real-life Excel issues that we are experiencing. This tailored, personal approach made the topics even more accessible.
The course was really interactive and easy to follow along with the course leader's screen shared in front of me. The activities were really useful to practise applying the knowledge.
Keep going
Advanced Excel
Advanced Excel takes you into lookups, macros, Power Query and PowerPivot.
Ready for more? See the courseFoundation Excel
Start with Foundation Excel, which covers everything this course builds on.
New to Excel? See the courseSave with a bundle
The Complete Excel Package is £1,450 in person or £1,315 online. All five Excel and Power BI courses together are £2,700 in person or £2,500 online. See all prices