Microsoft® Office Excel 2007
Basic | Intermediate | Advanced | Custom
Basic -Outline (8 Hours)
Book: Microsoft® Office Excel 2007 Step by Step
- What’s New in Excel 2007
- Excel 2007 Interface
- Managing Larger Collections
- New Excel File Format
- Formatting Cells and Worksheets
- Managing Data Tables
- Formulas and AutoComplete
- New Functions
- Conditional Formats
- More Charts
- Managing Printouts
- Creating a Workbook
- Modifying Workbooks
- Modifying Worksheets
- Customizing Excel
- Entering and Revising Data
- Moving Data
- Find and Replace
- Correcting and Expanding Upon Data
- Tables
- Grouping of Data
- Formulas
- Summarizing Data
- Error Detection
- Formatting Cells
- Working with Styles
- Themes
- Table Styles
- Conditional Formatting
- Adding Images to a Worksheet
Intermediate- Outline (8 Hours)
Book: Microsoft® Office Excel 2007 Step by Step
- Filters
- List Manipulation
- Data Validation
- Sorting
- Outlining with Levels
- Data Lookup
- Data from Multiple Sets
- Linking to other Workbooks
- Data Consolidation
- Grouping
- Alternative Data Sets
- Using Goal Seek
- Solver
- Data Analyzer and Descriptive Statistics
- PivotTables
- Filtering, Showing and Hiding in PivotTables
- Editing PivotTables
- Formatting PivotTables
- PivotTables and External Data Sets
Advanced- Outline (8 Hours)
Book: Microsoft® Office Excel 2007 Step by Step
- Creating Charts
- Customizing Charts
- Trends
- PivotCharts
- SmartArt
- Printing Worksheets and Selections
- Headers and Footers
- Printing Charts
- Introduction to Macros
- Creating and Modifying Macros
- Automating Macros
- Integration with Office Programs
- Importing Excel Data into other Programs
- Linking to other Documents
- Exporting Charts to other Documents
- Collaborating with Colleagues
- Comments
- Tracking Changes in Worksheets
- Protecting Worksheets
- Preparing and Saving Workbooks for the Web
Custom- Topical
Book: Microsoft® Office Excel 2007 Step by Step
Please contact us for a custom/topical session in Microsoft® Office Excel 2007.
Questions?
If the topic you desire is not listed in the information above, please send a request for additional information regarding your training needs by using the Contact form located here.
