Training Calendar

April 2022

Event
Date
Time
PowerPoint Transitions and Animations
04/07/2022
12:00 PM EST
EXCEL Advanced Pivot Tables
04/14/2022
12:00 PM EST
MS TEAMS: "Tasks by Planner and ToDo" app
04/21/2022
12:00 PM EST
OUTLOOK Tips and Tricks
04/28/2022
12:00 PM EST

May 2022

Event
Date
Time
Social Media Security
05/05/2022
12:00 PM EST
Presentation Best Practices
05/12/2022
12:00 PM EST
EXCEL Advanced Functions
05/19/2022
12:00 PM EST
Intro to Microsoft Forms (NEW!)
05/26/2022
12:00 PM EST

PowerPoint Transitions and Animations

April 7, 2022 12:00-1:00 pm EST)
This session is available for designDATA clients only

Join us as we delve into the world of transitions and animations in PowerPoint. You will learn how to apply transitions and animations, how to change effects and timings, which transitions and animations to avoid, and Motion Paths.

EXCEL Advanced Pivot Tables

April 14, 2022, 12:00-1:00 pm EST)
This session is available for designDATA clients only

PIVOT TABLE DATA and FORMATTING

  • Setting the Default Pivot Table layout
  • Connecting to an External Data Source

WORKING WITH PIVOT TABLE FIELDS

  • Using “Value Field Settings”
  • Using Pivot Table data in a formula
  • Working with Pivot Table dates

ANALYZING AND FILTERING DATA

  • Drilling down into Pivot Table data
  • Using Slicers
  • Adding filters to a Pivot Table
  • Using Conditional Formatting in Pivot Tables

MS TEAMS: "Tasks by Planner and ToDo" app

(April 21, 2022, 12:00-1:00 pm EST)
This session is available for designDATA clients only

This session will demonstrate the “Tasks by Planner and ToDo” app used in MS Teams to keep track of individual and team tasks.


Social Media Security

(May 5, 2022, 12:00-1:00 pm EST)
This session is available for designDATA clients only

Facebook is one of the dominant social media platforms in the market. With all the benefits it has introduced to the world, does that mean it’s safe? After completing this lesson, learners will be able to spot the flaws of a demo account and fortify security and privacy settings to protect it moving forward.

* Identify the threats present on Social Media
* Review 4 principles to use while on Social Media
* Apply settings to harden Facebook account(s)


Presentation Best Practices

(May 12, 2022, 12:00-1:00 pm EST)
This session is available for designDATA clients only
Learn tips and tricks to take your presentation skills to the next level!


EXCEL Advanced Functions

(May 19, 2022, 12:00-1:00 pm EST)
This session is available for designDATA clients only
Perform Actions Based on One or More Conditions
·       IF
·       IF + AND/OR
·       IFS
·       SWITCH

Locate Data in a Table and Return Results
·       MATCH
·       INDEX
·       XLOOKUP

Perform Mathematical Computations Based on Conditions
·       COUNTIF, SUMIF, AVERAGEIF

Talk With Our Productivity Expert

Microsoft Forms Blog Post

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