Microsoft Excel : The Complete Guide
Learn how to write & edit in Excel along with the formatting of data
Updated on Jun, 2025
Language - English
Office Productivity,Microsoft,Excel
Lectures -50
Duration -5 hours
Lifetime Access
Lifetime Access
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course Description
The "Ms-Excel: The Complete Guide" course fulfils the requirement of all students either beginner or advanced.
The student will learn Excel from scratch to advance. The following topics are covered:
- Purpose of Excel.
- write and edit the data.
- Text and Maths functions and formulae.
- Data & time functions.
- Pivot table.
- sorting and table formatting.
- Conditional formatting.
- protect worksheet and workbook.
- organize the data.
- Vlookup and hookup.
- Static & DynamicCharts.
- Subtotal the data and goal seek.
- Manage multiple windows and freeze panes.
- Insert and import data.
- Macros.
- Create forms.
Goals
- 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 on 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 advanced sorting
- many more......
Prerequisites
- Basic and fundamentals of computers.
- Computer with Windows 7 onward.
Curriculum
Check out the detailed breakdown of what’s inside the course
Write and Edit Excel sheet
8 Lectures
-
Introduction to Excel
06:09
06:09
-
Excel first screen
05:54
05:54
-
Excel first screen1
05:54
05:54
-
Edit the sheet - Lecture 1
05:41
05:41
-
Edit the sheet - Lecture 2
08:24
08:24
-
Edit the sheet - lecture 3
08:12
08:12
-
Write number, date and other series
02:53
02:53
-
Define name to data and cell
03:17
03:17
Formatting
3 Lectures
Functions and Formulae
5 Lectures
Charts
4 Lectures
Sorting
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
Macros
2 Lectures
Search data using vlookup & hlookup
4 Lectures
Pivot table
2 Lectures
Instructor Details
Anand Mahajan
⚫ Anand Mahajan has been providing state-of-the-art training for more than 26 Years. He is a visionary online course creator renowned for his innovative approach to digital education. With a deep-rooted passion for knowledge and technology, Anand has crafted a series of engaging and impactful online courses that cater to a diverse audience.
⚫ His expertise spans various programming languages, including C, C++, Core Java, JSP & Java Servlets, and Python making his courses highly sought after by learners worldwide. Data Structures with implementation is also a course he is known for.
⚫ He established a programming training institute in 1998 after gaining experience in prestigious computer training institutes. During his exciting journey, he trained thousands of Engineering and Computer Science students conducting classroom lectures and practicals. Scores of his students placed in reputed companies are abundantly appreciative of his methodology in explaining the coding intricacies.
⚫Now Mahajan is only into developing online courses. His courses are published on prestigious online learning platforms like MKCL (Maharashtra Knowledge Corporation Ltd.), HKCL, Internshala, Packt. publishing, UK, etc.
2) English-speaking trainer related:
I have had a great deal of passion for the English language since my school days. I have trained scores of students, professionals, and employees in English speaking skills using online and phone medium.
Idioms, phrases, advanced vocabulary words are my forte. I have uploaded many audios on some Spoken English practice apps.
I have been writing articles and letters in the English newspapers also.
I have been guiding students by giving them surefire tips on improving their English without getting frustrated.
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