Excel 2007 Advanced
Welcome to the Excel 2007-Advanced course. Knowing how to use the advanced features of Microsoft Excel 2007 opens a completely new experience in using this spreadsheet program. The novice user tends to use Excel 2007 as holding place for report data. They may know how to insert data and move columns around, but rarely go into the deeper functions that Excel 2007 offers.
This course will teach you the most common advanced features of Microsoft Excel 2007. The goal of this course is to get you familiar with these functions in a safe learning environment. Once you complete the course, your familiarity and confidence in using the advanced feature of Excel 2007 will increase, making Excel 2007 a more useful tool for you at work or at home.
Before we begin, let’s learn more about each other. Breaking the ice early in the training session will help to foster a team environment where sharing and learning will occur.
Course Objectives
Research has consistently demonstrated that when clear goals are associated with learning, it occurs more easily and rapidly. This Excel 2007-Advanced course will teach the participants how to:
- Use SmartArt
- Insert Objects
- Create Charts
- Create Pivot Tables
- Work with Pivot Tables
- Create Pivot Charts
- Solve Formula Errors
- Use What-If Analysis
- Manage Your Data
- Group and Outline Data