Essentials Of Analytics In Excel

This course will illustrate data analytics with Excel using fundamental statistical concepts (i.e., descriptive statistics, statistical inference, and regression analysis).

 In so doing, it offers students a jumping-off point into the world of visualizations and data-driven decision-making from a one-stop-shop software solution.  

Participants will become adept at tools such as Pivot Tables, the Data Analysis Toolpak, the VLOOKUP, and other formulas which are relevant and applicable to today's vast enterprises and business endeavors.

Learning Outcomes:

• Navigate Excel's functions and formulas most often used in data/business analytics
• Create tables and charts on the fly/ad hoc
• Formulate and test hypotheses about a population mean and/or a population proportion
• Identify linear relationships in data and produce regression models