Sep 30, 2020
Decisions made easily with Excel
So, we’re in Excel and we have to apply some conditional logic. Hopefully, you are familiar with the IF function. Basically we provide a condition that will evaluate to [...]
Sep 04, 2020
Rounding Numbers in Excel, Part 2
In Part 1 of this series I discussed the worksheet functions ROUND, ROUNDUP and ROUNDDOWN. They will truly round numbers to a certain number of decimal places. But what [...]
Aug 27, 2020
Rounding Numbers in Excel, Part 1
The first thing I’d like to point out about rounding numbers in Excel is that simply hiding decimal places isn’t true rounding; the decimal places are still there, just [...]
May 29, 2021
Recursive functions in VBA
In programming, you use functions for two purposes. You either want to reuse a piece of code over and over again, therefore you encapsulate it as a function, or you may [...]
Dec 16, 2020
Excel formulas are not just for numbers
I had a student recently say that she "didn't need to know formulas in Excel" as she "didn't work with financial spreadsheets." Formulas, however, do a lot more than [...]
Aug 05, 2020
Keep your Excel formulas in place with dynamic named ranges
So, you have developed an exciting formula somewhere that works perfectly by extracting some value from a specified range and you are quite proud of it. Then one day, [...]
Mar 10, 2021
Using custom fields to calculate GST in Microsoft Project
Microsoft Project allows you to customise fields for several purposes including; to save time, avoid typing errors, meet stakeholders' expectations and needs, warn you [...]
