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