TEXT Function in Excel: Format Dates and Numbers in Formulas
Use Excel’s TEXT function to format dates, numbers, percentages, times and leading zeros inside formulas, with a format-code cheat sheet and fixes for common mistakes.
Use Excel’s TEXT function to format dates, numbers, percentages, times and leading zeros inside formulas, with a format-code cheat sheet and fixes for common mistakes.
Plan any business event with this free Excel and Google Sheets template: a task timeline that calculates due dates from the event date, a budget tracker (estimated vs actual) and a guest list with RSVP counts.
A practical checklist for buying business laptops: how much RAM and storage you need, processor and screen choices, Windows Pro vs Home, Mac vs Windows, warranty and security features.
Stop searching for final_FINAL_v2. Eight simple file naming rules (dates as YYYY-MM-DD, clear order, versions, no special characters) with examples and a team naming guide you can copy.
What Microsoft Copilot can do in Word and Outlook: draft documents from your files, rewrite and summarize, catch up on long email threads, draft replies and coach your tone, with practical prompts.
The Excel date functions you need at work: TODAY, DATE, EDATE, EOMONTH, NETWORKDAYS (including Friday–Saturday weekends), WORKDAY, DATEDIF for age and service, and WEEKDAY.
Free fixed asset register template for Excel and Google Sheets: track every asset’s cost, location and user, with automatic straight-line depreciation, book value, warranty alerts and a summary by category.
Start email marketing the simple way: choose a tool, collect subscribers with consent, set up a welcome email, write a monthly newsletter people open, and track the numbers that matter.
Two built-in Windows tools that save time every day: clipboard history (Win + V) to paste anything you copied earlier, and the Snipping Tool (Win + Shift + S) for quick screenshots, annotations and copying text from images.
How to use ChatGPT, Claude or Gemini to improve your CV, tailor it to each job, write a cover letter that doesn’t sound generic and practise interview questions, with prompts you can copy.