Home >
Microsoft Office >
MS Excel Level 3: Advanced
MS Excel Level 3: Advanced
| Course Code: |
OFFEX3 |
| Duration: |
1 day |
| Prerequisites: |
Completion of our course MS Excel Level 2
or equivalent knowledge.
|
| Objectives: |
Upon completion of this presentation, the participant should
be able to use advanced formulas and functions to customise spreadsheets
and create templates. Additionally, the delegate should be aware of security
implications when sharing workbooks with other users.
|
| Core Topics: |
Advanced Formulas & Functions
- IF and related functions
- Nested functions/formulas
- Array formulas
- Date arithmetic
- Financial functions
- Locating and interpreting errors
Analysing Data
- Create a PivotTable
- Create a PivotChart
- Create Scenarios
- Use Goal Seek
Macros
- Record and run a macro
- Relative vs. absolute recording
- Edit a macro
- Macro security
Customising Excel
- Creating templates
- Customising toolbars/menus
- Create custom keyboard shortcuts
- Create custom views
Protecting Workbooks/Worksheets
- Lock cells
- Hide formulas, rows, columns
- Password protect worksheet/workbook
- Share workbook options
|
