«
»

How to Work with Array Formulas in Excel

With an Array Formula, you can frequently create formulas quicker because you can eliminate several intermediate calculations.

I begin my introduction to Array Formulas by showing you how to use the SUMPRODUCT Function. Next, I show you two examples of Array Formulas in Excel. I also show you how an Array Formula provides a level of protection for your formulas, because you cannot edit a single cell in the array – you must select the entire range of cells that contain the array formula to edit it or to delete it.

Please visit my website – www.thecompanyrocks.com – to view all of my video lessons and to learn about the services and resources that I offer.

Danny Rocks
The Company Rocks

Duration : 0:7:45


Technorati Tags: , , , , , , , , , , , , , , ,

Related posts:

  1. Highline Excel Class 36: Array Formulas Basics
  2. Excel Magic Trick 313: Some Facts About Array Formulas
  3. Excel Array Formula Series #1: Basics of Array Formulas
  4. How to Record a Macro in Excel to Fix Problems with an Imported Text File
  5. Excel Array Formula Series #4: Find Largest Improvement

Tags: , , , , , , , , , , , , , , ,

This entry was posted on Thursday, December 8th, 2011 at 4:57 am and is filed under Learn Excel Formulas. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

2 Responses to “How to Work with Array Formulas in Excel”

  1. todaslasmujeres says:
    December 8, 2011 at 4:57 am

    i learned 3 things …
    i learned 3 things from this video, thank you.

  2. DannyRocksExcels says:
    December 8, 2011 at 4:57 am

    @todaslasmujeres
    …
    @todaslasmujeres
    Thank you for sending me your comment. I am pleased that you were able to learn 3 things from my tutorial.

    Danny Rocks
    The Company Rocks

Leave a Reply