Excel Procedure and Function Videos

Please report dead links, corrections, or suggestions to Larry Schrenk.

NOTE: The videos listed below should be completed (including accurate captioning and transcripts) by mid-semester Fall 2022.

PROCEDURES

Basic

Cell Formats I (9:04) xlsx

Cell Formats II (10:00) xlsx

Charts, Intro (15:45) xlsx

Copying, Moving, and Pasting (8:34) xlsx

Creating and Saving (9:09) xlsx

Deleting (13:37) xlsx

Entering Data (14:04) xlsx

Excel Tour (11:12) xlsx

Font Formats (14:27) xlsx

Formulae, Intro I (4:44) xlsx

Formulae, Intro II (10:21) xlsx

Number Formats I (10:14) xlsx

Number Formats II (13:01) xlsx

Paste Special (14:05) xlsx

Printing (6:04) xlsx

Search, Sort, and Filter (17:49) xlsx

Intermediate  

Add-ins (8:36) xlsx

Auto-Fill and Flash Fill (:) xlsx

Cell References (14:25) xlsx

Dynamic Arrays, Intro (6:08) xlsx

Freezing and Splitting (5:11) xlsx 

Histograms (6:42) xlsx

Hyperlinks (:) xlsx

Linear Regression (14:32) xlsx

Quick Access Toolbar, Ribbon (:) xlsx

Short Cuts (4:12) xlsx 

Status Bar (4:10) xlsx

Tables (:) xlsx

Trendlines (6:27) xlsx

Advanced

Analyze Data (:) xlsx

Conditional Formatting (:) xlsx 

Data Validation (:) xlsx 

Data Visualization (:) xlsx 

Fuzzy Matching (:) xlsx 

Import Data (:) xlsx 

Macros (:) xlsx

Naming (:) xlsx 

Protection (:) xlsx

Quick Analysis (:) xlsx 

Remove Duplicates (:) xlsx

Solver, Goal Seek (:) xlsx

Sparklines (:) xlsx 

FUNCTIONS

Logical

AND, OR, XOR (15:03) xlsx  

TRUE (:) xlsx

FALSE (15:03) xlsx

IF, IFS (10:49) xlsx

IFERROR (5:11) xlsx  

NA (2:05 xlsx

Count/Search/Find/Select/Sort

COUNT, COUNT, COUNTA, COUNTIF (5:31) xlsx  

FIND, SEARCH (12:22) xlsx  

INDEX (:) xlsx

CHOOSE (2:32) xlsx

SWITCH (3:18) xlsx  

Math

ABS (:) xlsx

LN, EXP (1:38) xlsx  

MAX, MIN (2:01) xlsx

SMALL, LARGE (2:04) xlsx

ROUND, ROUNTUP, ROUNDDOWN, INT (5:02) xlsx  

ROW, COLUMN (2:53) xlsx  

SUM (4:05) xlsx

SUMXMY2, SUMPROD (8:17) xlsx

Array Functions (Linear Algebra)

MMULT(array1, array2) Matrix multiplication (:) xlsx

TRANSPOSE(array) Matrix transpose (:) xlsx

Dates and Times

DATE, TIME, YEAR, MONTH, DAY, TODAY, NOW (12:52) xlsx

DAYS360, YEAREFRAC, EDATE (6:55) xlsx

Text

CONCAT, TEXTJOIN (8:21) xlsx

Formatting

TEXT (5:00) xlsx

Probability and Statistics

AVERAGE, AVERAGEA, AVERAGEIF (9:56) xlsx

MODE, MEDIAN (2:46) xlsx

GEOMEAN (11:13) xlsx

VAR, STDEV, SKEW, KURT (5:47) (xlsx not available)  

CORREL, COVARIANCE (3:17) xlsx

INTERCEPT, SLOPE, TREND (17:39) xlsx  

NORM.S.DIST (4:28) xlsx  

Forecasting

FORECAST (:) xlsx

Dynamic Array Functions

FILTER (7:17) xlsx

RANDARRAY (:) xlsx

SEQUENCE (10:39) xlsx

SORT, SORTBY (:) xlsx

UNIQUE (:) xlsx

XLOOKUP (:) xlsx

Finance

FV, PV (10:30) xlsx 

PMT, NPER, RATE (16:45) xlsx

NPV (10:10) xlsx  

IRR, MIRR (10:40) xlsx

Depreciation

SLN, SYD, DB, DDB, VDB (9:28) xlsx  

Interest Rates

EFFECT, NOMINAL (7:10) xlsx

Bonds

PRICE, YIELD, DISC, YIELDDISC (11:12) xlsx  

DURATION, MDURATION (4:23) xlsx

Pivot Tables

GETPIVOTDATA (:) xlsx