Office information
How to Use the TRUNC Function in Excel
Truncate numbers without rounding, keep a chosen number of decimal places, remove time from date-time values, and truncate digits to the left of the decimal point.
Browse more Latest Office information Articles Page 4
Office information
How to Use the STOCKHISTORY Function in Excel
Retrieve historical stock prices in Microsoft 365 Excel, specify an exchange, select daily, weekly, or monthly fields, handle spilled arrays, and build a chart.
Office information
SUMIF Not Working in Excel? Common Errors and Fixes
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.
Office information
How to Use the FIXED Function in Excel
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.
Office information
How to Use the ROUNDDOWN Function in Excel
Use Excel's ROUNDDOWN function to round a number toward zero, choose decimal places, and round to tens or hundreds with practical formula examples.
Office information
How to Use IFERROR in Excel
Use IFERROR to replace formula errors with a fallback value or message, with practical division and VLOOKUP examples plus guidance on avoiding hidden problems.
Office information
How to Use COUNT and Related Counting Functions in Excel
Learn what COUNT includes and ignores, how COUNTIF applies one condition, and when to use COUNTA, COUNTBLANK, or COUNTIFS instead.
Office information
How to Get the Current Date and Time in Excel
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.
Office information
How to Use the RIGHT Function in Excel
Extract characters from the end of text with Excel RIGHT, split text after delimiters, remove prefixes, convert numeric results, and troubleshoot common errors.
Office information
How to Extract Text with LEFT, MID, and RIGHT in Excel
Choose LEFT, MID, or RIGHT to extract characters from the beginning, middle, or end of an Excel cell, with syntax, examples, and common pitfalls.
Office information
How to Use VLOOKUP in Excel
Use VLOOKUP for exact or approximate vertical lookups, understand each argument, lock table references, and avoid common matching errors.
Office information
How to Use VSTACK and HSTACK in Excel
Combine dynamic arrays vertically with VSTACK or side by side with HSTACK, add headers, use Excel Tables, and handle uneven array sizes.
Office information
How to Calculate Years of Service in Excel
Calculate completed years, months, and days of service with DATEDIF and TODAY, validate date values, and avoid common formula errors.
Office information
How to Use the SUMIF Function in Excel
Sum values that meet one condition with SUMIF, using text, comparison operators, wildcards, blank cells, dates, and practical troubleshooting steps.
Office information
How Accountants Can Use VLOOKUP in Excel
Use VLOOKUP to retrieve product names, account details, and other reference data by code, with exact matching and correctly locked table ranges.
Office information
How to Combine VLOOKUP and LEFT in Excel
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.
Office information
Common Excel Functions: Formulas and Examples
A practical reference to common Excel functions for totals, averages, ranking, counting, logic, rounding, and other everyday calculations.
Office information
How to Use the Vlookup Function in Excel: Formulas and Detailed Examples
The VLOOKUP function in Excel lets users quickly look up data by column, especially useful when working with large tables.
Office information
Basic Excel Functions in Accounting
Explore basic Excel Functions in Accounting, including key concepts, practical steps, useful tips, and common questions.
Office information
Practical Google Docs Tips for Faster, Safer Editing
Work faster in Google Docs with accurate keyboard shortcuts, quick document creation, version history, file uploads, translation, and mobile editing.