Financial Modelling in MS Excel
Master Excel for financial reporting & modeling. Automate tasks, save time, and gain insights. Perfect for finance professionals!
Course Content
Financial Modelling in MS Excel is an all-levels Udemy course taught by Syed M Ali Shah. It runs 15h 58m, is taught in English, and includes a certificate of completion. Learners rate it 4.5 out of 5 from 103 reviews, with 468 students enrolled. It is a paid course, last updated August 2024.
Financial Modeling Training: Master Excel for Accounting & Finance
Unlock your career potential with our comprehensive financial modeling training. This in-demand skill is highly valued by employers in the accounting and finance sectors. Our sixteen-hour course provides a practical, hands-on approach, taking you from foundational Excel skills to professional-level proficiency.
What You'll Learn:
- Excel Mastery (40% of Course): Deepen your MS Excel skills with practical exercises.
- Financial Application (60% of Course): Apply MS Excel to real-world accounting and finance scenarios.
Detailed Course Content:
- Excel Fundamentals: A solid foundation in Microsoft Excel.
- Excel Productivity: Discover useful tips and tools to enhance your workflow.
- Keyboard Shortcuts: Boost your efficiency with essential Excel keyboard shortcuts.
- Key Excel Functions: Master Excel's key functions and functionalities for data manipulation.
- SUMIFS Update: Learn the latest on SUMIFS for advanced data analysis.
- Financial Functions: Utilize powerful financial functions in Excel for accurate calculations.
- Pivot Tables: Extract insights with Microsoft Excel's Pivot Tables.
- Profit & Loss (P&L) Modeling: Build a complete P&L in Excel – a practical case study.
- Excel Charts: Visualize data effectively with introduction to Excel charts.
- Profit and Loss Case Study: Apply your skills with a detailed Profit and Loss case study.
- Statement of Financial Position (Balance Sheet): Learn to create a Statement of Financial Position with a case study.
- Statement of Cash Flows: Understand and model Statement of Cash Flows through practical examples.
- Financial Modeling Fundamentals: Grasp the core principles of financial modeling.
- Company Valuation & M&A: Introduction to Company Valuation and Mergers & Acquisitions (M&A).
- Discounted Cash Flow (DCF) Modeling: Build a Discounted Cash Flow model in Excel – including NPV and IRR calculations.
- Investment Appraisal: Apply investment appraisal techniques through a case study.
- Business Valuation Case Study: Develop business valuation skills with a practical case.
- Capital Budgeting Theory: Understand the theory of capital budgeting.
- Capital Budgeting Case Study: Apply capital budgeting principles in a real-world scenario.
- Interest & Exchange Rate Impact: Analyze the impact of interest rates and exchange rates on NPV.
- Sensitivity Analysis: Implement sensitivity analysis in capital budgeting for robust decision-making.
Who Should Attend?
- Basic MS Excel knowledge (1+ year user experience recommended).
- Fundamental understanding of financial accounting.
- Microsoft Office 2013 or later installed.
About the Instructor:
Our instructor is a highly qualified accounting and finance professional with over 20 years of experience across diverse industries, including auditing, manufacturing, and oil & gas. Having progressed from finance executive to CFO of a multinational oil & gas company, they bring practical, real-world insights. Experience as a consultant with the World Bank and European Union on IFRS and financial management projects in the Middle East, Eastern Europe, and CIS countries (2011-2018) further enhances their expertise. Holding MBA, ACCA, and CIMA UK qualifications, they have over 15 years of experience teaching IFRS, Financial Reporting, Financial Management, and Performance Management, with a focus on ACCA and CIMA qualifications.
Hire the developers behind TutorialSearch.io
We built this site — full-stack web apps, AI integration & automation. Tell us what you need and we'll build yours.