Udemyallen

Financial Modelling in MS Excel

Master financial modeling in Excel! Learn from beginner to advanced techniques. Build powerful models for forecasting, analysis & decision-making.

4.4(45)
158students
13h 44m
Certificate
Syed Muhammad Ali Shah
Syed Muhammad Ali ShahTeaching Accounting and Finance for Over Fifteen Years

Course Content

Financial Modelling in MS Excel is an all-levels Udemy course taught by Syed Muhammad Ali Shah. It runs 13h 44m, is taught in English, and includes a certificate of completion. Learners rate it 4.4 out of 5 from 45 reviews, with 158 students enrolled. It is a paid course, last updated February 2021.

Financial Modeling Training: Master Excel for Accounting & Finance

Boost your career with our comprehensive financial modeling training! This in-demand sixteen-hour course equips accounting and finance professionals with the essential skills employers are seeking. Go from beginner to professional, building a strong foundation in practical application.

What You Will Learn:

  • Advanced Excel Skills: Unlock the power of Excel's advanced features for efficient financial analysis.
  • Team Proficiency: Become a confident and proficient Excel user, enhancing collaboration within your team.
  • Time-Saving Techniques: Streamline your regular tasks and complete them faster with Excel shortcuts and functions.
  • Financial Statement Mastery: Learn to build robust Profit and Loss (P&L), Statement of Financial Position (Balance Sheet), and Cash Flow statements.
  • Valuation Modeling: Develop the ability to build valuation models from scratch, gaining a deep understanding of company worth.
  • Net Present Value (NPV) Modeling: Master the NPV model, a crucial tool for investment decisions.
  • Professional Data Visualization: Create clear, professional-looking charts and graphs to effectively communicate financial insights.

Detailed Course Content:

  • Excel Fundamentals: Introduction to Microsoft Excel and essential features.
  • Excel Productivity: Discover useful tips, tools, and keyboard shortcuts to maximize efficiency.
  • Core Excel Functions: Master key functions and functionalities for accurate calculations.
  • Data Analysis with SUMIFS: Learn and apply the powerful SUMIFS function for advanced data aggregation.
  • Financial Functions: Utilize specialized financial functions within Excel.
  • Pivot Tables: Extract and analyze data effectively using Excel's Pivot Tables.
  • P&L Case Study: A practical exercise in building a complete Profit and Loss statement in Excel, complete with professional charts.
  • Excel Charts: Introduction to creating effective and visually appealing charts.
  • Financial Modeling Fundamentals: A deep dive into the principles of financial modeling.
  • Company Valuation & M&A: Introduction to company valuation techniques and Mergers & Acquisitions.
  • Discounted Cash Flow (DCF) Modeling: Learn to build a Discounted Cash Flow model in Excel.
  • Business Valuation Exercise: A comprehensive practical exercise in business valuation.
  • Capital Budgeting Theory: Understand the core concepts of capital budgeting.
  • Capital Budgeting Case Study: Apply capital budgeting principles through a complete case study.
  • Interest & Exchange Rate Impact: Analyze the impact of interest rates and exchange rates on NPV.
  • Sensitivity Analysis: Implement sensitivity analysis in capital budgeting to assess risk.

Prerequisites:

  • Basic understanding of Microsoft Excel (over 1 year of experience recommended).
  • Fundamental knowledge of financial accounting principles.
  • Microsoft Office 2013 or later installed on your computer.

About the Instructor:

Our instructor is a highly qualified accounting and finance professional with over twenty 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 real-world expertise to the classroom. They have also consulted with the World Bank and European Union on IFRS and financial management projects in the Middle East, Eastern Europe, and CIS countries. Holding MBA, ACCA, and CIMA UK qualifications, they have over fifteen 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.