Free Basic Excel Course + Lookup Function

Free Basic Excel Course + Lookup Function, available at Free, has an average rating of 4.55, with 25 lectures, based on 3317 reviews, and has 56394 subscribers.

You will learn about The students will learn the basics which are needed to work on excel This course is ideal for individuals who are Anyone who wants to learn working with Excel It is particularly useful for Anyone who wants to learn working with Excel.

Enroll now: Free Basic Excel Course + Lookup Function

Summary

Title: Free Basic Excel Course + Lookup Function

Price: Free

Average Rating: 4.55

Number of Lectures: 25

Number of Published Lectures: 25

Number of Curriculum Items: 25

Number of Published Curriculum Objects: 25

Original Price: Free

Quality Status: approved

Status: Live

What You Will Learn

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

Who Should Attend

Anyone who wants to learn working with Excel

Target Audiences

Anyone who wants to learn working with Excel

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.

Course Curriculum

Chapter 1: Basic Excel Course

Lecture 1: Creating a Loan Calculator-1

Lecture 2: Creating a Loan Calculator-2

Lecture 3: Creating a Loan Calculator-3

Lecture 4: Function Basics

Lecture 5: Logical Functions

Lecture 6: Mathematical Functions

Lecture 7: Lookup and Reference Functions

Lecture 8: LOOKUP, VLOOKUP, and HLOOKUP Functions

Lecture 9: Introduction to Advanced charts

Lecture 10: Line chart

Lecture 11: Column chart

Lecture 12: Pie chart

Lecture 13: Area Chart

Lecture 14: Converting area chart into line chart

Lecture 15: What is regression analysis ?

Lecture 16: What are chart templates

Lecture 17: What are sparklines

Lecture 18: Sparklines vs charts

Lecture 19: Data in hidden rows and columns

Lecture 20: Introduction to Pivot chart and tables

Lecture 21: Creating pivot charts

Lecture 22: Creating pivot table

Lecture 23: Multiple fields in row, column or data section

Lecture 24: Creating pivot charts

Lecture 25: Creating and using calculated fields

Instructors

MKCL India
Creating a Knowledge Lit World

Rating Distribution

1 stars: 53 votes
2 stars: 125 votes
3 stars: 623 votes
4 stars: 1216 votes
5 stars: 1300 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu