Tutorialspoint

Celebrating 11 Years of Learning Excellence! Use: TP11

Microsoft Excel Mastery Course: Beginner to Expert Level

person icon Logistics And Supply Chain World.

4.2

Microsoft Excel Mastery Course: Beginner to Expert Level

Learn all the Excel Formulas, Advanced Analytics, Case Studies, BI Dashboards, Macros & more advanced topics

updated on icon Updated on Jun, 2025

language icon Language - English

person icon Logistics And Supply Chain World.

English [CC]

category icon Office Productivity,Microsoft,Excel

Lectures -68

Resources -51

Duration -4 hours

Lifetime Access

4.2

price-loader

Lifetime Access

30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.

Course 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 is 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 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.

This course covers:

  • Course Introduction.
  • Excel Basics.
  • Excel Formulas ( Mathematical Formulas ).
  • Excel Formulas ( Lookup Formulas ).
  • Excel Formulas ( Logical Formulas ).
  • Excel Formulas ( Text Formulas ).
  • Excel Formulas ( Date Formulas ).
  • Formatting.
  • Other things in Microsoft Excel.
  • Excel Charts.
  • Pivot Chart.
  • Advance Excel.
  • Case Studies.
  • Macros Basics.
  • Excel Short Cuts.

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

Goals

  • 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.
  • Make 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.
  • Advanced 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.

Prerequisites

  • You will need a PC with any version of Excel installed on 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.
Microsoft Excel Mastery Course: Beginner to Expert Level

Curriculum

Check out the detailed breakdown of what’s inside the course

Course Introduction.

4 Lectures
  • play icon Course Introduction. 03:42 03:42
  • play icon Course Flow. 04:04 04:04
  • play icon Course Expectation. 00:38 00:38
  • play icon Course Handouts.

The Basics of Excel.

5 Lectures
Tutorialspoint

Excel Formulas [Mathematical Formula]

10 Lectures
Tutorialspoint

Excel Formulas [ Look Up Formula ]

5 Lectures
Tutorialspoint

Excel Formulas [ Logical Formula ]

5 Lectures
Tutorialspoint

Excel Formulas [ Date & Time Formulas ]

1 Lectures
Tutorialspoint

Excel Formulas [ Text Formulas ]

1 Lectures
Tutorialspoint

Complete Formatting in Excel

4 Lectures
Tutorialspoint

All other things that you can do in EXCEL.

21 Lectures
Tutorialspoint

Excel Charts

3 Lectures
Tutorialspoint

Pivot Tables

1 Lectures
Tutorialspoint

Advanced Excel & Excel Analytics

3 Lectures
Tutorialspoint

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

2 Lectures
Tutorialspoint

Macro Basics [ VBA ]

1 Lectures
Tutorialspoint

Conclusion

1 Lectures
Tutorialspoint

Instructor Details

Logistics and Supply Chain World.

Logistics and Supply Chain World.

Course Certificate

Use your certificate to make a career change or to advance in your current career.

sample Tutorialspoint certificate

Our students work
with the Best

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
Annual Membership

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
Online Certifications

Talk to us

1800-202-0515