We’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 MoreExcel's Paste Special is CTRL-V’s big brother, and boy does it pack a punch. In what’s to come, we’ll walk you through five things that Paste Special does in its own inimitable way. Try it out for yourself, and watch your productivity metrics zoom.
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 look quickly at how to turn the gridlines on and off in Excel. If you need to make an Excel file visually appealing, this is a fabulous way to start.
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 MoreIn this Rapid Fire Excel Tutorial, we’ll cover how to split up text using the fixed width setting of the text to columns data tool.
Read MoreIn this Rapid Fire Excel Tutorial, we’ll show you how to quickly select, add, and remove rows and columns using only keyboard shortcuts. You won't regret watching it. And as always, we promise to be brief.
Read MoreIf you need a set of Excel links to learn from, here's a great set that can get you going.
Read MoreWe all love Excel Vlookups. But what happens when they error. Here at Excel Everest we wondered if we should write a poem on them. Our conclusion? Yes, we should.
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 MoreWondering how to use the CountIF function in Excel. We've got your back. This incredibly powerful function can be a bit confusing at first. Learn it. You wont regret it.
Read More