TAFE Gippsland

Intermediate Microsoft Excel - 0417EXCEL2

This course will expand on your knowledge of basic Microsoft Excel and teach you intermediate functions of the program: Use the fill operations available to fill a data series, Use a range of techniques to work with worksheets, Apply a variety of page set up techniques, Apply borders to cells and ranges in a worksheet, Use common worksheet functions, Create more complex formulas and functions, Create and use defined names in a workbook, Apply a range of number formatting techniques to worksheet cells, Apply conditional formatting to ranges in a worksheet, Use goal seeking to determine the values required to reach a desired result, Understand and use Excels Quick Analysis tool, Create and work with tables, Use a range of elements and features to enhance charts, Select and change the format of objects in a chart