Microsoft Excel : The Complete Guide

person icon Anand Mahajan

Microsoft Excel : The Complete Guide

Learn from scratch to advance

updated on icon Updated on Sep, 2023

language icon Language - English

person icon Anand Mahajan

architecture icon Excel,Office Productivity,Microsoft


30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 19,000+ top Tutorialspoint courses anytime, anywhere.

Course Description

 "Ms-Excel: The Complete Guide"  course fulfills the requirement of all students either beginner or advanced. The student will learn Excel from scratch to advance. The following topics are covered:

  1. Purpose of Excel 
  2. write and edit the data
  3.  Text and  Maths functions and formulae
  4. Data & time functions
  5. Pivot table
  6. sorting and table formatting
  7. Conditional formatting 
  8. protect worksheet and workbook
  9. organize the data
  10. Vlookup and hookup
  11. Static & DynamicCharts
  12.  Subtotal the data and goal seek
  13.  Manage multiple windows and freeze panes
  14. Insert and import data
  15.  Macros
  16. Create forms


What will you learn in this course:

  • How to write & edit in Excel along with the formatting of data.
  •  How to implement the math and text functions on data and string respectively.
  • How to find the specific data from very large data using vlookup and hlookup.
  •  Draw static charts and automatically change charts using dynamic charts.
  • Highlight the specific data based upon the condition using conditional formatting.
  • Make a summary or organize data using a pivot table.
  • Save the actions using macros and do the work automatically.
  • sorting and advance sorting
  • many more......


What are the prerequisites for this course?

  • Basic and fundamentals of computers
  • Computer with Windows 7 onward
Microsoft Excel : The Complete Guide


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

Write and Edit Excel sheet
8 Lectures
  • play icon Introduction to Excel 06:09 06:09
  • play icon Excel first screen 05:54 05:54
  • play icon Excel first screen1 05:54 05:54
  • play icon Edit the sheet - Lecture 1 05:41 05:41
  • play icon Edit the sheet - Lecture 2 08:24 08:24
  • play icon Edit the sheet - lecture 3 08:12 08:12
  • play icon Write number, date and other series 02:53 02:53
  • play icon Define name to data and cell 03:17 03:17
3 Lectures
Functions and Formulae
5 Lectures
4 Lectures
2 Lectures
Insert Objects
2 Lectures
Organise worksheet
5 Lectures
Filter data from the large data
5 Lectures
Data validation while Inputting the data
3 Lectures
Consolidate Data
4 Lectures
Create Form to input data
1 Lectures
2 Lectures
Search data using vlookup & hlookup
4 Lectures
Pivot table
2 Lectures

Instructor Details

Anand Mahajan

Anand Mahajan

Senior Programming Instructor

I started teaching programming when I myself was a student. I have been training Computer Science students for the last 20+ years, I have a fair deal of experience in the training of C, C++, Core Java, Advanced Java, PHP and .Net to thousands of students. All these students vouch for my training skills , dedication to my responsibility towards my students. What I believe is - my students who repose faith in me deserve the BEST training. I have been the most recommended computer programming teacher in the region. But despite this enormous experience I always believe that there is always room for improvement. So I will appreciate if any student points out my weak points or foibles.

Course Certificate

User your certification to make a career change or to advance in your current career. Salaries are among the highest in the world.

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
People having fun around a laptop

Online Certifications

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

Explore Now
People having fun around a laptop

Talk to us