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 🙂
So in my previous post I was banging on about the new Dynamic Array formulas only fairly recently released to Office 365 Excel. I reckon FILTER() is the star but
The new Dynamic Array formulas are now in Office 365 Excel! I have been playing around with some of them namely FILTER, UNIQUE and SORT which are awesome! Excel MVPs
You may get a laugh from this hilarious compilation from the IT Crowd’s recurring theme so many people working in IT can relate to … “have you tried turning it
Here is a quick but really useful coffee break dynamic sum formula tip. I used this handy INDEX + MATCH based formula the other day and thought it was a