Computer Based Training (CBT) and Video Based Training (VBT) have emerged as the premier training tools in recent years. KeyStone Self-Paced CBT/VBT courses are known for their high quality in-depth content. Compared to traditional training methods, KeyStone courses cost less and users can learn faster while taking advantage of some of the best trainers in the industry. They are easy to use, comfortable to follow, perfect for training at the office, on the road, or at home.This Microsoft Office Excel 2007 Essentials Course will lead you through the new results-oriented interface of Excel 2007. You will learn how to create more professional-looking charts, share data with enhanced security with your coworkers, customers, and business partners, and manage your business information more effectively.
• Find the appropriate tool commands that you want, when you need them.
Import, organize, and explore data with expanded spreadsheets, with a bigger grid that supports multi-core processor platforms.
Create and use interactive PivotTable views that enable you to retrieve data to help you answer multiple questions.
Share spreadsheets and ensure you and your organization work with the most current business information.
Consolidate data using position, category, and three dimensional formulas.
Your Personal Instructor: Deanna Reynolds
Deanna Reynolds has worked as a technical trainer for more than ten years teaching in both the corporate and technical college environments. Throughout her teaching career, Deanna has been privileged to work with students traveling many different career paths on a multitude of software programs including the entire Microsoft Office Suite, Web Design, Desktop Publishing, and Database Development. Deanna specializes in delivering instructor-led training and writing custom courseware that helps her students quickly become "power-users." Microsoft Excel 2007: Beginner
1.0 Getting Started
2.0 Entering Data
3.0 Changing Worksheet Layout
4.0 Entering Formulas
6.0 Using Themes and Styles
Microsoft Excel 2007: Intermediate
1.0 Managing Workbooks
2.0 Tables and Data Management
3.0 Using Cell References
5.0 Creating Web Pages from Workbooks
6.0 Using Excel with Other Applications
7.0 Customizing Excel
8.0 Using Scenarios and Watching Cells
9.0 PivotTables and PivotCharts
Microsoft Excel 2007: Advanced
2.0 Advanced Formulas and Functions
3.0 Data Consolidation
5.0 Track Revisions
6.0 Data Validation and Conditional Formatting
7.0 Creating Templates