Managing rows and columns well in Excel will save you lots of time. It is highly useful to be able to quickly select a row or column, move it, resize it, add or delete new rows or columns, and group and hide them. None of this is particularly difficult (there are actually no hard level examples in this section) but there are a few worthwhile tips and tricks to go through that will save you time.
Read MoreThe Text to Columns and Find and Replace functions in Excel are essential for cleaning data; ie, reformatting it, getting rid of errors, and/or extracting only the information you want. If you find yourself in a situation where you have, for example, first and last name in one column but you want two columns, one with first name and one with last, you’d use text to columns to accomplish this.
Read MoreSorting allows you to organize data in a way that makes it most useful for you. It's hugely important to learn how to sort in Excel. You won't regret it.
Read MoreGood Excel formatting can make or break your success communicating data, explaining the nuances to what you do, and ensuring that you're achieving your Excel learning objectives.
Read MoreYou’ve no doubt used copy and paste for countless computer tasks. You should never be using the mouse to do your copy, cut, or pasting. The keyboard shortcuts “Ctrl-X” (cut), “Ctrl-C” (copy), and “Ctrl-V” (paste) are absolute essentials and will save you time. If you don’t have those memorized, do so immediately! You won’t regret it.
Read MoreCells are where the magic happens in Excel. They store either text, numbers (in different forms), or formulas (use the “=” sign to indicate a formula). You need to understand the basic properties of Excel cells to fully grasp Excel.
Read MoreMicrosoft completely re-thought Excel with their release of Excel 2007. Users across the world who were familiar with previous versions of Excel sat down in their office chairs after purchasing the new version and clicked opened their shiny new software to find a foreign environment, a place where all the buttons were rearranged, new features were incorporated, charting was different, and pivot tables were unrecognizable. Though Excel 2007 takes some adjusting if you’re used to the previous versions, the new features in Excel 2007 are very slick and very powerful, and Microsoft patched up many problems in Excel 2003. It’s a solid upgrade.
Read MoreYou should learn Excel keyboard shortcuts. Hands down, doing so is one of the quickest routes to productivity around. I use keyboard shortcuts for inserting pivots, for creating charts, for inserting equations – for everything that you can think of, in short. In most cases, I don’t even have to look up at the screen to figure out there appropriate keyboard shortcut.
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 MorePart of working with massive Excel files is understanding all of the details and nuances inside a file. It can be easy to get confused. Excel Named Ranges feature makes this hugely easier.
Read MoreNeed to better understand how to use Excel Paste Special? We've got you covered. It's a powerful feature that you're going to grow to love.
Read More