Thank you so much Mylinda for this useful tutorial. I would like to add some easy tricks for chart as I'm using them in my professional dashboards. 1- CTRL+6: Hiding and unhiding charts and other objects 2- ALT+F10: Open object pane 3- CTRL+C+C: Open the copy and paste panel, which is helping whenever you want to paste it another place. 4- For default color templates: First arrange individual chart colors from Themes in Page Layout Tab and save as it as your own name. Then save your current workbook as named Workbook1 into C:\Users\User\AppData\Roaming\Microsoft\Excel\XLSTART. Then, whenever you open any workbook, you are able to find your themes selected automatically. 😵
After selecting year and data columns, we can use 'recommended charts' available in ribbon to select line chart. That ways, we get year data on x axis directly. You are one of the best excel tutors👍
Hi Mynda. Great tips! I especially like the Properties follow chart tip and CTRL+up/dn to cycle through chart elements. Thanks for sharing :)) Thumbs up!!
No matter how many years I've had in this program, I still learn new tips and tricks with every one of these videos! Also, does anyone remember how to quickly move a column of data to a different column within an unformatted table? Currently I add a blank column, cut my desired column, paste into the newly created blank column and then delete the now blank column where my data originally was. I know there is an easier way and it was even called out in one of these videos; I just don't remember which one now.
After I've spent not inconsiderable time selecting the right colours for a chart, only to have them change when I copy it and change the data is enormously frustrating! Who'd have thought there was a setting for that? Thanks, Mynda!
I want to copy and paste link my data for summary or consolidation. I have found it easy when the cells are adjacent. But when there are already gaps in cells, it slows me down because i have to do it one by one. Is there any fast way to do it? Maybe in batch? Thank you.
I'd probably use Power Query to gather the data and remove the gaps, but it's difficult to say for sure without seeing an example. You're welcome to post your question and sample Excel file on our forum where we can help you further: www.myonlinetraininghub.com/excel-forum
Like Zor suggested, my beginners playlist is a great place to start: ua-cam.com/video/MnGIaqpqLTU/v-deo.html and if you want more, please check out my courses: www.myonlinetraininghub.com/
Thank you so much Mylinda for this useful tutorial. I would like to add some easy tricks for chart as I'm using them in my professional dashboards.
1- CTRL+6: Hiding and unhiding charts and other objects
2- ALT+F10: Open object pane
3- CTRL+C+C: Open the copy and paste panel, which is helping whenever you want to paste it another place.
4- For default color templates: First arrange individual chart colors from Themes in Page Layout Tab and save as it as your own name. Then save your current workbook as named Workbook1 into C:\Users\User\AppData\Roaming\Microsoft\Excel\XLSTART. Then, whenever you open any workbook, you are able to find your themes selected automatically. 😵
Great, tips! Thanks for sharing, Emre :-)
After selecting year and data columns, we can use 'recommended charts' available in ribbon to select line chart. That ways, we get year data on x axis directly. You are one of the best excel tutors👍
Thanks so much, Nethikar! I'll give recommended charts a go. I tend to avoid them because I'm old school 😂
Lots of helpful good tips! Thank you and greetings from Los Angeles, California!
Great to hear, Takao!
Hi Mynda. Great tips! I especially like the Properties follow chart tip and CTRL+up/dn to cycle through chart elements. Thanks for sharing :)) Thumbs up!!
Thanks so much, Wayne! Glad you found some tips you liked :-)
Outstanding! Just watched your other tips video. You’re a great teacher, knowledgeable and clear. Thank you.
Wow, thank you!
No matter how many years I've had in this program, I still learn new tips and tricks with every one of these videos!
Also, does anyone remember how to quickly move a column of data to a different column within an unformatted table? Currently I add a blank column, cut my desired column, paste into the newly created blank column and then delete the now blank column where my data originally was. I know there is an easier way and it was even called out in one of these videos; I just don't remember which one now.
Glad it was worth your time to watch, Dan! To move data in columns/rows/cells, hold SHIFT while left clicking and dragging the range of cells.
@@MyOnlineTrainingHub Thank you! Amazing videos. And really really appreciate the reply!
Those tips are definitely useful!! They will help me a lot to customize my charts. Thanks for sharing, Mynda!
Great to hear, Cassio!
Great Job . Thanks for sharing 👍
Thanks so much!
I learn something new from you every time!! Thank you.
I'm so glad!
Fantastic tips!
Glad you like them!
Impressive. Thumps up for the nice work.
Thank you very much!
Excellent video, I like the item on selection pane, this is going to save me a stack of time. Thanks Mynda.
Great to hear, Dave!
Very helpful. Please share some more tips on charts and slides
Sure 👍
New subscriber here :) Love your videos, thank you so much! Ctrl+D F4 was something I never knew. So powerful :>
Wonderful to hear!
Thank you for explaining so well. These tips are very helpful.
My pleasure 😊
Wowww. Valuable information. Everything is very useful. Prevent chart resizing with columns/rows will be incorporated into my skill. Thank you Mynda!!
So pleased to hear you found it useful, Ivan!
Hi, these tips are really great! You explain very nicely. Appreciate your efforts!
Thanks so much, Milena 😊
New subscriber here! Very helpful video with my report thank you.
Great to hear 😊
Great set of tips. Have saved video to watch again later.
Great to hear, Deirdre!
It is one thing most useful while preparing Dashboard- I love it
So pleased you found it helpful, Pankaj!
Thank you so much for sharing this, made my life easier 🙏
You're so welcome!
Some very useful tricks her Mynda - thank you
Great to hear 😊
Chart template was 👌
Glad you think so!
Such a time saver! Thank you!
You're welcome!
It’s really amazing, thank you for great and useful tips
Our pleasure 😊
Mynda,
Bravo !
Thanks, Eric 😊
Thanks
My pleasure 😊
Brilliant !!! BRAVO !!! VERY VERY USEFUL
Thanks so much, Amrish!
Great tips! Thank you for sharing!
Thanks for watching, Crystal!
These are great, thanks Mynda!
Glad you like them, Chris!
Hi Mynda!Really Great Tips..Thank You :)
Thanks so much, Darryl!
Many thanks for these useful tips
My pleasure 😊
Excellent tutorial. Thank you :-)
Glad you enjoyed it!
Very useful
Great to hear, Meziane 😊
Excelente dicas, parabéns!!
Thanks so much!
Thank You, Found it very Usefull
Glad to hear that, Ajay!
I cringe when thinking about the number of hours I've wasted over the years by not knowing these techniques! Thanks a lot Mynda!
Better late than never 😅
Thank you! I founв good tip
Great 😊
It's really helpful...
Glad to hear that, Sonu :-)
thank you maam
My pleasure, Abdul! 😊
Great
Cheers, Gulam!
Thanks 👍
Welcome 👍
Could you do this for healthcare managers? Managers need tools to show CEOs WHY they are not meeting KPIs.
Yes, as long as you have a target value and an actual value, you can compare them.
Hi Mynda. Great tips!
Is there any way you can align the columns in a column chart with the spreadsheet columns?
Only by trial and error manually resizing the chart to the columns. There’s no setting as such.
After I've spent not inconsiderable time selecting the right colours for a chart, only to have them change when I copy it and change the data is enormously frustrating! Who'd have thought there was a setting for that? Thanks, Mynda!
So pleased to hear this will be useful to you, Craig!
Is there a simple way to compare hospital/healthcare staffing from year to year with patient and staff satisfaction scores?
Yes, as long as you have the data you can chart it.
I want to copy and paste link my data for summary or consolidation. I have found it easy when the cells are adjacent. But when there are already gaps in cells, it slows me down because i have to do it one by one. Is there any fast way to do it? Maybe in batch? Thank you.
I'd probably use Power Query to gather the data and remove the gaps, but it's difficult to say for sure without seeing an example. You're welcome to post your question and sample Excel file on our forum where we can help you further: www.myonlinetraininghub.com/excel-forum
In order to understand your courses , which office you use.
Because I have office 2016 only.
In this video I’m using Microsoft 365, but my courses cater for Excel 2016 too.
The right I think. My right.
🤩🤩🤩🤩🤩🤩 great
I want to learn Excel, how do I start?
look into her excel for beginners playlist, or possibly inlist in one of her courses (the link is in the descripion)
Like Zor suggested, my beginners playlist is a great place to start: ua-cam.com/video/MnGIaqpqLTU/v-deo.html and if you want more, please check out my courses: www.myonlinetraininghub.com/
@@MyOnlineTrainingHub I gotchu
How Ctrl+D copy the charts? This command is for down the current window
In Excel CTRL+D duplicates objects or if you're in a cell, copies data from the cell above.
@@MyOnlineTrainingHub i knew about it copy the cell which is above but will try on charts. Thanks
Where is the practice file.
I didn't share the file for this video, sorry.
Hey there! I'm looking forward to give my freelancing service in your organization. If something is there...plz make it.
Thanks, but we don't have anything available for freelancing, sorry.
Thanks
Welcome :-)