Home >
Microsoft Office >
MS Excel Level 2: Intermediate
MS Excel Level 2: Intermediate
| Course Code: |
OFFEX2 |
| Duration: |
1 day |
| Prerequisites: |
Completion of our course MS Excel Level 1
or equivalent knowledge.
|
| Objectives: |
Upon completion of this presentation, the participant should
be able to use Excel to effectively create and manage data lists and summary data.
The participant should also be able to extract and display information
from a workbook(s) based upon certain criteria.
|
| Core Topics: |
Referencing Cells & Cell Ranges
- Absolute, relative & mixed referencing
- Named ranges
- Referencing values in other worksheets/workbooks
- 3-D referencing
- Circular referencing
Working With Large/Multiple Spreadsheets
- Freeze panes
- Split window
- Arrange windows
Consolidating Data
- Consolidating worksheets
- Consolidating workbooks
Lookup Functions
Working With Data Lists
- Sorting
- Subtotals
- Filtering
- Setting search criteria
Excel's Database Functions
Conditional Formatting
- Setting up conditional formats
- Using formulas in conditional formats
Advanced Chart Creation
- Create various chart types
- Modify a chart
- Add data to a chart
|
