|
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 - IF
|
Online
|
|
E3L2M21: Functions - Nested IF
|
Online
|
|
E3L2M22: Functions - Joining Text
|
Online
|
|
E3L2M23: Functions - CONCATENATE
|
Online
|
|
E3L2M24: Functions - CHOOSE
|
Online
|
|
E3L2M25: Functions - ISERROR
|
Online
|
|
E3L2M26: Functions - VLOOKUP
|
Online
|
|
E3L2M27: Functions - VLOOKUP Exact Matches
|
Online
|
|
E3L2M28: Functions - HLOOKUP
|
Online
|
|
E3L2M29: Functions - INDEX
|
Online
|
|
E3L2M30: Functions - MATCH
|
Online
|
|
E3L2M31: Pivot Tables
|
Pending
|
|
E3L2M32: Pivot Tables - Creating
|
Pending
|
|
E3L2M33: Pivot Tables - Row Fields
|
Pending
|
|
E3L2M34: Pivot Tables - Page Fields
|
Pending
|
|
E3L2M35: Pivot Tables - Filter Data
|
Pending
|
|
E3L2M36: Pivot Tables - Formatting
|
Pending
|
|
E3L2M37: Pivot Tables - Using Count Function
|
Pending
|
|
E3L2M38: Pivot Tables - Display Options
|
Pending
|
|
E3L2M39: Pivot Tables - Percentages
|
Pending
|
|
E3L2M40: Pivot Tables - Calculations
|
Pending
|
|
E3L2M41: Pivot Charts
|
Pending
|
|
E3L2M42: Pivot Charts - Creating
|
Pending
|
|
E3L2M43: Pivot Charts - Fields
|
Pending
|
|
E3L2M44: Pivot Charts - Types
|
Pending
|
|
E3L2M45: Pivot Charts - Formatting
|
Pending
|
|
E3L2M46: Filter - Simple
|
Soon
|
|
E3L2M47: Filter - Advanced
|
Soon
|
|
E3L2M48: Filter - Extracting Records
|
Soon
|
|
E3L2M49: Filter - Using Formulas
|
Soon
|
|
E3L2M50: Filter - Using Database Functions
|
Soon
|
|
E3L2M51: Sorting
|
Soon
|
|
E3L2M52: Sorting - Using Secondary Sorts
|
Soon
|
E3L2M53: Subtotals
|
Soon |
E3L2M54: Subtotals - Using a Summary Outline
|
Soon |
E3L2M55: Subtotals - Removing
|
Soon |
|
E3L2M56: Outlining - Automatic
|
Soon
|
|
E3L2M57: Outlining - Working with Outlines
|
Soon
|
|
E3L2M58: Outlining - Remove Automatic Outlines
|
Soon
|
|
E3L2M59: Outlining - Manual Outlines
|
Soon
|
|
E3L2M60: Outlining - Remove Manual Outlines
|
Soon
|
|
E3L2M61: Styles - Applying Default Excel 2003 Styles
|
Soon
|
|
E3L2M62: Styles - By Example
|
Soon
|
|
E3L2M63: Styles - By Definition
|
Soon
|
|
E3L2M64: Styles - Applying Custom Styles
|
Soon
|
|
E3L2M65: Styles - Merging Styles from Other Workbooks
|
Soon
|
|
E3L2M66: Styles - Add to Toolbar
|
Soon
|
|
E3L2M67: Styles - Modifying Styles
|
Soon
|
| E3L2M68: Templates - Creating |
Soon |
| E3L2M69: Templates - Using |
Soon |
| E3L2M70: Templates - Modifying |
Soon |