You’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 MoreBack in the earlier days of personal computers, Excel (and other spreadsheet) applications used to be THE reason you’d by a PC. Just like today how a lot of people buy an XBox to play Rock Band, back then people bought PCs to use Excel – well at least businesses would. The ability to do on the fly customizable numeric calculations in an intuitive way transformed many industries and truly catalyzed the early personal computer markets. Complex financial modeling became commonplace and much quicker. It’s important to understand a little bit of this history because it brings the software to life and helps show how powerful and game changing spreadsheet software really was.
Read MoreAs we help people go through our Excel training, we work to make sure that we always explain the WHY. Context is exceptionally important. In this series, we'll go through the specifics on what's inside Excel Everest and why.
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 MoreWe’re going to cover concepts quickly, keep the number of concepts per video to an absolute minimum, and keep the videos as short as possible. Stay tuned on our blog (we’ll repost the videos here) or our YouTube channel for the latest!
Read MoreIn this Rapid Fire Excel Tutorial, we provide some tips for using the Microsoft Excel ribbon in Excel 2007 and Excel 2010 as efficiently as possible.
Read More