My Spreadsheet Lab

The site is about Microsoft Excel.

  • Home
  • Templates
  • Excel Blog
  • About Me
  • Contact Kevin

Post Category → Formulas

Video 00043 Formulas_Array Formulas_Example1_LEN_function

posted in Formulas on April 16, 2013 by Kevin Lehrbass 0 Comments

Question: Why use an array formula?

Answer: Because you can answer many complex questions using only 1 array formula!

 

In this video, I use an array formula to extend the use of Excel’s LEN function. Continue reading →

Video 00042 Why would I need an array formula?

posted in Formulas on April 11, 2013 by Kevin Lehrbass 0 Comments

Why would I need an array formula?

I have heard this question so many times over the years! If you have never ever used an array formula than this video is for you.

Don’t worry….No prior knowledge is required. I explain things slowly. Continue reading →

Video 00037 Formulas_Adding numbers in Excel

posted in Formulas on April 8, 2013 by Kevin Lehrbass 0 Comments

Learn how to add numbers in Microsoft Excel using these functions: SUM, SUMIF, SUMIFS. Continue reading →

Video 00030 Create a HYPERLINK in Microsoft Excel

posted in Formulas on April 7, 2013 by Kevin Lehrbass 0 Comments

A hyperlink is an easy way to jump from one location to another location.  The destination could be to the same workbook, an external workbook or a website.

There are two ways to create a hyperlink in Microsoft Excel: Continue reading →

Video 00029 OFFSET function with combo box

posted in Formulas on April 7, 2013 by Kevin Lehrbass 0 Comments

Watch this video to learn how to combine the offset function with a combo box.  This will make it easy to retrieve the desired value from your data.

Continue reading →

Video 00028 OFFSET function introduction

posted in Formulas on April 7, 2013 by Kevin Lehrbass 0 Comments

Learn how to retrieve a value or several values using Microsoft Excel’s offset function. Offset is one of my favorite functions due to it’s flexibility. Continue reading →

Video 00026 Financial Functions_FUTURE VALUE part 2

posted in Formulas on April 7, 2013 by Kevin Lehrbass 0 Comments

What’s the difference between Compound Interest and Simple Interest?

I know that there’s a difference but I often forget the details so I created this video for you and for me! Continue reading →

Video 00025 Financial Functions_FUTURE VALUE

posted in Formulas on April 7, 2013 by Kevin Lehrbass 0 Comments

Calculate the future value of your money in Microsoft Excel using the Future Value function. Continue reading →

Video 00027 COUNT functions in Excel

posted in Formulas on April 7, 2013 by Kevin Lehrbass 0 Comments

Learn how to use Excel’s various count functions to count numbers, blanks, non blanks and how to conditionally count (count if a condition is met). Continue reading →

Video 00017 VLOOKUP Introduction Part2

posted in Formulas on April 6, 2013 by Kevin Lehrbass 0 Comments

This video reviews two parameters of Excel’s vlookup function (‘col_index_num’  and  ‘table_array’). Continue reading →

← Older posts
Newer posts →