Highlights
- Concatenation – combine data from multiple cells
- Upper Lower and Proper Functions
- Round Function
- TRIM Data Cleanse
- Insert Function Wizard with VLOOKUP
- Date functions
- MATCH Function
- Formula Auditing
This intermediate course builds on the Level 1 course, demonstrating a range of effective and time-saving formulas and techniques.
Learn how to confidently use functions that deal with text, data cleanse, lookups, dates, matching and tracing precedents and dependents.
Understand and work effectively with fundamental and versatile calculation and analysis techniques in Excel beyond introductory level.
This course will broaden and strengthen your understanding of Excel’s capabilities.
Gaining this knowledge is a fundamental and highly marketable skill set in Excel and is vital in a wide range of professions and fields including accounting, financial analysis, government and business administration.