I have been using Excel for over 15 years and I still consider myself a beginner. I recently left my job and am using this “in the meantime” period for professional development courses. Stumbling across your channel was the best professional development gift that I can give me self-a perfect start to 2022! I just completed your intro course and can see how I’ve wasted a great deal of time. I am a research administrator/analyst and work with data. After watching these video, I can only imagine the amount of time I have wasted. I cannot wait to get to more advance courses on pivot tables, dashboards, etc., which I hope will help me to prepare detailed projections and comprehensive budgets. Obrigada!
Hi Mynda. Thanks for the cut, copy and paste tips. Always useful to review the different ways to do those procedures. I like to remember the keyboard shortcut ALT+H+FO to open/close the clipboard pane which has a lot of functionality, as you demonstrated, but remains hidden unless you take the steps to expose it. Excellent review. Thumbs up!
Ty so very much, I’ve subscribed and pray you are able to guide me thru your tutorial here. Blessings from Houston. Why do get instead of copying two lines that read My name Signature I can’t seem to get rid of this Help 🙏
Glad I can help. Not sure what you mean by your question. If you're stuck, you're welcome to post your question and sample Excel file on our forum where someone can help you further: www.myonlinetraininghub.com/excel-forum
Thank you for this series! To follow along with it, do you have the workbook you're using in this video , available to download so we can follow in real time and mess around with?
@@MyOnlineTrainingHub thanks for getting back to me... looks like I found the link but it’s available for paying customers. Thanks anyway! www.myonlinetraininghub.com/preview-excel-syllabus
That's not the link in the video description. The workbook is available for free if you just follow the link in the video description as I suggested. Here it is again: www.myonlinetraininghub.com/workbook-downloads
I’ve got a question I have a long list that I want to paste and for it to get into individual cells but it’s being paste in one cell I don’t know why if you could help me that would be great
Love your videos, they are very helpful! Learned a really great trick in this video that was going to make my life much simpler. Special paste - paste link. I have several cogs spreadsheets that I condense into a few. Manually copy and paste every time. Not hard but annoying when I know there's probably a dozen better ways. I'm still learning with help from your videos! This one has me stumped though. Wondered if you might help me. Successfully pasted link instead of just the regular paste. When I change the original it automatically changes the data everywhere else. Easy peasy. However the files are now too big to attach to an email. I've googles like crazy and can't find anything helpful. Any wisdom you can offer on this would be greatly appreciated? Thanks in advance!!
Glad you find my videos helpful, Sean! You could embed your spreadsheet in a web page instead of emailing it. I've got a video on that coming out next week, so keep your eye out.
Hi Maam! Is there a way to copy multiple UUIDs from different cells in a sheet and paste them in a single cell of another sheet of the same workbook? Thank you for your wonderful videos! :)
No, you can't copy multiple cells and paste them into a single cell, but you can use the TEXTJOIN function: www.myonlinetraininghub.com/excel-textjoin-function
Hi thank you so much for great tutorial. Please teach me how to make a sales plan for electricity branch with bill printing with Excel. Thank you very much.
Hi, I have a problem with copy pasting. Maybe you can help me: If I want to paste and not overwrite data you showed the popup with the shift cell up or down. How can I activate this feature? In my german Version it does not seem to work.
This feature isn't something you turn off or on. I wonder if you're not placing your mouse on the edge of the cell border. You need to get the 4 headed arrow mouse pointer before left-clicking and dragging while holding shift.
Hi Mynda, I hope you can help me with a small problem. I'm using Office 2013 on a new laptop. Every time I hit Copy the whole worksheet sort of jumps for a fraction of a second and then everything is OK. Paste works OK, but it's disconcerting and hard on the eyes to have the sheet jump around like that. Any ideas?
Thanks for that Mynda - I'll look into it. I also opened an xls file that was giving me the problem and resaved it as an xlsx file and the problem went away, but other xls files are OK. Strange!
"There's no best way, it's completely up to you"? That's completely wrong. Cut and Copy of formulas have very different "consequences". Not knowing those difference is why I"m on youtube looking for a training video to help my colleague understand why she broke our template.
I was referring to the "entry points" for cutting/copying/pasting, e.g. to cut you can CTRL+X or you can use the mouse and right-click > cut, or you can use the Home tab > click the Cut icon. That's 3 different entry points for cutting and there's no best way, it's completely up to you. Hope that clarifies things.
Finally I feel comfortable with this simple task because of this easy video! Thank you!!!
Great to hear! 🙏😊
This saved my job! Thank you Holy Spirit for leading me here!
Awesome to hear!
I have been using Excel for over 15 years and I still consider myself a beginner. I recently left my job and am using this “in the meantime” period for professional development courses. Stumbling across your channel was the best professional development gift that I can give me self-a perfect start to 2022!
I just completed your intro course and can see how I’ve wasted a great deal of time. I am a research administrator/analyst and work with data. After watching these video, I can only imagine the amount of time I have wasted. I cannot wait to get to more advance courses on pivot tables, dashboards, etc., which I hope will help me to prepare detailed projections and comprehensive budgets. Obrigada!
Great to hear you found my videos helpful, Tia!
I love your tutorials very very much. Thank you.
Happy to hear that!
Yep, I'm so silly, it finally clicked today and I've completed the course! Thanks for replying.
Hi Mynda. Thanks for the cut, copy and paste tips. Always useful to review the different ways to do those procedures. I like to remember the keyboard shortcut ALT+H+FO to open/close the clipboard pane which has a lot of functionality, as you demonstrated, but remains hidden unless you take the steps to expose it. Excellent review. Thumbs up!
Thanks for sharing the keyboard shortcut for the clipboard, Wayne! I'll try to remember that one.
Even thou i have 8 years of experience in Excel, I always look up to these beginner guides. You never know what you can learn new.
Great to hear, Nika! 😊
Jjjjjkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk
You’re amaizing and i wach majority of your videos especially the dashboard thanks 🙏 alot
I appreciate that!
Awesome video finally i understand all the type's of paste ❤️❤️❤️❤️❤️
Great to hear 😊
Just know new safer method for pasting copied data to avoid messing around in spreadsheet. Thank you Mynda!
You're so welcome, Rizal!
Thanks Mynda. That was Great!!! : ) : )
Glad you liked it!, John!
Ty so very much, I’ve subscribed and pray you are able to guide me thru your tutorial here. Blessings from Houston.
Why do get instead of copying two lines that read
My name
Signature
I can’t seem to get rid of this
Help 🙏
Glad I can help. Not sure what you mean by your question. If you're stuck, you're welcome to post your question and sample Excel file on our forum where someone can help you further: www.myonlinetraininghub.com/excel-forum
Great video! 👌🏻
Thank you 🙏
Thank you for this series! To follow along with it, do you have the workbook you're using in this video , available to download so we can follow in real time and mess around with?
There’s a link to the workbook in the video description.
@@MyOnlineTrainingHub thanks for getting back to me... looks like I found the link but it’s available for paying customers. Thanks anyway! www.myonlinetraininghub.com/preview-excel-syllabus
That's not the link in the video description. The workbook is available for free if you just follow the link in the video description as I suggested. Here it is again: www.myonlinetraininghub.com/workbook-downloads
I’ve got a question I have a long list that I want to paste and for it to get into individual cells but it’s being paste in one cell I don’t know why if you could help me that would be great
Please post your question and sample Excel file on our forum where someone can help you further: www.myonlinetraininghub.com/excel-forum
Love your videos, they are very helpful! Learned a really great trick in this video that was going to make my life much simpler. Special paste - paste link. I have several cogs spreadsheets that I condense into a few. Manually copy and paste every time. Not hard but annoying when I know there's probably a dozen better ways. I'm still learning with help from your videos! This one has me stumped though. Wondered if you might help me. Successfully pasted link instead of just the regular paste. When I change the original it automatically changes the data everywhere else. Easy peasy. However the files are now too big to attach to an email. I've googles like crazy and can't find anything helpful. Any wisdom you can offer on this would be greatly appreciated? Thanks in advance!!
Glad you find my videos helpful, Sean! You could embed your spreadsheet in a web page instead of emailing it. I've got a video on that coming out next week, so keep your eye out.
Hi Maam! Is there a way to copy multiple UUIDs from different cells in a sheet and paste them in a single cell of another sheet of the same workbook? Thank you for your wonderful videos! :)
No, you can't copy multiple cells and paste them into a single cell, but you can use the TEXTJOIN function: www.myonlinetraininghub.com/excel-textjoin-function
Hi thank you so much for great tutorial. Please teach me how to make a sales plan for electricity branch with bill printing with Excel. Thank you very much.
Glad you enjoyed it, Reza!
@@MyOnlineTrainingHub so please teach me how to make a sales plan for electricity branch with bill printing with excel .thanks very much
Hi, I have a problem with copy pasting. Maybe you can help me:
If I want to paste and not overwrite data you showed the popup with the shift cell up or down. How can I activate this feature?
In my german Version it does not seem to work.
This feature isn't something you turn off or on. I wonder if you're not placing your mouse on the edge of the cell border. You need to get the 4 headed arrow mouse pointer before left-clicking and dragging while holding shift.
Thanks a lot
Most welcome :-)
Hi Mynda, I hope you can help me with a small problem. I'm using Office 2013 on a new laptop. Every time I hit Copy the whole worksheet sort of jumps for a fraction of a second and then everything is OK. Paste works OK, but it's disconcerting and hard on the eyes to have the sheet jump around like that. Any ideas?
Hi Tony, I'd say it's to do with the video driver settings. Hope that points you in the right direction.
Thanks for that Mynda - I'll look into it. I also opened an xls file that was giving me the problem and resaved it as an xlsx file and the problem went away, but other xls files are OK. Strange!
Oh yeah, you don’t want to be opening it as a .xls avoid that format if possible.
Video idea: how to properly drag and drop across different rows when a filter is applied on a table...
Not a good idea to drag and drop multiple cells on a filtered table.
@@MyOnlineTrainingHub exactly my point... it can ruin the data table; hence what is the best approach to address this issue.
"There's no best way, it's completely up to you"? That's completely wrong. Cut and Copy of formulas have very different "consequences". Not knowing those difference is why I"m on youtube looking for a training video to help my colleague understand why she broke our template.
I was referring to the "entry points" for cutting/copying/pasting, e.g. to cut you can CTRL+X or you can use the mouse and right-click > cut, or you can use the Home tab > click the Cut icon. That's 3 different entry points for cutting and there's no best way, it's completely up to you. Hope that clarifies things.
❤❤❤
Thanks for watching 😊