Credential(s) Offered
Industry certification, Secondary school diploma
Method of Delivery
Hybrid or blended
When offered
Daytime Hours
Instructional Program (CIP)
Description
Learn more of the essential features of Microsoft Excel and spreadsheets to create and manage large workbooks, lock and hide rows and columns, print large worksheets, create 3-D formulas and link workbooks together. Find out how to use functions to format text, work with styles and themes, add and delete watermarks, outline and consolidate data, create subtotals, sort and filter data. Table and chart creation will also be covered.
- Audience
- This course is designed for students who already have foundational knowledge and skills in Excel and who wish to begin taking advantage of some of the higher-level functionality in Excel to analyze and present data.
Prerequisites
- Students should have foundational knowledge of the Excel interface and how to enter and manipulate data within worksheets. Some knowledge about basic formulas and visualizations is also helpful.
-
Recommended Courses: - Excel 2021 Level 1
Related Classes
Course Disclaimer
*Course cost listed does not include the cost of courseware. Course to run is subject to a minimum enrollment. Please contact us at learn@vtec.org or 207-775-0244 for additional pricing information, or if you have any questions.
Follow Up
Course Details
- Module 1: Working with Functions
- Work with Ranges
- Use Specialized Functions
- Work with Logical Functions
- Work with Date and Time Functions
- Work with Text Functions
- Module 2: Working with Lists
- Sort Data
- Filter Data
- Query Data with Database Functions
- Outline and Subtotal Data
- Module 3: Analyzing Data
- Create and Modify Tables
- Apply Intermediate Conditional Formatting
- Apply Advanced Conditional Formatting
- Module 4: Visualizing Data with Charts
- Create Charts
- Modify and Format Charts
- Use Advanced Chart Features
- Module 5: Using PivotTables and PivotCharts
- Create a PivotTable
- Analyze PivotTable Data
- Present Data with PivotCharts
- Filter Data by Using Timelines and Slicers
Details
Program Length (Weeks)
1
Hours
7
Entrance Requirements
Combination of Education and Course(s)
School
WIOA Approved Program
Yes
Curriculum Competency Based
Excel Level 2
Training Location(s)
343 Gorham Rd South Portland, ME
Local WIB
4 - Coastal Counties Local Area 4
Type of Attainment:
Postsec. Awards/Cert./Diplomas; <1 yr.
Name of Credential
Excel Level 2
Type of financial aid offered or have access to
N/A
Refund Policy
https://vtec.org/About/Cancellation/
Is the proposed curriculum currently certified by an accrediting agency or similar national standardization program?
Yes - Microsoft
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
Books (Estimated)
$25.65
Testing/Exam Fees
$100.00
In-State/District Tuition
$295.00 Days
Total In-State Program Cost
$420.65
