Left (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 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 MoreMacros bring Excel to life. Want to see how? Simply go to the index page of this tutorial and hit the fun button in the top right. See, Excel is alive! But don’t worry, they can be used for much more practical purposes than that. We'll show you how.
Read MoreKeyboard shortcuts exist to make your life easier, but are often overlooked in importance. Imagine that every time you pasted anything in Excel you didn’t use a keyboard shortcut and you pasted at least 20 times a day.
Read MoreHaving duplicates in your data can be a huge pain. Have you ever been in a situation where you have a big list of people but some are there twice, or even three times? When you’re working with large datasets, the problem of duplicates is bound to pop up and knowing the best way to get rid of them can help you enormously.
Read MoreKnowing how to take a list of your company’s usernames and quickly convert them into an email list that you can copy and paste right out of Excel and into your email program is an essential time saving skill.
Read More