No video

Excel for Beginners - Cut, Copy and Paste like a Pro!

  Рет қаралды 85,666

MyOnlineTrainingHub

MyOnlineTrainingHub

4 жыл бұрын

Lesson 4 of 13 - Get started with Excel and learn how to cut, copy and paste like a pro user. Download the Excel file for all 13 lessons here: www.myonlinetr...
Get the full course here: www.myonlinetr...
View all my comprehensive courses: www.myonlinetr...
Connect with me on LinkedIn: / myndatreacy

Пікірлер: 54
@kimberlyhuff9617
@kimberlyhuff9617 9 ай бұрын
This saved my job! Thank you Holy Spirit for leading me here!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 9 ай бұрын
Awesome to hear!
@JessicaMillerNashville
@JessicaMillerNashville 7 ай бұрын
Finally I feel comfortable with this simple task because of this easy video! Thank you!!!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 7 ай бұрын
Great to hear! 🙏😊
@tiadenise4519
@tiadenise4519 2 жыл бұрын
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!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 жыл бұрын
Great to hear you found my videos helpful, Tia!
@wayneedmondson1065
@wayneedmondson1065 4 жыл бұрын
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!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 4 жыл бұрын
Thanks for sharing the keyboard shortcut for the clipboard, Wayne! I'll try to remember that one.
@rezayoun6571
@rezayoun6571 4 жыл бұрын
I love your tutorials very very much. Thank you.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 4 жыл бұрын
Happy to hear that!
@Mphc18
@Mphc18 3 жыл бұрын
Yep, I'm so silly, it finally clicked today and I've completed the course! Thanks for replying.
@nikakalichava8012
@nikakalichava8012 2 жыл бұрын
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.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 жыл бұрын
Great to hear, Nika! 😊
@julianarichard1666
@julianarichard1666 6 ай бұрын
Jjjjjkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk
@abdulkareemal-mahdi4288
@abdulkareemal-mahdi4288 4 жыл бұрын
You’re amaizing and i wach majority of your videos especially the dashboard thanks 🙏 alot
@MyOnlineTrainingHub
@MyOnlineTrainingHub 4 жыл бұрын
I appreciate that!
@johnborg5419
@johnborg5419 4 жыл бұрын
Thanks Mynda. That was Great!!! : ) : )
@MyOnlineTrainingHub
@MyOnlineTrainingHub 4 жыл бұрын
Glad you liked it!, John!
@wowmovies10
@wowmovies10 3 жыл бұрын
I learn's today how to use copy, paste and cut in new ways Thank ma'am 🙏🙏
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 жыл бұрын
Glad to hear that, Aashish!
@Kingagaink
@Kingagaink 3 жыл бұрын
Awesome video finally i understand all the type's of paste ❤️❤️❤️❤️❤️
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 жыл бұрын
Great to hear 😊
@rizalfatoni4075
@rizalfatoni4075 3 жыл бұрын
Just know new safer method for pasting copied data to avoid messing around in spreadsheet. Thank you Mynda!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 жыл бұрын
You're so welcome, Rizal!
@moisestatis5418
@moisestatis5418 2 жыл бұрын
Great video! 👌🏻
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 жыл бұрын
Thank you 🙏
@joelmayele
@joelmayele Жыл бұрын
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
@MyOnlineTrainingHub
@MyOnlineTrainingHub Жыл бұрын
Please post your question and sample Excel file on our forum where someone can help you further: www.myonlinetraininghub.com/excel-forum
@rezayoun6571
@rezayoun6571 4 жыл бұрын
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.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 4 жыл бұрын
Glad you enjoyed it, Reza!
@rezayoun6571
@rezayoun6571 4 жыл бұрын
@@MyOnlineTrainingHub so please teach me how to make a sales plan for electricity branch with bill printing with excel .thanks very much
@glamourhusnisha6809
@glamourhusnisha6809 3 жыл бұрын
Thanks a lot
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 жыл бұрын
Most welcome :-)
@seandenard3341
@seandenard3341 2 жыл бұрын
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!!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 жыл бұрын
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.
@sukshma239
@sukshma239 4 жыл бұрын
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! :)
@MyOnlineTrainingHub
@MyOnlineTrainingHub 4 жыл бұрын
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
@Mphc18
@Mphc18 3 жыл бұрын
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
@MyOnlineTrainingHub 3 жыл бұрын
There’s a link to the workbook in the video description.
@Mphc18
@Mphc18 3 жыл бұрын
@@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
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 жыл бұрын
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
@selectthedead
@selectthedead Жыл бұрын
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.
@MyOnlineTrainingHub
@MyOnlineTrainingHub Жыл бұрын
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.
@hectorbello2104
@hectorbello2104 4 жыл бұрын
Video idea: how to properly drag and drop across different rows when a filter is applied on a table...
@MyOnlineTrainingHub
@MyOnlineTrainingHub 4 жыл бұрын
Not a good idea to drag and drop multiple cells on a filtered table.
@hectorbello2104
@hectorbello2104 4 жыл бұрын
@@MyOnlineTrainingHub exactly my point... it can ruin the data table; hence what is the best approach to address this issue.
@chemay6027
@chemay6027 7 ай бұрын
❤❤❤
@MyOnlineTrainingHub
@MyOnlineTrainingHub 7 ай бұрын
Thanks for watching 😊
@tonyscott5045
@tonyscott5045 3 жыл бұрын
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?
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 жыл бұрын
Hi Tony, I'd say it's to do with the video driver settings. Hope that points you in the right direction.
@tonyscott5045
@tonyscott5045 3 жыл бұрын
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!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 жыл бұрын
Oh yeah, you don’t want to be opening it as a .xls avoid that format if possible.
@FrrrrrOshs
@FrrrrrOshs Жыл бұрын
"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.
@MyOnlineTrainingHub
@MyOnlineTrainingHub Жыл бұрын
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.
Excel for Beginners - Working with Cells, Rows & Columns including Pro Tips!
5:10
6 Excel Tools Most Users Never Think to Use (Files Included)
12:34
MyOnlineTrainingHub
Рет қаралды 171 М.
Why Is He Unhappy…?
00:26
Alan Chikin Chow
Рет қаралды 98 МЛН
The Joker saves Harley Quinn from drowning!#joker  #shorts
00:34
Untitled Joker
Рет қаралды 52 МЛН
EVOLUTION OF ICE CREAM 😱 #shorts
00:11
Savage Vlogs
Рет қаралды 14 МЛН
How to Cut, Copy and Paste, Part 1 of 2
13:33
Nerd Sidekick
Рет қаралды 99 М.
10 *SURPRISING* Copy Paste Secrets for Excel PROs
8:27
Chandoo
Рет қаралды 244 М.
5 Excel Secrets You'll Be Embarrassed You Didn't Know
17:32
Excel Campus - Jon
Рет қаралды 150 М.
Excel Copy Paste Tricks
11:49
Presentation Process
Рет қаралды 437 М.
Excel Time-Savers - 5 Hidden Features for Busy People
14:24
Leila Gharani
Рет қаралды 370 М.
10 Excel Things You Should NEVER Do and What to do Instead
12:34
MyOnlineTrainingHub
Рет қаралды 588 М.
Excel for Beginners - The Complete Course
54:55
Technology for Teachers and Students
Рет қаралды 6 МЛН
Excel Tricks to Save 95% of Your Time on Boring Tasks
12:34
MyOnlineTrainingHub
Рет қаралды 35 М.
Excel for Beginners - Move, Copy, Name, Group & Hide Sheets
4:00
MyOnlineTrainingHub
Рет қаралды 11 М.
Why Is He Unhappy…?
00:26
Alan Chikin Chow
Рет қаралды 98 МЛН