Financial Training Videos

Library Financial Management Certification Program

• View Budgeting course preview video

• View Governmental Accounting course preview video

• View Internal Control course preview video

• View Payroll Administration course preview video

• View Purchasing course preview video

• View Financial Policies course preview video

• View Balancing the Books - Strategies for Sound Financial Practices free webinar

  Free 1-hour webinar -  no CPE or CEU credit-free resource only

   

Local Government Certification Program

• View Free Fundamentals of Governmental Accounting Webinar

• View Free Fundamentals of Purchasing Webinar

• View Free Fundamentals of Capital Improvement Webinar

• View Free Fundamentals of Internal Control Webinar

 

State Financial Management Certification Program

Chart of Accounts

This tutorial explores the design of Georgia’s Uniform Chart of Accounts.  At the end of the tutorial, you should be able to define the purpose of a chart of accounts, recall the state’s chartfields and their purposes

State of Georgia Chart of Accounts This 22 minute video will discuss each chartfield in the State of Georgia Chart of Accounts.

Understanding TeamWorks Commitment Control This 4-part tutorial explores the TeamWorks Commitment Control module, explaining trees, ledger groups and ledgers. At the end of the tutorial, you should be able to recall how trees and ledgers work together to monitor and control budgets in TeamWorks Commitment Control.

Section 1 - Commitment Control Overview and Chartfields (09:14) This section provides an overview of Commitment Control and chartfields. At the end of the section, you should be able to recall various chartfields in TeamWorks and how they are used.

Section 2 – Trees (15:58) This section focuses on Trees used in Commitment Control. At the end of the section, you should be able to recall the differences between agency and statewide trees, recall the various trees used in TeamWorks and describe the hierarchy in TeamWorks trees.

Section 3 - Ledger Groups and Ledgers (10:21) This section focuses on ledger groups and ledgers used in Commitment Control. At the end of the section, you should be able to recall the various budget ledger groups in TeamWorks Commitment Control, recall the budget ledgers used within each ledger group and recall the various levels of control.

Section 4 - Translating Data Entry Values to Budget Ledgers (14:29) This section focuses on translating data entry values to budget ledgers. At the end of the section, you should be able to convert values using the translation map to the appropriate budget ledger values in TeamWorks Commitment Control.

Microsoft Excel Tutorials These tutorials explain Excel functionality demonstrated in the webinar.

How to Create Excel PivotTables (16:05) This tutorial will show users how to create pivot tables using Microsoft Excel. The training example uses the results of a 0BD010 TeamWorks query from the State of Georgia's financial system.

 

How to Concatenate within Excel

Using the Left Function within Excel

 

 

---