Microsoft Excel is considered one of the most useful tools in the workplace. However, if Excel is used incorrectly, it can seriously drag down productivity. This course guides you through shortcuts and functions to enable you to boost your productivity and shave valuable time from repetitive tasks. You'll learn:
Selected Shortcuts
Keep your hands on your keyboard to improve your speed. This online Excel course explores 5 shortcuts that assist when writing formulas and functions. The Excel lesson includes F9, fill down and right, Ctrl+Home, row shortcuts and column shortcuts. It also follows up on a discussion from Volume 1 Chapter 6, and expands the utility of F2.
Conditional Summing Basics
Have you explored the conditional summing functions in Excel? The SUMIFS function is absolutely a game changer. This online Excel course introduces the multiple condition sum function SUMIFS. The Excel lesson works through the syntax of the function, and provides several practical examples so you can work hands-on.
Remove Duplicates
This online Excel course explores how to remove duplicate values from lists and tables. This Excel lesson demonstrates how to use the remove duplicates feature to generate a unique list of report labels.
Lookup Basics with VLOOKUP
Are you comfortable performing lookups in Excel? They are the keys that unlock significant efficiency in recurring-use workbooks. This online Excel course covers the cornerstone of all Excel lookup functions, VLOOKUP. This Excel lesson covers the function syntax, and provides numerous exercises so you can work hands-on to develop your skill.
Improve VLOOKUP with MATCH
This online Excel course demonstrates how to address a serious limitation of the VLOOKUP function. The VLOOKUP function will break when a user inserts a new column between the lookup and return columns. This Excel lesson explores the MATCH function, and illustrates how to use it to bypass this VLOOKUP limitation. We work through the syntax of the function, and provide several practical examples so you can work hands-on.
Improve VLOOKUP with TEXT and VALUE
This online Excel course addresses a serious limitation of the VLOOKUP function, the fact that equivalent values stored as different data types won't match. That is, the number 100 won't match 100 in the lookup range if stored as a text string. This lesson demonstrates how to bypass this limitation by using the TEXT and VALUE functions. We work through the syntax of the function, and provide several practical examples so you can work hands-on.
Moving Beyond VLOOKUP with INDEX
This online Excel course addresses a major limitation of the VLOOKUP function, the inability to go left. That is, the VLOOKUP function is not designed to return a value that lies to the left of the lookup column. This Excel lesson demonstrates how to bypass this limitation by using the INDEX function. We work through the syntax of the function, and provide several practical examples 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
- Increase your Excel speed with selected shortcuts
- Remove duplicates from lists and tables
- Look up values in a table using VLOOKUP
- Utilize multiple lookup functions such as VLOOKUP, MATCH, and INDEX
Last updated/reviewed: March 22, 2024
(415) Reviews
(195 rating)Good course and review. A lot of information but good "broad" overview of materials.
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.
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.
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!
This was a good review of the Control Environment. It provided great explanations and examples.
Good course overall. Was a great audio course that made it easy to walk and learn simultaneously.
More content than I was expecting. Went into some detail with how to calculate pricing. I will be taking the two other courses in this mini series.
The course did a nice job and explained important, relevant information in a manageable and easy-to- digest manner.
Excellent knowledge as a presenter, but there is no way that a test for a little 2-hr CPE course like this should ever be that difficult.
The examples would be better if written out. It is hard to catch by just listening.
This is really a refresher course where Lenny reviews prior courses but he puts it all together, showing how various features can be utilized to build a robust dashboard.
there was an extensive amount of material to learn and understand. Maybe do more explanations and less amount of concepts.
Good overview of SOX 302, including the history, the requirements, explanations of the key components, and relation to SOX 404.
Great review of budgeting topics with some new information I hadn't heard of. Will refer to this content again.
This was a helpful review. Thank you for the informational resources.
very good introduction to power query. have not used this function in excel and found it very interesting
This was a very long course. The material was informative but very dry. Knowing this, I would probably break this up into multiple sittings instead of trying to get through a continuous play.
Good course explaining how account takeovers can occur and ways individuals and businesses can protect themselves.
Very helpful course as I WAS a former bullet queen.
Interesting course with great Cases to add understanding. Great presentation.
Very clear explanations and examples of Ethics vs Morality vs the Law. Also, how we operate within each. Lynn gave a thorough and thoughtful presentation. I always enjoy and learn from her training.
Lot of unnecessary politics in this course. Ethics is something that doesn't need to be politicized. It detracts from the arguments.
This was an excellent overview of the budget process in review. It is not a detailed budget process but it is sufficient to outline the major points.
Ethical issues are sometimes downrated, what is not correct. Great presentation.
easy to understand, slides were good form of study guide
Good discussion but I don't think the answer for the first review question is correct.
Rob does an outstanding job of effectively teaching the Key Performance Indicators and KPI Dashboards. The course was well-structured, providing a comprehensive understanding of KPIs and their critical role in measuring and driving business performance. The content was insightful and easy to follow, with a perfect blend of theory and practical examples. The section on creating KPI dashboards was particularly valuable, offering hands-on guidance on designing and implementing effective dashboards that provide real-time insights into business performance. The instructor was knowledgeable and engaging, making complex concepts accessible and relevant. The interactive elements and practical exercises helped reinforce the learning and provided me with the confidence to apply these concepts to my own work. Overall, this course is a must for anyone looking to deepen their understanding of KPIs and enhance their ability to track and manage performance effectively. I highly recommend it!
I am a CPA that works in a publicly traded company and most of the ethics courses are firm based. I like the perspective on this course being non-firm.
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.
Always like her courses. Very easy to understand and process the information. She clearly understands the topic and uses good detail.
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.
A great intro course into Excel, I would recommend to others.
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.
Virginia ethics course, it's required for CPAs and this format works
Clear, concise, and practical. Perfect for beginners!
Supplementary was a great summarization of all the items learned and then to see it in action was a great learning experience
The class was basic. Explained some key fundamentals
very good course, good presentation and pertinent information
I really enjoyed this webinar. It gave me a lot to think about with my own management style.
Mr. Ringstrom is an excellent instructor; I like that he goes through the PowerPoint and then shows it live in Excel. I will be back for more courses.
Extremely thorough presentation encompassed in the gradual addition of detail to each slide.
good thank you so much, it was helpful. really helpful.
The material is dense and detailed. Be prepared to read and reread to fully comprehend.
Great class to meet state-required ethics class. Information presented was easy to understand with good examples.
Detailed instruction by author. Refresher course still if you know Excel.
I learned a lot, but the test questions were out in left field and there are no slides.
Love Blair's webinars! Definitely wish there were more available on Illumeo. He is one of my facotire presenters!
Good overview of the subject material. Covered all the major points.
Great overview of the various types of cognitive dissonance and biases that we humans fall into. If you've taken a behavioral psychology course or enrolled in the CFA program, this material may not be new to you (e.g. Ariely, Kahneman, Sen...if you recognize these names, you do not need to take this course.)
Honestly, I got more out of watching Ted Talks and YouTube videos ...
This course was a good refresher. This course is ideal for people not as familiar with accounting. Thank you.
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.
Excellent refresher course and reference for future use. Instructor and materials are also excellent.
I like the trick to think of at least 3 options or choices in deciding on solutions to a problem.
they didn't give clear examples on the courses and it was hard to navigate through it unless you go to search by yourself
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.
Good introduction to the investing segment of the treasury function.
I have taken 2 of Mr. Ihde's courses. They were both very informative and helpful. Please bring more of his courses to Illumeo.
Presenter is easy to listen to but, the course needs real world examples - not just reading tax brackets.
Another great course - helps provide real-world examples to visualize ethical situations.
What I appreciated: The recap at the end is helpful to reinforce the most important concepts. The quizes are a nice touch because it tests your knowledge while you're watching the course. Areas of improvement: There is a lot of content in this short course, and it would be overwhelming for someone who has no experience in accounting. Additionally, I think it's much more helpful to learners to teach that Assets = Liabilities + Equity rather than Assets - Liabilities = Equity, so it reinforces the idea that Liabilities & Equity should have a credit balances. When going over the example for Lesson 2: Posting Entries (continued), it would be helpful to list the numbers we know before showing the correct entry.
This was a great overview/introduction to Power Query. Users with no exposure to the process will not be overwhelmed. Good supporting materials, but it would be nice to have access to the source files to make the practice more realistic. Overall highly recommended, especially to beginners.
A+ with just the right level of detail for an introduction to blockchain!
Well taught. Instructor is excited and engaging. Thank you for the course.
The questions had multiple misspelled words and incorrect grammar. Not super insightful training
Course was relevant and a good road map to live all aspects of your life.
Detailed and informative course with plenty of examples to illustrate application of laws into practice.
Blair was very engaging. It's a great class for intro to finance.
A lot of useful information on basics of accounting.
This course was very easy to follow and well explained on how to use Excel functions and shortcuts.
Very lovely class. I can use this and also apply the principles to helping my kids write.
Really great class for beginners and advanced users. Really enjoy David's excel classes. They are easy to follow and love the examples he uses throughout the course.
I really liked the format of this course. Easy to follow and learn from. Thank you for your time. The v lookups make a lot more sense to me now and I feel confident using Excel.
The instructor spoke a little slow for my taste. I had to speed up the video to help me follow along. Good course, though.
Too much repetition and not enough instruction on how outlook works.
This was a great course to refresh and learn new excel skills that can improve time management and workflow.
This course provides some great information. The topics covered are very helpful as well.
Well structured overview of the course by instructor
Super clear instructions with excellent examples provided to work through.
Great introduction to macros. Mr. Ringstrom provides several great examples where macros can provide work efficiencies.
Well worth your time. Very practical use of Outlook to become more efficient managing information at work. Keep the imprortant things the important things.
Course is both entertaining and informative. Sanders' example organization for his sample 990 is humorous and enjoyable.
Nice review of the key principles of ASC 606 and 842
This course was very informative and gives interesting perspectives for anyone who pays taxes.
Great information in this course. It was easy to follow along.
I like the overarching subject matter of the course and especially the sections on SWOT
The program is well presented. I would prefer a video format to aid my learning style.
been using pivot tables for years and still learned something new
Good material and overview of SAAS metrics. Sound was a little low could be increased but otherwise good
This course was a great review of Ethics CPAs Business.
Very informative course, would recommend to all states, not just Iowa.
The course was very informative and provide lots of short cuts.
David's courses are always great. Learned a great trick for getting the month number.
Thank you for including the example questions, I found them very helpful in understanding the course content.
The information provided in this course was presented well and provided a good overall understanding of the planning process of an audit. However, the exam itself needs to be proofread as there were several questions that were written so poorly as to make no sense of the question being asked.
I love this course! Practical and motivating, actionable advice to drive your business forward. Implementing advice right away.
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.
The Course was very engaging and provided great examples of real life. The instructor is very enthusiastic and content is to the point.
Helpful perspective on how to approach meetings with a superior
Excellent speaker who is clear, concise, and gave relevant examples that supplemented the course theories.
The instructor provided very helpful information. He is very clear and easy to follow. The samples are practical.
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.
Actually enjoyed the refresher. Nicely done. Easy to read and understand.
Great course to go over how to manage cash flow and important aspects to consider for any level.
This course was very informative and helps to review the basic concepts of the accounting process.
A good follow up to part one. Digs deeper into the actual code aspect of VBA. Very informative!
A good review of ethical principles. Enjoyed the case study related to IWK.
Large amount of typos. The slides appeared sloppy.
IF it free training then final exam must be allowed without subscription
Great course with clear and detailed breakdowns of the course material. Well worth the time.
Enjoyed this course! Great insight into future dealings within companies.
I liked the text format of this course! Will use it again in the future.
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.
I liked the way the trainer presented the topic to clarify the concepts in the easiest way.
Learned a lot about filtering, and the instructor was spot on and explained in detail. I like how the instructor walks you through every example.
Very thorough, the workbook goes along quite well.
Ethics is difficult to teach, although you would think otherwise. This is a great course to address the esoterics of the subject.
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.
The content of the course including case studies were effective, but the slides in the presentation were very wordy and unengaging.
I liked that after each sections, an example was given.
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!
This was an informative primer on IT General Controls and was easy to understand.
Helpful information about automating reports in Excel. Recommend.
Great course for learning more about Excel! This course prepared me to be more efficient in Excel. I learned multiple lookup functions such as VLOOKUP, MATCH, and INDEX. Thank you!
Great deal of practical solutions to enhancing executive presence. Solid examples by the instructors.
The quiz had typos and was very confusing. It would be helpful proofread and make sure the question makes since.
Well prepared and laid out. Flowed well from topic to topic.
Good refresher course for the CA regulatory review
The examples used by the course instructor were very helpful in understanding the material presented.
I am excited about the potential time savings that power query can bring.
great course, good to follow, great and effective instructor
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.
The lecture offers very helpful tips to help increase the efficiency of using the excel. The lecture is also very organized and easy to follow. The exercise workbooks are extremely helpful to practice the skills mentioned in the lecture. Thank you!
Instructor really explains thoroughly & provides wonderful & helpful supporting documents & materials for afterwards. It still takes me forever to complete, but it is a well planned out & conducted online learning video.
Good course for the various fraudulent schemes that are appearing everyday in the workplace
Good advice to avoid disastrous presentations. I wish some of the people giving presentations to me had taken the course too.
Very informant course - contained a lot of good information. Course instructor very good with good examples.
Well presented and well explained. And he made it interesting as well!
great course. introduced some functions with which I had limited experience, and broadened my appreciation for the application of functions I already use frequently.
A little dated. Needs to be updated to current outlook. some of the strategies go beyond outlook software and these are useful.
This was a very detailed course and a good refresher of the responsibilities and types of controls businesses should have.
Foundational learnings regarding the bookkeeping process. Those pursuing a bookkeeping position or those interested in organizational management, separation of duties and roles and responsibilities within an organization may benefit from this course.
This course is a very basic but important guide in setting goals
The best ethics course that I have taken. Thank you!
Good course overall. The instructor is knowledgeable and interactive, but it was hard to follow and keep up at times because the instructor went a little too fast and used too many technical terms.
to long, could be more sintetic; it seems to be boring at some time.
not a fan of this course. too much story telling and all over the place, hard to follow. If youre looking for a new commentary then you'll love it.
Good overview of various ratios that help in the financial statement analysis
Your courses have all been so wonderful, so informational, and so thorough--in short, greatly appreciated by me! Thank you for sharing your expertise, your wealth of knowledge, your inclusion of examples! I have greatly enjoyed reading and listening to all of your lectures thus far.
Informative and easy to understand. Can't wait to use the new options!
This was the best ethics course I have taken. I really liked the case studies.
Good course and ideas for staying more organized and effective..
Decent refresher course, plus you learn a few items to make excel easier.
Excellent overview of covered material. Examples and support material were helpful in understanding each excel tip.
Dynamic teacher. Lot of new features to use on day to day!
The course was very good and I got a lot out of it; however, the microphone was very distracting. It was not sitting in a good place and would make a noise every time the instructor moved.
Great general overview of the new standard. Very informative.
Very good information given in this course, and given in a way that was very informative, not too wordy, and easy to understand.
- - - - - -
Good course on Xlookup formula, this will definitely be my go to formula when looking up values.
Very helpful course that makes you better appreciate the controls in place at companies and realize the risks of not having these controls. Management review is very important too and I was surprised that tips was number one.
Though the material in this course was well thought out and presented, I found it distasteful and unpatriotic to include a former president, not just as an example of an amoral/immoral leader, but also the answer to an exam question. Keep your politics out of my professional learning materials...
Two exam questions were super confusing. Not well written. #2 and #4, other than that, was an excellent course
The course offers great suggestions for how a 1:1 meeting can contribute to career building success.
Helpful reminders to remain proficient with excel and stay away from more manual bad habits.
Great instructor and presentation! The material is explained in simple terms and informative.
Great overview of manager mistakes that are made early on when becoming a manager for the first time.
I liked the different ways to look at things throughout our life daily.
I didn't feel like the questions about The TV Show or "Nerds" were appropriate to the material. "Nerd" tends to be perceived as a derogatory term and doesn't feel like it fits in with the concept of Emotional Intelligence.
The instructor was very thorough on explaining xlookup and its functionality. Furthermore, he provided detailed examples on how to overcome the constraints of vlookup, hlookup, xlookup and other formulas.
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.
This course could have been really cool, but I couldn't follow the Excel directions....
good course
I appreciate all of the practice. Lot's of problems help to develop proficiency at speed.
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.
This course was really interesting because I learned about some of the new things I can do with 365. Definitely recommended. However, digging into the differences between various versions of Excel is not too interesting.
Informative and engaging. Good examples to use in real life presentations.
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.
Great review of the financial statements for CPE credit. Great professor and lesson.
instructor was clearly very knowledgeable, spoke quickly and used examples of how you would apply to real life situations-- a lot of material but all very useful.
Good review course. This was a solid refresher for something I have been away from for some time.
now that I WFH full time because of the pandemic, this was SO helpful!
It was great to review and/or learn anew these important topics.
Excellent recap of the 5 steps of RR and solid examples of their application to learn from. Recommend this course to solidify understanding of concepts.
Excellent class with important information on knowing your audience. Class includes helpful tips when working with those in higher positions.
Other illumeo presenters should take this course! Awesome!
I took this course and it was good. Then I passed.
Great basic course to provide a basic understanding of business combinations under topic 805. Would be better if it was not a text based course but an instructor led program.
It was a great course. Though, there were too much information given in a short time. As the instructor said, it needs lots of practice and repetition to be more efficient.
very interesting and provide good insight for new keys and directions
Great instructor. Very happy to take the class and learned a lot
Great course Lenny - step by step simple instructions for tips and tricks regarding pivot tables.
This class was very informative, I like how they gave detailed examples to have a better understanding.
There should be a handout which can be referred to with more information that assists with the exam. This took longer than 3 hours.
The macros were a good introduction for someone who has never used them to see how powerful they can be in mass reporting. Getting briefly into the coding behind it when that was not the true takeaway of this course was a bit too much information as I got too focused on seeing the code rather than the purpose of the actual code.
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.
Easy to understand and follow. Basic concepts with real world examples.
This is a great course. I recently start doing budget forecast for my company. I can see a lot of the similarity between this course and actual real life work. This course definitely help me to improve my understanding and the concept behind my work. I also like the few tricks that Blair shares at the end of the course.
Introduction to basic excel features. Course topics explained by working through numerous examples. Time estimate on the low side. Very good course.
I wish I saw this training at my previous job. What a good, straightforward approach to managing the situation.
It is pronounced FISCAL and not PHYSICAL. SUI stands for State Unemployment Insurance Tax not State Unemployment Income Tax.
Very useful for anyone who is considering implementing a workflow system.
Good class overall. There are many complex topics covered in a short period of time, I had to watch a few of the topics several times to grasp concepts.
I would like to see more real life examples in this course.
Enjoyed the take away for me of the importance of a leader looking ahead to the future instead of focusing on what happened in the past.
Very good refresher! Must take it every few years. Very good coverage.
This was an excellent presentation of tools that are key to efficient payroll analysis. The student should invest personal time practicing the applications but the material could not have been presented better. The overview followed by the actual application in the worksheet was extremely helpful in following along. All excel courses should be taught this way. Slides were well formatted and are usable for future reference.
Very helpful information for people in the accounting profession.
Awesome instructor who can simplify complex excel processes.
This was a good and basic introduction to the business process mapping.
Great course. Stated prerequisite requirements were appropriate and sufficient. Program materials were relevant and contributed to the achievement of the learning objectives.
Good written material and fair questions on the exam.
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!
Clear and easy to digest information. Helps understand how some people get stuff done and others don't. Stepp explains this by incorporating personal experiences.
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).
Very interesting to learn about and think about how ethics is changing in this dynamic environment
I really enjoyed this course, examples were practical and realistic.
Content was fine but his frequent typo during the lecture was distracting.
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.
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.
Excellent course lead by an effective instructor. Great content.
It was a good overview of the new lease accounting standard. Thank you.
The answers to the exam questions are not in the slides.
Very Basic Review of google sheets but helpful if new to google sheets. Most items were similar to excel.
Very cool course! Many really useful things have been explained.
Very helpful to learn of the different styles and their characteristics
The instructor makes the material easy to understand and remember.
Very good basic course in modeling without getting too caught up in Excel functions and shortcuts or accounting jargon.
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.
I thought the questions were less aligned to the information in the slide deck as they have been in other courses.
This course provides a detailed materials on preventing and detecting fraud.
The answer spreadsheets were very helpful as a reference.
The presentation was great with great information.
Great explanations and examples of each function, ideal for anyone who works with lists
Ann is very knowledgeable in regards to AP, however, the class itself is hard to follow. I do not feel as though Ann is as engaging as other presenters.
Insightful commentary with real world, attainable, objectives
Course was very through and very well taught. I also like that the instructor has a sense of humor and keeps things light, as opposed to be so serious.
Comprehensive, informative and well delivered course.
It would be helpful to have screenshots or a video of the instructor working through the exercise.
The hands-on application of regression analysis, though simplified, was helpful in understanding how to interpret the results
After having been away from auditing for many years, this was an excellent refresher course.
I like how cutting edge the topic is, but the lecturer style is a bit too academic.
Excellent overview about temporary differences, very useful examples and exercises
The course makes it seem like these changes would be simple when in reality this is a very high level overview.
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.
Good basic course for an overview of segregation of duties. Easy to understand with simple examples.
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.
This course gave excellent tips and short cuts. Very easy to follow along with the instructor as well as the exercises.
Helpful information on those pesky error messages that we tend to live with rather than fix.
Really helpful to see the side-by-side presentation with Formula based reports vs Pivot table reports
Very easy to understand and course provide a great overview with lots of examples. Highly recommend!
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.
It's a little look into the background of Accounts Payable. It was helpful to learn when liabilities is established.
Good discussion on recognizing revenue under the new revenue standard.
Good concepts, but he goes very fast when working in excel.
This course is too basic to take as CPE for a CPA. I would also suggest during the instruction to make the notes more formalized if you are going to teach how to prepare a financial statement.
Thank you for this amazing insight! I cannot wait to get started creating a successful business plan.
This was well detailed while providing very efficient timely lessons of the general topic.
This course added nicely to the preceding courses and explored topics that will be of use without getting too complex.
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.
This lecture let me think allocation my times for working efficiently.
Dated content, should be removed. Thank you.. Thank you.. Thank you.. Thank you.. Thank you. 50 characters.
Great test for practicing payroll accounting principles.
This course was very efficient. Though it was fairly straight forward and there were no new ideas, it is good for beginners.
good course except that the presenter's screen was blurry and I couldn't see clearly
Great course, very interesting to learn about the Myers-Briggs!
No Basic excel functions learned in this course. Don't believe "efficiency" is the right topic for course name.
Very informative and organized in an easy to follow method. Enjoyed the training.
Good discussion on recognizing revenue under the new revenue standard.
Good insight in personalities and leadership. Excellent explanations of human behavior
Great overview and detailed account of the information.
Lynn's slides were well designed and effective. She knows this topic well.
I would have liked to have more examples of different kinds of leases.
I will definitely recommend this course to my co employee
Appreciate the thorough review, especially the foray into graphics.
There were many tips for older versions of excel, not applicable in my case.
Not terribly relevant now that Excel 2016 is available.
The overlap of information on the slides makes it hard for reference purposes.
I thought Erik did a good job of covering the basics of the statement of cash flows in a short amount of time, but I wish that the final exam had been a better test of the viewer's knowledge. The questions were very basic and I would've much preferred being given a balance sheet/income statement and forced to construct a statement of cash flows that way. Still, I thought the instruction throughout was clear and the layout of the course made sense.
Excellent course and helpful in many ways. Can there be another course from this instructor on how to handle Q&A when presenting financial information?
Lots of helpful tips & insights. Good ideas of different ways to deal with conflicts.
This course was a thorough reminder of the ethical requirements of the CFO, as well as the general responsibilities of the role.
Excellent course for ratio analysis, very well presented
very importnat program coz, it gives you the tools to improve and get the rigth way to intriduce yourself with succes, and this is what we need in this business race
Comprehensive overview with detailed steps to a good fraud mitigation program. Instructor laid out what was to be covered and then covered it.
Difficult to follow instructor as mutliple screen shots are applied to each slide in the presentation
If I could have given 6 stars, it mightn't have been enough. He provided a very practical roadway to finance excellence. Great enthusiastic and knowledgeable presenter.
I thought he was on target with his observations. He kept pretty much to the slides so they were a helpful resource.
The text in the spreadsheet was too small to follow the instructor on a 17 inch monitor
nothing to add good course on financial information that is useful in conversation
Very articulate, concise and insightful! I would recommend for anyone looking to improve their public presence.
A useful and technical course topic which was presented in a clear and concise manner.
This course is very helpful for the intermediate excel user that would like to be more efficient in excel.
The training was well organized and was probably the best Ethics course i have taken.
Solid insights to improve command of key excel functions that can be readily applied to real problems.
Excellent course!! Definitely one of the best offers for it value and how is explained each of these courses.
Good topic.
Good Information
Great course. Thanks!
Liked to keep up to date with new changes.
Lots of great ideas for someone who is good at Excel but wants guidance on automated dashboard reporting.
Awesome
Short albeit good review of T&E expenses.
Great course in understanding the IT and Finance relationship.
A bit hard to follow in some places but overall, another very good presentation
Very effective teaching lesson.
Some more error rectification technique may be included in this course.
Helpful.
very good
Great course! I really enjoyed it.
great suggestions
A very interesting topic, another one they don't teach you in school.
na
Well presented.
It was helpful
Great Course!
Good
Great lesson!
Would have been nice to have the Excel files used to follow along.
Very informative!
Excellent, great summary
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.
A lot of information and a step by step instruction. Very useful for anyone who has use for pivot tables.
Instructor was very effective and structured the course in an organized, easy to follow manner. This approach kept me engaged and allowed me to easily retain the key concepts.
Good information. Would like to have more detail on slides so that can use later when setting up spreadsheets.
Good overview of SEC Reporting
Great and informative course! Thanks
liked the convenience; it was good information
Nice
The instruction is very easy to follow. I have mastered the subject matters!
.
Very useful.
The instructor is easy to listen to. He keep the topic interesting.
Lots of information.
Good
I would like to know what I got right and wrong on the exam.
Excellent!
Great course!
Great course. Makes you think. Very well taught.
Very helpful. Learned many new techniques for building reports.
Very basic if you're a CPA.
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.
Quick guide to organise and stop distractions
great course. very useful info
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.
This is a good reminder about a tool that can help you as you manage a company.
Great tips!
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.
Learn a lot. Many thanks.
very clear
Excellent course
The videos have too much screenshots that make my eyes confused where to look at to.
Enjoyed it.
Too much time spent discussing the presenter's qualifications
Valuable course for educating auditors and management about the value of RBIA that provides a step by step methodology which can be utilized as a starting place for organizations to begin to establish RBIA.
good tips
Great tips, love the instructor very clear explanantions and examples
clear and easy to follow
Great course!
Good overview of basic accounting principles
A bit dry but did have some useful material.
A good overview of the characteristics that IA managers need to have to excel in the profession.
The examples helped to confirm understanding of the material presented.
Good class, very useful
Il liked the amount of info, well thought out, good advice.
Good material but monotone delivery makes it difficult to focus.
Great course that I hope will save me time down the road.
I would love to know which one I got wrong so I can review the area
Great material. Too fast to follow at times.
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.
Great course, I had to pause frequently to make sure I understood the topic. He really flew through the formulas and it was difficult to keep up at times. Not a big problem but definitely changes the timing of the course for me
A common sense reminder.
Excellent
Mr. Turner demonstrated a comprehensive budgeting solution in Excel which could work well if it is monitored and managed carefully.
great course!
Please match the speaker with the slide transitions and slow down the pace.
I really like Lynn's systematic explanations, as she explores every facet of every skill needed in today's internal auditor.
I liked the simple style of presentation and the way the instructions are repeated and reinforced from presentation slide to excel workbook.
I believe the exam answers are not correct and should be reviewed.
Excellent presentation.
l like learn about this course and subject We will follow full courses for an intense love thank you very much
It would be better if the items were shown in motion (vs. the slide with numbers). Also the sound quality was a bit poor.
Other excel course provide excel worksheet example which are very helpful. Trying to following formulas on the screen was not always efficient as the screen was very small and hard to read.
Great course...like the way the topics are explained
Very basic information. Good information for non-accountants
material to reivew more than once to understand the logic is interesting
Straightforward and easy to understand course content.
This is a great course and a great speaker. There is so much to learn about Excel and this is one of many steps to get there.
it seems kind of dry in the presentation. I would love some info on not using T-accounts.
Class was a little slow...instructor restated his name, title, title of the class at each section of course.
The lecture was too fast in some cases and not enough detail for beginners.
The Index Match usage was good to see.
I liked the pacing of the course, it starts simple and builds to the most complex. By the time you get to the complex you feel ready for it. I had not taken an earlier course so I was lost on a few of the shortcuts that were heavily referenced, but that was a minor problem.
I liked the course and the worksheets to work along with the video. Very helpful.
A good refresher for Vlookup, however, The IFNA Function module seems to have completely repeated itself and is twice as long as the information actually is.
This is a great course for someone who is new to using excel and formatting data.
Best excel class that I have taken so far! I actually learned something new and can actually used some of the examples in my own workbook.
no
Great overview of Outlook factional tools. I love the instructor's personal stories and positive personality. Easy directions to follow and great content.
Awesome tips to quickly overcome the limitations
Very useful tips and tricks.
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.
Very informative
I love the NRN tip! The amount of "Thank you" emails in my office is extremely wasteful of my time and inbox space.
Expert instructor with excellent presentation flow and engaging style.
Excellent review material. Thoroughly explained and easily understood.
Great overview of what to expect.
Once again Mr. Lenning provides clear understanding.
a general comment to proformative...if we pass the course, but do not get all answers correct, it would be great to be able to review the question.
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.
Great course and very relevant to email / org / management of time
Good amimated speaker.
I found this extremely useful. I am fairly good at Excel and still learned some tricks. Thanks.
This is a pretty solid course to introduce you to Buy vs. Lease analysis and the different aspects to consider when doing so. This is something I am hoping to implement in our company to help with management decisions.
Ask the instructor a question about this lesson