Excel Is Fun

Excel Magic Trick 1124

DESCRIPTION See how to Conditional Format Weekends & Holidays using the NETWORKDAYS.INTL & NOT functions. Conditionally format serial dates for weekends and holidays. Conditional Formatting. Format Conditionally. Logical Formulas. Format holidays and weekends. WORKBOOKS

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 40

DESCRIPTION Topics in this video: 1. Built-in Conditional Formatting. Conditional Formatting to cells: A logical test that comes out TRUE or FALSE. TRUE = get Formatting. FALSE = Not get Formatting. 2. Highlight Cell Rules: [Read More >>>]

Excel Is Fun

Highline Excel 2013 Class Video 37

DESCRIPTION Topics in this video: 1. Advanced Filter: Cross Between Filter and Database Functions. 2. Advanced Filter 3 Areas: Criteria Area Data Set Extract Area: Be sure to keep area below CLEAR!!!! 3. Advanced Filter [Read More >>>]

Excel Is Fun

Highline Excel 2013 Class Video 26

DESCRIPTION Topics in this video: 1. Is Item In List 2 also in List 1? Use MATCH and ISNUMBER. Comparing a prospective customer sales phone list to the companies master customer list. 2. Sort Dialog [Read More >>>]