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

Expert Certifications

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.

Course Collections

This course is included in the following Course Collections:

Learning Objectives

  • 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

144 Reviews (329 ratings)Reviews

5
Member's Profile
Great simple explanation of concepts on worksheet design.
5
Member's Profile
Great course. I've been searching for a course that discusses good design ideas.
5
Member's Profile
Great course, great instructor
4
Member's Profile
Very informative.
5
Member's Profile
Great tips for designing workbooks and making them easier to use and maintain. Wish I had known this a long time ago.
5
Anonymous Author
Very useful topics covered. Also liked the presenter's delivery.
5
Anonymous Author
Really like the =Subtotal explanation. Very helpful and a time saver.
5
Member's Profile
Awesome and useful information that can be implemented tomorrow.
5
Anonymous Author
Very nice sample files to practice on.
5
Member's Profile
This was very helpful. It would be great to include a pdf of some of the info on the video.
4
Anonymous Author
Great overview.
5
Member's Profile
Now I use the sub total function.
5
Member's Profile
Great class will implement the information on subtotal tomorrow will look for more of these
5
Member's Profile
Thanks for making Excel fun and interesting to learn.
3
Member's Profile
interesting presentation
4
Member's Profile
Course jumped around, but was still effective.
5
Member's Profile
Jeff is an excellent presenter who makes technical concepts easy to understand.
5
Member's Profile
Amazing course. Must take for accountants.
4
Member's Profile
Good course to have.
5
Anonymous Author
Very good.
4
Anonymous Author
A lot of great design tips that are easy to incorporate.
4
Anonymous Author
Definitely excel beginners would get the most from this course.
5
Anonymous Author
Great functions / tools. My work will be easier from now on.
5
Member's Profile
I feel I now have fundamental guidance for creating financial modeling with excel. thank you very much
4
Member's Profile
Good tips and tricks
5
Anonymous Author
Each course I'm learning a nugget I can apply right away, and I'm an advanced user!
5
Member's Profile
The information presented is easy to understand. The examples are very helpful.
5
Member's Profile
The overall guidelines to standardize workbooks and make them more efficient was helpful.
5
Member's Profile
Made the key points to Excel efficiency clear and very teachable. Love all of the points made and look forward to implementing many immediately.
5
Member's Profile
Very thorough and informative course!
5
Anonymous Author
Very well organized course. Very useable tips that will improve the workbooks for any Excel users
5
Member's Profile
Excel nerds like me will love this course.
5
Member's Profile
Great course! Pleasant classes even for advanced users.
5
Member's Profile
Helpful
5
Member's Profile
Very helpful
5
Member's Profile
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!
4
Member's Profile
Good overview of how to organize data in Excel
5
Anonymous Author
The training is easy to understand because jargon are limited by the trainer.
5
Anonymous Author
Great presentation! very helpful
5
Member's Profile
A lot of helpful information and ideas
5
Anonymous Author
Great presentation!
5
Member's Profile
If, like me. you have picked up Excel through using it, but have not taken formal training, then this is for you.
5
Anonymous Author
Great course. Learned some excellent techniques to improve workbook efficiency.
3
Anonymous Author
This course is very helpful for those who are starting to use and manage Excel workbooks. It explains and gives many functions that are useful and easy to understand. This course can be considered as Excel 101.
2
Anonymous Author
very basic
5
Member's Profile
Very helpful Excel tips and techniques. I really enjoy courses by this author, very useful and fun to watch.
5
Member's Profile
great
5
Member's Profile
As advanced an Excel user as I consider myself, I still learned a handful of new and very useful tools.
5
Member's Profile
Common sense features that are unusually smart! Great stuff
5
Member's Profile
Good course, great job Jeff!
5
Anonymous Author
Great Beginner itinerary - I've been using excel for years and was still able to take away a few gems and will incorporate them into my day-to-day work.
5
Member's Profile
Very helpful. Many reminders of info we have learned before, but some new tips. Great course.
5
Member's Profile
Great tips, love the instructor very clear explanantions and examples
5
Member's Profile
great at illustrating the point
4
Anonymous Author
The SUBTOTAL alternative is a great tip!
5
Anonymous Author
This was soo great. I am going to go back over it and back over it again. There is so much useful information and the examples and descriptions are great.
5
Member's Profile
Excellent Instructor, I have learned many of the additional features that excel has to offer.
5
Member's Profile
Great tools to improve efficiency when using Excel. The skinny row is a great example of this, and has so many applications!
4
Member's Profile
This course did an exceptional job in presenting the feature and demonstrating how to use them effectively.
5
Member's Profile
Very informative and can really be used in my reports.
5
Anonymous Author
Its great. Will ook into more classes like this.
5
Member's Profile
Well done!
4
Anonymous Author
Very clear
5
Member's Profile
very clear and easy to understand.
4
Member's Profile
I really enjoy Jeff's enthusiasm for the lessons. His "bam" quotes are the best.
4
Anonymous Author
Several points I did not know
5
Anonymous Author
A very good course.
4
Anonymous Author
Some very helpful tricks and tips
5
Member's Profile
Always has great ideas. A shortcut cheat sheet would be helpful.
5
Anonymous Author
I liked the Subtotal and Skinny Row function
4
Anonymous Author
A bit fast pased
3
Anonymous Author
great techniques taught in this course. Instructor is upbeat but a little fast at times!
5
Member's Profile
Great class, very useful information.
4
Member's Profile
Useful information that I will apply to daily functions
5
Anonymous Author
Good tips. I'll be examining my frequently used workbooks to find ways to incorporate these tips.
4
Member's Profile
Another good course. I am really enjoying them and really learning a lot. Good work, Jeff!
5
Member's Profile
Learned good tips
5
Anonymous Author
Great intro course to spreadsheet design - he hits all of the major points.
5
Member's Profile
I learned a couple of useful tricks!
5
Member's Profile
Great Course
5
Anonymous Author
Excellent course with loads of great tips for anyone who wants to create more efficient workbooks. The content was effectively delivered by a qualified instructor (thanks, Jeff...I will definitely enroll in more of your courses). I am able to immediately implement what I learned in this course.
5
Member's Profile
Very good tips. Presentation was a bit entertaining.
5
Member's Profile
I was surprised how much useful information I learned from a 1 hr course. Thank YOU!
5
Member's Profile
Had helpful tips that were simple to implement. Can improve the design of a workbook without extensive effort. Anyone who regularly builds workbooks could use this course.
5
Anonymous Author
Great, Good Presenter.
5
Anonymous Author
Great clarity in information! Learned several time-saving techniques. Fantastic instructor!
4
Member's Profile
Good content, easy to understand. Module "Workbook Design Principles" would not load.
4
Member's Profile
I will be using several of these techniques in my Excel Workbooks in the future. Go Sub-total!
5
Member's Profile
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.
5
Member's Profile
Very helpful skills for improving excel efficiency.
4
Anonymous Author
Very basic - good excel tips though.
4
Anonymous Author
It will be great to include all worksheets for all examples.
4
Anonymous Author
Liked the concepts for workbook organization and the error check sheet.
3
Member's Profile
Good overview. New tips
5
Member's Profile
Mr. Lenning does a very good job explaining the concepts and he also explains why they are important. If you want to build Excel workbooks that are useful and efficient, these are excellent rules to follow.
5
Anonymous Author
Excellent
5
Member's Profile
great course! It tells me the bigger picture that I was weak at designing the excel workbook.
5
Anonymous Author
Very helpful tips
5
Member's Profile
I knew about many of these topics in this lesson. An example was the SUBTOTAL function, but I was not aware of the benefits of the SUBTOTAL function. It will be used much more frequently now I know how to use it. I also liked the Workbook and Worksheet organization lessons. Plus the flat file tip for data. These tips are very applicable to my current projects. Thank you!
4
Member's Profile
The concepts in this course are fundamental to someone who regularly works in Excel. I like the focus on concepts, rather than just going over a list of functions.
5
Member's Profile
Love your courses. Sadly, I may be running out of any more to take. Do recommend you bring up the pitfalls of pivot tables and steer people away from them. Likewise with lookups, as matching against indexes is more powerful. I don't see tables used in practice. Tables mitigate the weakness of lookup functions, but specifying a named range isn't necessary when you just use whole columns or rows in data ranges. Also, Subtotals change when the data are filtered, which can create false results and is such a scary potential that I never use subtotals. Really love your separation of data from output reporting, totals on top, consistent formulas top to bottom. How I've preached these things myself.
5
Member's Profile
Good examples. Lots of ways to do a thing.
5
Member's Profile
Pleasantly surprised that this course provided quite a few good tips for workbook efficiency, even to a seasoned user of Excel. I will be implementing some of these in my workbooks in the future
5
Anonymous Author
Excellent, excellent course!!! I build huge spreadsheets and will put this items discussed to use immediately and often. Can't wait to get into more Excel courses!
5
Anonymous Author
Very informative
5
Member's Profile
Good intro and refresher for experienced users
3
Anonymous Author
It takes a little too long to explain pretty simple concepts like skinny row or better summing.
5
Anonymous Author
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.
5
Anonymous Author
Clear and organized presentation; I especailly like the sample/exercise on the topics/training
5
Anonymous Author
For a long time excel user, I learned a few efficient techniques and organizational guidelines that I will put into practice immediately
5
Member's Profile
The course was very good and provided helpful tips to become more efficient.
5
Anonymous Author
ErrorChk worksheet was interesting new concept for me. Good tip!
5
Anonymous Author
Very simple and easy to understand.
4
Member's Profile
Overall, I thought the course was excellent. I've been an Excel user for years and Jeff pointed out several simple ways to increase my effectiveness. Also, Jeff is a very good presenter integrating humor into the presentation.
4
Anonymous Author
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.
5
Member's Profile
This is the first Jeff Lenning class I took. I didn't realize that it covered later chapters in his book; it would have been nice to know that so I could have taken his courses in order. I also really liked Jeff's enthusiasm!
4
Anonymous Author
The information is good and useful.
5
Member's Profile
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.
5
Member's Profile
Great class! Very helpful for all but beginning Excel users!
5
Member's Profile
Very efficient topic coverage; like the introduction of topics so that it was easy to know whether items covered were familiar or new.
4
Anonymous Author
Very informative. I have some experience, yet not at this level, yet i understood the instructions....good information
5
Anonymous Author
Great presentation. Helpful content and examples. Ready for Volume 2!
4
Member's Profile
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.
4
Anonymous Author
Great tips and advice. The segments make it easy to do in smaller increments. The technology worked well.
5
Member's Profile
There were great tips in here! I'm an intermediate excel user at best, so this course provided a lot of useful lessons!
5
Anonymous Author
Expert instructor with excellent presentation flow and engaging style.
5
Anonymous Author
Easy learning and well explained.Worth learning.
5
Anonymous Author
I thought I was good but this course taught me a thing or three - especially SUBTOTAL and Cell Style
4
Anonymous Author
It was clear and direct to the point. Plus the instructor gives prompt responses.
5
Anonymous Author
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.
5
Member's Profile
Nice. Well presented - fast and easy and of course, there's never a dull moment. Kudos to the lecturer. I learned new techniques and so excited to apply these on my working tables. Great job!
4
Anonymous Author
The course met its objectives
5
Anonymous Author
Course provided excellent suggestions for documenting and making excel workbooks more efficient as well as providing excellent guides for future updates and understanding of that same workbook.
5
Member's Profile
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!
5
Anonymous Author
Jeff Lenning is the best presenter on Excel topics of any Excel course I've ever had! Kudos for keeping it interesting, moving at a good pace and showing this long-time user some better options. That said, this course took longer than 1 hour, so should have been worth more credits.
5
Member's Profile
Got a little silly at the beginning, but Mr. Lenning is clear and to the point again!
5
Nice course even for an Excel power user. Thanks
3
Anonymous Author
covers aspect well with good examples
4
Member's Profile
Skills for better workbook design was very enlightening. I struggled with data validation discussed under highlight input cells but I hope this will be clarified further in preceding courses.
5
Member's Profile
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.
5
Member's Profile
Fast and useful - love all the tips in the course.
5
Anonymous Author
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.
5
Anonymous Author
Contains simple tips to use immediately
4
Anonymous Author
Lots of great and useful stuff in this course. I have been using the Skinny Row idea for awhile now and it really does help when you have to unexpectedly insert a new row into an existing table.

Prerequisites

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

Education Provider Information

Company:
Illumeo, Inc., 75 East Santa Clara St., Suite 1215, San Jose, CA 95113
Contact:
For more information regarding this course, including complaint and cancellation policies, please contact our offices at (408) 400- 3993 ext. 106, or send an e-mail to .
Course Syllabus
INTRODUCTION AND OVERVIEW
Training
  7:57Better Summing
  7:33Skinny Row
  4:09Hide Worksheets
  6:20Highlight Input Cells
  9:26Workbook Organization
  10:31Worksheet Organization
  5:13Nested Functions
  5:26Selection Groups
  7:08Workbook Design Principles
CONTINUOUS PLAY
SUPPORTING MATERIALS
  ZIP FILEWorksheets
  PDFExcel Training: Skills for Better Workbook Design Glossary/Index
REVIEW & TEST
  quizReview Questions
 examFinal Exam