Excel Is Fun

Highline Excel 2013 Class Video 41

June 23, 2017 0

DESCRIPTION Topics in this video: 1. What do Charts do? Visually portray Quantitative data (number data). Give a quick impression of the number data. Create a picture that can communicate more quickly than just the […]

Excel Is Fun

Highline Excel 2013 Class Video 40

June 16, 2017 0

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

Excel Is Fun

Highline Excel 2013 Class Video 39

June 9, 2017 0

DESCRIPTION Topics in this video: 1. Import Commas Delimited Data From Word Document with Copy and Paste then do Text To Columns. 2. Import CSV File and Txt File. 3. Import Proper Data Set into […]

Excel Is Fun

Highline Excel 2013 Class Video 38

June 2, 2017 0

DESCRIPTION Topics in this video: 1. Split Text with Delimiter = Space. Split First and Last Name and Skip a column. Text To Columns keyboard: Alt, A, E or Alt, D, E. 2. Split Text […]

Excel Is Fun

Highline Excel 2013 Class Video 37

May 26, 2017 0

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

Excel Is Fun

Highline Excel 2013 Class Video 36

May 19, 2017 0

DESCRIPTION Topics in this video: 1. Sort to Extract Records. 2. Filter for extracting records. 3. Filter Toggle Keyboard: Ctrl + Shift + L or Alt, D, F, F. 4. Single Criteria Data Extract. 5. […]

Excel Is Fun

Highline Excel 2013 Class Video 35

May 12, 2017 0

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

Excel Is Fun

Highline Excel 2013 Class Video 34

May 5, 2017 0

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

Excel Is Fun

Highline Excel 2013 Class Video 33

April 28, 2017 0

DESCRIPTION Topics in this video: 1. Most sorting is done on a Proper Data Set. 2. Click in single cell and use Sort Button. 3. Whole data set is sorted, not just selected column. 4. […]

Excel Is Fun

Highline Excel 2013 Class Video 32

April 21, 2017 0

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