Using Microsoft Excel is something that people either LOVE or HATE. And the only difference between those two kinds of people is whether you understand it or not. Let’s pretend you’re the owner of SellingCoolStuff Pty Ltd and you have four salespeople who work for you: Bob, Jane, Mary and Fred, and you want to […]
Excel Magic – the Payment Function (PMT)
I will assume most of us have had a loan or mortgage or, if not, you’ve probably at least contemplated one. You know the drill. You see something you like on realestate.com, head to the slick calculators on the website of your chosen financial institution and either give yourself a fright or leave wondering about […]
Shhhh, Secret Excel Business…
In our previous article, we discovered how to create the Perfect Formula – Every Time. Now we are going to investigate the rules behind how Excel calculates these results. OK before we start, here’s a Pop Quiz! Question: The formula below, 3 + 2 x 9 = Answer: Would the answer be A or […]
7 Steps to Create the Perfect Formula, Every Time!
In the previous edition of The Dossier, we debunked the Excel Myth: “… to be skilled at using Excel, you must be a math head”. Now I will share with you, my proven recipe for creating the perfect formula – every time. The recipe works no matter whether the formula is simple or complex. Secret […]
Excel’s Hidden Gem
Having taught Excel (and all the Office apps) as a corporate trainer for over 20 years, the application that shot fear into the heart of more people than any other was Excel. It is still this fear that stops people from using this awesome application. You have to be a math head to be able […]