Tag Archives: Advanced Excel

Video Lesson: Advanced Pivot Tables – Round 2

Advanced Pivot Tables Round 2 This lesson picks up right where the last Pivot Table lesson left off. In this tutorial, you will learn: How to use multiple levels of data within row or column labels. Expand / collapse all … Continue reading

Posted in Workbook/Reference Lessons | Tagged , , , | 28 Comments

Excel Video Lesson: Advanced VLOOKUP Examples

Advanced Vlookup Examples The VLOOKUP function is one of the most frequently used functions in all of Excel. ┬áIn this video lesson I go over some advanced usages of the VLOOKUP function including: – In-depth overview of the VLOOKUP syntax: … Continue reading

Posted in Function-Related Lessons | Tagged , , , , | 28 Comments