Array Formulas Courses and Certifications

Excel in Microsoft Excel 2: Intermediate to Expert advanced

642 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 1 minute
• On-Demand
• Paid Course

Microsoft Excel Dashboards & Data Visualization Mastery

210 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 for Mac 2: Intermediate to Expert advanced

206 ratings at Udemy

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

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

Microsoft Excel - Practical Excel Masterclass

54 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
• 6 hours
• On-Demand
• Paid Course

Excel 2011 for the Mac: Advanced Formulas and Functions

Demystifies some of the most challenging of the 300+ formulas and functions in Excel 2011 for the Mac.

• LinkedIn Learning
• 6 hours
• On-Demand
• Free Trial Available

Learnit Training

Excel 2019 Power User Tutorial

Advanced Excel techniques for data analysis, including VLOOKUP troubleshooting, INDEX MATCH, PivotTables, array formulas, conditional formatting, and macros. Ideal for users seeking to enhance efficiency and problem-solving skills.

• YouTube
• 1 hour 15 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

Excel Statistical Analysis - Introduction to Probability, Power Query & Pivot Table Example

Aprenda os fundamentos de probabilidade em Excel, incluindo experimentos aleatórios, espaço amostral, combinações e permutações. Aplique conceitos em exemplos práticos de negócios usando Power Query e Tabelas Dinâmicas.

• YouTube
• 44 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 XLOOKUP Function – Comprehensive Lessons – 27 Examples

Comprehensive guide to Excel's XLOOKUP function, covering 27 examples from basic usage to advanced techniques like dynamic column retrieval and array formulas.

• YouTube
• 25 minutes
• On-Demand
• Free Video

ExcelIsFun

Array Formula - Add Daily Rainfall 5 AM to 5 AM Next Day - Most Automatic

Learn advanced Excel array formulas to automate rainfall reporting with custom time periods. Master FREQUENCY, AGGREGATE, and SUMIFS functions for efficient data analysis and unique date extraction.

• YouTube
• 37 minutes
• On-Demand
• Free Video

ExcelIsFun

Logical Formulas - Count & Extract Customer Names for 8 Sales Coupon Groups

Learn advanced Excel techniques for analyzing customer coupon usage across multiple stores, including logical formulas, array formulas, and functions like COUNTIFS, AND, OR, and INDEX.

• YouTube
• 31 minutes
• On-Demand
• Free Video

ExcelIsFun

Extract Records With Multiple Contains - Partial Text Criteria: 4 Examples

Learn advanced Excel techniques for extracting records with multiple contains criteria, using array formulas, functions like SEARCH and MMULT, and exploring matrix multiplication concepts.

• YouTube
• 38 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

Standard Deviation with Criteria - Power Query, PivotTable, or Array Formula

Learn advanced Excel techniques for calculating standard deviation using Power Query, PivotTables, and array formulas. Master data analysis with practical examples and step-by-step guidance.

• YouTube
• 26 minutes
• On-Demand
• Free Video