Excel Is Fun

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

Excel Is Fun

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

Excel Is Fun

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

Excel Is Fun

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

Excel Is Fun

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

Excel Is Fun

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

Excel Is Fun

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

Excel Is Fun

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

Excel Is Fun

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

Excel Is Fun

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