Could someone here give me a few examples of pivot tables that I can work out as practice with total and subtotal? Would like intermediate level please. I'd appreciate it.
No offense but I'm highly confused by your suggestion. The link does not contain any exercises to work out problems. It just provides samples with data, nothing more.
you can use this data information to create your own pivot table/s with totals and subtotals, the best way i find to learn anything is to start at the beginning and in this case it is with the data. A simple web search will give you access to loads of training materials / instructions specific to your own requirements.
The site i gave you above has links to specific types of Pivot functions so i would start there.
I have updated the link below to the Pivot material. Pivot
you can use this data information to create your own pivot table/s with totals and subtotals, the best way i find to learn anything is to start at the beginning and in this case it is with the data. A simple web search will give you access to loads of training materials / instructions specific to your own requirements.
The site i gave you above has links to specific types of Pivot functions so i would start there.
I have updated the link below to the Pivot material. Pivot
Appreciate the reply. But whats the point in creating pivot tables if theres no source for practice exercises?
A "simple" web search to finding exercises is far from simple. I've been seeing people on a few forums asking for actual practice exercises and none have been provided which is weird af.
Also your updated link ONLY provides tutorials NOT exercises.
Appreciate the link but again theyre tuts NOT actual exercises.
I'll explain what I mean by exercises. First thing, tuts are NOT exercises. Exercises are where a question is asked on solving a problem and you WORK OUT the problem WITHOUT a "tutor" or "tutorial" guiding you towards the answer. Hope this helps you understand what I'm looking for. Looking forward to your reply
Sorry I forgot to get back to you.
I understand what you mean but without enrolling in a course they are bit hard to come by.
I think any tutorial that provides the files will work for what you want, you just need to think about it differently.
Normally with an Exercise.
You get the question
You get some sample data
You solve the problem
You normally also want the solution so you can check your work and see if there was a better way
Most tutorials provide all 4 of these just in a different order.
Read the very start of the tutorial or section of the tutorial - it will give you the question
Do not read the tutorial or watch the video just download the file - you will have your sample data
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.
