The IF statement in Excel is a “logic” formula. Logic formulas in Excel let you choose to do something (perform a calculation, do a vlookup, input text, etc) based off criteria you specify.
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 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 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