The Introduction to Excel course is for beginners to Excel
and covers a wide variety of topics which demonstrate the
power and range of functionality that Excel possesses. It
covers all the basic functions that a user will need to understand
how spreadsheets work and the most useful things that can
be done in Excel. Time will be taken so that all users understand
before moving on (within reason). Examples will be realistic
so that they can referenced on return to work.
| Introduction to Excel |
| This section explains what Excel is and how it can be
used. You will learn about the Excel environment, the
Excel Toolbars and how to use the Excel Help facilities.
You will also be shown some "Cool Shortcuts"
to aid your productivity. |
| Workbooks and Worksheets |
| This section explains about Workbooks and Worksheets,
all you need to know about cells and references and how
to navigate around Excel. |
| Data |
| This section explains how to enter data and shows many
of the Excel "time-saving" features such as
Autocomplete and Pick Lists |
| Formatting Data |
| Excel has a very rich set of features for formatting
the data it contains. Learn how to format text and numbers
and how to apply custom formatting. |
| Editing Spreadsheets |
| Learn how to Cut, Copy and Paste. Learn how to Insert
and Delete. Learn how to Find and Replace. |
| Formulas and Functions |
| Excel's reputation is founded on the incredible power
of its Formulas and Functions. Learn how to properly enter
formulas and how to reference cells within formulas. Also
learn how to enter Functions. |
| Printing |
| Learn all about Page Setup, Margins and Header &
Footers. Learn how to Print Preview and actually print
the page. |