Nonprofit.Courses Select by Lorman

Advanced Microsoft® Excel® PivotTables, by Lorman

Advanced Microsoft® Excel® PivotTables is brought to you by Lorman

You know the basics of PivotTables – now become a power user.

To be truly proficient in using PivotTables in Excel, you need to know more than just the basic techniques of creating PivotTables and switching the locations of fields. To better use the analytical power of PivotTable tools, you need to master the highly visual presentation tools available through the Slicer and Timeline features, learn the content expansion capabilities of calculated fields, calculated items, and custom calculations, create external formulas with the GETPIVOTDATA function, and also how to group data based on dates and times, as well as grouping by any criteria you wish. Other features, like drill-down (to see specific source data in a flash), Pivot Charts (instant visual support for numerical data), conditional formatting (accentuating results with icons and color variations) and grouping data on an ad hoc basis are also tools that enhance and expand the way you use this powerful feature.

See more content from Lorman by clicking here.

Affiliate disclaimer: This content may include affiliate links. That means when you buy it, Nonprofit.Courses earns a commission, at no extra cost to you. It’s a win/win. You get some great content, and we keep the lights on!
0 0 votes
Give it a rating!
Subscribe
Notify of
guest

This site uses Akismet to reduce spam. Learn how your comment data is processed.

0 Comments
Inline Feedbacks
View all comments