Microsoft Excel 365 bootcamp is a course that exposes students to data analytics tools available in Excel. The course begins with the basics of Excel ( for those who are new to Excel) and then progresses to more advanced tools such as the data analysis toolpack, solver, what-if-analysis, conditional statements, pivot charts, pivot tables etc. In this course students will learn through hands on , practical demonstrations of Excel tools for data analysis and will gain practical knowledge of applying these tools through the final project. The course covers basics to advanced tools, and students will learn applications of these tools in business. Real data is used to teach the concepts and this allows students to gain an understanding of how the Excel tools taught can be applied to the real world. After finishing this course students will learn how to use data and Excel tools to solve business problems, how to study trends in data and use these trends to infer about the business setting they are studying. . The course covers the following topics:

1. Introduction to Excel

2. Importing Data

3. Basic Operations in Excel

4. Statistical functions and applications.

5. Data Visualisation.

6. Data Analysis using Excel

7. Solving Equations in Excel

8. What if analysis

9. Look up and match functions.

10. Pivot tables and charts

11. Statistical Analysis in Excel

Prerequisites:

1. Basic High School Mathematics

2. Basic knowledge of statistical concepts such as mean, media, mode, standard deviation etc.

3. A computer with Mac OS or Windows

4. Eagerness to learn

María Fernanda Hernández Obele

--

1