Python for Data Analysis

This course covers the basics of financial accounting, finance, and three main valuation methods, Discounted Cash Flow, Comparable Companies, and Precedent Transactions, all using Excel. You’ll learn theoretical concepts followed by practical exercises, including case studies that simulate real work scenarios. These exercises range from forecasting financial statements to creating full valuation models.

This course covers essential Excel formulas, charts and shortcuts for business and finance roles. Starting with basics you'll advance to creating professional spreadsheets like financial models, dynamic pivot tables and interactive dashboards. The modules combine theory with practical exercises and case studies simulating real-world tasks for professionals.

This course teaches you to create and analyse income statements, balance sheets, and cash flow statements from scratch. You will learn key financial ratios and metrics through theory and real-world exercises using the financial statements of companies, preparing you for careers in accounting, investment banking, and financial planning.

This LBO Modelling & Private Equity Course covers the theory of LBOs, including deal structures and returns analysis. You'll practice Paper LBO exercises for interview preparation and work through a comprehensive LBO case study. The course also involves analysing real LBO deals to understand their complexities and provides further modelling exercises to enhance your skills, preparing you for roles in private equity and investment banking.

This course covers the fundamentals of how M&A creates value and key metrics used to assess it. Participants will simulate real investment banking scenarios, going through steps like the offer letter, SPA, and virtual data room. The course includes building a comprehensive merger model, covering sources & uses, pro forma financial statements, and accretion dilution analysis. Advanced techniques are applied in an extensive model for a Disney & Apple merger, including credit statistics, sensitivity analysis, and contribution analysis. Overall, the course aims to enhance practical skills in M&A modelling and financial analysis.

This course will teach you to transform raw business data into dynamic Power BI dashboards. Starting with the basics, you'll progress to advanced topics like Power Query transformations, data pivots, merging queries, DAX measures, and calculated columns. Practical exercises, including built-from-scratch reports and dashboards, will help you visualize meaningful insights from complex data.

This course equips you with essential PowerPoint skills, from basics to advanced features, for creating professional presentations. You'll learn to design effective slide decks, including stock pitch and management consulting presentations, using visuals and design principles to enhance clarity. The course also covers efficiency-boosting shortcuts and includes practical case studies to simulate real-world business scenarios, preparing you for roles as a professional in the business and finance sectors.

This SQL for Business Analytics course equips learners with essential SQL skills to extract, transform, and analyse data stored in databases. Starting with basic SQL concepts and database creation, it progresses to advanced query writing, data manipulation, and analysis techniques. Participants will master writing efficient queries, optimizing performance, and applying SQL in real-world business scenarios to unlock valuable insights. By the end, learners will be proficient in using SQL for effective database management and business analytics.

This beginner-friendly course teaches you how to create custom procedures that transform 3-hour tasks into one-click solutions. Starting with fundamental coding principles, it progresses to advanced topics like code loops, data arrays, and user input boxes. Real-life exercises and case studies, including tutorials on a billing summary file and a P&L creation tool, help you auto-generate pivot tables, streamline chart creation, and extract and summarize data efficiently.