Microsoft Excel : The Complete Guide
Learn from scratch to advance
Updated on Jul, 2024
Language - English
Excel,Office Productivity,Microsoft
Lectures -50
Duration -5 hours
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point 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:
- 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 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
- 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
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