IMPORTRANGE in Google Sheets: Pull Data From Another Sheet
Learn how to use IMPORTRANGE to pull live data from one Google Sheets file into another, allow access, combine it with QUERY, and fix common #REF! errors.
SimplifyLearn Team
Free Employee Onboarding Checklist Template (Excel and Google Sheets)
Download a free new employee onboarding checklist for Excel and Google Sheets: 26 ready tasks from before day 1 to the 90-day review, automatic due dates, owners, progress tracking and overdue alerts.
How to Accept Online Payments as a Small Business
The main ways a small business can get paid online and in person: payment links, website checkout, card machines and tap-to-pay, QR and mobile wallets. Fees to compare, how to choose a provider and how to stay safe.
How to Take Better Meeting Notes (A Simple 4-Part Method)
Stop writing everything down. A simple 4-part method for meeting notes (decisions, actions, open questions, key info), with a ready template, tips for online meetings and how to share notes fast.
How to Use Gemini in Google Sheets (Formulas, Tables and the AI Function)
A beginner’s guide to Gemini in Google Sheets: open the side panel, generate formulas and tables, analyze data and charts, and use the AI function to summarize or categorize text in cells.
How to Use the QUERY Function in Google Sheets (Beginner Guide)
QUERY is the most powerful function in Google Sheets. Learn SELECT, WHERE, ORDER BY, GROUP BY, LIMIT and LABEL with easy examples you can copy into your own sheets.
Free Meeting Minutes Template (Excel and Google Sheets)
Download a free meeting minutes template for Excel and Google Sheets: meeting details, attendees, agenda with decisions, action items with owners and due dates, and an action log that flags overdue tasks.
Online Booking Systems for Small Businesses: How to Choose and Set Up
Let customers book appointments 24/7: what an online booking system does, the features to look for (reminders, deposits, staff calendars, WhatsApp), popular options, and a step-by-step setup.
The Weekly Review: A 30-Minute Checklist to Plan Your Week
A simple 30-minute weekly review checklist: clear your inboxes, review the past week, check projects and deadlines, and plan next week’s priorities, plus a printable checklist.
How to Write Social Media Captions with AI (That Don’t Sound Like AI)
Use ChatGPT, Claude or Gemini to write Instagram, LinkedIn and Facebook captions that sound like your brand: a brand voice prompt, caption formulas, hashtag tips and how to avoid generic AI phrases.