Excel'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 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 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 MoreIn this Rapid Fire Excel Tutorial, we’ll cover paste special, one of the most power day-to-day tools in Microsoft Excel. 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 MoreExcel Power Users May Well Be Geeky, but you can’t accuse them of being boring! Presenting the first, and to our knowledge only, rap video about Pivot Tables in Excel.
Read More