Category Archives: Function-Related Lessons

Lessons related to Functions and Formulas within Excel.

Excel 2013: Real World Examples of New Functions

Real World Examples of Excel 2013’s New Functions [This is the second article I’ve written for the Microsoft MVP blog, but figured I would post it here as well for those who might find it handy] Microsoft included over 50 new … Continue reading

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

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

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: Information Functions in Excel

In the following lesson I go through the Experience Level 1 Information Functions.  These functions are used to obtain information about formatting & referencing about specific cell or range references.  In this lesson I review the following functions: ISBLANK – … Continue reading

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

Video Lesson: Math and Statistical Functions

This Excel video lesson is about the Experience Level 1 Math and Statistical Functions in Excel.  Here is the level 1 function list extract from the Master Workbook that goes along with the video lesson. The formulas discussed in the video are as … Continue reading

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

Video Lesson: Advanced Lookup – Index & Match

The versatility and usefulness of the Index and Match functions are cherished by Excel veterans, but many less experienced users have either not encountered them, or are a bit confused by the usage of the two. This Excel Video Lesson … Continue reading

Posted in Function-Related Lessons, Workbook/Reference Lessons | Tagged , , , , , , , , , | 5 Comments

Video Lesson: Logical Functions and Formulas

This Excel video lesson is about Logical Functions and Formulas in Excel.  Here are the formulas that I go through in the video lesson (click below for larger image): Logical formulas are extremely useful in more advanced Excel spreadsheets/methods and … Continue reading

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

Video Lesson: Lookup / Reference Functions

As listed in the Master Workbook (see link at the top of the page), there are functions grouped into categories. This video is a demonstration of the Experience Level 1 – Lookup & Reference functions. The functions covered in this … Continue reading

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

Excel Video Lesson: Text Functions

This video tutorial is a demonstration of the Experience Level 1 Text functions. Make sure to download the newest version of the Master Workbook that I updated earlier today to follow along. The functions covered in this lesson are: CONCATENATE … Continue reading

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

Excel Video Lesson: Date & Time Functions

As listed in the Master Workbook, there are functions grouped into categories. This video is a demonstration of the Experience Level 1 Date & Time functions. The functions covered in this video lesson are: DATE — DATEVALUE — TODAY  — DAY  — … Continue reading

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