Microsoft Excel : The Complete Guide
Learn from scratch to advance
Updated on Sep, 2023
Language - English
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:
- 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
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......
Prerequisites
What are the prerequisites for this course?
- 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
Senior Programming InstructorI 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.
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