Module A1: Consolidating Data with Excel
- Creating Links
- Linking Sheets Within the Workbook
- Linking to Other Workbooks
- Amending Broken Links
- Using Data Consolidate
- Consolidate By Position
- Consolidate By Category
- Consolidate Data Using Formulas
Module A2: Auditing a Worksheet
- Tracing Formulas and Errors
- Trace cells that provide data to a formula (precedents)
- Trace formulas that reference a particular cell (dependents)
- Error Checking
- Correct common formula errors one at a time
- Correct an error value
- Watch Window
- Add cells to the Watch Window
- Remove cells from the Watch Window
- Protecting Your Files and Worksheets
- Locking & Unlocking Cells
- Setting Multiple Range Passwords
- Protecting The Contents of a Worksheet
- Protecting The Structure of a Workbook
- Encrypting Your Workbook
Module A3: Managing Excel Data
- Introducing Excel Tables
- Inserting a Table
- Benefits of A Table
- Removing A Table
- Sorting Data
- Performing A Quick Sort
- Performing A Complex Sort
- Using A Custom List
- Sorting Based On Colors
- Entering Data Using Forms
- Customizing the Quick Access Toolbar
- Entering New Data
- Editing Data
- Performing A Criteria Base Search
- Filtering Data
- Using Filters
- Using Custom AutoFilter
- Advanced Filtering
- Using Multiple OR To Filter
- Using Multiple AND To Filter
- Using AND & OR To Filter
- Using Wildcards To Filter
- Subtotals
- Adding Subtotals
- Adjusting Views with Subtotals
- Removing Subtotals
- Performing Nested Subtotals
- Validating Data Entry
- Creating A Drop Down List
- Creating A Customized Error Message
- Controlling Values & Dates
- Using Formulas to Control Data
- Importing Text Files
- When to Use Delimited
- When to Use Fixed Width
- Using Text To Column to manipulate data