OUR VISION

To be the premier Information and Communications Technology (ICT) training and consulting services provider in the caribbean.

OUR MISSION

To improve the quality of knowledge and skills base of ICT professionals within the caribbean through the provision of competitive world-class ICT training and consulting services on current and emerging platforms.

Microsoft Office Excel 2007: Level 3

Duration: 1 Day

Your training in and use of Microsoft Office Excel 2007 has provided you with a solid foundation in the basic and intermediate skills for working in Excel. You have used Excel to perform tasks such as running calculations on data and sorting and filtering numeric data. In this course, you will extend your knowledge into some of the more specialized and advanced capabilities of Excel by automating some common tasks, applying advanced analysis techniques to more complex data sets, collaborating on worksheets with others, and sharing Excel data with other applications.

Course Objective:
You will automate some common Excel tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data with other applications.

Course Outline
Lesson 1: Streamlining Workflow
Lesson 2: Collaborating with Others
Lesson 3: Auditing Worksheets
Lesson 4: Analyzing Data
Lesson 5: Working with Multiple Workbooks
Lesson 6: Importing and Exporting Data
Lesson 7: Using Excel with the Web
Lesson 8: Structuring Workbooks with XML

Print this page Print this page