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 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 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

Excel Magic Trick 1285

April 6, 2017 0

OR Criteria & AND Criteria for Max & Min Calculations (5 Examples) DESCRIPTION Learn how to calculate the MIN and MAX values when there is complex criteria that mixes OR Logical Tests and AND Logical […]

Excel Is Fun

Excel Magic Trick 1284

April 3, 2017 0

History of Excel Max or Min with Conditions / Criteria (5 Examples) DESCRIPTION Learn about 5 methods to make a Max or Min AND Criteria (AND Logical Test) Calculation with multiple Conditions / Criteria that […]

Excel Is Fun

Excel Magic Trick 1282

March 27, 2017 0

Lookup And Return Multiple Items to a Single Cell: TEXTJOIN Function DESCRIPTION See how to use the amazing new Excel 2016 function TEXTJOIN to Find Multiple Lookup Values In First Colum AND return Multiple Items […]

WORKBOOKS & WORKSHEETS

Worksheet Basics

March 2, 2017 0

INTRODUCTION There are two types of worksheets. The standard worksheets that contains cells. Chart sheets which contain only graphs. ROWS AND COLUMNS Every standard worksheet layout consists of Rows and Columns. Rows numbered from 1 […]

Dueling Excel

Dueling Excel 125

January 18, 2017 0

DESCRIPTION Conditional Formatting Date Four Days Old & Not Paid See Mr Excel and excelisfun use two methods to Conditional Formatting Date That is Four Or More Days Old & Not Paid 1. Conditional Formatting […]