The Complete Course on Data Analysis and Data Visualization

The Complete Course on Data Analysis and Data Visualization

The Complete Course on Data Analysis and Data Visualization

Advanced Microsoft Excel 2016+ Course covering Data Cleaning – Data Preparation – Data Analysis – Data Visualization

Language: english

Note: 4.4/5 (249 notes) 27,947 students

Instructor(s): Nitin Kr Saxena PhD

Last update: 2021-06-02

What you’ll learn

  • Build a solid understanding of the Microsoft Excel
  • Data Cleaning, Data Preparation, Data Analysis and Data Visualization
  • Become master in using advanced powerful tools such as pivot tables and pivot charts
  • Proficient in using various advanced level Functions and Formulas in MS Excel
  • Learn the techniques to communicate a clear and concise message in just 10 Second through right Data Visualization Technique
  • Master the art of creating impactful dashboards
  • Learn how to create different chart and graph types in Excel

 

Requirements

  • You will need a Laptop/PC with any version of Excel installed in it
  • Basic understanding of Excel operations like opening, closing and saving a file

 

Description

Success matters on 70% what we do and 30% how to market our work, this makes it 100%. Mastering Data Analysis and Data Visualization Using MS Excel is a power-packed course that will teach you that 30% without which your 100% for success is incomplete

Understand WHEN, WHY, and HOW to use 120+ Formulas / Functions and chart types in Excel 2016+

Learn advanced Excel techniques tools like PivotTables, Lookups, Logical Formulas, automated dashboards, and more

Get LIFETIME access to course material – Videos, Data Sets, Quizzes, Projects, exercises, and most important 1-on-1 expert support

Course Methodology

The Course has been designed in 4 steps

Data Cleaning – Data Preparation – Data Analysis – Data Visualization


What you’ll learn

  • Learn the techniques to communicate a clear and concise message in just 10 Second

  • Become master in using advanced powerful tools such as pivot tables and pivot charts

  • Master advanced data analysis hypothesis testing and forecasting methods

  • Master the art of creating impactful dashboards

  • Learn how to create different chart and graph types in Excel

Who this course is for:

  • Anyone looking to master MS Excel with a 360-degree approach

  • Aspirants aiming to exploit Data Analysis and Data Visualization techniques to successfully show their achievements to the management and have gain recognition and promotion

  • Students who are undergoing Summer Internship Projects and have to make their reports stand out.

  • Excel users who have basic skills but want to master advanced charts, graphs & dashboards

  • Students looking for an engaging, hands-on, and highly interactive approach to training

  • Anyone looking to pursue a career in data analysis or business intelligence

Are there any course requirements or prerequisites?

  • You will need a Laptop/PC with any version of Excel installed in it

  • Basic understanding of Excel operations like opening, closing and saving a file

 

Who this course is for

  • Anyone looking to master MS Excel with a 360-degree approach
  • This course is helpful for increasing personal productivity, efficiency at work or even developing skills to obtain a better job
  • Aspirants aiming to exploit Data Analysis and Data Visualization techniques to successfully show their achievements to the management and have gain recognition and promotion
  • Students who are undergoing Summer Internship Projects and have to make their reports stand out.
  • Excel users who have basic skills but want to master advanced charts, graphs & dashboards
  • Students looking for an engaging, hands-on, and highly interactive approach to training
  • Anyone looking to pursue a career in data analysis or business intelligence

 

Course content

  • Introduction of the Course
    • Introduction of the Course
    • Know Your Instructor
    • What You are going to Learn in this Course
    • Lifelong Learning
    • Time is Money
    • What is Data Analysis
    • What is Data Visualization
    • Why MS Excel for Data Analysis and Data Visualization
  • Fundamentals of Microsoft Excel
    • Data Set for MS Excel Fundamentals
    • Workbook and Worksheet
    • Navigation – Adjacent Cells
    • Navigation – within Table
    • Selecting Cells 1
    • Selecting Cells 2
    • Selecting Cells 3
    • Selecting Cells 4
    • Applying Filters
    • Formatting 1
    • Formatting 2
    • Paste Special Introduction
    • Paste Special General Features
    • Paste Special Operations
    • Paste Special Other Features
  • Data Cleaning – Data Cleaning Functions
    • Data Set for Data Cleaning Functions
    • Remove Duplicates
    • Delete Blank
    • Fill a Range
    • Flash Fill
    • Line Break – 1
    • Line Break – 2
    • Creating Custom List
    • Convert Text into Number
    • Find and Replace
    • Clear Formatting
  • Data Preparation – Text Functions
    • Data Set for Text Functions
    • How to convert string into Lower Case
    • How to convert string into Upper Case
    • How to convert string into Upper Case
    • How to Joining Two Text
    • How to Remove Extra Space between words
    • Let’s Count the Characters in a String
    • Compare Function – 1
    • Compare Function – 2
    • Replace Function
    • Learn how Substitute Function works
  • Data Preparation – Text to Column Functions
    • Data Set for Text to Column Functions
    • Text to Column – 1
    • Text to Column – 2
    • Text to Column – 3
  • Data Preparation – Reference Functions
    • Data Set for Reference Functions
    • Let’s Learn Relative Reference
    • Let’s Learn Absolute Reference
    • Let’s Learn Mixed Reference
    • 3D Reference
    • Naming the Cell
  • Data Preparation – Data Validation
    • Data Set for Data Validation
    • Validating List in the Worksheet
    • Validating Text in the Worksheet
    • Validating Whole Number in the Worksheet
    • Validating Date in the Worksheet
    • Validating Time in the Worksheet
  • Data Preparation – Group Sheets
    • Data Set for Group Sheets
    • Learn how to work on Multiple Sheet Together
    • Learn how to Sum data present in different sheet through One Formula
  • Data Preparation – Date and Time Functions
    • Data Set for Date and Time Functions
    • DatedIf Function
    • Date Value Function
    • Today Date and Live Time Function
    • Knowing The Week Day Function
    • How to calculate Net Working Days
    • Calculating the Age Function
    • Days untill Next Birthday
    • How to Know Last Day of the Month
    • Learn the Time Difference Function
  • Data Analysis – Round Formulas
    • Data Set for Round Formulas
    • Round Formula
    • Round Up Formula
    • Round Down Formula
  • Data Analysis – Subtotals
    • Data Set for Subtotal Functions
    • Subtotal Worksheet Function
    • Subtotal Sum Function
    • Subtotal Average Function
    • Subtotal Max Function
    • Subtotal Min Function
    • Subtotal Count Function
  • Data Analysis – VLookup & HLookup
    • Data Set for VLookup & HLookup
    • VLookup with Exact Match
    • VLookup with Approximate Match
    • VLookup with a Mixed Reference Formula
    • VLookup with IF Function
    • HLookup Function
    • Lookup Formula
    • Match Formula
    • Index Formula
    • Match Index Formula
  • Data Analysis – Pivot Tables
    • Data Set for Pivot Tables
    • How to create First Pivot Table
    • Understanding Value Fields in the Pivot Table
    • Learn to Refresh the Pivot Tables
    • Changing Data Source in Pivot Tables
    • Grouping the Items
    • Using Timlines
    • Playing with Slicer
  • Data Analysis – Sum Formulas
    • Data Set for SUM Formulas
    • Learning how to do Running Total
    • Doing Summation with Frequency 1
    • Doing Summation with Frequency 2
    • What is Sumif Formula
    • Sumif Formula with Number Criteria 1
    • Sumif Formula with Number Criteria 2
    • Sumif Formula with Text Criteria 1
    • Sumif Formula with Text Criteria 2
    • Sumif Formula with Date Criteria
    • Sumif Formula with OR Criteria
    • Sumif Formula with not equal to Criteria
    • What is Sumifs Formula
    • Sumifs or Sum with Multiple Criteria
  • Data Analysis – Count Formula
    • Data Set for Count Formulas
    • Introduction to Count Formulas
    • Count Formula
    • Counta Formula
    • Count Blank Formula
    • Countif with Number Criteria 1
    • Countif with Number Criteria 2
    • Countif with Text Criteria 1
    • Countif with Text Criteria 2
    • Countif with OR Logic
    • Countif vs Countifs
    • Countifs
  • Data Analysis – Statistical Formulas
    • Data Set for Statistical Formulas
    • Generating Random Numbers 1
    • Generating Random Numbers 2
    • Generating Random Numbers 3
    • Rank the Team Member’s Performance 1
    • Rank the Team Member’s Performance 2
    • Convert Negative to Positive Numbers 1
    • Convert Negative to Positive Numbers 2
    • Calculating Weighted Average
  • Data Analysis – Logical Formulas
    • Data Set for Logical Formulas
    • AND Logical Formula
    • IF Logical Formula
    • Logical Formula Combo 1 – IF AND
    • OR Logical Formula
    • XOR Logical Formula
    • Logical Formula Combo 2 – IF OR
    • Logical Formula Combo 3 – AND OR
    • Logical Formula NOT
    • Logical Formula IFS / Nested IF
  • Data Visualization – Conditional Formatting
    • Data Set For Conditional Formatting
    • Conditional Formatting with Highlighting the Cells
    • Conditional Formatting with Top Bottom Rule
    • Conditional Formatting with Colour Scales
    • Conditional Formatting with Data Bars
    • Conditional Formatting with Icon Sets
    • Conditional Formatting with ISTEXT Formula
    • Conditional Formatting Using Mixed Reference
  • Data Visualization – Essentials of Charts & Graphs
    • Introduction to Charts & Graphs
    • Different Messages Conveyed by Charts & Graphs
    • Best Practices of Making Charts & Graphs
    • Elements of Charts
  • Data Visualization – Charts – Level 1
    • Data Set for Charts – Charts – Level 1
    • Line Charts
    • Pie Charts
    • Pie Charts II
    • Doughnut Charts
    • Bar Charts
    • Cluster Bar Charts
    • Column Charts
    • Column Stacked Charts
    • Column Stacked 100% Charts
  • Data Visualization – Charts – Level 2
    • Data Set for Charts – Charts – Level 2
    • Area Charts
    • Combo Charts
    • Histogram & Pareto Charts
    • Tree Maps
    • Heat Maps
  • Data Visualization – Pivot Charts
    • Data Set for Pivot Charts
    • Pivot Line Charts
    • Pivot Pie Charts
    • Pivot Bar of Pie Charts
    • Pivot Pie of Pie Charts
    • Pivot Doughnut Charts
    • Pivot Bar Cluster Charts
    • Pivot Column Stacked Charts
    • Pivot Area Charts
    • Pivot Combo Charts
  • Data Visualization – Dashboards
    • Data Set for Sales Dashboards 1
    • Sales Dashboards Part 1 – 1
    • Sales Dashboards Part 1 – 2
    • Sales Dashboards Part 1 – 3

 

The Complete Course on Data Analysis and Data VisualizationThe Complete Course on Data Analysis and Data Visualization

Time remaining or 999 enrolls left

 

Don’t miss any coupons by joining our Telegram group 

Udemy Coupon Code 100% off | Udemy Free Course | Udemy offer | Course with certificate