The most basic example of a GETPIVOTDATA formula in Microsoft Excel is when the function is used to retrieve a grand total of ...

At the sheet level, conditional running totals require focused expressions, but an Excel PivotTable requires only a few field swaps. Susan Harkins shows you how.

Need to know your organization's YOY results? Susan Harkins will show you how to make a PivotChart in Microsoft Excel.

Excel's PivotTable feature is a fantastic option for data analysis, allowing users to consolidate and analyze data from various sources in a single, ...

This tutorial will show you how to create a Formula to Add, Subtract, Multiply or Divide in Microsoft Excel. You can do basic calculations easily!

One of Excel’s greatest tricks is the dimensional or 3D reference. This feature, which allows you to create formulas that refer to the same cell or range on multiple worksheets, simplifies the ...

How to Create a Formula for Income & Expenses in Excel. Income and expense spreadsheets can be useful tools to help you see where your personal or business finances stand.

Excel macros are like mini-programs that perform repetitive tasks, saving you a lot of time and typing. Here's everything you need to know to start programming macros yourself.