Microsoft Excel Refresher

Suitable for:

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

Objectives:

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.