MS Office Excel 2007: Level 2

Eligible

La Trobe staff, postgraduate & undergraduate students.

Description

In this intermediate-level course, you will use Microsoft® Office Excel® 2007 to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas, which will allow the data to be analysed in a variety of formats. The target students for this course are students who desire to gain the skills necessary to create templates, sort and filter data, import and export data, analyse data, and work with Excel on the web. In addition, this course helps prepare students who desire to take the Microsoft Office Specialist exam in Excel and who already have knowledge of the basics of Excel, including how to create, edit, format, and print basic worksheets.

Objectives

In this course, you will apply visual elements and advanced formulas to a worksheet to display data in various formats.

Topics

Calculating data with advanced formulas
Organising worksheet and table data
Presenting data using charts
Analysing data using PivotTables and PivotCharts
Inserting graphic objects
Customising and enhancing workbooks and the Excel environment

Duration

The estimated time of completion is 6 hours.

Element K catalog menu

Office Productivity - Spreadsheets

Costs

Staff - Free
Postgraduates - $50
Undergraduates - $50