Are you trying to get a distinct count in your values section of a Pivot Table? You know that by default the values section does a count of the values in the field you put there, but there's a way for you to get a distinct count. But it's an extra step. Check out the video to learn more.
Monday, October 16, 2023
Monday, October 2, 2023
How to do CAGR
Know what a CAGR is? It stands for Compound Annual Growth Rate and it shows the rate of return of an investment over a certain period of time as a percent. You'll see it a lot in business presentations or out the mouth of wall street types. It's a formula but there's a quick and easy function in Excel that will calculate it.
Monday, September 25, 2023
How to Add or Multiply Numbers in a Cell [No FORMULAS]
Quickly add multiply or do math on numbers in your table data with this tip. You don't need a helper column with a formula where you cut and paste and then delete the extra column. All you need is the value you want to do the calculation in a temporary location and use Paste Special to do the magic.
Subscribe to:
Posts (Atom)