When you enroll through our links, we may earn a small commission—at no extra cost to you. This helps keep our platform free and inspires us to add more value.

Development
SkillShare logo

Excel Formulas & Functions Part 9: Array Formulas

Unlock creativity with Skillshare! Learn acrylic painting, AI writing, graphic design, and photography.

     0 |
  • Reviews ( 0 )
Free
Excel Formulas & Functions Part 9: Array Formulas

Related Courses

This Course Includes

  • iconskillshare
  • icon0 (0 reviews )
  • icon49 minutes
  • iconenglish
  • iconOnline - Self Paced
  • iconcourse
  • iconSkillShare

About Excel Formulas & Functions Part 9: Array Formulas

Introduction: Array Formulas

Rules of Array Functions

Pros & Cons of Array Functions

Vertical, Horizontal, and 2-Dimensional Array Constants

Using Array Constants in Formulas

Named Array Constants

The Transpose Function

Linking Data Between Sheets: Array vs. Non-Array Comparison

Returning the "X" Largest Values in a Range

Counting Characters Across Cells

Creating a "MAX IF" Array Formula

BONUS: "MAX IF" with Multiple Criteria

BONUS: Using the Double Unary Operator ("--")

HOMEWORK: Array Functions

What You Will Learn?

  • This course is part 9 of a 9-part series on Excel Formulas & Functions: from basic to advanced..
  • If you're looking to push Excel beyond what you thought possible, array functions open up an entirely new world of advanced capabilities. Array functions are unlike any other type of function in Excel; they are able to cycle through multiple series of calculations and return results either in a single cell or across an entire range. In this section we'll start with the fundamentals before diving into advanced demos, such as returning the "X" largest values in a range, counting characters across multiple cells, and building a custom "MAXIF" function..
  • About the Excel Formulas & Functions Series:.
  • In this series, you will develop tools to transform Excel from a basic spreadsheet program into a dynamic and powerful analytics tool. Courses cover 75+ formulas, and feature hands-on, contextual demos and practice exercises designed to help you not only memorize formula syntax, but to think like Excel..
  • You'll learn how to write complex, powerful functions from scratch, allowing you to:.
  • If you're looking for the ONE series covering all of the advanced formulas and functions that you need to become an absolute Excel rock star, you've found it!.