Free Basic Excel Course + Lookup Function

Excel made easy for everyone

Created byMKCL India

Last updated 2/2019

English

What you'll learn

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

Course content

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

Creating a Loan Calculator-18:38
Creating a Loan Calculator-28:19
Creating a Loan Calculator-33:15
Function Basics5:12
Logical Functions18:31
Mathematical Functions12:20
Master essential Excel functions for mathematics, including average, mode, median, area and volume calculations, and rounding, plus mod, int and rand between.
Lookup and Reference Functions9:34
LOOKUP, VLOOKUP, and HLOOKUP Functions19:03
Introduction to Advanced charts1:38
Line chart0:52
Column chart0:26
Pie chart0:30
Area Chart0:47
Converting area chart into line chart0:38
What is regression analysis ?1:01
What are chart templates0:52
What are sparklines0:23
Sparklines vs charts1:15
Compare sparklines and charts to visualize large data sets; place sparklines next to each row to reveal relationships and trends, while charts offer greater detail and cross-series comparisons.
Data in hidden rows and columns0:22
Introduction to Pivot chart and tables0:36
Creating pivot charts1:04
Creating pivot table1:06
Multiple fields in row, column or data section2:22
Learn to build a pivot table that counts months served by gender, placing gender in columns and employee codes in values, using value field settings to count.
Creating pivot charts1:03
Creating and using calculated fields2:04

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