Do you have any report that you need to do on daily basis, weekly or monthly basis?
Do you have any standard template?
Do you have a standard working instruction?
Do you need to repeat the same process again and again?
Imagine - if you took 1 hour per day for 5 days per week for 4 weeks for 12 months. That is equal to 240 hours = 30 working days! Do you know that you can reduce the 1 hour task to only 30 seconds?
2. Prompt User
Did you notice excel always asked you to save your unsaved excel file before closing the file?
Do you want to have your own prompter (not part of standard application) in excel?
Do you know that you can also bypass excel prompter?
3. Interact between Office Applications
Do you have reports that you need to submit to your manager on daily basis?
Are you using MS Outlook for emailing?
Do you have any cut off time for the report submission?
4. Use Your Own ShortCut Keyboard
You may not like ctrl + C to copy...
You may not like to use excel built-in quick access toolbar...
Or maybe what you want is not available in excel standard application...
Or maybe you want a shortcut to save as csv file...
You know what? VBA is the answer and can do magic!
No comments:
Post a Comment