![]() So if you find yourself carrying out the same data processes on your data to get it just how you need it, then record a Macro. I use Macros to transform the information I get every week into the format I need to update my reports with the latest data. But it is data, and we can do stuff with it. Let’s face it, sometimes it is pretty (or not pretty at all!) awful. Usually, our data to update our reports is in a raw state. Avoiding repetition is my principal reason for using Macros in my reports. There is room for both, one method does not necessarily replace the other. Now, you may be a Power Query user (I am myself), and Power query DOES eliminate repetitive tasks, but not all tasks can be done in Power Query. So, my first reason I want to share as to why I use Excel macros is that they avoid repetitive tasks. Yes, I have FOUR great reasons why I use Excel macros. If you want to up your Excel VBA skills then this is my recommended VBA Course. So, today let’s explore my TOP FOUR reasons for including Excel Macros in your Excel dashboard reports. In this post, we’ll discuss four reasons to start using macros in your Excel reports and dashboards. Do you use macros in your Excel reports and dashboards? If not, you should! Macros can save you a lot of time and hassle when creating these documents. Time for some more Excel Macro fun on a Monday.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |