Learn how to use Excel for data analysis to an expert level and be able to apply this practical skill in any field. Learn Excel for data analysis from basic to expert level and be able to apply this practical skill in any field. It explores spreadsheet software’s most relevant features which will help you become an expert as beginner, achieve proficiency as basic user or polish skills and finish learning curve as an intermediate one. All of this while using real-world data together with practical exercises done step-by-step.
Become an Expert in Excel for data analysis by learning its most relevant features.
Use main file types and their options.
Store data in worksheets within workbooks.
Navigate worksheets’ cells quickly by using keyboard short-cuts.
Perform data operations with formulas and built-in functions.
Visualize data through conditional formatting and charts.
Organize data interactively with tables and pivot tables.
Implement scenarios with what-if analysis.
Analyze data with statistical and probabilistic add-in tools.
Optimize formula results with solver add-in.
Achieve Excel for data analysis proficiency and be able to apply it in any field.
Learning Excel is essential for any professional or academic career based on data analysis. It is the most commonly used data analysis software both professionally and academically and it’s a solid foundation before learning any other.
But as learning process can become difficult as complexity grows, this course helps by leading you through step-by-step real-world practical exercises for greater effectiveness.
Content and Overview
This course contains over 35 lectures and more than 6 hours of content. It’s designed for all Excel knowledge levels and no previous familiarity is required.
At first, you’ll learn how to use main file types depending on data format and how to protect it when sharing. Then you’ll study how to store data in workbooks containing one or more worksheets and their navigation by identifying cells as intersection points of columns and rows. This can be done quicker when using keyboard short-cuts.
After that, you’ll perform data calculations with formulas and built-in functions, correct any errors in them, and perform input validation when interacting with users. Next, you’ll visualize data with conditional formatting and charts. You’ll organize it interactively with tables and pivot tables which can be sorted and filtered.
Later, you’ll implement scenarios with what-if analysis. You’ll also do data analysis through statistical and probabilistic add-in tools such as identifying trends, deliver descriptive statistics and frequency histograms, evaluate correlation and causation between explained and explanatory variables, and simulate random numbers with pre-defined or user-defined probability distribution functions. Finally, you’ll optimize a formula’s result using solver add-in by defining changing variables and their constraints.
What are the requirements?
Course is done with Microsoft Excel 2010. Easy compatibility with older and newer software versions. Some features are not available in older ones.
Course Excel data file provided by instructor.
NO previous Excel knowledge is required.
What am I going to get from this course?
Over 39 lectures and 6.5 hours of content!
Use main file types depending on data’s original format and protect your spreadsheet when sharing it.
Store data in workbooks consisting of one of more worksheets which can be created according to your requirements.
Navigate worksheets by identifying cells as intersections of columns and rows while grouping them in ranges.
Move quickly through working space by using keyboard short-cuts and specific key-tips.
Perform data operations with basic arithmetic formulas, main categories’ built-in functions and arrays.
Correct formula errors and perform input validation when interacting with users.
Visualize data through conditional formatting, general and specific chart types, and single-cell spark-lines.
Organize data interactively using tables and pivot tables while you sort and filter it according to your needs.
Implement future scenarios through what-if analysis and find value for achieving certain formula result through goal seek.
Analyze data with add-in packages to identify trends by spotting a signal and minimizing the noise.
Summarize descriptive statistics of your data and provide a frequency histogram of these observations.
Evaluate correlation and causation between explained and explanatory variables.
Simulate random numbers based on pre-defined or user-defined probability distribution functions.
Optimize formula result with solver add-in by determining changing variables and their constraints.