The level of functionality of Excel has brought tears to my eyes a couple of times in my life, I swear to God.
This is such a brilliant video. 10 minutes is just right to get people excited. We newbies can actually follow it with playbacks.
Learn 5 awesome data analysis tricks here: https://youtu.be/0yvemzEzt-E
For mac usres "Paste Values" shortcut to paste the data. To do this, press "Command + Option + V" on your keyboard. Alternatively, you can right-click on the cell and select "Paste Values" from the context menu.
I am the International Transportation SR Analyst for Dollar General. Never been to college. Learned everything on YouTube.
Im a few days into the Google Cert course (about 5 hours) and so far I'm liking it. Not much hands on, mainly concepts. You're video was straight to the point, no flush and jam packed with great info. This got me excited and fired up to continue! Thank you so much! I'm now a subscriber!
I am enrolled in the Google Data Analytics Professional Certificate program, which is made up of 8 courses. I am currently in week 2 of the 4th part of the program.. Your 10 minutes video has benefited me significantly more than the 2-3 months I spent on Google's program... So seeing you promote for it confuses me.
Man! I'm absolutely in love with all your videos. The pace is easy to follow. You're teaching methods, and showing were better than most professors at the University.
Thank you! You helped me pass an Excel data analysis exercise I needed for a job interview
(for only values paste) i recommend ctrl+shivt+v instead of alt + h + v + v
i almost bored by learning so many tools as much but after seeing this video wow man what an explanation such a fan of you
Entry level folks if you just replicated this analysis, you will be miles ahead of your competition. Excellent video.
Awesome stuff! I'm a junior data analyst but I didn't even know about the paste values shortcut - ALT + H + VV
You're a life saver man, I was looking for how to activate the Data Analysis. Simple and Straightforward Guide. Thank you, good sir!
thanks so much. kindly note that most of the short cut keys no long work , since there has been so many updates on excel , you might have to find the new key for instance alt + H+VV wont work else use Ctr + Shift + V. thanks
I think investors should always put their cash to work, especially In 2024, we'll start to see more market diversification. I'm hoping to invest about $350k of my savings in stocks against next year. Hope to make millions in 2024
You explained it well and made it easy to understand. I'm a novice in excel and barely know about some of the formulas and functions as shown but it was easy to follow. Made me excited to try it myself on my work as well.
2:06 using the ROUNDUP function isn't accurate, as values like 201.01 become 202. What I'd recommend, select the cell F3, do Ctrl+Shift+Down arrow, to select the whole data column, then on the ribbon click on decrease decimal icon, its in number settings
Thank you for including the data sheet to work along with!
@KenjiExplains