Sorting 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 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 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 edition of Rapid Fire Excel we’ll cover some tips and tricks on using borders in Excel. A great approach to getting good, quickly, at using borders in Excel is simply highlighting a range of cells and hitting the Ctrl-1 shortcut and clicking on the borders tab. From there, simply play around, and see what you can do.
Read MoreIn this Rapid Fire Excel Tutorial, we’ll cover how to quickly combine text that’s in multiple cells into one cell by using the ampersand. This is incredible helpful in businesses. You'll rapidly learn how to utilize this function in your day-to-day.
Read MoreIn this Rapid Fire Excel Tutorial, we’ll cover using text to columns with the delimited setting. This is an incredible important Excel tool for chopping up data and making sure that you've got what you need out of your dataset.
Read More