Microsoft Excel Introduction Course

Free up your time and learn Excel well with our one day course providing a new user or user with basic experience of Microsoft Excel, the confidence to use a wide range of features.

Understand and write formula, build common functions, apply formatting, sorting, filtering and generate charts in Excel spreadsheets. You will also learn valuable shortcuts enabling you to work efficiently.

Prerequisite: 

• Delegates wishing to attend our Microsoft Excel Introduction training course should be comfortable with using a computer.

Microsoft Excel Introduction training course outline

Basics and Formatting

• Tour the Microsoft Excel Environment

• Customise the Quick Access Tool bar

• Enter and edit data

• Adjust Column widths

• Move and copy data

• Use Auto Fill

• Format a worksheet

• Copy and clear formatting

• Prepare a worksheet for printing

• Save a worksheet as a PDF

• Learn keyboard shortcuts

Formulas and Functions

• Understand and write Formula

• Learn the construction of a Function

• Use the SUM function

• Use Auto Fill to copy a formula

Further Functions and Calculations

• Use Functions AVERAGE, MIN, MAX and COUNT

• Calculate percentages

• Learn how to use relative and absolute cell referencing

Work with Data Lists

• Use Freeze Panes

• Sort data

• Filter Information

Charts and Graphs

• Create bar, column, line and pie charts

• Explore and change chart properties