fbpx
  • No products in the basket.

About the Data Visualization Using Excel course:

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.

Learning Outcomes of Data Visualization Using Excel Course :

By the end of this Data Visualization using Excel course, one will be able to:

  1. Generate powerful reports and dashboards that will help people make decisions and take action based on their business data.
  2. Learn the various Excel functions and apply the same suitably in day-to-day applications.
  3. Learn the different features of Pivot Tables like Grouping, Calculated Fields, etc.
  4. Get one on one support.
  5. Test your skills with 11 real-world assignment and 2 case studies 

Who can enroll ?

  • Students from any engineering (B.Tech, BE, M.Tech, ME) 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 (B.Sc., B.Com, M.Sc., M.Com, BCA, MCA, etc.).

Why Data Analytics using Excel ?

Contrasted with R and Tableau, Excel may appear to be obsolete nowadays but, it is still very well known for two reasons –

  • Accessibility.
  • Ease of Use.

It likewise enables you to coordinate with different segments of MS Office to make introductions and reports effectively. We are well aware of the significance of Office Suite and also know that it is irreplaceable.

Excel is useful for managing, manipulating, and presenting data. It offers a number of functions for statistical analysis – descriptive and inferential and provides a standard spreadsheet that you can use for a variety of tasks like updating databases, or representing data graphically. Excel can also be useful in collating data for analysis using a number of other software.

Requirements :

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

Course Curriculum

  • Assignment 1: Fundamentals of Excel 00:00:00
  • Assignment-2: Date and Time Function 00:00:00
  • Assignment 3: Data Cleaning 00:00:00
  • Assignment 4: Data Validation 00:00:00
  • Assignment 5: Pivot Table 00:00:00
  • Assignment 6: Lookup Function 00:00:00
  • Assignment 7: Advance Functions 00:00:00
  • Assignment 8; Array Functions 00:00:00
  • Assignment 9 00:00:00
  • Assignment 10 00:00:00
  • Assignment 11: Custom Charts 00:00:00
  • Case Study-1 00:00:00
  • Getting Started
    Introduction to the Course FREE 00:00:00
    Fundamentals of Microsoft Excel
    Excel Interface & Executing Shortcuts 00:00:00
    Formatting 00:00:00
    Conditional Formatting 00:00:00
    Functions 00:00:00
    Cell Referencing 00:00:00
    Date & Time Functions
    Date & Time Function 00:00:00
    Data Cleaning
    Data Cleaning & Text Function 00:00:00
    Logical Function 00:00:00
    Filter 00:00:00
    Advance Filter 00:00:00
    Data Validation
    Data Validation 00:00:00
    Security 00:00:00
    Pivot Table
    Pivot Table 00:00:00
    Calculated Field 00:00:00
    Slicer
    Slicer 00:00:00
    Lookup Function
    V_Lookup 00:00:00
    H_Lookup 00:00:00
    Using advance functions of Microsoft Excel
    Countifs 00:00:00
    Sumifs 00:00:00
    Match, Index & Offset 00:00:00
    Whatif Analysis 00:00:00
    Name Range & Dynamic Chart 00:00:00
    Array Functions
    Sum product 00:00:00
    Countifs 00:00:00
    Large 00:00:00
    Advance Function-2
    Advance Conditional Formatting 00:00:00
    Dependable Combobox 00:00:00
    Data Visualization
    Formatting Basics 00:00:00
    Pareto Analysis 00:00:00
    Interactive Charts- Part 1 00:00:00
    Interactive Charts: Part 2 00:00:00
    Creating Custom Charts
    Thermometer Chart 00:00:00
    Population Pyramid Chart 00:00:00
    Waterfall Chart 00:00:00
    Dashboard Creation & Report making
    Analyzing data 00:00:00
    Doing ground work 00:00:00
    Creating charts 00:00:00
    Dashboard 00:00:00
    Case Study

    Course Reviews

    5

    5
    1 ratings
    • 5 stars1
    • 4 stars0
    • 3 stars0
    • 2 stars0
    • 1 stars0
    1. Great Course

      5

      This course has helped me to make my team’s report look more easy to comprehend. Ali has taught it quite elegantly and since it covers from scratch I would recommend this course for all beginners and to ones looking to learn more about dashboard creation.
      Kudos to Zikshaa!

    110 STUDENTS ENROLLED

    Top Rated Course

    Course Reviews

    Zikshaa Pvt Ltd (2020) © zikshaa. All rights reserved.