Last updated 7/2022Course Language EnglishCourse Caption Course Length 09:29:53 to be exact 34193 seconds!Number of Lectures 190
This course includes:
9.5 hours hours of on-demand video
21 article
Full lifetime access
Access on mobile and TV
Certificate of completion
3 additional resources
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
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 incompleteUnderstand 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 moreGet LIFETIME access to course material – Videos, Data Sets, Quizzes, Projects, exercises, and most important 1-on-1 expert supportCourse MethodologyThe Course has been designed in 4 stepsData Cleaning – Data Preparation – Data Analysis – Data VisualizationWhat you’ll learnLearn the techniques to communicate a clear and concise message in just 10 SecondBecome master in using advanced powerful tools such as pivot tables and pivot chartsMaster advanced data analysis hypothesis testing and forecasting methodsMaster the art of creating impactful dashboardsLearn how to create different chart and graph types in ExcelWho this course is for:Anyone looking to master MS Excel with a 360-degree approachAspirants aiming to exploit Data Analysis and Data Visualization techniques to successfully show their achievements to the management and have gain recognition and promotionStudents 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 & dashboardsStudents looking for an engaging, hands-on, and highly interactive approach to trainingAnyone looking to pursue a career in data analysis or business intelligenceAre there any course requirements or prerequisites?You will need a Laptop/PC with any version of Excel installed in itBasic understanding of Excel operations like opening, closing and saving a fileWho this course is for:Anyone looking to master MS Excel with a 360-degree approachThis course is helpful for increasing personal productivity, efficiency at work or even developing skills to obtain a better jobAspirants aiming to exploit Data Analysis and Data Visualization techniques to successfully show their achievements to the management and have gain recognition and promotionStudents 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 & dashboardsStudents looking for an engaging, hands-on, and highly interactive approach to trainingAnyone looking to pursue a career in data analysis or business intelligence
Course Content:
Sections are minimized for better readability, click the section title to view the course content
8 Lectures | 14:43
Introduction of the Course
02:32
Know Your Instructor
02:03
What You are going to Learn in this Course
01:31
Lifelong Learning
01:03
Time is Money
01:16
What is Data Analysis
02:25
What is Data Visualization
02:28
Why MS Excel for Data Analysis and Data Visualization
01:25
15 Lectures | 42:36
Data Set for MS Excel Fundamentals
00:05
Workbook and Worksheet
03:15
Navigation - Adjacent Cells
05:19
Navigation - within Table
01:56
Selecting Cells 1
01:22
Selecting Cells 2
00:44
Selecting Cells 3
02:13
Selecting Cells 4
01:22
Applying Filters
06:03
Formatting 1
04:41
Formatting 2
03:02
Paste Special Introduction
01:52
Paste Special General Features
04:30
Paste Special Operations
02:59
Paste Special Other Features
03:13
11 Lectures | 19:54
Data Set for Data Cleaning Functions
00:05
Remove Duplicates
02:01
Delete Blank
01:38
Fill a Range
02:51
Flash Fill
01:41
Line Break - 1
01:50
Line Break - 2
01:56
Creating Custom List
02:21
Convert Text into Number
02:44
Find and Replace
00:53
Clear Formatting
01:54
11 Lectures | 20:36
Data Set for Text Functions
00:05
How to convert string into Lower Case
01:30
How to convert string into Upper Case
01:40
How to convert string into Upper Case
02:16
How to Joining Two Text
02:46
How to Remove Extra Space between words
01:47
Let's Count the Characters in a String
02:53
Compare Function - 1
02:08
Compare Function - 2
00:46
Replace Function
02:23
Learn how Substitute Function works
02:22
4 Lectures | 08:51
Data Set for Text to Column Functions
00:06
Text to Column - 1
04:10
Text to Column - 2
01:52
Text to Column - 3
02:43
6 Lectures | 13:57
Data Set for Reference Functions
00:05
Let's Learn Relative Reference
02:03
Let's Learn Absolute Reference
04:25
Let's Learn Mixed Reference
02:41
3D Reference
01:56
Naming the Cell
02:47
6 Lectures | 13:51
Data Set for Data Validation
00:05
Validating List in the Worksheet
05:37
Validating Text in the Worksheet
02:03
Validating Whole Number in the Worksheet
01:42
Validating Date in the Worksheet
01:53
Validating Time in the Worksheet
02:31
3 Lectures | 08:05
Data Set for Group Sheets
00:05
Learn how to work on Multiple Sheet Together
05:24
Learn how to Sum data present in different sheet through One Formula
02:36
10 Lectures | 34:05
Data Set for Date and Time Functions
00:06
DatedIf Function
03:46
Date Value Function
02:56
Today Date and Live Time Function
05:31
Knowing The Week Day Function
03:00
How to calculate Net Working Days
04:01
Calculating the Age Function
05:41
Days untill Next Birthday
05:16
How to Know Last Day of the Month
01:33
Learn the Time Difference Function
02:15
4 Lectures | 06:14
Data Set for Round Formulas
00:05
Round Formula
02:18
Round Up Formula
01:30
Round Down Formula
02:21
7 Lectures | 19:18
Data Set for Subtotal Functions
00:05
Subtotal Worksheet Function
03:52
Subtotal Sum Function
03:35
Subtotal Average Function
03:10
Subtotal Max Function
02:29
Subtotal Min Function
02:17
Subtotal Count Function
03:50
10 Lectures | 31:37
Data Set for VLookup & HLookup
00:05
VLookup with Exact Match
04:12
VLookup with Approximate Match
02:49
VLookup with a Mixed Reference Formula
03:29
VLookup with IF Function
05:07
HLookup Function
04:03
Lookup Formula
02:38
Match Formula
03:49
Index Formula
01:48
Match Index Formula
03:37
8 Lectures | 28:01
Data Set for Pivot Tables
00:05
How to create First Pivot Table
09:16
Understanding Value Fields in the Pivot Table
04:25
Learn to Refresh the Pivot Tables
02:49
Changing Data Source in Pivot Tables
02:09
Grouping the Items
03:43
Using Timlines
02:27
Playing with Slicer
03:07
14 Lectures | 40:45
Data Set for SUM Formulas
00:05
Learning how to do Running Total
02:59
Doing Summation with Frequency 1
04:10
Doing Summation with Frequency 2
02:46
What is Sumif Formula
01:18
Sumif Formula with Number Criteria 1
04:29
Sumif Formula with Number Criteria 2
02:55
Sumif Formula with Text Criteria 1
04:33
Sumif Formula with Text Criteria 2
02:48
Sumif Formula with Date Criteria
04:44
Sumif Formula with OR Criteria
02:23
Sumif Formula with not equal to Criteria
03:01
What is Sumifs Formula
00:58
Sumifs or Sum with Multiple Criteria
03:36
12 Lectures | 40:02
Data Set for Count Formulas
00:05
Introduction to Count Formulas
01:41
Count Formula
03:01
Counta Formula
02:47
Count Blank Formula
01:58
Countif with Number Criteria 1
06:26
Countif with Number Criteria 2
05:06
Countif with Text Criteria 1
04:14
Countif with Text Criteria 2
03:52
Countif with OR Logic
04:24
Countif vs Countifs
00:59
Countifs
05:29
9 Lectures | 23:50
Data Set for Statistical Formulas
00:05
Generating Random Numbers 1
02:31
Generating Random Numbers 2
01:54
Generating Random Numbers 3
02:30
Rank the Team Member's Performance 1
05:26
Rank the Team Member's Performance 2
02:10
Convert Negative to Positive Numbers 1
02:22
Convert Negative to Positive Numbers 2
01:56
Calculating Weighted Average
04:56
10 Lectures | 39:35
Data Set for Logical Formulas
00:05
AND Logical Formula
03:56
IF Logical Formula
04:21
Logical Formula Combo 1 - IF AND
05:01
OR Logical Formula
03:27
XOR Logical Formula
03:18
Logical Formula Combo 2 - IF OR
03:13
Logical Formula Combo 3 - AND OR
03:44
Logical Formula NOT
02:03
Logical Formula IFS / Nested IF
10:27
8 Lectures | 30:38
Data Set For Conditional Formatting
00:07
Conditional Formatting with Highlighting the Cells
06:06
Conditional Formatting with Top Bottom Rule
04:27
Conditional Formatting with Colour Scales
03:44
Conditional Formatting with Data Bars
07:16
Conditional Formatting with Icon Sets
02:36
Conditional Formatting with ISTEXT Formula
02:52
Conditional Formatting Using Mixed Reference
03:30
4 Lectures | 19:26
Introduction to Charts & Graphs
04:14
Different Messages Conveyed by Charts & Graphs
05:00
Best Practices of Making Charts & Graphs
04:00
Elements of Charts
06:12
10 Lectures | 26:12
Data Set for Charts – Charts – Level 1
00:06
Line Charts
03:20
Pie Charts
02:50
Pie Charts II
04:09
Doughnut Charts
02:53
Bar Charts
02:05
Cluster Bar Charts
02:32
Column Charts
02:38
Column Stacked Charts
02:28
Column Stacked 100% Charts
03:11
6 Lectures | 27:24
Data Set for Charts – Charts – Level 2
00:06
Area Charts
04:54
Combo Charts
04:04
Histogram & Pareto Charts
07:46
Tree Maps
03:15
Heat Maps
07:19
10 Lectures | 32:58
Data Set for Pivot Charts
00:07
Pivot Line Charts
05:45
Pivot Pie Charts
04:05
Pivot Bar of Pie Charts
03:24
Pivot Pie of Pie Charts
02:30
Pivot Doughnut Charts
02:56
Pivot Bar Cluster Charts
04:12
Pivot Column Stacked Charts
03:26
Pivot Area Charts
03:15
Pivot Combo Charts
03:18
4 Lectures | 27:08
Data Set for Sales Dashboards 1
00:07
Sales Dashboards Part 1 - 1
01:11
Sales Dashboards Part 1 - 2
14:20
Sales Dashboards Part 1 - 3
11:30
4.43
(284 course ratings)
1
6/284
2
6/284
3
42/284
4
108/284
5
122/284
JOIN OUR WHATSAPP GROUP TO GET LATEST COUPON AS SOON AS UPDATED
If you like to get inspired by great web projects, you should check out Made with Javascript. If you have a project that you wish to share with the world, feel free to submit your project on Made with Javascript Club website.
Free Online Tools And Converters for your use
URL Encoder
Input a string of text or a URL and encode the entered string
FAQ: Udemy Free course Most frequent questions and answers
Does Udemy offer Free Udemy coupons?
Yes, Udemy is the largest online education platform, with the broadest selection of video-on-demand courses and qualified instructors available to meet your needs. At theprogrammingbuddy.club we curate the latest udemy coupons, their expiry, and the number of uses left of these udemy coupons.
How to get free Udemy courses?
There are two ways to get free Udemy courses:
Go to udemy.com and search for your desired course category. Then select free from the filter options.
You can also get paid courses for free if you have a coupon. You can head to theprogrammingbuddy.club, where you can get a daily udemy paid course for free.
How to get Udemy Certificates for free?
Udemy offers certification on completion of each course. In order to receive a certificate of completion from Udemy, you need to complete your course 100%. There is a simple hack, you can open a video and jump on the timeline to complete a lecture.
To download the certificate from Udemy, you need to head over to your account on a desktop browser. Udemy certificates can't be accessed on the mobile app.
Do Udemy courses expire?
No, once you enroll, you will have lifetime access to the course. You can complete the course on your schedule.
Why are the Udemy instructors giving away free Udemy Coupons?
Every instructor has worked for hours on each of their courses. As new courses get launched, the instructors have no way to get their course in front of an audience to get some feedback. So, instructors share free coupons for their courses to get feedback from the students. We attheprogrammingbuddy.club work with these instructors to get their courses available to our buddies.
Is Udemy safe to use?
Yes, payments on Udemy are safe. It is no different than paying for other services on an application or website and inputting your payment information before receiving your goods. Just be sure to keep your account secure, do not share your udemy accounts.
Can Udemy courses get you a job?
Earning a skill is more valuable than earning a job these days. Skills are your most valuable asset. They can help you qualify for jobs you want and get promoted to more advanced positions within your organization. Unfortunately, it is difficult for many people to balance taking courses with work and family obligations. We have had many students, who have taken just Udemy courses, started a job as well as started freelancing with the skills they have learned.