Instructor for this course
more
Enrolled:
467
Duration: 1 Hour
Level: Intermediate
How To Access This Course:

Subscription

$99 Instant Access to Course Library

Expert Certifications

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 Collections

This course is included in the following Course Collections:

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

80 Reviews (215 ratings)Reviews

5
Member's Profile
Love this course. Thank you.
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
The detailed explanation followed by an example helps to understand and learn the material.
5
Member's Profile
very helpful information.
5
Member's Profile
i like the course we need more like this including counta
5
Anonymous Author
great course
4
Anonymous Author
Lots of information.
4
Anonymous Author
I enjoyed the course. Great learning experience.
3
Member's Profile
A lot of info, which would probably take several times to understand.
4
Anonymous Author
Great course. Makes you think. Very well taught.
5
Member's Profile
Good
5
Member's Profile
Very professionally done!
Member's Profile
Great review for me
5
Member's Profile
Good course.
4
Anonymous Author
It is a good refreshment course for beginners
5
Anonymous Author
Good to go back and review these formulas.
5
Member's Profile
Very concise presentation and very useful worksheets. thanks
5
Member's Profile
Very good.
5
Member's Profile
Good overview of basic funtions
5
Anonymous Author
Great functions. Perfect presentation. I'm a clever person now :-)
5
Member's Profile
Good review of some very useful but not famous tips and functions.
5
Member's Profile
A number of helpful ideas and I've been using Excel at a high level forever.
4
Anonymous Author
good explanations of how to use advanced features
4
Anonymous Author
Another great course by this instructor. Good tips even for the experienced excel user.
5
Member's Profile
The course is so easy to understand.
5
Anonymous Author
Another good one!
4
Anonymous Author
very clear
5
Member's Profile
well informative
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
Loved a nice comparison of vlookup with sum ifs.
4
Member's Profile
quick and informative Surprised by the match formula question, since the course did not cover the Match formula
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.
5
Member's Profile
Good probing presentation
3
Member's Profile
Good
5
Member's Profile
Very helpful and easy to understand.
5
Member's Profile
Fantastic new ideas. I thought I was an excel expert but apparently not!
4
Anonymous Author
Easy to follow the examples presented. Useful functions for comparing information.
4
Anonymous Author
It was a very good
4
Member's Profile
I liked how the professor showed multiple examples of how to use the formulas including more complex uses.
3
Anonymous Author
Spent too much time on simple functions like EOMonth (the worst function ever).
4
Member's Profile
Nice course
4
Anonymous Author
This course presented useful information in a concise manner. The examples were very helpful.
4
Member's Profile
I found the worksheets provided helpful.
5
Anonymous Author
As usual, these Excel University courses are excellent. Very good tips and well presented.
3
Anonymous Author
Little too beginner. Wanted more in depth.
5
Anonymous Author
Good class, very useful
5
Member's Profile
A lot of very useful day to day excel formulas to improve efficiency
5
Member's Profile
Very helpful. I like the side-by-side comparisons of functions.
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.
5
Anonymous Author
Great course if you don't know the functions listed in the synopsis
5
Member's Profile
Great tools.
5
Member's Profile
Good tips
5
Member's Profile
interesting
5
Anonymous Author
Course contains a lot of good information. Very helpful.
5
Member's Profile
Good Course
5
Member's Profile
Good course
5
Anonymous Author
Great review for very useful functions
5
Anonymous Author
Very informative and practical. I can put the formulae into my everyday use. Thank you very much!
4
Anonymous Author
Great instructor. I have enjoyed all of the courses I have taken that he teaches.
4
Anonymous Author
I liked the quick examples that were easy to understand.
5
Anonymous Author
This course is really helpful with my daily job. It will increase the efficiency when I compare different sets of data.
5
Member's Profile
Very helpful tips - had never heard of the iserror function before.
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
Anonymous Author
Helpful hints
3
Member's Profile
Very basic for me. I was a comp sci professor and I taught 5 excel course.
4
Anonymous Author
Pretty basic stuff, but well done course that would be good for those who don't have much experience with Excel
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
This was a good overview of several useful Excel tools.
5
Member's Profile
material to reivew more than once to understand the logic is interesting
5
Anonymous Author
I like that there are training worksheets included in this course.
5
Member's Profile
Useful material for any Excel user -- from beginners to veterans. Well presented with good worksheet examples and exercises.
4
Member's Profile
I thought the instructor could spend less time on the non functional portions and more time on the "homework".
5
Member's Profile
I like to the class very much.
5
Anonymous Author
Jeff - is a good resource for excel issues.
4
Anonymous Author
Excellent course.
5
Member's Profile
Nice! Excited for the next course.
5
Anonymous Author
Which question on the final exam was wrong? Hard to learn if you can't see the test results!
5
Member's Profile
Clear. Need to remind shortcuts in demonstrations, such as which key is being pressed for locking down cells.
3
Anonymous Author
Nice refresher
5
Member's Profile
I am good with Excel - but still learned some things I didn't know. It was worth my time.

Prerequisites

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 ext. 106, 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
SUPPORTING MATERIALS
  ZIP FILEWorksheets
  PDFMastering Fundamental Functions Glossary/Index
REVIEW & TEST
  quizReview Questions
 examFinal Exam