M3 : Compare Different Technology Methods

709 Words2 Pages

M3 - Compare different automation methods
In MOD’s excel workbook I have used many macros to create shortcuts to different sheets and also macros to perform various tasks. Overall using macros will speed up how fast the end user can use and navigate the sheet and also make it easier to use. I have also used auto-sum, this automatically entered in a certain formula that I had chosen. By using auto-sum I saved time by not having to enter in long formulas. I have also used an automated filter tool, this tool filters out any data that the user decides is unneeded, which will help the user as it does not show data that useless to them or is unneeded.
By using shortcuts MOD will save time because they do not need to go searching for a sheet in a book that could have a hundred pages in it. This will save time in the production of the spreadsheet as they will have more time to enter in the data.
By using a print macro MOD will be able to save even more time as they will quickly be able to print out the spreadsheet and give it to a customer or review it.
By having a macro that gets rid of the...

Open Document