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