Thank you for this wonderful series. I have a doubt. If i created the pivot table and i come to know that i missed a transaction, so after i add the missing transaction in the main table, does the same update in the pivot table also or do i have to create a new pivot table?.
Thanks for the video. Is there a way I could easily swap the data from two cells with a keyboard short? For example I have 'apple' in cell A1 and 'Orange' in cell A2. I want to swap the two so 'apple' is brought into A2 and Orange to A1. I don't want to have to cut and paste. Thank you
I'm working with a large pivot table containing multiple types of data (sales numbers, revenue, cost etc). Is it possible to switch between these types of data quickly in Excel 2007?
Ideally, I'd like to have a dropdown list through which I can choose which data I want displayed in the pivot table. But unfortunately, these lists only seem to be possible for selecting filters for rows/colums.
@diedikkeuitdejury hey i know how to do that but it doesn't use pivot tables. Pivot tables are all very well but to get really powerful data analysis and customization you need to get down & dirty with some CSE formula (control shift enter) AKA array formula.
I build tables made up of CSE formula when I want serious analysis setup and use pivots when its a quick fix. That drop down list you want could simply be made using data validation. If you would like to know more then message me.
Hi ExcelIsFun. Just a quick question. I am trying to practice the pivot tables. I imported my credit card transactions from the internet to excel. When I try to group the dates as you did in this video, it tells me "cannot group that selection" Do you know what I could be doing wrong or how to solve the problem? Thanks in advance
I love all the Excel tutorials by ExcellsFun! You really make Excel seems a lot more exciting and useful! Have learnt so much from you! Really appreciate these awesome tutorials! So clear, concise and interesting! Didn't realise there is so much Excel can do! Thank You!
This is great -thanks! I wish I had know about pivot tables when I was doing a statistical analysis of all the hunting units, seasons etc in the state. This would have been a lot quicker.
hey after creating the pivot table,i want to total certain selected items and show them separately in the same excel sheet ,how can we do it , is it possible ?
Let's say I have a list of 'ages' in my table. I add the 'ages' to my report filter but the report filter only shows the ages individually as they appear in the table. I want the report filter to show the ages in ranges instead, for example: 20-29, 30-39,....etc instead of individual values. How do I do this? Please help!
Great Videos! One question- In 6:22 when you drag “Region” down to the “rows label” in that pivot fields list, you get 3 columns but I only get 2. My year and months are on the same column. Where it should be saying “Sum of Sales” it says “Row labels” instead. I’m trying to figure it out? I followed all your steps. Help? Thanks so much
The video shows the field list on the right (Excel 2007) and then the pivotTable area, which has the pivotable options shown as Excel 2003) - so to match what you see in the video, drag and drop the fileds just as you see in the field list (right side) - then you should be able to get it to look like in the video.
Thank you very much for this video. I have a job interview and I need to learn how to do pivot tables. I always had them in my mind as being really complex because I have heard how powerful they are. Like you say in the video they are really simple and easy to learn how to do. Thanks very much. I feel prepared now. 8¬D
in this video u said dont press ctrl +1 to format cells of pivot table , can u please explain a litllte bit more why? because i tried ctrl +1 and it is working fine and also i copied and pasted it to other sheet and it retained that format that is y i m little bit confuse about it thanks!
Ctrl + 1 formats the cells, and if the PivotTable moves and uses different cells, then the Field does not know to move the formatting. However, if you use the Field Settings dialog box, the Field knows that it is formatted and when you Pivot the PivotTable, the formatting moves also.
Thank you. Very helpful. Before I was afraid of Excel. Now, since I've been following your classes I feel confidence of handle a lot of data using Excel. Thank you !
Thanks for this. I think this one lesson covers alot, but I think once you get comfortable with the first basic pivot table, you can go more into the fancy, like the group options, dates in front., etc. Many companies though, refuse to go to 2007, and are staying with 2003 Office Suite!
This is the best instruction of Excel ever. I spend several hours to learn the "Excel Is Fun!" on your website. And I believe it will save me thousands of hours in my future work. Very very good instructor! Good luck forever!
You are really the best and the way you teach is much more easy than some intructor! I am very green at Pivot table. Have a question for you.
How do you trend the dates? example: you have service date and invoice creation date and want to know the lag time between the two? Appreciate your help.
If there is only 1 service date & invoice creation date for each category in row label area, then you could create formula in pivottable, but that is risky cuz if you pivot the pivot table and more than one time is in a category, you may get a combined calculation. Why not just do it with formula in the original data set? Add a column & subtract one date from the other. I am not sure about how your data is set up though. You might also try posting to this site: mrexcel[dot]com/forum
Wow, I have never imagined Pivot Table to be so easy. I also didnt know that there is an excel function for these kinds. I have spent hours and hours in the office just to get the same result. Now that i know how to use Pivot table, it'll only take me minutes. THANK YOU SOOOOOO MUCH!!!!!!
small question, does 07 automatically update the changed values from the pivot table? I've had an 03 version that showed that it was problematic in the past. Great Vid btw
I tried to try create a pivot talbe from your EXELbasic._xls file, but I alway get a Data Source Reference is not valid. could you let me know why? Thanks!
I am working with a spreadsheet that has monthly data sales figures. I am trying to compare data from year to year displaying numbers for each year and a Year over Year column as well. Can someone help me with this as I forgot how I did it and now my pivot table is corrupted.
Thank you for this pivot table tutorial. I've read books on this and still didn't couldn't get it. It was lot easier than I thought, and the group option makes a lot more easier to read. Best excel tutorial out there. Thanx again.
Am I right in saying that adding a column to a table won't show up on an already-existing PivotTable Field List? You have to make a new PivotTable with the new table?
If you set your data table up as an 'Excel Table', then all you have to do is right-click the PivotTable and point to 'Refresh'. See this video:
YouTubersLoveExcel#25: Dynamic Range for Pivot Table & Chart
If you do not have data set up as an 'Excel Table', then in Excel 2007 / 2010 you have to go to PivotTable Tools Options ribbon and click on the 'Chnage Data Source' button. In earlier versions, go to the PivotTable wizard and in step 2 change data source.
Why do you not use Ctrl+1 to change the cell format of the Pivot Table? I've tried moving the table around after using Ctrl+1 and the format (e.g. currency) still remains. Thanks
Great pivot table demonstration as are all of your videos. I set up several pivot tables for analysis of the upcoming fiscal 2011 budget for our county's hospital district and the boss loves it. I LOVE pivot tables. Thanks for all you do.
GOD! you are just amazing SIR! i am big fan of you and MR. Excel
ishaq79 1 month ago
@ishaq79 , I am glad that the videos help!!
ExcelIsFun 1 month ago
Hello Sir,
Thank you for this wonderful series. I have a doubt. If i created the pivot table and i come to know that i missed a transaction, so after i add the missing transaction in the main table, does the same update in the pivot table also or do i have to create a new pivot table?.
Regards,
Varun
parkalvarun 1 month ago
@parkalvarun , rightclick PT and point to Refresh
ExcelIsFun 1 month ago
Can you show me how to do Matrix calculations in Excel
navylaks2 2 months ago
wow, you managed to make the world's MOST boring subject really interesting lol, so enthusiastic
iRyanww 2 months ago 2
@iRyanww , I am glad that you like it!!
ExcelIsFun 2 months ago
This has been flagged as spam show
Hi,
Thanks for the video. Is there a way I could easily swap the data from two cells with a keyboard short? For example I have 'apple' in cell A1 and 'Orange' in cell A2. I want to swap the two so 'apple' is brought into A2 and Orange to A1. I don't want to have to cut and paste. Thank you
maralghawsi 4 months ago
Awesome video!
Just one quick question:
I'm working with a large pivot table containing multiple types of data (sales numbers, revenue, cost etc). Is it possible to switch between these types of data quickly in Excel 2007?
Ideally, I'd like to have a dropdown list through which I can choose which data I want displayed in the pivot table. But unfortunately, these lists only seem to be possible for selecting filters for rows/colums.
diedikkeuitdejury 5 months ago
@diedikkeuitdejury , I do not know how to do that. Try:
mrexcel [dot] com/forum
ExcelIsFun 5 months ago
@diedikkeuitdejury hey i know how to do that but it doesn't use pivot tables. Pivot tables are all very well but to get really powerful data analysis and customization you need to get down & dirty with some CSE formula (control shift enter) AKA array formula.
I build tables made up of CSE formula when I want serious analysis setup and use pivots when its a quick fix. That drop down list you want could simply be made using data validation. If you would like to know more then message me.
Jamesedwardkoch 3 months ago
@Jamesedwardkoch , thanks! I already have 100s of videos on CSE formulas that do data analysis. Check out:
youtube [dot] com/excelisfun
ExcelIsFun 2 months ago
Hi ExcelIsFun. Just a quick question. I am trying to practice the pivot tables. I imported my credit card transactions from the internet to excel. When I try to group the dates as you did in this video, it tells me "cannot group that selection" Do you know what I could be doing wrong or how to solve the problem? Thanks in advance
Astroboy25 5 months ago
@Astroboy25 , there may be a blank cell, or the dates are stored as text. It can't group if there are blanks or dates as text.
ExcelIsFun 5 months ago
Wow, you are simply the best!! Thanks for all the videos!! They are amazing!! :-)
Astroboy25 5 months ago
@Astroboy25 , you are welcome for all the videos!
ExcelIsFun 5 months ago
Great tutorial! Thanks for taking the time to add tutorials...
cardenasadi 6 months ago
@cardenasadi , you are welcome!
ExcelIsFun 5 months ago
I cant find the workbook ! where is it?
sexykarito 7 months ago
people.highline.edu/mgirvin/ExcelIsFun.htm
ExcelIsFun 7 months ago
Fantastic Videos!
buzguy10 7 months ago
I am glad that you like them!
ExcelIsFun 7 months ago
I love all the Excel tutorials by ExcellsFun! You really make Excel seems a lot more exciting and useful! Have learnt so much from you! Really appreciate these awesome tutorials! So clear, concise and interesting! Didn't realise there is so much Excel can do! Thank You!
jennyzbz 8 months ago 2
I am glad that the video helps!
ExcelIsFun 8 months ago
This is great -thanks! I wish I had know about pivot tables when I was doing a statistical analysis of all the hunting units, seasons etc in the state. This would have been a lot quicker.
7BroncoBoy 9 months ago
You are welcome!
ExcelIsFun 9 months ago
Great tutorial! thank you!
Iaradorgan 10 months ago
You are welcome!
ExcelIsFun 10 months ago
great tutorial!!!! thanks
petrussola 10 months ago
I am glad the video helped!
ExcelIsFun 10 months ago
thanks
lera5266 10 months ago
You are welcome!
ExcelIsFun 10 months ago
These lesson are just great!
muiseec 10 months ago
You are welcome!
ExcelIsFun 10 months ago
also while creating a pivot table, how can we show min of some value and max of sum value,please help..
5132abcd 10 months ago
working 80+ hours a week. no time... try:
mrexcel[dot]com/forum
ExcelIsFun 10 months ago
@ExcelIsFun thanks will try it
5132abcd 10 months ago
hey after creating the pivot table,i want to total certain selected items and show them separately in the same excel sheet ,how can we do it , is it possible ?
5132abcd 10 months ago
working 80+ hours a week. no time... try:
mrexcel[dot]com/forum
ExcelIsFun 10 months ago
This has explained the PivotTables once and for all for me. Now if I only knew a PivotTable is what I need or not...
julianreischl 11 months ago
Hi there! Is there any formula to erase the '#DIV/0!' or '#VALUE!' in the pivot table?
blowyourmindset 11 months ago
Right-click, PivotTable Options, on Layout & Format tab Check "For error values hsow"
ExcelIsFun 11 months ago
@ExcelIsFun Thanks! You are very EXCELlent!
blowyourmindset 11 months ago
Just wanted to say thank you! I feel super confident about pivot tables!
harrysanghain 11 months ago
You are welcome!
ExcelIsFun 11 months ago
Let's say I have a list of 'ages' in my table. I add the 'ages' to my report filter but the report filter only shows the ages individually as they appear in the table. I want the report filter to show the ages in ranges instead, for example: 20-29, 30-39,....etc instead of individual values. How do I do this? Please help!
PlayMoreLoud 11 months ago
The trick is to drop the Age in the row labels, then grop while it is in the row label, then drag it to the Report Filter.
That should do it!
ExcelIsFun 11 months ago
The trick is to drop the Age in the row labels, then group while it is in the row label, then drag it to the Report Filter.
That should do it!
ExcelIsFun 11 months ago
@ExcelIsFun Thanks! You're a life saver. It strikes me as an obscure way of doing it. I think they should make this type of function much simpler.
PlayMoreLoud 11 months ago
I am glad that the video helps!
ExcelIsFun 11 months ago
Great Videos! One question- In 6:22 when you drag “Region” down to the “rows label” in that pivot fields list, you get 3 columns but I only get 2. My year and months are on the same column. Where it should be saying “Sum of Sales” it says “Row labels” instead. I’m trying to figure it out? I followed all your steps. Help? Thanks so much
MuffinTops388 1 year ago
The video shows the field list on the right (Excel 2007) and then the pivotTable area, which has the pivotable options shown as Excel 2003) - so to match what you see in the video, drag and drop the fileds just as you see in the field list (right side) - then you should be able to get it to look like in the video.
ExcelIsFun 1 year ago
Comment removed
scotthallto 1 year ago
Go to this web site and watch the auto play video, it shows how to get to all the files:
youtube[dot]com/user/excelisfun
ExcelIsFun 1 year ago
Comment removed
scotthallto 1 year ago
Comment removed
scotthallto 1 year ago
This has been flagged as spam show
thanks so much. like the trick on date
sunflowerseed0309 1 year ago
thanks so much. like the trick on date
sunflowerseed0309 1 year ago
Me too - The Date Trick is very powerful!
ExcelIsFun 1 year ago
Thank you very much for this video. I have a job interview and I need to learn how to do pivot tables. I always had them in my mind as being really complex because I have heard how powerful they are. Like you say in the video they are really simple and easy to learn how to do. Thanks very much. I feel prepared now. 8¬D
EdwardsAbacus 1 year ago
I am glad it helped!
ExcelIsFun 1 year ago
in this video u said dont press ctrl +1 to format cells of pivot table , can u please explain a litllte bit more why? because i tried ctrl +1 and it is working fine and also i copied and pasted it to other sheet and it retained that format that is y i m little bit confuse about it thanks!
grmzubair 1 year ago
Ctrl + 1 formats the cells, and if the PivotTable moves and uses different cells, then the Field does not know to move the formatting. However, if you use the Field Settings dialog box, the Field knows that it is formatted and when you Pivot the PivotTable, the formatting moves also.
ExcelIsFun 1 year ago
@ExcelIsFun thx a lot sir
grmzubair 1 year ago
very informative.... thanks!
mackmickmatt3 1 year ago
You are welcome!
ExcelIsFun 1 year ago
Thank you. I found it...
Yohasakura2005 1 year ago
EXCELlent!!!
ExcelIsFun 1 year ago
Is there a workbook for this one? Somehow I couldn't find it.
Yohasakura2005 1 year ago
Search for "excelisfun", then click on the channel link, then watch the auto play video - it shows how to download the workbooks.
ExcelIsFun 1 year ago
I am happy to hear that you love them!
ExcelIsFun 1 year ago
Excellent video!!
beto02k 1 year ago
I am glad that you like it!
ExcelIsFun 1 year ago
Thank you. Very helpful. Before I was afraid of Excel. Now, since I've been following your classes I feel confidence of handle a lot of data using Excel. Thank you !
vzlano34 1 year ago
You are welcome!
ExcelIsFun 1 year ago
Thank u!!!! this video is sooo helpful :)
xzcutiezzx 1 year ago
You are welcome!
ExcelIsFun 1 year ago
i really enjoyed your lesson! thanks!
MrPurplevolleyball 1 year ago
You are welcome!
ExcelIsFun 1 year ago
man, you are so cool!)))thank you so much!
OldManHerbert100 1 year ago
You are welcome!
ExcelIsFun 1 year ago
Thanks Man! Respect :)
marajaie 1 year ago
You are welcome!
ExcelIsFun 1 year ago
Awesome mate that was really helpful!
Ta from Australia...
shhanouq 1 year ago
I am glad that you like it!
ExcelIsFun 1 year ago
You are welcome!
ExcelIsFun 1 year ago
Excellent!!!
shanees001 1 year ago
Thanks for the EXCELlent comment!
ExcelIsFun 1 year ago
i can not find the file on the link provided
ed2m 1 year ago
It is the file at the very top -- Excel Basics.
ExcelIsFun 1 year ago
Best video tutorial out there! Thank you and may God/Allah/Yahweh bless you...
TheLibraMo 1 year ago
You are welcome!!
ExcelIsFun 1 year ago
Wicket awsome super helpful video's, and a very friendly helpful dude!
jmister22 1 year ago
PivotTables do rock! I am glad that you like it!
ExcelIsFun 1 year ago
bruupppp :) you are cool man.. thanks for your share ;)
Deliiiii 1 year ago
You are welcome!
ExcelIsFun 1 year ago
Great tutorial. I'd like to see your othere lessons in sequence. 1-19.... Where do I find them? Thanks!
overtheline1 1 year ago
Search for this video title and then watch it:
excelisfun Search & Find Excel Videos, Playlists, Download Excel Workbooks
ExcelIsFun 1 year ago
Wow....this is great! Thanks so much!
MarshaT754 1 year ago
You are welcome!
ExcelIsFun 1 year ago
Thanks for this. I think this one lesson covers alot, but I think once you get comfortable with the first basic pivot table, you can go more into the fancy, like the group options, dates in front., etc. Many companies though, refuse to go to 2007, and are staying with 2003 Office Suite!
ObiWan346 1 year ago
You are welcome!
ExcelIsFun 1 year ago
This is the best instruction of Excel ever. I spend several hours to learn the "Excel Is Fun!" on your website. And I believe it will save me thousands of hours in my future work. Very very good instructor! Good luck forever!
steviori 1 year ago 2
Saving thousands of hours at work is why i post the videos!!
ExcelIsFun 1 year ago
Great instruction! I've watched a lot of videos and these are very clear. Thanks a bunch!
jlynnkarpins 1 year ago
You are welcome!
ExcelIsFun 1 year ago 2
You are really the best and the way you teach is much more easy than some intructor! I am very green at Pivot table. Have a question for you.
How do you trend the dates? example: you have service date and invoice creation date and want to know the lag time between the two? Appreciate your help.
lk89mask 1 year ago
If there is only 1 service date & invoice creation date for each category in row label area, then you could create formula in pivottable, but that is risky cuz if you pivot the pivot table and more than one time is in a category, you may get a combined calculation. Why not just do it with formula in the original data set? Add a column & subtract one date from the other. I am not sure about how your data is set up though. You might also try posting to this site: mrexcel[dot]com/forum
ExcelIsFun 1 year ago
i am speechless. This is realy the best of the best learning video on the youtube site.
I have spent hours maybe days in the office and at home just to get the same result.
THANK YOU VERY VERY MUCH FOR THIS VIDEO..
tooxowcade 1 year ago
You are welcome!
ExcelIsFun 1 year ago
Thanks for the videos again, Sir. :)
aman1245singh 1 year ago
You are welcome!
ExcelIsFun 1 year ago
Wow, I have never imagined Pivot Table to be so easy. I also didnt know that there is an excel function for these kinds. I have spent hours and hours in the office just to get the same result. Now that i know how to use Pivot table, it'll only take me minutes. THANK YOU SOOOOOO MUCH!!!!!!
friedwanton 1 year ago
You are welcome so much!!
ExcelIsFun 1 year ago
thank you so much saved me a days work
keep up the good work
goodvibes03 1 year ago
You are welcome!
ExcelIsFun 1 year ago
@ Excellsfun.. You are the best!! You taught me something that I have been wanting to learn for years. Thank you! =)
MzResolute 1 year ago
You are welcome!
ExcelIsFun 1 year ago
Absolutely Wicked. Thank you!
RSLweblog 1 year ago
I am glad that you like them!
ExcelIsFun 1 year ago
your video is awesome!!!
mymiracle4ever 1 year ago
You are welcome!
ExcelIsFun 1 year ago
I'm having trouble downloading the videos for future reference.. I have realplayer downloader installed
Vklinge 1 year ago
I am not sure how YouTube does downloads. Try doing a Google serach - I think there is some good info there.
ExcelIsFun 1 year ago
@ExcelIsFun I was able to rectify the issue. These are great videos and your workbooks are awesome! Just what I needed.
Vklinge 1 year ago
I am glad that they helped!
ExcelIsFun 1 year ago
small question, does 07 automatically update the changed values from the pivot table? I've had an 03 version that showed that it was problematic in the past. Great Vid btw
ithnkurcute 1 year ago
No. For all Pivot Tables if you want to update, you have to right-click in Pivot Table and point to Refresh.
ExcelIsFun 1 year ago
this presentation is exactly what i needed. AMAZING
ysadstore 1 year ago
I am glad that it helped!
ExcelIsFun 1 year ago
cheers mate very helpful
bigyawn2 1 year ago
the video stops at 05:23?
21sweetcaramel 1 year ago
YouTube does that sometimes, you just have to try back later.
ExcelIsFun 1 year ago
YouTube does that sometimes. You have to try the video later.
ExcelIsFun 1 year ago
I tried to try create a pivot talbe from your EXELbasic._xls file, but I alway get a Data Source Reference is not valid. could you let me know why? Thanks!
chenshan69 1 year ago
Send file to: excelisfun at gmail and I will take a look at the file and see what is going on.
ExcelIsFun 1 year ago
I am working with a spreadsheet that has monthly data sales figures. I am trying to compare data from year to year displaying numbers for each year and a Year over Year column as well. Can someone help me with this as I forgot how I did it and now my pivot table is corrupted.
acopper57 1 year ago
I will make a video tomorrow! Do you know how to use the excelisfun channel to get the latest posted video?
ExcelIsFun 1 year ago
@acopper57 Just figured it out, thnx, never knew that was there.
acopper57 1 year ago
EXCELlent!!
ExcelIsFun 1 year ago
@acopper57
acopper57 1 year ago
Thank you for this pivot table tutorial. I've read books on this and still didn't couldn't get it. It was lot easier than I thought, and the group option makes a lot more easier to read. Best excel tutorial out there. Thanx again.
carlosgrana 1 year ago
You are welcome!
ExcelIsFun 1 year ago
hi mike, i cant find the workbook that match this video.
on the link to the workbbooks i downloaded the file excelbasics.xls and it isn't the same file you use here.
thanks....
gidozel 1 year ago
very helpful!
KaroBarca7 1 year ago
I am glad that it helped!
ExcelIsFun 1 year ago
Am I right in saying that adding a column to a table won't show up on an already-existing PivotTable Field List? You have to make a new PivotTable with the new table?
kaliylcule 1 year ago
If you set your data table up as an 'Excel Table', then all you have to do is right-click the PivotTable and point to 'Refresh'. See this video:
YouTubersLoveExcel#25: Dynamic Range for Pivot Table & Chart
If you do not have data set up as an 'Excel Table', then in Excel 2007 / 2010 you have to go to PivotTable Tools Options ribbon and click on the 'Chnage Data Source' button. In earlier versions, go to the PivotTable wizard and in step 2 change data source.
ExcelIsFun 1 year ago
nice thanks
bahodito 1 year ago
You are welcome!
ExcelIsFun 1 year ago
u r just amazing man...thnx!
PinjolliFundit 2 years ago
You are welcome!
ExcelIsFun 2 years ago
I am glad that you like them!
ExcelIsFun 2 years ago
Why do you not use Ctrl+1 to change the cell format of the Pivot Table? I've tried moving the table around after using Ctrl+1 and the format (e.g. currency) still remains. Thanks
kaliylcule 2 years ago
Because formatting done through Value Field Settings is more permanent and thus formatting remains when you "pivot".
ExcelIsFun 2 years ago
Thanks :-)
kaliylcule 2 years ago
You are a great teacher much better explained than any books or instuctors I have ever come across
newman785 2 years ago
I am glad the video helps!
ExcelIsFun 2 years ago
THANK YOU!! Explained much better than my teacher!
zhangdating 2 years ago
I am glad that it helped!
Here is another video title I made:
Highline Excel Class 20: Pivot Tables 20 Examples
ExcelIsFun 2 years ago
Great pivot table demonstration as are all of your videos. I set up several pivot tables for analysis of the upcoming fiscal 2011 budget for our county's hospital district and the boss loves it. I LOVE pivot tables. Thanks for all you do.
PrimevalRudy 2 years ago
You are welcome!
ExcelIsFun 2 years ago
PivotTables do help people get jobs!
ExcelIsFun 2 years ago
excellent video
mianegroup 2 years ago
EXCELlent!!!!
ExcelIsFun 2 years ago
Your videos are really very helpful.Thanks so much!! Thanks :):)
suruchigupta2k3 2 years ago
You are welcome!! I am glad that the videos are helpful!
ExcelIsFun 2 years ago
Thank you!!! thank you!!! thank you!!!!
Wangd00dles 2 years ago
You are welcome!
ExcelIsFun 2 years ago
Brilliant! I love these videos! Can't wait to go on to the next one. Thank you very much!!
lexingtonlp 2 years ago
You are welcome!
ExcelIsFun 2 years ago
Hello again Mike,
I want to ask, let's say I have created a pivot table for sale by representative,
but now I want to create a new one, product by sales representative,
I managed to make one, but i keep getting error message when i tried to create the 2nd one, what should i do in this situation?
amycecillau 2 years ago
btw, im using excel 2003
amycecillau 2 years ago
and is that options that helps generate multiple pivots in different spreadsheet not available on 2003?
amycecillau 2 years ago
What error message are you getting?
ExcelIsFun 2 years ago
thank you very much for helping us to learn pivot table and other functions...
1thusitha 2 years ago