{"@id":"https://credentialengineregistry.org/resources/ce-0f420f3b-1ea2-4cb6-8837-8d63743c281d","@type":"ceterms:Certificate","@context":"https://credreg.net/ctdl/schema/context/json","ceterms:ctid":"ce-0f420f3b-1ea2-4cb6-8837-8d63743c281d","ceterms:name":{"en-US":"Payroll Practice and Management with Microsoft Excel"},"ceterms:ownedBy":["https://credentialengineregistry.org/resources/ce-6765e17b-6c18-49ff-af7a-6e14b85ef2c9"],"ceterms:requires":[{"@type":"ceterms:ConditionProfile","ceterms:name":{"en-US":"Entry Conditions"},"ceterms:creditValue":[{"@type":"ceterms:ValueProfile","schema:value":170.0,"ceterms:creditUnitType":[{"@type":"ceterms:CredentialAlignmentObject","ceterms:framework":"https://credreg.net/ctdl/terms/CreditUnit","ceterms:targetNode":"creditUnit:ContactHour","ceterms:frameworkName":{"en-US":"Credit Unit"},"ceterms:targetNodeName":{"en-US":"Contact Hour"},"ceterms:targetNodeDescription":{"en-US":"Credit that is issued or accepted as being related to one or more temporal hours of instruction presented to students."}}]}],"ceterms:description":{"en-US":"No preqrequisites, but these skills are expected"},"ceterms:targetCompetency":[{"@type":"ceterms:CredentialAlignmentObject","ceterms:targetNodeName":{"en-US":"What you will learn    Identify various laws and regulations that affect employers in their payroll operations  Identify the various deductions, both voluntary and involuntary, that are taken out of employees' gross pay  Calculate gross and net pay  Explain the use of the forms required to withhold, deposit, and report federal income taxes  Recognize dates and regulations to ensure payroll compliance and reporting  Understand the payroll process and supporting systems and administration  Correctly apply payroll policies and procedures of a payroll department  Journalize payroll transactions and post to appropriate general ledger accounts  Be able to process payroll from start to finish (payroll project)  To create, modify, and manage Excel workbooks  To use formulas, functions and work with tables  To convert, sort, filter, and manage lists  To use conditional formatting and styles  To create pivot tables and charts  To import and export data  How you will benefit    Be prepared to pass the FPC exam and become certified in the fundamentals of payroll  Having a certification in payroll is a desirable attribute that many employers seek in payroll candidates  With certification comes additional knowledge and skill that is not often taught in the workplace  Be able to search and apply for payroll jobs, with the additional resume skills learned in the course  Become a certified Microsoft Office Specialist (MOS) Expert in Excel  Use these skills in most workplace situations  Manipulate data faster by learning helpful formulas and tricks"}}]}],"ceterms:offeredBy":["https://credentialengineregistry.org/resources/ce-6765e17b-6c18-49ff-af7a-6e14b85ef2c9"],"ceterms:identifier":[{"@type":"ceterms:IdentifierValue","ceterms:identifierTypeName":{"en-US":"Program_System_ID"},"ceterms:identifierValueCode":"12375"},{"@type":"ceterms:IdentifierValue","ceterms:identifierTypeName":{"en-US":"WIOA Funded - No"},"ceterms:identifierValueCode":"2 - Arapahoe/Douglas Works!"},{"@type":"ceterms:IdentifierValue","ceterms:identifierType":"colorado:ETPL_WIOA_Funding","ceterms:identifierTypeName":{"en-US":"WIOA Funded - No"},"ceterms:identifierValueCode":"2 - Arapahoe/Douglas Works!"},{"@type":"ceterms:IdentifierValue","ceterms:identifierType":"colorado:ETPL_WIOA_Funding","ceterms:identifierTypeName":{"en-US":"WIOA Funded - No"},"ceterms:identifierValueCode":"6 - Employment Service-Weld County"},{"@type":"ceterms:IdentifierValue","ceterms:identifierType":"colorado:ETPL_WIOA_Funding","ceterms:identifierTypeName":{"en-US":"WIOA Funded - No"},"ceterms:identifierValueCode":"16 - Western Region - Colorado Rural Workforce Consortium"},{"@type":"ceterms:IdentifierValue","ceterms:identifierType":"colorado:ETPL_WIOA_Funding","ceterms:identifierTypeName":{"en-US":"WIOA Funded - No"},"ceterms:identifierValueCode":"18 - Eastern Region - Colorado Rural Workforce Consortium"}],"ceterms:inLanguage":["en"],"ceterms:availableAt":[{"@type":"ceterms:Place","ceterms:name":{"en-US":"Primary Address"},"ceterms:latitude":40.40864740000001,"ceterms:longitude":-104.7664374,"ceterms:postalCode":"80634","ceterms:addressRegion":{"en-US":"Colorado"},"ceterms:streetAddress":{"en-US":"5401 West 20th, Attn: CWDI"},"ceterms:addressCountry":{"en-US":"United States"},"ceterms:addressLocality":{"en-US":"Greeley"}},{"@type":"ceterms:Place","ceterms:name":{"en-US":"Aims Community College - Main Location"},"ceterms:latitude":40.40864740000001,"ceterms:longitude":-104.7664374,"ceterms:postalCode":"80634","ceterms:addressRegion":{"en-US":"Colorado"},"ceterms:streetAddress":{"en-US":"5401 W. 20 Street, GH#1"},"ceterms:addressCountry":{"en-US":"United States"},"ceterms:addressLocality":{"en-US":"Greeley"}},{"@type":"ceterms:Place","ceterms:name":{"en-US":"Aims Community College - Loveland"},"ceterms:latitude":40.3952533,"ceterms:longitude":-105.0756976,"ceterms:postalCode":"80537","ceterms:addressRegion":{"en-US":"Colorado"},"ceterms:streetAddress":{"en-US":"104 E 4th Street"},"ceterms:addressCountry":{"en-US":"United States"},"ceterms:addressLocality":{"en-US":"Loveland"}}],"ceterms:description":{"en-US":"This is one of the offerings at our community college, the name details the course."},"ceterms:estimatedCost":[{"@type":"ceterms:CostProfile","ceterms:name":{"en-US":"Cost Profile"},"ceterms:price":2295.0,"ceterms:currency":"US Dollar","ceterms:costDetails":"https://www.aims.edu","ceterms:description":{"en-US":"This is the summary of the costs associated with this 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":"Cost Profile"},"ceterms:price":2295.0,"ceterms:currency":"US Dollar","ceterms:costDetails":"https://www.aims.edu","ceterms:description":{"en-US":"This is the summary of the costs associated with this credential."},"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."}}}],"ceterms:occupationType":[{"@type":"ceterms:CredentialAlignmentObject","ceterms:framework":"https://www.onetcenter.org/taxonomy.html","ceterms:targetNode":"https://www.onetonline.org/link/summary/11-3031.01","ceterms:codedNotation":"11-3031.01","ceterms:frameworkName":{"en-US":"Standard Occupational Classification"},"ceterms:targetNodeName":{"en-US":"Treasurers and Controllers"},"ceterms:targetNodeDescription":{"en-US":"Direct financial activities, such as planning, procurement, and investments for all or part of an organization."}},{"@type":"ceterms:CredentialAlignmentObject","ceterms:framework":"https://www.onetcenter.org/taxonomy.html","ceterms:targetNode":"https://www.onetonline.org/link/summary/11-3031.02","ceterms:codedNotation":"11-3031.02","ceterms:frameworkName":{"en-US":"Standard Occupational Classification"},"ceterms:targetNodeName":{"en-US":"Financial Managers, Branch or Department"},"ceterms:targetNodeDescription":{"en-US":"Direct and coordinate financial activities of workers in a branch, office, or department of an establishment, such as branch bank, brokerage firm, risk and insurance department, or credit department."}},{"@type":"ceterms:CredentialAlignmentObject","ceterms:framework":"https://www.onetcenter.org/taxonomy.html","ceterms:targetNode":"https://www.onetonline.org/link/summary/13-2011.01","ceterms:codedNotation":"13-2011.01","ceterms:frameworkName":{"en-US":"Standard Occupational Classification"},"ceterms:targetNodeName":{"en-US":"Accountants"},"ceterms:targetNodeDescription":{"en-US":"Analyze financial information and prepare financial reports to determine or maintain record of assets, liabilities, profit and loss, tax liability, or other financial activities within an organization."}},{"@type":"ceterms:CredentialAlignmentObject","ceterms:framework":"https://www.onetcenter.org/taxonomy.html","ceterms:targetNode":"https://www.onetonline.org/link/summary/13-2011.02","ceterms:codedNotation":"13-2011.02","ceterms:frameworkName":{"en-US":"Standard Occupational Classification"},"ceterms:targetNodeName":{"en-US":"Auditors"},"ceterms:targetNodeDescription":{"en-US":"Examine and analyze accounting records to determine financial status of establishment and prepare financial reports concerning operating procedures."}},{"@type":"ceterms:CredentialAlignmentObject","ceterms:framework":"https://www.onetcenter.org/taxonomy.html","ceterms:targetNode":"https://www.onetonline.org/link/summary/13-2051.00","ceterms:codedNotation":"13-2051.00","ceterms:frameworkName":{"en-US":"Standard Occupational Classification"},"ceterms:targetNodeName":{"en-US":"Financial and Investment Analysts"},"ceterms:targetNodeDescription":{"en-US":"Conduct quantitative analyses of information involving investment programs or financial data of public or private institutions, including valuation of businesses."}}],"ceterms:subjectWebpage":"https://www.aims.edu","ceterms:estimatedDuration":[{"@type":"ceterms:DurationProfile","ceterms:exactDuration":"P12M"}],"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:VariableSite","ceterms:frameworkName":{"en-US":"Delivery Type"},"ceterms:targetNodeName":{"en-US":"Variable Site"},"ceterms:targetNodeDescription":{"en-US":"Delivery is not tied to a specific site."}}],"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.0305","ceterms:codedNotation":"52.0305","ceterms:frameworkName":{"en-US":"Classification of Instructional Programs"},"ceterms:targetNodeName":{"en-US":"Accounting and Business/Management"},"ceterms:targetNodeDescription":{"en-US":"An integrated or combined program in accounting and business administration/management that prepares individuals to function as accountants and business managers."}}]}