Complete Microsoft Excel Master Class - 2024

Excel Formulas & Functions, Advance Excel Analytics, Case Studies, BI Dashboards, Charts, Macros & Practice Exercises

4.30 (328 reviews)

Udemy

platform

English

language

Data & Analytics

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.

Why take this course?

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.

Screenshots

Complete Microsoft Excel Master Class - 2024 - Screenshot_01

Complete Microsoft Excel Master Class - 2024 - Screenshot_02

Complete Microsoft Excel Master Class - 2024 - Screenshot_03

Complete Microsoft Excel Master Class - 2024 - Screenshot_04

Reviews

Arijit

September 20, 2023

very bad way of teaching , words are not clear enough , fumbles a lot and just jumping from here and there

Harivansh

July 19, 2023

The "Complete Microsoft Excel Master Class - 2023" is an exceptional course that surpassed all my expectations. As someone with intermediate Excel skills, I found this course to be a comprehensive and invaluable resource for mastering the program. The instructor's expertise and teaching style were exemplary, making complex concepts easily understandable. The course content covered a wide range of topics, from basic functions to advanced data analysis techniques, providing a well-rounded learning experience. What impressed me the most was the practical approach taken throughout the course, with numerous real-life examples and hands-on exercises that solidified my understanding. The course materials, including video tutorials and downloadable resources, were top-notch and enhanced the learning process. Furthermore, the course was regularly updated with the latest Excel features, ensuring its relevance in the ever-evolving landscape of spreadsheet software. Overall, the "Complete Microsoft Excel Master Class - 2023" is a must-have for anyone seeking to enhance their Excel skills, and I wholeheartedly recommend it to both beginners and intermediate users.

Fouad

April 29, 2023

The instructor explains how to do the formula and not the use of the formula, how I can make use of it or the wide range of usage for instance. Its just a problem and he is solving it.

Christian

December 5, 2022

Not very good at enunciating words, also it feels rushed. speaking very fast and not stopping for hypothetical errors in execution.

Zaman

July 6, 2022

Going to fast and missing steps. Example: You have used 'fix cell value' in multiple videos but missed to advise shortcut to fix cells i.e, F4.

Rakib

May 18, 2021

First of all, I got too many learnings from this course. Thank you for arranging all master tools in one course. But it was a little bit unorganized, some times Instructor rewrite the function and the auto captions didn't get your pronunciation.

Amir

May 16, 2021

The Teacher Clearly explained the lesson Each of the topics are covered in detail and very clearly in an easily understandable manner.it was easy to pickup and the videos was awesome especially the way of teaching it's very nice Even i enjoyed of learning MS EXCEL from "udemy"i am very happy that i have enrolled and completed this course.It was a fun and interesting learning experience

Tariq

May 10, 2021

too fast and he should tell everything what he does. Like he dont mention in this video how he sum up all numbers.

Merry

May 8, 2021

Thank you so much for giving me a chance to learn about excel. This would be a huge help on my future career, Thank you so much.

Vinaykumar

April 22, 2021

The name is Master Class but most of the things are very basic. I choose this course because I wanted an in-depth knowledge of advance Excel, especially dashboards.. this course is a moderate level course so kindly change the name and please don't misguide students. Having said that, thank you for your time.

Bhautikkumar

March 4, 2021

Absolutely worth it. Thank you for this content. I learned lots of things in excel. And I'm also specially thankful for case study according to SCM World. >Though teaching skill could be better because in few few section, it was hard to get exact meaning of whatever you wanted to say, and simple example would be very nice. Speaking speed is fast but I could catch it so I was ok with it. > Please create folders of practice files separately and keep it blank, so students don't need to remove data. And solution could be place in other file. And Zip file would be nice cuz there are many excel files. I hope it can be updated so future students will manage and get easily and quickly.

K.K.Rithik

July 13, 2020

He is speakng very fast and he is not explaining the things for example in mixed refernce table why he mentioned dollar with 4

Charts

Price

Rating

Enrollment distribution

Complete Microsoft Excel Master Class - 2024 - Distribution chart