Microsoft Excel: Data Reporting and Dashboards From Scratch!
- 0.0
-
![]()
![]()
![]()
![]()
![]()
Brief Introduction
Get the "Right Knowledge" to work with your Data in Excel and learn to build your own Interactive Excel DashboardsDescription
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 - Got 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.
Requirements
- Requirements
- You should have Excel 2007 or a later version Installed on your system
- You should have a need to learn Excel (Check the course contents to see if this course matches your requirements)
Complete Tableau 2021 Training for Absolute Beginners
- 4.6
-
![]()
![]()
![]()
![]()
![]()
The only Tableau course that teaches the entire Tableau Platform - Public, Desktop, Prep, Online, Server and Bridge 30-day 100% Money Back Guarantee if you are not satisfied....
Visually Effective Excel Dashboards
- 4.7
-
![]()
![]()
![]()
![]()
![]()
Actionable Excel Tips (Templates Included) You Can Use Right Now to Create Eye-Catching Microsoft Excel Dashboards Creating an impressive, interactive Microsoft Excel Dashboard from scratch is not easy!...
Excel Power Query, Power Pivot, Power Map & DAX Masterclass
- 4.5
-
![]()
![]()
![]()
![]()
![]()
Learn Excel Power Query, PowerPivot, DAX, Power View & Power BI Tools. Build Excel Data Analyst Models with Excel 2019 COMPLETELY REDONE ON FEB 2021 WITH NEW VIDEOS!...
Power BI - Data Analytics Essentials with Power BI
- 4.5
-
![]()
![]()
![]()
![]()
![]()
Get Started Quickly with Visualization, Data Prep and DAX on Power BI Many students who have taken this course have found it detailed and easy to understand....
