{"@id":"https://credentialengineregistry.org/resources/ce-aa9ffe06-1c2d-4622-8e58-aede41d1ed23","@type":"ceterms:Certification","@context":"https://credreg.net/ctdl/schema/context/json","ceterms:ctid":"ce-aa9ffe06-1c2d-4622-8e58-aede41d1ed23","ceterms:name":{"en-US":"Excel (Online) - Certification - Microsoft Office Specialist Certification - Excel"},"ceterms:ownedBy":["https://credentialengineregistry.org/resources/ce-e9730370-16c0-4ecc-a4b1-a8b949932d11"],"ceterms:requires":[{"@type":"ceterms:ConditionProfile","ceterms:targetLearningOpportunity":["https://credentialengineregistry.org/resources/ce-20ecc944-1e09-4258-a792-e99c362c5a6f"]}],"ceterms:inLanguage":["en-US"],"ceterms:availableAt":[{"@type":"ceterms:Place","ceterms:postalCode":"07470","ceterms:addressRegion":{"en-US":"New Jersey"},"ceterms:streetAddress":{"en-US":"1800 Valley Road"},"ceterms:addressLocality":{"en-US":"Wayne"},"ceterms:targetContactPoint":[{"@type":"ceterms:ContactPoint","ceterms:name":{"en-US":"Kevin Goskowski"},"ceterms:email":["goskowskik@wpunj.edu"],"ceterms:telephone":["(973) 720-2732"],"ceterms:contactType":{"en-US":"CPE Admin"}}]}],"ceterms:description":{"en-US":"This program prepares students for the Microsoft Excel Specialist Certification Exam, but does not include the cost to take the exam (150$).\n\nExcel is the most widely used spreadsheet application in business today.  Learn more advanced functions and how features in the Data Tab can help you with data analysis, financial analysis and making business decisions.  Our Hybrid course integrates the best features of classroom instruction with online activities that compliment and reinforce the material.\n\nCourse topics include the following:\n\n1. Advanced Functions\n\nLogical Functions; IF, AND, OR Lookup Functions: VLOOKUP, HLOOKUP, LOOKUP Creating Nested Functions Cross-worksheet calculations\n2. Tables and PivotTables\n\nSelections and Filtering Calculated field options Power Pivot and Managing a Data Model\n3. Presenting Data Visually\n\nConditional Formatting Charts SmartArt PivotCharts Slicer Timeline\n4. Working with External Data\n\nImporting Text Web Queries Linking Excel data to other Office documents Connecting to a Database\n5. Productivity and Customization\n\nWorking with Templates Creating and applying Macros\n6. Data Tools and Analysis\n\nSorting, Filtering and custom sequences Performing calculations on filtered data Data Validation Goal Seek Scenario Manager"},"ceterms:estimatedCost":[{"@type":"ceterms:CostProfile","ceterms:name":{"en-US":"Total Cost"},"ceterms:price":450.0,"ceterms:currency":"USD","ceterms:costDetails":"https://wpunj.edu/caps/","ceterms:description":{"en-US":"Estimated cost of credential learning opportunity or assessment"},"ceterms:directCostType":{"@type":"ceterms:CredentialAlignmentObject","ceterms:framework":"https://credreg.net/ctdl/terms/CostType","ceterms:targetNode":"costType:AggregateCost","ceterms:frameworkName":{"en-US":"Cost Type"},"ceterms:targetNodeName":{"en-US":"Aggregate Cost"},"ceterms:targetNodeDescription":{"en-US":"Sum of direct costs."}}},{"@type":"ceterms:CostProfile","ceterms:name":{"en-US":"Tuition"},"ceterms:price":450.0,"ceterms:currency":"USD","ceterms:costDetails":"https://wpunj.edu/caps/","ceterms:description":{"en-US":"Tuition cost for the credential"},"ceterms:directCostType":{"@type":"ceterms:CredentialAlignmentObject","ceterms:framework":"https://credreg.net/ctdl/terms/CostType","ceterms:targetNode":"costType:Tuition","ceterms:frameworkName":{"en-US":"Cost Type"},"ceterms:targetNodeName":{"en-US":"Tuition"},"ceterms:targetNodeDescription":{"en-US":"Cost for teaching and instruction."}}},{"@type":"ceterms:CostProfile","ceterms:name":{"en-US":"Fees"},"ceterms:price":0.0,"ceterms:currency":"USD","ceterms:costDetails":"https://wpunj.edu/caps/","ceterms:description":{"en-US":"Fees associated with the credential"},"ceterms:directCostType":{"@type":"ceterms:CredentialAlignmentObject","ceterms:framework":"https://credreg.net/ctdl/terms/CostType","ceterms:targetNode":"costType:MixedFees","ceterms:frameworkName":{"en-US":"Cost Type"},"ceterms:targetNodeName":{"en-US":"Mixed Fees"},"ceterms:targetNodeDescription":{"en-US":"The sum of fees that are not identified individually."}}},{"@type":"ceterms:CostProfile","ceterms:name":{"en-US":"Books and Materials"},"ceterms:price":0.0,"ceterms:currency":"USD","ceterms:costDetails":"https://wpunj.edu/caps/","ceterms:description":{"en-US":"Cost of books and materials for the credential"},"ceterms:directCostType":{"@type":"ceterms:CredentialAlignmentObject","ceterms:framework":"https://credreg.net/ctdl/terms/CostType","ceterms:targetNode":"costType:LearningResource","ceterms:frameworkName":{"en-US":"Cost Type"},"ceterms:targetNodeName":{"en-US":"Learning Resource"},"ceterms:targetNodeDescription":{"en-US":"Cost for one or more learning resources."}}},{"@type":"ceterms:CostProfile","ceterms:name":{"en-US":"Supplies"},"ceterms:price":0.0,"ceterms:currency":"USD","ceterms:costDetails":"https://wpunj.edu/caps/","ceterms:description":{"en-US":"Cost of supplies for the credential"},"ceterms:directCostType":{"@type":"ceterms:CredentialAlignmentObject","ceterms:framework":"https://credreg.net/ctdl/terms/CostType","ceterms:targetNode":"costType:TechnologyFee","ceterms:frameworkName":{"en-US":"Cost Type"},"ceterms:targetNodeName":{"en-US":"Technology Fee"},"ceterms:targetNodeDescription":{"en-US":"Cost for accessing technologies related to the learning opportunity or activity."}}},{"@type":"ceterms:CostProfile","ceterms:name":{"en-US":"Miscellaneous"},"ceterms:price":0.0,"ceterms:currency":"USD","ceterms:costDetails":"https://wpunj.edu/caps/","ceterms:description":{"en-US":"Miscellaneous costs for the credential"},"ceterms:directCostType":{"@type":"ceterms:CredentialAlignmentObject","ceterms:framework":"https://credreg.net/ctdl/terms/CostType","ceterms:targetNode":"costType:ProgramSpecificFee","ceterms:frameworkName":{"en-US":"Cost Type"},"ceterms:targetNodeName":{"en-US":"Program Specific Fee"},"ceterms:targetNodeDescription":{"en-US":"Additional cost for participation with a specific program or course of study such as engineering, business, and nursing."}}}],"ceterms:isRequiredFor":[{"@type":"ceterms:ConditionProfile","ceterms:name":{"en-US":"Certificate of Completion"}}],"ceterms:occupationType":[{"@type":"ceterms:CredentialAlignmentObject","ceterms:framework":"https://www.onetcenter.org/taxonomy.html","ceterms:targetNode":"https://www.onetonline.org/link/summary/13-2011.00","ceterms:codedNotation":"13-2011.00","ceterms:frameworkName":{"en-US":"Standard Occupational Classification"},"ceterms:targetNodeName":{"en-US":"Accountants and Auditors"},"ceterms:targetNodeDescription":{"en-US":"Examine, analyze, and interpret accounting records to prepare financial statements, give advice, or audit and evaluate statements prepared by others. Install or advise on systems of recording costs or other financial and budgetary data."}}],"ceterms:subjectWebpage":"https://wpunj.edu/caps/","ceterms:isPreparationFor":[{"@type":"ceterms:ConditionProfile","ceterms:name":{"en-US":"Data not collected"}},{"@type":"ceterms:ConditionProfile","ceterms:name":{"en-US":"Microsoft Office Specialist Certification - Excel"}}],"ceterms:estimatedDuration":[{"@type":"ceterms:DurationProfile","ceterms:description":{"en-US":"This is about how long it takes to earn this credential"},"ceterms:timeRequired":"PT20H","ceterms:exactDuration":"PT20H"}],"ceterms:hasSupportService":["https://credentialengineregistry.org/resources/ce-ce82de9c-b77c-43ec-8755-bb61e0e6837b"],"ceterms:credentialStatusType":{"@type":"ceterms:CredentialAlignmentObject","ceterms:framework":"https://credreg.net/ctdl/terms/CredentialStatus","ceterms:targetNode":"credentialStat:Active","ceterms:frameworkName":{"en-US":"Credential Status"},"ceterms:targetNodeName":{"en-US":"Active"},"ceterms:targetNodeDescription":{"en-US":"Awards of the credential are ongoing."}},"ceterms:learningDeliveryType":[{"@type":"ceterms:CredentialAlignmentObject","ceterms:framework":"https://credreg.net/ctdl/terms/Delivery","ceterms:targetNode":"deliveryType:BlendedDelivery","ceterms:frameworkName":{"en-US":"Delivery Type"},"ceterms:targetNodeName":{"en-US":"Blended Delivery"},"ceterms:targetNodeDescription":{"en-US":"Delivery includes significant levels of both in person and online."}}],"ceterms:instructionalProgramType":[{"@type":"ceterms:CredentialAlignmentObject","ceterms:framework":"https://nces.ed.gov/ipeds/cipcode/Default.aspx?y=56","ceterms:targetNode":"https://nces.ed.gov/ipeds/cipcode/cipdetail.aspx?y=56\u0026cip=52.0407","ceterms:codedNotation":"52.0407","ceterms:frameworkName":{"en-US":"Classification of Instructional Programs"},"ceterms:targetNodeName":{"en-US":"Business/Office Automation/Technology/Data Entry."},"ceterms:targetNodeDescription":{"en-US":"A program that prepares individuals to support business information operations by using computer equipment to enter, process, and retrieve data for a wide variety of administrative purposes.  Includes instruction in using basic business software and hardware, business computer networking, principles of desktop publishing, preparing mass mailings, compiling and editing spreadsheets, list maintenance, preparing tables and graphs, receipt control, and preparing business performance reports."}}]}