Microsoft® Excel Stage 1 Training Course

Excel can be a little overwhelming and bit intimidating when you first get into the application. In this module you will learn how to start Excel and work with only the areas you need at this stage of your learning journey.

TOPICS COVERED

Introducing Excel

Starting Excel

Excel screen components

The tabs you will need at this level of your learning

Workbooks and worksheets

Entering data is easy when you know how.  Trying to work it out yourself can cause all kinds of problems. In this module you will learn the tips and tricks of entering and updating data, and how to avoid data entry frustrations.

TOPICS COVERED

Selecting and moving around the workbook

Entering data into the worksheet

Deleting and replacing data

Using Undo and Redo

Spell Check

Overlapping data

Working with columns

Adjusting the column width

Making changes to the data

Learn how to be the 'boss' of your files. Master the many ways you can save your work, close and open files, delete and rename them AND how to avoid many 'gotcha' situations that can have your heart racing if you're unaware of them!

TOPICS COVERED

Saving your file for the first time

Using Save As to make a copy of an existing file

Closing a file

Starting a new workbook (file)

Opening an existing workbook

Current or active workbook

Using AutoSave

Understanding how to create calculations and read other people's calculations is a fundamental and essential skill to have if you want to be a proficient user of Excel. Learn how to confidently create calculations that are free from error.

TOPICS COVERED

Different data types

Creating calculations

Checking cell content using the Formula bar

Creating a formula - step-by-step

Calculating percentages

Calculating GST

Copying formula

Using the SUM function

You have a worksheet full of data and now you want to make modifications to it. Learn how to change the layout of the worksheet, copy calculations, move and copy data between worksheets.  This module is NOT TO BE MISSED as it contains so many 'gotcha' and 'ah-ha' moments.

TOPICS COVERED

Inserting, deleting and hiding rows or columns

Search the workbook using Find

Copying calculations

Creating an absolute reference

Moving and copying information

Moving and copying using the mouse pointer

Copying an entire worksheet

Deleting a worksheet from a workbook

Your data can look very 'black & white', very plain and somewhat boring without formatting. Learn how to make your data pop! Add some pizzazz to your report AND learn why understanding number formatting is essential. You'll also learn what to look out for when working with already formatted cells.

TOPICS COVERED

Understanding Number formats

Avoid Number format 'gotchas'

Font and Alignment formatting

Merged & Center options

Removing formatting from a cell

OK... so you have your data laid out beautifully, your calculations are all 'on-point'. Your formatting is outstanding... so how come you can't print it? Learn all of the 'gotcha's' of printing and how to avoid them so that you can print your masterpiece with ease!

TOPICS COVERED

Previewing your work before printing

Setting up the worksheet for printing

Inserting a page break

Selecting what will print

Adjusting preset print settings

Additional print settings