Microsoft Excel Refresher

Suitable for:

Objectives:

Anyone needing to learn how to use Excel or those familiar with other spreadsheet programmes new to Microsoft Excel

To be able to open, save, send and locate Excel workbooks. Format, edit and align text in cells. Use basic formulae and recognise the importance of the order of operations. Understand and use relative and absolute references appropriately. To be able to import and export data from Excel into other applications (such as Word, and Access). Create and modify charts.

Course Content:

• Navigating, the layout of newer versions of Microsoft Excel

• Backstage View: saving, printing and sharing

• Customise Quick Access Toolbar

• Accessing and using Help

• Zoom and Document Views

• Customise Status bar

• Tabs, On-demand tabs, and Launch buttons

• Entering text and numbers

• Faster data entry with Autofill

• Data Validation

• Formatting text and numbers

• Creating basic formulae

• Autosum

• Absolute and relative references

• Previewing and printing a workbook

• Importing and exporting data

• Introduction to charts

This is a sample course outline. We tailor every one of our workshops to suit your company's individual needs.