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/Technology Training. 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 below of the free technical training workshops offered by OIT for staff, faculty, and students.

Participants in this workshop will identify the collaborative tools available through the Office of Information Technology. This is an introductory course that provides a broad overview of the University's cloud technology, including SharePoint, OneDrive for Business, Skype for Business, OneNote, Yammer, and the Office Web Apps (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 American University'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 American University'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 PDF's.
Commonspot - Content Redesign
Existing Commonspot users will learn how to redesign a webpage to make it nondiscriminatory to persons with disabilities, and to create engaging content using the new responsive elements. Content will include: TextBlock, Links (local vs. global), Colored Background Section w/collapsibles, Flex vs Grid Containers, Image Touts, Highlight Strip, Tab Containers, using the MS Accessibility Checker to convert Word documents to PDF’s. 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; and 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, 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 Apps
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 Web Apps of Word, Excel, Powerpoint and Sway. OFFICE 365:

Office 365: OneDrive for Business and Office Web Apps
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 Web Apps of Word, Excel, Powerpoint and Sway.

This is a 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, increase productivity by quickly finding information with tagged notes.  
OFFICE 365: ONENOTE - VIRTUAL CLASS 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, increase productivity by quickly finding information with tagged notes. 
This is a 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). 
Outlook 2016 and Outlook Web App - Virtual Class 
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 is a 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 app 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 UIPerson and Organization search, Card View display, Grid View display, Mapping and adding People Favorites. To view this video course, prior approval from the HelpDesk (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 American University's Virtual Private Network (VPN). This video describes the enrollment process and the process for using DUO in collaboration with the Pulse Connect application 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 HelpDesk (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.