On Demand Webinar: Excel Training Series: Practical Applications of Advanced Count and Sum Functions

1 CPE GSK | 1 GFI Elective

 

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. 

 

All OnDemand webinars receive CPE and/or GFI Credit. After watching the OnDemand webinar, you will need to complete a quiz and return it to receive credit. The quiz will be accessible on the OnDemand Webinar link sent to you upon payment. 

If you choose to pay by check, a link to the OnDemand Webinar will be sent upon receipt of payment.

If you choose to pay online with a credit card, a link to the OnDemand Webinar will be sent by the end of the next business day. 

When
September 1st, 2019 12:00 AM
Location
The Comfort of Your Office
On-Demand Webinar, NY
United States
OnDemand Webinar
Fee
Member $ 55.00
Non-Member $ 85.00