I don’t format in Excel anymore, I do this instead

In this tutorial, I'll show you two powerful workflows that can dramatically reduce the time it takes to create professional, consistent spreadsheets.

First, you'll learn a simple trick for formatting multiple worksheets at once using a single reference worksheet. Then, I'll show you a more advanced workflow that uses Microsoft Copilot and a custom AI prompt to update complex worksheets, or even an entire workbook, while maintaining a consistent design and layout, and repeatable results.

Whether you're creating monthly reports, client workbooks, financial reports, or dashboards, these techniques can save hours of repetitive work, especially for finance professionals, accounting professionals and data analysts.

In this tutorial you'll learn:

• How to format multiple Excel worksheets from a single reference sheet
• A simple workflow for applying consistent formatting across a workbook
• How to create a powerful custom Copilot prompt that produces better results
• Tips for getting more accurate and consistent responses from Excel AI
• How to handle more complex workbook updates with AI
• Ways to speed up repetitive reporting and workbook maintenance

If you use Microsoft Excel regularly, these techniques can help you spend less time formatting/updating and more time analyzing your data.

If you'd like to learn more about automating Excel, check our Excel Automation Courses.

I hope you enjoy the video! :)

Don