Tag Archives: Excel Functions

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: 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