info +1 412-213-8665

On Demand Tech Skills Training

Microsoft Word

Learn how to maximize Microsoft Word’s potential, starting with the basics of document creation. Explore techniques for dynamic layouts, document preparation for printing and exporting, and effective formatting using Word Styles. Gain control over page formatting, table layouts, tab stops, and mail merges. Discover how to create and manage Word forms, templates, and track changes in documents.

Program includes:

  • You will learn how to take full advantage of Microsoft Word
  • Begin with the basics of creating Microsoft Word documents
  • Various techniques to create dynamic layouts
  • Preparing documents for printing and exporting
  • Format documents effectively using Microsoft Word Styles
  • Control page formatting and flow with sections and page breaks
  • Create and Manage Table Layouts
  • Work with Tab Stops to Align Content Properly
  • Perform Mail Merges to create Mailing Labels and Form Letters
  • Build and Deliver Word Forms
  • Manage Templates
  • Track and Accept/Reject Changes to a Document

Training length: 1-6 hours

Microsoft Excel

Master Microsoft Excel from the ground up. Begin with a solid understanding of Excel basics and common functions. Unlock the power of automation through Macros and VBA. Learn to manage large data sets, create dynamic reports with PivotTables, and utilize dynamic formulas like IF, VLOOKUP, INDEX, and MATCH.

Program includes:

  • Master Microsoft Excel from Beginner to Advanced
  • Build a solid understanding on the Basics of Microsoft Excel
  • Learn the most common Excel functions used in the Office
  • Harness the full power of Microsoft Excel by automating your day-to-day tasks through Macros and VBA
  • Maintain large sets of Excel data in a list or table
  • Create dynamic reports by mastering one of the most popular tools, PivotTables
  • Wow your boss by unlocking dynamic formulas with IF, VLOOKUP, INDEX, MATCH functions and many more

Session 1 covers:

  • Excel Overview & Interface
  • Functions & Basic Formulas
  • Excel Online
  • and more

Session 2-6 covers:

  • Lookup Functions
  • Error Tools
  • Information Graphics
  • Cell & Worksheet Protection

Session 3-6 covers:

  • Conditional Formatting
  • Macros Application
  • Pivot Tables
  • Excel Study Plan
  • Data Validation

Training length: 1-6 hours