Fix Windows problems, troubleshoot devices, understand AI, secure your accounts and get more from your technology with tested step-by-step guides.
Fix SUMIF formulas that return zero, the wrong total, or #VALUE! by checking syntax, dates, operators, range sizes, numbers stored as text, time formats, and external references.
Round a number to a chosen number of decimal places and return formatted text, control thousands separators, and know when ROUND or cell formatting is a better choice.
Use Excel's ROUNDDOWN function to round a number toward zero, choose decimal places, and round to tens or hundreds with practical formula examples.
Use IFERROR to replace formula errors with a fallback value or message, with practical division and VLOOKUP examples plus guidance on avoiding hidden problems.
Learn what COUNT includes and ignores, how COUNTIF applies one condition, and when to use COUNTA, COUNTBLANK, or COUNTIFS instead.
Use TODAY for a date that updates automatically, NOW for date and time, or a keyboard shortcut for a fixed timestamp, with practical date formulas.
Extract characters from the end of text with Excel RIGHT, split text after delimiters, remove prefixes, convert numeric results, and troubleshoot common errors.
Choose LEFT, MID, or RIGHT to extract characters from the beginning, middle, or end of an Excel cell, with syntax, examples, and common pitfalls.
Use VLOOKUP for exact or approximate vertical lookups, understand each argument, lock table references, and avoid common matching errors.
Combine dynamic arrays vertically with VSTACK or side by side with HSTACK, add headers, use Excel Tables, and handle uneven array sizes.
Calculate completed years, months, and days of service with DATEDIF and TODAY, validate date values, and avoid common formula errors.
Sum values that meet one condition with SUMIF, using text, comparison operators, wildcards, blank cells, dates, and practical troubleshooting steps.
Use VLOOKUP to retrieve product names, account details, and other reference data by code, with exact matching and correctly locked table ranges.
Extract a code from the start of a text value with LEFT and use it directly in VLOOKUP to return the corresponding name or category.
A practical reference to common Excel functions for totals, averages, ranking, counting, logic, rounding, and other everyday calculations.
The VLOOKUP function in Excel lets users quickly look up data by column, especially useful when working with large tables.
Explore basic Excel Functions in Accounting, including key concepts, practical steps, useful tips, and common questions.
Work faster in Google Docs with accurate keyboard shortcuts, quick document creation, version history, file uploads, translation, and mobile editing.
Limit a Google Form to one response per account, close it manually, or use the built-in close date and response limit controls, with practical checks.
Insert fractions, exponents, roots, Greek letters, and operators with the Google Docs equation editor, then show or hide its toolbar as needed.