HOT
blank

Microsoft Excel for Data Analytics

Office Productivity

Rating4.2
Enroll Now

Microsoft Excel for Data Analytics, available at $19.99, has an average rating of 4.15, with 39 lectures, 13 quizzes, based on 16 reviews, and has 142 subscribers.

You will learn about By the end of this "Data Visualization using Excel" course, one will be able to: Read Data, Clean data, create multiple dashboards and create reports. Generate powerful reports and dashboards that will help people make decisions and take action based on their business data. Learn the various Excel functions and apply the same suitably in day-to-day applications. Learn the different features of Pivot Tables like Grouping, Calculated Fields, etc. Test your skills with multiple resources,quiz and a real world case studies This course is ideal for individuals who are Students from any engineering background can enroll in this course. or Professionals looking for a change in their career or promotions can enroll for this course. or Secondly, any management students (BBA, MBA) can also enroll in this course. or Moreover, anyone from a quantitative background can also enroll in this course. It is particularly useful for Students from any engineering background can enroll in this course. or Professionals looking for a change in their career or promotions can enroll for this course. or Secondly, any management students (BBA, MBA) can also enroll in this course. or Moreover, anyone from a quantitative background can also enroll in this course.

Enroll now: Microsoft Excel for Data Analytics

Summary

Title: Microsoft Excel for Data Analytics

Price: $19.99

Average Rating: 4.15

Number of Lectures: 39

Number of Quizzes: 13

Number of Published Lectures: 39

Number of Published Quizzes: 13

Number of Curriculum Items: 53

Number of Published Curriculum Objects: 53

Original Price: ₹799

Quality Status: approved

Status: Live

What You Will Learn

  • By the end of this "Data Visualization using Excel" course, one will be able to: Read Data, Clean data, create multiple dashboards and create reports.
  • Generate powerful reports and dashboards that will help people make decisions and take action based on their business data.
  • Learn the various Excel functions and apply the same suitably in day-to-day applications.
  • Learn the different features of Pivot Tables like Grouping, Calculated Fields, etc.
  • Test your skills with multiple resources,quiz and a real world case studies

Who Should Attend

  • Students from any engineering background can enroll in this course.
  • Professionals looking for a change in their career or promotions can enroll for this course.
  • Secondly, any management students (BBA, MBA) can also enroll in this course.
  • Moreover, anyone from a quantitative background can also enroll in this course.

Target Audiences

  • Students from any engineering background can enroll in this course.
  • Professionals looking for a change in their career or promotions can enroll for this course.
  • Secondly, any management students (BBA, MBA) can also enroll in this course.
  • Moreover, anyone from a quantitative background can also enroll in this 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.

This course is designed for beginners, focusing on data cleaning and data visualization using Excel, one of the most powerful tools available. Titled “Data Visualization Using Excel,” the course takes participants from basic to advanced levels of Excel proficiency. By the end of this course, participants will have developed a comprehensive skill set in Excel.

Key competencies covered include reading and cleaning data, essential for accurate analysis. Participants will also learn to create multiple dashboards, a crucial skill for visualizing data insights effectively. The course emphasizes report creation, enabling participants to compile and present their data findings professionally.

In addition to these practical skills, the course ensures that participants become familiar with all the functions of Excel, equipping them with the knowledge to leverage Excel’s full potential in various data-related tasks. Whether you are looking to enhance your data handling capabilities or seeking to improve your data presentation skills, this course provides a thorough grounding in Excel’s functionalities, preparing you for diverse data visualization and reporting challenges.

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Chapter 2: Fundamental of Microsoft Excel

Lecture 1: Excel Interface and Executing Shortcuts

Lecture 2: Formatting

Lecture 3: Conditional Formatting

Lecture 4: Functions

Lecture 5: Cell Referncing

Chapter 3: Date and Time functions

Lecture 1: Date & Time functions

Chapter 4: Data Cleaning

Lecture 1: Data Cleaning and Text Function

Lecture 2: Logical Function

Lecture 3: Filter

Lecture 4: Advance Filter

Chapter 5: Data Validation

Lecture 1: Data Validation

Lecture 2: Security

Chapter 6: Pivot Table

Lecture 1: Pivot Table

Lecture 2: Calculated Field

Chapter 7: Slicer

Lecture 1: Slicer

Chapter 8: Lookup Functions

Lecture 1: Vlookup

Lecture 2: Hlookup

Chapter 9: Using Advance functions of Microsoft Excel

Lecture 1: Countifs

Lecture 2: Sumifs

Lecture 3: Match, Index & Offset

Lecture 4: Whatif Analysis

Lecture 5: Dynamic Charts

Chapter 10: Array Functions | CSE Functions

Lecture 1: Sumproduct

Lecture 2: Countifs

Lecture 3: Large

Chapter 11: Advance functions-2

Lecture 1: Advance Conditional Formatting

Lecture 2: Dependable Combobox

Chapter 12: Data Visualization

Lecture 1: Formatting Basics

Lecture 2: Pareto Analysis

Lecture 3: Interactive Charts-1

Lecture 4: Interactive Charts-2

Chapter 13: Creating Custom Charts

Lecture 1: Thermometer Chart

Lecture 2: Population Pyramid Chart

Lecture 3: Waterfall Chart

Chapter 14: Dashboard Creation & Report Making

Lecture 1: Analyzing Data

Lecture 2: Ground work

Lecture 3: Creating Chart

Lecture 4: Dashboard

Chapter 15: Case Study

Instructors

Rating Distribution

  • 1 stars: 0 votes
  • 2 stars: 0 votes
  • 3 stars: 4 votes
  • 4 stars: 10 votes
  • 5 stars: 2 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

Google Shopping Ads Digital Marketing Course