Microsoft Excel: Data Reporting and Dashboards From Scratch!

About Microsoft Excel: Data Reporting and Dashboards From Scratch!

This course gives you a perfect start to the "

Data Analytics world

". "_If you feel something is complicated or not your cup of tea, its majorly because you tried jumping on the advanced concepts rather than absorbing the basics first_ " - This course is an effort to provide ample background of each concepts and stresses on the fundamental areas to ensure that you

learn it correctly

and can

re-implement

the concepts when required. This course is not designed to teach you certain functionalities of Excel; But, to teach you the right skills which you can re-implement on other problems too The course is structured to cover all major

Excel Concepts

while

Explaining the Data Reporting concepts

. 1.

Data Understanding

- _Using concepts that will help you understand the framework of your Data in Excel_ 2.

Data Cleaning

- _Using various tools like - Go To special, Remove duplicates, etc_ 3.

Data Preparation

- _Using various Functions like VLookup, Text Functions, Date Functions, Logical Functions, etc_ 4.

Data Summarizing

- _Explained using Functions and Pivot Tables_ 5.

Data Presentation

- _Explained using Different chart types we should use depending on the requirement._ 6.

Reporting & Dashboards

- Explained using Form/ActiveX controls and Pivot Table with the help of Slicers All of this using Microsoft Excel. The course flow ordered exactly like the points above. This order should be followed while working on Excel as well.

After completing this course you will be able to:

1. Work confidently and Save your time and effort by using smart functionalities of Excel. 2. Create your own interactive Reports and Dashboards 3. Re implement the concepts to different problems 4. Be ready to answer Interview questions. 5. Start Loving Excel (in case you currently don't) Looking forward to hear back from you about the course.