IntroductionCourse Setup
Course Setup
Chapter 1: FundamentalsModule A: Getting aroundModule B: Workbook basics
Module A: Getting around
Module B: Workbook basics
Chapter 2: Creating worksheetsModule A: Entering dataModule B: FormulasModule C: FunctionsModule D: Moving and copying dataModule E: Reference types
Module A: Entering data
Module B: Formulas
Module C: Functions
Module D: Moving and copying data
Module E: Reference types
Chapter 3: FormattingModule A: Text formattingModule B: Number formattingModule C: AlignmentModule D: Borders and highlightingModule E: Styles and themes
Module A: Text formatting
Module B: Number formatting
Module C: Alignment
Module D: Borders and highlighting
Module E: Styles and themes
Chapter 4: Manipulating dataModule A: Data entry shortcutsModule B: Paste optionsModule C: Inserting, deleting, and hiding
Module A: Data entry shortcuts
Module B: Paste options
Module C: Inserting, deleting, and hiding
Chapter 5: ChartsModule A: Creating chartsModule B: Chart types and elements
Module A: Creating charts
Module B: Chart types and elements
Chapter 6: OutputModule A: Managing worksheet windowsModule B: Printing worksheetsModule C: Sharing workbooks
Module A: Managing worksheet windows
Module B: Printing worksheets
Module C: Sharing workbooks
Chapter 7: Settings and templatesModule A: Workbook options and propertiesModule B: Templates
Module A: Workbook options and properties
Module B: Templates
Chapter 8: Managing workbooksModule A: Managing worksheetsModule B: Customizing Excel
Module A: Managing worksheets
Module B: Customizing Excel
Chapter 9: Named rangesModule A: Using names in formulas
Module A: Using names in formulas
Chapter 10: TablesModule A: SortingModule B: Filtering tablesModule C: Structured referencesModule D: ValidationModule E: Transposing data
Module A: Sorting
Module B: Filtering tables
Module C: Structured references
Module D: Validation
Module E: Transposing data
Chapter 11: Summarizing dataModule A: ConsolidationModule B: Subtotals
Module A: Consolidation
Module B: Subtotals
Chapter 12: PivotTablesModule A: Creating and formatting PivotTablesModule B: Manipulating PivotTablesModule C: PivotCharts
Module A: Creating and formatting PivotTables
Module B: Manipulating PivotTables
Module C: PivotCharts
Chapter 13: Presentation featuresModule A: Conditional formatsModule B: Custom FormatsModule C: Graphics
Module A: Conditional formats
Module B: Custom Formats
Module C: Graphics
Chapter 14: Advanced chartsModule A: Special chart typesModule B: SparklinesModule C: Quick Analysis
Module A: Special chart types
Module B: Sparklines
Module C: Quick Analysis
Chapter 15: CollaborationModule A: PermissionsModule B: Shared workbooks
Module A: Permissions
Module B: Shared workbooks
Chapter 16: Logical and Lookup FunctionsModule A: Decision-making functionsModule B: Lookup and reference functions
Module A: Decision-making functions
Module B: Lookup and reference functions
Chapter 17: Advanced FormulasModule A: Auditing and error-trappingModule B: Formula optionsModule C: Arrays
Module A: Auditing and error-trapping
Module B: Formula options
Module C: Arrays
Chapter 18: Special functionsModule A: Date and time functionsModule B: Text functionsModule C: Other functions
Module A: Date and time functions
Module B: Text functions
Module C: Other functions
Chapter 19: Importing and ExportingModule A: The Power Pivot Data ModelModule B: Exporting data
Module A: The Power Pivot Data Model
Module B: Exporting data
Chapter 20: AnalysisModule A: What-if analysisModule B: The Analysis Toolpak
Module A: What-if analysis
Module B: The Analysis Toolpak
Chapter 21: Macros and FormsModule A: Recording macrosModule B: Running macrosModule C: Forms
Module A: Recording macros
Module B: Running macros
Module C: Forms