The aim of the course is to provide participants with a specific knowledge about how to use macros and forms in MS Office Excel. The course applies to the various versions of Microsoft Excel that are available on the market.
1. Macros
• Recording, creating and deleting a simple macro
• Assigning a macro to buttons
• Editing and renaming macros
• Understanding simple VBA commands in Excel
2. Creating forms to complete
• Applying data validation
• Creating searchable lists
• Defining a name for a cell
Ad hoc
Contatti
