1.5 CPE 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 to boost your productivity and shave valuable time from repetitive tasks. You'll learn:
Selected Shortcuts
Keep your hands on your keyboard to improve your speed. This online Excel course explores 5 shortcuts that assist when writing formulas and functions. The Excel lesson includes F9, fill down and right, Ctrl+Home, row shortcuts and column shortcuts. It also follows up on a discussion from Volume 1 Chapter 6, and expands the utility of F2.
Conditional Summing Basics
Have you explored the conditional summing functions in Excel? The SUMIFS function is absolutely a game changer. This online Excel course introduces the multiple condition sum function SUMIFS. The Excel lesson works through the syntax of the function, and provides several practical examples so you can work hands-on.
Remove Duplicates
This online Excel course explores how to remove duplicate values from lists and tables. This Excel lesson demonstrates how to use the remove duplicates feature to generate a unique list of report labels.
Lookup Basics with VLOOKUP
Are you comfortable performing lookups in Excel? They are the keys that unlock significant efficiency in recurring-use workbooks. This online Excel course covers the cornerstone of all Excel lookup functions, VLOOKUP. This Excel lesson covers the function syntax, and provides numerous exercises so you can work hands-on to develop your skill.
Improve VLOOKUP with MATCH
This online Excel course demonstrates how to address a serious limitation of the VLOOKUP function. The VLOOKUP function will break when a user inserts a new column between the lookup and return columns. This Excel lesson explores the MATCH function, and illustrates how to use it to bypass this VLOOKUP limitation. We work through the syntax of the function, and provide several practical examples so you can work hands-on.
Improve VLOOKUP with TEXT and VALUE
This online Excel course addresses a serious limitation of the VLOOKUP function, the fact that equivalent values stored as different data types won't match. That is, the number 100 won't match 100 in the lookup range if stored as a text string. This lesson demonstrates how to bypass this limitation by using the TEXT and VALUE functions. We work through the syntax of the function, and provide several practical examples so you can work hands-on.
Moving Beyond VLOOKUP with INDEX
This online Excel course addresses a major limitation of the VLOOKUP function, the inability to go left. That is, the VLOOKUP function is not designed to return a value that lies to the left of the lookup column. This Excel lesson demonstrates how to bypass this limitation by using the INDEX function. We work through the syntax of the function, and provide several practical examples so you can work hands-on.
Course Series
This course is included in the following series:
5 CoursesJeff Lenning's Excellence in Excel Training
- Excel Shortcuts Training: 5 Top Productivity Boosting Shortcuts
- Excel Training: Skills for Better Workbook Design
- Excel Training: Boosting Proficiency with Selected Shortcuts (PC Version)
- Excel Training: Mastering Fundamental Functions - IFERROR, IF, List Comparisons and More
- Excel Training: Tips for Improving Data Validation, Error Checking, Reporting and Other Performance Obstructions
Learning Objectives
- 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
Last updated/reviewed: March 22, 2024
Included In Certifications
This course is included in the following Certification Programs:
9 CoursesExcel Certification
- Excel Shortcuts Training: 5 Top Productivity Boosting Shortcuts
- Excel Training: Skills for Better Workbook Design
- Excel Training: Boosting Proficiency with Selected Shortcuts (PC Version)
- Excel Training: Mastering Fundamental Functions - IFERROR, IF, List Comparisons and More
- Excel Training: Tips for Improving Data Validation, Error Checking, Reporting and Other Performance Obstructions
- PivotTable Essentials
- How to Use PivotTables instead of Formula-Based Reports
- PivotTable Conclusion and External Data Introduction
- Using PivotTables and PivotCharts to Prepare External Data
208 Reviews (620 ratings)
Reviews
Anonymous
(SOX Analyst)
Another excellent, informative course from this instructor. I was already familiar with Vlookup, but this course introduced me to quite a few workarounds that I was not aware of. The keyboard shortcuts were also useful. There are plenty of opportunities to practice and learn through experience in the workbooks, which helped me retain the information much more than simply listening to the lecture. I highly recommend the course to anyone that wants to improve their Excel skills.
Kenneth Oliven
(Alsip Finance Director & Government .. at Village of Alsip)
Once again, Jeff Lenning is clear in presenting sometimes difficult ideas. My only suggestion is that he glides over shortcuts that he has already taught rather than saying every step of what he is doing. For example, I remember double clicking the bottom right to fill down and F9 for seeing the value, but I do not remember the F key to use when he quickly scrolls through locking down cells or which key strokes to use when filling in the whole column for cell references.
Anonymous
(CPA)
This was a fantastic course. It seems that XLOOKUP has replaced VLOOKUP now, which invalidates some of the learning here. But I still found it beneficial to understand how these operation work, and I'm sure XLOOKUP will be quicker and easier to understand now that I've learned this. Hopefully Illumeo updates their courses to include a more recent video from this guy.
Go Tanaka
(Manager, Sales Strategy at Manulife)
VLOOKUP, HLOOKUP and INDEX/MATCH are outdated Excel functions that are no longer being used (have been superseded by XLOOKUP). This course needs to be updated or otherwise deleted. Illumeo should also choose a different course as their sample free trial because people would assume Illumeo contents are old and outdated if VLOOKUP is the first thing they see.
Anonymous
(Internal Audit Manager)
Awesome course! The pace of the lectures, explanations, and doing the practice sheets was awesome! Some great tips to work around VLOOKUP shortcomings, but I am going to force myself to use INDEX MATCH more as it seems more elegant and I have done tons of VLOOKUPs. I think this is one of those courses that could be very helpful to most people.
Jeff Klein
(Capital Programs and Business Analyst at National World War II Museum)
Very good course. I liked that the excel problem sets can be downloaded. Sometimes I missed seeing some of the keystrokes that are used because the cursor was off screen or the ctrl/function shortcuts were used. It took me about twice as long as the CPE hours indicated. I use excel everyday but don't use vlookups everyday.
Andy Birchett
(Print Operations Group Manager at Intuit)
Jeff knows his stuff and explains it really well. It's fast paced.I had to go in and out of it and it took a while. It's easier with an extension monitor, not a laptop. Give yourself time to figure out the differences on a mac vs. a PC. I like the worksheets as we go through and I plan to revisit and finish up.
Chuen Lam
(CFO at Timberbrook Investment Group)
This course is great. The tricks on the vlookup definitely will help to speed up my work. These are really great tips to help people to be more efficient with Excel on their daily work. The last part of the Index function is not explaining it very well. I have to re-watch the video a couple of time to get it.
tom granger
( at Washington Eductation Association)
good explanation of how a few formulas and shortcuts can be used to save time. I would give the excel courses taught by Ringstrom higher marks generally, especially since his explanations are more thorough, and because his reference materials are easier to understand / refer to over the long term.
Ezgi Ustundag
(Financial Analyst at Cisco LIFT)
Even though I considered myself proficient in lookups, I learned a ton about how to optimize my workbooks with lookup functions, particularly using the Index/Match combo. I am very glad I took the time to review this content - as I actually ended up learning a lot of new material!
Kelly Brazzell
(Manager at Intuit Inc.)
I liked the pacing of the course, it starts simple and builds to the most complex. By the time you get to the complex you feel ready for it. I had not taken an earlier course so I was lost on a few of the shortcuts that were heavily referenced, but that was a minor problem.
Anonymous
(CPA)
I'm not a fan of VLOOKUP, because if you state the column number and a column is added or deleted, you have to find every instance where you've referenced the table using VLOOKUP. Match/Index never has this problem, and you don't have to count how many columns there are.
Anonymous
()
The lecture offers very helpful tips to help increase the efficiency of using the excel. The lecture is also very organized and easy to follow. The exercise workbooks are extremely helpful to practice the skills mentioned in the lecture. Thank you!
Anonymous
(AVP, Corporate Tax Manager)
This was very helpful information, I liked the extra examples to practice through. I did think that some of the examples moved through very quickly, but appreciated the times where the instructor stopped and reviewed the formula before proceeding.
Warren Parker
(Senior Accounting Spec at SEIU)
Lenning does a great job of explaining what appear to be complicated functions in a relatively simple way. I'm very grateful for the "xx_answers" files as reminders of how to use these formulas when I'm still getting used to typing them out.
Anonymous
(Logistics Analyst)
I like that this course solved for very specific issues that are encountered by many Excel users. The course flowed very well and the worksheets provided the hands-on experience required to understand and retain the information presented.
Mike Heller
(Accounting - PE at R W Baird)
Great course, I had to pause frequently to make sure I understood the topic. He really flew through the formulas and it was difficult to keep up at times. Not a big problem but definitely changes the timing of the course for me
Gregg Gillaspy
(Owner at Gregg Gillaspy, CPA, CFP)
Excellent course! Very much to learn in Excel which can only be done through repetition. You will need to keep looking at all these tricks and shortcuts to remember them and know when to use them. Again...excellent course.
Anonymous
(Consultant)
Helped me solve some of the issues that I have with trying to manipulate data. The basics are the building blocks to preventing frustrations with errors that result in not understanding the limitations with these functions
Harris Kirson
(Senior Analyst at ACG Professionals)
The course was great because it mixed in both presentation and live examples, but the added value was going through each example twice in the actual excel sheet. It helped slow down the formulas and reinforce the concepts.
Anonymous
(Accountant)
Jeff Lenning is an interesting instructor to follow. Great examples and really explains the logic behind VLookup and Index/Match functions. I would recommend this course even though I don't use a lot of keyboard shortcuts.
Radya Cherkaoui
(Business Account Manager at Intuit Inc)
Course was excellent but notes need to be more comprehensive to ensure material is retained and can be referenced down the road. The video would be a helpful tool to keep to refer to or a deck that represents the video.
Anonymous
(Inventory Accounting Manager)
Jeff Lennings course are always interesting and create value in the knowledge learned. He provides great opportunities for updating your knowlegde and provides gems to carry forward to make using Excel more efficient.
Keith Johnson
(Director SOX Compliance at Waterjet Holdings)
I really appreciated the detailed explanations and alternate ways to use each of these more advanced Excel functions in spreadsheets, and the presenters application of each function to common business reports.
George Bilyeu
(Senior Accountant at Bluestreet Solutions, Inc.)
A lot of material - might have obtained a better understanding of the topics had they been broken down into smaller presentations. 1.5 hours is insufficient time for this course. Jeff was stellar as usual
Anonymous
(Lead Auditor)
Good course overall. The instructor is knowledgeable and interactive, but it was hard to follow and keep up at times because the instructor went a little too fast and used too many technical terms.
Kim Bosler, CPA
(Accountant, Corporate Accounting & R.. at Intuit)
I really liked the workarounds for the vlookup formula and learning about the Index formula. I will definitely start utilizing these methods in my spreadsheets. The worksheets were very helpful.
Anonymous
(CFO)
Definitely some very practical tips in this course. I use many of them regularly, and there is still some information in here that deepened my understanding of how/why to use these tools.
Anonymous
(Director)
This course is very useful and easy to understand. It clearly explains the importance as well as the functions of some shortcuts. It also give examples and exercises to explain further.
Carrie Mangas
(AP at NetSuite)
This was a great course. I likes that I could stop it at any time and review my material and that I could go back if I was unsure. The instructor took his time and explained everything.
Norman West
(Financial Manager at Lockheed Martin)
Mr. Lenning is a good instructor. His jokes are a little corny, but that's OK. I have already used some of his methods I learned in previous courses to improve my efficiency at work.
Michelle Mazepa
(Senior Business Consultant at Canadian Tire Corporation, Limited)
Lots of examples were provided, and I appreciated the extra credit exercises which were useful in practicing the concepts from this module along with others learned in previous models.
Larisa Demling
(Accounting Manager at Signature Flight Support)
A lot of great information in this course. As other reviewers have commented, it is fairly fast-paced. I had to stop the video lesson, try the formula and then continue on many times.
Anonymous
(-)
I can't recommend all of Jeff's classes highly enough. His enthusiasm is infectious, explanations are clear, examples make sense. The worksheets provide ample opportunity for practice.
Anonymous
(Unemployed)
Awesome. This course covered a lot and was informative with relevant examples. Mr. Lenning was very clear and thorough. There was a lot of very useful information. Very good course!
Robert Burnett
(Corporate Controller at Cyrq Energy LLC)
Jeff's approach in teaching Excel is very well done and easy to stay focus. He does a great job in showing examples and explaining the mechanics of what he is doing. Well done!
Amy Sell
(Franchise Elite Account Executive at Yelp)
I really liked the format of this course. Easy to follow and learn from. Thank you for your time. The v lookups make a lot more sense to me now and I feel confident using Excel.
Anonymous
(Wireless Data Analyst)
The overall lesson was valuable information and I currently use the basics of Vlookup in my everyday job duties; However, I did learn a lot about the other functions of Vlookup.
Anonymous
(Accounting Technician)
It was a great course. Though, there were too much information given in a short time. As the instructor said, it needs lots of practice and repetition to be more efficient.
Bruce Reed
(Chief Financial Officer at PracticeLink)
The format for these lessons is perfect for the intermediate user. The demonstrations of complex strings are demonstrated in steps, and "unpacks" each part. Great lessons!
Anonymous
(Attorney)
Having been away from Excel for a while I remembered how to use VLOOKUP but couldn't recall how to use INDEX/MATCH. The exercises really helped me to regain that knowhow.
Caitlyn Post
(Controller at OK4WD)
This course did a great job breaking down the different excel formulas in pieces. The examples provided were clear and helped demonstrate the subject matter efficiently.
Oxana Pelc
(Access Management Specialist at Hire Counsel @Facebook)
This course is very helpful for Excel users. The lessons learned make calculations of complex formulas easy, enhance basic reporting tool and increase productivity.
Rachael Smith
(Senior Internal Auditor at FJ Management)
I learned a ton, and will review what I have learned frequently - I have always wondered what index was...this course puts it into plain language for me. thank you.
Anonymous
(APS)
Informational and thorough seminar on the aspects of Vlookup's and the additional functions that are available for different scenario's for reporting functions.
Anonymous
(Director, Accounting)
I really enjoy Jeff Lenning as an instructor and this class did not disappoint. He goes through each topic step by step and his exercises reinforce the learning.
Leslie Harding-Ide
(Lead Wireless Data Analyst at Charter Communications)
It was both a very good class in respect to covering the material and sound explanations of how it worked. It was however, a lot to remember for one class.
Erin Carle
(Senior Energy Cost Management Analyst at Charter Communications)
I really enjoyed this course. Many of the shortcuts explained in this course are already proving to be very helpful in my daily tasks while using Excel.
Anonymous
(Analyst)
This instructor always does a really nice job within the Excel subject area he's presenting. His style and presentation works with all learning types.
Margaret Mueller
(Retired Controller at Self-employed)
Very good course. I'm a fairly experienced Excel user, and I definitely learned some very helpful tools. The materials will serve as good references.
Vickie Jackson
(Accounting Manager at NewStar Sourcing and Service)
A lot of information in this course. I sometimes felt the instructor was going too fast when explaining formulas. Overall an excellent course.
Zulfiqar Haider
(None at None)
Step by step escalation of of formula logic, I shunned use of index and match but instructor made it so easy and tempting, I would love to use again
Ted Feher
(Owner at Feher, PC (CPA))
If they are not on the tip of your tongue, this is a very good and quick summary of the many Excel shortcuts to keep in mind while doing your work.
Anonymous
(Staff Accountant)
Very informative and easy to follow. I've used excel for years but picked up some new tips and tricks. Would recommend to any level of expertise.
bruce quayle
(accountant at Charter Communications)
I loved this class. Very informative and very well received. I will be taking more classes with Excel University. Please keep these videos coming.
Jatin Talreja
(Financial Accounting Consultant at Wells Fargo)
Way Sumif function was explained was just awesome, even using vlook up with text and value function is something I will explore in my workbooks.
Anonymous
(Controller)
Excellent coverage of what could be a confusing subject. Great tips that will save time and solve problems. Recommended for would-be power users!
Sandra Heelan
(CPA, CFE, MBA at None)
Jeff is a great instructor with great worksheets that allow you to really learn the information. His presentation is engaging and effective!
Anonymous
(Sr. Business Risk Analyst)
Best excel class that I have taken so far! I actually learned something new and can actually used some of the examples in my own workbook.
Anonymous
(Sr. Accountant)
A great review of VLOOKUP and intro to power of INDEX with which I was not familiar. Love Jeff's presentation and hands on teaching method.
Anonymous
(Senior Manager)
Well explained and useful overview of the various excel functions. The worksheets and extra credit examples were very helpful to practice.
Mark Eastman
(Accountant at Self)
Great class. It should be worth double the CPE credits assigned. Lenning is right about doing all of the exercises - it helps tremendously.
William Neighbour
(Sr Analyst at Express Seed Company)
I prefer to use the newer xlookup function but I was fairly unfamiliar with the index and match functions - so this has been very helpful.
Anonymous
(Senior Accounting & Reporting An..)
The course was broken down in easy to digest pieces of information. I appreciate the extra exercises provided and the real-life examples.
Anonymous
(Independent Financial Consultant)
I have been a long time user of VLOOKUPS. However using them with Match, Index, Text and Value is new to me. Thanks for the great tips!
Anonymous
(Senior Accountant)
Excellent explanation of how lookups work, how build on each other, real life applications. Can start using several of these lookups now.
John Watkins
( at GSMS Inc)
I liked the descriptions of how to get vlookups to be more automated.. Good review of the index and match functions as well.
Thanks
Neal LeBlanc
(Senior Controller at Browne Consulting Group)
Great training through out to learn about more advanced excel equations. It simplified the index match function to be easily accessible
Anonymous
(Accountant)
The index and match learned in this class has really changed how I complete many of my tasks. I really appreciate the explanations.
Lucas Kysely
( at Edcetera)
I’ve been using Excel for a long time, but I didn’t realize that F2 can toggle the way you are editing a cell. Very interesting.
Whitney Purinton
( at Lowe USA)
This course is fast paced, but the instructor keeps you focused with the excellent examples. Another great course by Jeff Lenning!
Anonymous
(Treasury Director)
Great speaker, easy to understand, and valuable information I can use on a daily basis as an accountant working with lots of data!
Nick Wright
( at WCF Insurance)
Easy to use, great content, cost beneficial with tremendous center of knowledge sharing and access to great experts to learn from.
Anonymous
(Finance Director)
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.
Anonymous
(Financial Reporting Manager)
Good overview of VLOOKUP, MATCH, INDEX, etc. Need to do the practice worksheets in order to make it stick. Excellent presenter!
Anonymous
(Accountant)
I thought this was a very helpful course. I will use all of the tips that were taught in the accounting workpapers I prepare.
Anonymous
(GL Manager)
Good class explaining basics on various excel tools. Never knew who to use multiple functions in once formula. Good overview.
Anonymous
(Accounting Manager)
Another very helpful and informative course by the presenter. A great precursor to have an in depth knowledge on V- lookups.
Anonymous
(CFO)
Another excellent lesson from Jeff Lenning. The shortcuts in this course will enhance any Excel user's modeling techniques.
Anonymous
(Sr. Accountant)
Good progression of material in the course and he shows the concept, then walks through the function step by step in excel.
Jeff Bone
(Financial Advisor at Northwestern Mutual)
I very much enjoy Jeff Lenning's teaching approach, I hope you offer more of his classes that are not Premium! Thank you!
Anonymous
(Controller)
Thanks Jeff - index and match are great formulas. I used them for a project not too long ago and they were very helpful!
Anonymous
(Unemployed)
—————————- ———- —————————- ———- —————————- ———-
I learned many new shortcuts during this course and most importantly i learned the concept of Index and Match properly.
MONICA MOUGEOT
(DIRECTOR OF FISCAL OPERATIONS at PENNINGTON BIOMEDICAL)
I learned a lot in a relatively short period of time due to the exercises provided as part of the workshop.
Thanks.
Anonymous
(Sr Director Consolidation)
Good tips and very helpful. Especially liked the Control key versus the alt key options to perform the same function.
Alexander Makielski
( at Pero)
i'm familiar with vlookups and index/match, but the text/value formualas are entierly new to me. very helpful! thanks
Anonymous
(CFO)
Good explanations for index/match and uses within vlookup. This is much more concise than other lessons I've seen.
Colleen Windham
(CPA/Relationship Manager at Retirement Plan Solutions, Inc.)
Usually CPE is boring, but this one was really helpful and interesting! It's one of the best classes I have taken.
Maaco Ting-Stoffregen
(Corporate Controller at Pauls Corp)
I have used vlookup for years. This course provided great guidance on how to overcome the limitations of vlookup.
Anonymous
()
Working through the examples and additional material is time-consuming but very valuable. Well presented course!
Shirley Bailey
(Board Member at GMR Protection Resources)
Uses good examples and breaks down the steps so that you can then apply it with the excel problems provided.
Anonymous
(Director of Finance)
Really thorough explanation of index and match. I really liked the tips about including the value function.
Anonymous
(Associate Director, CFCC Assurance)
Informative and a good overview of VLOOKUPS. He shares great shortcuts that I’m excited to start using.
Sheilah Brown
(Controller at SMB LTC)
much more information than in previous and relied on previous courses so they need to be taken in order.
Terence Wynn
(Consulting, CFO at SVFG)
Solid insights to improve command of key excel functions that can be readily applied to real problems.
Anonymous
(None)
Liked the additional short-cuts and different ways upon which to improve upon the look-up function.
Anonymous
(Managing Director)
This course was a very goof dive into Excel Training: Boosting Proficiency with Selected Shortcuts.
Anonymous
(-)
It moves very quickly. A lot of information. Hard to take notes and would like a summary sheet.
Anonymous
(Controller)
I spend a lot of time using Excel and there is always something that I learn from Jeff's training.
Megan Lesko
(Megan Lesko at Product School)
Engaging class that was easy to follow and offered helpful tips and tricks for Excel workbooks.
Dylan Weaver
(AP Specialist - Payments Team at Charter Communications)
very insightful, she went just the right speed on this video and was pretty easy to follow along
Anonymous
(Senior Accountant)
It was a great overview of index, matach, and vlookup. I will definitely use index/match more.
Anonymous
(Manager)
This course explained in an easy to understand way how these various functions/shortcuts work.
Anonymous
(Card Program Administrator)
Very good course - made me more aware of the variety of look-ups and how to control them more.
Anonymous
()
Well taught course providing a comprehensive but easy to understand overview of the topics.
Anonymous
(Controller)
Good pointers to improve and analyze spreadsheets if your not familiar with these functions
Brad Keith
(Controller at Cambium Learning Group)
The Author kept the course interesting and easy to follow. I like the practice workbooks.
Anonymous
(Finance & Accounting Consultant)
Some great tips to improve my efficiency in my spreadsheets and to remove my manual steps.
Anonymous
(solo)
Great course. I like this instructor Jeff Lenning a lot. He has a good sense of humor.
Fay Chen
(Finance Manager at Kowa Research Institute Inc.)
It's great to learn improve Vlookup with Match and improve Vlookup with Value and Text.
Anonymous
(CPA/Investment Advisor)
Helpful demo of index/match, which seems to confuse many looking to go beyond VLOOKUP
Audrey Ashcraft
(Staff Business Systems Analyst at Intuit)
This is a great course for someone who is new to using excel and formatting data.
Anonymous
()
Very informative class. I did pick up valuable shortcuts that enhance my formulas.
Serena Cheng
(Associate at RSM)
Very informational and I loved learning about the pros and cons of using vlookup.
Bret Lanning
(Senior Accountant at Intuit)
I liked the course and the worksheets to work along with the video. Very helpful.
Cindy Ventura
(None at Individual)
I like that there are worksheets that allow you to follow along with the course.
Ellen Hynes
(Financial Consultant at Pacific Life)
Intense training on V-lookups, Index and Match. I can do anything in Excel now!
Michael Izzo
(Sr Financial Reporting Analyst at Catholic Health Initiatives)
Outstanding review course. I especially enjoyed learning the vlookup go around.
John Noble
(Controller at eComEngine)
Quick and easy lessons that will help you increase your efficiency with Excel.
Anonymous
()
Great course on Excel.. very informative. Very happy that I took this course.
Anonymous
(-)
The instruction is very easy to follow. I have mastered the subject matters!
Munyaradzi Kadzinga
(Treasury Analyst at Yarra Valley Water)
Excellent Excel presentation from Jeff!! He makes Excel looks easy-pessy !!!
Robert Workman
(Senior Lean Development Officer at Confidential)
Good course and some surprising applications that can come from the material
Anonymous
(Director of Accounting)
Excellent course to familiarize yourself with vlookup, index, match function
Ellen Rogers
(Sr Accountant / Finance Manager Consulta.. at RGP)
Helpful to know how to use vlookup when your data includes text and valules
Kendall Houk
(Chief Financial Officer at Famous Smoke Shop)
I thought I was pretty good at excel already but this brought new insights.
Jennifer Spidle
(CFO at Spidle Office Solutions)
Well taught. Instructor is excited and engaging. Thank you for the course.
Anonymous
()
Great course. I love excel. The tips were helpful and slides were useful.
Anonymous
(Manager)
The examples helped to confirm understanding of the material presented.
Ralph Czarnecki
(Director - A/P at Charter Communications)
Excellent class for someone who uses Microsoft Excel on a daily basis.
Anonymous
(Accounts Payable Specialist)
Quick and easy steps to follow for new functions. Great time savers.
Anonymous
(President)
Good course. Instructor is very good. On to the next course by Jeff.
Kevin Moschella
(Sr. Director, FP&A at Evidera)
I like how Jeff breaks down the pros and cons of different functions.
Janet Gray
(SENIOR INTERNAL AUDITOR at NCCI )
I would love to know which one I got wrong so I can review the area
Anonymous
(Consulting Staff)
I liked the examples to learn each section, they were very helpful.
Anonymous
(Agent)
Course presented in a good format covering all stated objectives.
Shari Jenkins
(Operations Analyst at Intuit)
sometimes it goes a little too fast but I like I can back it up
Corey Masters
(Accountant, Internal Auditor, Risk Speci.. at Self)
Another great class by Jeff Lenning. I really like his courses.
David Hinojosa
( at Unemployed)
Very useful tips provided; especially the Index/Match functions.
Anonymous
(Senior Accountant)
very useful functions to use in excel, and very well presented.
Anonymous
(Accounting Clerk)
Good examples and interesting solutions to VLOOKUP limitations!
KAREN CARLOZZI
(Owner at KECCPA)
Excellent-learned so much in the webinar-can't wait to see more
Class goes at a fair clip, and much is learned in short order.
Anonymous
(Head of Internal Audit)
Great explanation of function compatibility and substitution.
Daniel Belong
(Controller at Orchestrade)
There was too much material to cover in a short period of time
Anonymous
(Sr. Accounting Analyst)
This was very informative and I will use the information daily
Hillary Broussard
( at Acadiana Management Group)
Great information in this course. It was easy to follow along.
Samuel Narotsky
(Corporate Accounting Consultant at Self Employed)
Very useful on screen exercises
Appropriate length of course
Anonymous
(CFO)
Great for beginners, useful information to start using excel.
Murch Ewings
(- at -)
Great intro to a few key functions for saving time in excel.
Charles Elwis
(Insurance Broker at Health Guys)
This takes more than 1.5 hours and covers a lot of material.
Anonymous
(Accounting Manager)
Very much liked learning about the index and match functions
Michael Glessner
(Controller at MJG & Associates)
Awesome instructor who can simplify complex excel processes.
Honghee Kim
( at Comsale Computer Inc.)
Easy and simple explanation and program materials are good.
Anonymous
(Associate Professor)
Excellent presentation and the "homework" was also useful
Anonymous
(Accountant)
Very interesting stuff! I enjoyed learning about VLOOKUPs.
James Chuang
(Compliance Officer at Silverton Casino Hotel)
Really helpful overview of some neat Excel tips and tricks.
Emily O'Reilly
(FA III at City of Detroit)
Thanks for the quick overview of the referenced materials.
Christine Gaumond
(Sr. Financial Analyst at Robert W. Baird & Co.)
Great course that I hope will save me time down the road.
Anonymous
(Accounts Receivable Representative)
This is a useful intermediate course on Excel functions.
Ryan O'Donnell
( at Maiden Holdings, Ltd)
Very useful information for anyone who uses excel daily.
Melissa Embry
( at TDI Fleet Services)
very good hints and shortcuts for a regular excel user
Anonymous
(Accountant)
I want to devour all Excel Unversity content. Love it.
Sarah Feuerpeil
(Senior Accountant at Novelis)
great instructor, great explanations, good to follow
Anonymous
(controller)
Great, relevant techniques with working examples.
Simon Adell
(Chief Financial Officer at Undisclosed)
I really like this instructor, he does a great job.
Anonymous
(Owner)
Wonderful examples and worksheets to follow along!
Anonymous
(Financial Analyst)
Good review of functions I haven't used in awhile.
Kenneth Hopkins
(Senior Financial Analyst at The University of Texas Health Science C..)
Lots of info. May need to go over more than once.
Anonymous
(Controller)
Good content, Spoke a little too quickly at points
PABLO Alejandro Montiel
(BRANCH MANAGER at BBVA Bancomer)
Excellent Course! Love the VLOOKUP function...!
Vish Inamdar
(Manager Operations (Governance, Risk &am.. at Cisco Systems Inc.)
Awesome tips to quickly overcome the limitations
Great simple but on point examples and practice
Chris Grimes
(Rules Master at Cisco)
Lots of good tips on using built in formulas.
Jason Sherman
(Staff Accountant at Willdan)
A good review of how to use lookup functions.
Anonymous
(President)
Great examples of how to nest functions!
Anonymous
(Credit and Collections Specialist)
I liked the challenge in the worksheets
William Applegate
(Sr. Business Analyst at Intuit)
The Index Match usage was good to see.
Ramakrishna Nalluri
(Senior Financial Analyst at LifeWorks Inc)
Very useful in practical applications
Cathy Kyriakis
(Distribution & Sales Ops Mgr at Intuit Canada)
Some excellent tips in this course!
Geoff Bosley
(Corp Controller at Aperture Credentialing, LLC)
index/match is the only way to go!
Frank Perillo
(Not Provided at Frank Perillo CPA)
Great instructor excellent class!
John Morgan
(Staff Accountant at EKS&H)
Very useful. A little fast paced.
Rachel Carter
(Business Ops Analyst at Intuit)
I thought it was pretty good.
Siva Vinay
(Controller at Park n Fly)
Will make the job very effective
Matt Osmundsen
(Category Finance Director at Energizer Holdings, Inc.)
Great course! Very informative.
love the F2 and F9 buttons now.
Mark Wieland
(SR. Accountant at Intuit)
Very useful tips and tricks.
Melvin Balberan
(Senior GL Accountant at Netsuite Philippines Inc.)
The tricks in Match and Index
Vera Nickelsen
(Fraud Agent at Intuit)
the exercises are awesome
Forrest Foster
(Audit Engagement Manager at Cisco Systems)
Good class, very useful.
Anonymous
(None)
Very helpful guidance.
Pamela LaPlaca, CPA
(Controller at EG USA)
Worthwhile for sure!
Becky Williams
(Manager of Operations Accounting at CONSOL Energy, Inc.)
great information
Mary Ann Arepentido
(Cash Application Analyst II at Netsuite Inc.)
Well presented.
Richard Dandan
(Senior Accounting Specialist at National Food Authority)
Great course!
Anonymous
(Accounting Manager)
clear concepts
Anonymous
(Credit/Collections Analyst)
It was helpful
Kayla Garbison
(Account Executive at Yelp)
Very helpful!!
Qingkui Qiu
(Finance supervisor at Wanli New energy corporation LTD.)
great course!
Anonymous
(Accountant)
Very helpful
Patricia Flores
(Payroll Analyst | Tax & Compliance at Intuit)
Great course
Anonymous
(Financial Consultant)
Excellent.
Anonymous
(-)
Excellent!
Anonymous
()
Loved it!
Anonymous
(Consultant)
Good
Deb Peterson
(Order Management Customer Service Specia.. at Intuit Canada)
no
Prerequisites
Course Complexity: Foundational
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 or send an e-mail to
.
Jeff LenningAuthor of Excel University
About Illumeo
Platform
Resources
Contact Us
- Email: info@illumeo.com
- Phone: 408-400-3993
- Adress: 1608 W Campbell
- Av #221, Campbell, CA 95008
© 2024 Illumeo, Inc.