Your Cart

Transforming your Excel skills

Joining the course is a TRANSFORMATIONAL journey.

You’re going to START with very little or no Excel experience and you’re going to learn SKILLS YOU WILL NEED for an office/admin role, you will end up with a skillset your colleagues will envy.

You’re going to be ABLE TO CONFIDENTLY complete beginner/intermediate Excel tasks like Sort, Filter, Sums, Simple Charts/Graphs, Formatting and much more…

Most importantly, you’re going to FEEL more at EASE with Excel

Join today!!

Early Bird Offer

£97

Course curriculum

1

Stage 1
- Excel Workbook for Stage 1 and 2
- Excel Intro to the Ribbon video
- Intro to the Excel Ribbon Free Preview
- Understanding file formats Free Preview
- Navigating Tab
- Range Tab
- Sums_Resize tab
- Autofills tab
- Flashfills tab
2

Stage 2
- Insert_delete tab
- Cut_Copy_Paste tab
- Transpose a range
- Cell comments
- Understand absolute, relative & mixed cell references
- Use a template
- Freeze columns and rows and split panes
- How to create a Table
3

Stage 3
- Excel Workbook Stage 3
- Format dates and numbers
- Wrap text, expand/collapse the formula bar, center across selection
- Cell styles, add colour/gradient effects, add borders and lines
- Conditional Formatting
- Insert a sparkline and apply a common vertical axis
4

Stage 4
- Excel Workbook Stage 4
- Understand chart types, layouts and styles
- Chart elements - add, remove, edit and format
- Chart filters, non-contiguous source data, data series & categories
- Numerical axes_add data labels and manipulate pie charts
- Chart with 2 vertical axes_combo chart_trendlines
5

Stage 5
- Excel Workbook Stage 5
- View in different windows_side by side_duplicate and hide
- Cross worksheet formulas_Find and Replace
- Print preview_and all things print
- VLOOKUP workbook and video training
- COUNT training