The General Ledger course prepares you to utilize the Datatel Colleague Financial System to manage your department's financial data. You will learn how to perform standard look-ups such as GLST, ACBL and AHST and run reporst including LGLA, GLSA, GLBR and XGAR. You will also receive an overview of the Budget Cycle, and learn about key dates and events within the cycle.
The Microsoft Excel 2010 Intermediate Level course will build on the skills learned in the Introduction course. You will learn how to work with multiple worksheets in a single workbook by adding three-dimensional references to formulas, and consolidating data from the worksheets; control the appearance of worksheet data with custom formats; organize data using a variety of graph and chart ...more
Managing your content pages on the new MyAU portal is easy, if you have the basic Sharepoint knowledge you need. Learn about the fundamentals of Sharepoint, the technology on which the portal was built. Participants will also develop content pages, add webparts to their pages, and manage existing content.
The Advanced CommonSpot course is for American University staff who will serve as departmental contributors to CommonSpot, American University's Content Management System.
In this course, add video to a News template and as an element on a webpage, edit the left navigation bar, create a form with fields for visitor input, customize Twitter and Facebook elements, update staff/faculty profile ...more
In this course, you will: apply conditional formatting to emphasize specific data elements, work with comments, use Paste Special options, create dynamic named ranges, set up a basic pivot table, show data trends with sparklines, evaluate data with subtotals, work with macros and Visual Basic programming and correct worksheet errors.