Learn Excel for Data Analysis| 3+ hrs Video Course

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