1
Highline Excel 2013 Class Video 01: Back To Basics: Number Format, Keyboards, PivotTables, Formulas
1:42:38
2013-09-23
2
Highline Excel 2013 Class Video 02: Comprehensive Excel Formula Types & Elements Video 12 Examples
33:55
2013-10-02
3
Highline Excel 2013 Class Video 03: How Formulas Calculate: Order of Precedence in Excel
15:23
2013-10-02
4
Highline Excel 2013 Class Video 04: Percentage Increase or Decrease Formula
4:51
2013-10-02
5
Highline Excel 2013 Class Video 05: Cell References: Relative, Absolute & Mixed (8 Examples)
37:12
2013-10-03
6
Highline Excel 2013 Class Video 06: Scenarios To Save Sets Of Formula Inputs, Paste Special Trick
6:01
2013-10-04
7
Highline Excel 2013 Class Video 07: Worksheet & Workbook References, 3-D Cell References
11:21
2013-10-04
8
Highline Excel 2013 Class Video 08: Excel Table Formula Nomenclature / Structured References 22 Ex.
25:47
2013-10-04
9
Highline Excel 2013 Class Video 09: Defined Names & Aggregate Functions
13:15
2013-10-17
10
Highline Excel 2013 Class Video 10: AND & BETWEEN Criteria: SUMIFS, DSUM, COUNTIFS, AVERAGEIFS
39:18
2013-10-17
11
Highline Excel 2013 Class Video 11: Calculations With OR Criteria: COUNTIFS, DCOUNTA, SUMIFS, DSUM
22:57
2013-10-12
12
Highline Excel 2013 Class Video 12: AND & OR Criteria Calculations: D Functions like DSUM, DCOUNT
9:00
2013-10-12
13
Highline Excel 2013 Class Video 13: AND & OR Criteria Calculations: Table Feature
5:34
2013-10-12
14
Highline Excel 2013 Class Video 14: AND, OR, IF Functions For AR Dept (Multiple Logical Tests)
13:37
2013-10-12
15
Highline Excel 2013 Class Video 15: IF & IS Functions To Deliver Numbers, Text, Formulas, Nested IFs
26:17
2013-10-12
16
Highline Excel 2013 Class Video 16: Round Functions: ROUND, MROUND, ROUNDUP, CEILING, more...
8:34
2013-10-12
17
Highline Excel 2013 Class Video 17: Introduction To SUMPRODUCT Function
10:02
2013-10-12
18
Highline Excel 2013 Class Video 18: VLOOKUP Function 20 Examples, VLOOKUP Formula, Excel VLOOKUP
42:00
2013-10-19
19
Highline Excel 2013 Class Video 19: Text Functions RIGHT, LEFT, MID, SEARCH for Partial Text VLOOKUP
11:13
2013-10-19
20
Highline Excel 2013 Class Video 20: VLOOKUP, DGET & MATCH For Looking Up Records 7 Examples
20:56
2013-10-19
21
Highline Excel 2013 Class Video 21: INDEX and MATCH Functions For Unusual Lookups 4 Examples
19:33
2013-10-19
22
Highline Excel 2013 Class Video 22: CHOOSE function to lookup table for VLOOKUP With Multiple Tables
6:46
2013-10-19
23
Highline Excel 2013 Class Video 23: VLOOKUP and IFNA for Commissions
2:24
2013-10-19
24
Highline Excel 2013 Class Video 24: Getting Top 5 Values With LARGE And Bottom 5 With SMALL
5:26
2013-10-19
25
Highline Excel 2013 Class Video 25: Goal Seek: Get Formula To Evaluate To Desired Result
3:38
2013-10-19
26
Highline Excel 2013 Class Video 26: Excel Compare Two Lists Formula: Item In List? Item Not In List?
6:15
2013-10-25
27
Highline Excel 2013 Class Video 27: How To Track Down Excel Formula Errors (16 Examples)
21:36
2013-11-08
28
Highline Excel 2013 Class Video 28: Excel Data Validation: List, Date, Time, Custom (22 Examples)
24:25
2013-11-08
29
Highline Excel 2013 Class Video 29: Flash Fill: Extract, Combine, Insert, Reverse Data (25 Example)
12:22
2013-11-08
30
Highline Excel 2013 Class Video 30: Custom Number Formatting & Text Functions, (33 Examples)
30:48
2013-11-08
31
Highline Excel 2013 Class Video 31: Date Functions: EDATE, EOMONTH, DATE, YEAR, MONTH, DAY, More
11:37
2013-11-08
32
Highline Excel 2013 Class Video 32: Introduction To Array Formulas and Array Functions
34:06
2013-11-09
33
Highline Excel 2013 Class Video 33: Sorting In Excel. Excel Sort (13 Examples)
18:11
2013-11-15
34
Highline Excel 2013 Class Video 34: Excel Subtotals, Add Subtotals based on One or Two Columns
12:48
2013-11-15
35
Highline Excel 2013 Class Video #35: Excel 2013 PivotTables: Basic To Advanced 58 Examples
1:21:50
2013-11-16
36
Highline Excel 2013 Class Video 36: Excel Filter For Extracting Records with AND or OR Criteria
15:06
2013-11-23
37
Highline Excel 2013 Class Video 37: Excel Advanced Filter Extract Data 26 Examples Basic - Advanced
30:26
2013-11-23
38
Highline Excel 2013 Class Video 38: Excel Text To Columns To Split or Convert Data 7 Examples
10:14
2013-11-23
39
Highline Excel 2013 Class Video 39: Excel Import Data: Text File, CSV File, Access, Excel File
10:04
2013-11-23
40
Highline Excel 2013 Class Video 40: Conditional Formatting Basic To Advanced 50 Examples
1:28:15
2013-11-28
41
Highline Excel 2013 Class Video 41: Review Of Chart Basics For Excel 2013
43:39
2013-12-22
42
Highline Excel 2013 Class Video 42: Save Chart As Template in Excel 2013
3:48
2013-12-22
43
Highline Excel 2013 Class Video 43: Set Default Chart in Excel 2013, Keyboard Shortcuts Charts
2:03
2013-12-22
44
Highline Excel 2013 Class Video 44: Pie within Pie Chart in Excel 2013
2:45
2013-12-22
45
Highline Excel 2013 Class Video 45: Combining Chart Types and Secondary Axis in Excel 2013
3:59
2013-12-22
46
Highline Excel 2013 Class Video 46: Statistics: Histogram Formulas & Chart in Excel 2013
12:35
2013-12-22
47
Highline Excel 2013 Class Video 47: Statistics: Dot Plot (Cell Chart)
2:38
2013-12-22
48
Highline Excel 2013 Class Video 48: Conditional Formatting: Bar Chart with Data Labels
2:24
2013-12-22
49
Highline Excel 2013 Class Video 49: Break Even Analysis Formulas & Chart, Plotting Break Even Point
13:26
2013-12-22
50
Highline Excel 2013 Class Video 51: Recorded Macro Basics, including Absolute & Relative References
33:16
2013-12-24