Credential(s) Offered
Measurable Skill Gain Leading to Employment
Method of Delivery
Online, e-learning, or distance learning
When offered
Daytime Hours
Instructional Program (CIP)
Description
In this class you will learn advanced Excel formulas and functions to bring your spreadsheets to the next level. Learn how to develop more complex formulas and learn the power of arrays. Learn formulas to help you automate your spreadsheets to simplify them for others to use, as well as yourself.
Prerequisites
An understanding of Excel Intermediate and Advanced topics including basic formulas, IF Statements and basic Lookup formulas. This is an intense one-day course covering functions and formulas.
Course Outline
Lesson 1: Logical & Information Functions
- Nesting IF Statements
- Nesting IF + AND functions
- Complex IF functions
Lesson 2: Text Functions
- Find and length function
- Concatenate
- Search, length and hyperlinks
Lesson 3: Additional Functions
- IS and Blank functions – COUNTBLANK, ISTEXT, ISODD, ISBLANK
- Array functions – TRANSPOSE and SUM and IF
- Formatting Functions
Lesson 4: Lookups
- VLOOKUP
- HLOOKUP
Lesson 5: Dynamic Drop-down Lists
- VLOOKUP drop-down lists
- IF and VLOOKUP
- IF and concatenate
- INDIRECT/VLOOKUP
- OFFSET drop-down lists
- Offset, indirect and CountA functions
Lesson 6: Filtered Columns
- ISTEXT and ROW
- SMALL
- INDEX and IFERROR
- ARRAY
- Normal validation list
- Removing blanks in the dropdown list
- ROW, COUNTBLANK and OFFSET
Details
Program Length (Weeks)
1
Hours
8
Entrance Requirements
None
School
WIOA Approved Program
Yes
Training Location(s)
21 Gregory Drive, #3, South Burlington, Vermont
Local WIB
00 - Vermont Workforce Investment Area
Name of Credential
Excel Skills
Type of financial aid offered or have access to
Eligible for WIOA funds.
Refund Policy
Notify us five or more business days before your class to do so without penalty. Cancellations made less than five days before your class will incur a $50 cancellation fee. Cancellations made less than 24 hours before the class starting time will incur a cancellation fee equal to the cost of the class. You may register to take the class for free the next time it runs.
Is the proposed curriculum currently certified by an accrediting agency or similar national standardization program?
No
Is this proposed curriculum considered a nontraditional program of training services for women?
No
Is this proposed curriculum considered a nontraditional program of training services for men?
No
Cost Items
In-State Tuition
$325.00
Total In-State Program Cost
$325.00
