How-to basics
Everyday tasks: sorting, filtering, formatting, printing, shortcuts.
- Free Network Inventory Spreadsheet: What to TrackYes. You can create a free network inventory spreadsheet in Excel from a blank workbook, using columns for device identity, location, network…
- Free Savings Tracker Google Sheets: Set Up a Simple SheetYes. You can make a free savings tracker in Google Sheets by starting with a blank spreadsheet, recording deposits and withdrawals, and…
- Google Sheets IFS Function: Syntax and ExamplesGoogle Sheets’ IFS function checks conditions in order and returns the value paired with the first condition that is TRUE. Use it…
- Free Meal Planner Spreadsheet: Plan Meals in ExcelYes—you can make a free meal planner spreadsheet in Excel by laying out a week of meals, adding a separate shopping list,…
- Free Monthly Budget Template for Google Sheets: SetupYes—Google Sheets can be used for a free monthly budget, either by choosing a budget template from the Sheets template gallery or…
- Google Sheets VLOOKUP: Formula, Examples, and FixesIn Google Sheets, VLOOKUP searches for a value in the first column of a range and returns a value from another column…
- Free Debt Snowball Spreadsheet for Google Sheets: SetupYes. You can make a free debt snowball spreadsheet in Google Sheets by listing each debt, its current balance, interest rate, and…
- Google Sheets SPLIT Formula: How to Separate Text CleanlyIn Google Sheets, use =SPLIT(A2, ",") to divide the text in A2 at each comma, with the pieces spilling into neighboring columns.…
- Google Sheets Alphabetize Formula: Sort Names A to ZTo alphabetize a list in Google Sheets, enter =SORT(A2:A20,1,TRUE) in an empty cell, assuming the names are in A2:A20; the result is…
- Google Sheets for Finances: Budgeting and TrackingYes—Google Sheets can help you make a household budget, track spending, monitor bills, and compare actual costs with your plan. In a…
- Hanging Indent in Microsoft Word: Steps, Uses and FixesTo make a hanging indent in Microsoft Word, select the paragraph or paragraphs, open Home > Paragraph using the small dialog box…
- Finding Duplicates in Google Sheets: Practical MethodsTo find repeated values in Google Sheets, select the cells, choose Format > Conditional formatting, and use a custom formula such as…
- Find Duplicates in Excel and Google Sheets by FormulaIn Excel, select the cells and choose Home > Conditional Formatting > Highlight Cells Rules > Duplicate Values; in Google Sheets, use…
- Finance Spreadsheet in Google Sheets: Setup and FormulasA finance spreadsheet in Google Sheets can help you track income, spending, budgets, savings, and debt in one place. Start with a…
- Google Sheets Filter Views: Create, Use, and Share ThemA Google Sheets filter view is a saved way to sort or filter a table without changing the view other collaborators are…
- Filtering in Google Sheets: How to Narrow and Sort DataTo filter data in Google Sheets, select a cell in your table and choose Data > Create a filter. Use the filter…
- Filter Sort in Google Sheets: Sort Data Without Losing RowsTo filter and sort in Google Sheets, select your table, choose Data > Create a filter, then open a column’s filter menu…
- Filter Unique Values in Google Sheets With a FormulaIf the values are in A2:A and their statuses are in B2:B, enter =UNIQUE(FILTER(A2:A7,B2:B7="Paid",A2:A7<>"")) to return each nonblank value marked Paid once.…
- Google Sheets Filter Shortcut: Turn Filters On and OffIn Google Sheets in a web browser, press Ctrl+Shift+L on Windows or ChromeOS, or ⌘+Shift+L on a Mac, to turn a filter…
- Google Sheets FILTER Function: Examples, Syntax, and TipsIn Google Sheets, the FILTER function returns only the rows or columns from a range that meet conditions you specify. For example,…
- Google Sheets Filter Shortcut: Keys and Quick TipsIn Google Sheets in a web browser, press Ctrl+Shift+L on Windows or ChromeOS, or ⌘+Shift+L on a Mac, to create a filter…
- Filter Google Sheets Without Affecting OthersTo filter a shared Google Sheet without changing what collaborators see, use a filter view: in a browser, open Data > Filter…
- Filter by Values in Google Sheets: Steps and TipsTo filter by values in Google Sheets, select your table, choose Data > Create a filter, open the filter icon in a…
- Google Sheets Filter: Show Only the Rows You NeedTo filter data in Google Sheets, select a cell in your table and choose Data > Create a filter; then use the…
- Export Yahoo Contacts to Outlook: Steps and Common FixesYes. Export your Yahoo contacts as a CSV file, then import that file into Outlook; CSV is the practical route for moving…
- Export Outlook Contacts to a Samsung Phone: StepsTo get Outlook contacts onto a Samsung phone, either sync the Outlook account through the Outlook app or export the contacts and…
- Export Outlook Contacts to vCard: Steps and OptionsYes. In classic Outlook for Windows, you can save an individual contact as a vCard (.vcf); Outlook does not provide a built-in…
- Export Phone Contacts to Outlook on iPhone and AndroidTo export phone contacts to Outlook, save them from your iPhone or Android phone as a contact file, then import that file…
- Export Outlook Contacts to Excel: A Clear Step-by-Step GuideYes. Export Outlook contacts to a comma-separated values (CSV) file, open that file in Excel, then save it as an Excel workbook…
- Export Outlook Contacts to PST: Steps and OptionsYes. In classic Outlook for Microsoft 365 on Windows, go to File > Open & Export > Import/Export, choose Export to a…