|
Mission
|
Status |
|
E3L2M01: Ranges - What are Labels and Named Ranges
|
Online
|
|
E3L2M02: Ranges - Using Labels in Formulas
|
Online
|
|
E3L2M03: Ranges - Using Text Labels
|
Online
|
|
E3L2M04: Ranges - Creating Labels
|
Online
|
|
E3L2M05: Ranges - Creating Named Ranges Using the Name Box
|
Online
|
|
E3L2M06: Ranges - Using Named Ranges to Select Cells
|
Online
|
|
E3L2M07: Ranges - Pasting Named Ranges in Formulae
|
Online
|
|
E3L2M08: Ranges - Creating Names between Workbooks
|
Online
|
|
E3L2M09: Ranges - Creating Names for Constants
|
Online
|
|
E3L2M10: Ranges - Creating A List of Names
|
Online
|
|
E3L2M11: Ranges - Changing a Named Range
|
Online
|
|
E3L2M12: Ranges - Deleting Ranges
|
Online
|
|
E3L2M13: Protecting Cells - Locking Cells
|
Online
|
|
E3L2M14: Protecting Cells - Unlocking Cells
|
Online
|
|
E3L2M15: Protecting Cells - Protecting a Worksheet
|
Online
|
|
E3L2M16: Protecting Cells - Using a Protected Worksheet
|
Online
|
E3L2M17: Protecting Cells - Disabling Worksheet Protection
|
Online |
| E3L2M18: Protecting Cells - Password Protecting a Worksheet |
Online |
|
E3L2M19: Functions - Date and Time
|
Online
|
|
E3L2M20: Functions - Logical
|
Online
|
|
E3L2M21: Functions - Lookup
|
Soon
|
|
E3L2M22: Functions - Statistical Extended
|
Soon
|
|
E3L2M23: Functions - Creating a Nested Function
|
Soon
|
|
E3L2M24: Functions - Editing a Formula with Nested Functions
|
Soon
|
|
E3L2M25: Functions - Copying a Formula with Nested Functions
|
Soon
|
|
E3L2M26: Functions - Concatenation
|
Soon
|
|
E3L2M27: Filtering - Using the Simple Filter
|
Soon
|
|
E3L2M28: Filtering - Advanced Filter
|
Soon
|
|
E3L2M29: Filtering - Using an Advanced Filter
|
Soon
|
|
E3L2M30: Filtering - Extracting Records
|
Soon
|
|
E3L2M31: Filtering - Using Formulas In Criteria
|
Soon
|
|
E3L2M32: Filtering - Using Database Functions
|
Soon
|
|
E3L2M33: Styles - What is a Style?
|
Soon
|
|
E3L2M34: Styles - Applying Existing Excel Styles
|
Soon
|
|
E3L2M35: Styles - Creating Styles by Example
|
Soon
|
|
E3L2M36: Styles - Creating Styles by Definition
|
Soon
|
|
E3L2M37: Styles - Applying Created Styles
|
Soon
|
|
E3L2M38: Styles - Merging Styles
|
Soon
|
|
E3L2M39: Styles - Adding the Style List to the Toolbar
|
Soon
|
|
E3L2M40: Styles - Modifying Styles
|
Soon
|
|
E3L2M41: Templates - Creating a Template
|
Soon
|
|
E3L2M42: Templates - Using a Template
|
Soon
|
|
E3L2M43: Templates - Modifying a Template
|
Soon
|
|
E3L2M44: Pivot Tables - What is a Pivot Table?
|
Soon
|
|
E3L2M45: Pivot Tables - Creating a Pivot Table
|
Soon
|
|
E3L2M46: Pivot Tables - Adding a Row Field to a Pivot Table
|
Soon
|
|
E3L2M47: Pivot Tables - Using the Page Field in a Pivot Table
|
Soon
|
|
E3L2M48: Pivot Tables - Filtering Row and Column Values
|
Soon
|
|
E3L2M49: Pivot Tables - Formatting a Pivot Table
|
Soon
|
|
E3L2M50: Pivot Tables - Counting with Pivot Tables
|
Soon
|
|
E3L2M51: Pivot Tables - PivotTable Summary and Display Options
|
Soon
|
|
E3L2M52: Pivot Tables - Format Data as Percentages In PivotTables
|
Soon
|
E3L2M53: Pivot Tables - Calculated Fields in Pivot Tables
|
Soon |
| E3L2M54: Pivot Tables - Calculated Items in Pivot Tables |
Soon |
| E3L2M55: Pivot Charts - Creating a Pivot Chart |
Soon |
|
E3L2M56: Pivot Charts - Modifying a Pivot Chart using the Pivot Table
|
Soon
|
|
E3L2M57: Sorting & Arranging Data - Sorting
|
Soon
|
|
E3L2M58: Sorting & Arranging Data - Performing a Secondary Sort
|
Soon
|
|
E3L2M59: Sorting & Arranging - Creating Subtotals
|
Soon
|
|
E3L2M60: Sorting & Arranging Data - Using the Summary Outline
|
Soon
|
|
E3L2M61: Sorting & Arranging Data - Removing Subtotals from a list
|
Soon
|
|
E3L2M62: Sorting & Arranging Data - Sorting by Column and Custom Lists
|
Soon
|
|
E3L2M63: Outlining - Creating an Automatic Outline
|
Soon
|
|
E3L2M64: Outlining - Working with an Outline
|
Soon
|
|
E3L2M65: Outlining - Removing an Automatic Outline
|
Soon
|
|
E3L2M66: Outlining - Creating a Manual Outline
|
Soon
|
|
E3L2M67: Outlining - Removing a Manual Outline
|
Soon
|