Urgently need to master the basics of Microsoft Excel but have no idea where to start?

Discover how to create simple, yet well-designed spreadsheets with formulas that work BY THIS TIME TOMORROW, even if you're starting at zero.

Is Microsoft Excel Your Kryptonite?

You found the perfect job but they say you must know Excel.
Formulas and spreadsheets are like a foreign language. It's overwhelming.
You're scared to touch anything in case it breaks!
You’ve been dabbling for months (or years) but still haven’t gained any traction.
And the Excel for Dummies book ... yeah I get it - say no more!

INTRODUCING

The Beginners Excel Bootcamp

Your one-stop-shop for quickly mastering
the basics and essentials of Microsoft Excel

(YOURS WHEN YOU JOIN THE OFFICE LEGENDS ACADEMY)

VIEW PRICING

Course Modules

Overview

MODULE 1: FUNDAMENTALS TO HELP YOU GET YOUR BEARINGS

Creating, saving closing, opening and renaming a workbook
Working with tabs and ribbons
Using Excel's Help Tools
Working With Rows, Columns & Cells
Working with text, numbers, dates and percentages
Selecting a cell, a cell-range, row or column
Inserting, deleting and resizing rows or columns
Moving and navigating around a worksheet

JOIN THE ACADEMY

MODULE 2: UNLOCK THE SECRETS TO WRITING FORMULAS

Entering and editing a formula
Formula rules, formula mistakes and best practices
Five basic functions to get you started - SUM, AVERAGE, COUNT, MIN, MAX
Adding together a group of numbers
Averaging a set of numbers
Counting how many numbers in a range
Finding the largest/smallest number in a range
Where to find and use other functions

JOIN THE ACADEMY

MODULE 3: ADDING SOME POLISH FOR A PROFESSIONAL FINISH

The Format Cells dialog box
Formatting a number or date
Aligning, repositioning or angling text
Controlling text with word wrap and shrink to fit
Merging cells - the easy way and the better way
Superscript, subscript and strikethrough
Setting borders and shading
Using the Format As Table feature
Using AutoFill and the AutoFill options
Inserting an image and positioning it correctly amongst text

JOIN THE ACADEMY

MODULE 4: TOOLS OF THE TRADE

Copying and moving data using cut, copy and paste
Copying and moving data using drag and drop
Copying styling using Format Painter
The Windows Clipboard vs the Office Clipboard
Spell check
Using Find and Replace to make bulk changes
AutoCorrect - why it's so useful and how to add your own

JOIN THE ACADEMY

MODULE 5: AMAZING CHARTS

Creating a chart with one key press
Creating a chart using the Chart Ribbons
Changing the chart type
Setting the chart title
Labelling the chart axes
Turning the chart gridlines on or off
Showing or hiding the legend
Adding data labels for clarity
Displaying the chart on its own sheet or next to the data

JOIN THE ACADEMY

MODULE 6: THE PLAYBOOK FOR PREPARING A WORKBOOK TO BE PRINTED

Setting the page size and orientation
Setting the margins
Creating a simple header and footer
Printing column headers and rows labels on every page automatically
Changing where pages break
Printing the whole worksheet or just a selection
Previewing the worksheet before printing

What Beginners Excel Bootcamp looks like

What are people saying about this course?

NANIKA

PRINSLOO

CRYSTAL CLEAR

Thanks a million. I have gone on courses, I have paid people to teach me and I still couldn't get it. Your videos are crystal clear and now I don't know why it was so difficult!

STEVE

MANSFIELD

TOTAL TECHNOPHOBE

Many thanks - even a total technophobe like me could follow this!

JODI

MARTYN

GREAT FOR VISUAL LEARNERS

It was really user friendly. I’m a visual learner and I love that I can do this in the comfort of my own home. Doing the courses exercises as I go and having to think and work out things for myself has really helped.

ANNA

CHEN

I LEARNT SOMETHING NEW IN EVERY VIDEO

I am 31, a mother of two and I work part-time. The last time I used Excel was 8 years ago. This is a fabulous product and I thank you for letting me be a part of it. It works for me because I have constant interruptions. I love that I can come back to it any time, do an hour in the morning, half an hour during lunch or in the evening. I don't have time to attend a classroom course.

Straight away I started to learn new things. It's easy to follow. I learnt something new in each video. Some of it I found easy and some took a bit of practice. The format works very well for me.

JOIN THE ACADEMY TODAY