Learn to apply the important concepts and techniques in data analysis using Excel.
Do any of the following apply to you?
Do you want to really know your way around Excel? You have data for your work or business but you?re not sure what to make of it? You might know your way around Excel but you?re not confident about turning data into business insights You frequently receive Excel spreadsheets from others but want to better understand how they arrived at their conclusions? You want to learn the best practices when it comes to using Excel for data analysis. You are intimidated by spreadsheets and terms like Pivot Tables and VLookups You want to learn skill set that is useful for any role in any industry you get into later. Every business generates data. But whether you?re able to turn that into insides depends on your ability to process, manipulate, and ultimately translate that data into useful insights.
Whether you?re working for a company or running your own, being able to make better decisions require you to be able to analyze and interpret data.
What data do you need? How do you prep that data? How do you analyze it to answer specific questions?
In this course, we?re going to show you step by step, exactly how to do that, by starting with the very basics.
Why Microsoft Excel?
Excel is still the most widely used analytical tool used by analysts in all industries across all roles. It?s used by financial analysts, marketing analysts, sales analysts, and of course, data analysts.
Yes, there are many more tools out there but if you learn and master the core concepts and techniques of data analysis in Excel, you?ll be able to apply those learnings to other areas.
But do not underestimate Excel?a single worksheet can technically hold more than 17 BILLION data points (but it will make your computer REALLY slow). And for most of us running analysis most of the time, we?ll need to process far fewer data points than this.
This course is as much about Excel, if not more, than data analysis concepts and techniques.