Find Missing Numbers, Really Fast

find missing numbers really fastA while ago I wrote a routine using the .Find method to find missing numbers in a sequence. So if we had 1, 3, 5, the missing numbers are 2 and 4. I had some feedback that as the sequence grew longer, the .Find method became increasingly slower, to the point that your hair grew […]

Slicers for Excel Tables

Slicers filter Excel TablesDid you know you can use Slicers to filter Excel Tables? It’s like having your cake and eating it too! Not just any cake either, it’s like the most delicious Excel cake you’ve ever eaten and once you get a taste of the ‘Table Slicer Cake’ you’ll be wanting more. The good news is it’s […]

Excel PivotTable Calculated Fields

Excel PivotTable Calculated FieldExcel PivotTable Calculated Fields are easy to add but there are a couple of ‘gotchas’ you should be aware of. Calculated Field Definition Microsoft Definition: A Calculated Field is a user-defined field in a PivotTable that can perform calculations using the contents of other fields in the PivotTable. Calculated field formulas can refer to one […]

Skip Dates in Excel Chart Axis

set Excel axis to skip weekend datesIn this tutorial we’re going to look at how we can skip dates in the Excel chart axis for those dates that have no data. Download the Excel Workbook. Note: this is a .xlsx file please ensure your browser doesn’t change the file extension on download. When you plot data in a chart that has […]

Excel Custom AutoFilter with Wildcards

Excel AutoFilterExcel’s Custom AutoFilter can perform a myriad of tasks that are often overlooked. Just last week we had a question from Alf: “I have a list of 7000+ words and want to search it with variables such as find all words where the third character is “u”, or where the third character is “u” and […]

Excel Custom Chart Labels

Excel custom chart labelsUsing Excel custom chart labels is a great way to create a more insightful chart without having to show a whole other series. Just take this chart below with custom labels showing the year on year % change: Download the Excel Workbook. Note: this is a .xlsx file please ensure your browser doesn’t change the […]

Excel Find Tool

excel_find_tool_thumbYou’ll be Amazed at what you can CTRL+F in Excel Excel’s Find tool is one of the first features you’re likely to learn and for many of us we only use its most basic feature, which is to find a particular word or value in a cell. It is such a diverse tool that I […]

Excel Advent Calendar

Excel Advent CalendarToday I’ve got a Christmas treat for you with an Excel Advent Calendar that Phil and I created. Before you get too excited I should say that there aren’t any chocolate/candy treats behind each door, plus you have to do a bit of work to actually open the doors! Don’t worry, I’m not the Grinch… […]

Workbook & Worksheet Events in Excel VBA

Workbook & Worksheet Events in Excel VBAWhat Are Events? An Event occurs when certain actions are performed by the user or VBA. For example when you open a workbook the Workbook_Open event is triggered. When you (or your VBA) saves a workbook, the Workbook_BeforeSave event is triggered. These events are built into Excel VBA and are executed automatically by Excel. You […]