We looked through Excel’s capacious archives to come up with five formulas that won’t be used all that often.
Read More
So 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 More
The 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 MoreThe Excel transpose formula turns out to be one of those "must use" features in the software. Make sure to learn how it works so you can save time and energy down the road.
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 MoreDid you know that you can use Excel to calculate loan repayments? It's an incredible and unknown feature set that has real world implications. Learn more about how to make your life easier through this feature.
Read MoreThere's a little known feature in Excel that you simply must take advantage of: the auto list-building drag-down. It's an incredible tool that will save you time and energy as you learn Excel.
Read MoreExcel's Sumproduct formula allows you to take an array (an array is best thought of as data stored in more than one cell) that reposes in columns A, and multiply it with those in columns B. The sum of the individual products is what the Sumproduct formula returns. Here's how it works.
Read MoreEver wondered if it was possible to convert Roman numerals to Arabic in Excel? Well, you're in luck. It's definitely possible. Here we show you how.
Read More