How-to basics
Everyday tasks: sorting, filtering, formatting, printing, shortcuts.
- Daily Schedule in Google Sheets: Build a Practical PlannerTo make a daily schedule in Google Sheets, create columns for start time, end time, activity, and notes, then add one row…
- Excel vs Google Sheets for Dashboards: Which Fits?For a dashboard built from larger or messier data, Microsoft Excel for Microsoft 365 on Windows is usually the stronger choice, especially…
- Daily Expenses Tracker in Google Sheets: How to Set It UpYes—you can make a daily expenses tracker in Google Sheets by recording each purchase on its own row, then using SUM and…
- Daily Lunch Count in Google Sheets: Setup and FormulasYes—Google Sheets can track daily lunch orders and total meals by date and choice. Create a log with a date, student, and…
- Daily Report in Google Sheets: Setup and TipsA daily report in Google Sheets is easiest to maintain when you record each activity in a consistent log and show the…
- Current Date in Google Sheets: Formula, Settings & TipsTo show the current date in Google Sheets, enter =TODAY() in a cell. It displays today’s date according to the spreadsheet’s time…
- Currency Rate in Google Sheets: Formulas and TipsTo get a currency rate in Google Sheets, use the GOOGLEFINANCE function with a currency pair, such as =GOOGLEFINANCE("CURRENCY:USDEUR") for the U.S.…
- Custom Sort in Google Sheets: Steps, Rules, and ExamplesTo custom-sort Google Sheets data, select the full table, choose Data > Sort range > Advanced range sorting options, select a column…
- Google Sheets Currency Converter: Rates and FormulasTo convert currencies in Google Sheets, use GOOGLEFINANCE to get a rate, then multiply the amount by that rate. With no input…
- Currency Exchange in Google Sheets: Rates and FormulasTo get a currency exchange rate in Google Sheets, enter a formula such as =GOOGLEFINANCE("CURRENCY:USDEUR"), which requests the USD-to-EUR rate. To convert…
- Currency Formula in Google Sheets: Convert and FormatFor a live exchange rate in Google Sheets, enter =GOOGLEFINANCE("CURRENCY:USDEUR") in an empty cell to request the US dollar-to-euro rate. To convert…
- Creating Rules in Microsoft Outlook: A Practical GuideTo create a rule in Outlook for Microsoft 365 on Windows, select a message and choose Home > Rules > Create Rule,…
- Creating Rules in Outlook: Setup and TroubleshootingTo create a rule in Outlook, open the Rules controls, choose a condition such as a sender or subject, select an action…
- Currency Conversion in Google Sheets: Formulas and TipsTo convert an amount in Google Sheets, multiply it by a rate returned by GOOGLEFINANCE. For example, if A2 contains a USD…
- Creating Labels in Microsoft Word: A Step-by-Step GuideTo create labels in Microsoft Word, open Mailings > Labels, choose the label size under Options, enter your text, and select New…
- Creating Labels in Word: Mail Merge, Setup, and PrintingTo create labels in Microsoft Word for Microsoft 365 on Windows, open Mailings > Start Mail Merge > Labels, choose the label…
- Creating a Template in Microsoft Outlook: A Practical GuideTo create a reusable email template in classic Outlook for Windows, compose a message, choose File > Save As, and save it…
- Creating Columns in Word: Layout, Breaks, and FixesTo create columns in Microsoft Word for Microsoft 365 on Windows, select the text you want to format, then choose Layout >…
- Creating a Schedule in Google Sheets: Steps and TipsTo create a schedule in Google Sheets, open a blank spreadsheet, add columns for dates, start and end times, activities, and owners,…
- Creating a Signature in Outlook: Steps and TipsTo create a signature in Outlook, open the signature settings for your version, choose New, write and format your signature, then select…
- Creating a Signature in Microsoft Outlook: Setup GuideTo create an Outlook signature, open the signature settings for your version of Outlook, add and format the text, then choose whether…
- Creating a Cover Page in Word: Steps and Design TipsTo create a cover page in Microsoft Word, open the Insert tab, choose Cover Page in the Pages group, and select a…
- Creating a Fillable Form in Word: Steps and Tips That WorkTo create a fillable form in Microsoft Word for Microsoft 365 on Windows, turn on the Developer tab, insert content controls where…
- Creating a Flowchart in Word: Steps and Practical TipsTo create a flowchart in Microsoft Word for Microsoft 365 on Windows, choose Insert > Shapes, add shapes from the Flowchart section,…
- Creating a Brochure in Word: A Practical GuideTo create a brochure in Microsoft Word, start with File > New and search for a brochure template, or set up a…
- Creating a Calendar in Google Sheets: Steps and TipsTo create a calendar in Google Sheets, open a blank spreadsheet, set up weekday headings and a date grid, then use a…
- Creating a Booklet in Word: Setup, Pages, and PrintingTo create a booklet in Microsoft Word for Microsoft 365 on Windows, open Layout > Margins > Custom Margins, set Multiple pages…
- Create a Vertical Line in an Outlook Email SignatureTo create a vertical line in an Outlook signature, use a two-column table and show only the border between its columns; for…
- Debt Snowball Spreadsheet: Build One in ExcelYes—you can create a debt snowball spreadsheet in Excel by listing debts from smallest balance to largest, calculating each month’s interest and…
- Create Your Own PowerPoint Template for Free: A GuideYes—you can design a PowerPoint template without paying for a template file: use PowerPoint for the web with a free Microsoft account…