Evaluate with Excel to Extract Sequence

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

Tags Evaluate, Excel, Number Sequence

Extract the First Item from a Horizontal List

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

Tags Excel, Extract, Horizontal List

Create Number Sequence with VBA Custom Function

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

Tags Excel, Split, Cells, Number sequence, Custom Function, VBA

Protect a Worksheet, Use the Autofilter

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

Tags auto, filter, protect, worksheet, excel, Protect

Countifs Across Sheets

Add a count formula across multiple sheets in Excel.

Tags Excel, Countifs, multiple, sheets, many, tabs

Excel VBA to Select Sheets

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

Power BI Desktop Dashboard

A Power BI Desktop example using Power BI

New Excel Dashboard Tools

This is a list of Excel dashboards - the best I have produced to date. These are time saving Excel tools which you can purchase from Eloquens.

Tags Excel, Dashboards, Tools, Premium Models

Watch This Space

No Spaces in Excel sheet names is a good habit to get into.

Tags Excel, Sheet names, No Spaces

The Fuzzy World of Financial Modelling

This post is about financial modelling, how to do it and what is important when it comes to manipulating Excel data.

Tags Excel, Financial Modelling, Dashboards

Excel Autofill - Fill Down to Bottom of Range

In Excel you may wish to drill down on a range which has a header value not already contained in the rows. The following article shows a practical example of how to generate a unique row name based on the heading in a specific place. The procedure is in VBA.

Tags Excel, VBA, Drill down, Fill down, filldown, autofilter