Microsoft Excel Introduction

This basic Microsoft Excel course is ideal for beginners who want to learn how to produce spreadsheets, work with data and perform basic calculations.

1 day course
What you will learn:
  • Create, modify, and format a spreadsheet
  • Use basic formulas and functions
  • Calculate and manage multiple worksheets
  • Create a chart
  • Customise the print settings and print
What you'll get:
Courseware and Handouts
Live Recorded Session copy
Capped Class Sizes
e-Certificate
Course prerequisites

Participants will need to be familiar with Microsoft Windows and basic Windows techniques such as opening, closing and saving files.

Before Session:

Please ensure you have downloaded the latest version of the software Microsoft Excel Desktop for use within the session. We also require a working computer with a microphone and speaker installed, and an up-to-date web browser for this training. For the best experience we recommend downloading the latest Google Chrome browser.

It is also recommended that you have a second screen attached to your computer.  This will allow you to watch the online training session and complete the course activities at the same time.

Looking for In-House training?

Discover our Microsoft Excel Introduction In-House training course. Can’t find what you are looking for?  Enquire for online training today!

Topics covered in this training course:
  • Navigation shortcuts
  • Quick range selection techniques
  • Getting data into your spreadsheet
  • Data entry ranges
  • Adjust column widths
  • Indenting
  • Centre aligning
  • Merging and centring
  • Text Wrap
  • The Sum function
  • AutoSum
  • AutoFill a formula
  • Basic formulas
  • BOMDAS rule
  • AutoCalculate
  • Editing formulas
  • Copy and paste
  • Copy an entire sheet
  • Calculating across worksheets
  • Copying formulas
  • Renaming sheets
  • Inserting/deleting a sheet
  • Grouping sheets
  • The AVERAGE function
  • The MAX function
  • The MIN function
  • Font formatting
  • Number formatting
  • Borders
  • Cell shading
  • Format painter
  • Adding cell comments
  • Inserting columns/rows
  • Deleting columns/rows
  • Hiding columns/rows
  • Freeze panes
  • AutoFill sequences
  • Quick list sorting
  • Basic list filtering
  • Selecting data to chart
  • Creating a chart
  • Changing the chart type
  • Switching columns/rows
  • Adding titles
  • Reposition the legend
  • Using chart layouts
  • Printing a chart
  • Pie chart specifics
  • Print preview
  • Margins, orientation, scaling
  • Page layout view
  • Page break preview
  • Headers and footers
  • Printing titles on all pages
  • Setting a print area
  • Print
  • Save as PDF
  • Saving to OneDrive
  • Opening a file in Excel Online
    Reset options
- +

Need your training approved? Get a quote

Need your training approved? Get a quote