Deb, Thanks for the great training session. I have watched most if not all of your Excel webinars. I love how you are sharing small tricks which are extremely helpful while explaining other topics. And your explanation is very clear. I am looking forward to more of your training sessions.
That's great to hear! You can join us live and get access to nearly 100 courses (many written by Deb) as a Simon Sez IT member - www.simonsezit.com/members/signup
Awesome, glad the instructions are clear for you! Glad you enjoyed it. Thanks for watching! 🙂 🔥Check out our FREE 300+ hour training course playlist here 👉 ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
Mrs. Debora, may the lord bless you for this tutorial for I have learn a lot from it and will continue to practice it all the time till I becomes perfect.
Thank you Deb & Adam, you doing a wonderful job fit for heavenly purposes great is your work and all your team you giving an empowerment to the planet over the staff you have collected at the fount of your lives experience and many lives across the globe are transformed by this ready distilled knowledge that is offered to enhance their services in this particular field THANKS TO YOU ALL DEARS
To sort your data in the second pivot chart "Sales by Manager", you have to right click on any of the bar then sort and select "Sort smallest to largest", which is the opposite of what is in the actual table. But then both are sorted the same way... So stupid. You would need to have a duplicate table that would be on an hidden sheet for the bar chart and you can then have separation of sorting. Sorry this is the best I came up with. Thank you Microsoft for such an intuitive sorting feature! hahaha Great video, excellent elocution for non English native speakers. Much appreciated.
22:15 If data is largest number down to smallest number in table, but bar chart shows smallest bar down to largest bar, right-click at any name on the left of a bar in the chart to highlight all the names of the bars, click Format Axis, click Categories In Reverse Order, so that now the bars in the chart are sorted in the same order as the data in the table.
You are welcome, and thank you for the nice comments. 🙂 We have additional videos to 🚀 boost your Excel knowledge 👉🏼 ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉🏼 ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here 👉🏼ruclips.net/p/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u
Glad you enjoyed it. Thanks for watching! 🙂 🔥Check out our FREE 300+ hour training course playlist here 👉 ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU 🚀 Level up your Excel skills with free training here 👉 ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here 👉 ruclips.net/p/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! RUclips Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► ruclips.net/user/simonsezittraining ♥️ We appreciate your support!
We're holding a live class on PowerPivot in 2020. You can attend live as a Simon Sez IT member: support.office.com/en-gb/article/show-the-project-summary-task-5f29729b-5b22-4e75-a8ab-c69f2aa17573
Thanks Deb, question - i have a dashboard with 1. a chart map created from a table with a slicer (works great) 2. i have a pivot table from same data with a slicer and VLOOKUPs to pull text out (works Great) can i have one slicer to control the table (MAP) and the pivot table/VLOOKUP Thanks
I am new to the excel dashboard and came here looking for tutorial. The data file does not seem to be accessible from the link posted above. Can you please post a link to access the data file? Thanks.
✅Download the exercise files and follow along here: ➡www.simonsezit.com/article/dashboards-in-excel-using-pivot-tables-pivot-charts-and-slicers/ The exercise files will be sent to your email.
We have lots of additional free and recent Excel training here 👉 ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here 👉 ruclips.net/p/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u
Hi. I just completed 3 hours Excel for Beginners and now searching for continuous session for intermediate (if any). But I can't locate session for intermediate
since my data was hundreds of thousands of records and too big to email i found that if i made a copy of the spreadsheet and deleted the data tab , the pivot tables links remained intact
✅Download the exercise files and follow along here: ➡www.simonsezit.com/article/dashboards-in-excel-using-pivot-tables-pivot-charts-and-slicers/
I think Deb Ashby is among the best instructors for excel i have interacted with
Thank you Charles!
Thank you Derby this my time to dashboard and pivot table, but you made easy and your English was clear to understand. God bless you
Glad it was helpful! 🤩 Learn more Microsoft Excel Tips and Tricks here ➡️
ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc
Deb, Thanks for the great training session. I have watched most if not all of your Excel webinars. I love how you are sharing small tricks which are extremely helpful while explaining other topics. And your explanation is very clear. I am looking forward to more of your training sessions.
That's great to hear! You can join us live and get access to nearly 100 courses (many written by Deb) as a Simon Sez IT member - www.simonsezit.com/members/signup
Ashby is good.. instructions and demonstrations are self-evident, step by step!
Awesome, glad the instructions are clear for you! Glad you enjoyed it. Thanks for watching! 🙂
🔥Check out our FREE 300+ hour training course playlist here 👉
ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
Thank you! I’m creating a dashboard that will live in our shared drive, and I finally understand what I’m doing!
Mrs. Debora, may the lord bless you for this tutorial for I have learn a lot from it and will continue to practice it all the time till I becomes perfect.
Thank you Wumbei Emmanuel 😀
Your voice and using word very clear to understand even beginner in excel. thanks lot for your lesson 😊
So nice of you. You're very welcome! 😊
I like genuine English accent in addition to your fabulous teaching.
Thank you! 😃
Wooow really very well explained and clear...my first time i watch a tuto on dashboard in excel thank you
Hello, thanks for your sessions I am able to get more advanced information on pivot tables
i finished the first part and i lean a lot..i expect to learn a lot as well at this lesson..your English is very understandable for me
Pleased to hear you learnt a lot from the tutorial!
You're a great teacher, Deb!
Oh thank you!
You are the best Debby.
Thank you Deb & Adam, you doing a wonderful job fit for heavenly purposes great is your work and all your team you giving an empowerment to the planet over the staff you have collected at the fount of your lives experience and many lives across the globe are transformed by this ready distilled knowledge that is offered to enhance their services in this particular field
THANKS TO YOU ALL DEARS
Thank you so much! If you need additional Excel training, there is plenty of it here -> ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI
This is really very helpful. Thank you for explaining the minute details in preparing the dashboard.
You are welcome Aditya! Glad you found it helpful.
Amazing session deb, you are my favourite
Glad you think so! Thanks for watching :-)
Thank you so much for the presentation ...it was clear and to the point
Glad it was helpful! 🤩 Check out our FREE 400+ hour training course playlist here ➡️
ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
Great job Deb, thank you!
Glad it was helpful!
Thank you so much for sharing this expertise. I learned a lot
You are very welcome 🙂
Great Tutorial, really very very Helpful 🔥
Glad to hear that, Harsh! If you need additional tips, check out our playlist on Pivot Tables -> ruclips.net/p/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u
To sort your data in the second pivot chart "Sales by Manager", you have to right click on any of the bar then sort and select "Sort smallest to largest", which is the opposite of what is in the actual table. But then both are sorted the same way... So stupid. You would need to have a duplicate table that would be on an hidden sheet for the bar chart and you can then have separation of sorting. Sorry this is the best I came up with.
Thank you Microsoft for such an intuitive sorting feature! hahaha
Great video, excellent elocution for non English native speakers. Much appreciated.
Great webinar Deb
Thanks for watching, Charles 🙂
I have no words to thank you so I didn't skip any ads in this video 😂 just for you guys
You're the best!
22:15 If data is largest number down to smallest number in table, but bar chart shows smallest bar down to largest bar, right-click at any name on the left of a bar in the chart to highlight all the names of the bars, click Format Axis, click Categories In Reverse Order, so that now the bars in the chart are sorted in the same order as the data in the table.
this was super helpful - thanks so much!
You're so welcome!
Queen excel deb! Big thank you 🥰
Thank you for the kind words 😊
Fabulous explanation and well explained
Glad it was helpful!
Thank you so much, love it
You are welcome, and thank you for the nice comments. 🙂 We have additional videos to 🚀 boost your Excel knowledge 👉🏼
ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc
& here 👉🏼 ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI
& Pivot Table training here 👉🏼ruclips.net/p/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u
Exactly the information I needed. Great job Deb!
came to this a few years late but very useful. thanks
Great to hear!
thanks this i enjoyed this
Glad you enjoyed it. Thanks for watching! 🙂
🔥Check out our FREE 300+ hour training course playlist here 👉
ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
🚀 Level up your Excel skills with free training here 👉 ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI
& Pivot Table training here 👉 ruclips.net/p/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u
For more information about Simon Sez IT courses, visit:
SimonSezIT.com: www.SimonSezIT.com/
Stay in touch!
RUclips Channel: www.youtube.com/@SimonSezIT
LinkedIn: www.linkedin.com/company/simon-sez-it/
Please SUBSCRIBE ► ruclips.net/user/simonsezittraining
♥️ We appreciate your support!
Lovely ❤️ awesome ❤️thank you ❤️
Ahhh....thank you Karthik! ☺️
Thank you.
You're welcome! If you need additional MS Excel tips, you can find them here -> ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI
Quite useful.
Thanks Pervez! Glad you think so! 😁
Thanks! Was good refresh. If in the future is comin power pivot. Please keep it really simple in explanation, specialy when is coming in DAX.
We're holding a live class on PowerPivot in 2020. You can attend live as a Simon Sez IT member: support.office.com/en-gb/article/show-the-project-summary-task-5f29729b-5b22-4e75-a8ab-c69f2aa17573
A great webinar 👍👍
Glad you enjoyed it Vikram
Thanks a lot
Happy to help
it was helpful. thanks a lot
Most welcome!
Great presentation. Btw, the legends are backwards on the dashboard. Tfs....
Thanks for the info!
Thanks Deb, question - i have a dashboard with 1. a chart map created from a table with a slicer (works great) 2. i have a pivot table from same data with a slicer and VLOOKUPs to pull text out (works Great) can i have one slicer to control the table (MAP) and the pivot table/VLOOKUP
Thanks
رائع.... شكرا جزيلا
I am new to the excel dashboard and came here looking for tutorial. The data file does not seem to be accessible from the link posted above. Can you please post a link to access the data file? Thanks.
✅Download the exercise files and follow along here: ➡www.simonsezit.com/article/dashboards-in-excel-using-pivot-tables-pivot-charts-and-slicers/
The exercise files will be sent to your email.
Great . Is there a newer video on this? See its 4 years ild
We have lots of additional free and recent Excel training here 👉 ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here 👉 ruclips.net/p/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u
How did you save your dashboard as pic ? I tried to group it or even save as png, but it didn't work as you can tell :(
Hi. I just completed 3 hours Excel for Beginners and now searching for continuous session for intermediate (if any). But I can't locate session for intermediate
Wonder Years fan or coincidence?
since my data was hundreds of thousands of records and too big to email i found that if i made a copy of the spreadsheet and deleted the data tab , the pivot tables links remained intact
Yes, the PivotTable data will remain intact as long as you don't refresh it. :)
Thanks! but your link "Data Cleaning - ruclips.net/video/4DAHWCNuFs8/видео.html" gives "Video unavailable
This video is private."
Sorry, wrong link. Updated with the right one now: ruclips.net/video/EwmuaqnoaKs/видео.html
nice tutorial, though sky blue is your God damn colour ma'am!
Thank you Joseph