| |
Working With Worksheets
|
|
Calendar Functions |
|
Date formatting |
|
Using Dates in Formula |
|
Custom Lists |
|
Freeze Panes |
|
Adding Comments To A Worksheet |
|
Cell & Document Protection |
|
Working With Document Windows |
| |
Logical Functions
|
|
What Is An If Statement ? |
|
Multiple nested If Statements |
|
Or Statements |
|
Using Named Ranges |
|
The VLookup Function |
| |
Worksheet Management
|
|
Creating and using Named ranges |
|
Searching For Files |
|
Using Find & Replace |
|
The Go To Command |
|
Outlining A Worksheet |
| |
Printing Large Worksheets
|
|
Page Breaks |
|
Page Break Preview |
|
Custom Headers & Footers |
|
Custom Views |