MS Office Excel 2003: Level 3
Eligible
La Trobe staff, postgraduate & undergraduate students.
Description
You have used Microsoft® Office Excel 2003 to perform tasks such as running calculations on data and sorting and filtering numeric data. You would now like to automate some common tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Microsoft® Office Excel 2003 data with other applications. In this course, you will do all of these things. The target student is someone desiring to gain the skills necessary to create macros, collaborate with others, audit and analyse worksheet data, create PivotTables and PivotCharts, incorporate multiple data sources, and import and export data. This course is also designed for individuals who wish to prepare for the Microsoft Office Specialist (MOS) exam in Excel or Module 2-Key Applications of the Internet and Computing Core Certification (IC3) exam, and who already have knowledge of the basics of Excel, including how to create, edit, format, and print worksheets that include charts and sorted and filtered data.
Objectives
In this course, you will automate some common Microsoft® Office Excel 2003 tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Microsoft® Office Excel 2003 data with other applications.
Topics
- Course introduction
- Streamlining workflow
- Collaborating with others
- Auditing worksheets
- Analysing data
- Working with multiple workbooks
- Importing and exporting data
- Structuring XML workbooks
- Course follow up
Duration
The estimated time of completion is 4 hours and 31 minutes.
Element K catalog menu
Office Productivity - Spreadsheets
Costs
Staff - Free
Postgraduates - $50
Undergraduates - $50