Excel's deep, dark secrets.
Read MoreSo you’re running a moderately successful business selling medical equipment. There’s just one teensy-weensy problem – your otherwise high-performing employees are horrible at Microsoft Excel.
Read MoreMicrosoft Excel is the biggest, best and meanest spreadsheet software out there today, and that is a fact. But it’s far from perfect. This post is about things that I just wish Excel did – it is probably a little irrational of me to wish for them, as you will see, and it is probably asking for a little bit too much.
Read MoreThe COUNTIF function only counts those values in a range which match a condition within the formula – if the condition is not met, no counting.
Read MoreTurns out, there are a couple of functions in Excel that do nothing but return the number of rows and columns for a specified array. This turns out to be hugely helpful.
Read MoreLeft (the formula) lets you take a cell and extract a certain number of characters from the left. So, for example “=Left(A3,4)” would extract the first four characters out of whatever happens to be in cell A3.
Read MoreCheck out this amazingly creative use of Excel... making sure that you'll be warm on your vacation. And here you thought that going through Excel training would just make you better at work. :)
Read MoreThe “Cell” formula can take multiple arguments ans return a wide variety of information about the cell in question, unlocking all of it’s myriad mysteries.
Read MoreExcel has this formula called the SEARCH formula – all it does is look up a particular piece of text within another piece of text. So if you asked it to search for the letter ‘e’ in ‘text’, it would come up with the answer ’2′.
Read MoreThis Excel Everest scoreboard allows you and/or your manager to watch your progress as you climb Excel Everest. The charts and graphs below show how many and what percentage of the problems you’ve completed correctly in our Excel training.
Read MoreThere are plenty of great free (and cheap) resources online but they’re found all over the Internet. We’ve done some digging and shelved some of the ones we think are top-notch. Click on the logos below to visit the sites.
Read MorePrinting in Excel can be far more confusing than it needs to be. It's important to learn how to do this so that you're able to quickly move forward and show your results on paper.
Read More