Excel Array Formula Series #1: Basics of Array Formulas

Tags:
Excel Array Formulas Functions Mike Gel Girvin Highline Community Colleges
ExcelIsFun
  • Affiliate Submitter:
    ExcelIsFun
  • International International
  • Comments: 0
  • Views: 218
  • Added: 26-Jun-08

See how to create a basic array formula. Learn about the syntax, the Ctrl + Shift + Enter method of formula entry and the curly brackets that get entered automatically by Excel

See how to calculate the Total Sales (given rows of input data)

In this series see how to create array formulas in Excel. Array formulas can take complex series of formula calculations and reduce them down to a single formula that sits in just one cell! You will see how to create array formulas and see how to use Array Functions.

  1. Categories: Science & Tech
Comments on

Excel Array Formula Series #1: Basics of Array Formulas

2 Comments | Add Comment
  • Dear jefframras, ...

    Dear jefframras,

    17 videos is not enough to portray Array formulas, but it's a good start!

    Keep watching and rating!!!

    Wait till you get to the last few, they are not so easy (but that's what makes them fun!!).

    --ExcelIsFun

    By ExcelIsFun [Affiliate User] 1214594219 Reply Spam Moderate Up Moderate Down
  • WOW!! 17 videos on ...

    WOW!! 17 videos on arrays. I'm excited to get through these. Thanks so much for putting out this series. I thought you might make 1 video!

    By jefframras [Affiliate User] 1214575086 Reply Spam Moderate Up Moderate Down
2 Comments | Add Comment