Microsoft Excel 2007 Level 2
| Duration: | 1 day |
| Prerequisite: | Excel Introduction or equivalent experience. |
| Course Materials: | Course manual with CD containing exercises, 160 pages |
| Prices: | $195 for 1 student (one-on-one training) $160 each for 2 to 3 students $130 each for 4 to 6 students $130 for the first 6 students, $100 for each additional student |
| Description: | This class covers the intermediate concepts of Microsoft Excel 2007 with managing workbooks, automating tasks, using and analyzing list data, enhancing charts and worksheets, and working with Excel and the Internet. The manual is recognized as a Microsoft Approved Study Guide for the Microsoft Office Specialist Program Certification Exam. The manual is also a great reference for after the class. |
Math, Statistical, and Financial Functions
Rounding Numbers
Groups of Numbers
Future Value
Present Value
Calculating the Number of Payments You Need to Make
Tables: List Management Made Easy
The Basics of Tables
Sorting and Filtering a Table
Dealing with Duplicate Rows
Performing Table Calculations
Grouping and Outlining Data
Basic Data Grouping
Grouping Timesavers
Creating Basic Charts
Charting 101
Basic Tasks with Charts
Practical Charting
Chart Types
Formatting and Perfecting Charts
Chart Styles and Layouts
Adding Chart Elements
Selecting Chart Elements
Formatting Chart Elements
Improving Your Charts
Advanced Charting
Manipulating Dates, Times, and Text
Manipulating Text
Manipulating Dates and Times
Math with Dates and Times
Date and Time Functions
Advanced Formula Writing and Troubleshooting
Conditions in Formulas
Descriptive Names for Cell References
Solving Formula Errors
The Anatomy of the IF Function
IF Function Description
Nesting an IF Function
Multiple Nested Conditions and Multiple Return Values
Nesting Other Functions in an IF Function
Templates
Understanding Templates
Creating a New Workbook from a Template
Creating Templates