Become master in Excel Data Analysis with lots of examples
Microsoft Excel is an important tool for data analysis. It helps companies accurately assess situations and make better business decisions. This course helps you unlock the power of your organization's data using the data analysis and visualization tools built into Excel. Author starts with the foundational concepts, including basic calculations such as mean, median, and standard deviation, and provides an introduction to the central limit theorem. He then shows how to visualize data, relationships, and future results with Excel's histograms, graphs, and charts. He also covers testing hypotheses, modeling different data distributions, and calculating the covariance and correlation between data sets. Finally, he reviews the process of calculating Bayesian probabilities in Excel. Each chapter includes practical examples that show how to apply the techniques to real-world business problems.

Topics covered | duration : 3+ hrs Video Course

01 Foundational Concepts of Data Analysis
02 Visualize Data
03 Test a Hypothesis
04 Utilize Data Distributions
05 Measure Covariance and Correlation
06 Perform Bayesian Analysis