When you print a pivot table, arrange value fields vertically, so it's easier to read Read more 👉 lttr.ai/AgTJ8

In a pivot table, you can create a new field that performs a calculation on the sum of other pivot fields, using your own formulas. Read more 👉 lttr.ai/AgVY4

How to make an Excel Pivot Table calculated field using a count Read more 👉 lttr.ai/AgVeE

In this example however, the new data was incomplete, and I didn't want to paste blank cells -- only the cells that contained data. Read more 👉 lttr.ai/AgVmi

Quickly filter Microsoft Excel Pivot Tables with Slicers. They make it easy to change one or more pivot tables with a single click ▸ lttr.ai/AgVod

Excel data validation tips and troubleshooting ▸ lttr.ai/AgWoN

How to create named tables in Excel, and fix table problems Read more 👉 lttr.ai/AgXLE

See how to set up a dependent drop-down list in Excel, based on the value in another cell Read more 👉 lttr.ai/AgXXc

How to install and use Excel add-ins Read more 👉 lttr.ai/AgYnD

Quickly add your Microsoft Excel macros to buttons and drop down lists on a custom Excel Ribbon tab. Read more 👉 lttr.ai/AgYnE

See how to count specific items in an Excel list, using formulas for exact or partial matches Read more 👉 lttr.ai/AgYnF

Get this free Excel golf tee off times workbook, to choose player tee off times for golf tournaments, or for daily players at a golf course Excel Golf Tee Off Times: lttr.ai/AgYnG

Excel Annual Cost Calculator ▸ lttr.ai/AgYnH

Create a Data Validation drop down list that lets people add new items, when needed! ▸ lttr.ai/AgYs9

The following 2 macros will sort all the Row fields in the selected pivot table, based on the values in the "Sum of Total" field. Read more 👉 lttr.ai/AgYtL

How to compare years in an Excel pivot chart lttr.ai/AgYtN

If you don't know anything about Excel VBA, where should you start? Read more 👉 lttr.ai/AgYtP

How to fix the problem when a named Excel Table does not expand automatically, if you add new data at the end of the list. Read more 👉 lttr.ai/AgYtV

Show text in the Pivot Table Values area, by using conditional formatting and custom number formats. Set this up manually or with a macro. Read more 👉 lttr.ai/AgYtY

Use Excel formulas to count specific text in a cell Read more 👉 lttr.ai/AgYta