DAY 1

Module 1: Main Excel objects

• What are worksheets & workbooks?
• Columns, row, cells & ranges
• Navigating, important shortcut keys
• The Backstage
• The Ribbon

Module 2: Worksheets & workbooks

• Creating a worksheet
• Creating a workbook
• Save & save as

Module 3: Formulas

• What are excel formulas
• The formula bar
• Common mathematical operators
• The order of operations

Module 4: Insert functions

• The Excel function
• The function library
• Important excel functions

DAY 2

Module 5: Formula references

• Absolute & relative references
• References when copying formulas in an array

Module 6: Important Excel functions

• IF, VLOOKUP, SUMIF, COUNT

Module 7: Important excel aspects

• Undo & redo
• Autofill feature
• Autofill options
• Dragging & dropping cells
• Cut, copy, & paste cells
• How to cut, copy, & paste multiple cells
• Using the clipboard
• Paste special
• The transpose option
• Live preview
• The Clear button
• Excel spell checking

Module 8: Rows & columns

• Inserting & deleting
• Important shortcut keys
• Adjusting width of rows & columns
• Hiding & unhiding rows & columns

Module 9: Finding & replacing data

• The Find command
• The Replace command
• The Go to command

Module 10: Excel fonts

• Fonts & font type
• The font group
• The format cells dialog box
• The format painter
• Live preview & formatting
• The mini toolbar

Module 11: Drawing borders & colouring cells

• Border options
• Fill options
• Sheet backgrounds

Module 12: Apply number formats

• Number formats
• Excel number formats
• Customizing number formats

Module 13: Cell alignment & cell styles

• Alignment options
• The indent command
• Orientation options
• The merge & centre options
• Cell styles
• The style dialog box

Module 14: Printing excel worksheets

• Print options in backstage view
• Page setup dialog box
• Print preview options
• Inserting headers & footers
• Header & footer settings
• Page margins
• Margins tab options
• Setting page orientation

Module 15: Page layout & other print options

• Zoom options
• Page breaks
• Page break options
• Setting the print area
• Print titles
• Scaling options

Module 16: Worksheet tabs

• Renaming worksheet tabs
• Changing tab colour
• Hiding & unhiding worksheets
• Deleting worksheets
• Copying tabs
• Moving tabs

Module 17: Worksheet views

• Split command
• Freeze panes options
• Arrange all command
• Arrange windows dialog box
• View side by side command
• Switch windows command
• New window command

Module 18: Formula Auditing

• Tracking Dependents and Precedents
• Showing formulas
• Error checking and tracing errors

Module 19: Sorting & Filtering

• Working with lists
• Applying Sorting and Filtering to a list
• Simple sorting
• Sorting by multiple columns
• Using AutoFilter
• Using custom filter
• Using Advanced Filter
• Removing duplicates from data

Module 20: Data Tools

• Text to Columns
• Flash Fill
• Remove Duplicates
• Data Validation
• Consolidate

Module 21: Introduction to Excel charts

• Types of Excel charts
• Data ranges and selecting data
• The bar graph
• The pie chart
• Advanced chart formatting

• Clerks
• Operations personnel
• Security personnel
• Customer officers
• Front and backend staff who already have some foundation in Excel.