Chat with us, powered by LiveChat

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

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