Microsoft Excel 2010 Level 2 is the second of a 3-Level study program for Microsoft Excel 2010. This level extends your basic knowledge of Excel and provides you with the skills and knowledge to produce more effective and productive workbooks. It covers formulae and function techniques, more intricate formatting, setting complex printing options, using intricate charting features and working more effectively with existing worksheets and workbooks. BSBITU314 Design and produce spreadsheets BSBWOR204 Use business technology

Westfield Penrith Weekend on Sunday Weekends

Beginning 10/3/2019 from 9:30:00 to 17:30:00

for 1 Day

$152

Topics Covered include:

Use the fill operations available to fill a data series, and move the contents of cells and ranges within and between workbooks Work with logical functions in Excel and use a range of formula techniques Apply a range of number formatting techniques to data, apply conditional formatting to ranges in a worksheet and apply borders to cells and ranges Apply a variety of page setup techniques and work with various elements of a worksheet Use a range of find and replace techniques, sort and filter data in a list in a worksheet. Use a range of techniques to enhance charts

Course Outcome

BSBITU304 BSBWOR204

On the first session bring

Notebook and pen. Please wear warm clothing in Autumn and Winter as the air conditioning can be cold.

and purchase during the course

Special Issues To Note

Workshop, no concession

97EX2W119