Data Validation and Time Functions are two powerful Excel features. Data Validation determines what entries a cell will allow. This is exceptionally useful in creating dropdown menus and worksheets designed to reject entries that fall outside a defined-criteria.
For example, requests for reimbursement in amounts that exceed a per diem or dates that fall out of a fiscal year. Time functions are very useful in tracking work orders or any other time-based processes. They are essential in estimating the completion dates of complex projects. Only a rudimentary prior understanding of Excel is necessary to use these tools. A template will be available to use along with the video.
Eligible for 1 GFI Elective Credit
After watching the OnDemand webinar, you will need to complete a quiz and return it to earn credit.
Not enrolled in the Government Finance Institute (GFI)? Click Here for more details!
On-Demand Webinar, NY