100 Productivity Tips
Here is a preview:
📊 Excel
How to autosum adjacent cells?
Alt + =How to create a waterfall chart?
Insert > Chart > WaterfallHow to insert a new worksheet?
Shift + F11How to track changes in a workbook?
Review > Track Changes > Highlight ChangesHow to insert a new column?
Ctrl + Shift + "+"
(get the answers 6-25 in the Cheat Sheet below)
🖥 Powerpoint
How to convert a text into a diagram?
Select text > Convert to SmartArt > Choose a SmartArt GraphicHow to set slide transitions?
Transitions > Transition to This Slide > EffectHow to loop a PowerPoint presentation?
Slide Show > Set Up Slide Show > Loop continuouslyHow to compress images in PowerPoint?
Select image > Picture Format > Compress PicturesHow to link Excel tables in PowerPoint?
Insert > Text > Object > Create from File > Browse to select Excel file
(get the answers 31-50 in the Cheat Sheet below)
📧 Outlook
How to recall an email in Outlook?
Open Sent Items > Message > Actions > Recall This MessageHow to set out of office?
File > Automatic Replies > Send automatic repliesHow to automatically delay all sent emails by 1 minute?
File > Manage Rules & Alerts > New Rule > Apply rule on messages I sendHow to create a new email?
Press Ctrl + NHow to reply to a message?
Press Ctrl + R
(get the answers 56-75 in the Cheat Sheet below)
📑 Word
How to jump to your most recent edits?
Shift + F5How to track changes in Word?
Enable “Track Changes” for real-time editing visibilityHow to insert a table in Word?
Insert tab > Select Table > Choose the number of rows and columnsHow to create a template in Word?
File > Save As > Save as type: Word Template (*.dotx)How to change line spacing in Word?
Home > Line and Spacing > Line Spacing Options
(get the answers 81-100 in the Cheat Sheet below)
📕 Want more practical productivity content like this?
Free list of “Top 100 Excel Tips”: https://bit.ly/3UWOKam