Master Excel offers practical and highly personalized courses for anyone who wants to land a career in Banking or Consulting.
We understand that different people have different ways of learning; all our courses are tailored to your learning needs.
We aim to provide you with the highest quality training content and networking opportunities, giving you the best chance of successfully landing your dream job.
Microsoft Excel Courses
All Industries
Our interactive course provides the necessary skillsets to navigate and solve business problems through Microsoft Excel.
- Beginner Excel Course
- Intermediate Excel Course
- Expert Excel Course
Financial Modelling Courses
Investment Banking
Are you aiming for a career in Investment Banking, Corporate Finance, or M&A? Our Course will provide you with the essential skillset to succeed in these fields
- 3 Statement Modelling
- DCF valuation modelling
- Leverage Buyout Modelling
- Comparable valuation
Consulting Courses
Consulting
Are you curious on how to implement a software solution? Join us for a hands-on lesson!
- Introduction to Consulting
- Define Project Plan
- Writing Business Requirements
- Defining Test Cases
- Change Management
Career Insights
Investment Banking. Consulting
Are your interviews coming up but somehow you do not feel confident? Fret not, we are here to help!
- Resume Review
- Mock Interview
- Salary Negotiation
- Mentoring
Excel Courses
1-on-1 and group personalised courses available based on your current excel level
Beginner Excel Course
Course Overview
This course introduces Excel to beginners, covering its interface, basic features, and foundational skills. It is designed to help you navigate Excel confidently, perform basic calculations, and format data effectively.Course Objective
By the end of this course, participants will be able to:Understand the Excel interface and key functionalities.
Perform basic calculations and formatting.
Create a simple inventory list with input and output sheets.
Course Duration
8 hours (1 full day or split into 2 half-day sessions).Pre-requisite
Basic computer literacy (e.g., navigating files, typing).
Familiarity with Microsoft Office tools is a plus but not required.
Course Outline
Module 1:Â Introduction to Excel (Interface, Tabs, Sheets, Cells)
Module 2:Â Common Use Cases (Personal and Business Applications)
Module 3:Â Basic Functions & Formulas (SUM, ABS, etc.)
Module 4:Â Basic Data Formatting (Text, Numbers, Borders, Colors)
Module 5:Â Worksheet Modifications (Insert/Delete Rows, Find/Replace)
Module 6:Â Final Exercise (Inventory List Creation)
Intermediate Excel Course
Course Overview
This course dives deeper into Excel, focusing on intermediate functionalities like advanced formulas, chart creation, and data analysis techniques. It’s ideal for users who want to enhance productivity and manage data effectively.Course Objective
By the end of this course, participants will:Master intermediate-level formulas and functions.
Create and format advanced charts and graphs.
Manage and analyze large datasets efficiently.
Course Duration
10 hours (2 full days or 5 two-hour sessions).Pre-requisite
Completion of the Beginner Excel course or equivalent skills.
Ability to navigate and perform basic functions in Excel.
Course Outline
Module 1:Â Advanced Functions & Formulas (SUMIFS, VLOOKUP, INDEX-MATCH).
Module 2:Â Advanced Sorting & Filtering (Custom Sort, Filters by Color).
Module 3:Â Advanced Formatting (Grouping, Conditional Formatting).
Module 4:Â Charts and Graphs (Types, Best Practices).
Module 5:Â Dealing with Data Sets (Error Checking, Precedents/Dependents).
Module 6:Â Print Formatting (Page Setup, Headers/Footers).
Advanced Excel Course
- Course Overview
This course equips participants with advanced Excel skills for professional use, focusing on automation, complex data analysis, and error-free workflows. It is perfect for users looking to maximize efficiency and master Excel. - Course Objective
By the end of this course, participants will:- Use advanced tools like Pivot Tables, Goal Seek, and Data Validation.
- Master keyboard shortcuts for seamless navigation.
- Apply best practices for handling multiple files and large datasets.
- Course Duration
12 hours (3 full days or 6 two-hour sessions). - Pre-requisite
- Completion of the Intermediate Excel course or equivalent skills.
- Comfortable with advanced functions and data formatting.
- Course Outline
- Module 1:Â Pivot Tables (Functionalities, Use Cases).
- Module 2:Â Data Tools (Text to Columns, Goal Seek, Data Validation).
- Module 3:Â Number Formatting (Creating Custom Formats).
- Module 4:Â Excel without Mouse (Comprehensive Shortcuts).
- Module 5:Â Circular Referencing and Name Manager (Advanced Applications).
- Module 6:Â Managing Multiple Tabs/Files (Tips, Version Control).
Finance Courses
1-on-1 & group personalised courses, focused on Investment Banking and Mergers & Acquisition (M&A). Networking opportunities available for career progression.
Financial Modelling
Course Duration
1 week (5-7 days depending on financial literacy).Course Outline
Financial Modelling Best/Worst Practices – Formatting, Structure, Page Setup.
Introduction to Income Statement (P&L) – Revenue, Gross Margins, SG&A, EBITDA, EBIT, Net Income.
Introduction to Balance Sheet – Assets, Liabilities, Equities.
Introduction to Cashflow Statement – Cashflow from Operations, Cashflow from Investing, Cashflow from Financing.
Working Capital Schedule.
Debt & Loans Schedule.
Plant, Property, & Equipment / Depreciation Schedules.
Balancing a 3-statement model – Including building in Revolver with circular referencing.
Building a Discounted Cashflow (DCF) analysis – Free Cash Flow, WACC, Cost of Equity, Cost of Debt, Levered vs. Unlevered Free Cash Flow.
Comparables Analysis
Course Duration
1 Day (2-3 Hours).Course Outline
All about Precedent Transactions Analysis – Examples, Benefits & Limitations.
All about Comparable Companies Analysis – Examples, Benefits & Limitations.
Tips and tricks on using Capital IQ.
Advanced Financial Modelling
Course Duration
3-4 Days.Pre-requisite
Completion of Financial Modelling course or equivalent skills.Course Outline
Leveraged Buyouts (LBO) – Complete run-through step-by-step guidance on building a full-blown LBO model.Sources & Uses.
Investment & Capital Structure – Treasury Stock Method, Management Rollover/Sweeteners.
Debt Schedules.
Fees & Other Assumptions.
Pro-forma Financial Statements & Goodwill Calculation.
Cashflow and Debt Servicing Assumptions.
Returns Analysis & Sensitivity Analysis.
Key Findings.
FRS116 (Right-of-Use Assets & Lease Liabilities) – Introduction to FRS116 and how to build them into the model.
Mergers & Acquisition
Course Duration
1 week (5-7 days depending on financial literacy).Course Outline
Introduction to Mergers & Acquisition.
Types of Deal Structure – Buyouts vs. Growth vs. Carveouts.
Types of Investment Instruments – Common Equity, Convertible Debt, RCPS, SAFE Notes, etc.
Typical Timelines and Process.
Key Considerations in Financial Model & Marketing Collaterals (Teasers, Confidential Information Memorandums etc.).
Key Considerations in Non-Binding Bids.
Key Considerations at Diligence – Corporate, Operational, Financial, Legal, Human Resource, Information Technology, etc.
Key Considerations at Signing – Deal Terms (payment structure, guarantees), Working Capital, Condition Precedents/Condition Subsequent.
Key Considerations at Closing – Fund Flow.
Key Considerations post Closing – Integration, Synergies, Earn-out (if any), Management Incentive Plan etc.Â
Consulting Courses
Learn to bridge strategy and execution with the tools, frameworks, and techniques needed to manage stakeholders, align goals with solutions, and deliver impactful implementation results.
Foundations of Managing a Large Scale Project Implementation
1. Course Overview
This course provides participants with a foundational understanding of implementation consulting. It focuses on the transition from strategy development to execution, emphasizing the practical tools and techniques required to deliver successful implementation projects. By the end of the course, participants will be equipped with the knowledge to effectively manage stakeholders, structure implementation plans, and address common challenges.
2. Course Duration
8 hours (1 full day or split into 2 half-day sessions).
3. Course Outline
a)Â Â Â Introduction to Implementation Consulting
o  Definition and importance of implementation consulting
o  Differentiating between strategy and implementation consulting
b)Â Â Â Phases of an Implementation Project
o  Initiate and plan
o  Analyse and design
o  Build and test
o  Deploy and project closure
c)Â Â Â Â Stakeholder Engagement Essentials
o  Identifying key stakeholders
o  Building trust and managing expectations
d)Â Â Â Tools and Frameworks for Implementation
o  Overview of project management tools
o  Developing implementation roadmaps
e)Â Â Â Case Study: Real-World Application
Analyzing a simplified project scenario to apply learned concepts
Execution Excellence: Driving Results in Implementation Projects
1. Course Overview
This course is designed for consultants managing technology-heavy
implementation projects. Participants will gain expertise in aligning business
objectives with technical solutions, handling complex data migrations, and
managing technology-related risks. By the end of the course, participants will
be confident in driving large-scale technology implementations.
2. Course Duration
8 hours (1 full day or split into 2
half-day sessions).
3. Course Outline
a)
Understanding Technology
Solutions
o
Overview of enterprise systems
o
Aligning technology solutions
with business needs
b)
Choosing the Right Methodology
o
Agile vs. Waterfall for
technology projects
o
Hybrid approaches and best
practices
c)
Data Migration and Integration
o
Planning and executing data
migrations
o
Addressing compatibility and
integration challenges
d)
Risk Management in Technology
Projects
o
Identifying and mitigating
common risks
o
Building contingency plans
e)
Case Study: Implementation in
Financial Services
Industry-specific application and lessons learned
Career Insights
Finance Career Advice (Complementary)
Course Duration
Provided as part of Finance Course.Course Outline
Difference between Hedge Funds, Equity Research, Venture Capital, Direct Private Equity, FoF Private Equity, Private Credit, Investment Banking (M&A), Equity Capital Markets, Debt Capital Markets, Leveraged Financing, Project Financing etc. (customised to your career objectives)
Interview Prep (Complementary)
Course Duration
Provided as part of Finance Course.Course Outline
Complete run-through of Investment Banking Interview Questions.
CV Review (Complementary)
Course Duration
Provided as part of Finance Course.
Networking Opportunities with Professionals
(as and when available)