In this section we are going to learn the following targets.
- Creating, editing and deleting a defined names for cells and ranges
- Pasting list of defined names as documentation
- Using defined names in formulas
- Adding define names to the existing formulas
- Creating a validation of rules for data entry
- Protecting contents of worksheet and workbooks
- Adding, editing and deleting comments
- Learning macro viruses and Ms Excel security features
- Creating macro using macro recorder
- Editing macro using VBE (Visual Basic Editor)
- Assigning macro to keyboard shortcut and a button
- Saving workbook in a macro enabled format
- Minimizing the Ribbon
No comments:
Post a Comment