Strategize Financial Modelling

@UCZbKSna-5dTve6dhhjtL4SQ - 2.9K subscribers

ABOUT Strategize is a financial modelling and advisory firm. We focus on servicing private equity, middle market, family office and banking clients. Our firm is an independent, boutique firm that is not conflicted, and works in the best interests of your firm’s business needs. Strategize works with clients globally by providing decision support to its clients, either by • helping executives and stakeholders gain greater confidence with an existing financial model, or • building an error-free, robust and best practice financial model for transactional purposes. Strategize Financial Modelling videos show professionals how to build Best Practice Financial Models or spreadsheets, or simply helps users to correctly employ the universe of Microsoft Excel® functions and other features in their day to day spreadsheet work.

Home Videos Live Playlists

Managing Creditors: A Strategic Imperative for Financial Leadership

Managing Creditors: A Strategic Imperative for Financial Leadership Strategize Financial Modelling

12 views - 1 year ago

The Hidden Dangers of Capital Structure

The Hidden Dangers of Capital Structure Strategize Financial Modelling

14 views - 1 year ago

A CFO's Guide to Disclosing Finder Fees in Financial Statements

A CFO's Guide to Disclosing Finder Fees in Financial Statements Strategize Financial Modelling

13 views - 1 year ago

How Working Capital can improve Your Company’s Liquidity

How Working Capital can improve Your Company’s Liquidity Strategize Financial Modelling

40 views - 1 year ago

Mastering Due Diligence: The CFO's Secret Weapon

Mastering Due Diligence: The CFO's Secret Weapon Strategize Financial Modelling

17 views - 1 year ago

The Hidden Power of Capital Structure

The Hidden Power of Capital Structure Strategize Financial Modelling

11 views - 1 year ago

Mastering Strategic Due Diligence in Corporate Transactions

Mastering Strategic Due Diligence in Corporate Transactions Strategize Financial Modelling

29 views - 1 year ago

Mastering Revenue Recognition: US GAAP ASC 606 Explained

Mastering Revenue Recognition: US GAAP ASC 606 Explained Strategize Financial Modelling

395 views - 1 year ago

The Hidden Power of Capital Structure: A CFO's Guide

The Hidden Power of Capital Structure: A CFO's Guide Strategize Financial Modelling

33 views - 1 year ago

Average an Excel range - ignoring blank, text or error cells & largest & smallest

Average an Excel range - ignoring blank, text or error cells & largest & smallest Strategize Financial Modelling

3.3K views - 4 years ago

Largest value in Excel range (advanced approach) - ignore blanks, texts or errors

Largest value in Excel range (advanced approach) - ignore blanks, texts or errors Strategize Financial Modelling

370 views - 4 years ago

Deleting rows based on error values across sheets

Deleting rows based on error values across sheets Strategize Financial Modelling

286 views - 4 years ago

How to change from exponential to number format in Excel - Advanced

How to change from exponential to number format in Excel - Advanced Strategize Financial Modelling

14K views - 4 years ago

How to change from exponential to number format in Excel

How to change from exponential to number format in Excel Strategize Financial Modelling

119.1K views - 5 years ago

Remove x characters from right of cell using Excel VBA

Remove x characters from right of cell using Excel VBA Strategize Financial Modelling

1.4K views - 5 years ago

Remove x characters from left of cell using Excel VBA

Remove x characters from left of cell using Excel VBA Strategize Financial Modelling

2.6K views - 5 years ago

Automatically highlight the active column in Excel

Automatically highlight the active column in Excel Strategize Financial Modelling

191 views - 5 years ago

Automatically highlight the active row in Excel

Automatically highlight the active row in Excel Strategize Financial Modelling

294 views - 5 years ago

XIRR formula across multiple sheets

XIRR formula across multiple sheets Strategize Financial Modelling

2.6K views - 5 years ago

XLOOKUP formula across multiple sheets

XLOOKUP formula across multiple sheets Strategize Financial Modelling

17K views - 5 years ago

Excel SLOPE & INTERCEPT to forecast ROI

Excel SLOPE & INTERCEPT to forecast ROI Strategize Financial Modelling

1.6K views - 5 years ago

Excel VBA Dynamic Ranges in a Pivot Table

Excel VBA Dynamic Ranges in a Pivot Table Strategize Financial Modelling

6.3K views - 5 years ago

How to convert formulas to values in an Excel workbook

How to convert formulas to values in an Excel workbook Strategize Financial Modelling

622 views - 5 years ago

Revenue (Multi Currency) module in Modano

Revenue (Multi Currency) module in Modano Strategize Financial Modelling

190 views - 5 years ago

Foreign currency revenue module in Modano

Foreign currency revenue module in Modano Strategize Financial Modelling

150 views - 5 years ago

Create index with hyperlinks to all selected sheets using Excel VBA

Create index with hyperlinks to all selected sheets using Excel VBA Strategize Financial Modelling

3.8K views - 5 years ago

Unfreeze panes across selected sheets

Unfreeze panes across selected sheets Strategize Financial Modelling

102 views - 5 years ago

XLOOKUP VLOOKUP macro alternative

XLOOKUP VLOOKUP macro alternative Strategize Financial Modelling

3.9K views - 5 years ago

Freeze panes across selected sheets

Freeze panes across selected sheets Strategize Financial Modelling

1.4K views - 5 years ago

Loop through rows in a Column

Loop through rows in a Column Strategize Financial Modelling

23K views - 5 years ago

Loop across columns in a Row

Loop across columns in a Row Strategize Financial Modelling

9.7K views - 5 years ago

Delete empty columns in Excel

Delete empty columns in Excel Strategize Financial Modelling

366 views - 6 years ago

How to convert formulas to values in Excel

How to convert formulas to values in Excel Strategize Financial Modelling

1.6K views - 6 years ago

How to unfreeze panes across multiple Excel worksheets, workbooks

How to unfreeze panes across multiple Excel worksheets, workbooks Strategize Financial Modelling

765 views - 6 years ago

How to break external links from selected cells in Excel

How to break external links from selected cells in Excel Strategize Financial Modelling

20.5K views - 6 years ago

How to freeze panes across multiple Excel worksheets, workbooks

How to freeze panes across multiple Excel worksheets, workbooks Strategize Financial Modelling

1.6K views - 6 years ago

How to unfreeze panes across multiple Excel worksheets

How to unfreeze panes across multiple Excel worksheets Strategize Financial Modelling

366 views - 6 years ago

How to freeze panes across multiple Excel worksheets

How to freeze panes across multiple Excel worksheets Strategize Financial Modelling

4.9K views - 6 years ago

Insert multiple columns across Workbooks using VBA in Excel

Insert multiple columns across Workbooks using VBA in Excel Strategize Financial Modelling

1.6K views - 6 years ago

Insert multiple rows across Workbooks using VBA in Excel

Insert multiple rows across Workbooks using VBA in Excel Strategize Financial Modelling

2K views - 6 years ago

Excel sum right value in each string cell

Excel sum right value in each string cell Strategize Financial Modelling

922 views - 6 years ago

Excel sum left value in each string cell

Excel sum left value in each string cell Strategize Financial Modelling

5.7K views - 6 years ago

Remove x characters from right of cell in Excel

Remove x characters from right of cell in Excel Strategize Financial Modelling

25.8K views - 6 years ago

Remove x characters from left of cell in Excel

Remove x characters from left of cell in Excel Strategize Financial Modelling

75.8K views - 6 years ago

How to extract the last word in a string with Excel VBA

How to extract the last word in a string with Excel VBA Strategize Financial Modelling

1.6K views - 6 years ago

How to extract the first word in a string with Excel VBA

How to extract the first word in a string with Excel VBA Strategize Financial Modelling

2.5K views - 6 years ago

XMATCH - Practical Uses in Excel

XMATCH - Practical Uses in Excel Strategize Financial Modelling

3K views - 6 years ago

XLOOKUP - Practical Uses in Excel

XLOOKUP - Practical Uses in Excel Strategize Financial Modelling

144 views - 6 years ago

Case Study - Childcare Modano model for buy-side due diligence

Case Study - Childcare Modano model for buy-side due diligence Strategize Financial Modelling

232 views - 6 years ago

Case Study - Coal mining financial model for an equity raise using Modano

Case Study - Coal mining financial model for an equity raise using Modano Strategize Financial Modelling

773 views - 6 years ago

Excel SUMPRODUCT financial modelling examples - part 2

Excel SUMPRODUCT financial modelling examples - part 2 Strategize Financial Modelling

165 views - 6 years ago

Excel SUMPRODUCT financial modelling examples

Excel SUMPRODUCT financial modelling examples Strategize Financial Modelling

1.2K views - 6 years ago

Excel VBA SUMIF by font color

Excel VBA SUMIF by font color Strategize Financial Modelling

9.3K views - 6 years ago

Excel VBA SUMIF by fill color

Excel VBA SUMIF by fill color Strategize Financial Modelling

673 views - 6 years ago

Excel VBA open & close workbooks

Excel VBA open & close workbooks Strategize Financial Modelling

1.4K views - 6 years ago

Excel VBA how to move a sheet x times to the left

Excel VBA how to move a sheet x times to the left Strategize Financial Modelling

164 views - 6 years ago

Excel VBA how to move a sheet x times to the right

Excel VBA how to move a sheet x times to the right Strategize Financial Modelling

317 views - 6 years ago

Excel VBA how to copy multiple sheets multiple times

Excel VBA how to copy multiple sheets multiple times Strategize Financial Modelling

4K views - 6 years ago

Excel VBA insert columns all sheets

Excel VBA insert columns all sheets Strategize Financial Modelling

5.3K views - 6 years ago

Excel VBA: Goal Seek across columns, across sheets

Excel VBA: Goal Seek across columns, across sheets Strategize Financial Modelling

2.6K views - 6 years ago