Instructor for this course
more

This course provides practical guidance to help you rapidly master a few fundamental functions of Excel. Upon completing the training, you will be able to use:

The IFERROR Function

This online Excel course explores the idea of error trapping, and demonstrates how to control formula results when an error is encountered. This Excel lesson introduces the IFERROR function, works through the syntax of the function, and provides several practical examples so you can work hands-on.

The IF Function

This online Excel course reviews the IF function. The lesson includes the syntax of the IF function, how to implement it into your workbooks, and explores the benefits.

List Comparisons

This online Excel course demonstrates how to perform list comparisons with Excel. What's a list comparison? Let's say you have two Excel sheets, and you have a question: does anything on this list appear on that list? Or, what appears on this list but not on that list? These are examples of list comparisons. This lessons applies Excel's lookup functions to perform list comparisons. Homework activities and Excel files are provided so you can work hands-on.

The ISERROR Function

This online Excel course explores the ISERROR function, and illustrates how to use it in conjunction with the IF function to control the output of formulas when errors are encountered. This combination of functions enables us to perform tasks that are not possible with the IFERROR function, and expands our ability to trap errors. Sample Excel files are provided in the homework activities so you can work hands-on.

Multicolumn List Comparisions with COUNTIFS

A multicolumn list comparison is a list comparison that uses two or more columns for the matching criteria. Typically, Excel users familiar with the VLOOKUP function will try to combine multiple columns into a single lookup column, often using concatenation, in order to perform the list comparison. However, this step of combining columns is not necessary, and in recurring use workbooks our goal is to eliminate steps. This online Excel class explores the COUNTIFS function. The Excel lesson walks through the function's syntax, illustrates how to use it to perform multicolumn list comparisons, and provides several practical examples so you can work hands-on.

Indentation

How do you create indented report labels? Do you tab over to a new column? Do you pad the report label with two spaces? Both of these common approaches impede our productivity. This online Excel class discusses this minor detail, and demonstrates how the way we indent can have a major impact on our efficiency. This Excel lesson provides several practical examples so you can work hands-on.

Perform Lookups with SUMIFS

What is your favorite lookup function? Excel has many lookup functions, including VLOOKUP, INDEX, and MATCH. However, when we consider using SUMIFS to perform lookups, we are able to avoid many limitations of traditional lookup functions. This online Excel course demonstrates how to apply our dear friend SUMIFS to the task of lookups.

Determine the Last Day of the Month with EOMONTH

Date driven workbooks are common for accountants. This online Excel course discusses one of the most important date functions...EOMONTH. This Excel lesson reviews the function's syntax, demonstrates how to integrate it into your workbooks, and provides a sample Excel file so you can practice hands-on.

Date Parts - MONTH and YEAR

Date driven workbooks are common for accountants, and thus, it is important to be familiar with key date functions. We can pull the date parts out of a date, and this online Excel class explores the MONTH, YEAR, and DAY functions. This Excel lesson reviews the syntax and walks through several practical examples. The sample Excel file is provided so you can work hands-on.

Course Series

This course is included in the following series:

5 CoursesJeff Lenning's Excellence in Excel Training

  1. Excel Shortcuts Training: 5 Top Productivity Boosting Shortcuts
  2. Excel Training: Skills for Better Workbook Design
  3. Excel Training: Boosting Proficiency with Selected Shortcuts (PC version)
  4. Excel Training: Mastering Fundamental Functions - IFERROR, IF, List Comparisons and More
  5. Excel Training: Tips for Improving Data Validation, Error Checking, Reporting and Other Performance Obstructions

Learning Objectives

  • Be able to trap errors with IFERROR function
  • Demonstrate multiple uses for the IF function
  • Enact multi-column comparisons with COUNTIFS
  • Be able to create indented report labels

Included In Certifications

This course is included in the following Expert Certifications:

9 CoursesCertified Expert in Excel for Professional Applications

  1. Excel Shortcuts Training: 5 Top Productivity Boosting Shortcuts
  2. Excel Training: Skills for Better Workbook Design
  3. Excel Training: Boosting Proficiency with Selected Shortcuts (PC version)
  4. Excel Training: Mastering Fundamental Functions - IFERROR, IF, List Comparisons and More
  5. Excel Training: Tips for Improving Data Validation, Error Checking, Reporting and Other Performance Obstructions
  6. PivotTable Essentials
  7. How to Use PivotTables instead of Formula-Based Reports
  8. PivotTable Conclusion and External Data Introduction
  9. Using PivotTables and PivotCharts to Prepare External Data

111 Reviews (276 ratings)Reviews

5
Anonymous Author
An excellent introduction course into trapping errors and using combined functions along with using date functions. I will be able to use these combined functions in complicated bank reconciliations and date functions in prepaid worksheets and many others. Explained well with superb materials. Best excel teacher thus far.
5
Anonymous Author
Material was clearly presented and the examples were easy to follow. The speaker was very articulate and did well to ensure that the material was thoroughly reviewed before moving onto the next topic.
4
Anonymous Author
I'd really like to explore more on excel so this is really a great help for me. Just noticed that the audio playing took so long that made me nap waiting for the next picture/graphics to come out.
4
Anonymous Author
Excellent overview of these functions with easy to follow examples. I was not familiar with several of the functions and will be able to incorporate them into some of my worksheets.
5
Member's Profile
This course was great. It showed how to use some functions that I didn't consider very important and also some different uses for functions that I hadn't thought of.
5
Anonymous Author
Easy to follow and the excel examples illustrate the functions well. However the exam for this course did ask questions about formulas taught in a previous course.
5
Member's Profile
Mr. Lenning is an excellent instructor. He has a lot of valuable tricks and techniques to make the student's use of Excel more effective and efficient.
5
Member's Profile
Great course to learn all the functions. Worksheets are extremely helpful to "ingrain" the formulas so they aren't forgotten when you next need them.
5
Anonymous Author
Entire series is fantastic. No matter how much I have used these functions, I always learn something new in these courses. Great use of one's time.
4
Anonymous Author
Had a hard time understanding the error functions. Seemed backwards to how I think and very hard to conceptualize. More examples would have helped.
4
Anonymous Author
The speaker is great and provided a very clear example that is easy to follow and understand. This is very useful to anybody that deals with excel.
4
Member's Profile
Very helpful and useful tools, specifically the benefit of SUMIFS versus VLOOKUP. And, understanding what the date serial numbers were.
4
Anonymous Author
It would help to know what formulas are assumed known before taking this course. It just lists what formulas are being taught.
5
Member's Profile
Useful material for any Excel user -- from beginners to veterans. Well presented with good worksheet examples and exercises.
5
Anonymous Author
This course is really helpful with my daily job. It will increase the efficiency when I compare different sets of data.
4
Member's Profile
quick and informative Surprised by the match formula question, since the course did not cover the Match formula
4
Member's Profile
I thought the instructor could spend less time on the non functional portions and more time on the "homework".
4
Anonymous Author
Pretty basic stuff, but well done course that would be good for those who don't have much experience with Excel
5
Member's Profile
Clear. Need to remind shortcuts in demonstrations, such as which key is being pressed for locking down cells.
4
Member's Profile
I liked how the professor showed multiple examples of how to use the formulas including more complex uses.
5
Anonymous Author
Very informative and practical. I can put the formulae into my everyday use. Thank you very much!
5
Member's Profile
Even though I know how to use most of these functions, it opened my eyes to different approaches.
5
Member's Profile
This course had some very helpful tips for analyzing data sets and comparing multiple data sets.
5
Anonymous Author
Which question on the final exam was wrong? Hard to learn if you can't see the test results!
4
Anonymous Author
This course presented useful information in a concise manner. The examples were very helpful.
5
Member's Profile
I am good with Excel - but still learned some things I didn't know. It was worth my time.
5
Member's Profile
The detailed explanation followed by an example helps to understand and learn the material.
5
Anonymous Author
As usual, these Excel University courses are excellent. Very good tips and well presented.
4
Anonymous Author
Another great course by this instructor. Good tips even for the experienced excel user.
4
Member's Profile
Well presented, recommended.Well presented, recommended.Well presented, recommended.
4
Anonymous Author
Easy to follow the examples presented. Useful functions for comparing information.
5
Member's Profile
Love Jeff Lenning's instruction method, best excel teacher I have ever experienced!
4
Anonymous Author
Great instructor. I have enjoyed all of the courses I have taken that he teaches.
Anonymous Author
Spent too much time on simple functions like EOMonth (the worst function ever).
5
Member's Profile
Nice demonstration of functions to use for list comparisons and related topics
3
Anonymous Author
Overall not bad, a lot of little lessons versus one long extended discussion.
5
Member's Profile
A number of helpful ideas and I've been using Excel at a high level forever.
3
Member's Profile
Very basic for me. I was a comp sci professor and I taught 5 excel course.
5
Member's Profile
Fantastic new ideas. I thought I was an excel expert but apparently not!
5
Member's Profile
material to reivew more than once to understand the logic is interesting
3
Member's Profile
A lot of info, which would probably take several times to understand.
5
Member's Profile
A lot of very useful day to day excel formulas to improve efficiency
5
Member's Profile
Very helpful tips - had never heard of the iserror function before.
5
Anonymous Author
I like that there are training worksheets included in this course.
5
Anonymous Author
Great course if you don't know the functions listed in the synopsis
5
Member's Profile
Good review of some very useful but not famous tips and functions.
5
Anonymous Author
Great functions. Perfect presentation. I'm a clever person now :-)
5
Member's Profile
Very helpful. I like the side-by-side comparisons of functions.
4
Member's Profile
Nice tips and tricks. Great instructor. Very useful tools.
5
Member's Profile
Very concise presentation and very useful worksheets. thanks
4
Anonymous Author
I liked the quick examples that were easy to understand.
5
Member's Profile
i like the course we need more like this including counta
5
Anonymous Author
Course contains a lot of good information. Very helpful.
4
Anonymous Author
This was a good overview of several useful Excel tools.
5
Member's Profile
Great examples and ideas on how to use Excel functions
5
Member's Profile
Loved a nice comparison of vlookup with sum ifs.
4
Anonymous Author
good explanations of how to use advanced features
4
Anonymous Author
Great course. Makes you think. Very well taught.
4
Anonymous Author
I enjoyed the course. Great learning experience.
5
Anonymous Author
Again another excellent course by the author.
4
Anonymous Author
It is a good refreshment course for beginners
Anonymous Author
Little too beginner. Wanted more in depth.
5
Anonymous Author
Jeff - is a good resource for excel issues.
5
Member's Profile
Covered material which I can put to use now
5
Anonymous Author
Good to go back and review these formulas.
5
Member's Profile
Best lesson to learn and understand excel.
4
Member's Profile
I found the worksheets provided helpful.
5
Anonymous Author
Great review for very useful functions
5
Member's Profile
The course is so easy to understand.
5
Member's Profile
Very helpful and easy to understand.
5
Member's Profile
I love Excel, and all Excel courses.
5
Anonymous Author
Learned a lot on using IF functions
5
Anonymous Author
Information is presented very well.
5
Member's Profile
Nice! Excited for the next course.
5
Member's Profile
Excellent Course. Advance excel.
5
Member's Profile
I like to the class very much.
5
Member's Profile
Good overview of basic funtions
4
Anonymous Author
The course had some great tips.
5
Member's Profile
Love this course. Thank you.
4
Anonymous Author
interesting course material
5
Member's Profile
Good probing presentation
5
Member's Profile
Very professionally done!
5
Member's Profile
very helpful information.
5
Anonymous Author
Good class, very useful
5
Anonymous Author
Interactive questions.
3
Anonymous Author
It's a fair review....
4
Anonymous Author
Lots of information.
Member's Profile
Great review for me
4
Anonymous Author
It was a very good
5
Anonymous Author
Exselent material!
4
Anonymous Author
Excellent course.
5
Anonymous Author
Another good one!
4
Anonymous Author
Quite informative
5
Anonymous Author
Great explanation
5
Member's Profile
well informative
3
Anonymous Author
Nice refresher
5
Anonymous Author
Helpful hints
5
Member's Profile
Great tools.
5
Member's Profile
Good course.
5
Anonymous Author
great course
5
Anonymous Author
Great course
5
Member's Profile
Good Course
5
Member's Profile
interesting
4
Member's Profile
Nice course
Member's Profile
Good course
4
Anonymous Author
very clear
5
Member's Profile
Very good.
5
Member's Profile
Good tips
4
Member's Profile
Helpful.
Member's Profile
Good
5
Member's Profile
Good

Prerequisites

Course Complexity: Intermediate

No Advanced Preparation or Prerequisites are needed for this course. However, it is recommended to take the other courses in the series prior to completing this one.

Education Provider Information

Company:
Illumeo, Inc., 75 East Santa Clara St., Suite 1215, San Jose, CA 95113
Contact:
For more information regarding this course, including complaint and cancellation policies, please contact our offices at (408) 400- 3993 or send an e-mail to .
Course Syllabus
INTRODUCTION AND OVERVIEW
Lessons
  4:15Trap Errors with IFERROR
  3:32The IF Function
  3:30List Comparisons
  7:04The ISERROR Function
  6:46Multicolumn List Comparisons with COUNTIFS
  6:15Indentation
  8:02Perform Lookups with SUMIFS
  7:50Determine the Last Day of the Month with EOMONTH
  2:40Date Parts - MONTH and YEAR
CONTINUOUS PLAY
  49:56Excel Training: Mastering Fundamental Functions - IFERROR, IF, List Comparisons and more
SUPPORTING MATERIALS
  ZIP FILEWorksheets
  PDFMastering Fundamental Functions Glossary/Index
REVIEW & TEST
  quizReview Questions
 examFinal Exam