Array Formulas Courses and Certifications

ExcelIsFun

Dynamic Spilled Array Formulas and Functions - Revolution in Easier Worksheet Solutions

Discover Microsoft 365 Excel's Dynamic Spilled Array Formulas to revolutionize worksheet solutions with easier, faster methods and advanced formula modeling techniques.

• YouTube
• 10 hours 43 minutes
• Self-Paced
• Free Video

ExcelIsFun

Excel Array Formulas & Functions - 50 Examples of How to Become an Array Expert

Master Excel array formulas with 50 practical examples, covering fundamental concepts, advanced functions, and real-world applications for data analysis and reporting.

• YouTube
• 1 hour 10 minutes
• Self-Paced
• Free Video

ExcelIsFun

Excel Statistical Analysis - 5-Number Summary - Box & Whiskers Chart - Power Query & Array Formulas

Aprenda a criar análises estatísticas avançadas no Excel usando Power Query, fórmulas de matriz e gráficos Box & Whiskers para visualizar e interpretar conjuntos de dados complexos.

• YouTube
• 26 minutes
• Self-Paced
• Free Video

ExcelIsFun

Average of Customer Total Sales by Product - Formulas, DAX or Array Formula?

Learn advanced Excel techniques for calculating average customer sales by product using formulas, array formulas, and DAX measures in Power Pivot. Compare methods and optimize performance.

• YouTube
• 29 minutes
• Self-Paced
• Free Video

ExcelIsFun

Ctrl - Shift - Enter- Excel Array Formulas - Extract Unique Lists & Sorting Formulas

Learn advanced Excel techniques for extracting unique lists, sorting data, and creating efficient array formulas to solve complex data analysis problems and enhance spreadsheet functionality.

• YouTube
• 55 minutes
• Self-Paced
• Free Video

ExcelIsFun

Ctrl + Shift + Enter - Excel Array Formulas - SUMPRODUCT Function - Including Timing

Comprehensive guide to SUMPRODUCT function in Excel, covering 21 examples with array formulas, timing comparisons, and efficient calculation techniques for data analysis and problem-solving.

• YouTube
• 45 minutes
• Self-Paced
• Free Video

Supercharge Excel with Dynamic Array Functions & Formulas

Master Excel's Dynamic Array Functions like FILTER, UNIQUE, and SORT to automate data tasks, eliminate manual errors, and streamline workflows for enhanced productivity.

• Zero To Mastery
• 4 hours
• Self-Paced
• Paid Course

ExcelIsFun

Ctrl - Shift - Enter - Excel Array Formulas - Review Formula Basics

Comprehensive tutorial on Excel array formulas, covering formula basics, advanced functions, and practical applications for efficient data analysis and problem-solving.

• YouTube
• 59 minutes
• Self-Paced
• Free Video

EDUCBA

Master Advanced Excel Functions to Analyze & Automate Data

13 ratings at Coursera

Unlock advanced Excel functions for financial analysis, conditional logic, dynamic lookups, and automated data workflows to enhance productivity and decision-making.

• Coursera
• 5 hours 6 minutes
• Self-Paced
• Paid Course

Packt

Excel Functions and Formulas

Master Excel's powerful functions and formulas to efficiently manage data, perform complex calculations, and automate tasks for enhanced productivity in any professional setting.

• Coursera
• 5 hours 34 minutes
• Self-Paced
• Paid Course

Excel in Microsoft Excel 2: Intermediate to Expert advanced

896 ratings at Udemy

Get Expert certified! Levels 6-10 for Microsoft Excel 2010, 2013, 2016 and Excel 2019. Covers 77-728, 77-427 & 77-428.

• Udemy
• 11 hours 2 minutes
• Self-Paced
• Paid Course

ExcelIsFun

Comprehensive Excel Dynamic Array Formula Lesson - The Power of Array Formulas

Explore Excel's new dynamic array formulas and functions, enhancing data analysis with spill ranges, UNIQUE, FILTER, SORT, and more. Master advanced techniques for efficient spreadsheet manipulation and reporting.

• YouTube
• 40 minutes
• Self-Paced
• Free Video

ExcelIsFun

Excel Array Formulas - Comprehensive Lessons with 12 Examples

Comprehensive guide to Excel array formulas, covering 12 practical examples from basic operations to advanced functions like SUMPRODUCT, TRANSPOSE, and FREQUENCY for efficient data analysis.

• YouTube
• 52 minutes
• Self-Paced
• Free Video

ExcelIsFun

Ctrl - Shift - Enter- Excel Array Formulas - 26 Amazing Array Formulas

Discover 26 powerful Excel array formulas for advanced data analysis, including unique value summation, conditional ranking, and complex lookups. Enhance your spreadsheet skills and efficiency.

• YouTube
• 1 hour 21 minutes
• Self-Paced
• Free Video

ExcelIsFun

Ctrl - Shift - Enter- Excel Array Formulas - Unique Count Formulas- FREQUENCY or COUNTIF Function?

Explore advanced Excel array formulas for unique counting, including FREQUENCY and COUNTIF functions, handling mixed data, empty cells, and wildcards. Learn efficient techniques for data analysis.

• YouTube
• 41 minutes
• Self-Paced
• Free Video