How-to basics
Everyday tasks: sorting, filtering, formatting, printing, shortcuts.
- XLOOKUP Array Formula in Google Sheets: How It WorksTo return a matching result for every lookup key in Google Sheets, put the keys in a column and use =ARRAYFORMULA(IF(A2:A="", "",…
- Google Sheets ARRAYFORMULA: How It Works in PracticeIn Google Sheets, ARRAYFORMULA applies a formula to a range of cells so one formula can return results for many rows or…
- Array in Google Sheets: How It WorksIn Google Sheets, an array is a set of values arranged in rows or columns, and an array formula can calculate across…
- Google Sheets ARRAYFORMULA: How It Works and ExamplesIn Google Sheets, ARRAYFORMULA lets one formula return results for multiple rows or columns, rather than calculating for just one cell. Enter…
- Google Sheets ARRAYFORMULA: How It Works and When to Use ItIn Google Sheets, ARRAYFORMULA lets one formula calculate across a range and return results into multiple cells. With the numbers 3, 4,…
- Archive Outlook Emails to an External Hard DriveYes. In classic Outlook for Microsoft 365 on Windows, export email to an Outlook Data File (.pst), then save the file to…
- Archive Outlook Emails to a Local Folder as a PST FileYes. In classic Outlook for Microsoft 365 on Windows, export the messages to an Outlook Data File (.pst) using File > Open…
- Google Sheets FILTER: Array Formulas ExplainedIn Google Sheets, use FILTER to return rows or columns that meet conditions; it expands its results automatically, so wrapping it in…
- Archive All Emails in Outlook: Bulk Methods and LimitsTo archive a large number of Outlook emails, select messages in a folder or search results and choose Archive; repeat for other…
- Archive Large Amounts of Emails in OutlookTo archive a large number of emails in Outlook, find the messages you want to keep, select them in manageable batches, and…
- Google Sheets Apps Script Tutorial: Automate Everyday TasksGoogle Sheets Apps Script is Google’s JavaScript-based tool for automating spreadsheets. To start, open a sheet in a browser, choose Extensions >…
- Google Sheets Apps Script Editor: How to Open and UseTo open the Apps Script editor for a Google Sheet, open the spreadsheet in a desktop browser and select Extensions > Apps…
- Google Sheets Apps Script Extension: Setup and UseGoogle Apps Script is built into Google Sheets; you do not need to install a separate extension to use it. In a…
- Apps Script Google Sheets Bad Request? Causes & FixesYes—“Bad Request” in a Google Sheets Apps Script usually means a request was rejected because its URL, range, parameters, or data did…
- Apply a Dropdown to an Entire Column in Google SheetsTo apply a dropdown to a whole column in Google Sheets, select the column or enter its range in the data-validation rule,…
- Applying Styles in Word: A Practical GuideTo apply a style in Microsoft Word for Microsoft 365 on Windows, select the text or place the cursor in its paragraph,…
- How to Alphabetize Names in Google Sheets Step by StepTo alphabetize names in Google Sheets, select the full data range you want to keep together, then choose Data > Sort range…
- Advanced Filter in Google Sheets: Methods and ExamplesGoogle Sheets does not have a single command named “Advanced Filter” like Microsoft Excel. To filter a table interactively, use Data >…
- Advanced Sort in Google Sheets: Rules, Examples & TipsTo use advanced sort in Google Sheets, select the full data range, then choose Data > Sort range > Advanced range sorting…
- Add Page Numbers in Word: Steps, Sections, and FixesIn Microsoft Word for Microsoft 365 on Windows, select Insert > Page Number, choose where the number should appear, and pick a…
- Add Page Numbers in Microsoft Word: A Practical GuideTo add page numbers in Microsoft Word for Microsoft 365 on Windows, select Insert > Page Number, choose where the number should…
- Adding a Header in Word: Steps and OptionsTo add a header in Microsoft Word for Microsoft 365 on Windows, choose Insert > Header, select a design, and type your…
- Adding a Checkbox in Google Sheets: Steps and UsesTo add a checkbox in Google Sheets in a web browser, select the cell or range where you want it, then choose…
- Adding a Checkbox in Google Sheets: Steps and TipsTo add a checkbox in Google Sheets in a web browser, select the cell or range where you want it, then choose…
- Adding a Citation in Word: Steps, Styles, and TipsTo add a citation in Microsoft Word for Microsoft 365 on Windows, open the References tab, choose a citation style, select Insert…
- Adding a Dropdown in Google SheetsTo add a dropdown in Google Sheets in a web browser, select the cell or cells, choose Insert > Dropdown, enter the…
- Add a Shared Mailbox in Outlook Without a PasswordYes. You can add a shared mailbox in Outlook without knowing or entering a separate password for it, as long as your…
- Add a Shared Mailbox to Classic OutlookTo add a shared mailbox in classic Outlook for Windows, first make sure your Microsoft 365 or Exchange account has permission to…
- Add a Shared Mailbox to New Outlook: Setup and FixesTo add a shared mailbox in New Outlook for Windows, right-click your account name in the folder pane, choose Add shared folder…
- How to Add a Shared Mailbox to Outlook on Your PhoneTo add a shared mailbox in Outlook on an iPhone or Android phone, open Outlook, tap your profile or account icon, open…