Microsoft Excel

Learn how to get the most out of Microsoft Excel with one of our short virtual instructor led classes delivered remotely or book an Excel trainer to visit your site. Our expert instructors deliver courses in Excel spreadsheets to all levels providing hands on, interactive training. 

All Excel training courses can be tailored to your needs and delivered in bite sized chunks so that you have the flexibility to fit training into your busy schedule.

Corporate Excel Training Courses Onsite and Virtual

Our beginners level training in Excel Spreadsheets is aimed at users who may be self taught with a basic knowledge of spreadsheets. Users with limited Excel skills who have little or no experience of Excel formulae and functions should attend this course prior to enrolling on the intermediate level.  Customers may request an intermediate level Excel course which can be customised to include a revision section covering formulae and functions.

Course overview

Our introductory level Excel course is ideal for beginners who want to learn the essentials including how to produce formatted spreadsheets and perform calculations.

Course prerequisites

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

What you will learn

• Create, modify and format a spreadsheet

• Use basic formulas and functions

• Customise the print settings and print

Excel Course Topics

Overview

• Keyboard and mouse shortcuts

• Entering data into your spreadsheet

• Data entry ranges

• Formatting the worksheet

  • Number and date formats

  • Fonts, colours, borders, sizes

  • Adjust column widths

  • Indenting

  • Centre aligning

  • Merging and centring

  • Text Wrap

  • Format Painter

Formulas

• The Sum function

• AutoSum

• AutoFill a formula

• Basic formulas

• BODMAS (working with brackets)

• Editing formulae

• An introduction to relative and absolute references

• Functions

  • The AVERAGE function

  • The MAX function

  • The MIN function

  • The COUNT function

Working with columns and rows

• Inserting columns/rows

• Deleting columns/rows

• Hiding columns/rows

• AutoFill

• Printing and page setup

  • Print preview

  • Margins, orientation, scaling

  • Page layout

  • Page break preview

  • Headers and footers

  • Repeating Print titles on all pages

  • Setting a print area

  • Print

  • Save as PDF