Tag Archives: How to Learn Excel Formulas

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: 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: Formula Auditing & Evaluation

Formula Auditing and Formula Evaluation are powerful components in Excel, and today’s video lesson goes over the following uses of the Formula Auditing features: Show Formulas:  How to change view to show formulas instead of cell results. Formula Evaluation:  See … Continue reading

Posted in Workbook/Reference Lessons | Tagged , , , , , , , , , | 5 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

Quick Tip: Remove Duplicate Values from List

This gallery contains 2 photos.

Many times there are instances when you’ll have a large amount of data and you’ll want to be able to extract a listing of one specific column with only one line for each item type. For example, you may have … Continue reading

More Galleries | 14 Comments

Excel Course: Book and Website Recommendations

I wanted to suggest a few books that I’ve used in the past which are extremely helpful in learning Excel.  I’d recommend checking any one of these books out as they have lots of useful information and examples for how … Continue reading

Posted in Quick Tips | Tagged , , , , , , | 2 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

Video Lesson: Absolute & Relative Referencing

Absolute and Relative Cell Referencing Note: This video was originally the 3rd lesson in the plan, but due to the comments regarding it being too confusing at that level, I have moved it to the Intermediate section effective 3/23/17. This … Continue reading

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