Excel 2013 PowerPivot Basics

Excel 2013 PowerPivot Basics 12

DESCRIPTION See how to create Student GPA Grade by Class for each High School, with each report on a new sheet, automatically using a PivotTable and Show Report Filter Pages. This feature is NOT available [Read More >>>]

Excel 2013 PowerPivot Basics

Excel 2013 PowerPivot Basics 06

DESCRIPTION See how to Import, Filter, Edit Data From Access, Excel, Text Files into one Data Model, including importing new tables and columns and deleting tables after an existing connection is established: (00:28) goal of [Read More >>>]

Excel Is Fun

Excel Magic Trick 1112

DESCRIPTION (01:06) Group By Date In PivotTable Error (Cannot group that selection error) (01:42) Text To Columns To Convert Text Dates To Dates (02:53) Text To Columns Fatal Error (Microsoft Excel has stopped working error) [Read More >>>]

Excel Is Fun

Excel Magic Trick 1109

DESCRIPTION See how to Compare Two Lists and Extract Records with Excel Advanced Filter: 1. Extract items in list 2 that are NOT in List 1 using Advanced Filter and Logical Formula in Criteria Area [Read More >>>]

Excel Is Fun

Excel Magic Trick 1108

DESCRIPTION See how to Compare Two Lists and Extract Records: 1. ISNA and MATCH function with Filter to extract items in list 2 that are NOT in List 1. 2. ISNUMBER and MATCH function with [Read More >>>]

Excel Is Fun

Excel Magic Trick 1105

DESCRIPTION See how and why to use the DMIN function for calculating the minimum value with two conditions/criteria. Rules for D Functions: We must have: 1) Proper data Set w/ Field Names 2) We can [Read More >>>]

Excel Is Fun

Highline Excel 2013 Class Video 18

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 [Read More >>>]

Dueling Excel

Dueling Excel 005

DESCRIPTION See Mr Excel and excelisfun try and create Horizontal Subtotals for a data set. See the IF, SUM and SUMIF functions as they try to solve this very difficult problem. Also see Conditional Formatting [Read More >>>]

Excel Is Fun

Highline Excel 2013 Class Video 15

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 [Read More >>>]

Excel Is Fun

Excel Magic Trick 1098

DESCRIPTION See how to compare two e-mail lists where one list has extra semi-colons: (00:28) Find and Replace feature to remove semi-colons (Ctrl + H). (01:32) Is in List: MATCH and ISNUMBER functions. (03:20) Is [Read More >>>]