Excel 2013 provides many advanced features to customize formats and layouts. Data can be customised to any format and adding a customised fill series can not only save you time, but help ensure consistency and accuracy in your work. Customising cells, adding forms, and creating templates all help tailor your workbooks to your individual needs. Conditional formatting can also format ranges according to specific criteria. Finally, Excel provides tools to help create workbooks that are accessible and consider international audiences. 

This online course forms part of the SkillsNet short course suite.

Learning objectives

  • Create a custom data format in Excel 2013
  • Create a custom fill series in Excel 2013
  • Decide how to create a custom data format and fill series in Excel 2013
  • Apply custom styles in Excel 2013
  • Add form fields to a workbook and create a template in Excel 2013
  • Add form fields to a workbook and create a template in Excel 2013
  • Choose how to create a custom cell style and form control in Excel 2013
  • Apply advanced conditional formatting in Excel 2013
  • Apply advanced conditional formatting in Excel 2013
  • Decide how to apply advanced conditional formatting and filtering in Excel 2013
  • Check for accessibility issues in Excel 2013
  • Decide how to provide accessibility in a workbook in Excel 2013

Audience

Professionals seeking to improve competency in Excel.

60 Minutes

365 Days

loading...