Advance Excel (Intermediate)

Course Description

Specialized Excel training for accounting professionals and financial analysis.

What you'll learn in this course?

Advanced Excel functions, formulas, pivot tables, and automation for accounting tasks.

What You'll Learn

• Perform calculations using Time and Date functions
• Lookup information using HLOOKUP and VLOOKUP
• Perform more complex lookups using INDEX and MATCH
• Make decisions with IF Statements
• Incorporate logical operators into formulas
• Advanced Formulae
• Create Pivot Tables and Pivot Charts
• Analyse large datasets using Power Pivot
• VBA/Auditing VBA
• Automate common tasks using Macro