Microsoft Excel - Beginner to Advanced
Learn Microsoft Excel Essentials, a Spreadsheet Application in the real world for Beginners to Advanced Users
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