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

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

ExcelIsFun

INDEX & MATCH Lookup Functions - Beginning to Advanced

Comprehensive tutorial on INDEX & MATCH functions in Excel, covering 18 advanced techniques from basic lookups to complex array formulas for data extraction and manipulation.

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

Being an intermediate level user of Excel can help save a user hours of work time and take full advantage of the Excel application. Taking an intermediate Excel course will help students advance their skills and pass an intermediate Excel exam.

• Cybrary
• 8-9 hours
• On-Demand
• Paid Course

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

Learnit Training

Excel 2019 Power User Tutorial

Advanced Excel techniques for data analysis, including VLOOKUP troubleshooting, INDEX MATCH, PivotTables, array formulas, conditional formatting, charts, and macros. Ideal for power users seeking efficient problem-solving methods.

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

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