slide1 n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Excel Tips and Tricks to Find Improper Payments Jim Davidson Bob Lehmann PowerPoint Presentation
Download Presentation
Excel Tips and Tricks to Find Improper Payments Jim Davidson Bob Lehmann

Loading in 2 Seconds...

play fullscreen
1 / 10

Excel Tips and Tricks to Find Improper Payments Jim Davidson Bob Lehmann - PowerPoint PPT Presentation


  • 124 Views
  • Uploaded on

Excel Tips and Tricks to Find Improper Payments Jim Davidson Bob Lehmann. Bureau of State Expenditures. Audits state expenditures prior to payment Conducts post audits. Environment. 450 Agencies 4 million payments $80 billion. Other payments. Bureau of State Expenditures.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Excel Tips and Tricks to Find Improper Payments Jim Davidson Bob Lehmann' - clodia


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
bureau of state expenditures
Bureau of State Expenditures
  • Audits state expenditures prior to payment
  • Conducts post audits

Office of Operations 2009 Fall Conference

environment
Environment
  • 450 Agencies
  • 4 million payments
  • $80 billion

Office of Operations 2009 Fall Conference

other payments
Other payments

Office of Operations 2009 Fall Conference

bureau of state expenditures1
Bureau of State Expenditures

4 million payments worth $80 billion in 254 business days annually

16,000/$315 million payments a day!!!

50 auditors - 320/$6.3 million payments each day

Office of Operations 2009 Fall Conference

bureau of state expenditures2
Bureau of State Expenditures

Office of Operations 2009 Fall Conference

data analysis
Data Analysis

Data analysis is a process of systematically applying statistical and logical techniques to summarize, compare, and describe data.

We use data analysis to evaluate risk and determine where to best focus our audit efforts.

Office of Operations 2009 Fall Conference

data analysis tools
Data Analysis Tools

Office of Operations 2009 Fall Conference

course objectives
Course Objectives
  • Import text files
  • Verify data (using sum/count/sort)
  • Basic & advanced filters
  • Summarizing data
  • Basic & advanced formulas/functions
  • Pivot Tables
  • Identify Duplicates and Gaps
  • Benford’s Analysis

Office of Operations 2009 Fall Conference

slide10
To obtain a copy of the supporting documents used in this presentation, send an email to the Outreach Training Program –

Outreach@osc.state.ny.us

Office of Operations 2009 Fall Conference