Array Formulas Courses and Certifications

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 - 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

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

Visualizing Data and Building Dashboards in Excel & Power BI

Comprehensive guide to data visualization and dashboard creation in Excel and Power BI, covering various chart types, PivotTables, Power Query, and advanced techniques for effective data presentation.

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

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

ExcelIsFun

MIN & MAX Functions for Alphanumeric - Text Values Report

Learn 8 methods to find MIN and MAX alphanumeric values in Excel, including VLOOKUP, array formulas, AGGREGATE, MINIFS/MAXIFS, Power Query, and SQL, with practical examples and explanations.

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

ExcelIsFun

Backwards One to Many Relationship Report - Excel, Power Query or SQL?

Learn advanced Excel techniques for calculating average GPA across related tables using array formulas, DAX, Power Query, and SQL. Master data analysis skills for complex relationships.

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

ExcelIsFun

Conditional Calculations with Excel Formulas - Comprehensive Lessons

Comprehensive guide to conditional calculations in Excel, covering AND/OR functions, SUMIFS, array formulas, and more. Ideal for mastering complex data analysis techniques.

• YouTube
• 1 hour 23 minutes
• On-Demand
• Free Video