Excel automation for office work

If every week you repeat the same tasks in Excel and Word — sending dozens of emails with different attachments, creating one PDF for every row of a list, numbering invoices or generating QR codes for an inventory — this is where you learn to stop doing it by hand.

These guides come from years of teaching office software to teachers, administrative assistants and small business owners. Each tutorial explains the full procedure so you can build it yourself, and at the end you’ll find the ready-to-use template that applies the same logic, tested and with email support.

A note before you start: the screenshots and the templates show Spanish-language Excel and Word. Every English guide names the English menu or function and, the first time it appears, the Spanish name you’ll see in the images.

Where to start? If you send bulk email, go straight to the guide on sending emails with attachments from Excel and Outlook. If you produce certificates, letters or reports, see how to mail merge into separate documents. If you manage inventory, look at the QR code and barcode generators.