Office 2013 training

Access

Beginner

• Design and build tables for a database (Access basics, part 1)

• Create table relationships (Access basics, part 2)

• Create your first Access 2013 database

• Introduction to queries (Access basics, part 3)

• Webinar: Intro to Access 2013

Intermediate

• Dealing with read-only queries

• Stop a query from asking for input

• Use parameter queries to filter query results

• Use update queries to change data in Access 2013

• Query criteria 2: Using date criteria in queries

Excel

Beginner

• Add numbers in Excel

• Basic math in Excel

• Create a chart

• Create your first Excel workbook

• Freeze or lock panes

• Top tips for working in Excel Online

• Understand and use cell references

• Use AutoFill and Flash Fill

Intermediate

• Add or subtract time

• Average a group of numbers

• Insert headers and footers

• Make the switch to Excel 2013

• Sort and filter data

• Take conditional formatting to the next level

• Use conditional formatting

• VLOOKUP: When and how to use it

Advanced

• Advanced IF functions

• Array formulas

• Create and manage drop-down lists

• Create a PivotTable and analyze your data

• Password protect workbooks and worksheets

• Print worksheets and workbooks

• Webinar: Understanding Power Pivot in Excel 2013

• Webinar: Understanding the Excel Data Model

• Work with macros

OneNote

Beginner

• Create your first OneNote 2013 notebook

• Using Tables in OneNote

• Webinar: Back to school with OneNote

• Webinar: OneNote for free plus cool new tools

Intermediate

• Webinar: Onetastic for OneNote

Outlook

Beginner

• Add and use contacts

• Calendar basics

• Email basics

• Fonts, hyperlinks, and spell check

• Recall and replace sent messages

• Setting up automatic replies and inbox rules in Outlook

• Send and open attachments

• The ins and outs of BCC

• Use Instant Search to find Calendar items

• Use Instant Search to find contacts

• Use Instant Search to find messages and text

• Webinar: Using Outlook Web App

Intermediate

• Add holidays to your calendar

• Control spam

• Create or delete a search folder

• Group and view email in your inbox

• Import and export vCards to Outlook contacts

• Make the switch to Outlook 2013

• Make your job easier with Outlook

• Reach out with contact groups (distribution lists)

• Send or delete an email stuck in your outbox

• Take calendars to the next level

• Templates and stationery

• Track email with read receipts

• Use voting buttons to create or respond to polls

• Webinar: Tips for searching Outlook

• Webinar: 5 simple ways to clean up Outlook

• Webinar: 8 great timesavers in Outlook

Advanced

• Archive or back up your mailbox

• Create and use Personal Folders (Outlook Data Files)

• Password protect your mailbox

• Share or publish your Office 365 calendar

• Use rules to manage your email

• Webinar: Archiving items in Outlook

PowerPoint

Beginner

• Apply and change a theme

• Apply transitions between slides

• Create speaker notes

• Create your first PowerPoint 2013 presentation

• Highlight text and change fonts

• Print slides, notes, or handouts

• Use Presenter view

Intermediate

• Backgrounds in PowerPoint

• Crop a picture to fit a shape

• Group shapes or pictures

• Make the switch to PowerPoint 2013

• Webinar: Handouts for PowerPoint with guru Rick Altman

• Webinar: YouTube videos in PowerPoint

• Webinar: Ways to avoid rebuilding PowerPoints over and over

• Webinar: 5 steps to a better PowerPoint

• Working with watermarks

• Work with handout masters

Advanced

• Add a sound effect to a transition

• Add bullets to text

• Add headers and footers to a presentation

• Add sound effects to an animation

• Animate pictures, clip art, text, and other objects

• Create a flow chart

• Create an org chart

• Create a template from a presentation

• Design motion paths

• Insert a bar chart

• Insert a line chart

• Insert a pie chart

• Insert a video from your PC

• Insert music and time it to your slides

• Rehearse timings for a slide show

• Trigger an animation effect

• Use slide masters to customize a presentation

Word

Beginner

• Create your first Word 2013 document

• Custom margins in Word 2013

• Introduction to Tables of Contents (TOCs)

• Line spacing

• Spell-check basics

• Top tips for working in Word for the web

• Track changes

• Webinar: 5 things to raise your game to a college level

• Work with word counts in your document

Intermediate

• Create labels

• Creating an MLA paper with citations and a bibliography

• Footnotes in Word 2013

• Make the switch to Word 2013

• Mirror margins in Word 2013

• Resumes in Word

• Take tables of contents (TOCs) to the next level

• Use landscape and portrait orientation

• Using Styles in Word

• Webinar: Creating forms in Word

• Working with watermarks

Advanced

• Advanced mail merge

• Advanced tables of contents

• Collapsible headings

• Mail merge

• Take mail merge to the next level