Course description
Our intensive Excel for Financial Professionals Certificate eLearning course offers a hands-on experience throughout, where you'll learn how to utilize MS Excel to solve various financial and organizational challenges and tasks. Instead of treating MS Excel as a basic calculator, we teach you how to unleash its full potential as a powerful tool and maximize its extensive functionality, This course is perfect for individuals seeking to improve their proficiency in MS Excel, especially those who need to mine and analyze data, efficiently handle large volumes of information, and create spreadsheets for stress-testing and simulating data outputs.
Syllabus
- Excel Basics
- Core Functions
- Advanced Functions
- Output Analysis
Outcome / Qualification etc.
Online Assessment
When you're ready, you will take an online assessment to test your level of understanding.
- 4 modules and 17 concepts
- Each concept includes 10 knowledge check questions
Training Course Content
The Excel for Financial Professionals Certificate delves into MS Excel essentials and core functions, and will help you master advanced techniques and understand output analysis.
Excel Basics
- Navigation – get quicker, faster
- Efficient presentation protocols
- Efficient referencing methods
- Formula auditing
Core Functions
- Logical statements
- Summary functions – data management and analysis
- Financial functions
- Data cleansing – text functions
- Modeling hacks
Advanced Functions
- Lookup functions
- Array functions
- Advanced lookups
Output Analysis
- Drop-down lists
- Charting
- Scenarios
- Sensitivity analysis
- Pivot tables and pivot charts
Why choose Fitch Learning
9 in 10 would recommend us to a colleague
Over 1,300 clients worldwide
CPD recognized