Dynamic List of Weekday Dates in Excel
Creating a Dynamic list of dates in Excel is pretty easy now with the use of the SEQUENCE function. Creating a dynamic list of weekday dates is a little bit more complex.
(more…)Padding Entries in Excel
Another post inspired by the book 101 Ready-to-Use Excel Formulas by Michael Alexander and Dick Kusleika. This one is Formula #22 and covers padding entries with zeroes.
(more…)Introduction to Dynamic Arrays Webinar Recording
Learn about the new way to create formula and functions in Excel. This webinar recording from April 2024 will get you started.
(more…)Significant Digits in Excel
This post is inspired by the book 101 Ready-to-Use Excel Formulas by Michael Alexander and Dick Kusleika. Formula #10 allows rounding to a certain number of significant digits. This post shows how to convert that formula into a custom function.
(more…)Excel Dynamic Arrays in April
April is Dynamic Array month. This month I ran 4 new live one hour webinars dedicated to all things Dynamic Arrays. Dynamic Arrays change the way you create and maintain formulas in Excel. They expand Excel's capabilities and make it even more flexible. All four webinars are now online courses that you can buy as part of the Dynamic Arrays 2024 Bundle for AU$60. PLUS you get access to future Dynamic Array sessions this year. As new Dynamic Array courses…
Excel Range Name Conventions
You can name parts of a spreadsheet and then use the name in formulas and other Excel features. Using a naming convention make things much easier to follow and adapt in the long run. I will share some suggestions for naming ranges.
(more…)Excel VBA – Please Don’t Do This
I recently read an Excel VBA book that recommended using numbers instead of VBA constants for message boxes. Please don’t do that. Here’s why.
(more…)