Get started with DataCamp's Excel Fundamentals Learning Track here ➡ datacamp.pxf.io/ExcelFundamentalsDataCampMoChen Or check out the Data Analyst Certification by DataCamp here ➡ datacamp.pxf.io/dataAnalystCert
What a video you shared there I found it super helpful to discover those handy keyboard shortcuts for Excel that make tasks much quicker to complete. There were a few shortcuts that were totally unfamiliar to me. Now I'm excited to try them out myself in real situations. Thanks much, for passing along these valuable tips!
My takeaways: - Clicking a worksheet tab + Holding the Control Key and dragging to a preferred destination to duplicate a worksheet. - I am used to CTR+ALT+V+check the VALUE Radio button to paste Values. Now I have another way to do it : ALT+H+V+V. Thanks Mo!
Might be even faster and better if you use Ctrl + Shift + V to paste values. Considering we use Ctrl + V to paste, a simple Shift might be more favorable since they differ by 1 button and all 3 keys are all in the lower left corner of the keyboard. Possibly easy to remember for a lot of people. 😊 Your friendly Accountant. 🤓
Brother Please make a detailed video on how to create a Portfolio for a data analyst fresher. Hope you'll consider my request and upload the content soon !😊
Get started with DataCamp's Excel Fundamentals Learning Track here ➡ datacamp.pxf.io/ExcelFundamentalsDataCampMoChen
Or check out the Data Analyst Certification by DataCamp here ➡ datacamp.pxf.io/dataAnalystCert
There is Alt+E+S to paste value or other operations with copying faster
it's like Mo Chen is listening to my thoughts now!!! Love your content, keep them coming.
Excel shortcuts are a game-changer! Thanks for breaking these down with such clear examples, bookmarking this one for sure.
What a video you shared there I found it super helpful to discover those handy keyboard shortcuts for Excel that make tasks much quicker to complete. There were a few shortcuts that were totally unfamiliar to me. Now I'm excited to try them out myself in real situations. Thanks much, for passing along these valuable tips!
Glad it was helpful!
My takeaways:
- Clicking a worksheet tab + Holding the Control Key and dragging to a preferred destination to duplicate a worksheet.
- I am used to CTR+ALT+V+check the VALUE Radio button to paste Values. Now I have another way to do it : ALT+H+V+V.
Thanks Mo!
Great video as usual! Ctrl + LMB + Drag for copying sheets is so good.
For paste values though much easier one is Ctrl Shift V
Great tip!
Definitely gonna remember some of these
Great!
Hoping for more videos on excel shortcuts in the future.
can you share also the dataset ready to download so we can practice? appreciate it
It’s a kaggle dataset. Link in description
I’m coming from Tik Tok, thank you for sharing
Might be even faster and better if you use Ctrl + Shift + V to paste values. Considering we use Ctrl + V to paste, a simple Shift might be more favorable since they differ by 1 button and all 3 keys are all in the lower left corner of the keyboard. Possibly easy to remember for a lot of people. 😊
Your friendly Accountant. 🤓
Good shout, thank you!
Alt H V V Same as CTRL, Shift V?
I think I saw you on the street of HCM city today. Want to come up and say thanks for all the great videos but you walked too fast 😅. Thanks Mo
It was definitely me! If you see me again, please say hi :)
can u do a video on functions like vlookup and index match PLS! I watch tutorials and it still confusing. You explain things more easily
Already did 😃 ruclips.net/video/n0vqkuRyMvQ/видео.htmlsi=OO3giR89tPlZQthQ
@ oh , thanks!!
Make a video on time intelligence
Brother Please make a detailed video on how to create a Portfolio for a data analyst fresher.
Hope you'll consider my request and upload the content soon !😊
Already did :) Check this out here ruclips.net/video/GGsAKyk_Ahw/видео.htmlsi=0hd65fDFB3yKSDSI
Hard to get jobs in data analyst bro kindly help me to land in th job