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
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
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