Tag Archives: Learn Excel

Excel 2013 In-Depth Preview

What’s new in Excel 2013! Microsoft has made it possible for anyone who’d like to check out Excel 2013 (included with the full Office 2013) through their Excel 2013 pre-release trial here. UPDATE 2/20: Now they have the Office 365 full … Continue reading

Posted in Function-Related Lessons, News / Updates | Tagged , , , , | 3 Comments

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

Video Lesson: Beginner’s Introduction to Excel

One video that I have been meaning to do is a lesson focused on those of you who have never (or rarely) used Excel, and needed an introduction to the program and how it works.  I’ve created this lesson in … Continue reading

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