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.

Participants in this workshop will learn about the collaborative tools supported by the Office of Information Technology. This introductory course provides a broad overview of AU's cloud technology, including SharePoint, OneDrive for Business, Skype for Business, OneNote, Yammer, and the Office 365 web applications (Word, Excel, and PowerPoint). 

You’ll analyze your team’s technology needs, learn how to apply the appropriate tools, and evaluate the impact of collaborative tools on your team's work processes. 

This is a virtual course; the information for accessing this online training will be provided to you by the instructor.

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.


CommonSpot - Content Redesign
Existing CommonSpot users will learn how to redesign a webpage to make it nondiscriminatory to persons with disabilities, as well as to create engaging content using the new responsive elements. 

Content will include: TextBlock, Links (local vs. global), Colored Background Section with Collapsibles, Flex vs. Grid Containers, Image Touts, Highlight Strip, Tab Containers, using the MS Accessibility Checker to convert Word documents to PDFs. You must currently be a user of CommonSpot to enroll in this course.

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.

Excel - Basic Formatting
Participants in this workshop will manipulate cell/column/row contents, apply various formatting styles to both text and numbers, view selected portions of data vs. 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 - Financial Functions and the Visual Basic Editor
Participants in this workshop will use Excel, as a financial calculator to solve Time Value of Money (TVM) problems, find input values of desired results with the What-If analysis tool set, identify variances in a range of values with conditional formatting, and automate tasks using Excel's programming language - VBA.

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 vs. Absolute Cell References, streamline existing formulas with shortcut techniques, control the type of data entered in a cell, and automate repetitive tasks with simple macros.

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.



Participants in this workshop will use the MicroStrategy Business Intelligence tool to analyze data in pre-defined reports, using standard features such as: page-by, visual threshold editor, sort, filter, and drill. Participants will also create custom Personal Views, print and export data, and automate reporting tasks by establishing an Email Subscription and a History List.

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 and Sway applications.

This course is offered both as a classroom-based and virtual course. If you enroll in the virtual course, the information for accessing this online training will be provided to you by the instructor.

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.  


This course is offered both as a classroom-based and virtual course. If you enroll in the virtual course, the information for accessing this online training will be provided to you by the instructor.

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

This course is offered both as a classroom-based and virtual course. If you enroll in the virtual course, the information for accessing this online training will be provided to you by the instructor.

PowerPoint - Introduction
Participants in this workshop will insert text and images to slides, change the styles of those objects with the contextual tools tabs, learn the difference between and when to use: transitions and animations, customize and execute a slide show, save a presentation in a variety of formats, and collaborate on presentations using Office 365.

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.

SharePoint Essentials - Virtual Class 
Participants in this workshop will learn the benefits of using SharePoint for departmental use and as a portal platform, navigate common site elements including: lists, tasks, and items, sort and filter data in site elements, manage calendar events, collaborate with coworkers via discussion boards, share documents including: version history, check-out process, alerts, document links, and folder structures, and customize application settings. 

This is a virtual course; the information for accessing this online training will be provided to you by the instructor.  


SharePoint Team Site Owner - Virtual Class

Participants in this workshop will design and implement a portal structure using SharePoint 2013 objects including sites, libraries, lists and pages, explain the role of security and permissions throughout SharePoint, enhance the design of and content on a site using themes and web parts, explain the importance of and the role of social networking in SharePoint and its impact on collaboration. 

This is a virtual course; the information for accessing this online training will be provided to you by the instructor.

Participants in this workshop will learn to use Skype for conducting online meetings, messaging calls, and video; setup contact groups and use the directory to communicate via instant messaging with team members; and schedule Skype meetings in Outlook.

This is a virtual course; the information for accessing this online training will be provided to you by the instructor.

VIDEO COURSES

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.

Colleague UI 4.5 - Introduction 
Learn to customize the UI environment, create favorites, invoke mouse-over descriptions and navigate screen tabs. Also learn about the Colleague UI Person and Organization search, Card View display, Grid View display, Mapping and adding People Favorites. To view this video course, prior approval from the Help Desk (202-885-2550) is required.

Colleague UI 4.5 - General Ledger 
Learn to manager your department's financial date, perform standard look-ups such as GLST, ACBL, and AHST, run reports including LGLA, GLSA, GLBR, and XGAR, and receive an overview of the Budget Cycle (key dates and events within the cycle).

Colleague UI 4.5 - Puchasing 
Learn to create purchase requisitions and research purchase order and vendor/voucher information.

DUO verifies your identity with two-factor authentication, before connecting to AU's Virtual Private Network (VPN). This video describes the enrollment process, as well as the process for using DUO to securely access the VPN.

Learn the logon process to EagleData, understand the application interface, access report links, and export a report to MS Excel. To view this video course, prior approval from the Help Desk (202-885-2550) is required.

Learn to navigate this user-friendly system to record annual activities, such as: teaching and advising, published and in-process research, creative and professional activities, grants, lectures and conferences, and internal and external activities.

Learn how the powerful Entrinsik Informer reporting tool provides you with access to real-time data from one or more databases through an intuitive web interface. Navigate the tool, search for reports, and export results into multiple formats. Analyze results by filtering, graphing, and exporting the data.

Learn to analyze data in pre-defined reports, using standards features, such as: page-by, visual threshold editor, sort, filter, and drill.

Learn how the Ellucian CRM Recruit solution supports the entire recruiting and admissions lifecycle. Recruit streamlines admissions operations, while providing an engaging, personalized web experience for prospective students. Ellucian CRM Recruit is designed to help you find the best prospects, engage them more successfully, improve enrollment results, and manage the recruitment cycle more efficiently and effectively.