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
4.76  (1184 reviews)
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:
Workbook
Refreshments
Capped class size
eCertificate
Post Course Support
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
Post Course Support
Course prerequisites

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

In-Person Training

Participants are not required to bring their own laptops as our dedicated computer training labs are equipped with the programs and files you will need access to on your training day.

Online Training

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.
What's covered?
  • 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
4.76
4.76
from 1184 reviews
5/5
“Really great - covered the basics in a clear, concise way & not confusing!”
Katie, Jan 2021
5/5
“Annie was an excellent instructor. I thoroughly enjoyed the course.”
Mark, Jan 2021
5/5
“I really enjoyed the session and liked how it wasn’t just reading out the textbook.”
Natalie, Jan 2021
5/5
“Really great - covered the basics in a clear, concise way & not confusing!”
Katie, Jan 2021