Case-Sensitive Lookups in Excel with EXACT
VLOOKUP, XLOOKUP and MATCH ignore upper and lower case. Learn how to do a case-sensitive lookup with EXACT, count case-sensitive matches, and find case-sensitive duplicates.
VLOOKUP, XLOOKUP and MATCH ignore upper and lower case. Learn how to do a case-sensitive lookup with EXACT, count case-sensitive matches, and find case-sensitive duplicates.
Free recruitment tracker for Excel and Google Sheets: track candidates through every hiring stage, next steps with overdue alerts, ratings and days in process, plus an open roles summary.
Practical Slack tips for busy teams: clear channel names, threads, notification settings, reminders, saved items, search shortcuts, status updates and simple team rules that cut the noise.
Use ChatGPT, Claude or Gemini to build a practical one-page marketing plan for a small business: define your customer and offer, set goals, pick channels, plan 90 days of actions and track results.
Stop Excel printing a few columns on extra pages: fit the sheet to one page, set the print area, use landscape and narrow margins, repeat header rows, and check Page Break Preview.
A beginner’s guide to Google Ads for small businesses: set a clear goal, choose keywords and negative keywords, target the right area, write ads, control your budget and track real results.
A simple OneDrive guide: back up your Desktop and Documents automatically, understand the sync icons, save space with files on demand, share files safely, and recover old versions or deleted files.
How to use Google NotebookLM at work: add your own documents, ask questions and get answers with citations, create summaries, FAQs, briefing docs and audio overviews, and keep company data safe.
Lock formulas but let people type in input cells: how to protect an Excel sheet, protect workbook structure, encrypt a file with a password, and protect ranges in Google Sheets.
Free price list and product catalog template for Excel and Google Sheets: products by category, optional discounts, automatic VAT, prices with and without VAT, stock status and a print-ready layout.