Outline - MS Excel Quick Start

Microsoft Excel: Quick Start

Course Outline

This course teaches you the key features of Microsoft Excel and gives you the skills that most employers require.

In less than a day, you can have the skills you need to use Excel like a pro!

  • Section 1: Introduction
    • Lecture 1: Course Introduction
  • Section 2: The Excel Interface
    • Lecture 1: Interface Introduction
    • Lecture 2: The Title Bar
    • Lecture 3: The File Command and Backstage View
    • Lecture 4: The Command Ribbon
    • Lecture 5: Command Icons
    • Lecture 6: The Name Box and Formula Bar
    • Lecture 7: The Workbook and Worksheets
    • Lecture 8: The Status Bar
  • Section 3: Entering and Changing Data
    • Lecture 1: Entering Data
    • Lecture 2: Changing Data
    • Lecture 3: Moving Data
    • Lecture 4: Copying Data
    • Lecture 5: Clearing Data
    • Lecture 6: Deleting Data
    • Lecture 7: Using Paste Special
    • Lecture 8: The AutoFill Feature
  • Section 4: Formatting
    • Lecture 1: Fonts
    • Lecture 2: Borders
    • Lecture 3: The Format Painter
    • Lecture 4: Cell Alignment
    • Lecture 5: Number Formatting
    • Lecture 6: Wrapping Text
    • Lecture 7: Merging Cells
    • Lecture 8: Freezing Panes
  • Section 5: Creating Formulas
    • Lecture 1: Formulas Introduction
    • Lecture 2: Cell References
    • Lecture 3: Other Operators
    • Lecture 4: Moving Formulas
    • Lecture 5: Cell Reference Types
    • Lecture 6: Copying Formulas
    • Lecture 7: Copying Formulas - More Examples
      • Section 6: Working with Functions
        • Lecture 1: Functions Introduction
        • Lecture 2: The SUM Function
        • Lecture 3: Getting Function Help
        • Lecture 4: AutoSum Functions
        • Lecture 5: Counting Functions
        • Lecture 6: Common Text Functions
        • Lecture 7: Combining Functions
        • Lecture 8: Adding Functions to Product List
      • Section 7: Designing Tables
        • Lecture 1: Tables Introduction
        • Lecture 2: Creating a Table
        • Lecture 3: Table Styles
        • Lecture 4: Table Style Options
        • Lecture 5: Table Totals
        • Lecture 6: Formulas in Tables
        • Lecture 7: Adding Table Rows and Columns
        • Lecture 8: Deleting Rows and Columns
        • Lecture 9: Row and Column Addition Shortcuts
      • Section 8: Sorting Data
        • Lecture 1: Sorting Introduction
        • Lecture 2: Quick Sorts
        • Lecture 3: The Sort Command
        • Lecture 4: Multiple Column Sort
      • Section 9: Filtering Data
        • Lecture 1: Filtering Introduction
        • Lecture 2: Applying Filters
        • Lecture 3: Number Filtering Options
        • Lecture 4: Text Filtering Options
        • Lecture 5: Multiple Column Filters
        • Lecture 6: Reapplying Filters
      • Section 10: Using Multiple Worksheets
        • Lecture 1: Multiple Worksheets Introduction
        • Lecture 2: Adding Worksheets to a Workbook
        • Lecture 3: Grouping and Ungrouping Worksheets
        • Lecture 4: Adding Data to Multiple Worksheets
        • Lecture 5: Formatting Multiple Worksheets
        • Lecture 6: Adding Formulas to Multiple Worksheets
        • Lecture 7: Multiple Worksheet Formulas
      • Section 11: Printing
        • Lecture 1: Printing Introduction
        • Lecture 2: Print Preview
        • Lecture 3: Selecting What to Print
        • Lecture 4: Working with Print Areas
        • Lecture 5: Print Titles
        • Lecture 6: Predefined Headers and Footers
        • Lecture 7: Custom Headers and Footers
        • Lecture 8: Page Break Preview
      • Section 12: Pivot Tables
        • Lecture 1: Pivot Tables Introduction
        • Lecture 2: A Simple Pivot Table
        • Lecture 3: A More Useful Pivot Table
        • Lecture 4: Multiple Rows and Columns
        • Lecture 5: Functions in a Pivot Table
        • Lecture 6: Formatting Pivot Table Values
        • Lecture 7: Formatting Pivot Tables
        • Lecture 8: Pivot Table Filters
        • Lecture 9: Updating Pivot Tables
      • Section 13: Creating Charts
        • Lecture 1: Charts Introduction
        • Lecture 2: Creating a Chart
        • Lecture 3: How Charts Work
        • Lecture 4: Chart Elements
        • Lecture 5: Chart Elements Icon
        • Lecture 6: Formatting Chart Elements
        • Lecture 7: Chart Styles
        • Lecture 8: Chart Design Tab
        • Lecture 9: Chart Format Tab
        • Lecture 10: Chart Formatting Pane
        • Lecture 11: Updating Charts
        • Lecture 12: Select Data Icon
        • Lecture 13: Common Chart Types
        • Lecture 14: Pivot Charts
      • Section 14: Using Lookups
        • Lecture 1: Lookups Introduction
        • Lecture 2: VLOOKUP Explained
        • Lecture 3: VLOOKUP Example
        • Lecture 4: HLOOKUP Explained
        • Lecture 5: HLOOKUP Example
      • Section 15: Conclusion
      • Lecture 1: Course Conclusion