
How to enter same Formula in multiple cells?
As you probably know, there are a TON of ways to copy or fill formulas. I am going to show you the technique that works best when you already have… Read more »
As you probably know, there are a TON of ways to copy or fill formulas. I am going to show you the technique that works best when you already have… Read more »
Here’s a nifty little trick I use every day while working in Excel. It’s a two part trick. Part one will be selecting all the blank cells in a range… Read more »
On many occasions and in many dashboards, time will be the main factor of your analysis and reports. As far as time goes, you can do a Yearly, Quarterly, Monthly,… Read more »
It can be used as a ‘wrapper’ to hide many different errors; #DIV/0, #NAME?, #NULL, #NUM, #REF, #VALUE, and one of the most common being VLOOKUP’s #N/A error. In this… Read more »
This post will talk about the way that Excel sorts data and the Case Sensitive sorting it offers. If we look at this data And sort it in ascending order… Read more »
Almost everyone uses Excel in some form or fashion in the modern workforce, but many of us may be wasting a little too much time trying to format those pesky… Read more »
Scroll bars or Sliders on an Excel Chart are a great addition if you are building interactive Excel Reports and Dashboards. This guide will walk you through the steps in… Read more »
SUM, COUNT, AVERAGE SUM allows you to sum any number of columns or rows by selecting them or typing them in, for example, =SUM(A1:A8) would sum all values in between… Read more »
Most of us are probably familiar with Excel, but not knowing the shortcuts and tricks can turn any simple spreadsheet into a long drawn-out process. We have put together some… Read more »
Suppose you receive a spreadsheet with calculations, but the calculations are stored as text, for display purposes only, and not used to actually derive answers. Without wanting to reinvent the… Read more »