To Access This Course:
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: October 7, 2018
24 Reviews (96 ratings)Reviews
Homer Hernandez
(Owner at Homer Hernandez CPA)
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.
Sergey Bulychev
(internal auditor at Transneft Finance LLC)
Просто фантастический курс по Excel! После него вы становитесь по-настоящему продвинутым пользователем электронных таблиц от Microsoft! Автору - респект и уважуха!
Nikita Patel
(Consultant at DLC Group)
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.
Anonymous
()
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.
Sheilah Brown
(Controller at SMB LTC)
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.
Anonymous
(DIRECTOR)
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.
Julie Hammeras CPA
(Director,Finance (West Region) at Liberty Utilities)
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.
Kayla Garbison
(Account Executive at Yelp)
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.
Anonymous
(Fund Accountant)
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.
Alex Ledin
(Financial Analyst at Lockheed Martin Co.)
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.
Anonymous
(Senior Accounting Analyst)
Thoroughly enjoyed the detailed analysis of excel functions and shortcuts. Excel is such an underutilized tool for data analytics.
Christine Seres
(Senior Associate at RSM)
More time should be allocated to this course if the individual is attempting to complete the exercises as part of their training.
Sean Kennedy
(Sr. Auditor at HomeTrust Bank)
Very good course. I know A LOT about Excel, and still found a couple of nuggets in there that I was not aware of.
Shaila Shankar
( at Minted)
This course was outstanding in helping boost my efficiency and knowledge of excel functionality.
JOSH Aharonoff
( at Graphite Financial)
Excellent course and refresher on some important excel functions - thank for all the help!
John Russell
( at The Master's University and Seminar..)
Good material that is well presented. The supporting materials are clear and helpful.
Anonymous
()
high again its me...love excel hope you do too. this course was fun and challenging
Andrew Anderson, CPA
(Principal Financial Analyst at Rio Tinto)
Great training and really useful tips to improve workbook design and function.
Anonymous
(N/A)
I learned a lot of new shortcuts that have advanced my knowledge of Excel.
Makarand Vaidya
(Senior Internal Auditor at Latitude12 Pty Ltd)
Helped me understand a lot of new ways of working efficiently in Excel
Anonymous
(Specialty Controller)
There were some great shortcuts that will help to improve my workflow.
Sally Fonstein
(Corp Controller at Ustream, Inc.)
Really helpful course with relevant information to use every day.
Anonymous
()
one of the best excel courses I have seen, very useful.
Anonymous
()
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 .