Excel Tips
=SUM(B1:B5) is Better Than =B1+B2+B3+B4+B5 »
July 27, 2022
You have an intern working in the Accounting department who likes to add up short columns of numbers using =B1+B2+B3+B4+B5. You try to convince him that the correct formula is =SUM(B1:B5). He looks at you like you are insane, pointing out that his formula returns the exact same answer.
Add New Functions to Excel with Fast Excel SpeedTools Extras »
July 26, 2022
There are several add-ins that add new calculation functions to Excel. One of the best is from Charles Williams and FastExcel. The SpeedTools Extras package includes functions that accountants will use in everyday work.
Return Data from a Webservice »
July 25, 2022
Microsoft introduced three new functions in Excel 2013 that will return data from a webservice.
July 21, 2022
I need to spell out numbers in Excel, like on the old check writer machines.
Change from Lower to Upper Case in Excel »
July 20, 2022
I have data in lower case. I need to convert it to upper case.
Create a Bell Curve in Excel »
July 19, 2022
I need to generate a bell curve in Excel. The mean is 50 and the standard deviation is 12. (In the formulas below, substitute your real mean and standard distribution for the 50 and 12.)
See Formulas Next to the Answer »
July 18, 2022
I need to audit several formulas. I already know how to use Show Formulas mode, but I need something more permanent.
Fill Blanks With Value Above »
July 15, 2022
Someone set up data in an outline view. I need to sort by columns A, B, and C, so I need all of the blanks filled in.
Can Excel Track Negative Time? »
July 14, 2022
I keep track of comp time for employees. If employees work more than 8 hours, this time gets put into a bank so that they can work less time on another day. The company will generally let people go a few hours into the negative. But Excel completely freaks out when my formula results in a negative time.