->
SkillShare - Excel Formulas & Functions Part 9: Array Formulas - 2134371818
SkillShare - Excel Formulas & Functions Part 9: Array Formulas
Intermediate level


About This Class

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:

  • Build dynamic tools & dashboards to filter, display and analyze your data
  • Join datasets from multiple sources in seconds with LOOKUP, INDEX & MATCH functions
  • Pull real-time data from APIs directly into Excel using WEBSERVICE & FILTERXML
  • Manipulate dates, times, text, and arrays with ease
  • Automate tedious and time-consuming analytics tasks (no VBA required!)
  • And much more
  • 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!

    SkillShare - Excel Formulas & Functions Part 9: Array Formulas


     TO MAC USERS: If RAR password doesn't work, use this archive program: 

    RAR Expander 0.8.5 Beta 4  and extract password protected files without error.


     TO WIN USERS: If RAR password doesn't work, use this archive program: 

    Latest Winrar  and extract password protected files without error.


     Coktum   |  

    Information
    Members of Guests cannot leave comments.




    rss