Home

All courses

Mastering Data Visualization & Analytics with MS Excel

Business

Excel Formulas and Functions

Business Analytics & Intelligence

Mastering Data Visualization & Analytics with MS Excel

From Data Cleaning to Insightful Analysis

4.3

(370)

31538 enrolled on this course

Last updated 11/2021

None

₹ 2299.0

₹ 3799.0

Buy Now

30-Day Money-Back Guarantee

Lessons

Quizzes

Duration

13 Hours

Skill level

Beginner

Language

English

Certificate

Yes

Full lifetime access

Yes

Description

Unlock the full potential of your data with our comprehensive course, "Mastering Data Visualization & Analytics with Advanced Microsoft Excel 2016+." This course is meticulously designed to equip you with the skills needed to transform raw data into powerful insights using the advanced capabilities of Microsoft Excel and beyond.
Why This Course?
In today's data-driven world, the ability to clean, prepare, analyze, and visualize data is indispensable. Whether you're a professional aiming to enhance your data handling skills or a student preparing for a data-centric career, this course is your gateway to mastering Excel's advanced features.
Course Highlights:
Data Cleaning:
Learn to handle messy data with ease. Master techniques for removing duplicates, correcting errors, and standardizing data to ensure accuracy and reliability.
Data Preparation:
Discover best practices for preparing your data for analysis. Understand how to structure and format your datasets for optimal performance.
Data Analysis:
Dive deep into Excel’s powerful analytical tools. Explore functions, pivot tables, and advanced formulas to extract meaningful insights from your data.
Data Visualization:
Transform your analyses into compelling visuals. Create dynamic charts, graphs, and dashboards that effectively communicate your findings.
What’s New?
Advanced Excel Features:
Get hands-on experience with the latest Excel features, including Power Query, Power Pivot, and DAX.
Real-World Case Studies:
Apply your skills to real-world scenarios with case studies from various industries.
Interactive Learning:
Engage with interactive exercises and quizzes designed to reinforce your understanding and challenge your proficiency.
Why Enroll Now?
Stay Ahead in Your Career:
In a rapidly evolving job market, advanced Excel skills can set you apart from the competition.
Comprehensive Learning Path:
This course covers everything from basic data cleaning to advanced visualization techniques, ensuring a well-rounded learning experience.
Expert Instruction:
Learn from industry experts with years of experience in data analytics and Excel training.
Who Should Enroll?
Professionals:
Enhance your analytical skills to make data-driven decisions and advance in your career.
Students:
Build a solid foundation in data analytics and visualization, preparing you for a variety of roles in today’s job market.
Data Enthusiasts:
Whether you're a beginner or have some experience, this course will take your Excel skills to the next level.
Take Action Now!
Don't miss out on this opportunity to become a data visualization and analytics expert. Enroll today and start your journey towards mastering the art of data analysis with Microsoft Excel!
Enroll Now
and transform your data into actionable insights!
Who this course is for:
Professionals: Enhance your analytical skills to make data-driven decisions and advance in your career.
Students: Build a solid foundation in data analytics and visualization, preparing you for a variety of roles in today’s job market.
Data Enthusiasts: Whether you're a beginner or have some experience, this course will take your Excel skills to the next level.

What you'll learn

Build a solid understanding of Microsoft Excel

Master data cleaning, preparation, analysis, and visualization

Become proficient with advanced tools like pivot tables and charts

Expertly use advanced functions and formulas in Excel

Communicate insights clearly with effective data visualization

Create impactful and interactive dashboards

Design various chart and graph types in Excel

Transform raw data into actionable insights efficiently

Requirements

You will need a copy of Adobe XD 2019 or above. A free trial can be downloaded from Adobe.
No previous design experience is needed.
No previous Adobe XD skills are needed.

Course Content

27 sections • 95 lectures

Expand All Sections

1-Introduction of the Course

1.1-Introduction of the Course

1.2-What You are going to Learn in this Course

1.3-Lifelong Learning

1.4-What is Data Analysis

1.5-What is Data Visualization

1.6-Why MS Excel for Data Analysis and Data Visualization

2-Fundamentals of Microsoft Excel

2.1-Data Set for MS Excel Fundamentals

2.2-Workbook and Worksheet

2.3-Navigation - Adjacent Cells

2.4-Navigation - within Table

2.5-Selecting Cells 1

2.6-Selecting Cells 2

2.7-Selecting Cells 3

2.8-Selecting Cells 4

2.9-Applying Filters

2.10-Formatting 1

2.11-Formatting 2

2.12-Paste Special Introduction

2.13-Paste Special General Features

2.14-Paste Special Operations

2.15-Paste Special Other Features

3-Data Cleaning – Data Cleaning Functions

3.1-Data Set for Data Cleaning Functions

3.2-Remove Duplicates

3.3-Delete Blank

3.4-Fill a Range

3.5-Flash Fill

3.6-Line Break - 1

3.7-Line Break - 2

3.8-Creating Custom List

3.9-Convert Text into Number

3.10-Find and Replace

3.11-Clear Formatting

4-Data Preparation – Text Functions

4.1-Data Set for Text Functions

4.2-How to convert string into Lower Case

4.3-How to convert string into Upper Case

4.4-How to convert string into Upper Case

4.5-How to Joining Two Text

4.6-How to Remove Extra Space between words

4.7-Let's Count the Characters in a String

4.8-Compare Function - 1

4.9-Compare Function - 2

4.10-Replace Function

4.11-Learn how Substitute Function works

5-Data Preparation – Text to Column Functions

5.1-Data Set for Text to Column Functions

5.2-Text to Column - 1

5.3-Text to Column - 2

5.4-Text to Column - 3

6-Data Preparation – Reference Functions

6.1-Data Set for Reference Functions

6.2-Let's Learn Relative Reference

6.3-Let's Learn Absolute Reference

6.4-Let's Learn Mixed Reference

6.5-3D Reference

6.6-Naming the Cell

7-Data Preparation – Data Validation

7.1-Data Set for Data Validation

7.2-Validating List in the Worksheet

7.3-Validating Text in the Worksheet

7.4-Validating Whole Number in the Worksheet

7.5-Validating Date in the Worksheet

7.6-Validating Time in the Worksheet

8-Data Preparation – Group Sheets

8.1-Data Set for Group Sheets

8.2-Learn how to work on Multiple Sheet Together

8.3-Learn how to Sum data present in different sheet through One Formula

9-Data Preparation – Date and Time Functions

9.1-Data Set for Date and Time Functions

9.2-DatedIf Function

9.3-Date Value Function

9.4-Today Date and Live Time Function

9.5-Knowing The Week Day Function

9.6-How to calculate Net Working Days

9.7-Calculating the Age Function

9.8-Days untill Next Birthday

9.9-How to Know Last Day of the Month

9.10-Learn the Time Difference Function

10-Data Analysis – Round Formulas

10.1-Data Set for Round Formulas

10.2-Round Formula

10.3-Round Up Formula

10.4-Round Down Formula

11-Data Analysis – Subtotals

11.1-Data Set for Subtotal Functions

11.2-Subtotal Worksheet Function

11.3-Subtotal Sum Function

11.4-Subtotal Average Function

11.5-Subtotal Max Function

11.6-Subtotal Min Function

11.7-Subtotal Count Function

12-Data Analysis – VLookup & HLookup

12.1-Data Set for VLookup & HLookup

12.2-VLookup with Exact Match

12.3-VLookup with Approximate Match

12.4-VLookup with a Mixed Reference Formula

12.5-VLookup with IF Function

12.6-HLookup Function

12.7-Lookup Formula

12.8-Match Formula

12.9-Index Formula

12.10-Match Index Formula

13-Data Analysis – Pivot Tables

13.1-Data Set for Pivot Tables

13.2-How to create First Pivot Table

13.3-Understanding Value Fields in the Pivot Table

13.4-Changing Data Source in Pivot Tables

13.5-Grouping the Items

13.6-Using Timlines

13.7-Playing with Slicer

14-Data Analysis – Sum Formulas

14.1-Data Set for SUM Formulas

14.2-Learning how to do Running Total

14.3-Learn to Refresh the Pivot Tables

14.4-Doing Summation with Frequency 1

14.5-Doing Summation with Frequency 2

14.6-What is Sumif Formula

14.7-Sumif Formula with Number Criteria 1

14.8-Sumif Formula with Number Criteria 2

14.9-Sumif Formula with Text Criteria 1

14.10-Sumif Formula with Text Criteria 2

14.11-Sumif Formula with Date Criteria

14.12-Sumif Formula with OR Criteria

14.13-Sumif Formula with not equal to Criteria

14.14-What is Sumifs Formula

14.15-Sumifs or Sum with Multiple Criteria

15-Data Analysis – Count Formula

15.1-Data Set for Count Formulas

15.2-Introduction to Count Formulas

15.3-Count Formula

15.4-Counta Formula

15.5-Count Blank Formula

15.6-Countif with Number Criteria 1

15.7-Countif with Number Criteria 2

15.8-Countif with Text Criteria 1

15.9-Countif with Text Criteria 2

15.10-Countif with OR Logic

15.11-Countif vs Countifs

15.12-Countifs

16-Data Analysis – Statistical Formulas

16.1-Data Set for Statistical Formulas

16.2-Generating Random Numbers 1

16.3-Generating Random Numbers 2

16.4-Generating Random Numbers 3

16.5-Rank the Team Member's Performance 1

16.6-Rank the Team Member's Performance 2

16.7-Convert Negative to Positive Numbers 1

16.8-Convert Negative to Positive Numbers 2

16.9-Calculating Weighted Average

17-Data Analysis – Logical Formulas

17.1-Data Set for Logical Formulas

17.2-AND Logical Formula

17.3-IF Logical Formula

17.4-Logical Formula Combo 1 - IF AND

17.5-OR Logical Formula

17.6-XOR Logical Formula

17.7-Logical Formula Combo 2 - IF OR

17.8-Logical Formula Combo 3 - AND OR

17.9-Logical Formula NOT

17.10-Logical Formula IFS / Nested IF

18-Data Visualization – Conditional Formatting

18.1-Data Set For Conditional Formatting

18.2-Conditional Formatting with Highlighting the Cells

18.3-Conditional Formatting with Top Bottom Rule

18.4-Conditional Formatting with Colour Scales

18.5-Conditional Formatting with Data Bars

18.6-Conditional Formatting with Icon Sets

18.7-Conditional Formatting with ISTEXT Formula

18.8-Conditional Formatting Using Mixed Reference

19-Data Visualization - Essentials of Charts & Graphs

19.1-Introduction to Charts & Graphs

19.2-Different Messages Conveyed by Charts & Graphs

19.3-Best Practices of Making Charts & Graphs

19.4-Elements of Charts

20-Data Visualization – Charts – Level 1

20.1-Data Set for Charts – Charts – Level 1

20.2-Line Charts

20.3-Pie Charts

20.4-Pie Charts II

20.5-Doughnut Charts

20.6-Bar Charts

20.7-Cluster Bar Charts

20.8-Column Charts

20.9-Column Stacked Charts

20.10-Column Stacked 100% Charts

21-Data Visualization – Charts – Level 2

21.1-Data Set for Charts – Charts – Level 2

21.2-Area Charts

21.3-Combo Charts

21.4-Histogram & Pareto Charts

21.5-Tree Maps

21.6-Heat Maps

22-Data Visualization – Pivot Charts

22.1-Data Set for Pivot Charts

22.2-Pivot Line Charts

22.3-Pivot Pie Charts

22.4-Pivot Bar of Pie Charts

22.5-Pivot Pie of Pie Charts

22.6-Pivot Doughnut Charts

22.7-Pivot Bar Cluster Charts

22.8-Pivot Column Stacked Charts

22.9-Pivot Area Charts

22.10-Pivot Combo Charts

23-Data Visualization – Dashboards

23.1-Data Set for Sales Dashboards 1

23.2-Sales Dashboards Part 1 - 1

23.3-Sales Dashboards Part 1 - 2

23.4-Sales Dashboards Part 1 - 3

Course Categories

Popular Courses

Mastering Data Visualization & Analytics with MS Excel

Description

What you'll learn

Requirements

Course Content

You May Like