Microsoft Excel 365 Bootcamp

About Microsoft Excel 365 Bootcamp

Microsoft Excel 365 Bootcamp is a course that has been designed to allow students to master Excel 365 and learn all the nuances of Excel 365. In this course I begin with the very basics, and then advance step by step to more advanced concepts , tools and techniques that can be used in Excel. The course is designed for those who want to learn the diverse range of applications that Excel is capable of.  This course will allow students to not only master Excel applications, but also to use Excel in a wide variety of situations upon completion of the course. Budding business analysts, business intelligence analysts, data analysts can use Excel to visualise data, generate pivot plots and tables, conduct statistical analysis, solve equations, and this course is designed to impart the aforementioned skills to students. The course uses a learning by doing format, which means that all the lectures are taught in Excel with a hands on approach. Real world examples are used to demonstrate concepts, and practical data is used to demonstrate various Excel tools. At the end of the course, students will be well equipped to use Excel for providing business solutions. The course teaches the following topics:

1. Introduction to Excel

2. Importing Data

3. Basic Operations in Excel

4. Statistical functions and applications.

5. Logical Operators and Conditional Statements in Excel

6. Data Visualisation.

7. Solving Equations in Excel

8. What if analysis

9. Look up and match functions.

10. Pivot tables and charts

11. Statistical Data Analysis in Excel