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
|
