100 Productivity TipssteemCreated with Sketch.

in productivity •  8 months ago  (edited)

image.png

Here is a preview:

📊 Excel

  1. How to autosum adjacent cells?
    Alt + =

  2. How to create a waterfall chart?
    Insert > Chart > Waterfall

  3. How to insert a new worksheet?
    Shift + F11

  4. How to track changes in a workbook?
    Review > Track Changes > Highlight Changes

  5. How to insert a new column?
    Ctrl + Shift + "+"

(get the answers 6-25 in the Cheat Sheet below)

🖥 Powerpoint

  1. How to convert a text into a diagram?
    Select text > Convert to SmartArt > Choose a SmartArt Graphic

  2. How to set slide transitions?
    Transitions > Transition to This Slide > Effect

  3. How to loop a PowerPoint presentation?
    Slide Show > Set Up Slide Show > Loop continuously

  4. How to compress images in PowerPoint?
    Select image > Picture Format > Compress Pictures

  5. How 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

  1. How to recall an email in Outlook?
    Open Sent Items > Message > Actions > Recall This Message

  2. How to set out of office?
    File > Automatic Replies > Send automatic replies

  3. How to automatically delay all sent emails by 1 minute?
    File > Manage Rules & Alerts > New Rule > Apply rule on messages I send

  4. How to create a new email?
    Press Ctrl + N

  5. How to reply to a message?
    Press Ctrl + R

(get the answers 56-75 in the Cheat Sheet below)

📑 Word

  1. How to jump to your most recent edits?
    Shift + F5

  2. How to track changes in Word?
    Enable “Track Changes” for real-time editing visibility

  3. How to insert a table in Word?
    Insert tab > Select Table > Choose the number of rows and columns

  4. How to create a template in Word?
    File > Save As > Save as type: Word Template (*.dotx)

  5. 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

Authors get paid when people like you upvote their post.
If you enjoyed what you read here, create your account today and start earning FREE STEEM!
Sort Order:  
Loading...