{"@id":"https://credentialengineregistry.org/resources/ce-a78aaab8-b240-4996-add8-c3beb6cb0327","@type":"ceterms:Certificate","@context":"https://credreg.net/ctdl/schema/context/json","ceterms:ctid":"ce-a78aaab8-b240-4996-add8-c3beb6cb0327","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":"To enroll in this course, you should be proficient in keyboarding, have a basic understanding of a word-processing computer program, and be comfortable using a personal computer. You should also be familiar with operating Microsoft Office software and have a command of English grammar and punctuation. No payroll or office work experience is required."},"ceterms:targetCompetency":[{"@type":"ceterms:CredentialAlignmentObject","ceterms:targetNodeName":{"en-US":"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"}}]}],"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":"12390"},{"@type":"ceterms:IdentifierValue","ceterms:identifierTypeName":{"en-US":"WIOA Funded - No"},"ceterms:identifierValueCode":"1 - Adams County Workforce \u0026 Business Center"},{"@type":"ceterms:IdentifierValue","ceterms:identifierType":"colorado:ETPL_WIOA_Funding","ceterms:identifierTypeName":{"en-US":"WIOA Funded - No"},"ceterms:identifierValueCode":"1 - Adams County Workforce \u0026 Business Center"},{"@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":"3 - Broomfield Workforce Center"},{"@type":"ceterms:IdentifierValue","ceterms:identifierType":"colorado:ETPL_WIOA_Funding","ceterms:identifierTypeName":{"en-US":"WIOA Funded - No"},"ceterms:identifierValueCode":"4 - \"Denver Workforce Center - Office of Economic Development, Divison of Workforce Development\""},{"@type":"ceterms:IdentifierValue","ceterms:identifierType":"colorado:ETPL_WIOA_Funding","ceterms:identifierTypeName":{"en-US":"WIOA Funded - No"},"ceterms:identifierValueCode":"5 - Larimer County Workforce Center"},{"@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":"7 - Jefferson County Workforce Center"},{"@type":"ceterms:IdentifierValue","ceterms:identifierType":"colorado:ETPL_WIOA_Funding","ceterms:identifierTypeName":{"en-US":"WIOA Funded - No"},"ceterms:identifierValueCode":"8 - Workforce Boulder County"},{"@type":"ceterms:IdentifierValue","ceterms:identifierType":"colorado:ETPL_WIOA_Funding","ceterms:identifierTypeName":{"en-US":"WIOA Funded - No"},"ceterms:identifierValueCode":"9 - Pikes Peak Workforce Center"},{"@type":"ceterms:IdentifierValue","ceterms:identifierType":"colorado:ETPL_WIOA_Funding","ceterms:identifierTypeName":{"en-US":"WIOA Funded - No"},"ceterms:identifierValueCode":"10 - Mesa County Workforce Center"},{"@type":"ceterms:IdentifierValue","ceterms:identifierType":"colorado:ETPL_WIOA_Funding","ceterms:identifierTypeName":{"en-US":"WIOA Funded - No"},"ceterms:identifierValueCode":"11 - Pueblo Workforce Center"},{"@type":"ceterms:IdentifierValue","ceterms:identifierType":"colorado:ETPL_WIOA_Funding","ceterms:identifierTypeName":{"en-US":"WIOA Funded - No"},"ceterms:identifierValueCode":"12 - Mountain - Rural Resort"},{"@type":"ceterms:IdentifierValue","ceterms:identifierType":"colorado:ETPL_WIOA_Funding","ceterms:identifierTypeName":{"en-US":"WIOA Funded - No"},"ceterms:identifierValueCode":"13 - Northwest Region - Colorado Rural Workforce Consortium"},{"@type":"ceterms:IdentifierValue","ceterms:identifierType":"colorado:ETPL_WIOA_Funding","ceterms:identifierTypeName":{"en-US":"WIOA Funded - No"},"ceterms:identifierValueCode":"14 - Upper Arkansas Region - Colorado Rural Workforce Consortium"},{"@type":"ceterms:IdentifierValue","ceterms:identifierType":"colorado:ETPL_WIOA_Funding","ceterms:identifierTypeName":{"en-US":"WIOA Funded - No"},"ceterms:identifierValueCode":"15 - Southwest Region - Colorado Rural Workforce Consortium"},{"@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":"17 - Southeast 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"},{"@type":"ceterms:IdentifierValue","ceterms:identifierType":"colorado:ETPL_WIOA_Funding","ceterms:identifierTypeName":{"en-US":"WIOA Funded - No"},"ceterms:identifierValueCode":"19 - Southcentral 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":"Payroll professionals have to navigate financial laws and data to do their job efficiently. This online course covers all critical areas of payroll management and teaches you advanced practices for using Microsoft's Excel software. You will be prepared to take the Fundamental Payroll Certification exam and the Microsoft Office Specialist (MOS) Expert certification exam for Microsoft Excel. Key topics include the major components of the Fair Labor Standards Act of 1938, the Internal Revenue Code and major parts of the state labor code for your chosen state."},"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:audienceLevelType":[{"@type":"ceterms:CredentialAlignmentObject","ceterms:framework":"https://credreg.net/ctdl/terms/AudienceLevel","ceterms:targetNode":"audLevel:PostSecondaryLevel","ceterms:frameworkName":{"en-US":"Audience Level"},"ceterms:targetNodeName":{"en-US":"Post-Secondary Level"},"ceterms:targetNodeDescription":{"en-US":"Intended for those who have completed secondary level school programs or equivalent."}}],"ceterms:estimatedDuration":[{"@type":"ceterms:DurationProfile","ceterms:exactDuration":"PT170H"}],"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:OnlineOnly","ceterms:frameworkName":{"en-US":"Delivery Type"},"ceterms:targetNodeName":{"en-US":"Online Only"},"ceterms:targetNodeDescription":{"en-US":"Delivery is only via the Internet."}}],"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."}}]}