Business Business Analytics & Intelligence Data Visualization

Data Visualization with Excel - Crash Course

Learn Excel for Business. Learn the most useful features of excel to develop dynamic business dashboards and Graphs.
Rating: 4.4 out of 5 (598 ratings)
16,597 students
Created by Mobeen Ayub
English
English [Auto]

Data Visualization
Pivot Tables
Basic Excel

Requirements

  • English

Description

1. Learn to create a database and some excel formulas and shortcuts common for people in Universities and Corporate roles.

2. Learn to create different metrics and KPI's (Key Performance Indicators) from the main database in the form of Pivot Tables which update automatically when you update data in the main table.

3. Learn to visualize data in the database in the form of different charts which automatically update when you update the data in the table.

Who this course is for:

  • Corporate Employees, Entrepreneurs, Small Business Owners, Students, Graduates

Course content

1 section • 6 lectures • 33m total length

  • Building a Database
    09:20
  • Creating Pivot Tables
    11:51
  • Visualizing with Charts
    06:03
  • Visualizing with Charts - Continued
    04:38
  • Create a "Dashboard" that updates with addition of New Data
    01:14
  • Bonus Video - Learn basics of business and start-ups
    00:01

Instructor

Mobeen Ayub
MBA, Entrepreneur, BI enthusiast, Leadership Trainer
Mobeen Ayub
  • 4.4 Instructor Rating
  • 629 Reviews
  • 16,683 Students
  • 2 Courses

5 yrs+ work experience in team leadership, sales and entrepreneurship. Electrical Engineer by background and specialize in initiative development for new ventures.  Expertise in strategic leadership and growth consultancy for small and medium sized businesses.

Strong Areas:

1. Mindset Development.

2. Career Counselling.

3. Startups and Entrepreneurship.

4. Data Science and Analytics.

5. Leadership Training and Personal Development.


Education:

1. BS Electrical Engineering

2. MBA Entrepreneurship & Marketing

3. Certified Business Analyst

4. Certified MS Excel Visualization Expert