top of page

Microsoft basic (beginner) 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

Microsoft Intermediate Excel: course outline

1 Working With Functions

  • Topic A: Work with Ranges

  • Topic B: Use Specialized Functions

  • Topic C: Work with Logical Functions

  • Topic D: Work with Date and Time Functions

  • Topic E: Work with Text Functions

2 Working With Lists

  • Topic A: Sort Data

  • Topic B: Filter Data

  • Topic C: Query Data with Database Functions

  • Topic D: Outline and Subtotal Data

3 Analyzing Data

  • Topic A: Create and Modify Tables

  • Topic B: Apply Intermediate Conditional Formatting

  • Topic C: Apply Advanced Conditional Formatting

4 Visualizing Data With Charts

  • Topic A: Create Charts

  • Topic B: Modify and Format Charts

  • Topic C: Use Advanced Chart Features

5 Analyzing Data With PivotTables and PivotCharts

  • Topic A: Create a PivotTable

  • Topic B: Analyze PivotTable Data

  • Topic C: Present Data with PivotCharts

  • Topic D: Filter Data by Using Timelines and Slicers

Microsoft Advanced Excel: course outline

​

  • 1: Working With Multiple Worksheets and Workbooks

    • Topic A: Use Links and External References

    • Topic B: Use 3-D References

    • Topic C: Consolidate Data

    2: Using Lookup Formulas and Formula Auditing

    • Topic A: Use Lookup Functions

    • Topic B: Trace Cells

    • Topic C: Watch and Evaluate Formulas

    3: Sharing and Protecting Workbooks

    • Topic A: Collaborate on a Workbook

    • Topic B: Protect Worksheets and Workbooks

    4: Automating Workbook Functionality

    • Topic A: Apply Data Validation

    • Topic B: Search for Invalid Data and Formulas with Errors

    • Topic C: Work with Macros

    5: Creating Sparklines and Mapping Data

    • Topic A: Create Sparklines

    • Topic B: Map Data

    6: Forecasting Data

    • Topic A: Determine Potential Outcomes Using Data Tables

    • Topic B: Determine Potential Outcomes Using Scenarios

    • Topic C: Use the Goal Seek Feature

    • Topic D: Forecasting Data Trends

bottom of page