Tutorialspoint

MS Excel From Beginners to advance

Become an Excel Expert

Course Description

In this course, you will learn Excel from zero to advance level. All the topics are started from a very basic level. This course covers the following topics in detail.

Solid understanding of Microsoft excel.

Most commonly used functions in office.

Logical functions, Conditional functions, lookup functions, INDEX, and match function.

Nesting functions.

Preparing Visual data presentation skills with help of different types of charts.

Creating dynamic reports with the help of Pivot table.

Along with these, there are some real-life examples and various types of reports that are used in organizations for different purposes. 

Goals

  • Scope and use of MS Excel.
  • Excel Fundamental
  • Function and Formulas
  • Charts
  • Pivot Table
  • Nesting functions
  • Preparing different types of reports.
  • Playing with big data.

Prerequisites

  • This course does not require any prerequisite skills. For practice purposes, students need a PC/Laptop with MS Excel(Any Version) installed on this.
Show More

Curriculum

  • Course Overview
    06:41
    Preview
  • Q&A - Resources
    00:38
  • Launching MS Excel
    03:13
    Preview
  • Saving Excel File
    04:27
    Preview
  • Excel Interface
    06:12
    Preview
  • Customizing Quick Access Toolbar
    03:17
  • Customizing Ribbon
    05:00
  • Worksheet View
    01:52
    Preview
  • Frequently Used Excel Shortcut Keys
    08:45
    Preview
  • Excel Shortcuts - Part 2
    08:10
Tutorialspoint
Tutorialspoint
Tutorialspoint
Tutorialspoint
Tutorialspoint
Tutorialspoint
Tutorialspoint
Tutorialspoint
Tutorialspoint
Tutorialspoint
Tutorialspoint
Tutorialspoint
Tutorialspoint
Tutorialspoint
Tutorialspoint
Tutorialspoint
Tutorialspoint
Tutorialspoint
Tutorialspoint
Tutorialspoint
Tutorialspoint
Tutorialspoint
Tutorialspoint
Tutorialspoint
Tutorialspoint
Feedbacks
4.5
Course Rating
75%
0%
25%
0%
0%

    Feedbacks (4)

  • Sachin Joshi
    Sachin Joshi

  • Praful Suresh jamadar
    Praful Suresh jamadar

  • ABHIJIT SHANTARAM BHONDVE
    ABHIJIT SHANTARAM BHONDVE

  • BASAVARAJ A ARABHANVI
    BASAVARAJ A ARABHANVI

MS Excel From Beginners to advance
This Course Includes
  • 22 hours
  • 226 Lectures
  • 29 Resources
  • Completion Certificate Sample Certificate
  • Lifetime Access Yes
  • Language Hindi
  • 30-Days Money Back Guarantee

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.

X

Sample Certificate