#ExcelAutomation #ExcelTips #ReportBuilding

How to automate repetitive reports without learning to code

Name: How to automate repetitive reports without learning to code
Uploaded: 2026-09-01T21:16:13+00:00
Duration: 4 min
Description: Learn how to automate repetitive report building in Excel using action recording—no JavaScript or macro knowledge required. Tommy Stephens walks through setting up relative vs. absolute mode recording to create reusable templates you can share with your team. Watch how to capture formatting, data entry, and layout in minutes and replay them whenever you need.

4:00 · A clip from K2's Excel Best Practices And Features, taught by Tommy Stephens

Learn how to automate repetitive report building in Excel using action recording—no JavaScript or macro knowledge required. Tommy Stephens walks through setting up relative vs. absolute mode recording to create reusable templates you can share with your team. Watch how to capture formatting, data entry, and layout in minutes and replay them whenever you need. From the course “K2's Excel Best Practices And Features” (2 CPE credits, Computer Software and Applications, Intermediate): https://www.cpetoday.com/course/k2s-excel-best-practices-and-features-24c-ebpf Taught by Lawrence A. "Mac" McClelland — Speaker & Author, K2 Enterprises. More from Lawrence A. "Mac" McClelland: https://www.cpetoday.com/instructor/lawrence-a-mac-mcclelland CPE Today offers live webinars, Live Replays and self-study for CPAs and accounting professionals. NASBA-sponsored (ID 167619) and an IRS-approved CE provider. https://www.cpetoday.com/ #ExcelAutomation #ExcelTips #ReportBuilding