Official Site Of The State Of New JerseyMicrosoft Excel-Level III
ManageAssist, Inc.
Consumer report card
DescriptionAbout this Learning Opportunity
This course presents the advanced concepts of Microsoft Excel software. Participants may request additional topics to cover during the class. Manuals are provided with exercises to facilitate learning.
The following topics are included:
Protecting Worksheets
Advanced Calculations: 3-D calculations across several worksheets; Time and Date Functions, Date calculations; Math functions: Sumif, Mina, Countif; Rounding functions
Using Lookup and Reference functions such as Vlookup
Logic Functions: The If function
Text Functions: Proper and Concatenate functions (changing case of text, and joining two strings of text together)
Advanced Financial Functions such as IRR and NPV, XIRR and XNPV
Advanced Filtering
Conditional Formatting
Tables
Analyzing data: using Trend lines and Goal Solver
Pivot Tables
Auditing: Finding errors in worksheets
Creating Charts
Upon completion of this course participants will be able to master the advanced concepts in Microsofts Excel spreadsheet software. This course could be customized to accomplish a companys specific requirements.
Quick FactsDetails about this Learning Opportunity
CostDetailed cost breakdown of the Learning Opportunity
| Total Cost | $0 |
|---|---|
| Tuition | $0 |
| Fees | $0 |
| Books & Materials | $0 |
| Supplies & Tools | $0 |
| Other | $0 |
Location and Contact DetailsGeographic and contact information for this Learning Opportunity
ManageAssist, Inc.
1 Bethany Road
Bldg 3, Suite 48
Hazlet, NJ 07730
Jonathan Stotler
Managing Director
(732) 888-0245
Instructional ProgramsType of material covered by the Learning Opportunity
Associated Occupations and IndustriesExplore the occupations below to learn more
Support ServicesSupport services provided for the Learning Opportunity
Offerings subject to change – contact the provider to verify these services are still available
How to get fundingYou may be eligible for funding for certain training opportunities
New Jersey residents who meet eligibility criteria can receive funding to train for the following in-demand occupations: In-Demand Occupations List For more details about tuition assistance and to apply, visit the
One Stop Career Centersor learn more about
Tuition AssistanceDescriptionAbout this Learning Opportunity
This course presents the advanced concepts of Microsoft Excel software. Participants may request additional topics to cover during the class. Manuals are provided with exercises to facilitate learning.
The following topics are included:
Protecting Worksheets
Advanced Calculations: 3-D calculations across several worksheets; Time and Date Functions, Date calculations; Math functions: Sumif, Mina, Countif; Rounding functions
Using Lookup and Reference functions such as Vlookup
Logic Functions: The If function
Text Functions: Proper and Concatenate functions (changing case of text, and joining two strings of text together)
Advanced Financial Functions such as IRR and NPV, XIRR and XNPV
Advanced Filtering
Conditional Formatting
Tables
Analyzing data: using Trend lines and Goal Solver
Pivot Tables
Auditing: Finding errors in worksheets
Creating Charts
Upon completion of this course participants will be able to master the advanced concepts in Microsofts Excel spreadsheet software. This course could be customized to accomplish a companys specific requirements.
Quick FactsDetails about this Learning Opportunity
Instructional ProgramsType of material covered by the Learning Opportunity
Associated Occupations and IndustriesExplore the occupations below to learn more
How to get fundingYou may be eligible for funding for certain training opportunities
New Jersey residents who meet eligibility criteria can receive funding to train for the following in-demand occupations: In-Demand Occupations List For more details about tuition assistance and to apply, visit the
One Stop Career Centersor learn more about
Tuition AssistanceCostDetailed cost breakdown of the Learning Opportunity
| Total Cost | $0 |
|---|---|
| Tuition | $0 |
| Fees | $0 |
| Books & Materials | $0 |
| Supplies & Tools | $0 |
| Other | $0 |
Location and Contact DetailsGeographic and contact information for this Learning Opportunity
ManageAssist, Inc.
1 Bethany Road
Bldg 3, Suite 48
Hazlet, NJ 07730
Jonathan Stotler
Managing Director
(732) 888-0245
Support ServicesSupport services provided for the Learning Opportunity
Offerings subject to change – contact the provider to verify these services are still available