|
If you have used Microsoft® Office Excel 2003 to perform tasks such as running calculations on data and sorting and filtering numeric data, and 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, then this course is for you. In this course, you will do all of these things.
This course is suitable for those 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.
|
|
After the completion of this course, you should be able to:
- 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.
|
|
Hardware and Software Required:
- Browser Microsoft Internet Explorer 6 (or higher)
- Browser Mozilla Firefox 2 (or higher)
- Browser Apple Safari 2 (or higher)
- Operating System Microsoft Windows 2000, XP, or Vista
- Operating System Apple Mac OS X 10.4 (or higher)
- Processor Pentium III 1 GHz (or better)
- Processor Macintosh Intel-based or PowerPC G4 (or better)
- RAM 512 MB (1 GB or more recommended)
- Internet connection 256K (broadband recommended)
- Adobe Flash Player 8 (current version recommended)
- Adobe Reader 7 (or higher)
|
