Excel 2016 Data and List Management

First page Table of contents Next page Last page

Copyright & Trademarks	6
Disclaimer	6
Lesson 1 - Using Advanced Functions	9
Using Lookup Functions	10
 Discussion	10
Using the VLOOKUP Function	10
 Discussion	10
 Procedures	12
 Step-by-Step	12
Using the HLOOKUP Function	14
 Discussion	14
 Procedures	15
 Step-by-Step	16
Using the IF Function	17
 Discussion	17
 Procedures	19
 Step-by-Step	19
Using Nested IF Functions	21
 Discussion	21
 Procedures	22
 Step-by-Step	22
Using the ISERROR Function	24
 Discussion	24
 Procedures	25
 Step-by-Step	25
Using an AND Condition with IF	27
 Discussion	27
 Procedures	27
 Step-by-Step	28
Using an OR Condition with IF	29
 Discussion	29
 Procedures	30
 Step-by-Step	30
Using the ROUND Function	32
 Discussion	32
 Procedures	33
 Step-by-Step	33
Limiting the Precision of Numbers	34
 Discussion	34
 Procedures	35
 Step-by-Step	35
Exercise	37
Using Advanced Functions	37
 Task	37
Lesson 2 - Creating/Revising PivotTables	39
Recommended PivotTables	40
 Discussion	40
 Procedures	40
 Step-by-Step	41
Creating a PivotTable Report	41
 Discussion	41
 Procedures	42
 Step-by-Step	42
Adding PivotTable Report Fields	43
 Discussion	43
 Procedures	44
 Step-by-Step	45
Search for PivotTable Report Field	46
 Discussion	46
 Procedures	47
 Step-by-Step	47
Selecting a Report Filter Field Item	47
 Discussion	47
 Procedures	48
 Step-by-Step	48
Refreshing a PivotTable Report	49
 Discussion	49
 Procedures	49
 Step-by-Step	49
Changing the Summary Function	50
 Discussion	50
 Procedures	51
 Step-by-Step	51
Adding New Fields to a PivotTable Report	52
 Discussion	52
 Procedures	52
 Step-by-Step	52
Moving PivotTable Report Fields	53
 Discussion	53
 Procedures	54
 Step-by-Step	54
Using Expand and Collapse Buttons	55
 Discussion	55
 Procedures	56
 Step-by-Step	56
Hiding/Unhiding PivotTable Report Items	57
 Discussion	57
 Procedures	57
 Step-by-Step	57
Deleting PivotTable Report Fields	58
 Discussion	58
 Procedures	58
 Step-by-Step	59
Creating Report Filter Pages	59
 Discussion	59
 Procedures	60
 Step-by-Step	60
Formatting a PivotTable Report	61
 Discussion	61
 Procedures	62
 Step-by-Step	62
Creating Slicers	63
 Discussion	63
 Procedures	64
 Step-by-Step	64
Filtering with Slicers	65
 Discussion	65
 Procedures	66
 Step-by-Step	66
Editing a Slicer	67
 Discussion	67
 Procedures	67
 Step-by-Step	68
Using Multi-Select Slicers	69
 Discussion	69
 Procedures	69
 Step-by-Step	69
Creating a PivotChart Report	70
 Discussion	70
 Procedures	71
 Step-by-Step	71
Exercise	73
Creating/Revising PivotTables	73
 Task	73
Lesson 3 - Working with Outlines	75
Applying an Outline	76
 Discussion	76
 Procedures	77
 Step-by-Step	77
Collapsing/Expanding an Outline	78
 Discussion	78
 Procedures	79
 Step-by-Step	79
Modifying Outline Settings	80
 Discussion	80
 Procedures	81
 Step-by-Step	81
Using Auto Outline	82
 Discussion	82
 Procedures	83
 Step-by-Step	83
Clearing an Outline	84
 Discussion	84
 Procedures	85
 Step-by-Step	85
Creating Subtotals in a List	86
 Discussion	86
 Procedures	87
 Step-by-Step	87
Removing Subtotals from a List	90
 Discussion	90
 Procedures	90
 Step-by-Step	90
Exercise	91
Working with Outlines	91
 Task	91

Made with FlippingBook - professional solution for displaying marketing and sales documents online