Microsoft Excel Computer Training

Level 1 – New User (1 day)

• what's new in your version?
• overview of Excel features and capabilities
• functional elements of the Excel screen
• obtaining help
• opening, closing, saving and searching for files
• entering and editing data, (including labels, values and formula)
• moving around the worksheet and selecting ranges
• using formula and functions, (including SUM, COUNT and TODAY)
• applying formatting to numeric data and text labels
• altering the worksheet appearance, (e.g. column widths and row heights)
• creating and editing charts
• introduction to printing

Level 2 – Regular User (1 day)

• working with named ranges and multiple worksheets
• when to use absolute, relative and mixed cell addressing
• using zoom, freeze titles and split screen to change the display
• hiding and protecting data, (including security considerations)
• creating custom formats, (including conditional formatting)
• creating hierarchical data structures with Outlines
• creating and saving custom charts, (including 'pictograms' )
• adding header and footer information to printed copies
• setting up and using Custom Views to control what is seen or printed
• overview of list handling in Excel, (including sorting and use of AutoFilters)
• working with Pivot Tables

Level 3 – Advanced User (1 day)

• review of good spreadsheet design concepts and techniques
• applying formula to textural data, (e.g. convert to uppercase)
• using logical functions and nested IF's to carry out complex tests
• using SUMIF and COUNTIF to selectively sum and count
• using dates within formula, (e.g. to calculate due date on an invoice)
• using data validation to control user input, (including drop-down lists)
• creating What-if? tables, (e.g. to compare loan repayments from 2 lenders)
• using statistical formula, (including frequency distributions and SD)
• using Lookup functions to find data values in a table
• using Scenarios to store multiple sets of figures and analyse outcomes
• working with Goal Seek and Solver to find solutions and optimise outcomes
• customising the Toolbars
• creating a keystroke macro and assigning to a button