Courses

Learn the fundamentals of setting up and administering payroll, one of the most important responsibilities of human resources professionals.

Welcome to The Payroll Cycle, the second course in ADP's Entry-level Payroll Specialist Professional Certificate program. This course explores the end-to-end payroll processing cycle, from data collection to net pay. Students will gain insights into the step-by-step process, including time tracking methods, leave management, new hire onboarding tasks, and potential bottlenecks. This is an entry-level course intended for beginner learners interested in learning the fundamentals of payroll, those pursing an entry-level Payroll Specialist role, and more experienced professionals looking to shift their career to purposefully focus on the area of a Payroll Specialist.

The courseware is designed to equip participants with a profound understanding of Payroll and HR Management. Tally is a revolutionary product which has been created with the objectives of Simplify the Simplest, Greater Flexibility and New Look and Feel, and our course also describes the same. This comprehensive course in Payroll and HR Management provides participants with a thorough understanding of the intricacies involved in managing payroll processes and human resources using Tally. The course covers key topics such as - - The fundamental concepts of payroll management and income tax regulations. - Significance of accurate payroll processing in an organizational context. - Configure Payroll feature in Tally. - Learn how to create and manage employee profiles in Tally. - Master the creation and configuration of primary pay heads in Tally. - Understand the various elements such as salary structures, deductions, allowances, and other essential aspects related to payroll. This course is suitable for individuals aspiring to pursue a career in payroll management, human resources, or accounting. Professionals already working in payroll or HR departments who want to enhance their skills using Tally. Business owners or managers responsible for payroll and HR functions within their organizations. Students or graduates seeking practical knowledge in payroll processing and HR management using Tally software.

Welcome to The Payroll Professional, the first course in ADP's Entry-level Payroll Specialist Professional Certificate program. This course will introduce learners to the Payroll Specialist professional certificate program and introduce the role and function of the Payroll Professional. Learners will discover the duties of those who work in the payroll field and the traits that make them successful. Learners will also explore the basics of pay and the components that make up gross and net income. This is an entry-level course intended for beginner learners interested in learning the fundamentals of payroll, those pursing an entry-level Payroll Specialist role, and more experienced professionals looking to shift their career to purposefully focus on the area of a Payroll Professional.

In the Payroll Fundamentals workshop, students will learn what it takes to properly record and distribute payroll as a professional bookkeeper. Taught by QuickBooks Pro Advisors, this class will walk students through the various classifications of employees, best practices for taxes, and recording related payroll expenses properly. Payroll involves a lot of variables to record properly and this class will help you with the job-ready skills to be able to work as a bookkeeper managing payroll today.Classes at DWC are offered in a bootcamp style, moving at an accelerated pace but in small class sizes. Support and mentoring is a part of all programs at DWC to make sure our students achieve the best career outcome possible.This class will start with payroll basics but quickly move into learning about complex payroll scenarios. QuickBooks Payroll is a part of the QuickBooks Bookkeeper Certification and is designed for any students looking to advance an administrative or bookkeeping career with the real-world skills needed to be successful. If you are ready to launch your bookkeeper career forward, contact us today to learn more.ObjectivesUpon successful completion of the Payroll Fundamentals​ workshop, students will be able to:Business entity types and special payroll rulesContractor or Employee or Statutory EmployeeBest practices of fair labor and documenting employee statusCalculate employee federal and state taxesDifferentiate between pre-tax and post-tax deductionsRecord and remit voluntary withholdings such as health insurance, retirement accountsTax filings and penaltiesUnderstand how payroll transactions affect the Income Statement and Balance SheetComprehensive payroll activityPrerequisitesBasic digital literacy including file management is requiredSome experience with accounting vocabulary is helpful but not required.It is recommended that you have access to QuickBooks online before the start of your first class

Effective Bookkeeping and Payroll What you'll learn: Learn about the generally accepted accounting principles (GAAP)Learn and implement internal controlsMaintain subsidiary ledgers and special journalsReconcile accountsCorrect wrong amounts and wrong accounts by reverse entriesPerform sales tax calculationsSetup a yearly budgeting planUnderstand accounting for merchandisingPerform accounting for cashManage payroll system The Bookkeeping and Payroll course prepares the candidates to become successful bookkeepers and acquire the necessary knowledge and understanding needed to create an effective and reliable bookkeeping system. The course gives the fresh graduates and inexperienced professionals a career boost and enhances their accounting and bookkeeping skills. The course helps the candidates to prove to employers that they can provide office accounting, bookkeeping and payroll management duties in an effective and efficient manner.A bookkeeper keeps business financial records and performs basic and essential accounting tasks. The course provides an essential learning experience to the candidates to perform the basic bookkeeping and payroll management tasks in an effective and efficient manner. The course provides a launching platform to the candidates for a bright career in financial accounting, bookkeeping or payroll management.After successfully completing this course, the students shall be able to:Learn about the generally accepted accounting principles (GAAP)Learn and implement internal controlsMaintain subsidiary ledgers and special journalsReconcile accountsCorrect wrong amounts and wrong accounts by reverse entriesPerform sales tax calculationsSetup a yearly budgeting planUnderstand accounting for merchandisingPerform accounting for cashManage payroll systemThe course is intended for:Small and medium business ownersBookkeepers and accountantsPayroll management staffFinancial auditorsBusiness decision makersThe course has no formal pre-requisites. However, the basic knowledge of accounting fundamentals is highly recommended.

Learn to manage and run company payroll with QuickBooks Payroll and these tutorials from Bonnie Biafore.

Processing QuickBooks Online payroll for a small business, generating paychecks, processing payroll tax forms What you'll learn: List and describe payroll related legislationEnter new employee information into QuickBooks and describe where to get the data necessary to add a new employeeSet up and calculate Federal Income Tax (FIT)Describe the Federal Income Contribution Act and its componentsSet up and calculate social securitySet up and calculate MedicareSet up and calculate Federal UnemploymentDescribe and calculate employer payroll taxesGenerate payroll journal entries from payroll reportsGenerate and analyze Form 941 Employer's Quarterly Federal Tax ReturnGenerate and analyze Form 940 Employer's Annual Federal Unemployment (FUTA) Tax ReturnGenerate and analyze Forms W-2 & W-3Reconciling year end payroll tax formsGenerate and analyze a payroll register and payroll reportsDescribe mandatory and voluntary deductions and how they are entered into QuickBooks OnlineList and describe types of retirement plans and how to set them up in QuickBooks OnlineEnter comprehensive payroll problem into QuickBooks OnlineSetup paid payroll in QuickBooks OnlineProcess payroll in QuickBooks Online QuickBooks Online payroll will describe the payroll process for a small business in detail, so bookkeepers, accountants, and business owners can better understand how to set up payroll, process payroll, and troubleshoot problems related to payroll. This course will introduce the payroll set-up in the QuickBooks Online system, walking through payroll screens. We will discuss payroll legislation that will affect payroll calculations within QuickBooks Online and list the payroll forms we will need to generate from Quickbooks Online. The course will walk through the process of entering a new employee into the QuickBooks Online system and describe where the data would be received from in practice including Form W-4. We will discuss Federal Income Tax (FIT) calculations within QuickBooks Online. The course will describe how FIT is calculated, what is needed for QuickBooks Online to calculate FIT, and how to enter the data into the accounting system. The course will describe the Federal Income Contributions Act (FICA) and its components. We will calculate social security and describe how QuickBooks Online will help with the calculations as we process payroll. The course will calculate Medicare and describe how QuickBooks Online will help with the calculations of Medicare when we process payroll. We will calculate Federal Unemployment (FUTA) and discuss how FUTA is related to state unemployment (SUTA). The course will describe and calculate employer taxes and discuss which taxes are employee taxes and which taxes are employer taxes. We will describe payroll journal entries and discuss how payroll data is populated in the QuickBooks Online reports and financial statements including the profit and loss and balance sheet. We will discuss and enter both mandatory and voluntary deductions into the QuickBooks Online system. The course will discuss retirement plan options, how to enter them into the QuickBooks Online system, and how they are used to calculate net income and payroll taxes. We will work a comprehensive problem, processing payroll within QuickBooks Online. The comprehensive problem will use the paid QuickBooks Online feature. The comprehensive problem will start very basic with one employee and will increase in complexity as we enter more benefits and payroll details each year.

Learn to manage and run company payroll with QuickBooks Payroll and these tutorials from Bonnie Biafore.

Using the pay statement as our roadmap, this course covers the basics of payroll that everyone who receives a paycheck should know. Starting with your classification as an employee, you'll learn why certain new hire forms are required; how to calculate various payroll amounts, including gross and taxable wages, deductions, and certain taxes; how pretax deductions and benefits impact your taxes; and how your pay statement year-to-dates are used to generate a W-2. All this so you can make sure you are being paid accurately.

Prepare for a career in the diverse field of Payroll with an Entry-Level Payroll Specialist Professional Certificate from ADP! Learn about the value Payroll brings to an organization, what makes a successful Payroll Specialist, the foundational concepts needed by all those in the field, and the essential competencies you’ll need to be successful. Learn the process to execute a typical payroll cycle accurately and on time, the skills needed to manage payroll outside of the everyday tasks, and the fundamentals needed to understand payroll at a basic level. This program is designed to equip entry-level payroll specialists with the essential knowledge and skills necessary to carry out their responsibilities accurately, efficiently, and in compliance with applicable requirements.

This eight-course Professional Certificate from IBM prepares you with job-ready skills for an entry level data analyst role. Position yourself competitively and power your data analyst career for a job in a thriving market or leverage foundational data skills to explore problems in an increasingly data-driven professional world. The U.S. Bureau of Labor Statistics projects a growth rate of 20% in the data analytics industry until 2028. You will learn the core principles of data analysis, participate in hands-on skills-based practice, and gain the knowledge to help companies make smarter business decisions. You will work with a variety of data sources, project scenarios, and data analysis tools, including Excel, SQL, Python, Jupyter Notebooks, and Cognos Analytics. These online learning tools will offer you practical experience with data manipulation and the application of analytical and data visualization techniques. This Professional Certificate does not require any prior programming or statistical skills, and is suitable for learners with or without college degrees. A willingness to learn, basic computer literacy, comfort working with numbers, high school math, and a desire to enrich your profile with valuable skills is all you need to get started in this course. With the IBM Data Analyst Professional Certificate you will develop the confidence and portfolio to begin a career as an associate or junior data analyst by learning the essential skills that help professionals in a wide range of job functions and industries explore business problems.

Clean up messy data, uncover patterns and insights, and communicate your findings. You'll start with an introduction to data analysis tools, including Jupyter Notebook, NumPy, pandas, and Matplotlib. Using these tools, you will ask questions about data and answer them through data collection, exploration, wrangling, and visualization. This intermediate-level program includes real-world projects where you will choose your own datasets, research questions, and analysis approach. As you progress through the program, each course will repeat the data analysis process while introducing more advanced techniques, such as applying data imputation to fill in missing data and applying appropriate encodings when developing data visualizations.

The goal of the Security Analyst Nanodegree Program is to equip students with the skills required to be successful in an analyst role.

The US Bureau of Labor Statistics projects a 23% increase in cybersecurity jobs to 2033. The demand for cybersecurity analysts is growing ever stronger! What do cybersecurity analysts do? Cybersecurity analysts protect an organization's digital assets by identifying, analyzing, and mitigating security threats, ensuring data and systems remain secure against cyberattacks. This IBM Cybersecurity Professional Certificate has been designed by industry experts to provide you with the job-ready cybersecurity and digital forensic skills you need to jumpstart your cybersecurity career. No prior cybersecurity experience is required. To begin, you’ll build your foundational knowledge of cybersecurity essentials, tools, and technologies, operating systems, networking fundamentals, and the basics of cyberattacks. You’ll explore database fundamentals and vulnerabilities and learn about the steps a cybersecurity analyst would take to prevent, manage, and mitigate cybersecurity attacks. Plus, you’ll learn about cybersecurity architecture, compliance frameworks, standards, and regulations. You’ll also explore gen AI for cybersecurity and build valuable skills and hands-on experience in penetration testing, incident response, forensics, and threat intelligence. You’ll work on real-world projects developing cybersecurity plans and compliance frameworks, giving you great practical work to talk about in interviews. Plus, you’ll use real-world case studies that demonstrate that you can: Apply incident response methodologies and forensics practices. Use industry-specific security tools. Apply cybersecurity industry standards and best practices that mitigate risks, enhance security, and ensure compliance through audit processes. Use gen AI tools to boost cybersecurity effectiveness and productivity. Investigate a real-world security breach by identifying the attack, vulnerabilities, costs, and prevention. Take advantage of the insights provided by seasoned industry experts to guide your job search, resume creation, and Interviewing to help you land your first cybersecurity role. This program will also prepare you to take and earn a 30% discount on the CompTIA Security+ and CySA+ certification exams. After successfully completing this program, you’ll have an industry-recognized IBM Professional Certificate that you can add to your resume and portfolio. If you’re looking to kickstart your cybersecurity career as a sought-after analyst, ENROLL TODAY, and look forward to being job-ready in less than 6 months!

Understand Data Security What you'll learn: Deep knowledge of organization’s IT Systems.IT Security threat analysis and management.IT Security maintenance, training and supportIT security fixes, tools, countermeasures, testing plus upgrade paths This course is designed for anyone who wants to understand the analysis of data security. More than ever, information security analysts are needed to rescue companies when they have been hacked or breached, as well as to put in place controls and counter-measures to avert cyber attacks.Gain the skills required to detect and mitigate information and cyber security threats and vulnerabilities. The security analyst role is an entry point to many other security specialties and is highly in-demand in today’s evolving threat environment.In the fast moving world of cyber security, with new threats evolving daily, up to date knowledge and skills that involves protecting systems and networks of companies and other assets containing mission-critical data as well as designing and developing new security solutions routinely to stay ahead of the hackers and cyber attackers.Learn the essential prerequisites for your career success! ENROLL TODAY!

Step into the fast-growing world of data analytics with the Data Analyst program. This comprehensive, beginner-friendly series of courses from Microsoft will equip you with essential skills to collect, clean, model, and visualize data using Power BI—a leading business intelligence platform. Through hands-on projects and interactive lessons, you’ll learn how to turn raw data into actionable insights, build compelling dashboards, and effectively communicate trends and findings to stakeholders. Whether you're aiming to launch a new career in data analysis or upskill in your current role, this program offers the practical knowledge and tools to succeed in today’s data-driven job market.

Learn how to efficiently manage payroll in QuickBooks Online with this comprehensive tutorial video. Explore the Payroll Setup Checklist, add employees, set up your company for payroll, run payroll processes, adjust settings, and manage payroll taxes. Follow along with step-by-step instructions and time-stamped sections for easy navigation. Download a free QuickBooks Online Shortcuts Sheet to enhance your productivity. Gain valuable insights into QuickBooks Online Payroll functionality and streamline your payroll management processes.

Processing QuickBooks Pro Desktop 2019 payroll for a small business, generating paychecks, processing payroll tax forms What you'll learn: List and describe payroll related legislationEnter new employee information into QuickBooks and describe where to get the data necessary to add a new employeeSet up and calculate Federal Income Tax (FIT) In QuickBooks Desktop Pro 2019Describe the Federal Income Contribution Act and its componentsSet up and calculate social security in QuickBooks Pro Desktop 2019Set up and calculate Medicare in QuickBooks Pro Desktop 2019Set up and calculate Federal Unemployment in QuickBooks Pro Desktop 2019Describe and calculate employer payroll taxes in QuickBooks Pro Desktop 2019Generate payroll journal entries from payroll reports in QuickBooks Pro Desktop 2019Generate and analyze Form 941 Employer's Quarterly Federal Tax Return in QuickBooks Pro Desktop 2019Generate and analyze Form 940 Employer's Annual Federal Unemployment (FUTA) Tax Return in QuickBooks Pro Desktop 2019Generate and analyze Forms W-2 & W-3 in QuickBooks Pro Desktop 2019Reconciling year end payroll tax formsGenerate and analyze a payroll register and payroll reports from QuickBooks Desktop Pro 2019Describe mandatory and voluntary deductions and how they are entered into QuickBooks Desktop Pro 2019List and describe types of retirement plans and how to set them up in QuickBooks Desktop Pro 2019Enter comprehensive payroll problem into QuickBooks Desktop Pro 2019Setup paid payroll in QuickBooks Desktop Pro 2019Setup Manual payroll in QuickBooks Pro Desktop 2019Process payroll in QuickBooks Pro Desktop 2019Pay payroll liabilities using QuickBooks Desktop Pro 2019 QuickBooks Desktop Pro payroll will describe the payroll process for a small business in detail, so bookkeepers, accountants, and business owners can better understand how to set up payroll, process payroll, and troubleshoot problems related to payroll. This course will introduce the payroll set-up in the QuickBooks Desktop Pro system, walking through payroll screens for both the paid version and the free manual version of payroll within QuickBooks Desktop. We will discuss payroll legislation that will affect payroll calculations within QuickBooks Pro Desktop and list the payroll forms we will need to generate from Quickbooks. The course will walk through the process of entering a new employee into the QuickBooks Desktop Pro system and describe where the data would be received from in practice including Form W-4. We will discuss Federal Income Tax (FIT) calculations within QuickBooks Pro Desktop. The course will describe how FIT is calculated, what is needed for QuickBooks Pro to calculate FIT, and how to enter the data into the accounting system. The course will describe the Federal Income Contributions Act (FICA) and its components. We will calculate social security and describe how QuickBooks Pro Desktop will help with the calculations as we process payroll. The course will calculate Medicare and describe how QuickBooks Desktop Pro will help with the calculations of Medicare when we process payroll. We will calculate Federal Unemployment (FUTA) and discuss how FUTA is related to state unemployment (SUTA). The course will describe and calculate employer taxes and discuss which taxes are employee taxes and which taxes are employer taxes. We will describe payroll journal entries and discuss how payroll data is populated in the QuickBooks reports and financial statements including the profit and loss and balance sheet. The course will describe and fill out a payroll register and analyze the many payroll reports that can be generated from QuickBooks Pro Desktop. We will discuss and enter both mandatory and voluntary deductions into the QuickBooks Pro Desktop system. The course will discuss retirement plan options, how to enter them into the QuickBooks Pro Desktop system, and how they are used to calculate net income and payroll taxes. We will cover two comprehensive problems, processing payroll within QuickBooks Desktop Pro. One comprehensive problem will use the paid QuickBooks version. The second comprehensive problem will use the free manual version and compare the computations to ones we will do in Excel. Our first comprehensive problem will start off very basic with one employee and will increase in complexity as we enter more benefits and payroll details each year. Our second comprehensive problem will focus on manual calculations to get a better understanding of what the paid version is really doing for us. A better understanding of the calculations being made by the QuickBooks Desktop Pro system allows us to spot and troubleshoot problems when they happen.In addition to the instructional videos, this course will include downloadable • QuickBooks Pro Desktop Backup files• Excel practice files• Downloadable PDF Files The QuickBooks Desktop backup files are a great tool that allows us to jump ahead in the material or to rework material if we choose. Excel practice files will be preformatted and will generally have at least two tabs, one tab with the completed work and a second tab with a preformatted worksheet we can fill in as we watch the instructional videos.

Hands-On Data Analysis with SQL What you'll learn: Analyse and manipulate dataCreate Database and TablesAnalyse data using aggregate functionsAnalyse data using analytic functionsAnalyse data using ranking functionsAnalyse data using various operatorsAnalyse data using sub queriesAnalyse data using views A SQL data analyst is a data scientist that uses the SQL language to interpret data. This analysis is used to improve business information and provide new insights to managers.SQL data analysts design scripts and programs to perform specific database functions and to analyse and maintain data. Some SQL Data Analyst Duties and ResponsibilitiesDuties vary for SQL data analysts based on the specific needs of the hiring company and the amount of data being analysed. However, these core tasks are commonly associated with this job:Integrate DataSQL data analysts integrate data from multiple data sets into o:ne database system to streamline information.Create Database FunctionsSQL data analysts program specific database functions to create database triggers and design data tables.Design ReportsAfter reviewing and analysing data, SQL data analysts design reports to show statistics and other information about specific database topics.Clean DatabaseSQL data analysts remove dead data files and other irrelevant information to free up database space.Write ScriptsSQL data analysts write scripts to analyse data and perform specific data queries.Resolve Data IssuesSQL data analysts isolate and resolve issues with data and databases.Add DataSQL data analysts collect data from multiple sources and add it to the database. We will be performing data analysis using SQL on relational databases like: MySQL, PostgreSQL and MS SQL Server.A relational database is a type of database. It uses a structure that allows us to identify and access data in relation to another piece of data in the database. Often, data in a relational database is organized into tables. A relational database includes tables containing rows and columns. For example, a typical business order entry database would include a table that describes a customer with columns for name, address, phone number and so forth.SQL or Structured Query Language is a critical tool for data professionals. It is undoubtedly the most important language for getting a job in the field of data analysis or data sciences. Millions of data points are being generated every minute. And raw data does not have any story to tell. After all this data gets stored in databases and professionals use SQL to extract this data for further analysis.