Learn how to send Google Sheets Email Alerts with Apps Script. Step by step setup, trigger types, custom templates, testing tips, and scaling best practices.
Two Minute Tech Tips – Streamlined Tech Know-how That Delivers Results
At Two Minute Tech Tips, we help professionals turn everyday tech challenges into seamless wins—one actionable tutorial at a time. Whether you’re automating Smartsheet workflows, connecting Excel to live data feeds, or leveraging AI tools for smarter meetings, our bite‑sized lessons make complex workflows clear and practical. Learn how to save time, reduce errors, and boost productivity—without getting bogged down in jargon or lengthy guides
SmartTask App: Ultimate Productivity Companion
SmartTask simplifies task management, boosts focus, and enhances your workflow with customizable timers, intuitive due-date management, and the powerful Eisenhower priority matrix.
- Easy task creation and editing that syncs across devices
- Customizable Pomodoro-style countdown timer with manual adjustment
- Dynamic task prioritization with Eisenhower matrix
- Stat screen to track progress on tasks
- Memory Matrix game for quick breaks
- Calendar view for upcoming tasks
- Access to a rich library of productivity articles and insights
- CSV task and stat export
Automate scheduled backups of Google Sheets using Apps Script to protect data, maintain versioned snapshots, and simplify restores with Drive or external storage.
Create custom menu items in Google Sheets with Apps Script. Step-by-step setup, code examples, and integration tips to automate repetitive workflows.
Automate API data pulls into Google Sheets with Apps Script. Learn fetch parse schedule and error handling to build real time dashboards and save hours.
Automate Google Sheets reports with Apps Script triggers to refresh data, format output, and deliver PDFs on schedule for timely, error-free reporting.
Use Excel's EOMONTH NETWORKDAYS to automate month-end cutoffs and business-day KPI calculations for faster, accurate reporting and automated dashboards.
Discover how to use the TODAY and NOW functions to create dynamic, time-saving templates in Excel and Google Sheets that boost productivity.
Learn how combining CHOOSE and SWITCH functions simplifies Excel data mapping for cleaner formulas and faster, flexible automation-ready workflows.
Learn how the OFFSET function makes Excel charts automatically update as data changes to save time and boost reporting accuracy.
Learn how Nesting IFERROR simplifies complex formulas, removes disruptive error messages, and keeps your spreadsheets running smoothly.
Learn how SUMIFS and COUNTIFS functions can speed up reporting, eliminate manual calculations, and power smarter automated analytics.
Learn how to create dynamic rolling averages with Excel's AVERAGEIFS function to automate performance tracking and simplify real-time reporting.