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

#COUNTIFS

Showing: 13 courses
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

Excel Spreadsheet Formulas - Old School or Dynamic Arrays?

0 rewiews
Learn to use Excel formulas for data analysis, comparing traditional methods with dynamic arrays. Master SUMIFS, COUNTIFS, and AVERAGEIFS for creating effective summary reports.
Add to list
15 Lesons
30 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 - Boolean Logic, AND & OR Criteria, Convert TRUE FALSE

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

Excel Intermediate Functions & Features

0 rewiews
Master advanced Excel functions like IF, VLOOKUP, IFS, and custom formatting. Learn time-saving techniques, data manipulation, and presentation skills to enhance productivity and analysis capabilities.
Add to list
14 Lesons
2 hours 30 minutes
On-Demand
Free-Video
Simon Sez IT

Logical Functions in Excel Tutorial

0 rewiews
Learn to use Excel's logical functions like IF, IFS, COUNTIF, and SUMIF. Master simple tests, nested statements, and error checking for efficient data analysis and decision-making.
Add to list
9 Lesons
45 minutes
On-Demand
Free-Video
Simon Sez IT

How to Create a Stunning Interactive Dashboard in Excel - Sales Excel Dashboard Crash Course

0 rewiews
Step-by-step guide to creating an interactive sales dashboard in Excel, covering data setup, calculations, dynamic charts, and advanced features for a comprehensive and visually appealing analysis tool.
Add to list
15 Lesons
1 hour 54 minutes
On-Demand
Free-Video
ExcelIsFun

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

0 rewiews
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.
Add to list
34 Lesons
1 hour 48 minutes
On-Demand
Free-Video
LiquidBrain Bioinformatics

Batch Create Reports with App Scripts

0 rewiews
Learn to automate report generation in Google Sheets using Apps Script. Create tables, graphs, and text replacements without add-ons, streamlining data processing from raw CDC EU information.
Add to list
11 Lesons
39 minutes
On-Demand
Free-Video
Simon Sez IT

Top 10 Excel Formulas for Beginners - Essential Functions Tutorial

0 rewiews
Master essential Excel formulas with step-by-step guidance. Learn VLOOKUP, IF statements, COUNTIF, and more. Practical examples and timestamps for easy navigation make this tutorial perfect for beginners.
Add to list
13 Lesons
1 hour 32 minutes
On-Demand
Free-Video
linux.conf.au

The Joy of Spreadsheets

0 rewiews
Explore the versatile world of spreadsheets, from practical applications to quirky uses. Discover the power of familiar interfaces, built-in functions, and macros in this entertaining journey through "boring" technology.
Add to list
1 Lesons
19 minutes
On-Demand
Free-Video
Learnit Training

Excel for HR Professionals - Data Management and Analysis Fundamentals

0 rewiews
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.
Add to list
18 Lesons
1 hour 20 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