03:21

How to Fix the Healthcare System – Hacks to treat more patients.

03:26

How to calculate weighted average in Excel – using SUMPRODUCT function

01:59

How to use SUMPRODUCT function – calculate revenues with 1 function in Excel

04:40

Financial Modeling in Excel – How to model revenues

05:30

Digital Transformation in Retail – How it is done

05:23

Monthly Recurring Revenue (MRR) - What it is and how to use it

02:43

Examples of Subscription Businesses

02:52

Drivers of Subscription Models

02:32

How to Increase the Customer Lifetime Value

03:19

Payback Period – What it is and how to calculate it

04:34

How to use ChatGPT for market research during consulting projects

03:20

What is Customer Lifetime Value (LTV or CLV) and how to calculate it

03:08

Customer Acquisition Costs (CAC) – Definition and how to calculate them.

04:13

How to Delete a Query in Power Query

02:09

When starting a project is a bad idea?

01:51

What is Agile? Agile vs Waterfall in Project Management.

02:46

How to Estimate Tasks Duration (Time) for Projects

06:31

How to Clean Data in Excel, using Power Query

08:28

How to Combine Data From Multiple Worksheets into a Single Worksheet in Excel using Power Query

04:15

What is a Project? A guide for Management Consultants.

02:54

What is a Milestone in Project Management?

02:51

What is Project Scope?

02:15

How to copy a Power Query?

01:48

How to add a Column from Examples in Power Query/Excel without any formulas (AI elements in Excel)

02:40

How to add a Conditional Column in Power Query (like IF function in Excel)

03:53

Unpivot Data in Excel (Convert columns to rows in Excel) using Power Query

04:52

Normal Distribution explained

03:21

How to define the problem in Six Sigma

01:32

Fishbone diagram (Ishikawa diagram) example - Restaurant

01:51

Fishbone diagrams (Ishikawa diagrams) explained in 2 minutes

04:30

What is SIPOC and how to use SIPOC diagram in practice

04:29

Correlation Analysis Explained in 4 minutes

03:37

What do we mean by defects in Six Sigma?

07:03

What is DMAIC framework - Six Sigma?

04:31

What is Six Sigma? Six Sigma explained in 5 minutes.

03:23

Salary Structure – Employee Bonus Systems

01:43

Pay Matrix – Understanding the salary Structure – Management Consulting

02:15

Pay Grades & Ranges – How to define basic salaries in the firm

03:58

Naming and Renaming Excel Tables - Quick Tips

01:58

Excel Table Formatting - How to format the Excel Table.

05:08

How to create & use Excel Tables (Essential information for Management Consultants)

03:48

Headcount & Workforce Optimization – Adjust salaries & bonuses

04:45

Benchmarks for Headcount & Workforce Optimization (consulting projects)

05:39

Workload Analysis for Projects & Headcount (Workforce) Optimization using FTE

03:02

Headcount & Workforce Optimization – the General Framework

06:19

Things I hate in Management Consulting

18:22

Lean Office: Cost-benefit analysis for changing the layout of the office

02:30

Lean Office: Problems generated by mistakes with the Layout of the office

02:24

Lean Office: Poka Yoke examples

10:06

Cost-Benefit Analysis Example in Excel – Specification Analysis in Purchasing

01:59

Lean Maufacturng: Milk Run Explained

04:38

Lean Office: What generates waste in the office

04:25

Lean Office: Different types of waste in the office

03:49

Dynamic Drop-down list in Excel – how to create it with Excel Tables.

05:10

Capex vs Opex Analysis Explained

02:19

The Basics of Procurement Management: Why should you create specifications?

05:58

Facebook’s & Instagram's (Meta) Business Model Explained (with the Business Model Canvas)& strategy

02:05

Modular Design – why it is so important for the business

02:02

How to find the Lowest values in Excel with one formula (SMALL function)

05:12

Procurement Management – How to identify quick wins?