Microsoft Excel Master Class - 2020
Created by Logistics And Supply Chain World., Last Updated 02-Sep-2020, Language:English
Microsoft Excel Master Class - 2020
Excel Formulas & Functions, Advance Excel Analytics, Case Studies, BI Dashboards, Charts, Macros & Practice Exercises & Much More.
Created by Logistics And Supply Chain World., Last Updated 02-Sep-2020, Language:English
What Will I Get ?
- Get a Solid understanding of Excel
- Learn the Basics of Excel from Scratch.
- Learn 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.
- Macros: Learn to Automate things by recording a Macro and assigning a button to it.
- Learn 30+ Excel shortcuts useful in daily Life.
Requirements
- You will need a PC with any version of Excel installed in it.
- A Good Internet Connection.
- When it comes to Excel Knowledge , there is nothing that is expected ! We will start from scratch. A person with no knowledge of excel can also attend the course and learn.
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 !!
Course Content
-
Course Introduction.
4 Lectures 00:08:24-
Course Introduction.
Preview00:03:42 -
Course Flow.
Preview00:04:04 -
Course Expectation.
Preview00:00:38 -
Course Handouts.
-
-
The Basics of Excel.
5 Lectures 00:10:09-
Microsoft Excel Introduction.
Preview00:01:01 -
Microsoft Excel Basics
Preview00:02:28 -
Characteristics of a Cell
00:00:58 -
Cell Reference
Preview00:04:38 -
Creating a File Template & Closing it
Preview00:01:04
-
-
Excel Formulas [Mathematical Formula]
10 Lectures 00:18:02-
MIN Formula
00:01:22 -
MAX Formula
00:01:26 -
Average Formula
00:01:27 -
Sum Formula
00:02:59 -
Large Formula
00:02:09 -
Rand Between Formula
00:01:11 -
Round Formula
00:01:05 -
Sub Total Formula
00:03:16 -
Sum Product Formula
00:01:33 -
Rank Formula
00:01:34
-
-
Excel Formulas [ Look Up Formula ]
5 Lectures 00:14:14-
V-Lookup Formula
00:03:39 -
H-lookup Formula
00:03:17 -
Match Formula
00:01:13 -
Index Formula
00:02:40 -
Combination of Index Formula & Match Formula
00:03:25
-
-
Excel Formulas [ Logical Formula ]
5 Lectures 00:16:23-
OR Formula
00:01:50 -
AND Formula
00:01:34 -
IF Formula
00:01:28 -
Sum IF & Sum IFS
00:07:41 -
Count IF & Count IFS
00:03:50
-
-
Excel Formulas [ Date & Time Formulas ]
1 Lectures 00:02:19-
Date & Time Formulas
00:02:19
-
-
Excel Formulas [ Text Formulas ]
1 Lectures 00:03:22-
Text Formula
00:03:22
-
-
Complete Formatting in Excel
4 Lectures 00:27:00-
Formatting Basics
00:08:04 -
Conditional Formatting Part-1
00:10:22 -
Conditional Formatting Part-2
00:03:26 -
Advanced Conditional Formatting
00:05:08
-
-
All other things that you can do in EXCEL.
21 Lectures 01:05:44-
Excel Data Editing: Find & Replace
00:01:45 -
Excel Cell that speaks: Tell excel to speak what you have-Advance Part In Excel.
00:03:10 -
Text to Columns: Separating Words or Sentences connected with a delimiter.
00:02:51 -
Inserting Comments: Inserting Comments , Seeing all comments in the excel sheet
00:03:51 -
Paste Special: Different Operations using Paste Special.
00:02:10 -
What is Fill & Advance filling & Flash Fill
00:07:49 -
Freezing Sheets & Other things
00:03:06 -
Customizing your Views in Excel
00:02:49 -
Addition of Rows & Columns in Excel
00:01:53 -
Playing with Worksheets
00:03:27 -
Worksheets Side By Side
00:01:28 -
Formula Evaluation and Excel Auditing Tools
00:04:58 -
Protecting Work Book & Sheet
00:03:09 -
Adding a hyperlink
00:04:06 -
Tables & Advance Tables in Excel
00:03:19 -
Data filters & Sorting.
00:04:41 -
Data validation
00:03:08 -
GOTO & GOTO Special
00:02:57 -
Removing Duplicates
00:01:37 -
How to Create a Drop Down
00:01:19 -
Named Ranges
00:02:11
-
-
Excel Charts
3 Lectures 00:12:45-
Column Chart & Bar Charts
00:05:52 -
Formatting the Column Chart.
00:04:18 -
Pie Chart
00:02:35
-
-
Pivot Tables
1 Lectures 00:08:57-
Pivot Tables
00:08:57
-
-
Advanced Excel & Excel Analytics
3 Lectures 00:23:28-
Simple Linear Regression for Forecasting with a example
00:12:00 -
Goal Seeker
00:03:49 -
Solving Problems Using Solver
00:07:39
-
-
Case Studies & Introduction to Excel Dash Boards [ Business Intelligence ].
2 Lectures 00:41:39-
Case 1. Class Marks Case Study using excel Formulas & Building a Dashboard
00:36:53 -
Case 2.Predicting Sales of Fertilizer using Simple Linear regression
00:04:46
-
-
Macro Basics [ VBA ]
1 Lectures 00:04:02-
Basics of VBA - Create a Macro and assign a button to it.
00:04:02
-
-
Conclusion
1 Lectures-
Conclusion - End of theCourse.
-

Logistics And Supply Chain World.
Hello Students,
We are from LOGISTICS & Supply Chain World. Our aim is to teach Students Excel, Supply Chain Concepts , Logistics Concepts , Marketing, Entrepreneurship, Social Media Marketing, Data Science Concepts and other areas as well. These Courses will equip students with knowledge and skills to face the Real World.
Our Aim is to Equip Students with best skills trending in the market.
We provide Students with all the Relevant Material Like E books and the relevant material.
Regards,
Logistics & Supply Chain World