Microsoft Excel Master Class-2020
4.4 (10 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
56 students enrolled

Microsoft Excel Master Class-2020

Microsoft Excel Training: Power Excel Formulas, Advance Excel Analytics, Case Studies, BI Dashboards, Charts & Macros
4.4 (10 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
56 students enrolled
Last updated 2/2020
English
English [Auto]
Current price: $139.99 Original price: $199.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 4 hours on-demand video
  • 4 articles
  • 46 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • A Solid understanding of Excel
  • Basics of Excel from Scratch.
  • All Important 33+ Formulas in Excel which are very useful in day to day life.
  • Making your data look good & re presentable by using Formatting & Advance Formatting.
  • Explore all the things that can be done using Excel .e.g: Speaking Cells in Excel [ 21 Things that you can do in Excel are included in this section ]
  • Visualization of the data using Excel Charts and deriving Important Insights from them.
  • Harness the power of Pivot Charts by introducing Slicers and deriving Insights from them.
  • Advance Excel : Linear Regression, Goal Seeker & Solver by working on Real Life Consulting Projects.
  • Introduction to BUSINESS INTELLIGENCE DASHBOARDS & building them from Scratch.
  • Solve 2 Real life Case Studies one building DASH BOARD from scratch for a school and putting hands on a Real Life consulting project for a Fertilizer Company and recommending them with Insights.m
  • Macros: Learn to Automate things by recording a Macro and assigning a button to it.
  • 30+ Excel shortcuts useful in daily Life.
Requirements
  • You will need a PC with any version of Excel installed in it.
Description

Welcome to the course,

Start your excel Journey by Harnessing the Full Potential of EXCEL today!!

The World is moving at an unprecedented speed in the field of Data Analytics & Excel being one of the major tools. It becomes very important to learn it and make the best use of it.

Learning Excel and Advance Excel is like a powerful weapon in your Arsenal.

Either you are a starter in Excel or you have been using it or you are not confident enough to take your Excel Skills to the next level.

You are at the Right Place!!!

It doesn’t matter whether you are a STUDENT, GRADUATE, POST GRADUATE, BUSINESS MANAGER or YOU ARE JUST WAITING TO ENTER YOUR JOB BUT NOT CLEAR WHAT TO LEARN BEFORE YOU JOIN.

This course is just for you!! We at LOGISTICS & Supply Chain World completely understand the problem you face when you are a Student, Graduate, Post Graduate or Business Manager when it comes to Excel.

This course is designed keeping all the Problem in mind faced by Students, Graduate, Post Graduate or Business Manager. This course is one stop Solution for all your Problems in EXCEL.

This course has everything with regards to Excel A-Z tm

What makes us Eligible to teach this course?

We at LOGISTICS & Supply Chain World have experience working in the field of DATA ANALYTICS, LOGISTICS & SUPPLY CHAIN in MNC Companies. We have been using Excel for years together. This Experience makes us eligible to teach this course.


What all is covered in this course?

1. Course Introduction

2. Excel Basics

3. Excel Formulas ( Mathematical Formulas )

4. Excel Formulas ( Lookup Formulas )

5. Excel Formulas ( Logical Formulas )

6. Excel Formulas ( Text Formulas )

7. Excel Formulas ( Date Formulas )

8. Formatting

9. Other Things in Microsoft Excel

10. Excel Charts

11. Pivot Chart

12. Advance Excel

13. Case Studies

14. Macros Basics

15. Excel Short Cuts

Please enroll in this course and take the maximum benefits of this course !!

Best Regards,

LOGISTICS & Supply Chain World.

Who this course is for:
  • Working Professionals [DATA ANALYST, RESEARCH SPECIALIST & BUSINESS MANAGERS] beginning their Data journey, High school students ,Professors , Graduates & Post Graduates and people from all phase of life who have the curiosity of learning EXCEL
Course content
Expand all 68 lectures 04:13:24
+ Course Introduction.
4 lectures 04:54

Please Download all the Excel sheets used in the course.

Course Handouts
00:02
Reviews on this Course.
00:09
+ Excel Formulas ( Mathematical Formulas ).
10 lectures 18:03
MIN Formula
01:22
Max Formula
01:26
Average Formula
01:27
Sum Formula
02:59
Large Formula
02:10
Rand Between Formula
01:11
Round Formula
01:05
Sub Total Formula
03:16
Sum Product Formula
01:33
Rank Formula
01:34
+ Excel Formulas ( Lookup Formulas ).
5 lectures 14:14
Vlook Up Formula
03:39
Hlook Up Formula
03:17
Match Formula
01:13
Index Formula
02:40
Combination of Both Index & Match
03:25
+ Excel Formulas ( Logical Formulas ).
5 lectures 16:23
OR Formula
01:50
AND Formula
01:34
IF Formula
01:28
Sum IF Formula & Sum IFS
07:41
Count IF & Count IFS
03:50
+ Formatting.
4 lectures 27:00
Formatting Basics
08:04
Conditional Formatting Part-1
10:22
Conditional Formatting Part-2
03:26
Advanced Conditional Formatting
05:08
+ Other Things That you can do in EXCEL.
21 lectures 01:05:44
Excel Data Editing: Find & Replace
01:45
Excel Cell that speaks: Tell excel to speak what you have-Advance Part In Excel.
03:10
Text to Columns: Separating Words or Sentences connected with a delimiter.
02:51
Inserting Comments: Inserting Comments , Seeing all comments in the excel sheet
03:51
Paste Special: Different Operations using Paste Special.
02:10
What is Fill & Advance filling & Flash Fill
07:49
Freezing Sheets & Other things
03:06
Customizing your Views in Excel
02:49
Addition of Rows & Columns in Excel
01:53
Playing with Worksheets
03:27
Worksheets Side By Side
01:28
Formula Evaluation and Excel Auditing Tools
04:58
Protecting Work Book & Sheet
03:09
Adding a hyperlink
04:06
Tables & Advance Tables in Excel
03:19
Data filters & Sorting.
04:41
Data validation
03:08
GOTO & GOTO Special
02:57
Removing Duplicates
01:37
How to Create a Drop Down
01:19
Named Ranges
02:11
+ Excel Charts.
3 lectures 12:45
Column Chart & Bar Charts
05:52
Formatting the Column Chart.
04:18
Pie Chart
02:35