Excel for Data Analysis
Vložit
- čas přidán 25. 06. 2024
- EXCEL FOR DATA ANALYSIS // Top skills to learn to perform great analytics in Excel.
One of the easiest places to start when you want to build your analytics skills is Excel. It’s readily available, widely used, the learning curve isn’t hard, and there are a LOT of online resources to help. Whether you are a data scientist, business analyst, or just want to be able to understand your data better, Excel is a great resource to use.
As an analyst myself, I’ll go through the top skills anyone doing analytics in Excel should know. While there are hundreds if not thousands of Excel skills you could learn, this will help you prioritize where you build your skills.
__________
► HOW TO BECOME A DATA ANALYST. Get the eBook that lays out the skills you need, how to build them, and launch your career as a data analyst:
bit.ly/TCFDataAnalyst
► RESUMES. Build a great resume that puts you at the top of the candidate list. Designed to be straight-forward and highly effective:
bit.ly/TCFPerfectResume
► COACHING. Want to build a career in analytics? Get personalized coaching with me. Check out the details:
bit.ly/TCFCoaching
► FREE CAREER QUIZ. What’s the best analytics career path for you based on your background, skills, and interests? Take the quiz!
bit.ly/TCFCareerQuiz
__________
ANALYTICS RESOURCES:
DataCamp
bit.ly/TCFDataCamp
Coursera
bit.ly/TCFCoursera
edx
tidd.ly/fa30fe60
Analytics setup
• Data Analyst Work from...
__________
CONNECT WITH ME:
Website: thecareerforce.com
Linked In: / the-career-force
Facebook: / thecareerforce
Instagram: / thecareerforce
NOTE: This description contains affiliate links meant to help you find valuable resources. This channel may earn minimal commissions if you use these links, but you are under no obligation to use them.
• Excel for Data Analysis
#dataanalyst #excelskills - Jak na to + styl
Thanks for watching! Which skill stands out to you the most?
The Career Force hi 👋🏾 I would like to know what laptop is the best for data analytics? Please. I want to buy a new laptop so I would like to know which one. I am a woman. I bought already your digital career path. Thank you.
You rock! But if you could give us a quick visual of what you are talking about performing that would really help.
Thank you Jen. This is the first of your videos I have viewed. Very informative and clear. Keep it up!
Thanks for the amazing content, keep up the good work! :)
Thank you.
I'm a junior studying statistical science and data analytics, and discovering your channel was a such a golden coincidence. Aside from learning the basics in Excel like vlookup, functions, and descriptive statistics, in class I learned about ANOVAs and regressions with simple indicator variables can also be used in Excel. Keep up the great work Jen!
Jimmy, if anyone tries to tell you that Excel can't be used for statistics, ignore them. While Excel doesn't have the complete statistical capabilities of programs like SAS, SPSS or R, using it for an intro stats course is just fine. Way back in the early 1990's Microsoft had to admit that Excel was making errors in rounding numbers, which caused a huge outcry in the stats and analysis community. Turns out, the actual error involved digits that were 3 places to the right of the decimal point! So it was a non-issue. But the hate against Excel for stats still comes up.
I couldn't agree more! Excel has great capabilities and while it might not be as flashy and exclusive as some other tools, it's a workhorse that shouldn't be ignored.
@@andrelegris998 I've seen some people say that they're worried that they'll be looked down upon if they make a graph using Excel and not using a program like Tableau rather than worrying about if the graph effectively conveys their intended message. 🤷
the Greatjon Excel is a tool, just like Tableau is a tool. They are quite different but can both accomplish some of the same data vizz tasks. Excel can’t do quite as many cool visualizations as Tableau but can do more with data than can Tableau. Would you refuse to live in a house if you found out the walls were built with a manual hammer rather than a air-compressor power hammer? Different tools, same result.
Question: Do you know of a easily accessible synthetic or factual business centric data set to practice data analysis on? One with practice questions are even more valuable.
Ma'am how to improve problem solving skills can you make a video on this topic or share any video link that helps me
I subscribed because of @3:43 , plain and simple, gotta learn how to play with legos first 😂. Great video btw.
PLS TELL HOW I COMPARE TWO YEARS SALES DATA & FIND OUT PERCENTAGE WISE GROWTH..ANY FORMULA FOR THAT
Thx a lot
Do you conduct any online course in data analysis or Business Analytics ????
Not currently, but be on the lookout in early 2020...
Dear M'am I have a Questions ?
How to Analysis Data in Accounting
🤙
Hi Jen, I like your videos. They are clear and informative. Also, I think it’s awesome that you’re helping people transitioning into data analytics careers. I’m building my own data skills at the moment and I have some doubts I would like you to clear.
Here’s a little bit about me:
I completed 2 years of computer science in college and I dropped out due to health issues. I’m recovered now and I would like to become an intern or an entry-level data analyst. I’m strong in math and programming and I live in San Francisco, California
My question:
Do I really have to go back to college and finish my degree? Or, would it be more reasonable to seek data analytics training and create a delightful portfolio?
Regards,
Farhaan
Hi Farhaan. I'm glad you're doing better now.
It's definitely going to be a challenge to get even an entry level data analyst role with no degree and (I'm guessing) little/no relevant work experience even if you build a good portfolio. You're also unlikely to find an internship if you're not actively in school as most companies require this for internships. The quickest option to get into analytics is likely to finish your degree and get an internship while you're working on the degree.
Thanks for replying,
Given that these institutions are accredited, would it be fine if I complete my degree online or through a college in India?
I’m in India right now and I have access to seasoned data analysts ready to train me (as they are now).
Also, do you see machine learning and AI replacing this field within the next 10-20 years?
All the best,
Farhaan
Ma'am plz tell me ...what will be better for further cerear ... business analyst or data analyst data science......plz say
Business analytics, data analytics, and data science are all good options for a career. If you want something more tech-centered go the data analyst/data scientist route. If you're more interested in problem solving and business-specific issues, go business analyst. Overall, the problem solving skills that all these roles offer will be in-demand for many, many ears.
Ma'am I am 26 year old...I have done BSC in maths and msc also......am I eligible for data analyst or data scientist...I want to pursue data analyst or Data science as my future.....am I eligible or not plz .....
Hello mam, do you think Excel is not best suit for advance analysis? If yes why?
It depends on the specific type of analysis and the dataset size. Excel doesn't do well with very large sets of data - it can't efficiently process the high volumes.
Plz say.... ma'am....
Was expecting Power Query M, DAX & Data Modelling.