Excel - MAXIFS & MINIFS Tutorial

Convert a picture into Data with Excel

• 0:25
• Viewed 1816 times

3D Maps

• 1:41
• Viewed 1386 times

Create a combo chart

• 1:47
• Viewed 1376 times

Introduction to Excel

• 0:59
• Viewed 1256 times

The nuts and bolts of VLOOKUP

• 3:05
• Viewed 1208 times

AutoFill

• 2:55
• Viewed 1157 times

The SUMIF function

• 5:27
• Viewed 1089 times

The SUM function

• 4:37
• Viewed 1062 times

How to simultaneously edit and calculate formulas across multiple worksheets

• 3:07
• Viewed 1061 times

Customize charts

• 4:28
• Viewed 1055 times

Operator order

• 2:04
• Viewed 1049 times

Assign a button to a macro

• 2:49
• Viewed 1040 times

Functions and formulas

• 3:24
• Viewed 1037 times

Advanced formulas and references

• 4:06
• Viewed 1033 times

Top tips for working in Excel Online

• 3:35
• Viewed 1029 times

COUNTIFS and SUMIFS

• 5:30
• Viewed 1027 times

Drop-down list settings

• 4:14
• Viewed 1013 times

Using functions

• 5:12
• Viewed 1010 times

Three ways to add numbers in Excel Online

• 3:15
• Viewed 990 times

Add numbers

• 2:54
• Viewed 979 times

One click Forecasting

• 1:01
• Viewed 976 times

More complex formulas

• 4:17
• Viewed 975 times

Basic math

• 2:28
• Viewed 973 times

Print worksheets and workbooks

• 1:07
• Viewed 972 times

Freeze panes in detail

• 3:30
• Viewed 966 times

AutoFilter details

• 3:27
• Viewed 960 times

Ink Equation

• 0:41
• Viewed 959 times

Improved version history

• 0:51
• Viewed 951 times

Work with macros

• 4:40
• Viewed 949 times

Sort details

• 4:46
• Viewed 943 times

Copy a VLOOKUP formula

• 3:27
• Viewed 942 times

Manage drop-down lists

• 6:12
• Viewed 933 times

Look up values on a different worksheet

• 2:39
• Viewed 930 times

AVERAGEIFS and IFERROR

• 4:45
• Viewed 930 times

Manage conditional formatting

• 4:30
• Viewed 928 times

Password protect workbooks and worksheets in detail

• 6:00
• Viewed 926 times

Password protect workbooks and worksheets

• 2:27
• Viewed 924 times

VLOOKUP: How and when to use it

• 2:38
• Viewed 918 times

New Chart types

• 1:52
• Viewed 915 times

Use formulas to apply conditional formatting

• 4:20
• Viewed 915 times

Print headings, gridlines, formulas, and more

• 4:29
• Viewed 910 times

Create pie, bar, and line charts

• 3:13
• Viewed 908 times

Input and error messages

• 2:52
• Viewed 907 times

How to simultaneously view multiple worksheets

• 3:25
• Viewed 905 times

Add formulas and references

• 2:52
• Viewed 904 times

How to use 3-D reference or tridimensional formulas

• 3:01
• Viewed 903 times

AutoFill and Flash Fill

• 1:36
• Viewed 902 times

Use conditional formatting

• 2:02
• Viewed 902 times

Insert headers and footers

• 2:02
• Viewed 901 times

IFS

• 1:05
• Viewed 897 times

Sort, filter, summarize and calculate your PivoteTable data

• 3:49
• Viewed 895 times

Freeze or lock panes

• 1:06
• Viewed 894 times

Share documents

• 1:13
• Viewed 893 times

More print options

• 5:59
• Viewed 893 times

Copying formulas

• 3:00
• Viewed 892 times

Print a worksheet on a specific number of pages

• 4:34
• Viewed 888 times

Save your macro

• 2:59
• Viewed 888 times

Cell references

• 1:34
• Viewed 876 times

Weighted average

• 2:06
• Viewed 873 times

AVERAGEIF function

• 3:04
• Viewed 868 times

Start using Excel

• 4:22
• Viewed 866 times

Save and print an Excel workbook

• 1:53
• Viewed 864 times

Translate your Excel spreadsheets

• 1:16
• Viewed 855 times

How to link cells and calculate formulas across multiple worksheets

• 2:10
• Viewed 853 times

IF with AND and OR

• 3:35
• Viewed 852 times

Copy a chart

• 2:59
• Viewed 851 times

Header and footer details

• 3:41
• Viewed 848 times

Start with "Ideas" in Excel

• 0:38
• Viewed 847 times

Subtract time

• 3:58
• Viewed 842 times

A first look at Excel 2016

• 3:22
• Viewed 839 times

A closer look at the ribbon

• 3:55
• Viewed 837 times

Insert columns and rows

• 4:16
• Viewed 836 times

Create a PivotTable report manually

• 4:59
• Viewed 828 times

Average a group of numbers

• 2:01
• Viewed 827 times

Drop-down lists

• 0:55
• Viewed 826 times

Take conditional formatting to the next level

• 3:37
• Viewed 818 times

Create a PivotTable and analyze your data

• 1:35
• Viewed 811 times

Copy and remove conditional formatting

• 1:11
• Viewed 804 times

How to create a table

• 2:11
• Viewed 802 times

Sort and filter data

• 1:38
• Viewed 800 times

Get going fast

• 1:38
• Viewed 793 times

Combine data from multiple worksheets

• 2:50
• Viewed 793 times

Flash Fill

• 2:59
• Viewed 780 times

Microsoft Search

• 0:34
• Viewed 779 times

Conditionally format dates

• 2:38
• Viewed 775 times

Advanced filter details

• 4:13
• Viewed 773 times

TEXTJOIN

• 0:47
• Viewed 772 times

Conditionally format text

• 2:12
• Viewed 771 times

How to track and monitor values with the Watch Window

• 2:42
• Viewed 769 times

Create a chart

• 0:52
• Viewed 766 times

Save, publish, and share

• 2:22
• Viewed 766 times

Advanced IF functions

• 3:22
• Viewed 764 times

Use slicers to filter data

• 1:25
• Viewed 757 times

Edit a macro

• 3:29
• Viewed 749 times

Work simultaneously with others on a workbook

• 0:43
• Viewed 744 times

How things are organized

• 1:58
• Viewed 734 times

SWITCH

• 1:03
• Viewed 726 times

CONCAT

• 0:51
• Viewed 715 times

Map Chart in Excel

• 0:31
• Viewed 702 times

Page numbers in depth

• 3:06
• Viewed 699 times

Funnel Chart

• 0:33
• Viewed 698 times

Nested IF functions

• 3:30
• Viewed 681 times

Check Accessibility in Excel

• 1:51
• Viewed 531 times

Accessibility in Excel

• 1:12
• Viewed 527 times

Introduction to Power Query

• 3:35
• Viewed 471 times

Convert a timestamp to date

• 2:41
• Viewed 460 times

Automatic Data Entry in Excel

• 0:41
• Viewed 457 times

Bubble chart

• 2:46
• Viewed 445 times

Add filters

• 3:00
• Viewed 442 times

Boolean logic

• 3:11
• Viewed 438 times

Convert a number of seconds to a time format

• 1:53
• Viewed 428 times

Scatter plot

• 2:27
• Viewed 427 times

Display a distribution histogram

• 2:20
• Viewed 425 times

Create a Stock

• 4:37
• Viewed 417 times

Switch values

• 1:51
• Viewed 414 times

Calculate the number of days between two dates

• 3:16
• Viewed 413 times

Dynamically get today's date

• 3:34
• Viewed 413 times

Manage multiple values

• 2:29
• Viewed 410 times

Relationship charts between available properties

• 3:16
• Viewed 410 times

Split a column

• 3:15
• Viewed 409 times

Ranking charts by importance

• 4:05
• Viewed 409 times

Delete columns

• 3:38
• Viewed 407 times

Group by values

• 2:19
• Viewed 401 times

Manage multiple sets of conditions

• 5:17
• Viewed 400 times

Add slicers

• 4:43
• Viewed 399 times

Display box and whisker diagrams

• 3:27
• Viewed 399 times

Apply multiple conditions on the number of values

• 2:23
• Viewed 396 times

Power Query overview

• 3:24
• Viewed 396 times

Introduction to Data Visualization

• 0:58
• Viewed 396 times

The VLOOKUP function

• 4:10
• Viewed 395 times

Overview of set and subset graphs

• 3:47
• Viewed 395 times

Tips and best practices

• 8:51
• Viewed 393 times

The data analysis cycle

• 3:37
• Viewed 392 times

Your first PivotTable

• 6:45
• Viewed 390 times

Basic conditions

• 2:45
• Viewed 387 times

Change chart type

• 1:29
• Viewed 387 times

Areas

• 4:32
• Viewed 386 times

Create a Waterfall chart

• 2:26
• Viewed 385 times

Combo chart

• 2:18
• Viewed 385 times

Use Power Pivot in a PivotTable

• 2:14
• Viewed 384 times

Use table references

• 1:39
• Viewed 384 times

Create a PivotChart

• 3:29
• Viewed 383 times

Automatically add capital letters to text

• 1:52
• Viewed 382 times

Add categories to a scatter plot

• 1:23
• Viewed 382 times

Introduction to PivotTables

• 2:23
• Viewed 381 times

Add a conditional column

• 4:52
• Viewed 381 times

Replace values

• 0:53
• Viewed 381 times

Merge two columns

• 3:27
• Viewed 381 times

Customize the items displayed on a chart

• 3:34
• Viewed 380 times

Change the calculation type on a column

• 1:55
• Viewed 378 times

Retrieve unique items from a list

• 1:26
• Viewed 377 times

Create measurement functions

• 7:52
• Viewed 375 times

Map

• 1:47
• Viewed 375 times

Bar chart

• 3:12
• Viewed 373 times

Get the week and weekday number of a date

• 1:59
• Viewed 372 times

Convert separate items to date format

• 1:16
• Viewed 371 times

Overview of Financial Analysis Charts

• 3:20
• Viewed 371 times

Add segment on PivotCharts

• 2:06
• Viewed 370 times

Create relationships between tables

• 6:44
• Viewed 370 times

Stacked Bar Chart

• 3:29
• Viewed 370 times

Understanding distribution charts for a series of values

• 8:31
• Viewed 369 times

Remove unnecessary spaces from text

• 2:19
• Viewed 368 times

Create a Sunburst

• 3:19
• Viewed 367 times

Import data from an API

• 3:59
• Viewed 366 times

Funnel

• 2:10
• Viewed 366 times

Sparklines

• 2:44
• Viewed 366 times

Concatenate text

• 3:01
• Viewed 362 times

Remove duplicates

• 1:48
• Viewed 360 times

Create a two-dimensional PivotTable

• 2:31
• Viewed 359 times

Import a table into the data model

• 1:12
• Viewed 359 times

Logical operators

• 2:23
• Viewed 359 times

Radar

• 4:50
• Viewed 359 times

The value references of a PivotTable

• 2:30
• Viewed 358 times

Import options presentation

• 3:57
• Viewed 357 times

Retrieve part of a cell's text from the left or right

• 4:20
• Viewed 357 times

The main principles of data visualization

• 10:56
• Viewed 355 times

Duplicate a column

• 2:00
• Viewed 354 times

Create a Treemap

• 3:40
• Viewed 353 times

Power Pivot Overview and Installation

• 1:43
• Viewed 352 times

How to refresh your data after import

• 1:15
• Viewed 350 times

Refresh a PivotTable

• 1:58
• Viewed 348 times

Determine minimums and maximums based on criteria

• 1:31
• Viewed 346 times

Recreate the coordinates of a cell

• 3:37
• Viewed 346 times

Definition of statistical metrics

• 6:32
• Viewed 345 times

Import an Excel file

• 2:28
• Viewed 344 times

Increment a one-day date

• 3:46
• Viewed 340 times

Sort your data

• 2:09
• Viewed 337 times

How to install Power Query

• 1:25
• Viewed 336 times

Determine minimums and maximums

• 1:48
• Viewed 333 times

Double conditions

• 3:50
• Viewed 332 times

The HLOOKUP function

• 2:20
• Viewed 332 times

Import a series of files into a folder

• 2:58
• Viewed 327 times

Add a column off an example

• 2:06
• Viewed 325 times

Retrieve a set of values from a reference

• 4:20
• Viewed 325 times

Available trend charts

• 2:11
• Viewed 325 times

Retrieve information from a date

• 1:34
• Viewed 324 times

Change the order of columns

• 1:44
• Viewed 320 times

Refer to a table by appying filters and sorts

• 2:49
• Viewed 320 times

Retrieve part of a text in a cell

• 4:56
• Viewed 319 times

Pie chart

• 2:30
• Viewed 319 times

Incompatible cell format

• 2:48
• Viewed 317 times

Line options

• 5:07
• Viewed 317 times

Delete rows

• 2:06
• Viewed 316 times

Switch uppercase, lowercase text

• 3:42
• Viewed 316 times

Create your first chart

• 4:12
• Viewed 314 times

Calculate the number of values in a series

• 1:48
• Viewed 309 times

Change the format of a column

• 1:20
• Viewed 301 times

Convert separate items to time

• 1:53
• Viewed 299 times

Create a two-level entry PivotTable

• 1:57
• Viewed 298 times

Add a chart to a dedicated sheet

• 1:30
• Viewed 294 times

Add filters on PivotCharts

• 1:12
• Viewed 292 times

Check the accuracy of two cells

• 1:40
• Viewed 292 times

Calculate the number of characters in a text

• 1:15
• Viewed 281 times

Calculate an average based on criteria

• 2:12
• Viewed 280 times

Change how values are displayed

• 2:08
• Viewed 279 times

Calculate a median

• 1:30
• Viewed 278 times

Problem in cell selection

• 1:24
• Viewed 276 times

Figure too long

• 1:17
• Viewed 276 times

Dividing a number by zero

• 2:19
• Viewed 275 times

Knowing the number of numeric values in a column

• 1:41
• Viewed 269 times

Reference to an invalid cell

• 2:31
• Viewed 269 times

Identify the presence of an expression in text

• 2:12
• Viewed 268 times

Find the most present value in a series

• 0:46
• Viewed 266 times

Know the number of items corresponding to criteria

• 2:27
• Viewed 264 times

The Watch Window

• 2:46
• Viewed 261 times

Integer number too large

• 1:42
• Viewed 260 times

Calculate the standard deviation

• 1:45
• Viewed 257 times

Knowing the number of items in a table

• 2:22
• Viewed 247 times

Obtain the numeric coordinates of a cell

• 3:02
• Viewed 247 times

Search cannot return a value

• 2:49
• Viewed 242 times

Retrieve the number of empty values in a series

• 1:46
• Viewed 234 times

Insert an image in a cell with image function

• 3:01
• Viewed 228 times

XLOOKUP (Basic metrics)

• 4:19
• Viewed 226 times

Create dynamic drop down lists

• 3:26
• Viewed 217 times

Text before & after Function

• 4:57
• Viewed 212 times

XLOOKUP (Advanced metrics)

• 9:30
• Viewed 202 times