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
• On-Demand
• 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
• On-Demand
• 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
• On-Demand
• 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
• On-Demand
• 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
• On-Demand
• 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
• On-Demand
• Free Video

Excel in Microsoft Excel 2: Intermediate to Expert advanced

878 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
• On-Demand
• Paid Course

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
• On-Demand
• 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
• On-Demand
• Free Video

Microsoft Excel for Mac 2: Intermediate to Expert advanced

242 ratings at Udemy

Get Expert certified! Levels 6-9 for Microsoft Excel for Mac. Covers 77-728, 77-427 & 77-428.

• Udemy
• 10 hours 40 minutes
• On-Demand
• Paid Course

Microsoft Excel Dashboards & Data Visualization Mastery

217 ratings at Udemy

The only Microsoft Excel Dashboard, Data Visualization & Data Analysis course for INTERMEDIATE to ADVANCED EXCEL users!

• Udemy
• 6 hours 55 minutes
• On-Demand
• Paid Course

Microsoft Excel - Practical Excel Masterclass

58 ratings at Udemy

Master Excel for data analysis, from basics to advanced functions, PivotTables, and dynamic charts. Learn practical problem-solving approaches and gain industry-relevant skills for real-world applications.

• Udemy
• 5 hours 48 minutes
• On-Demand
• Paid Course

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
• On-Demand
• 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
• On-Demand
• 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
• On-Demand
• Free Video