Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
7 Hour(s) 49 Minute(s)
Language
English
Taught by
Kamal Vaswani
Rating
Course Overview
Get the "Right Knowledge" to work with your Data in Excel and learn to build your own Interactive visualizations
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.
Data Understanding - Using concepts that will help you understand the framework of your Data in Excel
Data Cleaning - Using various tools like - Go To special, Remove duplicates, etc
Data Preparation - Using various Functions like VLookup, Text Functions, Date Functions, Logical Functions, etc
Data Summarizing - Explained using Functions and Pivot Tables
Data Presentation - Explained using Different chart types we should use depending on the requirement.
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:
Work confidently and Save your time and effort by using smart functionalities of Excel.
Create your own interactive Reports and Dashboards
Re implement the concepts to different problems
Be ready to answer Interview questions.
Start Loving Excel (in case you currently don't)
Looking forward to hear back from you about the course.
Course Content
- 10 section(s)
- 95 lecture(s)
- Section 1 Understanding Your Goals
- Section 2 Understanding the Platform - Microsoft Excel
- Section 3 Understanding Your Data
- Section 4 Sort & Filter
- Section 5 Data Cleaning
- Section 6 Formulas & Functions
- Section 7 Data Preparation
- Section 8 Data Preparation(Date Functions)
- Section 9 Data Preparation(Logical Functions)
- Section 10 Data Preparation(Text Functions)
What You’ll Learn
- Right knowledge about Excel and how to use it smartly
- Create your own Interactive Reports & Dashboards
- Re implement the concepts on different problems
- Organized way to learn excel for Building Reports and Dashboards
Skills covered in this course
Reviews
-
SSharon
Well thought out course, taught me a lot of information about excel and dashboards
-
SSusovon Ghosh
The Course is really well organized and precise to the point approach. This will surely help the beginners as well as the intermediates in excel. However I would like to see a separate tutorial or addition of more sections with advance topics regarding dashboarding and reporting.
-
WWilliam Allsop
SO far its not very interactive, it would be great to have practice exercises
-
RRashmi Mahajan
The Course is very informative and will be very much useful in upgrading our skills , But the only drawback is that the Instructor is delivering lectures very slowly as a result it becomes bit boring and we loose our interest instead instructor should speak bit fast so that we remain engaged and the learning becomes more interesting.
