The Introduction to Microsoft Excel 2010 course will demonstrate to users the functionality of a spreadsheet and the ease of use in storing, manipulating, analyzing, and visualizing data. You will learn the basic benefits of working with Excel and how to create and format an Excel worksheet. You will also learn how to navigate the Microsoft Excel 2010 environment, customize the Quick Access ...more
Sharepoint Team Sites are a new way to collaborate at American University. Explore the various templates that are available and find out how to request a team site. Learn how to administer your team site, control access, and invite new members, manage documents and other content, and customize the site to best meet your needs.
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 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.
This Purchasing course provides you with an overview of the AU Purchasing Cycle and gives you hands-on experience creating Purchase Requisitions and researching Purchase Order and Vendor/Voucher information in the system.
Prerequisite: A valid Datatel account and supervisory permission is required to attend this course.
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