Sharing Is Caring:

Free Basic Excel Course + Lookup Function

  • Excel made easy for everyone
  • Free tutorial
  • Rating: 3.9 out of 53.9 (3,276 ratings)
  • 53,721 students
  • 1hr 42min of on-demand video
  • Created by MKCL India


What you’ll learn

  • The students will learn the basics which are needed to work on excel


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


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

Show less

Course content

1 section • 25 lectures • 1h 41m total length

Basic Excel Course25 lectures • 1hr 42min

  • Creating a Loan Calculator-108:38
  • Creating a Loan Calculator-208:19
  • Creating a Loan Calculator-303:15
  • Function Basics05:12
  • Logical Functions18:31
  • Mathematical Functions12:20
  • Lookup and Reference Functions09:34
  • LOOKUP, VLOOKUP, and HLOOKUP Functions19:03
  • Introduction to Advanced charts01:38
  • Line chart00:52
  • Column chart00:26
  • Pie chart00:30
  • Area Chart00:47
  • Converting area chart into line chart00:38
  • What is regression analysis ?01:01
  • What are chart templates00:52
  • What are sparklines00:23
  • Sparklines vs charts01:15
  • Data in hidden rows and columns00:22
  • Introduction to Pivot chart and tables00:36
  • Creating pivot charts01:04
  • Creating pivot table01:06
  • Multiple fields in row, column or data section02:22
  • Creating pivot charts01:03
  • Creating and using calculated fields02:04
Read Also -->   Appium - Selenium for Mobile Automation Testing

👇👇👇👇 Click Below to Enroll in Free Udemy Course 👇👇👇👇

Go to Course

👇👇 See Also 👇👇

Join Us Join Us Join Us
Sharing Is Caring:

Leave a Comment

Ads Blocker Image Powered by Code Help Pro

Ads Blocker Detected!!!

We have detected that you are using extensions to block ads. Please support us by disabling these ads blocker.

Powered By
100% Free SEO Tools - Tool Kits PRO