The Essentials of Microsoft Excel 2003 Formulas and Functions: Class 1
| Duration: | 1 day |
| Prerequisite: | This class is not for absolute Excel beginners. You should be familiar with the Excel environment and know the basics of Excel. |
| Course Materials: | Course manual with CD containing exercises |
| Prices: | $225 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 course focuses on Excel formulas and functions, the heart and soul of Excel. In this first class, after learning the fundamentals, you will learn how to link worksheets, how to work with dates and times, and how to create a variety of basic functions including summary, logical, lookup, and text functions. This class will provide with a solid foundation for learning more powerful formulas. This is the first day of a 3-day Excel Formulas and Functions class. You can choose to take all three days of training or to take just the first class and then continue on your own. You can even cherry-pick topics for a custom class. |
Class Outline
The Fundamentals
- Using Excel Tools
- The Excel Interface
- Smarts Tags
- Drag and Drop
- Keyboard Shortcuts
- Cell Formatting
- Entering and Editing Formulas
- Formula Elements
- Entering a Formula
- Pasting Names
- Editing Formulas
- Using Operators in Formulas
- Reference Operators
- Sample Formulas That Use Operators
- Operator Precedence
- Nested Parentheses
- Calculating Formulas
- Cell and Range References
- Creating an Absolute or a Mixed Reference
- Referencing Other Sheets or Workbooks
- Making an Exact Copy of a Formula
- Converting Formulas to Values
- Student Exercise
Working with Names
- Naming your Cells or Ranges
- A Name’s Scope
- The Name Manager
- Shortcuts for Creating Cell and Range Names
- Working with Range and Cell Names
Using Functions in Your Formulas
- What Is a Function?
- Basic Syntax
- Function Argument Types
- Ways to Enter a Function into a Formula
- Function Categories
How Excel Handles Dates and Times
- Understanding Date Serial Numbers
- Entering Dates
- Understanding Time Serial Numbers
- Entering Times
- Formatting Dates and Times
- Problems with Dates
- Using Functions to Display Current Date or Time
- Generating a Series of Dates
Counting, Summing, Averaging, and Finding the Largest or Smallest Value in a Range
- Counting Cells That Contain Numbers
- Counting Nonblank Cells
- Summing Cells in a Range
- Averaging Cells in a Range
- Finding the Largest or Smallest Cell in a Range
Basic Logical Functions
- What is a Logical Test?
- And and OR Functions
- Basic IF Function
- Text and Number Arguments
- Nesting Functions
- Information Functions
Basic Lookup Functions
- What Is a Lookup Formula?
- Basic Lookup Function
- Basic VLOOKUP and HLOOKUP Function
- Looking for an Exact Match
- Looking for an Approximate Match
Introducing Text Functions
- How Excel Handles Text
- Using the LEFT and RIGHT Functions
- Changing the Case of Text
- Joining Two or More Cells