Tutorials and Articles

Home: Welcome

Dynamic Search as you Type

If you want to search through data and have results updated on each keystroke, you probably won't think of Excel. But all your data is in...

Excel's LET function is on the Rise

Coding complex Excel formula with the new LET function is an utter joy - and that's just one of the many reasons to use this most elegant...

Solved | Can't save workbook macro-free

How to overcome the Excel message, "The following features cannot be saved in macro-free workbooks".

Five 'Running Total' Methods

Five different ways to create running totals in Excel - for five different situations.

Excel Tables - How and Why

Excel Tables present data professionally, make formula easy to understand, and help maintain spreadsheets as they grow. This tutorial...

Discussion and Problem Solving