Excel Is Fun

Excel Magic Trick 1418

DESCRIPTION See how to use Standard PivotTables to rank profits and profits per unit for both All The Products and Products within Manufacturer: (00:10) Introduction (01:31) PivotTable #1 for Total Profit per Product and Ranking [Read More >>>]

Excel Is Fun

Excel Magic Trick 1400

DESCRIPTION See how to Conditionally Format the row in an Enrollment Table when the following conditions are met: 1. Enrollment less than or equal to 15, then format row 2. Name Column can NOT contain: [Read More >>>]

Excel Is Fun

Excel Magic Trick 1391

DESCRIPTION See how to create a formula to perform Case Sensitive Lookup: (00:10) Introduction (00:16) VLOOKUP by itself will NOT work. (01:19) Formula #1: SUMPRODUCT & EXACT functions to lookup Numbers based on a Case [Read More >>>]

Excel Is Fun

Highline Excel 2016 Class 16

DESCRIPTION In this video learn about Conditional Formatting Topics : (00:16) Introduction (00:43) Built-in Feature: Cell Contains (03:28) Logical Formula: Highlight Row (Record) where cell contains a value. (10:00) Built-in Feature: Below Average (10:55) Logical [Read More >>>]

Excel Is Fun

Excel Magic Trick 1383

DESCRIPTION See how to Conditionally Format each row in a Data Set that has a Job Title that contains any text item from within a list. Learn about “Contains Criteria” in an OR Logical Test: [Read More >>>]

Excel Is Fun

Excel Magic Trick 1382

DESCRIPTION See how to: (00:15) Introduction to Contains Criteria (Partial Text Criteria) in an OR Logical Test, when search for records with Multiple Contains Criteria. (02:00) #1 Filter & Helper Column with Formula that uses [Read More >>>]

Excel Is Fun

Highline Excel 2016 Class 12

DESCRIPTION In this video learn about: (00:13) Introduction (00:30) Helper Column Solution with Join Operator and VLOOKUP (03:31) Array Formula with: INDEX and MATCH functions and a Join Array Operations. This formula requires Ctrl + [Read More >>>]

Excel Is Fun

Highline Excel 2016 Class 11

DESCRIPTION In this video learn about: (00:12) Introduction (00:51) Data Validation List. VLOOKUP, Exact Match. IF & ISBLANK functions. Goal: Create Invoice. (09:43) HLOOKUP with Exact Match Lookup. Goal: Lookup Tyrone’s Phone Number. Horizontal Lookup [Read More >>>]

Excel Is Fun

Highline Excel 2016 Class 03

DESCRIPTION In this video learn about the fundamentals of Data Analysis and Business Intelligence in Excel 2016: Sort, Filter, PivotTables, Power Query, Power Pivot Data Model: (00:00:05) Introduction (00:01:39) Sort (00:03:02) Sorting one column (00:03:23) [Read More >>>]

Excel Is Fun

Highline Excel 2016 Class 02

DESCRIPTION In this video learn about: (00:13) Introduction (01:09) Excel’s Golden Rule (04:31) Look at list of Formula Types and Formula Elements (06:29) Number Formula Examples (08:24) Text and Number Formulas for counting numbers above [Read More >>>]