Microsoft Excel Advanced Level 2 – 3hr
½ Day [3hrs] Hands On Training Course
Designed for experienced users of Excel this session jumps straight into more advanced tools in Excel such as creating templates, protecting sheets and cells and templates and macros to automate common tasks.
Requirements
This session is best run hands on with participants utilising a computer
What You Will Cover:
- Nesting Functions using IF and AND/OR
- SUMIF/S
- ISERROR
- Working with Text functions
- Concatenate
- Proper
- Text to Columns
- Paste Values
- Advanced Filtering
- Data Base Functions – DSUM, DAVERAGE
- Scenario Manager
- Goal Seek
Download this outline as a PDF.