Microsoft Office Excel 2007 Intermediate
Course Description
In this course, participants will explore the new and enhanced features of Microsoft Office Excel 2007 and use them effectively to organize, analyze and present data. This course will show you on how to work more efficiently with workbooks / worksheets and they will start working with the advanced functions such as the Conditional Function, Lookup Functions, and Database Functions. They will also be taught with the other features available in Microsoft Office Excel 2007 to enhance the appearance of the worksheets, perform analysis using various analysis tools such as pivot table, sorting, filtering, goal seeker and data table.
Objective
Participantsin the end would be able to:
- Be competent in using the conditional logic function and lookup tables
- Effectively use the database functions to manage simple database
- Use the PivotTable and PivotChart effectively to represent data
- Understand how analysis tools are used to achieve results
- Share and consolidate data and formulas across different workbooks and worksheets
Course Duration
14 hours (Full Time) / 15 hours (Part Time)
Target Audience
This course is intended for existing Microsoft Excel users who wish to extend their knowledge and skills beyond building simple workbooks.
