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.75  (1118 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
Course prerequisites

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

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 formulae
  • 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 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
    Reset options
- +
Need your training approved? Get a quote
4.75
4.75
from 1118 reviews
5/5
“Great structure, just the right detail. Overall happy. Thank you Annie!”
Annika, May 2019
5/5
“Very knowledgeable instructor. Very enthusiastic and engaging.”
Oliver, May 2019
5/5
“Annie was lovely and very knowledgeable. ”
Kelly, May 2019
5/5
“The trainer Katherine was excellent and was able to teach additional knowledge based on questions of the class that was not covered in the structure.”
Joey, May 2019