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.

Gain an unfair advantage

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)
Office Legends Logo

Course Modules

 Overview

1

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
2

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
3

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
4

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
5

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
6

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.

Testimonial
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.


Office Mastery   |  Office Mastery Digital Academy
Copyright © Two Rivers Software Training. All Rights Reserved Privacy Terms Contact
Like us on facebook Watch us on YouTube Connect with Jason on LinkedIn
Office Mastery