After completing this workshop, you will be able to:
Apply custom data formats and validation
- Create custom number formats
- Populate cells by using advanced Fill Series options
- Configure data validation
Apply advanced conditional formatting and filtering
- Create custom conditional formatting rules
- Create conditional formatting rules that use formulas
- Manage conditional formatting rules
Create and modify custom workbook elements
- Create custom color formats
- Create and modify cell styles
- Create and modify custom themes
- Create and modify simple macros
- Insert and configure form controls
Prepare a workbook for internationalisation
- Display data in multiple international formats
- Apply international currency formats
- Manage multiple options for +Body and +Heading fonts