Need Recommendations from Experts on Books for Pivot Tables - Please Read Description

Frank650

New Member
Joined
Oct 13, 2014
Messages
16
Hi,

I'm trying to find a publication that has a lot of course work in it. The book I'm using now teaches a lot of concepts but there are so few practice exercises that I end up forgetting a lot of the material.

Many years ago I took a course on Visual Basic, the book the instructor gave us was very different from what you buy in stores. Every chapter had 30-50 exercises, it was virtually impossible not to learn the material, is there an equivalent on the subject matter of pivot tables?
 

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.
Frank650,

See if any of the below links will help you:

Pivot Intro
Using Pivot Tables and Pivot Charts in Microsoft Excel

Office 2010 Class #36: Excel PivotTables Pivot Tables 15 examples (Data Analysis) - YouTube
Office 2010 Class #36: Excel PivotTables Pivot Tables 15 examples (Data Analysis) - YouTube

Getting Started with Pivot Tables
http://www.contextures.com/xlPivot01.html#Start

Overview of PivotTable and PivotChart reports
Overview of PivotTable and PivotChart reports - Excel

Build a Pivot Table in Excel VBA
Excel VBA - Build A Pivot Table In Excel VBA Tutorials



The above information is from my most up to date list:

Training / Books / Sites as of 10/08/2014

http://www.mrexcel.com/forum/excel-...applications-merging-columns.html#post3961033
 
Upvote 0
Frank650,

Thanks for the feedback.

You are very welcome. Glad I could help.

And, come back anytime.
 
Upvote 0

Forum statistics

Threads
1,214,857
Messages
6,121,948
Members
449,056
Latest member
FreeCricketId

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top