Teach with us
Tutorialspoint

Microsoft Excel : The Complete Guide

Learn from scratch to advance

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

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
Show More

Curriculum

  • Introduction to Excel
    06:09
    Preview
  • Excel first screen
    05:54
  • Excel first screen1
    05:54
  • Edit the sheet - Lecture 1
    05:41
    Preview
  • Edit the sheet - Lecture 2
    08:24
  • Edit the sheet - lecture 3
    08:12
  • Write number, date and other series
    02:53
  • Define name to data and cell
    03:17
Tutorialspoint
Tutorialspoint
Tutorialspoint
Tutorialspoint
Tutorialspoint
Tutorialspoint
Tutorialspoint
Tutorialspoint
Tutorialspoint
Tutorialspoint
Tutorialspoint
Tutorialspoint
Tutorialspoint
Feedbacks
  • No Feedbacks Posted Yet..!
Microsoft Excel : The Complete Guide
This Course Includes
  • 5 hours
  • 50 Lectures
  • Completion Certificate Sample Certificate
  • Lifetime Access Yes
  • Language English
  • 30-Days Money Back Guarantee
Gift Course

Sample Certificate

sample certificate

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

We have 30 Million registered users and counting who have advanced their careers with us.

Related Videos

view more
Tutorialspoint
X

Sample Certificate

Annual Membership

Annual Membership

Enjoy unlimited access on 7000+ Hand Picked Quality Video Courses
Training for a Team

Training for a Team

Affordable solution to train a team and make them project ready.

 Request a Demo

Talk to us

1800-202-0515