- 20
- 155 151
Aheadyx
Приєднався 15 лип 2024
Strategy consulting x restructuring end-to-end project case study. 1-minute slide design best practices and financial modeling Excel hacks. Selected insights from real case interviews with leading strategy consultancies.
Modelling the German Fashion Retail Market | Part 1: Approach
If you want to learn how to model a market for a commercial due diligence or strategy consulting project in general, you've come to the right place.
0:00 Motivation and context
0:13 Introduction to the case
0:38 Approach to modelling the market
#strategy #marketanalysis #consulting
0:00 Motivation and context
0:13 Introduction to the case
0:38 Approach to modelling the market
#strategy #marketanalysis #consulting
Переглядів: 35
Відео
Building an Integrated Financial Model | Part 1: Introduction to the Model
Переглядів 4014 днів тому
The integrated financial model is the centerpiece of any corporate restructuring and investment banking case. Watch this introduction for a unique perspective on understanding three-statement modeling. 0:00 Motivation & agenda 1:47 Excel model walkthrough 7:56 Outlook #investmentbanking #financialmodeling #finance
Planning Short-term Liquidity | Part 1: Introduction
Переглядів 3114 днів тому
Let's get started with the first work package: Planning short-term liquidity. So, in this series, I'll walk you through each step in analyzing the financial status and forecasting 13 weeks of liquidity. 0:00 Introduction 0:52 Suggestion for best learning experience 1:07 Financial status 1:51 13-weeks liquidity forecast 2:43 Top 10 payables & receivables 3:57 Financing parties 4:20 Summary & out...
Setting up Project Work | Information Request, Kick-off Workshop and Legal Entities in Scope
Переглядів 6021 день тому
Better safe than sorry: Let's set up project work. So, in this video we will look into the information request list (IRL), kick-off workshop agenda and the legal structure. 0:00 Introduction: Setting up project work (part 1/2): IRL, kick-off and legal entities 0:42 Information request: General remarks 1:15 Information request: Short-term liquidity 3:05 Information request: Integrated business p...
Staffing a Strategy Consulting Project | Roles and Responsibilities Explained!
Переглядів 39Місяць тому
As you move up the career ladder towards project lead in a strategy consultancy, the focus shifts from performing to organizing project work. In this video, join me for a detailed walkthrough of the career ladder and all things staffing in strategy consulting and restructuring. 0:00 Agenda 0:33 Career Ladder 4:04 1 2 vs. 1 3 Staffing 4:48 Example: Roles and Responsibilities in a 1 2 Staffing 9:...
6 PowerPoint shortcuts in 60 seconds! | Advanced level
Переглядів 45Місяць тому
Let's level up your PowerPoint game in this 60 seconds 'runthrough' of 6 advanced-level shortcuts. Brought to you from first-hand project experiences! 0:00 Contents: 6 PowerPoint shortcuts in 60 seconds 0:03 Efficiently align elements | ALT 1, 2, ... (customize quick access toolbar) 0:20 Repeat last action | F4 0:32 Duplicate along axis | Ctrl Shift Drag 0:45 Insert smooth line break | Shift En...
Strategy Consulting vs. Restructuring | Comparison of Working Styles
Переглядів 2,9 тис.Місяць тому
In this video let's compare strategy consulting with restructuring based on five dimensions that I selected from project experience. 0:00 Introduction: Comparison based on five dimensions 0:10 Solution space: Rather unrestricted vs. restricted 1:47 Complexity: Logical vs. technical 4:18 Rationale: Primarily qualitative vs. primarily quantitative 4:30 Activities: Structuring & story lining vs. f...
Strategy Consulting x Restructuring | Project Case Study | Part 1 | Introduction: SCR Framework
Переглядів 6 тис.Місяць тому
Aheadyx is the missing puzzle piece beyond case prep and onboarding bootcamps for stellar consulting performance in year one. Watch this video for an introduction to the case, based on the situation, complication and resolution framework. Specifically, we will deep-dive into the approach. This case study is the only one to teach a truly ambidextrous working style that seamlessly blends strategy...
9 Excel shortcuts in 90 seconds!
Переглядів 6 тис.2 місяці тому
For this video I compiled the best Excel shortcuts that are used in investment banking, strategy consulting and corporate restructuring. These shortcuts will significantly speed up your workflow as they focus on the efficient navigation of Excel. Last but not least, there's a PowerPoint trick to shift bullet points up and down. 0:00 Overview 0:07 Jump between sheets | Ctrl Page Up/Down 0:15 Sel...
Unconventional market sizing: Three examples from real case interviews with strategy consultancies!
Переглядів 12 тис.2 місяці тому
Be aware that market sizing questions with the leading strategy consultancies are usually much harder than what you see in most getting started with market sizing videos. In this 5-minute walkthrough, I explain to you three selected types of unconventional market sizing questions in case interviews. Each type is supplemented by a case prompt from a real interview with a tier 1 or tier 2 strateg...
Reduce file size of an Excel Workbook by removing links!
Переглядів 7 тис.2 місяці тому
Links to other Excel files can quickly drive up file size. To keep your model's file size down, remove external links and replace them with just the values. This can help reduce file size by more than 50% if you are using a lot of input data. 0:00 Pain point: File size exploded 0:11 Root cause: Links to other Workbooks 0:32 How to fix: Go with value copy 0:44 Working in a team: Add link, date l...
Compare two Excel files for differences!
Переглядів 17 тис.2 місяці тому
So you got two Excel Worksheets and want to quickly find out where they differ - let's do this! This works even for very large Excel files. 0:00 Motivation: Compare two large Excel files 0:07 Solution: Check cells for equality 0:45 Investigation: These cells differ #excel #finance #exceltips
Find out where Excel value is coming from!
Переглядів 8 тис.2 місяці тому
Let's trace back those formula inputs by changing this setting in Excel. Watch this video to change this default setting into something more useful! 0:00 Motivation: Where are my numbers coming from? 0:05 Example: Sum formula 0:13 Solution: Enable feature #excel #finance #exceltips
Export PowerPoint slide as high-resolution image!
Переглядів 11 тис.3 місяці тому
So you want to export your PowerPoint slides as images but the resolution is too low. Watch this video to showcase your slides in high-res with this simple trick. 0:00 Problem: PowerPoint by default only exports images in 1280x720 0:34 Solution: Add a white shape in the background 1:07 Check: Now we got an image in 4K resolution #powerpoint
Sum all sheets in between two sheets in Excel!
Переглядів 10 тис.3 місяці тому
With this sum formula you can easily sum up a specific cell across all sheets in between two bordering sheets. Watch this video to flexibly sum up business units, products, branches, ... anything! 0:00 Motivation: Sum up all sheets between two bordering sheets 0:14 Solution: Special sum formula 0:32 Examples: Departments, legal entities or measures #excel #finance #exceltips
Build a slide like a strategy consultant!
Переглядів 13 тис.3 місяці тому
Build a slide like a strategy consultant!
Avoid errors in your Excel model by using checks!
Переглядів 7 тис.3 місяці тому
Avoid errors in your Excel model by using checks!
Use Excel's name manager to ensure consistency of calculations!
Переглядів 35 тис.3 місяці тому
Use Excel's name manager to ensure consistency of calculations!
Insert line breaks in your Excel formulas to improve readability!
Переглядів 10 тис.3 місяці тому
Insert line breaks in your Excel formulas to improve readability!
Don't mess up PDF title when exporting a PowerPoint presentation!
Переглядів 9 тис.3 місяці тому
Don't mess up PDF title when exporting a PowerPoint presentation!
➡ Learn all things *structuring* and *modeling* on aheadyx.com
➡ Learn all things *structuring* and *modeling* on aheadyx.com
➡ Learn all things *structuring* and *modeling* on aheadyx.com
➡ Learn all things *structuring* and *modeling* on aheadyx.com
➡ Learn all things *structuring* and *modeling* on aheadyx.com
➡ Learn all things *slides* and *financial modeling* on aheadyx.com
➡ Learn all things *structuring* and *modeling* on aheadyx.com
Hl
Hi!
➡ Learn all things *structuring* and *modeling* on aheadyx.com
➡ Check out my free intro course on *financial modeling* on aheadyx.com
➡ Learn all things *slides* and *financial modeling* on aheadyx.com
➡ Check out my free intro course on *financial modeling* on aheadyx.com
➡ Check out my free intro course on *financial modeling* on aheadyx.com
➡ Learn all things *slides* and *financial modeling* on aheadyx.com
➡ Learn all things *slides* and *financial modeling* on aheadyx.com
➡ Learn all things *slides* and *financial modeling* on aheadyx.com
➡ Check out my free intro course on *financial modeling* on aheadyx.com
➡ Check out my free intro course on *financial modeling* on aheadyx.com
➡ Check out my free intro course on *financial modeling* on aheadyx.com
➡ Check out my free intro course on *financial modeling* on aheadyx.com
➡ Check out my free intro course on *financial modeling* on aheadyx.com
❤❤
Thank you!