While most Excel users are familiar with both of the basic sum and count functions, many are not familiar with more powerful conditional count and sum functions using countif, sumif, countifs and sumifs.
Conditional count and sum functions allow you to establish specific criteria for the result such as count all of full-time employees or all sum the total of all checks over a certain amount. Countifs and Sumifs are exclusionary and are extremely useful in counting or totaling a subset of data without the need for extensive sorting.
Sound complicated? It is not, and anyone with a rudimentary knowledge of Excel can easily master these functions and put them to immediate use in government finance and public sector applications. As a take-away, you will receive a fully annotated template with all the formulas and "you try" examples after the session.
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