This is where it goes "no comment". In a sense of great generosity, high level profesionalism, tutorials designed in detail, all combined to offer us an expensive tutorial program for free. Thank you Simon! I'm sure your generosity will return back to you. You are a genuine giver. Thank you Deb! You are a natural talent in teaching and we are so lucky to have you. You are really special.
Wow! Thank you for taking the time to write nice comment 😊 There's additional Excel training here if you need it -> ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
As a Data Analyst intern, it has become my worst nightmare to analyze data and find out insights because sometimes, ite really hard to decide how to start and where to start. But by watching your videos, things have become so simple and interesting I would like to say. You truly are the Excel queen. Thank you so much for making our lives easier :)
Thank you for the kind words, Rajbir. Here's some additional videos on data analysis that may be of interest: -> ua-cam.com/play/PLzj7TwUeMQ3jiDSWwQjtVvHqT09XdYFMi.html -> ua-cam.com/play/PLzj7TwUeMQ3iE3tUiAOKdVjSvcq0ynUS2.html
This is the only PivotTable course that one needs to be a good analyst. Thank you so much for your generosity in delivering such a valuable course for free by such professional and knowledgable person.
Hey, thanks a bunch for watching. I appreciate you taking the time to leave a positive feedback. 🙂 🔥Check out our FREE 300+ hour training course playlist here 👉 ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
I just recently got an opportunity to advance in my career to a new position. Turns out I must be a master of Excel which I had not ever opened once in my life! I want to sincerely thank you for your fantastic training and free training materials, which have made me gain so much confidence in dealing with Excel! Now I look at my future job requirements for Excel and I'm like- I GOT THIS EYES CLOSED !!!!! THANK YOU !!!!
It's always nice to hear our tips are helping. Wishing you all the best with your new position. 😊 We have lots of additional free Excel training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html & Pivot Table training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html
Deb you are such an excellent communicator and tutor, i got to understand a lot of formulaes i couldn't get from other tutorials.Thank you so much and SIMON YOU ARE STAR
Thank you for your kind words! I'm glad the tutorial helped you understand the formulas.🙂 🔥Check out our FREE 300+ hour training course playlist here 👉 ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
Excellent Course, perfectly delivered. There are a few things, I'd like to offer to the viewers of which I saw possibly easier ways to accomplish: 1) Finding blank rows. The method in the video used found rows of blanks cells within the data, but also individual cells left blank. The video showed the user simply using the control key and mouse to remove them from the collection. However, as said in the video, this could be a very large data sheet, thus making that not a functional way to remove blank rows. Because the data is in the table, the user can go to the table header which has a drop-down field, and simply unselect the all and then scroll to the bottom of the list and select "blank". If some rows show up with data in them, go to the column header of the row and choose blank for it also. But, most likely, choosing a column that is the primary field in the data, will show all the blank rows. Then the user can simply highlight the rows and delete them from the table.
I honestly can not say how much of an assistance the tutorials that Deb Ashby's gives has been in advancing my skills and knowledge on Excel. To start with, Deb Ashby is an excellent tutor with fantastic communication style and approach. The course content is elaborate, detailed and structured. 100% informatively relevant content and very up to date. Thank you for these contents
You are a wonderful instructor! Pivot Table intimated me in college, but now it all starts making sense. I interviewed a job today that requires high level of Pivot Table skills. I am trying to improve my Pivot Table skills from basic to advanced just in case I get a 2nd interview/or the job. I am sure it will be very useful for me in the future for other jobs as well.
Glad you enjoyed it. Thanks for watching! 🙂 🔥Check out our FREE 300+ hour training course playlist here 👉 ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
Deborah, you have a great simple facility to explain excel that I even used your videos to perform my English! I thank you for your time and for sharing your knowledge!
You´re such a great teacher. Thank you so much for sharing this valuable content for free! It was so great that I decided to become a member at your website. Keep it up!
I watched first the 1h video Pivot tables beginner then the 1h advanced one. After that I watched the 2h video beginner Pivot Tables and now right here watching this 2h advanced one. All 4 together is like magic, Thank you so much 🙏🏻
Thanks for kind feedback, Tony! If you need additional Excel training, we recently uploaded our 5+ hour course for Excel 2021/365 intermediate ➡️ ua-cam.com/video/oN82Umc9MCQ/v-deo.html
I am enjoying watching and learning at the same time this video tutorial. It's easy to follow that will linger in my beautiful brain infinitely as long you focus, focus and most importantly focus whilst watching the tutorial. Much gratitude Simon Sez IT.
Best Excel training course I've ever seen on the web. Congrats., I've subscribed to receive further info from your channel and stay up-to-date on this matter.
Hello Alessandro ... Have u got the exercise files downloaded for this course.. I tried downloading through the above link ..but the link isn't working
Thanks for uploading this for free onto UA-cam! Pivot Tables have always seemed really useful but I've never understood what some of the advanced features do until now.
Great Tutorial, Crystal Clear and Concise. When grouping a numerical field into categories/classes, instead of keeping intervals, It would be awesome if we could have the option to rename the groups (like low, moderate, high, etc,...), just as we did when grouping text fields. Actually this feature I feel like it should be better named as hierarch or categorization/bucketing since right from the beginning, the pivot table is already grouping by unique fields/values, apply the aggregation metric (sum, average, count, min, max,.......)! just thinking loud!
The file sent through the link are completely different. @Simon Sez IT - please correct the files, otherwise the course could not be followed. Please paste the updated link here -
Follow-along and download the accompanying Excel exercise files here ► www.simonsezit.com/adv-pivottables-course-exercise-files/ We have additional free Excel training here if you need it 👉 ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html & Pivot Table training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html
Hi, I've just tested the email link and it's working fine, we've had a number of people successfully get their files already. I suggest checking your spam/junk folder as sometimes the files end up in there. Also, check that you entered your email address correctly, if there was a small typo it won't send!
Hi, I can't find Course file in the given link. There are only exercise files which don't match the data which you have in the video. Can you help me please in this regard? Thank you so much.
Hi Deb, first up, thanks a bunch! I can't express how much your videos have helped me learn pivot tables. Forever grateful. I downloaded the files but the sheets are totally different from what I see in the tutorials. Am I missing something? The files are under Folder 1, 2, 3 and 4 and they seem to be employee data files not sales figures.
Thanks for watching 🙂 🔥Check out our FREE 300+ hour training course playlist here 👉 ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html 🚀 Level up your Excel skills with free training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html & Pivot Table training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! UA-cam Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► ua-cam.com/users/simonsezittraining ♥️ We appreciate your support!
Hello, I love the content! However, I have one doubt, when we practiced with the CleaningData File, I did notice that you did not delete the duplicate rows?
Thanks, great course so far .. I'm on the middle of that. Doing Exercise 2 I found a typo, you missed to delete duplicates before doing the Pivot Chart.
This is so helpful, but when I click on the link posted under video there are no practice files. It says they have been removed. : ( Is there anyway you can direct me to them in a new location? Thanks in advance, Gabrielle
Thanks for sharing. I have an issue with a pivot table in one workbook whose source is from a table in another workbook in another folder all in my local OneDrive folder that keeps referring to the online version of the file. Is there a way to force it to keep sourcing from the local workbook and not online? or is there a better way to set up cross-sourced pivot tables of other workbooks? In my particular case, I have 3 different workbooks (in different folders under my Onedrive folder) with different data that need to remain individual workbooks and each to obtain pivot table data from the other whilst all are open. Sometimes when the internet connection is lost OneDrive stores the file you are working on within another folder that messes the source links up causing chaos.
The above link for downloading the files doesn't work, only the exercise ones work. I have been trying since last night. Thank you for sending me the files used in the video.
This is where it goes "no comment". In a sense of great generosity, high level profesionalism, tutorials designed in detail, all combined to offer us an expensive tutorial program for free.
Thank you Simon! I'm sure your generosity will return back to you. You are a genuine giver.
Thank you Deb! You are a natural talent in teaching and we are so lucky to have you. You are really special.
Wow! Thank you for taking the time to write nice comment 😊 There's additional Excel training here if you need it -> ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
Hello dear , did you get the exercise files? Please let me know if you have them I really need them
As a Data Analyst intern, it has become my worst nightmare to analyze data and find out insights because sometimes, ite really hard to decide how to start and where to start. But by watching your videos, things have become so simple and interesting I would like to say. You truly are the Excel queen. Thank you so much for making our lives easier :)
Thank you for the kind words, Rajbir. Here's some additional videos on data analysis that may be of interest: -> ua-cam.com/play/PLzj7TwUeMQ3jiDSWwQjtVvHqT09XdYFMi.html
-> ua-cam.com/play/PLzj7TwUeMQ3iE3tUiAOKdVjSvcq0ynUS2.html
Hello dear , did you get the exercise files? Please let me know if you have them I really need them
This is the only PivotTable course that one needs to be a good analyst. Thank you so much for your generosity in delivering such a valuable course for free by such professional and knowledgable person.
Glad you enjoyed! Thanks for watching ;-)
Thank you Simon for your generosity; thank you Deb, you are an excellent communicator, the best teacher in the world.
Hey, thanks a bunch for watching. I appreciate you taking the time to leave a positive feedback. 🙂
🔥Check out our FREE 300+ hour training course playlist here 👉
ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
I just recently got an opportunity to advance in my career to a new position. Turns out I must be a master of Excel which I had not ever opened once in my life! I want to sincerely thank you for your fantastic training and free training materials, which have made me gain so much confidence in dealing with Excel! Now I look at my future job requirements for Excel and I'm like- I GOT THIS EYES CLOSED !!!!! THANK YOU !!!!
It's always nice to hear our tips are helping. Wishing you all the best with your new position. 😊 We have lots of additional free Excel training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
& Pivot Table training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html
Deb you are such an excellent communicator and tutor, i got to understand a lot of formulaes i couldn't get from other tutorials.Thank you so much and SIMON YOU ARE STAR
Thank you for your kind words! I'm glad the tutorial helped you understand the formulas.🙂
🔥Check out our FREE 300+ hour training course playlist here 👉
ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
Excellent Course, perfectly delivered. There are a few things, I'd like to offer to the viewers of which I saw possibly easier ways to accomplish: 1) Finding blank rows. The method in the video used found rows of blanks cells within the data, but also individual cells left blank. The video showed the user simply using the control key and mouse to remove them from the collection. However, as said in the video, this could be a very large data sheet, thus making that not a functional way to remove blank rows. Because the data is in the table, the user can go to the table header which has a drop-down field, and simply unselect the all and then scroll to the bottom of the list and select "blank". If some rows show up with data in them, go to the column header of the row and choose blank for it also. But, most likely, choosing a column that is the primary field in the data, will show all the blank rows. Then the user can simply highlight the rows and delete them from the table.
Thanks so much!! I realized that issue.
I honestly can not say how much of an assistance the tutorials that Deb Ashby's gives has been in advancing my skills and knowledge on Excel. To start with, Deb Ashby is an excellent tutor with fantastic communication style and approach. The course content is elaborate, detailed and structured. 100% informatively relevant content and very up to date. Thank you for these contents
Wow, thank you!
Hi Deb, thanks for this tutorial. You're the best teacher in the world.
You are very welcome! Thanks for watching 🙂
I LEARN SO MUCH THROUGH YOUR TEACHING AND APPRECIATE SO MUCH. THANK YOU DEB.
You are very welcome! Thanks for watching 😃
Hello dear , did you get the exercise files? Please let me know if you have them I really need them
Your explaining/teaching procedure is excellent. Even any beginner can understand and learn, provided he makes practice of it.
Thank you for your kind words, Delighted you’ve enjoyed the tutorial!
This is a really helpful and valuable lecture. Cant stop myself from leaving a comment
You are a wonderful instructor! Pivot Table intimated me in college, but now it all starts making sense. I interviewed a job today that requires high level of Pivot Table skills. I am trying to improve my Pivot Table skills from basic to advanced just in case I get a 2nd interview/or the job. I am sure it will be very useful for me in the future for other jobs as well.
Thank you! Delighted that you are enjoying the courses. I hope you get it!
I really enjoyed learning best quick pivot table training from your channel.
Glad you enjoyed it. Thanks for watching! 🙂
🔥Check out our FREE 300+ hour training course playlist here 👉
ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
Deborah, you have a great simple facility to explain excel that I even used your videos to perform my English! I thank you for your time and for sharing your knowledge!
You're very welcome, and thank you too!
very interesting course. The accent is very clear, thanks
I loved this training and thank you very much for making this training available for us.
What a great relief for us beginners. Thank you very much for your greatness in teaching people!
Thanks for the nice comments and the visit 😊
You guys are good teachers. I appreciate you Deb.
Our pleasure!
You´re such a great teacher. Thank you so much for sharing this valuable content for free! It was so great that I decided to become a member at your website. Keep it up!
I watched first the 1h video Pivot tables beginner then the 1h advanced one. After that I watched the 2h video beginner Pivot Tables and now right here watching this 2h advanced one. All 4 together is like magic, Thank you so much 🙏🏻
Thanks for kind feedback, Tony! If you need additional Excel training, we recently uploaded our 5+ hour course for Excel 2021/365 intermediate ➡️ ua-cam.com/video/oN82Umc9MCQ/v-deo.html
Nice video!!! 🌶
Thank you! Cheers!
you are such a great and excellent excel teacher
You are simply the best. God bless you
Wow, thank you
Great job done especially to support MEAL Departments in development world.
Thank you very much Simon and Deborah
You’re welcome!
I am enjoying watching and learning at the same time this video tutorial. It's easy to follow that will linger in my beautiful brain infinitely as long you focus, focus and most importantly focus whilst watching the tutorial. Much gratitude Simon Sez IT.
Thank you for your wonderful review, delighted that you've enjoyed the tutorial!
Thanks in a bunch Deb for this training. I can confirm this has improved my data analysis techniques
You're welcome! Wishing you all the best in 2023 :-)
Is very useful. God bless what you do!
Thanks Edwin 😄
immeasurably helpful. thanks Simon
Happy to help
This is excellent. Thank you for sharing this information for free.
Glad you enjoyed it, Nikki! 😃
Best Excel training course I've ever seen on the web. Congrats., I've subscribed to receive further info from your channel and stay up-to-date on this matter.
Thanks Zoilo, greatly appreciate your kind comments. We'll pass it along to Deborah.
There is no download link for the course files. The only download link is for the exercise files.
Hello dear , did you get the exercise files? Please let me know if you have them I really need them
Great course on Pivot Table, very clear explanation supported with exercises. Highly recomended, thanks.
You're very welcome Alessandro!
Hello Alessandro ... Have u got the exercise files downloaded for this course.. I tried downloading through the above link ..but the link isn't working
Thank you so much for putting this video online; I found it very informative.
Glad you enjoyed it!
Thanks for uploading this for free onto UA-cam! Pivot Tables have always seemed really useful but I've never understood what some of the advanced features do until now.
Glad it was helpful! thanks for watching
Excellent tutorial in Excel ever!
Glad you think so!
Thank a lot Simon really I appreciate this high quality effort the course is amazing
Our pleasure!
Thank you for refreshing my Power pivot knowledge, the content is very useful.
Glad to hear that!
Excellent, very helpful for my studies, Thanks so much!
Glad it was helpful! 🤩 Learn more Microsoft Excel Tips and Tricks here ➡️
ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html
Great Tutorial, Crystal Clear and Concise. When grouping a numerical field into categories/classes, instead of keeping intervals, It would be awesome if we could have the option to rename the groups (like low, moderate, high, etc,...), just as we did when grouping text fields. Actually this feature I feel like it should be better named as hierarch or categorization/bucketing since right from the beginning, the pivot table is already grouping by unique fields/values, apply the aggregation metric (sum, average, count, min, max,.......)! just thinking loud!
Brilliant presentation like never before
Thank you so much, Choro! If you need additional Excel training, there is plenty of it here -> ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
Thanks for this great effort and for uploading this for free, Great instructor.Highly recommended!
You're very welcome!
Brilliant teaching! Thank you very much!👍
Glad you liked it, Oyunpurev Battumur🙂 You can get additional Excel training here ➡️
ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
So good! Thank you. I've learnt so much.
Glad you are enjoying the training. 😀
12 minutes in but already subbed!! thank you so much for this video!
Wohoooo, Delighted to hear it!
Thank you for this detailed course
You're very welcome!
very Helpful Vedio, Many Thanks for making and publishing this in You tube.
You are most welcome
Really great tutorial! Thank you!
Thank you very much for this Excellent course.
Glad you liked it!
great lectures
thanks deb and thanks SIMON SEZ IT quite useful
Glad to hear it Hatim
very good way of improving your pivot table skills.. thank you for uploading this video
Thanks and welcome
Thank you! Super helpful!
Amazing class. I am Sam from Ghana
Thanks for watching our training, Samuel 😀
Thank you very much Sir/Ma'am for such a good content..wish you all the very best for your future advancement...
You're very welcome! Thank you for watching ;-)
Many thanks. Great course, all in one video.
Glad you liked it!
The files I downloaded only had four (4) subdirectories?
Excellent presentation
More than great Tutorial Many Thanks ♥
Glad it was helpful, Hazem ♥
Great tutorial and easy to follow. Thanks for sharing!
Thanks for watching!
Thank you so much for this valuable tutorial
You're very welcome!
Thanks for this course
You are very welcome! Thanks for watching :-)
love this video! thanks for sharing!
Thanks for watching! :-)
The file sent through the link are completely different. @Simon Sez IT - please correct the files, otherwise the course could not be followed. Please paste the updated link here -
good detailed overview, thanks
You’re welcome!
Great tutorial!
Follow-along and download the accompanying Excel exercise files here ► www.simonsezit.com/adv-pivottables-course-exercise-files/
We have additional free Excel training here if you need it 👉 ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
& Pivot Table training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html
Hi, I've just tested the email link and it's working fine, we've had a number of people successfully get their files already. I suggest checking your spam/junk folder as sometimes the files end up in there. Also, check that you entered your email address correctly, if there was a small typo it won't send!
Hello ... The above link for the exercise files is not working..Can u pls help me download the files..
@@usmanmarikkar9865 for me too its not working i've tried several times
i have tried numerous times to download the exercises and the course needs these to be worthwhile
I added my email several Time No e-mail received from you. Please check your e-mail process .
Teaching is excellent
😊 Thanks for watching!
Thank for this great tutorial
Glad you liked it
Thank you 😀
The tutorial help me a lot. I enjoyed it as well.
You're welcome 😊
Hi, I can't find Course file in the given link. There are only exercise files which don't match the data which you have in the video. Can you help me please in this regard? Thank you so much.
Tutorial is exceptionally well explained!!!
Glad you think so!
Great job!
Thank you! Cheers!
Hi Deb, first up, thanks a bunch! I can't express how much your videos have helped me learn pivot tables. Forever grateful.
I downloaded the files but the sheets are totally different from what I see in the tutorials. Am I missing something? The files are under Folder 1, 2, 3 and 4 and they seem to be employee data files not sales figures.
Great content, really helpful
Delighted to hear that Miftah!
Great course! Nice refresher and learned some new things along the way.
Thanks Bradley, appreciate the feedback!
nice explanation, thank you.
Glad you liked it!
Great and very helpful tutorial.
Glad you liked it
The relationship was not forming well though i was going through the process step by step, same help will be needed
Excellent. Thank you
You're welcome!
Please may i get the correct data files for this tutorials😢😢😢😢😢😢. The one that is on the video link is not complete!!
Unbelievable Simon
Thanks for watching 🙂
🔥Check out our FREE 300+ hour training course playlist here 👉
ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
🚀 Level up your Excel skills with free training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
& Pivot Table training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html
For more information about Simon Sez IT courses, visit:
SimonSezIT.com: www.SimonSezIT.com/
Stay in touch!
UA-cam Channel: www.youtube.com/@SimonSezIT
LinkedIn: www.linkedin.com/company/simon-sez-it/
Please SUBSCRIBE ► ua-cam.com/users/simonsezittraining
♥️ We appreciate your support!
A very helpful course. Thank you!
Glad it was helpful!
Please Deb, the file shared for download is different from what you used in your video. How can I get it ????
Thank you. Great intro!!
Thank you Dave!
very great
Hello, I love the content! However, I have one doubt, when we practiced with the CleaningData File, I did notice that you did not delete the duplicate rows?
Thanks, great course so far .. I'm on the middle of that. Doing Exercise 2 I found a typo, you missed to delete duplicates before doing the Pivot Chart.
Yip, picked that up as well .. nevertheless a great course so far
Awesome video, thank you so much!
Glad you liked it!
Excellent explanation, Keep it up sis❤️
Thank you so much 🙂
Hi Simon, after putting my information in tables, i still see the tables 1,2 and 3 also appearing, what am i doing wrong please. Thank you
Should be getting like and getting view million
Thank you Sam, I’m glad you’ve enjoyed it! 🙃
Very useful lesson. Thanks so much!
Glad it was helpful!
Great tutorial
Glad you think so Abu!
Just what I wanted
Thanks 😀
You're welcome 😊 Glad you enjoyed it Janaka! Thank you for watching and commenting!
This is so helpful, but when I click on the link posted under video there are no practice files. It says they have been removed. : ( Is there anyway you can direct me to them in a new location? Thanks in advance, Gabrielle
Awesome👍👍👍
Thanks for watching!
Thank you!
Thanks for sharing. I have an issue with a pivot table in one workbook whose source is from a table in another workbook in another folder all in my local OneDrive folder that keeps referring to the online version of the file. Is there a way to force it to keep sourcing from the local workbook and not online? or is there a better way to set up cross-sourced pivot tables of other workbooks?
In my particular case, I have 3 different workbooks (in different folders under my Onedrive folder) with different data that need to remain individual workbooks and each to obtain pivot table data from the other whilst all are open. Sometimes when the internet connection is lost OneDrive stores the file you are working on within another folder that messes the source links up causing chaos.
The above link for downloading the files doesn't work, only the exercise ones work. I have been trying since last night. Thank you for sending me the files used in the video.