Step-by-Step Tutorials to Help You Work Smarter

Practical how-to guides for Microsoft 365, Google Workspace, Adobe Acrobat, AI tools, automation, productivity and more.

Whether you're learning a new feature, solving a workplace problem, or looking for a faster way to get something done, you'll find practical tutorials designed to help you learn it, apply it, and put it to work.

Sharon Smith 9/21/26 Sharon Smith 9/21/26

How to Automate Excel Tasks with Office Scripts and AI

Learn how to automate repetitive Excel tasks with Office Scripts, create a reusable script with the Action Recorder, and use AI to troubleshoot and refine the TypeScript. Includes practice files and the final code used in the tutorial

Sharon Smith 9/15/26 Sharon Smith 9/15/26

How to Automate Excel Reports with Reusable Copilot Skills in Excel

Learn how to create a reusable Copilot Skill in Excel to automate repetitive report cleanup, formatting, calculations, and more. Follow along with practice files and use my complete SKILL.md example to create your own Skill.

Sharon Smith 3/31/26 Sharon Smith 3/31/26

5 Excel Data Cleanup Checks Before Importing Data (Avoid Upload Errors!)

Learn how to clean Excel data before importing with 5 essential checks to remove duplicates, fix formatting issues, and prevent upload errors in any system.

Sharon Smith 3/4/26 Sharon Smith 3/4/26

Mail Merge in Excel: How to Automatically Generate Invoices, Billing Statements, and Send Emails in Bulk

Learn how to create an auto-populating invoice template, generate client billing statements in bulk, and send multiple emails from Excel using tables, formulas, and VBA automation.