Microsoft Excel 2007 Class 2
| Duration: | 1 day (7 hours) |
| Prerequisite: | Excel Introduction or equivalent experience. |
| Course Materials: | Course manual with CD containing exercises |
| 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: | You will learn about how functions are structured and how to create them for dealing with all kinds of information. You'll also learn how to search, sort, and filter large amounts of information by using tables. This class also introduces you to charts so you can graphically represent information in a visually-engaging way. Lastly, you will learn to use one of the most popular and used function in Excel—the IF function. |
Understanding Functions
- Working with Summary Functions
- Syntax
- Working with the Insert Function Dialog Box
- Function Argument
- Function Description
Basic Financial Functions
- 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
Creating Basic Charts
- Charting 101
- Basic Tasks with Charts
- Practical Charting
- Chart Types
- Chart Styles and Layouts
- Adding Chart Elements
- Selecting Chart Elements
- Formatting Chart Elements
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