AVERAGEIFS Courses and Certifications

Learn Excel in 60 Minutes: Using Real Company Data

1977 ratings at Udemy

Filtering, SUMIFS, Pivot Tables, Conditional Formatting

• Udemy
• 50 minutes
• On-Demand
• Free Online Course

ExcelIsFun

Excel Basics - SUMIFS, COUNTIFS, AVERAGEIFS Functions Calculations With One or More Criteria

Master advanced Excel functions like SUMIFS, COUNTIFS, and AVERAGEIFS for data analysis. Learn to apply multiple criteria, use logical tests, and leverage Excel tables for efficient calculations.

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

Learnit Training

Excel 2016 Advanced Tutorial

Master advanced Excel techniques including named ranges, complex functions, data consolidation, solver tools, and macros to enhance your data analysis and productivity skills.

• YouTube
• 2 hours 39 minutes
• On-Demand
• Free Video

ExcelIsFun

Excel Formulas - Basics and Beyond

Master Excel formula fundamentals from basic references to advanced array formulas, VLOOKUP, SUMIFS, and error tracking techniques for efficient spreadsheet building.

• YouTube
• 15 hours 45 minutes
• On-Demand
• Free Video

ExcelIsFun

Excel Spreadsheet Formulas - Old School or Dynamic Arrays?

Learn to use Excel formulas for data analysis, comparing traditional methods with dynamic arrays. Master SUMIFS, COUNTIFS, and AVERAGEIFS for creating effective summary reports.

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

ExcelIsFun

Logical Tests - Excel Formulas, Conditional Formatting, PivotTables, Power Query, and More

Master Excel's logical functions, formulas, and advanced features. Learn to create powerful data analysis tools using PivotTables, conditional formatting, and Power Query for efficient data management.

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

Ctrl - Shift - Enter - Excel Array Formulas - Boolean Logic, AND & OR Criteria, Convert TRUE FALSE

Aprenda a usar fórmulas de matriz avançadas no Excel, incluindo lógica booleana, critérios AND e OR, e conversão de TRUE/FALSE para análise de dados eficiente.

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

ExcelIsFun

Average, Moving Average at Different Granularity - DAX or Excel Formulas

Learn advanced Excel and DAX techniques for calculating averages and moving averages at different granularities, enhancing your data analysis skills for more accurate financial reporting.

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

Learnit Training

Excel Introduction to Data Analysis Tutorial

Learn essential Excel data analysis techniques: formatting, conditional functions, charting, and Pivot Tables. Gain skills to summarize, visualize, and extract insights from your data effectively.

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

Learnit Training

Excel for HR Professionals - Data Management and Analysis Fundamentals

Master essential Excel functions and tools specifically designed for HR tasks, from data organization and calculations to creating dynamic visualizations for workforce analytics and reporting.

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