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

• OneNote help & learning​​​​​​​

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