HOT
blank

Microsoft Excel: Data Reporting and Dashboards From Scratch!

Office Productivity

Rating4.4
Enroll Now

Microsoft Excel: Data Reporting and Dashboards From Scratch!, available at $84.99, has an average rating of 4.35, with 95 lectures, 1 quizzes, based on 140 reviews, and has 1619 subscribers.

You will learn about 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 This course is ideal for individuals who are Working professionals who work on Data/ aspire to work on Data or Beginners who would like to learn excel the right way from scratch or Excel users who would like to enhance their Knowledge It is particularly useful for Working professionals who work on Data/ aspire to work on Data or Beginners who would like to learn excel the right way from scratch or Excel users who would like to enhance their Knowledge.

Enroll now: Microsoft Excel: Data Reporting and Dashboards From Scratch!

Summary

Title: Microsoft Excel: Data Reporting and Dashboards From Scratch!

Price: $84.99

Average Rating: 4.35

Number of Lectures: 95

Number of Quizzes: 1

Number of Published Lectures: 95

Number of Published Quizzes: 1

Number of Curriculum Items: 98

Number of Published Curriculum Objects: 98

Original Price: ₹7,500

Quality Status: approved

Status: Live

What You Will 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

Who Should Attend

  • Working professionals who work on Data/ aspire to work on Data
  • Beginners who would like to learn excel the right way from scratch
  • Excel users who would like to enhance their Knowledge

Target Audiences

  • Working professionals who work on Data/ aspire to work on Data
  • Beginners who would like to learn excel the right way from scratch
  • Excel users who would like to enhance their Knowledge

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.

  1. Data Understanding – Using concepts that will help you understand the framework of your Data in Excel

  2. Data Cleaning – Using various tools like – Go To special, Remove duplicates, etc

  3. Data Preparation – Using various Functions like VLookup, Text Functions, Date Functions, Logical Functions, etc

  4. Data Summarizing – Explained using Functions and Pivot Tables

  5. Data Presentation – Explained using Different chart types we should use depending on the requirement.

  6. 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:

  1. Work confidently and Save your time and effort by using smart functionalities of Excel.

  2. Create your own interactive Reports and Dashboards

  3. Re implement the concepts to different problems

  4. Be ready to answer Interview questions.

  5. Start Loving Excel (in case you currently don’t)

Looking forward to hear back from you about the course.

Course Curriculum

Chapter 1: Understanding Your Goals

Lecture 1: Course Outline

Lecture 2: Defining: Dashboards, Reports and Switchboards

Lecture 3: Properties of a Good Dashboard

Lecture 4: Steps to create Dashboards = Flow of this course

Chapter 2: Understanding the Platform – Microsoft Excel

Lecture 1: Intro to the section

Lecture 2: Tangible and Intangible Features

Lecture 3: All Tabs Overview

Lecture 4: Excel Options: Adding Developer Tab

Lecture 5: Formula Bar

Lecture 6: Name Box

Lecture 7: Status Bar

Lecture 8: Types of Shortcuts

Lecture 9: Try & Learn: Must know Keyboard Shortcuts

Lecture 10: Custom Lists and Fill handle Dragging.

Lecture 11: Creating your own Custom Lists

Chapter 3: Understanding Your Data

Lecture 1: Section Intro

Lecture 2: Case Study Intro

Lecture 3: Solution: Q1-Q3 (Data Understanding)

Lecture 4: Data Makeup – Number Formats

Lecture 5: Solution: Q4-Q6 (Conditional Formatting )

Lecture 6: Solution: Q7-Q9 (Conditional Formatting )

Lecture 7: Solution: Q10-Q12 (Conditional Formatting )

Lecture 8: Solution: Q13 (Find & Replace)

Lecture 9: Solution: Q14-Q16 (Copy, Paste & Paste Special )

Lecture 10: Solution: Q17-Q18 (Go To Special)

Chapter 4: Sort & Filter

Lecture 1: Intro to Section

Lecture 2: Explaining: Sort & Filter

Lecture 3: Questions

Lecture 4: Solution: Q1-Q4 (Sort & Custom Sort)

Lecture 5: Solution: Q5-Q7 (Filters & Custom Filters)

Lecture 6: Solution: Q8-Q10 (Custom Filters & Advanced Filters)

Chapter 5: Data Cleaning

Lecture 1: Introduction to section

Lecture 2: Introduction to Case Study

Lecture 3: Solution: Q1 (Removing Duplicates)

Lecture 4: Solution: Q2 (Missing Value Treatment)

Lecture 5: Solution: Q3 (Redundant Columns)

Chapter 6: Formulas & Functions

Lecture 1: Introduction to Excel Functions

Lecture 2: Symbols used in Excel Functions (Part 1)

Lecture 3: Symbols used in Excel Functions (Part 2)

Lecture 4: Symbols used in Excel Functions (Part 3)

Chapter 7: Data Preparation

Lecture 1: What is Data Preparation?

Chapter 8: Data Preparation(Date Functions)

Lecture 1: Explanation & Case Study intro

Lecture 2: Solution: Q1-Q3 (Year, Month & Day Functions)

Lecture 3: Why? (Connecting back to the Theory)

Lecture 4: Solution: Q4-Q6 (Date Calculations)

Lecture 5: Solution: Q7-Q8 (Advanced Date Calculations)

Lecture 6: Solution: Q9 (Advanced Date Formatting)

Chapter 9: Data Preparation(Logical Functions)

Lecture 1: Explanation & Case Study Intro

Lecture 2: Solution: Q1-Q2 (IF Function)

Lecture 3: Solution: Q3 (Nested IF)

Lecture 4: Solution: Q4 (OR Function)

Lecture 5: Solution: Q5 (AND Function)

Lecture 6: Solution: Q6 (IFERROR Function)

Chapter 10: Data Preparation(Text Functions)

Lecture 1: Introduction

Lecture 2: Solution: Q1-Q2 (Basic Text Functions)

Lecture 3: Solution: Q3 (LEFT & FIND)

Lecture 4: Solution: Q4 (MID & FIND)

Lecture 5: Solution: Q5-Q6 (REPLACE & SUBSTITUTE)

Chapter 11: Data Preparation(Lookup & Reference Functions)

Lecture 1: Introduction

Lecture 2: Decision Matrix and Case Study Intro

Lecture 3: Solution: Q1 (VLOOKUP)

Lecture 4: Solution: Q2 (Index & Match)

Lecture 5: Solution: Q3 (VLOOKUP + Wildcard)

Chapter 12: Data Summary

Lecture 1: Introduction

Lecture 2: Introduction to Case Study

Lecture 3: Basic Aggregate Functions

Lecture 4: Named Ranges

Lecture 5: Conditional Aggregate Functions (COUNTIF)

Lecture 6: Conditional Aggregate Functions (Using Wildcards)

Lecture 7: Multi-Condition Aggregate Function (COUNTIFS, SUMIFS)

Lecture 8: Conclusion

Chapter 13: Data Presentation (Dashboard)

Lecture 1: Introduction

Lecture 2: Creating Charts

Lecture 3: Dashboard Recap

Lecture 4: Controls

Lecture 5: Check boxes

Lecture 6: Formatting Controls

Chapter 14: Data Summary (Pivot Table)

Lecture 1: Introduction to Section and Case Study

Lecture 2: Solution: Q1-Q2 (Basic Pivot Features)

Lecture 3: Solution: Q3 (Summarize By)

Lecture 4: Solution: Q4 (Calculated Field)

Lecture 5: Solution: Q5 (Grouping Dates)

Lecture 6: Solution: Q6 (Report Filter Pages)

Chapter 15: Dashboard (Pivot Table)

Lecture 1: Introduction

Instructors

  • Kamal Vaswani
    Kamal Vaswani
    Sr Business Analyst |10,000+ Hrs of Experience as Instructor

Rating Distribution

  • 1 stars: 0 votes
  • 2 stars: 2 votes
  • 3 stars: 16 votes
  • 4 stars: 44 votes
  • 5 stars: 78 votes

Frequently Asked Questions


How long do I have access to the course materials?


You can view and review the lecture materials indefinitely, like an on-demand channel.


Can I take my courses with me wherever I go?


Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

You may also like

Top 10 Chatgpt And Ai Tools Courses to Learn in November 2024

Top 10 Excel Vba Courses to Learn in November 2024

Master Lead Generation: Grow Subscribers & Sales with Popups