Excel 2013 allows you to customise options and views to create a personalised environment. You can change how data displays by hiding and unhiding rows and columns; enable Show options; and also change the soom level. You can switch workbook views from Normal to Page Layout, to Page Break Preview, or create custom views.

This course will also cover the ways to arrange windows including Arrange All, Freese Panes, Split, and View Side by Side. It will also show you how to change the defaults for creating new workbooks and personalise the Ribbon and Quick Access Toolbar.

For an optimal experience please check the minimum computer system requirements.

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

Please note this course is only available to CPA Australia members.

Learning objectives

  • Hide and show worksheet data and elements in Excel 2013
  • Change how worksheet data displays in Excel 2013
  • Create a custom worksheet view
  • Create appropriate worksheet views in Excel 2013
  • Change how worksheet windows display in Excel 2013
  • Arrange worksheet windows in Excel 2013
  • Change default options for new workbooks in Excel 2013
  • Personalise the ribbon and quick access toolbar in Excel 2013
  • Customise your default options in Excel 2013


Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Excel 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2013; end-users seeking a basic IT certification

60 Minutes

365 Days