How-to basics
Everyday tasks: sorting, filtering, formatting, printing, shortcuts.
- How to Print Timestamps from Google Sheets ClearlyTo print timestamps from Google Sheets, format the cells as date and time, select the sheet or range you need, then choose…
- How to Properly Archive Emails in Microsoft OutlookTo archive email in Outlook, select the message and choose Archive on the toolbar; Outlook moves it to the account’s Archive folder…
- Prevent Duplicates in Google Sheets: 3 Reliable MethodsTo prevent duplicate entries in Google Sheets, select the cells where new values will go, open Data > Data validation, and add…
- Present PowerPoint in Teams With Speaker NotesTo present PowerPoint in Teams while keeping your speaker notes to yourself, open the meeting, select Share, and choose the deck under…
- How to Present PowerPoint and See Your Speaker NotesTo present PowerPoint while keeping your notes visible, connect your computer to a second screen, set the displays to extend rather than…
- PowerPoint Notes: How to Present With Speaker NotesTo present with speaker notes in PowerPoint, add your talking points in the Notes pane, then start the slide show with Presenter…
- How to Schedule an Email in OutlookTo schedule an email in Outlook, write your message, open the menu beside Send, and choose Schedule send in new Outlook or…
- How to Present from Notes in PowerPoint with Presenter ViewTo present with your speaker notes visible only to you, add notes to each slide, turn on Presenter View, connect or select…
- How to Present PowerPoint and See Your Speaker NotesTo present a PowerPoint while keeping your notes visible, connect a second display, set Windows to extend the desktop, and start the…
- Outlook: How to Stop Emails From Being Archived by AccidentTo keep messages in your Inbox, turn off AutoArchive in classic Outlook, remove Archive from Outlook on the web or new Outlook…
- How to Open Mail Merge in Microsoft WordTo open Mail Merge in Microsoft Word for Microsoft 365 on Windows, select the Mailings tab, then choose Start Mail Merge. Pick…
- Mail Merge in Word: Step-by-Step InstructionsTo perform a mail merge in Microsoft Word, prepare a recipient list, choose a document type under Mailings > Start Mail Merge,…
- How to Merge Cells in Google SheetsTo merge cells in Google Sheets, select the adjacent cells you want to combine, then choose Format > Merge cells and pick…
- How to Merge Two Word Documents to Compare ChangesTo compare two Word documents, open Word for Microsoft 365 on Windows and choose Review > Compare > Compare, select the earlier…
- How to Move All Emails to the Archive Folder in OutlookTo move emails into Outlook’s Archive folder in bulk, open the folder you want to clear, select its messages, and choose Archive.…
- How to Mass Archive Emails in OutlookTo mass archive emails in Outlook, open the folder containing the messages, select the messages you want, and choose Archive. Outlook moves…
- Google Sheets: How to Merge Cells in a TableTo merge cells in Google Sheets, select the adjacent cells, then choose Format > Merge cells and pick Merge all, Merge horizontally,…
- How to Merge Cells in Google Sheets: Steps and TipsTo merge cells in Google Sheets, select the cells, then choose Format > Merge cells and pick a merge option. Merging combines…
- How to Manually Archive Emails in Microsoft OutlookTo manually archive an email in Outlook, select the message and choose Archive; Outlook moves it to the Archive folder without deleting…
- How to Manually Archive Emails in Outlook 365To manually archive an email in Outlook 365, select it and choose Archive on the toolbar. Outlook moves it out of your…
- How to Mark Duplicates in Google Sheets with ColorTo mark repeated values in Google Sheets, select the cells you want to check, open Format > Conditional formatting, and use a…
- How to Make Two Columns in Microsoft Word: A GuideTo make two columns in Microsoft Word for Microsoft 365 on Windows, open the Layout tab, choose Columns, then select Two. Word…
- How to Make Two Columns in a Word Document QuicklyTo make two columns in Microsoft Word for Microsoft 365 on Windows, select the text you want to format—or place the cursor…
- How to Make a Weekly Schedule in Google Sheets Step by StepTo make a weekly schedule in Google Sheets, create a grid with time slots down the first column and days of the…
- Google Sheets Percentage Bar: Make an In-Cell Progress BarTo make a percentage bar in Google Sheets, put your percentage in one cell and use the SPARKLINE function in the next…
- How to Make a PowerPoint Like a Trifold Poster LayoutTo make a PowerPoint trifold poster, set one slide to the poster’s full unfolded size, mark the three panels and fold lines,…
- One Page Landscape in Word: How to Change One PageTo make just one page landscape in Microsoft Word, isolate it in its own section with a section break before and after…
- How to Make One Page Landscape in Word for MacTo make just one page landscape in Word for Mac, isolate it in its own section with a Next Page section break…
- How to Make One Page in Word Have Two Text ColumnsTo make just one page in Word have two columns, isolate it with section breaks, click inside that section, then choose Layout…
- How to Make Just One Page Landscape in Microsoft WordTo make just one page landscape in Microsoft Word, isolate it in its own section: insert a Next Page section break before…