Description
Duration: 1 day
In this course, you will cover how to: build a formula, use function formulas, work with range names in a
the formula, use Logical and Lookup function formulas, use Financial function formulas, use the Concatenate
function formula, work with the Date, Proper, Upper, and Lower function formulas, create a function formulas
from scratch & work with data tables.
Prerequisites
Excel Level 2 or equivalent knowledge
What’s included?
- Authorized Courseware
- Intensive Hands on Skills Development with an Experienced Subject Matter Expert
- Hands-on practice on real Servers and extended lab support 1.800.482.3172
- Examination Vouchers & Onsite Certification Testing- (excluding Adobe and PMP Boot Camps)
- Academy Code of Honor: Test Pass Guarantee
- Optional: Package for Hotel Accommodations, Lunch and Transportation
With several convenient training delivery methods offered, The Academy makes getting the training you need easy. Whether you prefer to learn in a classroom or an online live learning virtual environment, training videos hosted online, and private group classes hosted at your site. We offer expert instruction to individuals, government agencies, non-profits, and corporations. Our live classes, on-sites, and online training videos all feature certified instructors who teach a detailed curriculum and share their expertise and insights with trainees. No matter how you prefer to receive the training, you can count on The Academy for an engaging and effective learning experience.
Methods
- Instructor Led (the best training format we offer)
- Live Online Classroom – Online Instructor Led
- Self-Paced Video
Speak to an Admissions Representative for complete details
| Start | Finish | Public Price | Public Enroll | Private Price | Private Enroll |
|---|---|---|---|---|---|
| 9/23/2024 | 9/23/2024 | ||||
| 10/14/2024 | 10/14/2024 | ||||
| 11/4/2024 | 11/4/2024 | ||||
| 11/25/2024 | 11/25/2024 | ||||
| 12/16/2024 | 12/16/2024 | ||||
| 1/6/2025 | 1/6/2025 | ||||
| 1/27/2025 | 1/27/2025 | ||||
| 2/17/2025 | 2/17/2025 | ||||
| 3/10/2025 | 3/10/2025 | ||||
| 3/31/2025 | 3/31/2025 | ||||
| 4/21/2025 | 4/21/2025 | ||||
| 5/12/2025 | 5/12/2025 | ||||
| 6/2/2025 | 6/2/2025 | ||||
| 6/23/2025 | 6/23/2025 | ||||
| 7/14/2025 | 7/14/2025 | ||||
| 8/4/2025 | 8/4/2025 | ||||
| 8/25/2025 | 8/25/2025 | ||||
| 9/15/2025 | 9/15/2025 | ||||
| 10/6/2025 | 10/6/2025 | ||||
| 10/27/2025 | 10/27/2025 | ||||
| 11/17/2025 | 11/17/2025 | ||||
| 12/8/2025 | 12/8/2025 | ||||
| 12/29/2025 | 12/29/2025 | ||||
| 1/19/2026 | 1/19/2026 |
Curriculum
Function Formulas
• Review of Building a Formula
• Rules of Algebraic Order
• Function Formulas
• Cell Addressing
• Relative vs. Absolute Cell Addressing
• Review of Range Names
• A Review of Rules in
Advanced Functions
• Logical Functions
• Using IF Statements
• Nested IF Statements
• Lookup Functions
• The VLOOKUP Function
• The HLOOKUP Function
• Financial Functions
• The Payment Function
• Present Value
• Future Value
• Combining Text Fields
• Concatenate
• A Formula for Combining Text Fields
• Date Functions
• How Excel Stores Dates and Times
• DATEDIF Function
• NOW Function
• Addition with Dates
• DATE Function
• Other Function Formulas
• Proper, Upper, Lower Functions
• Proper Function
Advanced Options
• Creating a Function Formula
• Two Types of Macros
• Creating Function Macros
• Procedures
• Addition with Dates
• Using Data Tables
• To Create a One-Input Data Table
• Adding Formulas to Existing Data Tables
• Two-Input Data Table
