Microsoft Office essentials

MS Office Training: Excel, Word, PowerPoint

A practical workplace program focused on MS Office Training: Excel, Word, PowerPoint.

Join a Public ClassRequest Company Training

Build practical capability in MS Office Training: Excel, Word, PowerPoint.

A practical workplace program focused on MS Office Training: Excel, Word, PowerPoint.

Apply essential Excel text, logical, math, and lookup functions to everyday workplace data.
Prepare, validate, format, sort, and filter worksheets for accurate and efficient use.
Summarize and present information using PivotTables, PivotCharts, charts, and SmartArt.
Create more polished Word documents and PowerPoint presentations using practical formatting and media tools.

Course overview

A practical, instructor-led program with guided exercises and workplace examples. Open a topic to see the coverage.

Part 1. Basic MS Excel Functions
  • Text Functions
  • Combining Texts
Part 2. Worksheet Preparation Tools
  • Sorting and Filtering
  • Adding Borders
Part 3. PivotTables and PivotCharts
  • Basic PivotTable Features
  • Refresh and Change Data Source
Part 4. Essential MS Word Tools
  • Advanced Document Formats
  • Creating New Styles
Part 5. Basic PowerPoint Techniques
  • Adding and Modifying MS PowerPoint Objects
  • Modifying Texts
Part 6. Adding Diagrams and Charts in MS Office
  • Creating Diagrams using SmartArt
  • Creating Charts in Excel, PowerPoint, and Word

Full course outline

Review the complete legacy course outline, including all detailed subtopics.

View full outline
  • Part 1. Basic MS Excel Functions
    • Text Functions
      • Combining Texts
      • Changing Case
      • Other Accessory Text Functions
    • Logical Functions: Basic IF Statement
    • Math Functions
      • Basic Math Functions
      • Named Ranges
      • Conditional Math Functions
    • Lookup Functions
      • VLOOKUP
  • Part 2. Worksheet Preparation Tools
    • Sorting and Filtering
    • Adding Borders
    • Merge Cells and Cell Alignment
    • Insert, Delete, and Add Worksheets
    • Text-to-Columns
    • Basic Conditional Formatting
    • Basic Dropdown Menus and Cell Validations
  • Part 3. PivotTables and PivotCharts
    • Basic PivotTable Features
    • Refresh and Change Data Source
    • Using Slicers
    • Creating PivotCharts
  • Part 4. Essential MS Word Tools
    • Advanced Document Formats
    • Creating New Styles
    • Inserting Headers and Footers
    • Alternating Footers
    • First Page Footer
    • Table of Contents
  • Part 5. Basic PowerPoint Techniques
    • Adding and Modifying MS PowerPoint Objects
    • Modifying Texts
    • Formatting Texts: Font, Color, Size
    • Adding Textboxes
    • Automatic Text Reformatting
    • Troubleshooting Font Issues
    • Enhancing Images
    • Inserting Images
    • Cropping Images
    • Changing Image Colors
    • Using the Selection Pane
    • Inserting Audio and Video
    • Slide Formatting using the Slide Master View
    • Adding Animation
  • Part 6. Adding Diagrams and Charts in MS Office
    • Creating Diagrams using SmartArt
    • Creating Charts in Excel, PowerPoint, and Word

Choose how to join.

Individuals

Check current dates and rates.

View Public Classes

Company teams

Request an exclusive session.

Request Proposal