Business, Education
Complete Finance & Valuation Course
Career Principles
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.
Online Course
Business, Education
Financial Accounting Essentials
Career Principles
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.
Online Course
Business, Education
Leverage Buyout (LBO) Modelling & Private Equity
Career Principles
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.
Online Course
Business, Education
Mergers & Acquisitions (M&A) Modelling Course
Career Principles
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.
Online Course
Business, Education
Power BI for Business Analytics
Career Principles
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.
Online Course
Business, Education
PowerPoint for Business & Finance
Career Principles
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.
Online Course
Business, Education
Python for Data Analysis
Career Principles
This beginner's Python for Data Analysis course teaches you Python fundamentals with a focus on data manipulation and visualization. You'll work with Pandas for data analysis and use Seaborn and Matplotlib for creating impactful visuals. The course includes three projects, analysing stock prices, exploring Los Angeles crime patterns, and building a machine learning model to predict housing prices. By the end, you'll be able to clean data, conduct analysis, and present insights effectively, preparing you for roles in data analytics and business intelligence.
Online Course
Business, Education
Structured Query Language (SQL) for Business Analytics
Career Principles
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.
Online Course
Business, Education
VBA & Macros for Business Automation
Career Principles
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.
Online Course