Master Excel Lookups and References
Master Excel Lookups and References
I've developed this course for Stanford University. Now, it's finally available to you as well. Join my Stanford students and learn, so that you too can invigorate and dominate your Excel workflow better than ever before!
Enroll now and master Excel's most important and powerful lookup-and-reference functions. Propel your skills beyond VLOOKUP and discover the full power and hidden potential of Excel lookups.
Few things can transform your Excel workflow faster than tapping into the true power of Excel lookup-and-reference functions. Learn VLOOKUP, HLOOKUP, INDEX, MATCH, OFFSET, INDIRECT to immediately skyrocket your skills to a higher orbit.
This course will demonstrate what you need to know about these amazing Excel tools, covering how to create powerful formulas that automatically find and display exactly what you want in your datasets.
First, you'll master the venerable VLOOKUP and its remarkable potential, and how you can apply it to your workflow.
Then you'll move on to more elegant solutions: discover the MATCH function and the benefit of combining it with VLOOKUP.
Next, you'll learn how to take advantage of INDEX and MATCH for ultimate flexibility.
Plus, discover more efficient ways to consolidate data with the little-known INDIRECT function and tickle your creativity with the esoteric OFFSET function.
After completing this hands-on training program, you'll be able to:
Recognize the value of lookups and references to your specific workflow
Take the full advantage of the following Excel functions: VLOOKUP, HLOOKUP, INDEX, MATCH, TRANSPOSE, and INDIRECT
Create flexible lookups for Excel dashboards with drop-down lists
Append detailed data to large datasets
Create range-based lookups with the "approximate match"
Find specific items using the "exact match"
Create two-dimensional lookups by combining VLOOKUP and MATCH
Use named ranges and Excel tables as reference lists
Lookup data from a "secret" table
Overcome the limitations of VLOOKUP by using INDEX and MATCH
Create automatically-expanding references with the OFFSET function
Consolidate data from multiple sheets with the INDIRECT function
Use TRANSPOSE function to flip your data 90 degrees with links to the original cells
And so much more
This course will tickle your creativity and boost your Excel skills like nothing else.
Enroll now, so you can begin to learn immediately!
Discover the almost magical power hidden inside Excel's lookup-and-reference functions and transform your daily workflow
Url: View Details
What you will learn
- Discover the almost magical power hidden inside the lookup-and-reference functions in MS Excel
- Learn how to tame Excel’s lookup-and-reference power to re-engineer and drastically speed up your specific day-to-day tasks
- The number one Excel concept you must learn before you learn anything else if you want to be taken seriously as a remotely savvy Excel user. This is hard-core Excel foundation stuff that everyone working with spreadsheets must know.
Rating: 4.45
Level: Intermediate Level
Duration: 3.5 hours
Instructor: Igor Ovchinnikov
Courses By: 0-9 A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
About US
The display of third-party trademarks and trade names on this site does not necessarily indicate any affiliation or endorsement of hugecourses.com.
View Sitemap