My Shopping Cart
 
There are no items in your shopping cart.


Simplifying Payroll Budgets in Excel (IME630B)

Presented By : David Ringstrom , CPA
(*) Single User Price. For multiple users please call 1-800-223-8720
Pre Recorded Audio Conference
60 minutes
  •  Mon, June 3, 2013
Event Description

Identify Best Practices And Avoid The Common Pitfalls Of Payroll Budgets In Excel

Excel is a useful program which is widely used by individuals and companies to create payroll spreadsheets. In this live webinar, our Microsoft Excel expert David Ringstrom, CPA, will share a number of techniques that you can use to simplify payroll budget spreadsheets. Attendees will get the chance to ask any type of queries to David, even if they’re not specifically related to the material in the presentation. Our expert will mostly teach from Excel 2010, however he’ll include alternate instructions and techniques when applicable to Excel 2007, 2003, and even 2013.

Every hour many users transcribe hundreds or thousands of records into Excel to develop a payroll budget. This session will teach you, how you can eliminate manual data entry by linking to data sources, improve the integrity of your payroll budget by embedding key inputs, and how to use the pivot tables to quickly summarize and review the final results.

During this one-hour webinar you will:

  • Find out how you can link to a source file that has your payroll records, and then let Excel take care of managing the associated calculations
  • See how the hidden Form command makes it easy to review one record at a time
  • Use Range Names in your spreadsheet to streamline payroll-related calculations, or to hide key values that you don't want users overwriting
  • See how Pivot Tables can quickly summarize your results by department, region, or however you need it
  • Use the COUNTIF function to allocate costs based on head-count
  • Save the final results as a comma-separated value format so that accounting or finance can simply import your budget into the payroll software
  • See how to create automatic back-up copies of your payroll budget, so that you have fall-back positions in case something goes awry

Plus, you’ll also learn how to save others from rekeying data by creating an importable file for your budget software.

Who should attend? Beginning to intermediate Excel users

About Our Speaker(s)

David Ringstrom, Excel ExpertDavid Ringstrom CPA
David is a CPA and owner of Accounting Advisors, Inc., an Atlanta-based spreadsheet consulting firm that he started in 1991. Throughout his career David has spoken at conferences on Excel, and written dozens of freelance articles about spreadsheets. David\'s webinars receive rave reviews, and attendees particularly lik... More info

 
Recommend this event to a colleague
  • Your Name:
  • Your E-mail:
  • Colleague's Name:
  • Colleague's E-mail:
  •  
    Subject: You might be interested in this event from AudioSolutionz
    Event Title: Simplifying Payroll Budgets in Excel
    Presenter(s): David Ringstrom , CPA

 
DMCA.com Protection Status