 | |
Microsoft™
Excel
Level 2
Prerequisites:
Excel 1 or Equivalent
Customizing the Worksheet and Defaults
 |
The Xlstart Directory and Default Setup |
|
Creating and Customizing Toolbars |
Creating and Using Templates
Advanced Formulas
|
Advanced Financial and Statistical Functions |
|
The Table Lookup Functions |
Conditional Logic
|
The If Conditional Logic in Formulas |
|
And/Or Logic in Formulas |
AutoFormats, AutoCalculate, AutoComplete
Fundamentals of Database Functions
|
Sorting Data and Subtotals |
|
Creating and Deleting Multiple Worksheets |
|
Filters and AutoFilter |
Elementary Charts
|
Embedded Charts |
|
Chart Sheets |
Working With Multiple Worksheets
| Creating and Deleting Multiple Worksheets
|
| Writing Formulas Across Multiple Worksheets
|
Working With Multiple Worksheets Files
| Copying and Pasting Data From Other Worksheet Files
|
| Linking Multiple Worksheet Files (OLE)
|
Importing Files From Other Applications
| Importing From DOS or Other Systems
|
| Copying & Linking From Other Windows Applications
|
Exploring Elementary Macros
| Recording and Editing, MACROS
|
| Running MACROS
|
| Creating MACRO Execution Buttons
|
Importing
Files From Other Applications
| Importing From DOS or
Other Systems |
| Copying &
Linking From Other Windows Applications |
 
You can print this page with your web browser |
