Microsoft Tips 'n' Tricks Series


In today’s world, all employees need better technical skills! Ensure your employees can navigate common Microsoft platforms with skill and ease. Research suggests employees are more likely to stay with employers who train them. They benefit, and you benefit from them being more productive and efficient! 

 Our Microsoft Tips 'n' Tricks Series is delivered virtually by a live, real-time instructor delivering hands-on instruction. Unlike recorded webinars, participants will be actively engaged in their learning. They'll be able to see the Microsoft platforms in action, ask questions, and interact with our instructor.

 The series begins October 13, however, each course can be purchased individually.

Bring this series to your organization for your group of 10 or more. Contact ERC to learn more.

Microsoft Excel Tips 'n' Tricks: October 13, 2021 - 8:30am to 10am ET

Setting up a Workbook

  • Getting familiar with the Excel interface
  • Customizing the Excel interface
  • Workbook display options
  • Entering and modifying data in the worksheet

Working in a Workbook

  • Understanding entries types
  • Selecting cells and ranges
  • Formatting data in a worksheet

Creating Formulas and Working with Functions

  • Creating simple formulas with standard mathematical operators
  • Using functions – SUM, AVERAGE, MAX, MIN

Page Layout, Printing and Sharing Options

  • Using page views
  • Setting up printing specifications
  • Saving and sending options

Microsoft PowerPoint Tips 'n' Tricks: October 20, 2021 - 8:30am to 10am ET 

Setting up a Presentation

  • Getting familiar with the PowerPoint interface
  • Customizing the PowerPoint interface
  • Presentation display options

Working in a Presentation

  • Creating slides and slide layouts
  • Working with slide objects and placeholders
  • Formatting slide backgrounds and applying templates

Inserting Objects on Slides

  • Working with tables
  • Working with SmartArt
  • Working with shapes
  • Working with pictures

Slide Transitions and Animations

  • Applying slide transitions in the presentation
  • Creating animations on slides
  • Creating animations on objects on a slide
  • Reordering or removing animations

Slide Show, Printing and Sharing Options

  • Running the slide show
  • Printing the presentation and handouts
  • Saving and sending options

Microsoft Teams Tips 'n' Tricks: October 27, 2021 - 8:30am to 10am ET 

Teams Overview

  • Overview of Teams basic components – Activity, Chat, Teams, Calendar, Calls and Files
  • Customizing the PowerPoint interface
  • Presentation display options


  • Participating in conversations
  • Creating a conversation – formatting/attaching options
  • Private or group chats
  • Initiating video calls or screen sharing


  • Understanding what a Team is and who is participating on a team
  • Understanding Team Channels
  • Team conversations
  • Team files on a SharePoint platform
  • Team options for owners versus members


  • Creating Team meetings
  • Running a Team meeting
  • Recording a Team meeting
  • Overlap of the Teams calendar and the Outlook calendar


  • Accessing recent files
  • Viewing files in context of what Team or Channel the file is associated with