logo

State Financial Video Tutorials

Page Menu

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 AccountsState 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.

 

TeamWorks Commitment Control Overview and ChartfieldsSection 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.

TreesSection 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. 

Ledger Groups and LedgersSection 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.

 

Translating Data Entry Values to Budget LedgersSection 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 PivotTablesHow 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

 
 

How to VLookup within Excel

 

 


Contact

Dave Lakly

404.917.7943