Complete Microsoft Excel Master Class.

Complete Microsoft Excel Master Class., available at $54.99, has an average rating of 4.15, with 68 lectures, based on 350 reviews, and has 12524 subscribers.

You will learn about 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 Macros: Learn to Automate things by recording a Macro and assigning a button to it. 30+ Excel shortcuts useful in daily Life. This course is ideal for individuals who are 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 It is particularly useful 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.

Enroll now: Complete Microsoft Excel Master Class.

Summary

Title: Complete Microsoft Excel Master Class.

Price: $54.99

Average Rating: 4.15

Number of Lectures: 68

Number of Published Lectures: 68

Number of Curriculum Items: 68

Number of Published Curriculum Objects: 68

Original Price: ₹7,900

Quality Status: approved

Status: Live

What You Will 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
Macros: Learn to Automate things by recording a Macro and assigning a button to it.
30+ Excel shortcuts useful in daily Life.

Who Should Attend

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

Target Audiences

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

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.

Course Curriculum

Chapter 1: Course Introduction.

Lecture 1: Introduction.

Lecture 2: What to expect from this course?

Lecture 3: Course Handouts

Lecture 4: Reviews on this Course.

Chapter 2: Excel Basics.

Lecture 1: Microsoft Excel Introduction.

Lecture 2: Microsoft Excel Basics

Lecture 3: Characteristics of a Cell

Lecture 4: Cell Reference

Lecture 5: Creating a File Template & Closing it

Chapter 3: Excel Formulas ( Mathematical Formulas ).

Lecture 1: MIN Formula

Lecture 2: Max Formula

Lecture 3: Average Formula

Lecture 4: Sum Formula

Lecture 5: Large Formula

Lecture 6: Rand Between Formula

Lecture 7: Round Formula

Lecture 8: Sub Total Formula

Lecture 9: Sum Product Formula

Lecture 10: Rank Formula

Chapter 4: Excel Formulas ( Lookup Formulas ).

Lecture 1: Vlook Up Formula

Lecture 2: Hlook Up Formula

Lecture 3: Match Formula

Lecture 4: Index Formula

Lecture 5: Combination of Both Index & Match

Chapter 5: Excel Formulas ( Logical Formulas ).

Lecture 1: OR Formula

Lecture 2: AND Formula

Lecture 3: IF Formula

Lecture 4: Sum IF Formula & Sum IFS

Lecture 5: Count IF & Count IFS

Chapter 6: Excel Formulas ( Date & Time Formulas ).

Lecture 1: Date & Time Formulas

Chapter 7: Excel Formulas ( Text Formulas ).

Lecture 1: Text Formulas

Chapter 8: Formatting.

Lecture 1: Formatting Basics

Lecture 2: Conditional Formatting Part-1

Lecture 3: Conditional Formatting Part-2

Lecture 4: Advanced Conditional Formatting

Chapter 9: Other Things That you can do in EXCEL.

Lecture 1: Excel Data Editing: Find & Replace

Lecture 2: Excel Cell that speaks: Tell excel to speak what you have-Advance Part In Excel.

Lecture 3: Text to Columns: Separating Words or Sentences connected with a delimiter.

Lecture 4: Inserting Comments: Inserting Comments , Seeing all comments in the excel sheet

Lecture 5: Paste Special: Different Operations using Paste Special.

Lecture 6: What is Fill & Advance filling & Flash Fill

Lecture 7: Freezing Sheets & Other things

Lecture 8: Customizing your Views in Excel

Lecture 9: Addition of Rows & Columns in Excel

Lecture 10: Playing with Worksheets

Lecture 11: Worksheets Side By Side

Lecture 12: Formula Evaluation and Excel Auditing Tools

Lecture 13: Protecting Work Book & Sheet

Lecture 14: Adding a hyperlink

Lecture 15: Tables & Advance Tables in Excel

Lecture 16: Data filters & Sorting.

Lecture 17: Data validation

Lecture 18: GOTO & GOTO Special

Lecture 19: Removing Duplicates

Lecture 20: How to Create a Drop Down

Lecture 21: Named Ranges

Chapter 10: Excel Charts.

Lecture 1: Column Chart & Bar Charts

Lecture 2: Formatting the Column Chart.

Lecture 3: Pie Chart

Chapter 11: Pivot Charts.

Lecture 1: Pivot Charts

Chapter 12: Advance Excel.

Lecture 1: Simple Linear Regression for Forecasting with a example

Lecture 2: Goal Seeker

Lecture 3: Solving Problems Using Solver

Chapter 13: Case Studies & Introduction to Excel Dash Boards [Business Intelligence].

Lecture 1: Case 1. Class Marks Case Study using excel Formulas & Building a Dashboard

Lecture 2: Case 2.Predicting Sales of Fertilizer using Simple Linear regression

Chapter 14: Macro Basics [ VBA ].

Lecture 1: Macro Basics

Chapter 15: All Important Excel Short Cuts consolidated in Excel sheet.

Lecture 1: Excel Shortcuts

Lecture 2: Conclusion

Instructors

Rahul Srinivas
8000 + Students || 142 Countries || 4.5 Instructor Rating

Rating Distribution

1 stars: 6 votes
2 stars: 14 votes
3 stars: 46 votes
4 stars: 119 votes
5 stars: 165 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

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!

Menu