This intensive 3-day course is designed to introduce finance professionals and non-financial users to the core functions and formulas of Microsoft Excel, with a specific focus on financial applications. Through hands-on exercises, real-world datasets, and financial scenarios, participants will gain practical skills to perform data analysis, automate calculations, and build financial models using Excel’s built-in tools..
Course Content
• Understand the Excel interface and best practices for working with data.
• Learn core formulas and functions essential for finance.
• Perform calculations commonly used in budgeting and financial forecasting.
• Learn to organize and analyze financial data using logical and lookup functions.
• Learn to present financial data clearly using charts and dashboards.
• Use Excel tools to model simple financial scenarios