Excel Is Fun

Highline Excel 2016 Class 01

July 16, 2016 0

Excel Fundamentals: Efficiency, Data, Data Sets, Formatting DESCRIPTION In this video learn about these Excel Fundamentals for Excel Highline Excel 2016 Class: (00:33) Prerequisites for class (01:04) Excel Professional 2016 (01:50) Install Com Add-in Power […]

Excel Is Fun

Excel Magic Trick 1125

April 25, 2015 0

DESCRIPTION See how to use Data Validation Custom Formula to verify that dates entered into cells are in current month and are NOT a weekend or holiday. See the AND and NETWORKDAYS.INTL functions as well […]

Excel Is Fun

Excel Magic Trick 1124

April 24, 2015 0

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

April 12, 2015 0

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 […]

Excel 2013 PowerPivot Basics

Excel 2013 PowerPivot Basics 06

April 6, 2015 0

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 […]

Excel Is Fun

Excel Magic Trick 1112

March 10, 2015 0

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) […]

Excel Is Fun

Excel Magic Trick 1109

March 7, 2015 0

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 […]

Excel Is Fun

Excel Magic Trick 1108

March 6, 2015 0

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 […]

Excel Is Fun

Excel Magic Trick 1105

March 3, 2015 1

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 […]

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 […]