Instructor for this course
more

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 guides you through Excel and enables you to boost your productivity and save your most valuable resource: time. We start by exploring the top 5 productivity boosting shortcuts. Next, we'll look at how we can improve spreadsheet design, boost our proficiency with additional shortcuts, master the fundamental functions, and finally we'll make sure our spreadsheets are error free. This course is the primer to Excel you didn't know you needed!

Learning Objectives

  • Identify 5 top productivity shortcuts in MS Excel
  • Utilize Excel data tables and named ranges in excel
  • Demonstrate the use of conditional formatting and 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 and better workbook design
  • 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
  • Be able to trap errors with IFERROR function and create indented report labels
  • Demonstrate multiple uses for the IF function
  • Enact multi-column comparisons with COUNTIFS
  • Be able to create indented report labels
  • Articulate tactics for Excel data validation and reporting
  • Improve error checking
  • Implement concatenation basics
  • Build your own Date with the Date function
Last updated/reviewed: November 8, 2019

59 Reviews (208 ratings)Reviews

5
Anonymous Author
Great course and information. I like the instructor despite some cheesy moments. Suggestion to all my coworkers.
5
Member's Profile
I use this course and the materials CONSTANTLY in my work and it has helped my career dramatically. As long as you work hard and try, you can do anything. The people at work think I’m a literal wizard because of my excel skills which have been amped up due to this course. I have done this 5 hour course at least 5 times in order to practice and drill in the concepts. I want to work for this company!
4
Member's Profile
I liked the real world examples. Workbook design tips will give me and my supervisor more confidence. The use of lists or drop downs will eliminate errors and wasted time.The course not only shows function syntax but also its use in worksheets. Also the tips will help me become much more efficient. I will always use the subtotal function and conditional formatting to spot errors.
4
Anonymous Author
This course is very effective and easy to follow. Jeff does a great job of walking you through excel shortcuts, formulas, organizational techniques that is sure to increase your job productivity. I would recommend this course to those who work with excel often in their jobs. I look forward to incorporating these skills in my day to day use.
5
Member's Profile
Просто фантастический курс по Excel! После него вы становитесь по-настоящему продвинутым пользователем электронных таблиц от Microsoft! Автору - респект и уважуха!
4
Anonymous Author
I consider myself to be a pretty good Excel user, and I learned a few new tricks and ways to be more efficient. This is a long course, and I would suggest going through the different examples. Only problem I had, was that I couldn't seem to get all of the Excel templates to open.
5
Anonymous Author
Several of the courses included in this package are offered a la carte. You are well advised to take them all in sequence using this course series. Jeff is a great teacher with top notch materials and delivery. I can't recommend his classes, any of them, highly enough.
5
Member's Profile
I really enjoyed this course! I am an intermediate Excel user and found some of these tips and tricks to be tools I can get good use of in my day-to-day job. I wish I had some of the shortcuts covered in the videos in a handout that I can refer to later.
4
Anonymous Author
All of the information is good and relevant with good examples. However, this is more information than a 5 hour course should have. There really needed to be time to practice in between. It should have had more credits or more time spent on each segment.
5
Member's Profile
My only dislike is that the slides are not available for download. The spreadsheets are very helpful, but don't show the overall concept that is being taught. Together they are very powerful in showing how to use Excel functions to make your job easier.
4
Anonymous Author
It is interesting and contains very good information, but the only materials found in this course where only for the first Chapter - Excel Training: 5 Top Productivity Boosting Shortcuts" I wish all of the chapters had the material presented.
5
Anonymous Author
I highly recommend this course. I am a heavy user of excel but I was surprised that I have learned various tips, shortcuts and formulas that I don't use today. The examples provided are helpful and the instructor is very clear and engaging.
4
Member's Profile
There is a lot of information presented in this long course. All of it was great information, but I think it was too much to be presented in one course. I believe it would be better served to be broken out into several courses.
5
Member's Profile
Jeff Lenning is a great teacher and getting to do the exercises really helps keep the concepts easier to remember. He talks a little too fast, so it was great to be able to pause and work the exercises as he goes through them.
5
Member's Profile
Very informative and useful! These tips and tricks are things I can implement every day in my workplace. I definitely suggest doing the workbooks along with the instructor to ensure each objective is learned.
5
Anonymous Author
I consider myself an advanced Excel user and there were many helpful tips in this course to make me think about the way I create workbooks and to consider alternatives to the way I approach certain tasks.
5
Anonymous Author
Although the course is oriented on recurring tasks (like, accounting reports preparation), many techniques explained here are useful for other purposes, e.g. for data analysis. Overall, great course.
5
Member's Profile
A lot of information but extremely useful. Well put together, neatly explained, and the lesson workbooks make for a excellent resource. Especially liked the sections on dynamic namig etc.
5
Member's Profile
A treasure trove. I'm an advanced Excel user (pivots, macros, and VB) and I learned stuff... so you will too. One of the best courses that I've taken (for CPA CPE) on Illumeo.
5
Anonymous Author
Very informative and very practical ways to use Excel to increase efficiency in work. As well as going over what Excel functions work best for different scenarios.
5
Member's Profile
A lot of great information in this course. I'm looking forward to putting it into practice in my daily life and simplifying our reporting processes.
4
Member's Profile
A lot of content, might have been easier to grasp in smaller groups. However, I do enjoy this instructor and will continue taking courses from him.
5
Anonymous Author
This was one of the best courses I took - I really liked the fact that you could follow along with the instructor using the worksheets provided!
5
Member's Profile
This is a great course! Only drawback was I could not get the supporting documents to download. The content was, however, incredibly useful!
5
Member's Profile
Great content. Great examples to work through. This was the longest 5.5hrs of CE in my life. Should be more hours. Very helpful indeed.
4
Anonymous Author
Thoroughly enjoyed the detailed analysis of excel functions and shortcuts. Excel is such an underutilized tool for data analytics.
4
Anonymous Author
Good course. I liked the instructor. The course could use some better support materials that I could save and use in the future.
5
Member's Profile
More time should be allocated to this course if the individual is attempting to complete the exercises as part of their training.
5
Anonymous Author
Great course. I learned a lot of Excel tips. Highly recommended even for those who believe themselves to be skilled Excel users.
5
Member's Profile
Excellent and pretty deep dive into some really useful functions and efficiency tips. Homework and samples are also very good.
4
Anonymous Author
I learned some new tips for using Excel. But maybe breaking this training up into a few sessions might be easier for the user.
5
Anonymous Author
This course was helpful and a good refresher. The shortcuts and keys demonstrated within this course is good for everyday use.
5
Member's Profile
I knew a lot of the presentation, but it's a great course because I learned some new techniques and wasn't a starter course.
4
Member's Profile
This is a very good course that took a retard like me about 5 days to get through. I'm astonished that it's worth 5.5 hrs.
5
Member's Profile
great overview of a BUNCH of excel tricks. I learned about match, index, and the and funtion. super helpful trick with F9
4
Anonymous Author
Good refresher course. Seems that we know all but, refresher courses like these bring us back to learning curve.
5
Member's Profile
Very good course. I know A LOT about Excel, and still found a couple of nuggets in there that I was not aware of.
5
Member's Profile
Great job. I would consider adding in time-lapse links for specific sections in the longer videos.
5
Member's Profile
This course was outstanding in helping boost my efficiency and knowledge of excel functionality.
4
Anonymous Author
Good course. Long, but does a good job of explaining excel functions, formulas, and shortcuts.
5
Member's Profile
Excellent course and refresher on some important excel functions - thank for all the help!
4
Member's Profile
Good material that is well presented. The supporting materials are clear and helpful.
3
Anonymous Author
high again its me...love excel hope you do too. this course was fun and challenging
5
Anonymous Author
The course was very helpful. I liked that it included a lot of practical exercises.
5
Member's Profile
Great training and really useful tips to improve workbook design and function.
4
Anonymous Author
I learned a lot of new shortcuts that have advanced my knowledge of Excel.
5
Member's Profile
very useful, and the author is good at the formula. and a lot of detail
4
Member's Profile
Helped me understand a lot of new ways of working efficiently in Excel
5
Anonymous Author
There were some great shortcuts that will help to improve my workflow.
4
Anonymous Author
Great overview of so many efficiency tips and tricks. Very helpful.
5
Anonymous Author
Very comprehensive and lots of good information for any level user.
5
Anonymous Author
Very helpful information for people in the accounting profession.
5
Member's Profile
Really helpful course with relevant information to use every day.
4
Anonymous Author
Great course! I would greatly recommend to accountant colleagues.
5
Member's Profile
The answer spreadsheets were very helpful as a reference.
4
Anonymous Author
one of the best excel courses I have seen, very useful.
5
Anonymous Author
Great tools for Excel. Learned a ton. Thanks illumeo!
5
Anonymous Author
Very good tips for using excel. Useful to save time.
5
Anonymous Author
Very good excel tips and tricks; very helpful course

Prerequisites

Course Complexity: Intermediate

No Advanced Preparation or Prerequisites are needed for this course.

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 or send an e-mail to .
Course Syllabus
  45:25Excel Training: 5 Top Productivity Boosting Shortcuts
  1:03:46Excel Training: Skills for Better Workbook Design
  1:01:07Excel Training: Boosting Proficiency with Selected Shortcuts (PC version)
  49:56Excel Training: Mastering Fundamental Functions - IFERROR, IF, List Comparisons and more
  1:01:42Excel Training: Tips for Improving Data Validation, Error Checking, Reporting and Other Performance Obstructions
Supporting Materials
  ZIPExcellence in Excel Training Combined Supporting Materials
REVIEW AND TEST
  quizREVIEW QUESTIONS
 examFINAL EXAM