Excel 2016 Managing Worksheets

First page Table of contents Next page Last page

Copyright & Trademarks	6
Disclaimer	6
Lesson 1 - Working with Multiple Worksheets	9
Using Multiple Worksheets	10
 Discussion	10
Navigating between Worksheets	11
 Discussion	11
 Procedures	11
 Step-by-Step	11
Selecting Worksheets	12
 Discussion	12
 Procedures	13
 Step-by-Step	13
Renaming Worksheets	13
 Discussion	13
 Procedures	13
 Step-by-Step	13
Selecting Multiple Worksheets	14
 Discussion	14
 Procedures	14
 Step-by-Step	15
Coloring Worksheet Tabs	15
 Discussion	15
 Procedures	16
 Step-by-Step	16
Inserting Worksheets	17
 Discussion	17
 Procedures	17
 Step-by-Step	18
Deleting Worksheets	18
 Discussion	18
 Procedures	19
 Step-by-Step	19
Printing Selected Worksheets	19
 Discussion	19
 Procedures	20
 Step-by-Step	20
Exercise	22
Working with Multiple Worksheets	22
 Task	22
Lesson 2 - Managing Worksheets	23
Copying Worksheets	24
 Discussion	24
 Procedures	25
 Step-by-Step	25
Moving Worksheets	25
 Discussion	25
 Procedures	26
 Step-by-Step	26
Using Grouped Worksheets	26
 Discussion	26
 Procedures	27
 Step-by-Step	27
Moving Data between Worksheets	28
 Discussion	28
 Procedures	29
 Step-by-Step	29
Copying Data between Worksheets	30
 Discussion	30
 Procedures	30
 Step-by-Step	31
Creating 3-D Formulas	31
 Discussion	31
 Procedures	32
 Step-by-Step	32
Using 3-D Ranges in Functions	34
 Discussion	34
 Procedures	35
 Step-by-Step	35
Exercise	37
Managing Worksheets	37
 Task	37
Lesson 3 - Using Large Worksheets	39
Increasing the Magnification	40
 Discussion	40
 Procedures	41
 Step-by-Step	41
Decreasing the Magnification	41
 Discussion	41
 Procedures	42
 Step-by-Step	43
Changing the Magnification of a Range	43
 Discussion	43
 Procedures	44
 Step-by-Step	44
Switching to Full Screen View	45
 Discussion	45
 Procedures	45
 Step-by-Step	45
Splitting the Window	46
 Discussion	46
 Procedures	47
 Step-by-Step	47
Removing Split Windows	48
 Discussion	48
 Procedures	48
 Step-by-Step	49
Freezing the Panes	49
 Discussion	49
 Procedures	50
 Step-by-Step	50
Unfreezing the Panes	51
 Discussion	51
 Procedures	51
 Step-by-Step	51
Exercise	53
Using Large Worksheets	53
 Task	53

Made with FlippingBook Annual report