Instructor for this course
more
Enrolled:
672
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 (324 ratings)Reviews

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
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!
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
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
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
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.
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.
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.
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!
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.
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.
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.
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
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
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
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!
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
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
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 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
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!
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
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
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!
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
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
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
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
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
Very efficient topic coverage; like the introduction of topics so that it was easy to know whether items covered were familiar or new.
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.
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!
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!
4
Anonymous Author
Very informative. I have some experience, yet not at this level, yet i understood the instructions....good information
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
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.
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 helpful Excel tips and techniques. I really enjoy courses by this author, very useful and fun to watch.
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
As advanced an Excel user as I consider myself, I still learned a handful of new and very useful tools.
5
Member's Profile
I feel I now have fundamental guidance for creating financial modeling with excel. thank you very much
5
Anonymous Author
I thought I was good but this course taught me a thing or three - especially SUBTOTAL and Cell Style
5
Anonymous Author
Good tips. I'll be examining my frequently used workbooks to find ways to incorporate these tips.
5
Anonymous Author
Very well organized course. Very useable tips that will improve the workbooks for any Excel users
5
Member's Profile
Great class will implement the information on subtotal tomorrow will look for more of these
3
Anonymous Author
It takes a little too long to explain pretty simple concepts like skinny row or better summing.
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
Very helpful. Many reminders of info we have learned before, but some new tips. Great course.
5
Member's Profile
great course! It tells me the bigger picture that I was weak at designing the excel workbook.
5
Anonymous Author
Clear and organized presentation; I especailly like the sample/exercise on the topics/training
5
Anonymous Author
Great clarity in information! Learned several time-saving techniques. Fantastic instructor!
5
Member's Profile
Excellent Instructor, I have learned many of the additional features that excel has to offer.
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
Member's Profile
Another good course. I am really enjoying them and really learning a lot. Good work, Jeff!
5
Member's Profile
The overall guidelines to standardize workbooks and make them more efficient was helpful.
Anonymous Author
great techniques taught in this course. Instructor is upbeat but a little fast at times!
4
Member's Profile
Good content, easy to understand. Module "Workbook Design Principles" would not load.
5
Member's Profile
Got a little silly at the beginning, but Mr. Lenning is clear and to the point again!
5
Member's Profile
I was surprised how much useful information I learned from a 1 hr course. Thank YOU!
5
Anonymous Author
Each course I'm learning a nugget I can apply right away, and I'm an advanced user!
4
Anonymous Author
It was clear and direct to the point. Plus the instructor gives prompt responses.
5
Member's Profile
Great course. I've been searching for a course that discusses good design ideas.
4
Member's Profile
I really enjoy Jeff's enthusiasm for the lessons. His "bam" quotes are the best.
5
Member's Profile
Jeff is an excellent presenter who makes technical concepts easy to understand.
5
Member's Profile
The information presented is easy to understand. The examples are very helpful.
5
Anonymous Author
Great course. Learned some excellent techniques to improve workbook efficiency.
5
Member's Profile
The course was very good and provided helpful tips to become more efficient.
5
Anonymous Author
The training is easy to understand because jargon are limited by the trainer.
5
Anonymous Author
Great intro course to spreadsheet design - he hits all of the major points.
4
Anonymous Author
Liked the concepts for workbook organization and the error check sheet.
5
Anonymous Author
Expert instructor with excellent presentation flow and engaging style.
5
Anonymous Author
Great presentation. Helpful content and examples. Ready for Volume 2!
5
Member's Profile
Great tips, love the instructor very clear explanantions and examples
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 useful topics covered. Also liked the presenter's delivery.
5
Anonymous Author
ErrorChk worksheet was interesting new concept for me. Good tip!
5
Member's Profile
Always has great ideas. A shortcut cheat sheet would be helpful.
4
Anonymous Author
Definitely excel beginners would get the most from this course.
5
Member's Profile
Great class! Very helpful for all but beginning Excel users!
4
Anonymous Author
It will be great to include all worksheets for all examples.
5
Anonymous Author
Great functions / tools. My work will be easier from now on.
5
Member's Profile
Common sense features that are unusually smart! Great stuff
5
Member's Profile
Great simple explanation of concepts on worksheet design.
4
Anonymous Author
A lot of great design tips that are easy to incorporate.
4
Member's Profile
Useful information that I will apply to daily functions
5
Member's Profile
Great course! Pleasant classes even for advanced users.
5
Member's Profile
Very informative and can really be used in my reports.
5
Member's Profile
Very good tips. Presentation was a bit entertaining.
5
Member's Profile
Thanks for making Excel fun and interesting to learn.
5
Member's Profile
Fast and useful - love all the tips in the course.
5
Member's Profile
Very helpful skills for improving excel efficiency.
5
Nice course even for an Excel power user. Thanks
5
Anonymous Author
Easy learning and well explained.Worth learning.
5
Anonymous Author
Its great. Will ook into more classes like this.
5
Member's Profile
Good intro and refresher for experienced users
4
Member's Profile
Good overview of how to organize data in Excel
4
Member's Profile
Course jumped around, but was still effective.
5
Anonymous Author
I liked the Subtotal and Skinny Row function
5
Member's Profile
Amazing course. Must take for accountants.
5
Member's Profile
Excel nerds like me will love this course.
5
Member's Profile
Good examples. Lots of ways to do a thing.
4
Anonymous Author
The SUBTOTAL alternative is a great tip!
5
Anonymous Author
Contains simple tips to use immediately
5
Member's Profile
A lot of helpful information and ideas
5
Anonymous Author
Very nice sample files to practice on.
3
Anonymous Author
covers aspect well with good examples
5
Member's Profile
Great class, very useful information.
5
Member's Profile
Very thorough and informative course!
5
Member's Profile
I learned a couple of useful tricks!
5
Anonymous Author
Very simple and easy to understand.
4
Anonymous Author
Very basic - good excel tips though.
4
Anonymous Author
The information is good and useful.
5
Member's Profile
Now I use the sub total function.
5
Member's Profile
very clear and easy to understand.
4
Anonymous Author
Some very helpful tricks and tips
5
Anonymous Author
Great presentation! very helpful
4
Anonymous Author
The course met its objectives
5
Member's Profile
great at illustrating the point
5
Member's Profile
Great course, great instructor
4
Anonymous Author
Several points I did not know
5
Member's Profile
Good course, great job Jeff!
Member's Profile
interesting presentation
Member's Profile
Good overview. New tips
5
Anonymous Author
Great, Good Presenter.
4
Member's Profile
Good tips and tricks
4
Member's Profile
Good course to have.
5
Anonymous Author
A very good course.
5
Anonymous Author
Great presentation!
5
Member's Profile
Learned good tips
5
Anonymous Author
Very helpful tips
4
Member's Profile
Very informative.
4
Anonymous Author
A bit fast pased
5
Anonymous Author
Very informative
4
Anonymous Author
Great overview.
5
Member's Profile
Great Course
5
Member's Profile
Well done!
5
Member's Profile
Very helpful
4
Anonymous Author
Very clear
2
Anonymous Author
very basic
5
Anonymous Author
Very good.
5
Anonymous Author
Excellent
5
Member's Profile
Helpful
5
Member's Profile
great

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