### Office 2016 32

DESCRIPTION Topics in this video: (00:01) Introduction (01:51) Review of PivotTables we have already completed in this class. (03:15) What is Data Analysis in one sentence (03:34) What’s is Proper Data Set in Excel? (03:50) [Read More >>>]

### Office 2016 31

DESCRIPTION Topics in this video: (00:01) Introduction (01:30) Review of SUMIFS and COUNTIFS examples we hjave already done in this class. (03:38) What is an AND Logical Test (06:40) Example 1. Goal: Count How Many [Read More >>>]

### Office 2016 30

DESCRIPTION In this video learn about how to Create Defined Names, and use them in formulas and to Jump to areas in the Excel Workbook. NOTES WORKBOOKS

### Office 2016 29

DESCRIPTION Topics in this video: (00:01) Introduction (00:32) Example 1: Accounting Style Formatting (4 Examples) (08:47) Example 2: Accounting Borders (09:25) Example 3: Column widths!! (10:16) Example 4: Wrap Text in Cell: Multiple Lines in [Read More >>>]

### Office 2016 28

DESCRIPTION Topics in this video: (00:01) Introduction (01:24) Example 1: Mixed Cell References in Multiplication Table (04:24) Song and Excel Example in High Speed (05:20) How Cell References Move Throughout Copy Action (07:06) Two Questions [Read More >>>]

### Office 2016 27

DESCRIPTION Topics in this video: (00:01) Introduction (01:15) Example 1: Excel Table feature for VLOOKUP & Data Validation List (07:10) Example 2: Excel Table feature for Chart (09:45) Example 3: Excel Table feature for PivotTable [Read More >>>]

### Office 2016 26

DESCRIPTION Topics in this video: (00:01) Introduction (01:10) Should we use IF or VLOOKUP? (02:12) What does VLOOKUP do? (03:22) Examples of Lookup Tables (06:14) What does “V” in VLOOKUP mean? (06:41) Formula 1: Exact [Read More >>>]

### Office 2016 25

DESCRIPTION Topics in this video: (00:01) Detailed Introduction to the IF Function & Comparative Operators and Logical Tests (08:53) IF Example #01: Your Bonus: =IF(C6 Greater Than =C11,C10,0) (13:39) IF Example #02: In Balance?: =IF(B22=C22,”In [Read More >>>]

### Office 2016 24

DESCRIPTION Topics in this video: (00:01) Introduction (00:30) Different Types of Formulas (02:07) Formula Elements – what you can out into a formula. (04:55) Formula 01: Goal: Add calls made a service centre last week.: [Read More >>>]

### Office 2016 23

DESCRIPTION Topics in this video: (00:01) Introduction (01:19) Search for Excel Functions with Function Library (03:05) Insert Function Dialog Box, Search for Excel Functions with Insert Function button or with Keyboard: Shift F3 (03:46) PMT [Read More >>>]