Course Details
Course

Excel Training: Mastering Fundamental Functions - IFERROR, IF, List Comparisons and More 1 CPE


Course Duration: 1 Hours
Course Rating:
Course Enrollments: 1028 Enrolled
Mode of Delivery: On-Demand
Course Level: Basic
Study Area: Computer Software & Applications

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.

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.

Learning Objective
  • 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

Last updated/reviewed: July 17, 2025

(371) Reviews

(147 rating)
User Image
katherine.kirkup

Good presentation with clear examples of the ethics of team leadership. Real life examples were used which demonstrated the principles of ethical leadership. Found the course easy to follow and understand.

User Image
steven.lawrence

The presenter keeps a quick pace for this interesting subject and has a bullet point list on screen to make it easy to go back and find any part of the presentation.

User Image
karen.schrader

Good refresher course that could benefit all from goal setting to delegation.

User Image
robert.burnett

Jeff's technique is very well done and easy to follow. It is a great review and provides good examples that can be used day-to-day. Great Job!

User Image
kenneth.hopkins_1

This was a good review of the Control Environment. It provided great explanations and examples.

User Image
gene.cenotto

The course did a nice job and explained important, relevant information in a manageable and easy-to- digest manner.

User Image
xinlu.wen

The examples would be better if written out. It is hard to catch by just listening.

User Image
karn.carlozzi

there was an extensive amount of material to learn and understand. Maybe do more explanations and less amount of concepts.

User Image
aminah.bey

This was an excellent course and I felt like it provided a guidebook for necessary courses of action and reminders for those trying to ascend in his/her careers.

User Image
kerry.crooks

Thank you, Jeff for another excellent course. I will be buying your books for easy reference and practice. You make confusing concepts easy to understand. Well done!

User Image
ndilahomba

Excellent course i learned today about the best Wild, then you.com, and all other claude. I can see is a new world we are in and happy to be part of this transformational Journey. This course opened my eyes

User Image
allison.tomko

Great overview on ASC 606 and the transition into following the guidance. Its always good to have a refresher to ensure i have a proper understanding.

User Image
sandra.heelan

Interesting course with great Cases to add understanding. Great presentation.

User Image
arvydas.tenenis

Ethical issues are sometimes downrated, what is not correct. Great presentation.

User Image
hope.arthur

I really enjoyed this course. I think the length was appropriate, appreciated the variety of cases, and the instructor did a great job.

User Image
isabella.fung

Jeff did a great job in doing the presentation in a very interesting way. The materials are good and very easy to understand.

User Image
nandi.kyawmin

Really like the slides and files but the examples are repetitive. Wish to have more current scenario examples if possible. But the instructor is very engaging for sure. Thank you.

User Image
holly.runner

Good information in the course, but could use some updating.

User Image
wendy.jones

This course had surprising tips. It is always good to be reminded what excel can do and surprising when I learn something I didn't know or get an idea I didn't think about. Ringstrom is always great at showing how to create efficiencies with Excel.

User Image
chris.hole

It's hard to distill the entire history of ethical thought down into a 2 hour business course, but I give credit to the instructor for making the effort.

User Image
dominick.pariano

What a fantastic course! This course was chock full of great tips and general ideas. Definitely a ton of "a ha" kind of moments and very helpful for those of us at the middle management level who would like to try to convince the Executive level that moving even at least to data mining would be helpful. Also, really appreciated the presenter's use of helpful visuals as well.

User Image
jared.gelb

Great examples and content. High quality lecture that made following and applying the concepts easier.

User Image
nicholas.wilhelm

The excitement of the content combined with the enthusiasm and insight of Mr. Wasny make this course, along with those he presents on AI, the most inspiring and motivational I've experienced on this platform.

User Image
showalcd

Virginia ethics course, it's required for CPAs and this format works

User Image
thomas.hamill

Supplementary was a great summarization of all the items learned and then to see it in action was a great learning experience

User Image
jeffrey.torrence

Extremely thorough presentation encompassed in the gradual addition of detail to each slide.

User Image
caitlyn.boyd

The information provided was great for beginners, but some of the methods seem to be outdated. Specifically as it relates to vlookups. I think details on the xlookup function would be a game changer for some! Also a further analysis of using index and match together.

User Image
chloe.lee

good thank you so much, it was helpful. really helpful.

User Image
mark.eastman

The material is dense and detailed. Be prepared to read and reread to fully comprehend.

User Image
judy.kelley

Very informative but Mr. Lennig went a bit fast. Would like to take individual courses on the IF and IFerror functions.

User Image
jennifer.bollinger

Great class to meet state-required ethics class. Information presented was easy to understand with good examples.

User Image
ramakrishna.nalluri

Detailed instruction by author. Refresher course still if you know Excel.

User Image
nigel.fenty

This course had very good examples and case studies. Overall good overview and thought provoking.

User Image
paul.francom

I learned a lot, but the test questions were out in left field and there are no slides.

User Image
lindsay.elizondo

Love Blair's webinars! Definitely wish there were more available on Illumeo. He is one of my facotire presenters!

User Image
craig.farabaugh

Good overview of the subject material. Covered all the major points.

User Image
robert.workman

Honestly, I got more out of watching Ted Talks and YouTube videos ...

User Image
kim.johnson

Well thought-out content and presentation. Periodic mis-spell and various fonts made it seem less professional and the course was prepared on the fly with heavy Covid-19/Zoom fatigue :)

User Image
randy.leduc

This was a great course to introduce me to features of excel that I have never used to give me a great understanding of how they might be used in practical everyday applications of Excel.

User Image
judy.silverman

Excellent refresher course and reference for future use. Instructor and materials are also excellent.

User Image
mwinncpa85

I especially appreciated the David Foster Wallace commencement speech at the end.

User Image
carmen_.reyes-cruz

I like the trick to think of at least 3 options or choices in deciding on solutions to a problem.

User Image
kaylah.edwards

This course was excellent. I learned a great deal. I appreciate courses such as this because it will help me grow within my career.

User Image
austin.crowe

David did good job explaining the basic uses of a Pivot Table and breaking things down in steps to make the process easy to understand. I'll use this knowledge in the future in creating Pivot Tables.

User Image
chad.bailey

Materials need some improvement. They are just bullet points without any context. That's good for normal presentations, but won't be useful if trying to use as a guide later on when the information is not fresh in our minds.

User Image
katie.murrey

Overall, a good course to learn about multiple lookup equations.

User Image
kamran.jafri

On often overlooked topic for those in the non-IT/cybersecurity sector. Great overview on important topics on handling and preventing security threats.

User Image
linda.jacobs

Presenter is easy to listen to but, the course needs real world examples - not just reading tax brackets.

User Image
allan.morris

Terrific insights and very applicable. I pulled out my notebook for this one.

User Image
joseph.ennis

Course was relevant and a good road map to live all aspects of your life.

User Image
shankar.sundaram

Learnt a few things I did not know about pivot tables

User Image
tsimkiss

Direct, easy to understand slides and notes make this a valuable course.

User Image
angela.schultz

Having 3 different people jumping back and forth caused a lot of confusion and the material seemed to have gaps. Specifically betwen slide 22 & 23. At the beginning of slide 23 she says thank you for all of that insight....what insight? I didn't hear any insight from slide 22 as it seemed they skipped over half of that slide. The presentation was very choppy. I ended up stopping the presentation and just thumbing through the slides to get a passing exam. There are other really great courses on AI within Illumeo to explore

User Image
eblyar

The course provides a great overview of fraud, impacts to the Company, and ways to mitigate that risk and how Internal audit can aid and assist in this process.

User Image
sandi.mcdonald

Too much repetition and not enough instruction on how outlook works.

User Image
ermendoza_12

This course provides some great information. The topics covered are very helpful as well.

User Image
nina.sirak

This course contains a lot useful information and tools that are easily implemented! Examples were easy to follow.

User Image
sue.miller

Super clear instructions with excellent examples provided to work through.

User Image
david.hinojosa

Great introduction to macros. Mr. Ringstrom provides several great examples where macros can provide work efficiencies.

User Image
ana.shestakova

It was a lot to follow and kind of hard to digest all at once. I understand it's a complicated subject, but I'm still not sure I entirely understand how to account for leases.

User Image
jenningsr

Excellent demonstration of functions. Really expanded ways in which i can increase efficiency.

User Image
marsy.bassari

It was very hard to learn. It was like reading the ASC 718. I was hoping to get some examples or some other way of teaching.

User Image
dlynch

If you're new to functions you might need to review this course a couple of times to understand and remember the different functions.

User Image
ifadil

its a great course with full of information! i find it useful for me to detect a fraud next time

User Image
bette.shepherd

Good discussion of potential pitfalls to watch out for when working with NFP

User Image
shannon.green

This is, in no way, a 1.5 hour course if you are to attempt to "Learn by Doing" as instructed on slide 11.

User Image
tom.grimmig

This course was very informative and gives interesting perspectives for anyone who pays taxes.

User Image
mark.murdaugh

The supporting material slides pdf differs significantly from the video presentation. It looks like the video was updated and the slides were not updated to match the video.

User Image
hillary.broussard

Great information in this course. It was easy to follow along.

User Image
murch.ewings

I like the overarching subject matter of the course and especially the sections on SWOT

User Image
rachael

Good material and overview of SAAS metrics. Sound was a little low could be increased but otherwise good

User Image
julie.hammeras

I really had a hard time with some of the exam questions - they seemed ambiguous and unclear.

User Image
samantha.lemp

Thank you for including the example questions, I found them very helpful in understanding the course content.

User Image
corey.gibb

This was an informative course but I had trouble following along because I couldn't find all the worksheets in the Supporting Materials

User Image
julie.schmidt_1

This is one of the worst classes I have taken. The lecture is obviously read off a script and not well done. The content of the slides is not in a great format. Finally the review and final exam have a bunch of questions that don't even make sense. Skip this.

User Image
nick.wright

Great lesson. There are many Excel features that are not known by the vast majority of users. Illumeo does a good job of providing content to help bring those to light.

User Image
nealleblanc

Great course to go over how to manage cash flow and important aspects to consider for any level.

User Image
dlugviel

A good follow up to part one. Digs deeper into the actual code aspect of VBA. Very informative!

User Image
max.davis

Very good test, I am now SUPER good at ethics need more words to hit 50

User Image
erica.claudin

i thought this was a solid course and i liked the real-world examples because it made the topic more interesting and tangible.

User Image
jericho.hallimore

I appreciate some of the functions that have been used in the past or can be used by combining functions to an extent that it helps understanding the new functions. But in this presentation there seemed to be so much of it became confusing or a bit of information overload.

User Image
samuel.funt

This course provided an excellent overview of cyber security. I would recommend this course for anyone, especially those newer to the field of cybersecurity.

User Image
nroberts

I liked it. Good basis for an accounting close. It's nice to have a refresher every once in awhile.

User Image
richard.thompson

Excellent primer for internal control framework and necessity. Good use of examples in presentation.

User Image
yim_fong.so

Amazing to learn the competition between Vlookup and SUMIFS. The SUMIFS returns on both value and differ data type. It is great to use on daily payment report.

User Image
doug.norfleet

I liked the text format of this course! Will use it again in the future.

User Image
pamela.heflin

This course would be informative for someone right out of college or someone that has been in the workforce for a number of years. It reinforces what is acceptable today and not what was acceptable in time past.

User Image
jatin.talreja

I liked the way the trainer presented the topic to clarify the concepts in the easiest way.

User Image
rachael_.ciraolo

Very thorough, the workbook goes along quite well.

User Image
lema.rader

I really liked the course but the background music was too loud.

User Image
dominic.villanueva

Very simple and effective. Learned so much that I took for granted. Your approach in using simple examples to focus on the feature and function is very practical.

User Image
mkumar

I like training material and teaching style. Name reference surprised me. Yes i will try to complete all of training.

User Image
derek.ettinger

Excellent overview of the various financial statements. Thought the section on financial ratios was a great addition.

User Image
richard.waid

Excellent discussion and presentation of ethics for organizations!

User Image
tammy.allman

Great course - I highly recommend listening to the "This is Water" video. I found a 23 min version on you tube... wrapped this course up nicely!

User Image
keith.e.baker

Might be too much information in once course, but it is great stuff.

User Image
eylene.wachowiak

Really great content, that is taught efficiently without consuming excessive time. The only reason I gave less than 5 stars on this one is, I do not remember covering the match function in the presentation or worksheets (unless I missed it, then I retract this comment), but there was a question on the exam about it.

User Image
edward.muller

Extremely polished presentation and the the detailed examples help drive home how each function works.

User Image
vickie.cockrum

In total, it was very informative & I appreciated the detailed explanations. However I could have done without the instructors introduction of all of his background. Also the summary on how this course compares to similar courses was not needed.

User Image
emilie.mccutcheon

Helpful information about automating reports in Excel. Recommend.

User Image
william.barnes

Great deal of practical solutions to enhancing executive presence. Solid examples by the instructors.

User Image
darla.love

The quiz had typos and was very confusing. It would be helpful proofread and make sure the question makes since.

User Image
tonya.muszall

This course was great. It talked about the various types of culture, employee behaviors, how to recognize when culture needs a change, and how to implement it. Overall, I would recommend this course!

User Image
lisa.vandervelden

Well prepared and laid out. Flowed well from topic to topic.

User Image
miriam.barrera

Good refresher course for the CA regulatory review

User Image
erica.carper

The presentation was extremely well-ordered and seamlessly moved through teaching the facts then applying with examples of each approach.

User Image
mrjensen

The examples used by the course instructor were very helpful in understanding the material presented.

User Image
destiny.pinyan

A good basic review of journal entries and accruals!

User Image
sarah.feuerpeil

great course, good to follow, great and effective instructor

User Image
beverly.spath

Information presented will be very useful! It was presented in an easy to follow format. I learned several short-cuts to convert emails to tasks to calendar items. The tips provided relative to using the Notes section in Outlook will also be very helpful There is no doubt that I will be able to use the information provided in this course to better manage my time and and track my tasks. After taking this course, I am definitely going to follow it up with his course on Email management.

User Image
andrew.clarkson

This was a very helpful course. I appreciated the conciseness and clarity of the explanations. It was beneficial to see the T-accounts and Journal Entries written out. That helps solidify in my mind what is going on in the accounting process.

User Image
steven.ung

The topics were discussed with excellent examples and concisely.

User Image
brian.kathol

Well presented and well explained. And he made it interesting as well!

User Image
mark.jenkins_1

Great Course. Very Motivating. Makes you think about what kind of leader you want to be.

User Image
sean.lee_1

Good and Mandatory Ethics course. With recent changes, it's good to stay informed!!!!!!!

User Image
larisa.demling

This was a very detailed course and a good refresher of the responsibilities and types of controls businesses should have.

User Image
hong.zhu

The best ethics course that I have taken. Thank you!

User Image
staci.mcbride

Good overview of various ratios that help in the financial statement analysis

User Image
stephen.pruski

Good course it has some useful tips. My only issue is this course seems to be outdated (2014?) for the new functions of Outlook

User Image
trina.bremerkamp

Good overview of mentor-mentee programs, benefits and relationships.

User Image
jodi.massa

Excellent - I picked up many tips on IF(ISNA, data valuation lists, match, index and choose.

User Image
frank.gonzalez

Excellent overview of covered material. Examples and support material were helpful in understanding each excel tip.

User Image
sebastien.simard

Dynamic teacher. Lot of new features to use on day to day!

User Image
dustin.stuart

I am somebody that hopes and believes that crypto will be the future of payments and investing. The one thing I do not like is how scared people get when you mention the word crypto. People are also very misinformed a lot of times or just do not care to be informed. So my only critique would be the fact that the risks of cryptocurrencies are comparable to investing in stocks or holding cash in a bank account. Illegal acts have been happening since the dawn of man and cryptocurrency has a fraction of wrongdoing on its RAP sheet compared to cash and other financial tools. Just trying to make crypto seem less scary. Change is good.

User Image
kelly.sanders

Great general overview of the new standard. Very informative.

User Image
kerry.plemmons

Very good information given in this course, and given in a way that was very informative, not too wordy, and easy to understand.

User Image
agnes.gonzalez-dalmau

- - - - - -

User Image
bev.stenger

Two exam questions were super confusing. Not well written. #2 and #4, other than that, was an excellent course

User Image
karen.fischer

I wish I had taken a course like this 40 years ago! I really learned most of this through experience and a passion for knowledge, but it would have helped to have this road map at the start of my career. I have learned that self-confidence gained from competence, honesty, and compassion for others helps you be a leader. Always striving to do the best for the benefit of everyone will bring you success.

User Image
seth.fankhauser

The course offers great suggestions for how a 1:1 meeting can contribute to career building success.

User Image
rhaug27

Helpful reminders to remain proficient with excel and stay away from more manual bad habits.

User Image
jedwards

I loved the fact there was no instructor and I was able to work thru the material at my own pace with the excellent instructions and tools provided.

User Image
erin.carle

I liked the different ways to look at things throughout our life daily.

User Image
kingsley.onyekwelu

Barry Zalma is very dull and boring. He even seems un-interested in the lecture he is giving.

User Image
jie.zhang

A good financial leadership course that covers a lot of useful information and was based on experience that is relatable and relevant to many organizations.

User Image
tara.boring

This course could have been really cool, but I couldn't follow the Excel directions....

User Image
paul.tansley

good course

User Image
kevin_falini

I appreciate all of the practice. Lot's of problems help to develop proficiency at speed.

User Image
daniel.contreras

Similar to David's other courses, instruction was clear and concise. Not only will this help build a solid budget, but a few neat shortcuts and formulas are presented as well.

User Image
claudia_jones

High level overview which is good, but I would appreciate accounting courses that were more detail. Illumeo appears to be lacking in government accounting courses.

User Image
micheal.oconnor

Good review course. This was a solid refresher for something I have been away from for some time.

User Image
andrew.smith

now that I WFH full time because of the pandemic, this was SO helpful!

User Image
qian.zhong

Generally good advices and I hope the course can add more real life examples to support the theoretical system.

User Image
shirley.wong

Great instructor. Very happy to take the class and learned a lot

User Image
danielle.dell

The information is spoking in the presentation but not clearly documented so found the test hard to determine

User Image
sergey.bulychev

Training audit tests on specific examples will always help you learn the material more accurately.

User Image
mike.spanton

This is one of the most useful courses I have ever taken. Thank you for the helpful fixes to so many of the common problems we face in managing our inboxes.

User Image
smclaughlin_1

Having been away from Excel for a while I remembered how to use VLOOKUP but couldn't recall how to use INDEX/MATCH. The exercises really helped me to regain that knowhow.

User Image
grif.glenn

Introduction to basic excel features. Course topics explained by working through numerous examples. Time estimate on the low side. Very good course.

User Image
jholiday

This instructor courses are always very helpful and are well thought out. I always look for her courses on-line as I always learn something new and interesting from her classes.

User Image
eric.cox

Recommended for anyone who needs a refresher on auditing or anyone who is about to go through an audit!

User Image
ji.tan

Very helpful information for people in the accounting profession.

User Image
ray.barbic_2

This was a good and basic introduction to the business process mapping.

User Image
stephanie.doenges

Good written material and fair questions on the exam.

User Image
edward.restelli

This course is 6 stars out of 5 - the best and most thought provoking I have taken on Illumeo. I really enjoyed the links to psychological literature, and the action-oriented strategies and recommendations to improve these Executive traits. Take this course!

User Image
james.chang_1

Good review of the role of a forensic accountant in contrast to other types of accounting.

User Image
samuel.narotsky

Very useful as a practical guide and as a historical perspective (I was very involved with SOX work from the beginning until 2011, when my employer got bought by a European company).

User Image
kevin_.vanloo

Excellent way of presenting the course in an effective way

User Image
matt.madison

I learned a ton in this class. It was thorough and entertaining.

User Image
yelena.rye-kirova

I really enjoyed this course, examples were practical and realistic.

User Image
miyoung.cogswell

Content was fine but his frequent typo during the lecture was distracting.

User Image
donald.petter

David documents his points very thoroughly. His notes can be used for reference later to reinforce his teaching. I highly recommend him as an instructor.

User Image
numeriano_.de_la_cruz_jr

The course is great for refreshing the skills in Pivot Tables. It is very informative and detailed. The presenter discusses the topic in a step-by-step procedure making it very clear and easy to understand.

User Image
margaret.mueller

This course provides a good overview of factors to consider before joining a non-profit Board. I found the instructor's accent a bit thick, so I had to go back on a couple of slides to figure out exactly what he said.

User Image
rhonda.unthank

Excellent course lead by an effective instructor. Great content.

User Image
y_avazov

very good high level information for lending business details

User Image
anton.chornyi

Very cool course! Many really useful things have been explained.

User Image
leslie.harding-ide

The instructor makes the material easy to understand and remember.

User Image
charles.howery

extremely high level. needs more examples of what can go wrong. More discussion about orders of magnitute effort and cost

User Image
ted.feher

Very good basic course in modeling without getting too caught up in Excel functions and shortcuts or accounting jargon.

User Image
barry.gosby

I truly enjoy Blair's courses. It is amazing the depth and scope of the courses he has presented. Blair keep doing more courses please.

User Image
thanh.truong

This course provides a detailed materials on preventing and detecting fraud.

User Image
rahman.ullah

The course was interesting but could have been more organized and concise. The key concepts tested are spoken not listed on the slides.

User Image
sophia.ngo

Great explanations and examples of each function, ideal for anyone who works with lists

User Image
tsaunders

Great course, I truly enjoyed the instructor and learned a lot.

User Image
kyle.hilliard

Most engaging course I've taken on this site. Instructor does very well holding your attention and keeping it interesting.

User Image
kimberly.helmus

Insightful commentary with real world, attainable, objectives

User Image
trobinson

Very good information that will be beneficial when completing my formulas.

User Image
emily.peter

It would be helpful to have screenshots or a video of the instructor working through the exercise.

User Image
michelle.mazepa

The hands-on application of regression analysis, though simplified, was helpful in understanding how to interpret the results

User Image
rhenneberg

Sussman is excellent. He was one of my MBA professors so I was excited to see him on this platform. If he's teaching a class, you want to take it.

User Image
jcadena

This course provided a good overview of financial statements.

User Image
charles.elwis

After having been away from auditing for many years, this was an excellent refresher course.

User Image
chantell.haines_1

I really appreciate this course and its help in career growth and overall help in gaining knowledge in who we are, who we want to be and what our passions are.

User Image
taek.kwon

Excel 2007 is very old. Please update with new version.

User Image
vickie.jackson

Another excellent course by Jeff Lenning. So many helpful functions and tips. I just hope I can remember them all. I would have like to seen more examples.

User Image
kelly.eyster

This course is a great introduction for Macro novices like myself. Notes from this course will serve as valuable reference material as I move on to more Macro classes.

User Image
brian.coughlin

Very insightful. I'll keep an eye out for her other content.

User Image
courtney.gregory

This course gave excellent tips and short cuts. Very easy to follow along with the instructor as well as the exercises.

User Image
sheilah.mcbrown

Helpful information on those pesky error messages that we tend to live with rather than fix.

User Image
rebecca.grimmer

Really helpful to see the side-by-side presentation with Formula based reports vs Pivot table reports

User Image
michelle.grant

would have liked to have an excel exercise for each different "topic" that could be done along side of the instructor.

User Image
kathleen.rakonick

Further definition of the difference between what is "realistic" vs. what is "attainable" would be helpful. Give examples of where a goal is one but not the other.

User Image
ldendrinos

I highly recommend this course to anyone working in accounting. The class material is filled with lots of examples. Great class.

User Image
john.russell

Good concepts, but he goes very fast when working in excel.

User Image
tara.silliker

This course added nicely to the preceding courses and explored topics that will be of use without getting too complex.

User Image
drh105

Very nice - I like the course and the image of the flat file...as it is probably similar to what a lot of people are seeing.

User Image
jeremy.sallie

What you would expect for a foundation level course. The questions proved to be a nice refresher.

User Image
honghee.kim

This lecture let me think allocation my times for working efficiently.

User Image
jonathan.hinkley

Very thoughtful and articulate presentation of usable insights. The summary of a very difficult subject was well developed and the handouts are very useful.

User Image
sudip.roy

Dated content, should be removed. Thank you.. Thank you.. Thank you.. Thank you.. Thank you. 50 characters.

User Image
andrew.anderson

good course except that the presenter's screen was blurry and I couldn't see clearly

User Image
sylviane.alexion

This was an excellent overview of fundamental excel functions. I love the multiple uses of examples.

User Image
ara_toroyan

great overview. educational Bruce obviously speaks from experience.

User Image
darrell.littleberry

This is a great ethics class aimed at actually teaching ethics. No trickery or mind-binding questions to unnecessarily make this important requirement hard to understand.

User Image
jeffrey.bone

Great course, very interesting to learn about the Myers-Briggs!

User Image
craig.scanlon

Much prefer video presentations. Case facts are much more obvious than typical fraud cases. CPA should never practice again demonstrating no knowledge and/or interest in identifying basis of fair financial presentation or uncovering significant issues with client financials.

User Image
laurence.gutcher

The presenter lacks tone and speaks far too slowly to remain engaged. The presenter also reads the slides, providing very little additional insight.

User Image
madeline.edwards

The instructors real life examples were very helpful to further my understanding of the concepts.

User Image
bill.clark

Very good detailed summary of all aspects of the new COSO framework.

User Image
chgrimes

Good discussion on recognizing revenue under the new revenue standard.

User Image
nebbster

This course is outdated, based on 2016 tax law. It is completely irrelevant in 2018/2019. It needs to be updated.

User Image
kirit.kapadia

Good insight in personalities and leadership. Excellent explanations of human behavior

User Image
surepaul

would have loved more examples especially on how fair value assessment.

User Image
pamela.laplaca_1

Lynn's slides were well designed and effective. She knows this topic well.

User Image
tgoodspeed

Great overview of the tax law changes! I hope you do another class once a lot of the guidance is laid out better!

User Image
cpoole

This was a good overview to understanding BI and offered basic tools to implement.

User Image
michael.ware

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor

User Image
davidplee23

Good overview of a complex subject presented in a clear, easy to follow way. It would be even better with real world examples.

User Image
ellen.hynes

Appreciate the thorough review, especially the foray into graphics.

User Image
michael.kelly

What I did not get from this course was comparing to different worksheets of data elements and trying to look for matches (comparing 2 different reports to validate that data agrees). Also, when the exam is finished and the passing grade has been received, it would be nice to see the questions again so we can see which ones may have been incorrect and going back and reviewing the data again.

User Image
oreillye

There were many tips for older versions of excel, not applicable in my case.

User Image
antonio.crawford

The course is excellent, it adds a different perspective in the function of the CAE as part of the company.

User Image
tonia.mathew

The overlap of information on the slides makes it hard for reference purposes.

User Image
sspero

Although introductory accounting is typically a very boring topic, the instructor presented lots of real-world examples in different context which ended up making the course quite informative.

User Image
mondania.drummond

Too simple. I learned this as a sophomore in college - not necessary once you are a CPA.

User Image
chalsey

The pace is slow, but this is a thorough review of basic accounting.

User Image
manish.kothari

The speaker has provided very nice explanation with examples.

User Image
michael.hinton

I took this course, which is number 4 in the series, first but it did not really matter. I think I will take the whole course since it has been very helpful so far in letting me know just what can be done using the language of excel.

User Image
sally.fonstein

Really helpful course with relevant information to use every day.

User Image
mbryant

I liked the examples that were given and the content was good. there were many topics that are good for the beginner in the accounting field and a good refresher for those with experience.

User Image
bruce.reed

This course was a thorough reminder of the ethical requirements of the CFO, as well as the general responsibilities of the role.

User Image
zarksis.italia

Excellent course for ratio analysis, very well presented

User Image
amelia.nemeth

Really enjoy how Marc & Paul present together - engaging!

User Image
gabriel.torralba

I'm a self-taught, no manual "trial and error" Excel user, who uses "intuition" and experience to create what I have to do. This often leads to long and convoluted steps to get to the final product. I learned a couple of features that basically cut those long convoluted steps to a step or two.

User Image
jacob.rothman

Good job logically laying this out. The use of video to demonstrate the technique was excellent. The instructor would be easier to listen to if he didn't end every sentance with "right?"

User Image
jbrain

Well presented, recommended.Well presented, recommended.Well presented, recommended.

User Image
crobertson_1

Course materials would be more effective with powerpoint slides. Course duration could be shortened to 1 hour.

User Image
frank.perillo

A useful and technical course topic which was presented in a clear and concise manner.

User Image
dawn.takemoto

This course is very helpful for the intermediate excel user that would like to be more efficient in excel.

User Image
becky.williams

The training was well organized and was probably the best Ethics course i have taken.

User Image
ynisimur

Thank you very much. very good introduction to new revenue recognition. next time I hope to have more examples.

User Image
pablo.montiel

Excellent course!! Definitely one of the best offers for it value and how is explained each of these courses.

User Image
amy.dyer

Good topic.

User Image
nsaloum

Gives great examples

User Image
majid.mowlaie

Good Information

User Image
patricia_flores

Great course. Thanks!

User Image
kimesha_.jackson

the course was very clear and to the point

User Image
john.noble

Lots of great ideas for someone who is good at Excel but wants guidance on automated dashboard reporting.

User Image
brian.bleifeld

Awesome

User Image
tony.ramey

Short albeit good review of T&E expenses.

User Image
thereneestanley

This was a good refresher course on CVP

User Image
diane.gill

Great Course

User Image
abubacker.syed_abdul

Some more error rectification technique may be included in this course.

User Image
candacekb

excellent course on a much needed topic

User Image
akohl

na

User Image
jmorgan

Helpful.

User Image
andrewrossfullmer

I learned new elements of dashboard reporting.

User Image
simon.adell

A very interesting topic, another one they don't teach you in school.

User Image
psaddi

It was helpful

User Image
terri.salazar-rodriguez

Slides very helpful. Information very thorough.

User Image
penny_pearlman

Great Course!

User Image
jsherman

Great lesson!

User Image
ian.smith_3

Good information especially for someone new to accounting.

User Image
wduffy

I liked the extra tip of deleting objects within a workbook.

User Image
joel.barton

Would have been nice to have the Excel files used to follow along.

User Image
kcurry

Quite informative

User Image
aharris8667

One of the better courses I've seen - detailed and applicable. Good food for thought on key issues.

User Image
fay.chen

Very informative!

User Image
sivavn6

Excellent, great summary

User Image
lgangi

There was a lot of repeated data given. Made the course feel dragged out. Also slides had typos and/or wrong info stated in few places.

User Image
neal.cezat

I would have given a much higher rating if this course showed some actual examples, but there were none.

User Image
swoods_1

Very helpful

User Image
daniel.rodriguez

good

User Image
charpentier.amanda

It is a little challenging to listen to this presenter. She seems very repetitive. I also was discouraged that every time she referred to a leadership position, she used the term "he."

User Image
pamela.malone

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.

User Image
javier.montanez

I felt that most topics were covered well, however all the possibilities of each topic could be explored a little more. For example, conditional formats. Go into the various options.

User Image
jennifer.piano_3

A lot of information and a step by step instruction. Very useful for anyone who has use for pivot tables.

User Image
cheryl.honeycutt

Good information. Would like to have more detail on slides so that can use later when setting up spreadsheets.

User Image
efradela

Great learning

User Image
musantos

Very informative.

User Image
friedel

Good overview of SEC Reporting

User Image
ccatapang

Great and informative course! Thanks

User Image
jodie.vinson

detailed and informative

User Image
libby.antognoli_1

The detailed explanation followed by an example helps to understand and learn the material.

User Image
sabine_.d'amico

liked the convenience; it was good information

User Image
alexander.makielski

Nice

User Image
carmen.diep

The instruction is very easy to follow. I have mastered the subject matters!

User Image
dclark

The PDF supporting materials are all the same. The 2010 does not show the correct 2010 commands, it is for a prior version of excel.

User Image
james.landrum

Very useful.

User Image
eric.higashi

great course

User Image
susan.kim

The class delivery was efficient and effective.

User Image
susan.mccarthy

Lots of information.

User Image
natasha.blackshear

I would like to know what I got right and wrong on the exam.

User Image
malkossak

Excellent!

User Image
mark.odell

Good recap of cash flows

User Image
kyle.degruttola

I worked as an accounting professor for a few years and had a similar style to teaching. It is extremely effective. Nice review sir.

User Image
cmangas

Great course. Makes you think. Very well taught.

User Image
frankbry

Very comprehensive approach in a condensed session. Attachments and supporting documents were very helpful and a valuable tool to use in applying the concepts. Matt was very energetic and enthusiastic as an instructor.

User Image
brenda.au

Great, thorough explanations and examples

User Image
jcoleman

I appreciated that the course talked about CPAs in business not just in public accounting.

User Image
mike.morse

What about online identity theft companies? What do they do and are there worth the money? What are the steps to take if you have your identity stolen?

User Image
wayne.muscarello

Very professionally done!

User Image
munyaradzi.kadzinga_1

Simple but very effective presentation. I loved how brief the financial model was with enough information useful for reporting. Very useful and practical tips for both seasoned professional and those who are just beginning. Another excellent presentation from Blair Cook.

User Image
robbinsj

I liked that I learned something

User Image
zulfiqar.haider

Quick guide to organise and stop distractions

User Image
scott.ellis

This course provided a basic presentation of the closing process and journal entries. The instructor showed clear examples of how to close out the financial statements and the reasons you make the entries. Nice beginner course.

User Image
williamdstone

Clear descriptions from the presenter and follow-up examples answers the questions I had.

User Image
raul.cardona

Excellent course!! Learn many new features of Excel that I haven't seen anywhere else. Well presented training, nicely put together and easy to understand!! Highly recommend this training and all classes provided by this facilitator!

User Image
py2wong

Great tips!

User Image
ecapunitan

People Management

User Image
swong

The course is so easy to understand.

User Image
connorw

The video is outdated should follow the format of some of the more recent excel courses that have been uploaded to illumeo. Slides for a video is not very effective and hard to follow. The live feed of where the instructor's cursor was from other videos is much more effective.

User Image
amiles

very clear

User Image
hossam_elsherief

Excellent course

User Image
tvillegas

The videos have too much screenshots that make my eyes confused where to look at to.

User Image
daniel.miller_2

Enjoyed it.

User Image
aross

Too much time spent discussing the presenter's qualifications

User Image
david.mellinger

good tips

User Image
liliane_siv

Great tips, love the instructor very clear explanantions and examples

User Image
bscott

Good ideas for all company sizes, looking forward to implementing some new things

User Image
cillo_58

Very informative information

User Image
osmundsen

Great course!

User Image
nelsonm1978

Did not like questions about Apple. Numbers not in front of me.

User Image
matthew.jones

Well written. Powerpoint needs polishing.

User Image
kevin.moschella

A bit dry but did have some useful material.

User Image
vanessa.dennis

It was a very good course

User Image
partha.datta07

Nice course

User Image
julie.killian

Lots of helpful information.

User Image
dboczar

The examples helped to confirm understanding of the material presented.

User Image
xueya_liu

Good point

User Image
ruijie74

Good class, very useful

User Image
matthew.reilly

Good background on SEC

User Image
matt.rank

excellent refresher

User Image
vogtr4271

Good material but monotone delivery makes it difficult to focus.

User Image
kurtboehringer

this course was excellent. well structured, easy to follow and content rich.

User Image
jeffrey.wilson_1

I liked the instructor's delivery and enthusiasm for the material.

User Image
kerry.schanno

Great material. Too fast to follow at times.

User Image
tengwong02

Thank you!! Really useful info. I have not used Match/Index before but now find a lot of ways to use them in my spreadsheet.

User Image
ophelia.chan

It will be great to include all worksheets for all examples.

User Image
jshoular

Excellent

User Image
norman.west

Mr. Turner demonstrated a comprehensive budgeting solution in Excel which could work well if it is monitored and managed carefully.

User Image
james.munch

Great instructor, great overview!

User Image
travis.britt

good course

User Image
mike.cornelsen

Very informative and fairly comprehensive

User Image
jason.wimmer

I believe the exam answers are not correct and should be reviewed.

User Image
snyderaf

Excellent presentation.

User Image
mhpradwin

l like learn about this course and subject We will follow full courses for an intense love thank you very much

User Image
kevin.white_1

It would be better if the items were shown in motion (vs. the slide with numbers). Also the sound quality was a bit poor.

User Image
sphillips_2

Very basic information. Good information for non-accountants

User Image
andrew.gentile

I like the self study ability of this course and the exam practice.

User Image
aracely_falciola

material to reivew more than once to understand the logic is interesting

User Image
staabmary

Class was a little slow...instructor restated his name, title, title of the class at each section of course.

User Image
sofia_chaudhry

I wish course should be little lengthly and cover more item related to Pivot table.

User Image
deb_peterson

no

User Image
patrick.brown_1

The course was excellent. It met my expectations.

User Image
kelley_novick

I thought the instructor could spend less time on the non functional portions and more time on the "homework".

User Image
kim.bosler

I really liked the workarounds for the vlookup formula and learning about the Index formula. I will definitely start utilizing these methods in my spreadsheets. The worksheets were very helpful.

User Image
michael.morgus

You will learn about how operating lines of credit works and what to watch out for. Very informative & reference material.

User Image
singh.rohan

Expert instructor with excellent presentation flow and engaging style.

User Image
richard.dandan_1

Excellent review material. Thoroughly explained and easily understood.

User Image
betty.glover

Really enjoyed the course. Covered the material well with the incorporation of examples.

User Image
donald.carpenter

Great information for someone looking to help their company develop an investment policy and manage the investment process.

User Image
christopher_quiel

Great overview of what to expect.

User Image
kent.oliven

Once again Mr. Lenning provides clear understanding.

User Image
darryl.schroeder

Very helfpful for future financing avenues and IPO considerations.

User Image
dpeterson_3

Every company out there should make the effort to do a Fraud Assessment as it is not a matter of IF Fraud will happen at your company - but when (or has it already happened?). Lynn provided a great background on what companies should do to get the ball rolling.

User Image
bill_1

Again - great tools for improving Excel skills. I will use these a lot!

User Image
cyndin

Good amimated speaker.

User Image
katy_wilson

Had a hard timing hearing this. It seemed as if the volume went in and out.

User Image
lindsay.vanek

I found this extremely useful. I am fairly good at Excel and still learned some tricks. Thanks.

Lesson Questions and Answers0 Questions

Ask the instructor a question about this lesson

Your question will be sent to the instructor, who will answer as soon as possible.