My blog

My Blog page’s theme is to produce practical blog posts from my Excel consulting with large and small business clients from varied industries. These  topics include spreadsheet design, choosing a sound approach to an Excel based solution, learning from mistakes, VBA programing (or macros), Tables, Pivot Charts, Pivot Tables, advanced formulas, Pivot Query, PowerPivot, Excel User Forms, Excel data cleaning and manipulation, conditional formatting, user friendly features and more.

Hope you find them useful 🙂

Business Model Renovation

This blog post is about what I call a Business Model renovation which I call a workbook where the client won’t allow any major changes but I have to fix

Read More »

More Useful Array Constant Formulas

I have been recently blogging on Array Constants (see below links) and how useful they are for simpler, more maintainable and readable formulas. ttps:// Also I often use SUMIFS

Read More »

Excel Dialog Box Muddle

Do you find that some dialogs like the Name Manager and the Data Validation dialog mess you around when you edit or enter formulas?  I call this the Excel Dialog

Read More »