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 design better workbooks. You'll learn:
Better Summing
What function do you use the most? Is it the SUM function? It probably shouldn't be. This online Excel class explores better summing. The Excel lesson examines a summing function that is preferred to the SUM function.
Skinny Row
The skinny row technique helps improve the reliability and efficiency of recurring-use workbooks. It helps avoid the errors that can sometimes result from inserting new rows of data between the last data row and the formula row.
Hide Worksheets
This online Excel class demonstrates how to hide worksheets in order to prevent users from viewing extraneous information.
Highlight Input Cells
Highlighting input cells improves efficiency and reduces errors. This online Excel class reviews highlighting input cells and the advantages of using cell styles rather than manual cell formatting.
Workbook Organization
Did you know that the way we organize our workbooks can impact our efficiency? This online Excel course discusses key ideas to consider when building and organizing Excel workbooks.
Worksheet Organization
Organizing worksheets is a skill needed to maximize efficiency, especially in recurring-use workbooks. This online Excel class walks through many worksheet organization ideas and concepts.
Nested Functions
Nested functions are an absolutely fundamental and critical skill in Excel, and they enable us to write comprehensive and beautiful formulas. This online Excel course walks through the basic idea of nested functions.
Selection Groups
This online Excel class discusses the performance boost that can be achieved when you group select items first, and then perform a command one time to all items in the group.
Workbook Design Principles
This online Excel class reviews 5 critical workbook design principles. This lesson covers the concepts to keep in mind as you build workbooks in order to maximize efficiency in recurring-use workbooks.
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
- Explore alternatives to the SUM function
- Be able to hide and unhide worksheets
- Improve your workbook organization for better, faster use
- Demonstrate the basics of nested functions
- Demonstrate better workbook design
Last updated/reviewed: March 17, 2024
(241) Reviews
(99 rating)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.
This was a good review of the Control Environment. It provided great explanations and examples.
The course did a nice job and explained important, relevant information in a manageable and easy-to- digest manner.
I would have liked a video with an explanation with examples. Also, I don't see an explanation of how an applicant is defined. Otherwise a helpful course.
Good review of less traditional balance sheet accounts and accounting.
Ethical issues are sometimes downrated, what is not correct. Great presentation.
Great refresher with good exercises and commentary
Virginia ethics course, it's required for CPAs and this format works
I found the course to be very high level and basic. The content covered material that would be found in a principles or intermediate accounting class. The references to using manual or paper ledgers seems outdated.
Love Blair's webinars! Definitely wish there were more available on Illumeo. He is one of my facotire presenters!
Honestly, I got more out of watching Ted Talks and YouTube videos ...
I especially appreciated the David Foster Wallace commencement speech at the end.
On often overlooked topic for those in the non-IT/cybersecurity sector. Great overview on important topics on handling and preventing security threats.
Interesting and informative course with relevant information to understand the controllership function. Easy to follow and understand.
Direct, easy to understand slides and notes make this a valuable course.
Thank you for providing an informative opportunity to complete my ethics cpe requirement.
Excellent! This will lead better comunication. White spaces are realy an important.
Good material and overview of SAAS metrics. Sound was a little low could be increased but otherwise good
This was an informative primer on IT General Controls and was easy to understand.
Helpful information about automating reports in Excel. Recommend.
Great deal of practical solutions to enhancing executive presence. Solid examples by the instructors.
Informative course that opened my mind up to pricing strategy.
Great course, thank you for passing along your excel knowledge. I enjoyed the short, but thorough courses on how to really utilize the workbook.
Amazing explanation. Very clear articulation.
Very good information given in this course, and given in a way that was very informative, not too wordy, and easy to understand.
Another amazing course of the spreadsheet Jedi Lenny Wu. Thanks for sharing your valuable knowledge!
The session flowed quickly, and smoothly. The supporting documentation is a keeper.
Very straight-forward explaination which made the lecture easy to follow.
Great content! Lots of takeaways that can be applied immediately.
It was great to review and/or learn anew these important topics.
Very well done explaining job costs. I have been in manufacturing for 30+ years and highly recommend this to anyone just entering this sector.
Generally good advices and I hope the course can add more real life examples to support the theoretical system.
This course does not provide reference slides. It is also outdated with most information based on 2017-2018 tax years. Lastly, the final exam is riddled with typos, which makes the questions confusing.
I liked the case study examples. Otherwise the material is very dry.
Good written material and fair questions on the exam.
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).
Excellent way of presenting the course in an effective way
I really enjoyed this course, examples were practical and realistic.
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.
Excellent course lead by an effective instructor. Great content.
I love this XL guy. He's got great slides and always takes the time to explain them properly.
Excellent course. Lynn is one of my favorite authors here, she is very clear and easy to understand. Her webinars provide great examples and explanations. She is very knowledgable and provides useful information. The course covers important issues, and it gives a good base on how to approach ethics in the business environment.
The instructor makes the material easy to understand and remember.
Insightful commentary with real world, attainable, objectives
The hands-on application of regression analysis, though simplified, was helpful in understanding how to interpret the results
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.
Ethics must be 'top of mind' for all employees. This course provides guidance to help make this so.
Helpful information on those pesky error messages that we tend to live with rather than fix.
This course provides a good overall view of what composes ethics and what influences it within an organization
Really helpful to see the side-by-side presentation with Formula based reports vs Pivot table reports
great course for definitions and basic understanding of forensic accounting
great class, easy to use, material presented well, very organized, key points listed for every subject
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.
It is a very good course. I strongly recommend. It shows what CPAs need to know in business. Easy to understand.
Very good detailed summary of all aspects of the new COSO framework.
Good discussion on recognizing revenue under the new revenue standard.
I would have liked to have more examples of different kinds of leases.
Appreciate the thorough review, especially the foray into graphics.
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 for ratio analysis, very well presented
Comprehensive overview with detailed steps to a good fraud mitigation program. Instructor laid out what was to be covered and then covered it.
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?"
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.
Great instructor and delivery. Enjoyed the material and all examples.
Course materials would be more effective with powerpoint slides. Course duration could be shortened to 1 hour.
Good overview of ethics with current examples and very actionable suggestions that can be implemented in most organizations.
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.
Thank you very much. very good introduction to new revenue recognition. next time I hope to have more examples.
Excellent course!! Definitely one of the best offers for it value and how is explained each of these courses.
Good topic.
Learned some very useful tips
Helpful
Excellent summary of SEC reporting. Highly recommend to reinforce current understanding
Lots of great ideas for someone who is good at Excel but wants guidance on automated dashboard reporting.
Awesome
This was a good refresher course on CVP
Slides very helpful. Information very thorough.
This course is great for anyone looking to build a foundation on basics of workbook design.
Very informative!
It's an interesting subject especially for young professionals. The exam was quite a challenge.
Excellent, great summary
Do not want to go into upper management.
I would have given a much higher rating if this course showed some actual examples, but there were none.
Some excellent tips in this course
Very helpful
Great simple explanation of concepts on worksheet design.
Good information. Would like to have more detail on slides so that can use later when setting up spreadsheets.
Great learning
pretty good course, a little dry for my taste
Very informative.
Great and informative course! Thanks
Kind of slow moving
The detailed explanation followed by an example helps to understand and learn the material.
liked the convenience; it was good information
Nice
Very thorough and insightful.
Great course. The features chosen to discuss are especially useful.
.
Very useful.
Excellent course
Great course, great instructor
Good overview.
The exam answer choices should be rephrased
Excellent refresher course.
Lots of information.
Good
I would like to know what I got right and wrong on the exam.
Excellent!
Now I use the sub total function.
Very helpful
Great course!
Great class will implement the information on subtotal tomorrow will look for more of these
interesting info
Great course. Makes you think. Very well taught.
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.
Good course!
I appreciated that the course talked about CPAs in business not just in public accounting.
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?
Very helpful. Learned many new techniques for building reports.
Some helpful pointers in time management.
I liked that I learned something
Good course but needs to be updated for 2015-2016 changes.
Quick guide to organise and stop distractions
Effective information that can be used in the workplace.
More information on analytics to identify misuse.
Basic tips but useful
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.
Great course. My favorite part was having the first 4 steps of the change management process described as "thawing the organization for change". Lots of practical ideas for how to improve the close process. This course would benefit finance leaders, managers, process owners, and change managers.
Great speaker, very informative.
Great tips!
I truly enjoyed the review, it included advance and basic information where anyone from any point could gain some new information and follow along.
Helpful
This was a very well organized training of excel. I use excel all the time but I leaned a few tricks and found out why I should be using others. Great!
Informative class.
The training is easy to understand because jargon are limited by the trainer.
One of the best Illumeo classes I've taken.
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.
very clear
Excellent course
Enjoyed it.
excellent information. easy to follow.
Liked the comparing and contrasting with the multiple versions of Excel
Barry needs more energy. What he says is really interesting. But his monotone presentation even had him yawning (I actually heard him yawn twice). The exam (CPE for me) was unpleasant as well. Maybe that was the intent.
good tips
Great tips, love the instructor very clear explanantions and examples
good reminders and tips for macros
Very detailed and easy to follow.
Excellent overview about risks and things to look into.
Enthusiastic and clear instruction. Some of the data tested in quiz was not covered during instruction.
Great course!
Very good tips
Very informative information
Great tools to improve efficiency when using Excel. The skinny row is a great example of this, and has so many applications!
Good!
Great course!
It was a great review. Hope to hear more from this instructor.
Good overview of basic accounting principles
Its great. Will ook into more classes like this.
Well written. Powerpoint needs polishing.
A bit dry but did have some useful material.
very clear and easy to understand.
I really enjoyed this course and learned a lot of new Excel tips! The excel worksheets were good to do along with the video. The quiz and final exam were not really related to the course material, but the questions weren't that difficult if you know how Excel works. I really enjoyed this course, and I have already implemented these tips into my daily work.
Spent too much time on simple functions like EOMonth (the worst function ever).
Several points I did not know
Some very helpful tricks and tips
Good course. Informative and interesting.
I liked the Subtotal and Skinny Row function
Good pace and content. Hate to say it, but Blair's voice was a bit high pitched.
Easy, useful tips for excel workbooks - anyone building workbooks could use this course.
Good class, very useful
Good background on SEC
excellent refresher
Good material but monotone delivery makes it difficult to focus.
easy to understand, difficult to hear on certain ear buds
I liked the instructor's delivery and enthusiasm for the material.
Thanks for going into the Due Diligence process. Other podcasts and presentations have only focused on the pitch.
Great material. Too fast to follow at times.
A great starting point in learning Quickbooks
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.
This is graded as a beginner course so I almost skipped it. I am glad I took the course. While I knew a lot of the material, I like the two chapters on workbook organization very much and realized afterward that I could improve a few Excel habits like keeping data and reports on separate worksheets religiously.
Blair Cook is awesome!
A common sense reminder.
It will be great to include all worksheets for all examples.
Excellent
Mr. Turner demonstrated a comprehensive budgeting solution in Excel which could work well if it is monitored and managed carefully.
It was suggested that I take this course, but after completing it, I don't think I was the intended audience.
great course!
a lot are self explanatory
good course
This course was excellent!
Very good course. I particularly appreciate the weight given to emphasizing change management practices and preparing the company for the change - too often this is missed and, as his metrics show, the outcomes are weak.
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.
Insightful course but the lessons are a little long and draggy at some points
Very helpful review for intermediate user!
material to reivew more than once to understand the logic is interesting
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.
Very informative
welld done, great pointers for trouble shooting and utilizing excel's more recent adjustments
I liked the excel workbooks provided to follow along with the presentation. This is a great resource for someone with some understanding of excel but probably not for a beginner.
Very good class
Clear and organized presentation; I especailly like the sample/exercise on the topics/training
The course was very good and provided helpful tips to become more efficient.
Thanks a lot. I found it helpful and relevant.
Good intro to Excel/refresher of some Excel basics. Lot of it was pretty self-explanatory, but there is probably a thing or two that everyone can pick up from this course. Recommend for everyone open to learning some basic best practices for using Excel.
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.
The information is good and useful.
I found everything in this course to be beneficial. I was really surprised at how easy the data validation could be when naming a selection of data.
The course was excellent. It met my expectations.
Very efficient topic coverage; like the introduction of topics so that it was easy to know whether items covered were familiar or new.
Excellent course in reviewing the basics for IT Finance. Great overview of what's important for an IT organization.
Great presentation. Helpful content and examples. Ready for Volume 2!
I was happy to learn new techniques that I can apply in my daily work. A lot of the content feels like common sense approaches.
Great tips and advice. The segments make it easy to do in smaller increments. The technology worked well.
Expert instructor with excellent presentation flow and engaging style.
Excellent review material. Thoroughly explained and easily understood.
Really enjoyed the course. Covered the material well with the incorporation of examples.
Interesting primer for a non-IA person.
Easy learning and well explained.Worth learning.
Great timesaving tips! I learned more useful information in this one hour than in any other class I've taken. The entire hour was packed with helpful tips. Thank you.
This course provided more in-depth and hands on job information as compared to the COSO series.
The course met its objectives
Stats are great. Maybe add some real life cases to the course to make it perfect.
Once again Mr. Lenning provides clear understanding.
I liked how detailed the course was. By providing examples that we could walk through, it made it a lot easier to understand the excel training I was learning. However, I felt the walk-through did move a little fast and at times I felt myself constantly having to pause and back up to make sure I was getting everything!
I had no prior knowledge of Quickbooks but the course was still easy to follow
covers aspect well with good examples
Its really fantastic and useful. I am using Excel for almost 17 years but never knew that SUBTOTAL has so many advantages compared to SUM function. Thanks a lot for the knowledge sharing.
Jeff delivers a structured, well designed course which are easily followed. His clear and its set at the correct pace.
Very helfpful for future financing avenues and IPO considerations.
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.
Contains simple tips to use immediately
Again - great tools for improving Excel skills. I will use these a lot!
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.
Very helpful.
Ask the instructor a question about this lesson