Microsoft Excel 2007 Advanced
Course Description
In a new results-oriented user interface, Microsoft Office Excel 2007 provides powerful tools and features that you can use to analyze, share, and manage your data with ease.
This course builds on the skills gained in the Introduction course allowing you to work more efficiently with databases, develop more complex calculation and perform detailed data analysis.
Training Credits Required
1 Microsoft Office Training Credit is required per person attending the course. For more information about how to earn training credits visit our Training Overview Page.
Prerequisites
- Keyboarding/Typing skills
- Previous experience with spreadsheet software
- Experience with Windows Vista or XP
- Familiarity with Microsoft Excel 2007
Course Outline
- Template creation
- The .xltx extension
- Creating and editing templates
- Smart Art
- Pivot Tables
- Creating, updating and editing
- Filters
- Remove Duplicate data
- Text to Columns
- Subtotals
- Name Manager
- Tracing Precedents and Dependants
- Customizing the Ribbon and Quick Access Toolbar
- Protecting Sheets and Workbooks
- Printing and Print Areas
- Recording Macros
- Inserting Excel Charts and data into Word 2007 documents
Course Registration
To see a list of dates and register for this course visit our course calendar.