_Banner.webp)
Chapter 8
Adjusting Worksheet Views
Freezing and Unfreezing Panes
Chapter 8
Adjusting Worksheet Views
Splitting screens Horizontally &ammp; Vertically
Chapter 8
Adjusting Worksheet Views
Collapsing & Expanding Data Views
Chapter 9
Multiple Worksheets & Workbooks
Displaying Multiple Worksheets & Workbooks
Chapter 9
Multiple Worksheets & Workbooks
Renaming, Inserting & Deleting Sheets
Chapter 9
Multiple Worksheets & Workbooks
Moving, Copying & Grouping Sheets
Chapter 9
Multiple Worksheets & Workbooks
Formulas to Link Worksheets & Workbooks
Chapter 9
Multiple Worksheets & Workbooks
Locating and Maintaining Links
Chapter 10
IF, VLOOKUP & Power Functions
IF Functions & Relational Operators
Chapter 10
IF, VLOOKUP & Power Functions
Get Approximate Data with VLOOKUP
Chapter 10
IF, VLOOKUP & Power Functions
Get Exact Data with VLOOKUP
Chapter 10
IF, VLOOKUP & Power Functions
Using COUNTIF Family of Functions
Chapter 11
Security and Sharing
Unlocking Cells & Protecting Worksheets
Chapter 11
Security and Sharing
Protecting workbooks
Chapter 11
Security and Sharing
Assigning Passwords to Workbooks
Chapter 11
Security and Sharing
Sharing Workbooks
Chapter 11
Security and Sharing
Tracking Changes
Chapter 12
Data Management Features
Sorting Data
Chapter 12
Data Management Features
Insert Subtotals in a Sorted List
Chapter 12
Data Management Features
Using Filters
Chapter 12
Data Management Features
Split Data Into Multiple Columns
Chapter 12
Data Management Features
Split & Combine Data with Flash Fill
Chapter 12
Data Management Features
Removing Duplicate Records
Chapter 12
Data Management Features
Using Validation Tools
