Excel Is Fun

Highline Excel 2013 Class Video 21

February 20, 2015 0

DESCRIPTION Topics in this video: (00:10) INDEX and MATCH. (00:32) Lookup Left, 1-way vertical range lookup. (04:41) Lookup Low Bid, 1-way horizontal range lookup. (08:27) 2-way lookup to lookup discount rate. (13:14) Lookup Whole Row […]

Excel Is Fun

Highline Excel 2013 Class Video 20

February 19, 2015 0

DESCRIPTION Topics in this video: (00:15) VLOOKUP to retrieve whole record change columns manually. (02:20) VLOOKUP to retrieve whole record column number in cell. (03:43) VLOOKUP & MATCH to retrieve whole record — more dynamic […]

Excel Is Fun

Highline Excel 2013 Class Video 19

February 18, 2015 0

DESCRIPTION Topics in this video: (00:11) Text Functions. (00:23) Partial Text Lookup: RIGHT & VLOOKUP. (02:17) Partial Text Lookup: LEFT and SEARCH & VLOOKUP. (05:56) Partial Text Lookup: MID & VLOOKUP. (07:51) Converting Numbers Stored […]

Excel Is Fun

Highline Excel 2013 Class Video 18

February 17, 2015 0

DESCRIPTION Topics in this video: (00:38) Why do we have to know lookup functions? (03:44) VLOOKUP, Exact Match. VLOOKUP delivers a value to the cell. (08:34) What happens if lookup value is not in your […]

Excel Is Fun

Highline Excel 2013 Class Video 17

February 16, 2015 0

DESCRIPTION Topics in this video: (00:35) Bank Deposit Example: Multiply and then Add in Succession. (02:37) Grade Book Weighted Average Example: Multiply and then Add in Succession. (03:30) Accounting Budget Weighted Average Example: Multiply and […]

Excel Is Fun

Highline Excel 2013 Class Video 16

February 15, 2015 0

DESCRIPTION Topics in this video: (00:09) ROUND function so Invoices and Payroll spreadsheets are accurate. (03:49) ROUND to the penny, dollar or thousands position. (04:28) ROUND, ROUNDUP, ROUNDDOWN functions round to a digit or position. […]

Excel Is Fun

Highline Excel 2013 Class Video 15

February 14, 2015 0

DESCRIPTION Topics in this video: (00:33) IF Function to deliver numbers. (01:37) IF Function to deliver text. (03:19) IF Function to deliver formulas. (05:19) IF Function to deliver functions. (07:51) Nested IFs. (10:24) Null Text […]

Excel Is Fun

Highline Excel 2013 Class Video 14

February 13, 2015 0

DESCRIPTION Topics in this video: Analyze customer credit worthiness with logical formulas: (00:23) Analyze customer credit worthiness. (01:42) AND functions. (03:45) IF function and AND function. (06:05) OR function. (07:47) Formula Evaluator (Evaluate Formula) = […]

Excel Is Fun

Highline Excel 2013 Class Video 13

February 12, 2015 0

DESCRIPTION Topics in this video: (00:37) Excel TABLE. (01:04) Total Row. (01:59) AND Criteria with Table Feature. (04:07) OR Criteria with Table Feature. (04:40) AND and OR Criteria with Table Feature. WORKBOOKS