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 35

DESCRIPTION Topics in this video: 1. 3 Reports with Formulas. 2. What is a PivotTable do? a. Summarise data b. “Calculation with criteria” c. Create Reports that contain calculations with conditions/criteria 3. Proper Data Set. [Read More >>>]

Excel Is Fun

Highline Excel 2013 Class Video 34

DESCRIPTION Topics in this video: 1. Subtotals. 2. Alternatives to Subtotal: SUMIFS Formulas and PivotTables. 3. Sort First!!!!!!!!!!!!!!! 4. Add Subtotals based on One Column (Field). 5. Outline. 6. Copy and Paste Subtotal Report Trouble. [Read More >>>]

Excel Is Fun

Highline Excel 2013 Class Video 32

DESCRIPTION Topics in this video: 1. Essential definition of array formula: operation on an array of items rather than single items. 2. Example of operation on single items: subtracting 2 cells. 3. Example of operation [Read More >>>]