XLOOKUP vs VLOOKUP: Which Should You Use?
XLOOKUP vs VLOOKUP compared side by side: syntax, looking left, exact match, inserting columns, errors and compatibility. Find out which lookup function you should use.
SimplifyLearn Team
VLOOKUP in Excel Explained Simply (With Examples)
Learn how VLOOKUP works in Excel with simple, real examples: the four arguments, exact vs approximate match, common mistakes, and when to use XLOOKUP instead.
How to Fix #N/A in VLOOKUP and XLOOKUP (6 Easy Fixes)
Getting #N/A from VLOOKUP or XLOOKUP? Learn the 6 common causes (extra spaces, text numbers, wrong match type, unlocked ranges) and how to fix each one step by step.
Free Expense Tracker Template for Excel
Download a free expense tracker for Excel and Google Sheets: log expenses with category drop-downs, set monthly budgets, and see spent, remaining and % used for any month.
Password Managers for Small Teams Compared
Password managers for small business teams compared: 1Password, Bitwarden, Dashlane, Keeper and NordPass. Shared vaults, admin features, free options and how to roll one out.
Power Automate for Beginners: 5 Easy Office Flows
A beginner guide to Microsoft Power Automate: what flows, triggers and actions are, how to build your first flow, and 5 easy office automations for Outlook, Forms, Excel, Teams and approvals.
Best AI Meeting Note-Takers Compared
AI meeting note-takers compared: built-in options in Teams, Zoom and Google Meet, plus Otter, Fireflies, Fathom, tl;dv, Tactiq and Granola, and how to choose and use them responsibly.
Excel Keyboard Shortcuts Cheat Sheet (Free Printable PDF)
The Excel keyboard shortcuts office workers use most, grouped by task, with a free one-page printable PDF cheat sheet to keep on your desk.
Free Weekly Planner Template (Excel and Google Sheets)
Download a free printable weekly planner for Excel and Google Sheets: automatic dates, daily task lists, top 3 priorities, notes and a habit tracker. Plus how to plan your week in Notion.
Canva for Business: Make Social Media Posts in 10 Minutes
Use Canva to make professional social media posts for your business in about 10 minutes: set up your brand, pick a template, edit, resize and schedule, plus tips for a consistent look.