| Attend upcoming webinar and earn continuing education credits. | Excel Techniques for Payroll Professionals | | | | | | | | October | | | | 4 | | 1 pm - 2:40 pm ET | | | Presenter: David Ringstrom, an author and nationally recognized instructor | | | Credits: CPE, HRCI, and SHRM (Credit Details) | | | Can't attend live? By registering, you will be able to view the course live, view a recording at any time after the live presentation, or both. | | | Viewing Options: View on your computer, tablet, or smartphone | | | | | | | | | | | | There are many features and functions available in Excel that you can use to improve the accuracy and efficiency of payroll production. In this practical webinar, Excel expert, David Ringstrom, CPA, demonstrates and explains: - Mathematics for employee timesheets
- Date and time formatting and stamping
- Conditional formatting to highlight HR requirements
- Password protection for sensitive payroll files and worksheets
- Salary information formatting
- Using pivot tables for HR reporting and analysis tasks
You will see each technique demonstrated at least twice: first, on a PowerPoint slide with numbered steps, and second, in Excel 2019. You will identify differences in Excel 2016, 2013, or 2010 and will receive detailed handouts. You will also receive an Excel workbook that includes the examples presented during the webinar. You will learn how to: - Redact portions of Social Security numbers by way of Excel's TEXT worksheet function
- Identify 4 different ways to remove data from a pivot table report
- Format certain words within a column of text with Conditional Formatting
- Color-code the top ten (or however many you wish) amounts within a column of numbers with Conditional Formatting
- Improve the integrity of Excel pivot tables with the Table feature
- Add fields to a blank pivot table to create instant reports
- Determine the previous Friday when payroll dates fall on a weekend by using the IF and WEEKDAY functions
- Utilize the RANDBETWEEN worksheet function to create a series of random numbers
- Remove Conditional Formatting when it's no longer needed within a spreadsheet
- Calculate a series of semi-monthly dates by way of the IF and EOMONTH worksheet functions
- Describe the nuances of adding time values together in Microsoft Excel
- Employ pivot tables to pull random sets of employee names, such as for drug testing
Upon course completion, you will be able to: - Identify the command within the Tools menu, within the Save As dialog box, that enables you to password protect an Excel workbook from being opened or modified
- Recognize the Conditional Formatting feature that enables you to create a heat map
- State the worksheet function that returns a random number between two values that you specify each time the worksheet is recalculated
Suggested Audience: Professionals who wish to learn a variety of Excel features and functions that can improve the accuracy and efficiency of payroll production. | | | | | | | | | | David H. Ringstrom, CPA, is an author and nationally recognized instructor who teaches scores of webinars each year. His Excel courses are based on 25 years of consulting and teaching experience. David's mantra is "Either you work Excel, or it works you," so he focuses on what he sees users don't, but should, know about Microsoft Excel. His goal is to empower you to use Excel more effectively. | | | | | | | | | | | ● Earn continuing education credit for no additional fee
● Access courses on your computer, tablet, or smartphone
● More than 75 live webinars each month
● More than 1,500 on-demand courses | | | | | | |
No comments:
Post a Comment