Outlook Efficiency
This feature helps find available time slots for meeting attendees.
What is the Scheduling Assistant?
Tip: You can find this in the Outlook calendar under “New Meeting” to check attendees' availability.
Pressing Ctrl + E in OneNote helps you quickly find this.
What is a keyword across all notebooks?
Tip: This search function works across all sections and pages, making it easy to find notes fast.
This function pulls data from one spreadsheet into another.
What is VLOOKUP or XLOOKUP?
Tip: XLOOKUP is a newer, more flexible function than VLOOKUP and works left to right and vice versa.
Pressing Ctrl + Spacebar in Word removes this from selected text.
What is formatting?
Tip: This resets text to the default style, removing unwanted fonts or colors.
Pressing Alt + Tab allows you to switch between these quickly.
What are open applications?
Tip: Hold down Alt and keep tapping Tab to cycle through your windows.
Dragging an email to this section quickly turns it into a task.
What is the Tasks section?
Tip: You can also right-click an email and select “Follow Up” to flag it as a task.
This option allows you to collaborate on a OneNote notebook with colleagues.
What is the Share feature?
Tip: Click “File” > “Share” to generate a link that others can use to edit your notebook.
Pressing Alt + = automatically performs this function in Excel.
What is AutoSum?
Tip: Select a column or row before using AutoSum to quickly calculate the total.
This feature allows you to compare two versions of a document side by side.
What is Compare Documents?
Tip: It’s useful when reviewing edits made by different users.
This feature allows you to send an email directly to a Teams conversation.
What is Share to Teams?
Tip: Look for the “Share to Teams” button in Outlook emails.
This feature allows you to recall an email after sending it (if the recipient hasn’t opened it).
What is Message Recall?
Tip: Go to your Sent Items, open the message, and select “Recall This Message” under “Actions.”
This tool converts handwritten notes into editable text.
What is Ink to Text?
Tip: Use this if you take handwritten notes on a tablet or stylus-friendly device.
This feature keeps the top row visible while scrolling in a large dataset.
What is Freeze Panes?
Tip: You can find this under the “View” tab, and you can freeze rows or columns.
This collaboration feature lets multiple users edit a document at the same time.
What is Co-Authoring?
Tip: Requires saving the document to OneDrive or SharePoint for real-time collaboration.
This tool automates workflows between Microsoft 365 apps.
What is Power Automate?
Tip: You can create workflows to save time, like auto-saving email attachments to OneDrive.
These features let you save frequently used email text for quick insertion.
What are Quick Parts and My Templates?
Tip: Quick Parts are found in the Insert tab of an email, while My Templates are available in Outlook Web.
This feature links meeting notes directly to an Outlook calendar event.
What is Insert Outlook Meeting Details?
Tip: This feature auto-populates meeting info into OneNote, keeping your notes organized.
This conditional formatting feature highlights duplicate values in a dataset.
What is Highlight Duplicates?
Tip: It’s located under “Conditional Formatting” in the “Home” tab.
This tool allows you to save and reuse frequently used text blocks.
What is Quick Parts?
Tip: You can insert stored Quick Parts by typing the name and pressing F3.
Deleted files can be recovered from this OneDrive location within 30 days.
What is the Recycle Bin?
Tip: If a file isn’t there, check if it was permanently deleted or moved elsewhere.
This Outlook feature separates important emails from less relevant ones.
What is Focused Inbox?
Tip: If you don’t see it, enable it under Outlook settings in the “Mail” section.
Pressing Ctrl + 1 in OneNote creates this type of interactive list.
What is a To-Do List?
Tip: Checkboxes appear next to each item, allowing you to track completed tasks.
Pressing Ctrl + Shift + L in Excel toggles this feature on or off.
What is the Filter function?
Tip: Use this to quickly sort and filter data in your spreadsheet.
Pressing Ctrl + K allows you to insert this into your document.
What is a hyperlink?
Tip: This works in most Office apps, not just Word.
This Microsoft tool lets you create quick polls in Outlook and Teams.
What is Microsoft Forms?
Tip: Forms let you gather responses quickly and analyze them in Excel.