In this course you will use Excel 2007 to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas. You will apply visual elements and advanced formulas to a worksheet to display data in various formats.
Audience: Completion of the Microsoft Excel 2007 Level 1 course or equivalent knowledge and experience is
recommended.
Upon successful completion of this course you should be able to:
- Calculate data with advanced Formulas
- Analyze data with Logical and Lookup Functions
- Create, modify and format Tables
- Sort or Filter Worksheet or Table Data
- Calculate Data Across Worksheets
- Create, modify and format Charts
- Analyze Data using Pivot Tables and PivotCharts
- Insert and modify Pictures and ClipArt
- Illustrate Workflow using SmartArt Graphics
- Manage the View of Large Worksheets