Udemyallen

Financial Modelling in MS Excel

Master Excel for financial reporting & modeling. Automate tasks, save time, and gain insights. Perfect for finance professionals!

4.5(103)
468students
15h 58m
Certificate
Syed M Ali Shah
Syed M Ali ShahAn Accounting and Finance Professional And Seasoned Trainer

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:

  1. Excel Fundamentals: A solid foundation in Microsoft Excel.
  2. Excel Productivity: Discover useful tips and tools to enhance your workflow.
  3. Keyboard Shortcuts: Boost your efficiency with essential Excel keyboard shortcuts.
  4. Key Excel Functions: Master Excel's key functions and functionalities for data manipulation.
  5. SUMIFS Update: Learn the latest on SUMIFS for advanced data analysis.
  6. Financial Functions: Utilize powerful financial functions in Excel for accurate calculations.
  7. Pivot Tables: Extract insights with Microsoft Excel's Pivot Tables.
  8. Profit & Loss (P&L) Modeling: Build a complete P&L in Excel – a practical case study.
  9. Excel Charts: Visualize data effectively with introduction to Excel charts.
  10. Profit and Loss Case Study: Apply your skills with a detailed Profit and Loss case study.
  11. Statement of Financial Position (Balance Sheet): Learn to create a Statement of Financial Position with a case study.
  12. Statement of Cash Flows: Understand and model Statement of Cash Flows through practical examples.
  13. Financial Modeling Fundamentals: Grasp the core principles of financial modeling.
  14. Company Valuation & M&A: Introduction to Company Valuation and Mergers & Acquisitions (M&A).
  15. Discounted Cash Flow (DCF) Modeling: Build a Discounted Cash Flow model in Excel – including NPV and IRR calculations.
  16. Investment Appraisal: Apply investment appraisal techniques through a case study.
  17. Business Valuation Case Study: Develop business valuation skills with a practical case.
  18. Capital Budgeting Theory: Understand the theory of capital budgeting.
  19. Capital Budgeting Case Study: Apply capital budgeting principles in a real-world scenario.
  20. Interest & Exchange Rate Impact: Analyze the impact of interest rates and exchange rates on NPV.
  21. 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.

$ whoami — the devs behind tutorialsearch.io

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.