Training Calendar

November 2021

Event Date Date Time
Presentation Best Practices
11/04/2021
12:00 PM EST
TEAMS: Tips and Tricks
11/10/2021
12:00 PM EST
Advanced Pivot Tables
11/18/2021
12:00 PM EST

December 2021

Event Date Date Time
Introduction to OneNote
12/02/2021
12:00 PM EST
EXCEL: Tips and Tricks
12/09/2021
12:00 PM EST
POWERPOINT: Transitions and Animations
12/16/2021
12:00 PM EST

September 2021

Event Date Date Time
Comparing Video Conferencing Apps
09/02/2021
12:00 PM EST
EXCEL: Functions and Formulas (Advanced)
09/09/2021
12:00 PM EST
NEW! Outlook: Rules, Quick Steps, and Alerts
09/16/2021
12:00 PM EST
MS Teams Basics
09/23/2021
12:00 PM EST
MS Teams: What's New and What's On the Horizon?
09/30/2021
12:00 PM EST

Presentation Best Practices

(November 4, 12:00-1:00 pm EST)
This session is available for designDATA clients only

Learn how to become a much more effective presenter by incorporating the tips and tricks from this module.

Advanced Pivot Tables

(November 18, 12:00-1:00 pm EST)
This session is available for designDATA clients only

Learn some advanced Pivot Table techniques, such as connecting to an external database, using Value Field Settings and adding filters to Pivot Tables.

Introduction to OneNote

(December 2, 12:00-1:00 pm EST)
This session is available for designDATA clients only

AGENDA

Quick Overview of the Hierarchy System

  • Create a Notebook
  • Explore the Workspace
  • Review Additional Features
  • Delve into Personal Meeting Notes
  • Experience the Mobile App

EXCEL: Tips and Tricks

(December 9, 12:00-1:00 pm EST)
This session is available for designDATA clients only

AGENDA

ENTERING AND MANIPULATING DATA

  • Using an Absolute Reference
  • The magic of CTL+ENTER
  • Fill and Flash Fill
  • Entering data into non-adjacent cells
  • Splitting and joining text

MANIPULATING COLUMNS, ROWS, and CELLS

  • Manipulating column widths
  • Using shortcut keys to select rows, columns, tables
  • Selecting only visible (non-hidden) data
  • Removing leading, ending and middle blanks

Comparing Video Conferencing Apps

September 02, (12:00-1:00 pm EST)
This session is available for designDATA clients only

Learn the pros and cons of using three of the top video conferencing apps on the market: MS Teams, Zoom, and GoToMeeting.

EXCEL: Functions and Formulas
(Advanced)

(September 09, 12:00-1:00 pm EST)
This session is available for designDATA clients only

This Excel session will demonstrate how to use functions and formulas such as:

  • AND/OR
  • IFS
  • SWITCH
  • MATCH
  • INDEX
  • XLOOKUP
  • SUMIF
  • AVERAGEIF
  • COUNTIF
  • MAXIFS

NEW!
Outlook: Rules, Quick Steps, and Alerts

(September 16, 12:00-1:00 pm EST)
This session is available for designDATA clients only

This webinar will highlight the Rules, Quick Steps, and Alerts features in MS Outlook.

MS Teams Basics

(September 23, 12:00-1:00 pm EST)
This session is available for designDATA clients only

New to Teams? Learn about the basic features of this powerful product, such as Chat and Meetings.

Talk With Our Productivity Expert

Microsoft Forms Blog Post

  • This field is for validation purposes and should be left unchanged.