AVERAGEIFS Courses and Certifications

Learn Excel in 60 Minutes: Using Real Company Data

1815 ratings at Udemy

Filtering, SUMIFS, Pivot Tables, Conditional Formatting

• Udemy
• On-Demand
• Free Online Course

Excel Statistics and Finance Function Playbook

Save time and reduce errors by using the right functions in Excel. Statistics and finance functions can help you make quick work of reports and evaluations. Learn by example how to use the SUMIFS, AVERAGEIFS, COUNTIFS, NPV, FV, and PV functions.

• Pluralsight
• 1 hour 26 minutes
• On-Demand
• Free Trial Available

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

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

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

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

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

Top Excel Formulas for Accounting and Finance! Become more efficient at your job! Vlookup | Filters

Master essential Excel formulas for finance: Vlookup, IF statements, SumIF, AverageIF, CountIF, TRIM, Concatenate, and more. Boost efficiency with dynamic formulas, shortcuts, and data management techniques.

• Skillshare
• 1 hour 8 minutes
• On-Demand
• Free Trial Available

Excel Statistics and Finance Function Playbook

22 ratings at Pluralsight

Save time and reduce errors by using the right functions in Excel. Statistics and finance functions can help you make quick work of reports and evaluations. Learn by example how to use the SUMIFS, AVERAGEIFS, COUNTIFS, NPV, FV, and PV functions.

• Pluralsight
• 1-2 hours
• Finished
• Free Trial Available