Tips and Tricks

Microsoft Office Suite

Microsoft Office is an amazing piece of software, and even regular users might not be getting as much out of it as they can. This page contains a compilation of basic shortcuts and functions than can greatly improve your efficiency and proficiency.

Microsoft Office Basics
Use the keyboard to work with the ribbon
Change the keyboard focus without using the mouse

Microsoft Access

Access web app shortcut keys Desktop database shortcut keys for Access
Shortcut keys for working with text and data Shortcut keys for navigating records in Access
Shortcuts keys for Access ribbon commands Keyboard shortcuts for using the Help window

Microsoft Excel

Microsoft Excel is a member of the spreadsheet family of software. Spreadsheets allow you to keep track of data, create charts based from data, and perform complex calculations.
Just like a book ledger, spreadsheets store information in columns and rows. You can have up to 16,384 columns and 1,048,576 rows per worksheet.

Microsoft Excel 2016

Frequently used shortcuts Make selections and perform actions
Keyboard shortcuts to Navigate the ribbon Format in cells
Go to the access keys for the ribbon Work with data, fuctions, and the formula bar
Work in the ribbon tabs and menus with the keyboard Function Keys
Use access keys when you can see the Key Tips Other usefull shotcut keys
Navigate in cells

Microsoft Excel 2013

Keyboard access to the ribbon Ctrl Combination shortcuts keys
Function keys Other Useful Shortcut Keys

Microsoft Excel 2010

Keyboard access to the ribbon Ctrl Combination shortcuts keys
Function keys Other Useful Shortcut Keys

Microsoft PowerPoint 2013 & 2016

Frequently used shortcuts Work with shapes, pictures, boxes, objects, and WordArt
Navigate the ribbon with only the keyboard Select and edit text and objects
Change focus by using the keyboard Format text
Move between panes Custom keyboard shortcuts
Work in an outline

Microsoft Publisher 2016 & 2013

Ribbon shortcuts Work with pages
Shape and Picture Effects Edit or format text or objects
Text Effects Print a publication
Create, open, close, or save a publication Automate tasks

Microsoft Outlook

Basic Navigation Search
Common Commands Mail
Calendar People
Tasks Print
Send and Receive Views

Microsoft Word

Microsoft Word or MS-WORD (often called Word) is a graphical word processing program that users can type with. The purpose of the MS Word is to allow the users to type and save documents.
Similar to other word processors, it has helpful tools to make documents.

  • Spelling & grammar checker, word count (this also counts letters and lines)
  • Speech recognition
  • Inserts pictures in documents
  • Web pages, graphs, etc.
  • Tables
  • Displays synonyms of words and can read out the text
  • Prints in different ways

Microsoft Word 2016 & 2013

Frequently used shortcuts Keyboard shortcut reference
Navigate the ribbon with only the keyboard Function key reference
Change the keyboard focus without using the mouse Customize keyboard shortcuts

Keyboard shortcuts for SmartArt graphics

Insert a SmartArt graphic in an Office document Apply character formatting
Work with shapes in a SmartArt graphic Copy text formatting
Move and resize shapes in a SmartArt graphic Apply paragraph formatting
Work with text in a SmartArt graphic Use the Text pane

Microsoft Word 2010

Finding and using keyboard shortcuts Quick reference for Microsoft Word
Navigating the Ribbon Function key reference