Design And Produce Business Documents - Microsoft Word and Excel 2016

B&W printed

This publication has been mapped to the BSBITU306 - Design And Produce Business Documents competency. It applies to individuals who may exercise discretion and judgement using appropriate theoretical knowledge of document design and production to provide technical advice and support to a team.

At the completion of this course you should be able to:

  • understand the importance of establishing and using document standards
  • work safely with your computer, consider your impact on the environment and manage files and folders efficiently
  • understand the general features of Office 2013 and how to use them
  • obtain help for Word whenever you need it
  • work with the basic features of Word
  • select and work with text in a document
  • cut and copy information within and between documents
  • check the spelling and grammar of a document
  • use a range of font formatting techniques
  • work effectively with features that affect the page layout of your document
  • apply various page layout techniques
  • insert headers and footers into a document
  • create and apply styles
  • work with tabs
  • create and modify tables
  • perform a mail merge from scratch
  • customise mail merges
  • save various kinds of documents
  • create and work with a new workbook
  • understand, create and work with formulas and functions
  • use font formatting techniques
  • apply borders to cells and ranges in a worksheet
  • format rows and columns in a worksheet
  • align the contents of cells in a number of ways
  • understand and use the number formatting features in Excel
  • print your workbook data
  • apply a variety of page setup techniques
  • create effective charts in Microsoft Excel
  • create a range of common charts

  View outline

View a detailed outline of the course material. You may need to install Adobe Acrobat Reader to open this file.

View Outline

  Download student files

Download working files to go with this course. Read the installation instructions for opening these files.

Download Files Zip