Excel feels overwhelming
We start with the anatomy of Excel: the ribbon, sheet tabs, cells, rows and columns. You will know where everything lives and what it does.
Microsoft Excel
Foundation Excel
Little or no Excel experience? In one friendly day you will go from finding your way around the screen to building tidy, correct, printable spreadsheets with confidence.
£500at your premises, up to 10 delegates
Up to 6: £450 | Up to 3: £400
£450live online, up to 10 delegates
Up to 6: £400 | Up to 3: £350
1 day, per session, not per person. Smaller teams pay less. With a full group that is as little as £50 a person in person, or £45 online.
Problems this course fixes
Your spreadsheets look a mess
Cell styles, the format painter and the format cells menu make a sheet clear and consistent in minutes.
You add things up by hand
AutoSum, cumulative totals and functions like AVERAGE, MIN, MAX and COUNT do the sums for you.
The headings disappear when you scroll
Freeze panes keeps them in view, and Find and Replace takes you straight to what you are looking for.
Printing never comes out right
Fix the common printing problems with page breaks, print areas, headers and footers, and save a clean PDF.
You worry about overwriting something
Lock cells, protect sheets and understand what happens when someone else opens your file.
You type the same thing again and again
The fill handle and Flash Fill finish lists and patterns for you.
What you will learn
You work through hands-on activities with practice workbooks, from labelling the Excel screen to building formulas and a chart.
Getting to know Excel
- The anatomy of Excel
- Sheet tabs: add, rename, reorder, copy, colour-code, hide and unhide
- Cells, rows and columns: insert, cut, copy, hide and resize
- Cell locking, protection and security
- Saving in different file formats
- Saving and using templates
Formatting
- Using the ribbon to format
- Cell styles
- The format painter
- The format cells menu
Useful commands
- Find and Replace
- Freeze panes
- The fill handle
- Flash Fill
Basic formulas and functions
- Understanding formulas
- AutoSum and cumulative totals
- AVERAGE, MIN, MAX, COUNT, COUNTA and COUNTBLANK
- TRIM, PROPER, UPPER, LOWER and LEN
- ROUND, ROUNDUP and ROUNDDOWN
- TODAY and NOW
Printing and PDF creation
- Common printing problems and how to solve them
- Page breaks and print areas
- Headers and footers
Data analysis
- Sorting and filtering, with a puzzle activity
- Getting started with charts
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 with little or no experience of Excel, or self-taught users who want to fill the gaps and stop feeling unsure.
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
Rachel's infinite patience and analogies! I've done several Excel courses in the past and not retained the info, but I learned so much on this one that's really relevant to my role.
I was a complete novice to Excel and now I feel confident in the basic application.
Rachel is fab! She explains things so clearly and makes the training fun.
Keep going
Intermediate Excel
Once the basics feel natural, Intermediate Excel adds conditional formatting, drop-down lists and PivotTables.
Ready for more? 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