Microsoft Excel - Beginner to Advanced
Learn Microsoft Excel Essentials, a Spreadsheet Application in the real world for Beginners to Advanced Users
Updated on Jun, 2025
Language - English
Office Productivity,Microsoft,Excel
Lectures -72
Duration -8 hours
Lifetime Access
Lifetime Access
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course Description
This Course will teach one and all interested in knowing the best software invented till date which is none other than Microsoft Excel.
You will learn Look-up Functionality, Pivot tables & Formatting, Basic functions in Excel, Flash Fill and much more.
Learning this will help you excel in your career and boost your skills.
Getting started with Excel.
In this Excel course, you’ll learn the fundamentals to analyze data in spreadsheets before you know it. This course focuses on helping you navigate Excel and prepare your data for basic analysis. You’ll learn to manage tables and apply calculations to your data to provide new insights.
Working with Functions
You’ll learn about the many available functions in Excel that can help you to perform calculations, analyze data and, in some cases, automate tasks. We’ll start your journey into understanding the full potential of Excel functions and leverage built-ins such as SUM, AVERAGE, COUNT, UPPER, LEFT, and more.
Excel is a spreadsheet software that allows you to organize, analyze, and visualize data. An Excel course would teach you how to use various features and functions of Excel, such as:
How to create, save, and open workbooks
How to enter, edit, and format data in cells and ranges
How to use formulas and functions to perform calculations and analysis
How to create and customize charts, tables, and pivot tables
How to apply filters, sorting, and conditional formatting to the data
Goals
Learn Excel in an Easy and Effective way without getting bored.
Learn VLOOKUP, XLOOKUP, INDEX & MATCH, Conditional Formatting and many more functions.
Learn Basic to Advanced Topics like Pivot tables.
Be able to Create Various Charts in Excel.
Prerequisites
No Prior knowledge is required.
Here you will learn everything about Microsoft Excel.
Curriculum
Check out the detailed breakdown of what’s inside the course
Course Intro
3 Lectures
-
Welcome to Microsoft Excel Course
01:41
01:41
-
What is Excel ?
01:05
01:05
-
Excel Introduction
06:48
06:48
Save Options in MS Excel
1 Lectures
Entering Data in Excel File
1 Lectures
Workbooks and Sheets
1 Lectures
Copy and Paste Special
1 Lectures
Relative Vs Absolute References
1 Lectures
Formatting in Excel
3 Lectures
Conditional Formatting
3 Lectures
Freeze Panes In excel
1 Lectures
Sorting & Filtering Data in Excel
5 Lectures
Basic Functions
2 Lectures
Data Handling in Excel
4 Lectures
Logical Test
1 Lectures
Text Functions in Excel
4 Lectures
Logical Functions of Excel
9 Lectures
Mathematical Functions in Excel
2 Lectures
Date And Time Functions in Excel
4 Lectures
Find and Replace Options
1 Lectures
Tables in Excel
2 Lectures
PIVOT TABLES & LOOKUP FUNCTIONALITY
9 Lectures
Name Range
1 Lectures
What-If Analysis in Excel
2 Lectures
Charts in MS Excel
11 Lectures
Instructor Details
Mahammad Mansoor
I am a Mechanical Engineer with 17 years of experience spanning across industries in the Aerospace, Automotive, Heavy Machinery, Oil and gas industry. All the projects I have worked on i have used Microsoft Office specially Excel.
I hope my courses will help you excel in your career and life in general.
Course Certificate
Use your certificate to make a career change or to advance in your current career.
Our students work
with the Best
Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe now
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now