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 🙂
Save time using Excel Templates to upload to your accounting software – Part B Using Autofilter for bank entries
So this post is the 2nd part of my recent post on how Excel can automate data entry to your accounting system. See here for Part A. This example concerns automating
Using Excel Templates to upload to an accounting software – Part A The Cash Book
I have been putting off blogging about this topic because it’s unwieldy to explain and involves work done many years ago that I would do better now. I cringe a
Using INDEX to calculate a moving average dynamically
I have blogged before about how much I love INDEX (INDEX what’s the Big Deal ). It’s powerful, nimble (non volatile so easy on performance load) and just makes so
Toggle macro for hide & unhide columns
This is about macro I have used quite often in the last few years that achieves two things: a) toggles to hide or unhide columns set by the user and
Macro to Select All Formulas
I thought I would blog some handy personal macros I use day to day. This is the first and I will do others. This one simply is a macro to
Make Using Tables your New Year’s Resolution
Well it’s the Boxing Day holiday here in Aussieland 2017 and one of our traditions is watching the Test Cricket in Melbourne that always starts on Boxing Day. Fantastic stuff.
Business Model Renovation Macros Used
Further to my recent post this is one of the Business Model Renovation macros used in this project what I call one of my ‘quick and dirty’ but handy and
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
New Team Member at The Excel Factor
Update 2020 Bluey, about 4 years old Update 2020 Bluey, about 3 years old Bluey by now has had many adventures and a couple of close calls including a fight
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://theexcelfactor.com/using-array-constants-formulas-logic/ https://theexcelfactor.com/using-array-constant-list-formulas/ Also I often use SUMIFS
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
Organize data like an Excel Analyst
In past posts, I have talked about a ‘database’ approach or how an Excel data analyst approaches data in their spreadsheet work or financial modelling. I come from an accounting