How-to basics
Everyday tasks: sorting, filtering, formatting, printing, shortcuts.
- Camping Meal Planner Spreadsheet: Plan Meals and Pack FoodA camping meal planner spreadsheet helps you map meals to each day, estimate how much food to bring, and turn recipes into…
- Budgeting in Google Sheets: Build a Practical Monthly PlanYes—Google Sheets can work well for budgeting: list your monthly income and spending categories, record transactions, and use formulas to compare your…
- CAF Data Validation Tracker in Google SheetsGoogle Sheets does not have a built-in product called a “CAF data validation tracker,” and CAF can mean different things in different…
- Google Sheets Budget Template: Build or Choose OneA Google Sheets budget template is a spreadsheet that organizes income, planned spending, and actual spending so you can compare your plan…
- Budget Spreadsheet in Google Sheets: Setup and TipsYes—Google Sheets can work as a budget spreadsheet: start with a template or a blank file, list your planned amounts by category,…
- Budget Spreadsheet South Africa: Build a Rand-Based PlanA useful South African budget spreadsheet is a monthly Excel workbook that records income and spending in rand (R), compares planned amounts…
- Budget Spreadsheet Template for Google Sheets: SetupYes—a budget spreadsheet template for Google Sheets is available through the Sheets template gallery when a suitable template appears for your account,…
- Free Budget Spreadsheet in Google Sheets?Yes. You can make a budget spreadsheet for free in Google Sheets using a blank sheet or a template, then track planned…
- Budget Spreadsheet App: How to Choose and Use It WellA budget spreadsheet app is a spreadsheet program you use to plan income, track spending, and see how much money remains. Microsoft…
- Blocking a Sender in Outlook: Steps and What to KnowTo block a sender in Outlook, select one of their messages and choose Block or Block Sender from the message’s menu. In…
- Body Fat Percentage Tracker in Google Sheets GuideYes. You can make a body fat percentage tracker in Google Sheets by recording the date and repeatable measurements, then using a…
- How to Block Out and Share Your Outlook Calendar SafelyTo block out time in Outlook, create a calendar event for the period, set Show as to Busy or Out of office,…
- Block a Sender in Outlook Mail: Steps, Limits and TipsTo block a sender in Outlook, select a message from that person, open the message actions or Junk menu, and choose Block…
- Bi-Monthly Budget Template in Google Sheets: Setup GuideA bi-monthly budget template in Google Sheets can track income, planned spending, and actual expenses for each pay period. Create a transaction…
- Block an Email Sender by Name in Outlook: What WorksOutlook cannot reliably block a sender using only the display name shown in the From line. To block a particular person, block…
- Block an Email Sender in Outlook: Steps and FixesTo block an email sender in Outlook, select a message from that sender, open the message’s options, and choose Block sender (or…
- Best Way to Set Out of Office in Outlook AutomaticallyThe best way to set out of office in Outlook is to use Automatic Replies on your Microsoft 365, Exchange, or Outlook.com…
- Best Ways to Share an Outlook Calendar and What to KnowFor most people, the best way to share an Outlook calendar is to grant specific people access directly from Outlook, with the…
- How to Make a Fillable Form in Word Step by StepThe best way to make a fillable form in Word is to use the content controls in the desktop version of Microsoft…
- Best Way to Make a Schedule in Google Sheets: A GuideFor most people, the best way to make a schedule in Google Sheets is to build a simple weekly grid in a…
- Best Way to Make a Booklet in Word: Layout and PrintingFor a printed, folded booklet, the best way is Word’s built-in Book fold layout: it arranges pages in the right order for…
- Best Way to Make a Budget Sheet in Google Sheets: A GuideThe best way to make a budget sheet in Google Sheets is to keep a transaction log and a separate monthly summary…
- Bar Inventory Spreadsheet: What to Track and How to Use ItA bar inventory spreadsheet is a workbook for recording what a bar has on hand, what it buys or uses, and what…
- Best Way to Export Outlook Contacts as CSV or PSTFor most people, the best way to export Outlook contacts is to save them as a CSV file: it is easy to…
- AVERAGEIF in Google Sheets: Syntax and ExamplesTo average values in Google Sheets only when they meet a condition, use AVERAGEIF. For example, with regions in A2:A6 and sales…
- AVERAGEIFS in Google Sheets: Criteria and ExamplesIn Google Sheets, use AVERAGEIFS to average values that meet multiple conditions. With sales in C2:C100, regions in A2:A100, and product types…
- Auto Sort Google Sheets: Keep Rows in Order AutomaticallyTo auto-sort a Google Sheets table, use SORT in a separate output area for a live sorted view, or add an Apps…
- Automatic Timestamp in Google Sheets: How to Set It UpTo add an automatic, permanent timestamp in Google Sheets, use a small Apps Script that writes the current date and time when…
- Auto Loan Amortization Schedule in Google SheetsYes—Google Sheets can create an auto loan amortization schedule that shows each monthly payment’s interest, principal, and remaining balance. Enter the loan…
- Auto Filter in Google Sheets: Setup and TipsTo use an auto filter in Google Sheets, select your table, then choose Data > Create a filter. Filter icons appear in…