Day 6: Tips & Tricks for MS Office

Below you will find some tips and tricks to make the most of three Microsoft Office applications; use these links to jump to a section.

They are not intended for advanced users, but may make daily use a little easier!

 

MS Outlook
Browse the PDF file to the right or use the hyperlink above to download the guide.Contents:

  • Change your default font settings
  • Schedule emails
  • Forward an email as an attachment
  • Include a poll in your email
  • Search MS Outlook:
    • From a named sender
    • To a named recipient
    • With an attachment
    • Before, after or between date limits
  • Create Rules to automatically:
    • Send messages from a specific sender to a folder
    • Send messages containing set words in the subject line to a folder
    • Flag messages from a specific sender for follow-up
TipsMSOutlookDec2020KLS
MS Word
Browse the PDF file to the right or use the hyperlink above to download the guide.
Contents:

  • Set default fonts
  • Zoom slider
  • Smart look-up
  • Keyboard shortcuts:
    • Ctrl + C: Copy
    • Ctrl + V: Paste
    • Ctrl + X: Cut
    • Ctrl + Z: Undo
    • Ctrl + F: Find
    • Ctrl + H: Find and replace
    • Ctrl + K: Insert hyperlink
    • Ctrl + space: Clear formatting
    • Ctrl + Enter: Insert page break
    • Ctrl + Backspace: Delete whole words

 

TipsMSWordDec2020KLS
MS Excel
Browse the PDF file to the right or use the hyperlink above to download the guide.Contents:

  • Quickly add without formulas
  • Autosum
  • Autocorrect, for complex terms
  • Transpose data from row to column (and vice versa)
  • Conditional formatting (e.g. Red-Amber-Green ratings)
    • Based on numbers
    • Based on date
  • Vague search function
  • Quick analysis, including Sparklines
  • Keyboard shortcuts
    • o F2
      Start editing the current cell
      o Shift + F10
      Open the right-click menu for the current cell
      o Ctrl + ;
      Insert today’s date
      o Ctrl + Shift + :
      Inserts the current time
      o Ctrl + 5
      Apply strikethrough to text
      o Ctrl + Pageup
      OR
      o Ctrl + PageDown
      Move between sheets in your current workbook
      o Ctrl + arrow button
      Jump to the edge of a data block
      o Ctrl + `
      View all formulas in your spreadsheet
      o Alt + Enter
      Create a new line within a cell
      o Ctrl + Shift + %
      Apply percent format
      o Ctrl + Shift + $
      Apply currency format
TipsMSExcelDec2020KLS

 

Print Friendly, PDF & Email

Written by