$150 (per person) includes an online webinar for 2 hours of CPE credit
How do you know if the data and formulas in the Excel worksheet you use as audit evidence is right or wrong?
In addition to validating the accuracy of formulas, it’s equally important to know where the data was sourced and if it’s reliable. Remember, data is only as good as how it is collected and manipulated.
Don’t let any of that scare you! The ability to successfully audit Excel workbooks is achievable if you know how to use the right tools. This session will highlight those tools and demonstrate methods of working in Excel to better ensure the reliability of data and reports.
- Determine if formulas are consistent
- Determine how to track formulas across worksheets and workbooks
- Identify where to find all external information sources for a workbook
- Identify how to “watch” once cell while manipulating a related cell in another worksheet or workbook
- Determine how and when to use conditional formatting to indicate potential problems in cell data
- Identify how to use the Evaluate Formulas and Error Checking tools effectively
- Identify techniques to find “hidden” cells, worksheets and formulas
Program Level: Basic
Field of Study: Auditing (Governmental)
Who Should Attend: Auditors of government data and programs
Advanced Preparation Required: Participants should have Excel for Microsoft 365, Excel 2021, Excel 2019, or Excel 2016 installed on their computer prior to attending this workshop.
Instructional Method: Webinar (Group Internet Based)
CPE Credit Hours: 2
Date: Wednesday, April 10, 2024
Time: 12:00 p.m. – 2:00 p.m. Central
Reverse Engineering Excel Workbooks for Data Reliability Webinar Leader:
While it’s true that if you don’t know where you’re headed, it doesn’t matter how you get there; not asking in the first place is the sure road to disaster when it comes to significant technology infrastructure changes. Ask any business unit executive who can’t do today what she did yesterday but keeps being told that the organization is now “in a better place,” technologically speaking.
Melissa Esquibel was in the thick of early business technology innovation when hardware and systems were kept in a virtual black box, and IT gatekeepers doled out functionality within a rigid systems architecture. Now, in the present, where end-users know how to access the power of technology independently and according to the agile timelines they need, this push and pull has created quite a mess in many organizations.
With her unique experience as the conduit between the gatekeepers and the gate stormers, she offers her unique perspective as “bridge builder” to you. Her sense of humor and common sense approach will engage your team and produce results you can take to the bank in real world time savings and effective use of your organization’s resources. She brings out the best in people, coaxing out meaningful collaboration and impactful solutions.
Questions? You can find our FAQ here.
To see a breakdown of how many polls and minutes of attendance are required for this webinar, see this page.