Self-Study Resources

Word Online

• What’s new in Word Online
• Differences between using a document in the browser and in Word
• Compare Word Online with Word 2013, 2010, and Mobile

 

Excel Online

• What’s new in Excel Online
• Differences between using a workbook in the browser and in Excel
• Comparing Excel Online, Excel Services, and Excel Web App

 

PowerPoint Online

• Basic tasks in PowerPoint Online
• Differences between using a presentation in the browser and in PowerPoint
• Compare PowerPoint Online with PowerPoint 2013, 2010, and Mobile

 

OneNote Online

• Basic tasks in OneNote Online
• Differences between using a notebook in the browser and in OneNote

 

• Set up email in Outlook 2013 or 2010

• Find Office applications in Windows 10, Windows 8 or Windows 7

• Meet the app launcher

Word 2013

• Discontinued features and changed functionality in Word 2013

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 Online
• Track changes
• 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
• Working with watermarks

Advanced

• Advanced mail merge
• Advanced tables of contents
• Collapsible headings
• Mail merge
• Take mail merge to the next level
• Create a fillable form

Excel 2013

• Discontinued features and changed functionality in Excel 2013

Beginner

• Add numbers in Excel 2013
• Basic math in Excel
• Create a chart
• Create your first Excel 2013 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
• Understanding Power Pivot
• Understanding the Excel Data Model
• Work with macros

PowerPoint 2013

• Discontinued or changed features in PowerPoint 2013

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
• Print your handouts, notes, or slides
• 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

Outlook 2013

• Discontinued or changed features in Outlook 2013

Beginner

• Add and use contacts
• Calendar basics
• Email basics
• Fonts, hyperlinks, and spell check
• Recall and replace sent messages
• Send automatic replies when you’re out of the office
• 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

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

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 Business calendar
• Use rules to manage your email

SharePoint 2013

• Discontinued features and modified functionality in Microsoft SharePoint 2013

Beginner

• Create and set up a list
• Introduction to document libraries
• Start using a list
• Update Office365 profile and privacy settings

Intermediate

• Organize and configure a SharePoint library

Word 2010

 

Beginner

• Create accessible Word documents
• Create your first Word document II
• Office 2010 Security: Protecting your files
• Word 2010 keyboard shortcuts
• Word 2010 tips and tricks

Intermediate

• Create and customize a table of contents
• Create visually compelling documents in Word 2010
• Get control of page numbers, headers, and footers

Excel 2010

 

Beginner

• Excel 2010 keyboard shortcuts I: CTRL key shortcuts
• How to create a basic chart in Excel 2010
• Office 2010 Security: Protecting your files

Intermediate

• Excel 2010 keyboard shortcuts II: ALT key shortcuts
• Plan payments and savings in Excel 2010
• Sparklines: Use tiny charts to show data trends
• The IF function: what it is, and how to use it
• Understand data at a glance with conditional formatting
• Use Excel tables to manage information
• VLOOKUP: What it is, and when to use it

Advanced

• Save time by creating and running macros in Excel 2010

PowerPoint 2010

 

Beginner

• Animations and transitions
• Charts and diagrams I: SmartArt graphics
• Charts and diagrams II: Data charts
• Insert video into your presentation
• Office 2010 Security: Protecting your files
• PowerPoint 2010 keyboard shortcuts
• PowerPoint 2010 tips and tricks
• Put your photos into PowerPoint

Intermediate

• Going further with animations

Outlook 2010

 

Beginner

• Mailbox management 1: Use views to stay organized
• Mailbox management 2 : Instant Search and Search Folders
• Mailbox management 3: File your stuff in folders
• Use e-mail signatures in Outlook 2010
• Send Automatic Replies when you're away
• Outlook and RSS: The internet in your mailbox

Intermediate

• Outlook 2010 keyboard shortcuts I: Email
• Outlook 2010 keyboard shortcuts II: Calendar, contacts, tasks
• Outlook 2010 keyboard shortcuts III: Alt key shortcuts
• Outlook Best Practices: How Harry got organized
• Save time with templates in Outlook

 

• What’s new in Office 2016 for Mac

Word 2016 for Mac

• Add page numbers
• Add a “Draft” watermark to your document
• Create a template
• Keyboard shortcuts
• Delete a blank page   
• Create a table of contents
• Track changes
• Add footnotes or endnotes
• Add a page break
• Share your document with others

Excel 2016 for Mac

• Create a drop-down list
• Conditional formatting
• Print headings on every page
• Copy a formula by dragging the fill handle
• Count how often a value occurs        
• VLOOKUP refresher
• Freeze panes
• Formula basics
• Split text into different cells

PowerPoint 2016 for Mac

• Add a transparent picture (watermark) to your slides
• Modify a slide master
• Create or change slide layouts
• Create an organizational chart with SmartArt           
• Compress the picture size
• Change or remove animation effects
• Change and save a theme
• Create your own presentation template

Outlook 2016 for Mac

• Import items
• Set up email
• Propose a new meeting time
• Where’s my Outbox?  Send automatic “Out of Office” replies
• Add a signature automatically to every outgoing message
• Use VoiceOver in Outlook 2016 for Mac

OneNote 2016 for Mac

• Introducing OneNote for Mac
• Basic tasks in OneNote for Mac
• Keyboard Shortcuts
• Accessibility Options

Word 2011 for Mac

 

The following Word for Mac tutorials are in PDF format:

• Word for Mac 2011 basics
• Format text with styles
• Track and review document changes
• Use Mail Merge to create a form letter
• Automate tasks with Visual Basic macros 

The following Word for Mac videos are in PowerPoint (.pptx) files:

• Training: What’s new in Word for Mac 2011
• Training: Word for Mac 2011 Basics
• Training: Working with citations, sources, and bibliographies
• Training: Create a custom flyer
• Training: Collaborate with online documents
• Training: Add a decorative border to a document
• Training: Access and edit your files from anywhere
• Video: Remove the background from a picture
• Video: Copy and paste basics

Excel 2011 for Mac

 

The following Excel for Mac tutorials are in PDF format:

• Excel Basics
• Sort and Filter Lists
• Get Started with Formulas and Functions
• Automate tasks with Visual Basic macros

The following Excel for Mac videos are in PowerPoint (.pptx) files:

• Training: What’s new in Excel for Mac 2011
• Training: Excel for Mac 2011 Basics
• Training: Understand data at a glance with conditional formatting
• Training: Get started with charts
• Training: Analyze data with a PivotTable
• Training: Get started with VLOOKUP
• Training: Access and edit your files from anywhere
• Video: Remove the background from a picture
• Video: Copy and paste basics

PowerPoint 2011 for Mac

 

The following PowerPoint for Mac tutorials are in PDF format:

• PowerPoint for Mac 2011 Basics
• Design with Themes, Part 1: The Basics
• Design with Themes, Part 2: Advanced Custom Themes

The following PowerPoint for Mac videos are in PowerPoint (.pptx) files:

• Training: What’s New in PowerPoint for Mac 2011
• Training: PowerPoint for Mac 2011 basics
• Training: Animate slide text and objects
• Training: Using audio and Training in presentations
• Training: Access and edit your files from anywhere
• Video: Remove the background from a picture
• Video: Copy and paste basics

Outlook 2011 for Mac

• Outlook for Mac 2011 basics
• Best practices for Outlook for Mac 2011

Outlook for Mac videos are in .PPTX format:

• Training: What’s new in Outlook for Mac 2011
• Training: Outlook for Mac 2011 Basics
• Training: Customize and manage your inbox
• Video: Sync Outlook for Mac calendars with your iPhone, iPad, or iPod
• Video: Switch between different inboxes

 

• Microsoft Project 2013 Essentials

Please make sure to login with your LSE Email and Password

• Microsoft Visio 2013 Essentials

Please make sure to login with your LSE Email and Password