Two automation and customisation techniques in Microsoft Excel

Command Buttons

Command buttons make it easier to trigger certain commands rather than having to go into tools menus, command buttons are easy to make and mostly run off macros, an automation technique. In tools, I selected customize then forms, and dragged command button to the toolbars.

Protecting cells

By protecting cells the user can keep the spreadsheet from malicious damage or piggybacking. The user can also create a password for the spreadsheet to prevent people from tampering with it.

Validation

Validation is a tool that the user can use to make sure that incorrect data is not input into the spreadsheet, for example, dates must be correct, and formulae must be correct.

Macros

A macro is automated technique that is recorded by the user manually, so it can be run as many times as the user requires.

Local and Global Macros

A local macro is a macro that is only available for use in the sheet that it was created in. These are only used to navigate around the spreadsheet it was created in. A global macro is a macro that can be used in all sheets. These can be created in any sheet as it is on the toolbars. Local macros are usually set as command buttons in one sheet; this means it can only be used in that sheet and ones it is connected to. A global macro is set on the toolbars, and therefore is available for use in any sheet. A global macro can used for example, a header and footer which is used in all sheets.