Free Basic Excel Course + Lookup Function

Excel made easy for everyone
Rating: 4.4 out of 5 (2,805 ratings)
36,651 students
English
English [Auto]
The students will learn the basics which are needed to work on excel

Requirements

  • Interest to Learn
  • Microsoft Excel Installed in their computers or laptop

Description

Microsoft Excel has the basic features of all spreadsheets,using a grid of cells arranged in numbered rows and letter-named columns to organize data manipulations like arithmetic operations. It has a battery of supplied functions to answer statistical, engineering and financial needs. In addition, it can display data as line graphs, histograms and charts, and with a very limited three-dimensional graphical display. It allows sectioning of data to view its dependencies on various factors for different perspectives using pivot tables.

In this course you will be learning the basics which is required when you start working with Microsoft Excel. In today's time Microsoft Excel is one of the most important tool used in any organization. This course will definately help you to learn the basics with the practical use of it.

Who this course is for:

  • Anyone who wants to learn working with Excel

Course content

1 section25 lectures1h 41m total length
  • Creating a Loan Calculator-1
    08:38
  • Creating a Loan Calculator-2
    08:19
  • Creating a Loan Calculator-3
    03:15
  • Function Basics
    05:12
  • Logical Functions
    18:31
  • Mathematical Functions
    12:20
  • Lookup and Reference Functions
    09:34
  • LOOKUP, VLOOKUP, and HLOOKUP Functions
    19:03
  • Introduction to Advanced charts
    01:38
  • Line chart
    00:52
  • Column chart
    00:26
  • Pie chart
    00:30
  • Area Chart
    00:47
  • Converting area chart into line chart
    00:38
  • What is regression analysis ?
    01:01
  • What are chart templates
    00:52
  • What are sparklines
    00:23
  • Sparklines vs charts
    01:15
  • Data in hidden rows and columns
    00:22
  • Introduction to Pivot chart and tables
    00:36
  • Creating pivot charts
    01:04
  • Creating pivot table
    01:06
  • Multiple fields in row, column or data section
    02:22
  • Creating pivot charts
    01:03
  • Creating and using calculated fields
    02:04

Instructor

Creating a Knowledge Lit World
MKCL India
  • 4.3 Instructor Rating
  • 6,206 Reviews
  • 102,668 Students
  • 25 Courses

We are an eLearning company with more than 10 million learners for our courses. Our expertise is in creating eLearning courses which are self paced and rich in instructional design. We focus on the principles of 'learning by doing' in the courses by teaching the concepts and the tools while creating projects or assets.