You are here: Registration

OIT Technical Training Workshops

Register now for any of the free technical training workshops sponsored by the Office of Information Technology. There are a variety of training options, including instructor-led, on-demand Web-based training, and custom training options. The OIT Training Room is located in Anderson Hall, south-side lower level, room B-46.

Course Descriptions

Opportunity for learning is everywhere at American University. View the learning objectives of the free technical training workshops offered by OIT for staff, faculty, and students.

CommonSpot - Introduction
Learn to edit an existing webpage using AU's content management system, CommonSpot. Participants will learn essential CommonSpot terminology, use the menu bar navigation to change content in webpage elements, locate site pages, differentiate between internal/external/document page links, edit images to conform to common element standards, and submit a page for approval. This course is for new users to CommonSpot.


CommonSpot - Intermediate
Learn to create a new webpage using AU's content management system, CommonSpot. Using a blank template, participants will create new page layouts, add elements to containers, learn about the additional options of those elements, and use the MS Accessibility Checker to convert Word documents to accessible PDFs. Please take CommonSpot - Introduction before attending this class.

Teams is a hub in Office 365, designed for teamwork and flexibility, that builds on existing Microsoft technologies woven together by Office 365 Groups. In this workshop, you will learn how Teams, powered by the cloud, provides a single workspace for managing individual chats and team conversations, conducting and recording virtual meetings, maintaining and collaborating on shared documents, utilizing channels for central storage of project content, and integrating Office 365 applications.Contact the OIT Tech Training Team at techtrain@american.edu to schedule a customized training for your department or working group.

Introduction to Microsoft Excel Basics
Participants in this workshop will manipulate cell, column, and row content. Apply various formatting styles to both text and numbers. View selected portions of data versus entire range of data. Analyze data by sorting and filtering. Make calculations using basic formulas. And output data using a variety of print options.
 

Excel - Solving Problems with Functions
Participants in this workshop will use multi-argument functions to solve complex problems. Change cell contents by using logical functions. Expand a simple formula using nested functions. Understand the difference between Relative and Absolute Cell References. Streamline existing formulas with shortcut techniques. Please take Introduction to Microsoft Excel Basics before attending this class.
 

Excel Summarize and Analyze Data
Participants in this workshop will use Groups and Subtotals to make large sets of data more useful. Analyze related data with a table. View data from different angles with a pivot table. And graphically illustrate worksheet data with charts, graphs, and pivot charts. Please take Introduction to Microsoft Excel Basics, and Excel - Solving Problems with Functions before attending this class.

PowerPoint - Introduction
Participants in this workshop will build a presentation from scratch or leverage premade templates and themes and demonstrate adding and editing of text, images, graphs, video, and animation; format slides for consistency; and add speaker notes and transitions to ensure a smooth delivery.

PowerPoint - Advanced
Participants in this workshop will link and embed content into a PowerPoint presentation from other sources, display data using tables and charts, work with video and audio files, create instant screen recordings, customize slide masters and layouts, record narrations, apply artistic effects to images, and manage presentation output.

ServiceNow - Customer Service Training for Agents

ServiceNow is American University's Cloud-based Customer Relationship Management System. The training will introduce you to ServiceNow’s Customer Service Management Module. You will learn how to create, assign, and track customer service requests. You will also learn how to create articles for the ServiceNow Knowledgebase.

ServiceNow - Customer Service Training for Managers

This training will be useful to ServiceNow managers who use either the IT Service Management or Customer Service Modules. In this training you will learn how to work with performance analytics, create templates, dashboards, and several types of reports.

ServiceNow Incident Management Training

This hands-on training introduces you to ServiceNow, OIT’s Cloud-based IT Service Management Solution. You’ll learn how to navigate the Service Portal, and how use the Incident Management module to create, assign, and track customer service requests. Registration for this training is limited to OIT Staff and our Tech Partners.

ServiceNow Change and Problem Management Training

This hands-on training will teach you how to use ServiceNow’s Change and Problem Management Modules. You’ll learn how to create, approve and track change requests, and how to create and manage problem records. Prior completion of Incident Management training is recommended. Registration for this training is limited to OIT Staff and our Tech Partners.

ServiceNow - Creating Fillable Forms

This course will teach you how to create, edit and work with fillable forms, known as record producers, within ServiceNow for customers to use to request support or provide information. Prerequisites: Must be a Manager within a department using ServiceNow Customer Service Module.

Office 365: OneDrive for Business and Office Web Applications
Participants in this workshop will learn to use OneDrive for Business to store, edit and share your work files and documents, whenever you are on or off campus, and collaborate on Office documents with others in real time. This workshop will highlight the useful features of OneDrive for Business, as well as some handy tips to help you enhance productivity using the Office 365 Word, Excel, PowerPoint applications.

Outlook 2016 and Outlook Web App
Participants in this workshop will customize mail and calendar options and learn the top features of Outlook Mail and Calendar, using both Outlook 2016 and Outlook Web App (OWA). 

Office 365: OneNote
Participants in this workshop will learn the basics of creating and working with notebooks; add/re-arrange/delete pages and sections, learn different ways to add and format text; understand options to store all related information in one place by adding audio, video, links, and attached files; gain knowledge of how to add sketches to notes with drawing capabilities and related formatting options; and increase productivity by quickly finding information with tagged notes.  

Participants in this workshop will learn the features of desktop publishing software to design a tri-fold brochure and a flyer in MS Publisher and Adobe InDesign. Additionally, they will use Adobe Photoshop to edit images using image essentials, color fundamentals, selection tools, layers, and filters.

Online Training

Faculty and staff: Login to myau.american.edu, click the Technology link in the Personalized Links section, and select AsuccessfulU. In the Learning section of AsuccessfulU, search for the desired video course to register and view on-demand.

Introduction to Ellucian Colleague - (ONLINE AU_214281)

This course is required before access is granted to Ellucian Colleague, AU’s Enterprise Resource Planning system.

Colleague and Business Intelligence -(ONLINE AU_265281)

What is the difference between Colleague and Business intelligence (BI)? How do these two systems interact with each other? Ellucian Colleague and MicroStrategy Business Intelligence are two reporting systems at American University. You may encounter these systems in your daily work at the University. This video explains the inter-related functions of the two systems and the business needs they meet.

Colleague Purchasing - (ONLINE AU_42281)

Do you need to create and manage purchase requisitions for your department? This online tutorial will guide you through creating a purchase requisition; and provide resources to research purchase orders, vendor, or voucher information in the Colleague Financial System. Participants will also learn about the American University purchasing cycle.

Colleague Purchasing - Vendor Activity Inquiry Screen (VENI) - (ONLINE AU_9581)

Use the Vendor Activity Inquiry (VENI) form to view all purchasing activity with the specified vendor, plus total year-to-date counts and amounts.

Colleague Purchasing - Voucher Inquiry Screen (VOUI) - (ONLINE AU_9582)

Use the Voucher Inquiry (VOUI) form to view information about a voucher.

Colleague General Ledger - (ONLINE AU_51281)

Are you a new or experienced departmental budget manager that could benefit from learning more about the Colleague Financial General Ledger screens? This course prepares you to utilize the General Ledger to manage your department's financial data. Learn how to perform standard look-ups, and run reports to get the latest information on encumbrances, expenditures, and remaining budget amounts. Participants will also become familiar with the American University budget cycle.

Using Colleague's XGAR screen - (ONLINE AU_2122)

This video focuses exclusively on how run the XGAR detailed activity report in the Colleague financial system. XGAR generates a report based on fiscal year, start and end dates, transaction dates, and General Ledger account definition. The XGAR report is used to ensure that revenue and expenses have posted correctly.

Using Colleague's GLBA screen - (ONLINE AU_2882)

This video focuses exclusively on how run the GLBA, General Ledger Budget to Actual, report in the Colleague financial system. GLBA generates a report based on fiscal year, start and end dates, transaction dates, and General Ledger account definition. Run the report to see the Allocated Budget, Actual Expenses, Percentage Expended and Remaining Balance for an account.

General Ledger - Using the GLBR Screen in Colleague - (ONLINE AU_3581)

Use GLBR to run a report for budget line items that compares the annual allocated budget or year-to-date allocated budget to year-to-date actual activity and year-to-date encumbrance activity.

 

 

 

Duo Security Enrollment (ONLINE AU_156281)

This video explains the steps to enroll in Duo Security. Duo Security is required to access AU's Virual Private Network (VPN).

ServiceNow Knowledge Base - Interactive Training (ONLINE AU_273286)

This interactive training will show you how to create, edit and approve ServiceNow Knowledgebase articles.

Introduction to Business Intelligence (ONLINE AU_217281)

MicroStrategy Business Intelligence is used for ad hoc reporting, the generation and analysis of business analytics, and dashboards. In this training you will learn how to navigate the system and run reports.

How to Work with Enrollment Data and Business Intelligence (ONLINE AU_272292)

In this four-part online training you will learn where AU data comes from and how to use it. After completing this training you will understand key data terms, and how to use AU’s MicroStrategy BI tool to create basic enrollment reports.

Colleague and Business Intelligence (ONLINE AU_265281)

What is the difference between Colleague and Business intelligence (BI)? How do these two systems interact with each other? Ellucian Colleague and MicroStrategy Business Intelligence are two reporting systems at American University. You may encounter these systems in your daily work at the University. This video explains the inter-related functions of the two systems and the business needs they meet.

 

Pathways to Success for AU Staff

We understand that technological fluency is essential to your success as a staff member. We have charted Pathways to Success to help you strengthen your technical proficiency and assist you in meeting your professional goals. Each path provides a comprehensive approach to mastering a critical skill set. Please select a path to get started:

As a new staff member, you will be automatically enrolled in the New Staff Orientation, and you will be assigned the online course Data Security and Privacy. We also recommend that you complete the following essential courses within four months of your hire date: 

  • Outlook 2016/Outlook Web App 
  • Microsoft Teams for Working Groups

The ability to communicate and collaborate with your colleagues is vital to your success. Whether you are working in the same office or across continents, speed and accuracy is critically important. These courses provide you with the skills you need to succeed: 

  • Microsoft Teams for Working Groups
  • Office 365: OneDrive for Business and Office Web Apps 
  • Office 365: OneNote 

Integrity, consistency, and knowledge of financial data is critical to the ongoing success of American University. The following courses will provide you with the tools and information necessary to work with financial data. Please note that access to financial data requires Data Steward approval and mandatory introductory training: 

  • Introduction to Ellucian Colleague (Online)
  • Colleague General Ledger (Online)
  • Colleague Purchasing (Online)
  • Colleague Purchasing - Vendor Activity Screen (Online)
  • Colleague Purchasing - Voucher Activity Screen (Online)
  • Colleague General Ledger - Using the GLBR Screen in Colleague (Online)
  • Colleague General Ledger - GLSA Summary Activity Report (Online)
  • Budget and Financial Managment Overview (Online)
  • Introduction to Business Intelligence

AU uses the CommonSpot Content Management system to maintain and enhance the www.american.edu website. The CommonSpot training series will provide you will need to edit and manage your webpages. The series includes: 

  • CommonSpot Introduction 
  • CommonSpot Intermediate 

Captivating presentations, publications, and photos enhance the quality of your work and help spotlight your organization. These courses will help you create them: 

  • Designing with Microsoft PowerPoint
  • PowerPoint Advanced Topics
  • Design Basics – MS Publisher, Adobe InDesign and Adobe Photoshop

Whether you are new to the Microsoft Office Suite or simply looking to polish your skills, these targeted courses can help you achieve your goals: 

  • Microsoft Excel Basics
  • Microsoft Excel Intermediate
  • Microsoft Excel Advanced Topics
  • Designing Presentations with Microsoft PowerPoint
  • Microsoft PowerPoint Advanced Topics