Excel Is Fun

Highline Excel 2013 Class Video 28

March 24, 2017 0

Excel Data Validation: List, Date, Time, Custom (22 Examples) DESCRIPTION Topics in this video: 1. Data Validation to allow only whole numbers between an upper and lower limit. 2. Create an Input Message for your […]

Excel Is Fun

Highline Excel 2013 Class Video 27

March 17, 2017 0

DESCRIPTION Topics in this video: 1. List of possible errors in Excel. 2. 4 Steps to finding formula errors. 3. 3 Examples of how to use the 4 steps. 4. Cleaning Text data with the […]

Excel Is Fun

Highline Excel 2013 Class Video 26

March 10, 2017 0

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

Excel Is Fun

Highline Excel 2013 Class Video 25

March 3, 2017 0

DESCRIPTION Topics in this video: 1. Goal Seek: Get Formula To Evaluate To Desired Result 2. Goal Seek: Keyboard: Alt T, G 3. Set Cell: Contains a formula with a formula input you want to […]

Excel Is Fun

Highline Excel 2013 Class Video 24

February 24, 2017 0

Getting Top 5 Values With LARGE And Bottom 5 With SMALL DESCRIPTION Topics in this video: 1. Getting Top five values with LARGE and ROWS 2. Getting Bottom five values with SMALL and ROWS WORKBOOKS

Excel Is Fun

Highline Excel 2013 Class Video 23

February 17, 2017 0

VLOOKUP and IFNA for Commissions DESCRIPTION Topics in this video: VLOOKUP and IFNA for Commissions: VLOOKUP to look up an actual sales rep that has a contractual rate and then the IFNA to assign the […]

Excel Is Fun

Highline Excel 2013 Class Video 21

February 20, 2015 0

DESCRIPTION Topics in this video: (00:10) INDEX and MATCH. (00:32) Lookup Left, 1-way vertical range lookup. (04:41) Lookup Low Bid, 1-way horizontal range lookup. (08:27) 2-way lookup to lookup discount rate. (13:14) Lookup Whole Row […]

Excel Is Fun

Highline Excel 2013 Class Video 20

February 19, 2015 0

DESCRIPTION Topics in this video: (00:15) VLOOKUP to retrieve whole record change columns manually. (02:20) VLOOKUP to retrieve whole record column number in cell. (03:43) VLOOKUP & MATCH to retrieve whole record — more dynamic […]

Excel Is Fun

Highline Excel 2013 Class Video 19

February 18, 2015 0

DESCRIPTION Topics in this video: (00:11) Text Functions. (00:23) Partial Text Lookup: RIGHT & VLOOKUP. (02:17) Partial Text Lookup: LEFT and SEARCH & VLOOKUP. (05:56) Partial Text Lookup: MID & VLOOKUP. (07:51) Converting Numbers Stored […]