Главная
Study mode:
on
You
History
Saved
In progress 0 courses
compleat 0 courses
#Art & Design #Adobe #ChatGPT #GitHub

#Array Formulas

Showing: 20 courses
ExcelIsFun

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

0 rewiews
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.
Add to list
33 Lesons
44 minutes
On-Demand
Free-Video
ExcelIsFun

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

0 rewiews
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.
Add to list
23 Lesons
26 minutes
On-Demand
Free-Video
ExcelIsFun

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

0 rewiews
Learn advanced Excel techniques for extracting records with multiple contains criteria, using array formulas, functions like SEARCH and MMULT, and exploring matrix multiplication concepts.
Add to list
9 Lesons
38 minutes
On-Demand
Free-Video
ExcelIsFun

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

0 rewiews
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.
Add to list
11 Lesons
29 minutes
On-Demand
Free-Video
ExcelIsFun

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

0 rewiews
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.
Add to list
6 Lesons
26 minutes
On-Demand
Free-Video
ExcelIsFun

MIN & MAX Functions for Alphanumeric - Text Values Report

0 rewiews
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.
Add to list
10 Lesons
32 minutes
On-Demand
Free-Video
ExcelIsFun

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

0 rewiews
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.
Add to list
6 Lesons
31 minutes
On-Demand
Free-Video
ExcelIsFun

Conditional Calculations with Excel Formulas - Comprehensive Lessons

0 rewiews
Comprehensive guide to conditional calculations in Excel, covering AND/OR functions, SUMIFS, array formulas, and more. Ideal for mastering complex data analysis techniques.
Add to list
21 Lesons
1 hour 23 minutes
On-Demand
Free-Video
ExcelIsFun

Excel XLOOKUP Function – Comprehensive Lessons – 27 Examples

0 rewiews
Comprehensive guide to Excel's XLOOKUP function, covering 27 examples from basic usage to advanced techniques like dynamic column retrieval and array formulas.
Add to list
29 Lesons
25 minutes
On-Demand
Free-Video
ExcelIsFun

Aging Accounts Receivable Reports on Multiple Sheets With Array Formula

0 rewiews
Learn to create automated Aging Accounts Receivable Reports using Excel's array formulas, table features, and structured references. Master advanced functions like COUNTIFS, AGGREGATE, and INDEX for efficient data extraction and reporting.
Add to list
12 Lesons
27 minutes
On-Demand
Free-Video
ExcelIsFun

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

0 rewiews
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.
Add to list
12 Lesons
55 minutes
On-Demand
Free-Video
ExcelIsFun

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

0 rewiews
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.
Add to list
24 Lesons
45 minutes
On-Demand
Free-Video
ExcelIsFun

INDEX & MATCH Lookup Functions - Beginning to Advanced

0 rewiews
Comprehensive tutorial on INDEX & MATCH functions in Excel, covering 18 advanced techniques from basic lookups to complex array formulas for data extraction and manipulation.
Add to list
18 Lesons
1 hour 10 minutes
On-Demand
Free-Video
ExcelIsFun

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

0 rewiews
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.
Add to list
6 Lesons
31 minutes
On-Demand
Free-Video
ExcelIsFun

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

0 rewiews
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.
Add to list
9 Lesons
37 minutes
On-Demand
Free-Video
Learnit Training

Excel 2019 Power User Tutorial

0 rewiews
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.
Add to list
19 Lesons
1 hour 16 minutes
On-Demand
Free-Video
ExcelIsFun

Visualizing Data and Building Dashboards in Excel & Power BI

0 rewiews
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.
Add to list
22 Lesons
1 hour 42 minutes
On-Demand
Free-Video
ExcelIsFun

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

0 rewiews
Master Excel array formulas with 50 practical examples, covering fundamental concepts, advanced functions, and real-world applications for data analysis and reporting.
Add to list
17 Lesons
1 hour 10 minutes
On-Demand
Free-Video
Learnit Training

Excel 2019 Power User Tutorial

0 rewiews
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.
Add to list
18 Lesons
1 hour 15 minutes
On-Demand
Free-Video
ExcelIsFun

Excel Formulas for Counting and Adding: COUNT, COUNTA, ROWS, SUM, SUMIFS, COUNTIFS and IF Functions - Part 2

0 rewiews
Master essential Excel formulas and functions for counting and adding data, including COUNT, COUNTA, SUMIFS, and advanced logical tests for analyzing business data with multiple conditions.
Add to list
20 Lesons
52 minutes
On-Demand
Free-Video