Excel 2007 dramatically changes the way users create and work with spreadsheets. New features such as the Ribbon interface, improved graphics capabilities, new mathematical functions, greatly increased worksheet dimensions, and XML-based data files offer tremendous opportunities for increased productivity – but only for those who are prepared to take advantage of these opportunities. This course is designed to prepare users for the most significant upgrade to Microsoft’s standard-setting Excel spreadsheet application in over a decade. Participants will have access to sample data files.
Course Information:
CPE Credit: Recommended 4 Hours Specialized Knowledge and Applications
Instructional delivery method: Group-live demo and discussion using color computer projection - NOT a hands-on course
Prerequisites: None
Program level: Intermediate
Advanced preparation: None
Designed for: Accountants who want to learn how to use Excel 2007
Who should attend: Uses or potential users of Excel 2007
Course Highlights:
- Become familiar with the Ribbon, contextual tabs, style galleries, Live Preview, the Office Button, the mini-toolbar, the Quick Access Toolbar, and keyboard navigation
- Use the enhanced Status Bar, Zoom Slider, and Print Layout
- Learn about the new XML file formats and their likely impact on file sharing
- Understand Compatibility Mode and the Office 2007 Compatibility Pack for Excel 2000-2003
- Use Formula Autocomplete and the improved Formula Bar
- Investigate new functions, such as SUMIFS, COUNTIFS, and IFERROR
- Create, use, and manage defined names with the Name Manager
- Apply consistent formatting to workbooks using themes and styles
- Use conditional formatting to create dynamic dashboard displays of tabular data
- Investigate dynamic tables – creating, formatting, filtering, and using structured referencing
- Identify, filter, or remove unique or duplicate records
- Charting in Excel 2007 – creation, manipulation, and customization
- Introduction to PivotTables and PivotCharts
- Use SmartArt to create professional quality business figures and illustrations
- And much more…
Dates & Locations:
