Add a Currency Style to Pivot Data

Believe it or not, there is a correct way and an incorrect way, to turn on the Currency Style in a PivotTable!  I’m going to show you the best way, but I’ll also explain why it is the best way.


Can you believe you’re already at the third video!  No more than 15 minutes of your time and look at how much you’ve learned already!

PivotTables are one of the most sought after features in Excel and, like everything, they’re easy once someone shows you how.

As you know, my job as a training instructor is to show you how, but I also feel it’s much more than that.  It’s really important to me that you also understand the ‘why’.  I hope you’re picking up both the ‘how’ and the ‘why’ from these videos, but if you are going to use Excel on an ongoing basis then it’s really important to understand Excel in general as PivotTables are only one of many, many aspects of Excel.

Click to view course outlines

Take a look at our Excel course outlines, to see the many different items that are covered, within each course.

Hi, I'm Kelly!

Picture of Kelly


1 Month or 1 Year Access

Access a course for 1 Month or 1 Year  Download supporting files!

Excel Course – I really thought I knew Excel until I went on the course.  Lot’s of techniques to reduce time and effort.  Most enjoyable and well worth while. Thanks Kelly!
Mary R.
Excel Course – I now have a much better understanding of Functions and learned lots of shortcuts that will make my life easier. Definitely to be recommended.
John M.