Featured
Convert Formula to Relative or Absolute
Marcus Small
Convert Formula to Relative or Absolute
Marcus Small

Convert an Excel range from one reference to relative or absolute referencing.

Read More →
Marcus Small
Convert Entire Excel Workbook to Values
Marcus Small
Convert Entire Excel Workbook to Values
Marcus Small

Convert an entire workbook from formulas to numbers instantly.

Read More →
Marcus Small
Evaluate with Excel to Extract Sequence
Marcus Small
Evaluate with Excel to Extract Sequence
Marcus Small

Use the Evaluate function in Excel to populate a cell from a number sequence.

Read More →
Marcus Small
Extract the First Item from a Horizontal List
Marcus Small
Extract the First Item from a Horizontal List
Marcus Small

In Excel extract the left most item from a horizontal list using INDEX and MATCH.

Read More →
Marcus Small
Create Number Sequence with VBA Custom Function
Marcus Small
Create Number Sequence with VBA Custom Function
Marcus Small

An Excel custom function that allows sequental number sequences to be created.

Read More →
Marcus Small
Protect a Worksheet, Use the Autofilter
Marcus Small
Protect a Worksheet, Use the Autofilter
Marcus Small

Protect an Excel worksheet and use the auto filter.  A how to guide.

Read More →
Marcus Small
Countifs Across Sheets
Marcus Small
Countifs Across Sheets
Marcus Small

Add a count formula across multiple sheets in Excel.

Read More →
Marcus Small
Excel VBA to Select Sheets
Marcus Small
Excel VBA to Select Sheets
Marcus Small

Excel VBA to select sheets and print out the selected sheets using PDF.

Read More →
Marcus Small
Power BI Desktop Dashboard
Marcus Small
Power BI Desktop Dashboard
Marcus Small

A Power BI Desktop example using Power BI

Read More →
Marcus Small
New Excel Dashboard Tools
Marcus Small
New Excel Dashboard Tools
Marcus Small

This is a list of Excel dashboards - the best I have produced to date.  These are time saving Excel tools.

Read More →
Marcus Small