Microsoft Excel 2003 Formulas and Functions Class 2
| Duration: | 1 day |
| Prerequisite: | Microsoft Office Excel 2003 Formulas and Functions Class 1 |
| 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: | This is the second day of our Excel Formulas and Functions course so you should be well-acquainted with the function syntax, operators, and the basics of formulas and functions. In this class, students are introduced to financial and rounding functions. One of the most important and useful Excel function is the IF function, which we thoroughly explore in this class. We also learn more about text, date, and logical functions on an Intermediate level. Finally, we learn about Array formulas. This is the second day of a 3-day Excel Formulas and Functions class. You can choose to take all three days of training or to cherry-pick topics for a custom class. |
Working with Basic Financial Functions
- Financial Concepts
- Financial Function Arguments
- Calculating Present Value
- Calculating Future Value
- Calculating Payments
- Calculating Rates
- Calculating Periods
Rounding Numbers
- Basic Rounding Formulas
- Rounding to the Nearest Multiple
- Rounding Currency Values
- Using the INT and TRUNC Functions
The Anatomy of an IF Function
- The IF Function Description
- Nesting Other Functions within the IF Function
- Using Another Function as the Logical Test in an IF Function
- Creating Multiple Return Values in IF Statements
Manipulating Text
- Removing Excess Spaces and Nonprinting Characters
- Counting Characters in a String
- Finding and Searching within a String
- Extracting Characters from a Strings of Different Lengths
Date-Related and Time-Related Functions
- Displaying Any Date
- Calculating the Number of Days between Two Dates
- Calculating the Number of Work Days between Two Dates
- Calculating the Number of Years between Two Dates
- Calculating a Person’s Age
- Determining the Day of the Year
- Determining the Day of the Week
- Determining the Last Day of a Month
- Displaying Any Time
- Calculating the Difference between Two Times
- Converting from Military Time
- Converting Decimal Hours, Minutes, or Seconds to a Time
- Adding Hours, Minutes, or Seconds to a Time
Advanced Counting and Summing Formulas
- Counting Cells by Using the COUNTIF Function
- Basic Syntax
- Function Argument Types
- Ways to Enter a Function into a Formula
- Function Categories
- Computing a Cumulative Sum
- Conditional Sums Using a Single Criterion
- Summing Values Based on a Text Comparison
- Conditional Sums Using Multiple Criteria
- Using the Subtotal Function
- Using the Subtotal Feature
- Using Database Functions
Introducing Array Formulas
- How Array Formulas Work
- A Multi-cell Array Formula
- A Single-Cell Array Formula
- Creating an Array Constant
- Array Constant Elements
- The FREQUENCY Function