|
Mission
|
Status |
|
E7L2M01: Labels & Names
|
Online
|
|
E7L2M02: Creating Names
|
Online
|
|
E7L2M03: Names in Formulae
|
Online
|
|
E7L2M04: Applying Names
|
Online
|
|
E7L2M05: Using the Name box
|
Online
|
|
E7L2M06: Navigating with Names
|
Online
|
|
E7L2M07: Names in Formulae
|
Online
|
|
E7L2M08: Pasting Names
|
Online
|
|
E7L2M09: Names for Constant Values
|
Online
|
|
E7L2M10: Creating Ranges for Selections
|
Online
|
|
E7L2M11: Changing the Scope of a Named Range
|
Pending
|
|
E7L2M12: Using the Name Manager
|
Pending
|
|
E7L2M13: Changing a Named Range
|
Pending
|
|
E7L2M14: Deleting Names
|
Pending
|
|
E7L2M15: Creating a List of Names
|
Pending
|
|
E7L2M16: Protection - Locking Cells
|
Pending
|
E7L2M17: Protection - Unlocking Cells
|
Pending |
E7L2M18: Protection - Protecting a Worksheet
|
Pending |
|
E7L2M19: Protection - Using a Protected Worksheet
|
Pending
|
|
E7L2M20: Protection - Disabling Worksheet Protection
|
Pending
|
|
E7L2M21: Protection - Password Protecting a Worksheet
|
Soon
|
|
E7L2M22: Functions - Date & Time
|
Soon
|
|
E7L2M23: Functions - Logical
|
Soon
|
|
E7L2M24: Functions - Lookup
|
Soon
|
|
E7L2M25: Functions - Extended Statistical
|
Soon
|
|
E7L2M26: Functions - Nested Functions
|
Soon
|
|
E7L2M27: Functions - Editing Nested Functions
|
Soon
|
|
E7L2M28: Functions - Copying Nested Functions
|
Soon
|
|
E7L2M29: Functions - Concatenation
|
Soon
|
|
E7L2M30: Filter - Simple Filters
|
Soon
|
|
E7L2M31: Filter - Advanced Filters
|
Soon
|
|
E7L2M32: Filter - Extracting Records
|
Soon
|
|
E7L2M33: Filter - Formulae in Criteria
|
Soon
|
|
E7L2M34: Filter - Database Functions
|
Soon
|
|
E7L2M35: Styles - What is a Style?
|
Soon
|
|
E7L2M36: Styles - Applying Existing Styles
|
Soon
|
|
E7L2M37: Styles - Creating Styles by Example
|
Soon
|
|
E7L2M38: Styles - Creating Styles by Definition
|
Soon
|
|
E7L2M39: Styles - Applying Created Styles
|
Soon
|
|
E7L2M40: Styles - Merging Styles
|
Soon
|
|
E7L2M41: Styles - Adding Styles to QAT
|
Soon
|
|
E7L2M42: Styles - Modifying Styles
|
Soon
|
|
E7L2M43: Templates - Creating a Template
|
Soon
|
|
E7L2M44: Templates - Using Templates
|
Soon
|
|
E7L2M45: Templates - Modifying Templates
|
Soon
|
|
E7L2M46: Pivot Tables - What is a Pivot Table?
|
Soon
|
|
E7L2M47: Pivot Tables - Creating Pivot Tables
|
Soon
|
|
E7L2M48: Pivot Tables - Modifying Pivot Table
|
Soon
|
|
E7L2M49: Pivot Tables - Adding Row Fields
|
Soon
|
|
E7L2M50: Pivot Tables - Adding Page Fields
|
Soon
|
|
E7L2M51: Pivot Tables - Filtering Row and Column Values
|
Soon
|
|
E7L2M52: Pivot Tables - Formatting
|
Soon
|
E7L2M53: Pivot Tables - Counting
|
Soon |
E7L2M54: Pivot Tables - Summary & Display
|
Soon |
E7L2M55: Pivot Tables - Percentages
|
Soon |
|
E7L2M56: Pivot Tables - Calculation Fields
|
Soon
|
|
E7L2M57: Pivot Tables - Calculation Items
|
Soon
|
|
E7L2M58: Pivot Charts - Creating
|
Soon
|
|
E7L2M59: Pivot Charts - Modifying
|
Soon
|
|
E7L2M60: Sorting
|
Soon
|
|
E7L2M61: Sorting - Secondary Sorting
|
Soon
|
|
E7L2M62: Sorting - Creating Subtotals
|
Soon
|
|
E7L2M63: Sorting - Summary Outlines
|
Soon
|
|
E7L2M64: Sorting - Removing Subtotals
|
Soon
|
|
E7L2M65: Sorting - Sorting by Column & Custom Lists
|
Soon
|
|
E7L2M66: Outline - Automatic
|
Soon
|
|
E7L2M67: Outline - Using an Outline
|
Soon
|
|
E7L2M68: Outline - Removing an Outline
|
Soon
|
|
E7L2M69: Outline - Manual Outline
|
Soon
|
|
E7L2M70: Outline - Removing a Manual Outline
|
Soon
|