none

PowerPoint 365 Essentials

Workshop Objectives

Research has consistently demonstrated that when clear goals are associated with learning, it occurs more easily and rapidly. 
By the end of this workshop, you should be able to:
  • Open and close PowerPoint
  • Understand the Office 365 web interface, including the home page, the team site, and the shared documents list
  • Upload a presentation to the Shared Documents library 
  • Understand the PowerPoint 365 browser interface
  • Open a presentation in Reading View or Editing View
  • Page through presentations
  • Review Slide Notes
  • Open the pop out
  • View the Outline View
  • Open a selected presentation in the PowerPoint 2010 desktop application
  • Print from the reading view
  • Understand the types of slides and add a slide
  • Use the Slide organizer
  • Hide slides
  • Understand about saving presentations
  • Understand the PowerPoint web app interface
  • Use content placeholders
  • Insert and work with pictures
  • Insert links
  • Working with Notes
  • Print from the Editing View
  • Understand Broadcasting presentations over the web
  • Prepare your presentations for broadcast
  • Broadcast your presentation
  • View a broadcast presentation

Excel 365 Essentials

Workshop Objectives

Research has consistently demonstrated that when clear goals are associated with learning, it occurs more easily and rapidly. 
By the end of this workshop, you should be able to:
  • Understand the Office 365 web interface, including the home page, the team site, and the shared documents list
  • Understand the Excel 365 browser interface
  • Upload a spreadsheet to the Shared Documents library 
  • Download and reload workbooks
  • Open in Editing View
  • Open the spreadsheet in the Excel desktop application for more advanced features
  • Understand saving and collaborating
  • Enter labels and values
  • Build, copy and edit formulas
  • Use absolute referencing appropriately
  • Understand the difference between Formulas and Functions
  • Use basic Excel functions, including SUM, AVERAGE, MAX, and MIN
  • Sort and filter data
  • Collaborate with others on a spreadsheet
  • Use alignment options
  • Apply borders and fill color
  • Insert and work with Tables and Charts
  • Insert links