Microsoft Excel for Data Analytics

What you'll learn

By the end of this "Data Visualization using Excel" course, one will be able to: Read Data, Clean data, create multiple dashboards and create reports.
Generate powerful reports and dashboards that will help people make decisions and take action based on their business data.
Learn the various Excel functions and apply the same suitably in day-to-day applications.
Learn the different features of Pivot Tables like Grouping, Calculated Fields, etc.
Test your skills with multiple resources,quiz and a real world case studies

Requirements

This course was created with Excel 2016. But all features will work in Excel 2010, 2013, 2016, and most will work in 2007.

Description

This course is for beginners, who will learn data cleaning and data visualization with one of the most powerful tools – Excel. This “Data Visualization Using Excel” course will cover from the basic level to advance level of Excel tool. at the end of the course one will be able to:-

Read data

Clean data

Create multiple dashboards

Create reports, and

Be familiar with all the functions of Excel.

Who this course is for:

Students from any engineering background can enroll in this course.
Secondly, any management students (BBA, MBA) can also enroll in this course.
Professionals looking for a change in their career or promotions can enroll for this course.
Moreover, anyone from a quantitative background can also enroll in this course.