Executive Program in Advanced MS Excel
Advanced Microsoft Excel 2016+ Course covering Data Cleaning – Data Preparation – Data Analysis – Data Visualization
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 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
Fundamentals of Microsoft Excel
Data Cleaning – Data Cleaning Functions
-
9
Data Set for MS Excel Fundamentals -
10
Workbook and Worksheet -
11
Navigation - Adjacent Cells
-
12
Navigation - within Table
-
13
Selecting Cells 1
-
14
Selecting Cells 2
-
15
Selecting Cells 3
-
16
Selecting Cells 4
-
17
Applying Filters
-
18
Formatting 1
-
19
Formatting 2
-
20
Paste Special Introduction
-
21
Paste Special General Features
-
22
Paste Special Operations
-
23
Paste Special Other Features
Data Preparation – Text Functions
Data Preparation – Text to Column Functions
-
35
Data Set for Text Functions
-
36
How to convert string into Lower Case
-
37
How to convert string into Upper Case
-
38
How to convert string into Upper Case
-
39
How to Joining Two Text
-
40
How to Remove Extra Space between words
-
41
Let's Count the Characters in a String
-
42
Compare Function - 1
-
43
Compare Function - 2
-
44
Replace Function
-
45
Learn how Substitute Function works
Data Preparation – Reference Functions
Data Preparation – Data Validation
Data Preparation – Group Sheets
Data Preparation – Date and Time Functions
Data Analysis – Round Formulas
-
65
Data Set for Date and Time Functions
-
66
DatedIf Function
-
67
Date Value Function
-
68
Today Date and Live Time Function
-
69
Knowing The Week Day Function
-
70
How to calculate Net Working Days
-
71
Calculating the Age Function
-
72
Days untill Next Birthday
-
73
How to Know Last Day of the Month
-
74
Learn the Time Difference Function
Data Analysis – Subtotals
You can view and review the lecture materials indefinitely, like an on-demand channel.
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!
30-Day Money-Back Guarantee
Includes
9 hours on-demand video
21 articles
Full lifetime access
Access on mobile and TV
Certificate of Completion