1 / 13

Macros.Templates.Wizards

Macros.Templates.Wizards. By: CY. Macros makes the user’s life easier by simplifying and combining several processes into a single command. Long boring tasks can be shorten to just a click of a button! Macros are extremely useful for tasks that are repeated . Macros?.

mahlah
Download Presentation

Macros.Templates.Wizards

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Macros.Templates.Wizards By: CY

  2. Macros makes the user’s life easier by simplifying and combining several processes into a single command. • Long boring tasks can be shorten to just a click of a button! • Macros are extremely useful for tasks that are repeated Macros?

  3. So how to create a macro? • Firstly, look for the macro’s menu. For excel you may need to enable the developer tab first, in order to get the macro). • Next click on record. But before you do so please be sure you know exactly where to find the tools and buttons you need as the macro records every mouse click and action including the mistakes you make! Macros?

  4. Once you click record, name the macro. Make sure its something clear so you know what the macro does. Also there is a hot key function(shortcut), enter anything that you find easy to remember. Macros

  5. Once done click ‘ok’ now start with the steps and actions you want the macro to record. • When finish performing the actions stop recording. • Test out your new macro with the shortcut! Macros

  6. Wizards is something that is present in almost all software • Wizards are a step by step guide to helping the user create a new document, table ,queries etc. • This is extremely useful if you are a beginner at the software. Wizards

  7. Some disadvantages are: • Limitation of Wizards. Wizards do not offer as much customization which something experienced users do not like • Wizards might sometimes be time consuming as you need to go through all the steps Wizards

  8. Example of a wizard

  9. Templates are files that are preformatted in the beginning. When you open it, there are already certain things that are formatted and present for example to look like a business letter • Templates can be found along with the software or created by a user • To create a template simply go to file<save as<and choose the template file format. Templates

  10. Templates are extremely useful when you find yourself using the same format for all your documents. User could create a template based on that and lesser time would be wasted when documents are created in the future.

  11. Templates

  12. Eg.of template

  13. http://www.tethyssolutions.com/macros.htm • http://www.wikihow.com/Create-Macros • http://www.techterms.com/definition/wizard • http://www.techterms.com/definition/template References

More Related