Statistics transforms data into meaningful information, enabling organizations to make better decisions and predictions. Hence, it is a valuable skill to learn in business or academia. This course will teach participants how to perform the most important and commonly used analytics and modeling techniques in Excel. Topics covered include descriptive, diagnostic, predictive, and prescriptive analytics. Participants will be trained using a case-based approach with either real or simulated data sets, to solidify their knowledge so they can apply the techniques that they have learned to their own work.
What You Will Learn
Upon completion of this course, the learners are expected to:
- better understand what has happened to a business or organization, based on historical data, by performing foundational analytic techniques (e.g. aggregation-based analysis, descriptive statistics, profiling, and segmentation) using Excel’s basic functionalities;
- leverage powerful statistical functions and add-ins of Excel to test business hypotheses or to make forecasts or predictions; and
- use Excel’s What-If functionality to perform simulations, sensitivity analysis, and optimization that would support recommendation of preferred course of action.
You will need a computer or laptop with Microsoft Excel installed. Computer or laptop requirements are:
- For Windows: Core i3 or better, 4GB RAM or better, MS Excel 2007 or better
- For MacBook: ideally MS Excel 2013 or newer should be installed (some functions require this version on the Mac). If the version of MS Excel is 2011, download and install StatPlus.