Classbaze

Disclosure: when you buy through links on our site, we may earn an affiliate commission.

Excel – LookUp Functions

Excel in Excel learning what LookUp Functions are and how to use them!
0.0
☆☆☆☆☆ 0.0/5
(0 reviews)
0 students
Created by
Kathleen Martens

9.6

Classbaze Grade®

10.0

Freshness

N/A

Popularity

8.7

Material

Detailed Analysis »

Excel in Excel learning what LookUp Functions are and how to use them!
Go to course »
Platform: Udemy
Price: check current price
Video: 54m
Language: English
Next start: On Demand

Best Excel Formulas and Functions classes:

Skillshare_logo_2020
Best Excel Formulas and Functions classes on Skillshare »
Coursera Logo
Best Excel Formulas and Functions classes on Coursera »
Pluralsight Logo
BestExcel Formulas and Functions classes on PluralSight »
Udemy logo
Best Excel Formulas and Functions classes on Udemy »
linkedin
Best Excel Formulas and Functions classes on LinkedIn (Free trial) »

Classbaze Rating

Classbaze Grade®

9.6 / 10

CourseMarks Score® helps students to find the best classes. We aggregate 18 factors, including freshness, student feedback and content diversity.

Freshness

10.0 / 10
This course was last updated on 6/2022.

Course content can become outdated quite quickly. After analysing 71,530 courses, we found that the highest rated courses are updated every year. If a course has not been updated for more than 2 years, you should carefully evaluate the course before enrolling.

Popularity

We analyzed factors such as the rating (0.0/5) and the ratio between the number of reviews and the number of students, which is a great signal of student commitment.

New courses are hard to evaluate because there are no or just a few student ratings, but Student Feedback Score helps you find great courses even with fewer reviews.

Material

8.7 / 10
Video Score: 7.7 / 10
The course includes 54m video content. Courses with more videos usually have a higher average rating. We have found that the sweet spot is 16 hours of video, which is long enough to teach a topic comprehensively, but not overwhelming. Courses over 16 hours of video gets the maximum score.
Detail Score: 8.9 / 10

The top online course contains a detailed description of the course, what you will learn and also a detailed description about the instructor.

Extra Content Score: 9.5 / 10

Tests, exercises, articles and other resources help students to better understand and deepen their understanding of the topic.

This course contains:

0 article.
1 resources.
0 exercise.
0 test.

In this page

About this course

  The course will teach you this
  What you need to START the course
  Who can start this course?
General questions
  Coupons & Discounts
  Guarantees & money back
  Financial aid
Teacher
Classbaze hand picked recommendations

About the course

Course Description
This course will introduce you to what LookUp Functions are and how to use them. You will also learn the language Excel uses to better understand what you are doing when you assemble the function. Additional tools will be provided to help you engage with the program and make thing happen more quickly and more efficiently.
We will be covering
· VLookUp
· HLookUp
· XLookUp
· Index
· Match
· GetPivotData
· Choose
· Unique
· Sort
· SortBy
· Transpose
The IF and IFError functions are also included, though these are not LookUp functions, but they aid in the presentation of information in a more professional manner and we want to look as good as we can!
Additional tools are also provided to aid you in producing a more efficient product more quickly. Several keyboard shortcuts are included; AutoFill shortcuts and the use of the “F” keys, as well as a way to select large amounts of information in functions. These tools can be applied to other formulas and functions in the future.
This course is presented for Beginning to Intermediate level students. The length of the class is short enough to keep your attention but long enough to give you as much information as possible for your knowledge level. Please, make sure you download the document (Resource) we will be using in the class. You can work along with me or open it up later and work on it. Either way you want the document to further hone your Excel skills.
What are we waiting for? Let’s get started!

What can you learn from this course?

✓ Identify and utilize a dozen of the most popular lookup functions
✓ Understand the language used in functions
✓ Achieve an understanding and use of nested functions
✓ Identify Dynamic Array functions and how to use them

What you need to start the course?

• Previous exposure to personal computers and desktop applications is needed.
• A computer with Office 365 or Office 2021/2019/2016 is required for this course.

Who is this course is made for?

• Excel users who need to know how to find information in Excel in a professional manner.
• Students who need to become more familiar with this part of the program to produce better documents/spreadsheets.
• This course is a beginning/intermediate level course. If you are just getting started or need to improve upon your Excel skills, this course provides that.
• Those in the corporate world who are just beginning to utilize lookup functions in their job or require a refreshing of their Excel knowledge pool.

Are there coupons or discounts for Excel - LookUp Functions ? What is the current price?

The course costs $14.99. And currently there is a 80% discount on the original price of the course, which was $18. So you save $3 if you enroll the course now.

Will I be refunded if I'm not satisfied with the Excel - LookUp Functions course?

YES, Excel – LookUp Functions has a 30-day money back guarantee. The 30-day refund policy is designed to allow students to study without risk.

Are there any financial aid for this course?

Currently we could not find a scholarship for the Excel - LookUp Functions course, but there is a $3 discount from the original price ($18). So the current price is just $14.99.

Who will teach this course? Can I trust Kathleen Martens?

Kathleen Martens has created 1 courses that got — reviews which are generally positive. Kathleen Martens has taught — students and received a — average review out of — reviews. Depending on the information available, we think that Kathleen Martens is an instructor that you can trust.

Learn everything about

Kathleen Martens

Senior Corporate Instructor
After retiring from the corporate world, I was introduced into the world of corporate training and fell in love with it.  I have travelled all around the world teaching in front of live audiences.
When the webinar industry began to blossom, I found that it was a better way to reach more students and really embraced the industry. After almost 40 years in the corporate world, I found what I want to do for the rest of my life. I probably won’t retire again! Just kidding.
I began working in the 70’s before computers. Back then, we had typewriters. When computers entered the scene we didn’t have IT departments, so when I first hear that term, I got interested. I have been working in IT on and off ever since. I learned the programs and how they worked and ended teaching a lot of colleagues. My love of learning about the programs never ended. I also realized, that If I can give you my knowledge (paying it forward) to make your life a little easier than mine was, I have succeeded!
Kathleen Martens's full profile and courses »
Go to class »

9.6

Classbaze Grade®

10.0

Freshness

N/A

Popularity

8.7

Material

Detailed Analysis »

Excel in Excel learning what LookUp Functions are and how to use them!
Go to course »
Platform: Udemy
Price: check current price
Video: 54m
Language: English
Next start: On Demand

Classbaze recommendations for you

Learn to use tables and create powerful formulas in Excel. Learn SumIF

Tables and Formulas with Excel

Learn to use tables and create powerful formulas in Excel. Learn SumIF, Date, IF, VLOOKUP and Text formulas
4.4
★★★★★ 4.4/5
6,520 students
Go to class »