Microsoft Excel: Reporting and Dashboards
4.4 (4 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,101 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Microsoft Excel: Reporting and Dashboards to your Wishlist.

Add to Wishlist

Microsoft Excel: Reporting and Dashboards

Learn the fundamental concepts of Data using Excel
4.4 (4 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,101 students enrolled
Created by Kamal Vaswani
Last updated 9/2017
English
Current price: $10 Original price: $25 Discount: 60% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 6.5 hours on-demand video
  • 24 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Enjoy working with Excel
  • Save loads of time at work
  • Build interactive Dashboards
  • Apply the universal concepts on the real life scenarios.
View Curriculum
Requirements
  • “It is simple to think complicated. But its Difficult to think simple”
  • "Advanced = Complicated" (Only when your basics are not clear)
  • Understanding WHYs of Concepts makes the Learning 3 Times simpler
Description

This course gives you a perfect start to the "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 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 concepts.

  1. Data Understanding
  2. Analytics terminologies
  3. Data Cleaning
  4. Data Preparation
  5. Data Summarizing
  6. Data Presentation
  7. Reporting & Dashboards

All of this using Microsoft Excel.

After completing this course you will be able to:

  1. Understand the concepts and terminologies with respect to Data.
  2. Save time and effort by using smart functionalities of Excel.
  3. Know Excel in and Out
  4. Be ready to answer Interview questions.

Looking forward to hear back from you about the course.

Who is the target audience?
  • This course is for Excel Users who want to make their work simpler
  • Excel users who aspire to save time
Students Who Viewed This Course Also Viewed
Curriculum For This Course
82 Lectures
06:35:35
+
Get to know Excel Correctly
10 Lectures 32:26

Tangible and Intangible Features
01:18

All Tabs Overview
03:30

Excel Options: Adding Developer Tab
02:42

Formula Bar
02:55


Status Bar
02:10

Types of Shortcuts
06:14

Custom Lists and Fill handle Dragging.
03:33

Creating your own Custom Lists
05:52
+
Understanding Your Data
10 Lectures 59:31
Section Intro
02:36


Solution: Q1-Q3 (Data Understanding)
06:10

Data Makeup - Number Formats
07:37

Solution: Q4-Q6 (Conditional Formatting )
10:02

Solution: Q7-Q9 (Conditional Formatting )
07:02

Solution: Q10-Q12 (Conditional Formatting )
09:51

Solution: Q13 (Find & Replace)
03:56

Solution: Q14-Q16 (Copy, Paste & Paste Special )
07:18

Solution: Q17-Q18 (Go To Special)
04:14
+
Sort & Filter
6 Lectures 32:01
Intro to Section
01:42

Explaining: Sort & Filter
05:56


Solution: Q1-Q4 (Sort & Custom Sort)
11:38

Solution: Q5-Q7 (Filters & Custom Filters)
06:18

Solution: Q8-Q10 (Custom Filters & Advanced Filters)
06:02
+
Data Cleaning
5 Lectures 13:17


Solution: Q1 (Removing Duplicates)
03:17

Solution: Q2 (Missing Value Treatment)
04:50

Solution: Q3 (Redundant Columns)
02:08
+
Formulas & Functions
4 Lectures 23:24

Symbols used in Excel Functions (Part 1)
05:13

Symbols used in Excel Functions (Part 2)
04:30

Symbols used in Excel Functions (Part 3)
06:38
+
Data Preparation
1 Lecture 04:56
+
Data Preparation(Date Functions)
6 Lectures 30:30

Solution: Q1-Q3 (Year, Month & Day Functions)
04:50

Why? (Connecting back to the Theory)
01:04

Solution: Q4-Q6 (Date Calculations)
05:55

Solution: Q7-Q8 (Advanced Date Calculations)
07:15

Solution: Q9 (Advanced Date Formatting)
09:30
+
Data Preparation(Logical Functions)
6 Lectures 25:12
Explanation & Case Study Intro
03:05

Solution: Q1-Q2 (IF Function)
04:52

Solution: Q3 (Nested IF)
04:05

Solution: Q4 (OR Function)
04:50

Solution: Q5 (AND Function)
04:40

Solution: Q6 (IFERROR Function)
03:40
+
Data Preparation(Text Functions)
5 Lectures 29:06
Introduction
04:41

Solution: Q1-Q2 (Basic Text Functions)
04:14

Solution: Q3 (LEFT & FIND)
04:33

Solution: Q4 (MID & FIND)
09:50

Solution: Q5-Q6 (REPLACE & SUBSTITUTE)
05:48
4 More Sections
About the Instructor
Kamal Vaswani
4.4 Average rating
4 Reviews
1,101 Students
1 Course
There is no better way of learning than applying it.

I come with a decent 10,000+ hours of training individual, corporate and online live and video mode. 

I come from a commerce background and most of the topics you see me teaching here have not much link to my background. Yes, I learnt these skills myself for my own self and I learnt these better while training students. 

I definitely had a hard time learning these skills, specially coding (was completely beyond my dreams). But after learning it the hard way I did find ways to make it simple to understand. Exactly what one needs.  

My strength : to make things simple for understanding. I enjoy doing this. I hate making things complex.