Microsoft Excel - Basic

This one-day course is aimed at users who are new to Excel (Microsoft Excel 2003) and who want to set up their own basic spreadsheets and manipulate existing ones. The objective of the course is to develop a good working knowledge of Excel to include features such as basic functions and formulae, entering, sorting and filtering data, formatting and printing spreadsheets.

Course overview:

• Introduction and Overview - Accessing Excel and navigating the spreadsheet
• Parts of the Screen - Using and displaying toolbars and menus; task panes; smart tags and option buttons, zoom function
• Creating and Excel Spreadsheet - Best practices; entering information; saving, opening, closing and deleting workbooks; document properties and management
• Editing - Selection techniques; drag and drop; editing on spreadsheets or with formula bar; delete/clear options; cutting, copying and pasting text; paste options; clipboard; moving and copying text between workbooks; inserting and deleting columns, rows and cells; autofill
• Excel formulae - Entering and referencing formulae; calculations with formulae; editing formulae; ordering of operations; autofill with formulae
• Excel functions - Basic functions such as Sum, Average, Min, Max and Count; trace error options; relative and absolute cell addressing; naming cells
• Formatting the Spreadhseet - Number and font formatting; alignment; patterns, borders and shading; format painter
• Comments - Inserting, editing and deleting comments; printing options; view options
• Page set-up - Orientation; scaling; margins; headers and footers; gridlines
• Printing - Print preview; printing options; header and footer
• Using multiple sheets in a workbook - Naming sheets; moving, copying, inserting and deleting sheets; formulae across sheets
• Excel charts - Introduction to Excel chart facilities; constructing charts from spreadsheet data; changing the chart type; chart options; formatting charts
• Introduction to Excel databases - Setting up an Excel database; using the sort facility; using autofilter feature; custom filters
• Course Summary and Review