Level 1 | Using control box
Using menu bar
Using restore button
Using tool bars
Using help button
Using tip wizard
Explaining formula bar
Explaining work area
Using scroll bars
Explaining sheet tabs
Status bars
Enter information
Naming spread sheet
Simple spreadsheet
Changing column size
Moving cells
Using cut button
Using paste button
Moving shortcut
Copy button
Auto fill
Tab key and arrow keys
Entering formulas
Auto sum
Formula manually | Formatting information
Setting fonts
Changing size of letters
Using underline button
Inserting row
Format dialog box
Moving dialog boxes
Choosing colors
Format painter
Style dialog box
Sorting information
Undo button
Form dialog box to edit
Charting information
Chart wizard
Selecting chart type
Insert function
Sheet tabs
Naming sheets
Deleting sheets
Print preview
Page set to change print
Short cut to margins
Naming spreadsheet
Custom auto fill list
Semi formula to move information to new sheet
|
Level 2 | Introduction
Template sheet
Auto sum button
Copy shortcut (ctrl + c )
Paste shortcut (ctrl) + v )
Freeze planes
Un freeze planes
Data group and outline
Data create outline
Shortcut-repeat
Un group
Un group shortcut
Ways to save
Save as template
Subtotals and outline
Create pivot table
Create pivot table from external source
Setting up pivot table
Choosing stating cell
Pivot table
Pivot table tool bar
Using save as options
| Saving properties
Creating forms
View-select toolbars
Tool bar short cut
Create own toolbar
Form toolbar icons
Toolbar to create forms
Formatting objects
Inserting formulas-option boxes
Creating group box
Choose formulas
Creating list box
Setting absolute values
Creating macros
Using macros
Name and array
Name a range
Setting arrays
Order of operations-formulas
Advanced charting
Using chart wizard
Changing chart layout
|
Level 3 | Introduction
The function formula
Setting up criteria range
Copying information to the clipboard
Changing the parameters of your formula
Using the function wizard
| The date and time function
Custom formatting cells
The editing function 1 of 1
Embedding a function
Using the financial function
Auditing techniques
Saving the workspace |
