Канал: Strategize Financial Modelling

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

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

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

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

Deleting rows based on error values across sheets

Deleting rows based on error values across sheets

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

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

How to change from exponential to number format in Excel

How to change from exponential to number format in Excel

Remove x characters from right of cell using Excel VBA

Remove x characters from right of cell using Excel VBA

Remove x characters from left of cell using Excel VBA

Remove x characters from left of cell using Excel VBA

Automatically highlight the active column in Excel

Automatically highlight the active column in Excel

Automatically highlight the active row in Excel

Automatically highlight the active row in Excel

XIRR formula across multiple sheets

XIRR formula across multiple sheets

XLOOKUP formula across multiple sheets

XLOOKUP formula across multiple sheets

Excel SLOPE & INTERCEPT to forecast ROI

Excel SLOPE & INTERCEPT to forecast ROI

Excel VBA Dynamic Ranges in a Pivot Table

Excel VBA Dynamic Ranges in a Pivot Table

How to convert formulas to values in an Excel workbook

How to convert formulas to values in an Excel workbook

Revenue (Multi Currency) module in Modano

Revenue (Multi Currency) module in Modano

Foreign currency revenue module in Modano

Foreign currency revenue module in Modano

Create index with hyperlinks to all selected sheets using Excel VBA

Create index with hyperlinks to all selected sheets using Excel VBA

Unfreeze panes across selected sheets

Unfreeze panes across selected sheets

XLOOKUP VLOOKUP macro alternative

XLOOKUP VLOOKUP macro alternative

Freeze panes across selected sheets

Freeze panes across selected sheets

Loop through rows in a Column

Loop through rows in a Column

Loop across columns in a Row

Loop across columns in a Row

Delete empty columns in Excel

Delete empty columns in Excel

How to convert formulas to values in Excel

How to convert formulas to values in Excel

How to unfreeze panes across multiple Excel worksheets, workbooks

How to unfreeze panes across multiple Excel worksheets, workbooks

How to break external links from selected cells in Excel

How to break external links from selected cells in Excel

How to freeze panes across multiple Excel worksheets, workbooks

How to freeze panes across multiple Excel worksheets, workbooks

How to unfreeze panes across multiple Excel worksheets

How to unfreeze panes across multiple Excel worksheets

How to freeze panes across multiple Excel worksheets

How to freeze panes across multiple Excel worksheets

Insert multiple columns across Workbooks using VBA in Excel

Insert multiple columns across Workbooks using VBA in Excel

Insert multiple rows across Workbooks using VBA in Excel

Insert multiple rows across Workbooks using VBA in Excel

Excel sum right value in each string cell

Excel sum right value in each string cell

Excel sum left value in each string cell

Excel sum left value in each string cell

Remove x characters from right of cell in Excel

Remove x characters from right of cell in Excel

Remove x characters from left of cell in Excel

Remove x characters from left of cell in Excel

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

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

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

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

XMATCH - Practical Uses in Excel

XMATCH - Practical Uses in Excel

XLOOKUP - Practical Uses in Excel

XLOOKUP - Practical Uses in Excel

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

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

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

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

Excel SUMPRODUCT financial modelling examples - part 2

Excel SUMPRODUCT financial modelling examples - part 2

Excel SUMPRODUCT financial modelling examples

Excel SUMPRODUCT financial modelling examples

Excel VBA SUMIF by font color

Excel VBA SUMIF by font color

Excel VBA SUMIF by fill color

Excel VBA SUMIF by fill color

Excel VBA open & close workbooks

Excel VBA open & close workbooks

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

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

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

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

Excel VBA how to copy multiple sheets multiple times

Excel VBA how to copy multiple sheets multiple times

Excel VBA insert columns all sheets

Excel VBA insert columns all sheets

Excel VBA: Goal Seek across columns, across sheets

Excel VBA: Goal Seek across columns, across sheets

Excel VBA: Loop across sheets and select same row

Excel VBA: Loop across sheets and select same row

Strategize Financial Modelling Live Stream

Strategize Financial Modelling Live Stream

Insert multiple rows across sheets using VBA in Excel

Insert multiple rows across sheets using VBA in Excel

Deleting columns based on a cell value

Deleting columns based on a cell value

Loop down across macro in Excel

Loop down across macro in Excel

Loop down across macro in Excel

Loop down across macro in Excel

Loop selected range macro in Excel

Loop selected range macro in Excel

Copy a worksheet multiple times in Excel

Copy a worksheet multiple times in Excel

Random selection (no duplicates) from a list in Excel

Random selection (no duplicates) from a list in Excel

Random selection from a list in Excel

Random selection from a list in Excel

Insert multiple Excel sheets using a macro

Insert multiple Excel sheets using a macro

Smallest value in an Excel range - ignoring blank, text or error cells

Smallest value in an Excel range - ignoring blank, text or error cells

Largest value in an Excel range - ignoring blank, text or error cells

Largest value in an Excel range - ignoring blank, text or error cells

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

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

Deleting rows based on cell values across sheets using VBA

Deleting rows based on cell values across sheets using VBA

Deleting rows based on a cell value (update)

Deleting rows based on a cell value (update)

Ungrouping Rows from Multiple Sheets

Ungrouping Rows from Multiple Sheets

Grouping Rows from Multiple Sheets

Grouping Rows from Multiple Sheets

Ungrouping Columns from Multiple Sheets

Ungrouping Columns from Multiple Sheets

Grouping Columns from Multiple Sheets

Grouping Columns from Multiple Sheets

Create index with hyperlinks to all sheets using Excel VBA

Create index with hyperlinks to all sheets using Excel VBA

Excel 2019 - New Excel functions #2 - MINIFS

Excel 2019 - New Excel functions #2 - MINIFS

Excel 2019 - New Excel functions #1 - MAXIFS

Excel 2019 - New Excel functions #1 - MAXIFS

Excel VBA hyperlink list visible worksheets

Excel VBA hyperlink list visible worksheets

Excel vba list all worksheets

Excel vba list all worksheets

Excel VBA insert columns fill across

Excel VBA insert columns fill across

Excel insert multiple rows & fill down

Excel insert multiple rows & fill down

Excel Goal Seek across columns

Excel Goal Seek across columns

Advanced drop-down lists in Excel

Advanced drop-down lists in Excel

Deleting rows based on a cell value

Deleting rows based on a cell value

Creating a Three Dimension Data Table in Excel

Creating a Three Dimension Data Table in Excel

Insert multiple columns using Excel VBA

Insert multiple columns using Excel VBA

Insert multiple rows using VBA in Excel

Insert multiple rows using VBA in Excel

Excel VBA Dynamic Ranges

Excel VBA Dynamic Ranges

Excel VBA Dynamic Row Ranges

Excel VBA Dynamic Row Ranges

Excel Flash Fill in Financial Modeling

Excel Flash Fill in Financial Modeling

DCF Sensitivity Analysis with Excel Data Table (UPDATED)

DCF Sensitivity Analysis with Excel Data Table (UPDATED)

Using Excel Consolidate in Financial Modelling

Using Excel Consolidate in Financial Modelling

How to create a dynamic picture image based on an Excel cell value (UPDATED)

How to create a dynamic picture image based on an Excel cell value (UPDATED)

How to create ordinal numbers using Conditional Formatting in Excel (UPDATED)

How to create ordinal numbers using Conditional Formatting in Excel (UPDATED)

Dynamic dependent drop-down list - advanced approach with LOOKUP

Dynamic dependent drop-down list - advanced approach with LOOKUP

Managing Excel Form Control Buttons

Managing Excel Form Control Buttons

Shuffling data with HLOOKUP

Shuffling data with HLOOKUP

Converting between the two Excel Date Systems

Converting between the two Excel Date Systems

Financial Model Benefits of Excel Custom Format Cells

Financial Model Benefits of Excel Custom Format Cells

How to learn Excel Cell references

How to learn Excel Cell references

Excel Ctrl combination shortcut keys

Excel Ctrl combination shortcut keys

Excel Traffic Lights

Excel Traffic Lights

5 Potential Problems using Excel VLOOKUP

5 Potential Problems using Excel VLOOKUP

Excel spreadsheet calculation options

Excel spreadsheet calculation options

Excel Data Validation to prevent duplicate cells

Excel Data Validation to prevent duplicate cells

Sorting data without Excel Data Sort

Sorting data without Excel Data Sort

How to create a Precedent Drop-down list in Excel

How to create a Precedent Drop-down list in Excel

Excel AGGREGATE SUM with Errors

Excel AGGREGATE SUM with Errors

Using Excel Styles for Dynamic Color Formatting

Using Excel Styles for Dynamic Color Formatting

Excel Fill Handle with Various Data Series

Excel Fill Handle with Various Data Series

Excel AGGREGATE, not Excel aggravate!

Excel AGGREGATE, not Excel aggravate!

Can You Handle It?

Can You Handle It?

Applying Conditional Cell Formatting in Financial Modelling PART 2

Applying Conditional Cell Formatting in Financial Modelling PART 2

Applying Conditional Cell Formatting in Financial Modelling

Applying Conditional Cell Formatting in Financial Modelling

Excel SUMPRODUCT in Business Planning

Excel SUMPRODUCT in Business Planning

Sum an Excel range - ignoring blank, text or error cells

Sum an Excel range - ignoring blank, text or error cells

Why can't I kill the Excel External Links?

Why can't I kill the Excel External Links?

Data Group in Excel - Strategic Planning

Data Group in Excel - Strategic Planning

Advanced Waterfall Chart - Dealing with Negatives

Advanced Waterfall Chart - Dealing with Negatives

Reverse HLOOKUP in Excel

Reverse HLOOKUP in Excel

How to create a dynamic picture image based on an Excel cell value

How to create a dynamic picture image based on an Excel cell value

Reverse VLOOKUP - Equivalent methods

Reverse VLOOKUP - Equivalent methods

How to create a dynamic Waterfall Chart

How to create a dynamic Waterfall Chart

How to create ordinal numbers using Conditional Formatting in Excel

How to create ordinal numbers using Conditional Formatting in Excel

Dynamic data ranges in an Excel Graph

Dynamic data ranges in an Excel Graph

DCF Sensitivity Analysis with Excel Data Table

DCF Sensitivity Analysis with Excel Data Table

How to create a dynamic drop-down list from a horizontal range

How to create a dynamic drop-down list from a horizontal range

How to create a Waterfall Chart in Excel

How to create a Waterfall Chart in Excel

How to create a dynamic VLOOKUP

How to create a dynamic VLOOKUP

How to sum across optional column ranges using SUMPRODUCT

How to sum across optional column ranges using SUMPRODUCT

How to use Excel Data Validation to protect cells

How to use Excel Data Validation to protect cells

Excel INDEX MATCH for two dimension lookups

Excel INDEX MATCH for two dimension lookups

How to create a dynamic drop-down list

How to create a dynamic drop-down list

Welcome to Strategize Financial Modelling

Welcome to Strategize Financial Modelling

Excel VLOOKUP across multiple worksheets

Excel VLOOKUP across multiple worksheets

How to create a 'radio button' drop-down list

How to create a 'radio button' drop-down list

How to do a VLOOKUP - A Look into the basics

How to do a VLOOKUP - A Look into the basics

Making Sense of the Sensitivity Tools for Strategic Planning

Making Sense of the Sensitivity Tools for Strategic Planning

Worst to Best Practice Financial Modelling Basics

Worst to Best Practice Financial Modelling Basics

Practical Corporate Governance Tools

Practical Corporate Governance Tools

How to create dependent drop-down lists

How to create dependent drop-down lists

Executive, Financial Dashboards 101

Executive, Financial Dashboards 101

Advanced approaches to demystify financial uncertainty - sensitivity analysis

Advanced approaches to demystify financial uncertainty - sensitivity analysis

Output Summary and Dashboards - Financial spreadsheets 101

Output Summary and Dashboards - Financial spreadsheets 101

Calculations - Financial spreadsheets 101

Calculations - Financial spreadsheets 101

Table of Contents - Financial spreadsheets 101

Table of Contents - Financial spreadsheets 101

The Power of a Pricing Model

The Power of a Pricing Model

Contract Pricing & Analysis

Contract Pricing & Analysis

Struggling with your Company's strategic plan

Struggling with your Company's strategic plan

The challenge of adding value to an array of source carbon models

The challenge of adding value to an array of source carbon models

Output errors plaguing your Company's financial model

Output errors plaguing your Company's financial model

Consolidating your Company's financials for its strategic plan

Consolidating your Company's financials for its strategic plan

Carbon Modelling & Analysis

Carbon Modelling & Analysis

The challenge of managing your Company's legacy spreadsheets

The challenge of managing your Company's legacy spreadsheets