Microsoft Basic Excel: Course Outline

  • 1: Getting Started With Microsoft Office Excel 2016

    • Topic A: Navigate the Excel User Interface
    • Topic B: Use Excel Commands
    • Topic C: Create and Save a Basic Workbook
    • Topic D: Enter Cell Data
    • Topic E: Use Excel Help

    2: Performing Calculations

    • Topic A: Create Worksheet Formulas
    • Topic B: Insert Functions
    • Topic C: Reuse Formulas and Functions

    3: Modifying a Worksheet

    • Topic A: Insert, Delete, and Adjust Cells, Columns, and Rows
    • Topic B: Search for and Replace Data
    • Topic C: Use Proofing and Research Tools

    4: Formatting a Worksheet

    • Topic A: Apply Text Formats
    • Topic B: Apply Number Formats
    • Topic C: Align Cell Contents
    • Topic D: Apply Styles and Themes
    • Topic E: Apply Basic Conditional Formatting
    • Topic F: Create and Use Templates

    5: Printing Workbooks

    • Topic A: Preview and Print a Workbook
    • Topic B: Set Up the Page Layout
    • Topic C: Configure Headers and Footers

    6: Managing Workbooks

    • Topic A: Manage Worksheets
    • Topic B: Manage Workbook and Worksheet Views
    • Topic C: Manage Workbook Properties