Custom Search
Home > Computer > Microsoft Office > Last Minute Training > Computer and IT Certification Seminars > Microsoft Excel 2007 Level 2 Functions and Analysis - English
Provided by: Last Minute Training

Microsoft Excel 2007 Level 2 Functions and Analysis - English

Excel

 Last Minute Training
Training Provided by Last Minute Training Microsoft Excel 2007 Level 2: Functions and Analysis. This course builds on the knowledge gained from the Level 1 course and provides additional training based on that course. We will go over the prerequisites when we start the course, and then proceed to teach topics such as Reviewing Formulas; Understanding Functions; Financial Functions; Logical Functions; Lookup Functions; Date Functions; Statistical Functions; What-if Analysis; and Auditing Formulas. Also, an opportunity will be provided to all participants to use the lab to practicie the topics learned through this course. Participants who complete this course will be able to keep the course materials and will be provided with a certificate of completion.
This is primarily ilt training
Contact Last Minute Training for more information
Course Level:basic
Duration:1 days
Training Presented in:English
Microsoft Excel 2007 Level 2 Functions and Analysis - English Module 0: Prerequisites
|

1. Enter and Edit Data
2. Understand Basic Math
3. Apply Absolute and Relative Referencing
4. Understand the Difference Between a Formulas and a Function
5. Understand the Interface

| Module 1: Reviewing Formulas
|

1. What Is a Formula
2. Review Basic Concepts
3. Displaying Formulas in Cells
4. Reviewing Absolute Referencing
5. Using Mixed Referencing

| Module 2: Understanding Functions
|

1. What Is a Function
2. What Are Arguments
3. Using the Insert Function Dialog Box
4. Entering a Function Manually

| Module 3: Financial Functions
|

1. The Pmt Function
2. Using the Goal Seek
3. The Fv Function
4. The Nper Function

| Module 4: Logical Functions
|

1. Using a Basic If Function
2. Using Nested If Function with And, Or
3. Using If with Multiple Conditions

| Module 5: Lookup Functions
|

1. Using the Vlookup Function
2. Using the Hlookup Function
3. Using the Index Function

| Module 6: Date Functions
|

1. Using the Today Function
2. Calculating Differences Between Dates
3. Using the Workday Function

| Module 7: Statistical Functions
|

1. Using the Countif Function
2. Using the Countifs Function
3. Using Conditional Formatting
4. Using Existing Rules
5. Creating New Rules
6. Managing Rules

| Module 8: What-if Analysis
|

1. Using Scenarios
2. Using Goal Seek
3. Using Data Tables

| Module 9: Auditing Formulas
|

1. Using the Auditing Group

| Module 10: Lab
About The Training Provider: Last Minute Training
Last Minute Training - Last Minute Training Corp. works similar to last minute discounted travel. We sell training seminars at deep discounts on a last minute basis. If you want to save 30 - 60 off high quality training seminars and have the flexibility to attend with only a few days notice check out our website and see if the training you are looking for is on sale. While your there set up and free account...
Home > Computer > Microsoft Office > Last Minute Training > Computer and IT Certification Seminars > Microsoft Excel 2007 Level 2 Functions and Analysis - English
Advertise With Us
Are you a microsoft excel 2007 trainer?
This page was last updated on sb5- 10/10/08 at 14:13:56 - 19:25:39