Formatting raw data, filtering and sorting data, or applying the same set of functions and procedures to your sheets are all possibilities. You may not understand this at time, but macros can save you a large amount of time if you perform the same series of instructions on daily basis. Now, whenever we instruct excel to run that specific macro, we don't have to provide it with each step manually excel will automatically do them all. For example, we could have a macro that instructs excel to take a number, add 3, multiply by 7, and return the modulus. A macro in excel is basically a series of instructions and once you create a macro, what excel will do is that it will execute those instructions step-by-step on the data that you have provided to excel. In order to know how to add macros in excel, you first need to understand what macros are.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |