Tutorialspoint

Celebrating 11 Years of Learning Excellence! Use: TP11

Microsoft Excel - Beginner to Advanced

person icon Mahammad Mansoor

4.6

Microsoft Excel - Beginner to Advanced

Learn Microsoft Excel Essentials, a Spreadsheet Application in the real world for Beginners to Advanced Users

updated on icon Updated on Jun, 2025

language icon Language - English

person icon Mahammad Mansoor

category icon Office Productivity,Microsoft,Excel

Lectures -72

Duration -8 hours

Lifetime Access

4.6

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

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.

Microsoft Excel - Beginner to Advanced

Curriculum

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

Course Intro

3 Lectures
  • play icon Welcome to Microsoft Excel Course 01:41 01:41
  • play icon What is Excel ? 01:05 01:05
  • play icon Excel Introduction 06:48 06:48

Save Options in MS Excel

1 Lectures
Tutorialspoint

Entering Data in Excel File

1 Lectures
Tutorialspoint

Workbooks and Sheets

1 Lectures
Tutorialspoint

Copy and Paste Special

1 Lectures
Tutorialspoint

Relative Vs Absolute References

1 Lectures
Tutorialspoint

Formatting in Excel

3 Lectures
Tutorialspoint

Conditional Formatting

3 Lectures
Tutorialspoint

Freeze Panes In excel

1 Lectures
Tutorialspoint

Sorting & Filtering Data in Excel

5 Lectures
Tutorialspoint

Basic Functions

2 Lectures
Tutorialspoint

Data Handling in Excel

4 Lectures
Tutorialspoint

Logical Test

1 Lectures
Tutorialspoint

Text Functions in Excel

4 Lectures
Tutorialspoint

Logical Functions of Excel

9 Lectures
Tutorialspoint

Mathematical Functions in Excel

2 Lectures
Tutorialspoint

Date And Time Functions in Excel

4 Lectures
Tutorialspoint

Find and Replace Options

1 Lectures
Tutorialspoint

Tables in Excel

2 Lectures
Tutorialspoint

PIVOT TABLES & LOOKUP FUNCTIONALITY

9 Lectures
Tutorialspoint

Name Range

1 Lectures
Tutorialspoint

What-If Analysis in Excel

2 Lectures
Tutorialspoint

Charts in MS Excel

11 Lectures
Tutorialspoint

Instructor Details

Mahammad Mansoor

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.

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