Excel Is Fun

Excel Magic Trick 1469

DESCRIPTION Learn about how to take a rainfall data set with Time-Date Stamps and add rain totals for each day and have the ability to change the definition of the 24 hour period. Topics: (00:11) [Read More >>>]

Excel Is Fun

Office 2016 39

DESCRIPTION Topics in this Video: (00:01) Introduction (01:56) Create New Database (03:52) Save and Default Table (we’ll edit later) and talk about data that goes into table. (05:36) Import SupplierData Table from an Excel (08:08) [Read More >>>]

Excel Is Fun

Office 2016 27

DESCRIPTION Topics in this video: (00:01) Introduction (01:15) Example 1: Excel Table feature for VLOOKUP & Data Validation List (07:10) Example 2: Excel Table feature for Chart (09:45) Example 3: Excel Table feature for PivotTable [Read More >>>]

Excel Is Fun

Office 2016 26

DESCRIPTION Topics in this video: (00:01) Introduction (01:10) Should we use IF or VLOOKUP? (02:12) What does VLOOKUP do? (03:22) Examples of Lookup Tables (06:14) What does “V” in VLOOKUP mean? (06:41) Formula 1: Exact [Read More >>>]

Excel Is Fun

Excel Magic Trick 1426

DESCRIPTION See how to: (00:11) Introduction (00:51) Count Columns with COLUMNS Function (01:08) Count Rows with ROWS function (01:30) Count Unique Numbers using FREQUENCY and SUM Functions (04:41) Create Data Validation Drop Down List of [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 10

DESCRIPTION In this video learn about: (00:16) Introduction (00:46) Data Validation to allow only whole numbers between an upper and lower limit (02:12) Create an Input Message for your Data Validation (02:31) Error Message with [Read More >>>]

Excel Is Fun

Highline Excel 2016 Class 04

DESCRIPTION In this video learn about: (00:04) Download Files (00:30) Introduction to types of References (01:38) Example 1: Not Copying Formula. Goal: Calculate Net Income. (02:09) Example 2: Not Copying Formula. Goal: Estimate the Future [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 >>>]

Excel Is Fun

Excel Magic Trick 1353

DESCRIPTION See how to use the Power Query (Get & Transform) Inner Join Merge Feature to Extract Records (Data) from an Excel Table based on Criteria from cells in an Excel sheet (Criteria in a [Read More >>>]