Course
topic and minutes expected to teach each topic
Check to include
Total Minutes
The
Ribbon (tabs, groups and commands) (5)
The
Quick Access toolbar (5)
Persistent
undo and redo (5)
Access
Keys (2)
Super
Tooltips (5)
The
Zoom Slider (1)
Live
Previews (5)
SmartArt
& Word Art (5)
Saving
and Compatibility mode (10)
Contextual
tabs (5)
Quick
Styles and Themes (10)
Dialog
Box Launchers (1)
The
Minimize Toolbar (1)
Starting
New Workbooks (1)
File
Management (5)
Entering
Text, Numbers, Dates (15)
Editing
and Deleting cells (10)
Selection
Techniques (10)
Moving
and Copying data (10)
Inserting
New Columns and Rows (10)
Formatting
Spreadsheets (60)
Printing
and Previewing spreadsheets (60)
Creating
a Formula using +, -, × and ÷ (20)
Copying
a Formula (10)
Relative
and Absolute ($) Reference (20)
Using
Autosum (10)
Functions:
Average, Min, Max, Count (10)
Using
Logical Functions (IF, AND, OR) (60)
Using
Nested Functions (Function within another) (15)
Lookup
and Reference Functions, e.g. Vlookup, Index, etc (60)
Date
& Time Functions eg NETWORKDAYS (15)
Text
Functions eg LEFT, MID, RIGHT, TRIM, etc (45)
Using
Charts (60)
Insert,
Deleting and Moving Worksheets (5)
Recolour,
Hide, Move or Copy Worksheets (5)
Linking
sheets in the same file (15)
Linking
different Excel files (20)
Using
Data Consolidation (20)
Viewing
Different Files at once (5)
Saving
a Workspace (5)
Sorting
Data (10)
Adding
Subtotals on a list (10)
Using
Autofilter (15)
Using
Advanced Filter (15)
Database
Functions: Dsum, Dmin, Dmax (15)
Outline
and Group Spreadheets (10)
Pivot
Tables (90)
Pivot
Chart (10)
Setting
up Scenarios (15)
Uing
Goal Seek and Solver (15)
Creating
and using Custom Views (10)
Sharing
a File (10)
Tracking
changes (10)
Protecting
Cells, Sheets, Files (20)
Formula
Auditing Spreadsheets (20)
Customizing
Toolbars (10)
Importing
/ Exporting Text files (10)
Spreadsheet
Form Controls (Combo, Radio Buttons, etc) (30)
Recording
and Running Macros (90)
Using
the Visual Basic Editor (15)
Essential
Language Elements (30)
Obejcts,
Properties, Methods, Object Hierarchy (90)
Using
Variables and Constants (30)
Creating
Functions (45)
Control
Structures (If, ElseIf, Select Case) (45)
Interactive
Code (Message and Inputbox) (45)
Using
Looping structures (90)
Error
Handling (15)
Creating
Userforms (90)
Creating
Custom Menus and Toolbars (10)
Using
Event Procedures (90)
Using
Event Procedures (5)
Macro
Distribution (Addins) (10)
Please
provide information on any other topics you would like to include