01:50

How to use the SUM function in Excel

03:28

How to sort data in Excel

03:41

How to use the XLOOKUP function in Excel

05:04

How to use the MATCH function in Excel

02:51

How to use the TEXTJOIN function in Excel

07:00

How to use a WHILE Loop in Excel VBA

02:16

How to use the COUNTA function in Excel

03:54

How to use the CONCAT function in Excel (vs the CONCATENATE function)

04:28

How to use the MINIFS function in Excel

05:09

How to use the Excel MAXIFS Function

05:49

How to use a FOR Loop in Excel VBA

06:32

How to use the IF-THEN-ELSE statement in Excel VBA

05:02

How to use Aliases in SQL

04:40

How to use the COUNTIFS function in Excel

04:52

How to use the JavaScript findIndex (Array method)

03:04

How to highlight the top score (highest value) in an Excel table

02:49

How to use the MID function in Excel

03:13

How to use the FIND function in Excel

02:25

How to use the SQL IS NULL Condition

02:47

How to use the AVERAGEIF function in Excel

03:04

How to find the closest larger number in an unordered list of values in Excel

02:11

How to use the COUNTIF function in Excel

03:57

How to use the IFS function in Excel

02:27

How to use the SQL LIKE Condition

02:54

How to use the SWITCH function in Excel

01:55

How to create a Pie Chart in Excel

02:17

How to use the SQL DELETE Statement

03:02

How to use the NETWORKDAYS function in Excel

03:05

How to use the EOMONTH function in Excel

01:57

How to use the BETWEEN Condition in SQL

02:12

How to create a Column Chart in Excel

01:52

How to use the CHOOSE function in Excel

02:20

How to use the SQL UPDATE Statement

02:05

How to create a Line Chart in Excel

04:17

How to use the SQL INSERT Statement

02:52

How to use the AND Condition with the OR Condition in SQL

02:47

How to use the INDEX function in Excel

03:08

How to use the SQL SELECT Statement

02:15

How to create a Pivot Table in Excel

02:42

How to use the IF function with the AND function in Excel

03:36

How to use the IF function in Excel

02:34

How to use the SUMIF function in Excel

03:01

How to use the HLOOKUP function in Excel

02:58

How to use the VLOOKUP function in Excel