Audio Conference/Webinars & Events: Online
Sponsored by Accounts Payable Now & Tomorrow, a Crystallus Inc. publication
Using Pivot Tables (Excel 2007/2010)
in Accounts Payable
Thursday, August 25, 2011 2:00 p.m. EST (1:00 p.m. CST; noon MST; 11:00 a.m. PST)
Register here & get the CD too.
Order the CD alone here.
To pay by check, download an order form here.
Without a doubt, the work currently being done on the accounts payable function is becoming increasingly sophisticated and analytical. With reams of data to evaluate, it’s not surprising that a growing number of professionals are turning to pivot tables to sort through the mass of information. Pivot tables take much of the manual efforts out of the process making professionals more productive and allowing them to spot trends they may have otherwise missed.
On August 25, Rich Lanza has agreed to give a one-hour presentation that will arm attendees with the information they need to effectively use Pivot Tables in their shop. He’ll start by demonstrating how to create a pivot table and then quickly move on to demonstrating real life accounts payable examples including:
- Tabulating/Reviewing employee performance measures
- Detecting possible duplicate payments
- Searching for open credits and organizing by supplier
- Looking for number trends such as Benford’s Law
- Calculating average payment trends to suppliers
- Reviewing accounting distribution (general ledger) data by type and supplier for useful procurement trends
- Graphing and summarizing invoice payment information by who, when, and where using a few mouse clicks.
- …and more
There will be plenty of time at the end for you to ask questions.
When: August 25, 2011
Lecturer: Rich Lanza
Where: Your office!
Cost: $189 for Webinar or CD; $289 for both CD & Webinar (if ordered together)
Time: 2:00 p.m. EST (1:00 p.m. CST; noon MST; 11:00 a.m. PST)
About Rich Lanza
Rich Lanza (CPA, CFE) President of Cash Recovery Partners, LLC, helps companies identify their hidden financial assets, mostly using technology and referring them to specialists. He has close to two decades of experience in audit technology and recovery auditing, becoming a leading authority in these areas. His free website, www.findmillions.net, helps companies to identify cost recovery and prospective savings in all areas of their business.
Rich was recently a key contributor to the IIA’s Global Technology Audit Guide (GTAG) Fraud in an Automated World. He is the author of 13 publications and training courses in audit software and has over 75 articles for major audit and accounting publications. These written materials include Proactively Detecting Fraud Using Computer Assisted Audit Reports that he wrote as a research project for the Institute of Internal Auditors. This work led to him receiving the Outstanding Achievement in Business award from the Associated of Certified Fraud Examiners. He also just finished a practical guide of the cash recovery industry for John Wiley entitled Cost Recovery: Turning Your Accounts Payable Department into a Profit Center.
Rich has worked for companies ranging in size of $30 million to $30 billion and in all, has helped them save money through the use of technology and recovery auditing
Register here & get the CD too.
Order the CD alone here.
To pay by check, download an order form here.
Earn while you learn with no costly travel expenses! CPE credits available to all program participants.
 Crystallus Inc. is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be addressed to the National Registry of CPE Sponsors, 150 Fourth Avenue North, Suite 700, Nashville, TN, 37219-2417. Web site: www.nasba.org.
Work experience in accounts payable, accounting or related field, or an introductory course in accounting is a prerequisite for these intermediate level programs. No advance preparation is needed. For more information regarding administrative policies such as refund, complaint and/or cancellation, please contact us at 302.836-0540. To see our customer service policies, click here.
This one-hour Group-Internet-based programs is eligible for one (1) CPE credit.
Register here & get the CD too. Order only the CD here.
Build Your CD Library! CDs of all our programs—past and present—are available! Click here for more information and to purchase. For an order form, click here.
|
