Technical Training Opportunities

Technical Training Course

Free IT Training Sessions

Build the skills you need to enhance your educational and professional experience while you study, teach, or work at AU.

Register for any of the FREE technical workshops sponsored by the Center for Teaching, Research & Learning, the Office of Information TechnologyUniversity Events Scheduling, and the University Library, including the New Media Center. All courses are open to all AU faculty, staff, and students.

There are a variety of training options, so you will certainly find a course that fits both your schedule and your preferred learning style. We offer everything from basic courses to advanced workshops and from one-on-one tutorials to hands-on classroom training.



Featured Trainings

TrainUNow

Learn the new features of Microsoft Office 2013 and how it differs from Office 2010. The Office of Information Technology's (OIT) new TrainUNow program features 30-45 minutes of live demonstrations of the new features of Word 2013, Excel 2013 and Powerpoint 2013 and offers practical Office 2013 tips. TrainUNow sessions are being offered in-person and on-site: contact the OIT Training Department to schedule a technical trainer to come by your office and show your staff how to get the most productivity from the new applications. To request a TrainUNow session, contact:

  • Jackie Palumbo Director, Training and Performance Improvement, IT Customer Service 
  • 202-885-2776
  • jpalum@american.edu

Topics will include:
MS Excel 2013: Click Here for Additional Information

MS Word 2013: Click Here for Additional Information

MS PowerPoint 2013: Click Here for Additional Information

Introduction to BI Reporting

American University uses the MicroStrategy Business Intelligence tool to analyze trends, perform forecasting, create scorecards and dashboards, and proactively deliver timely information to organizations. This foundation level course will introduce you to the concept of Business Intelligence methodologies, processes, architectures, and technologies. You will learn how to run reports, use the MicroStrategy toolbar, visualize and export data, and use the History List.

Sponsored by the Office of Information Technology
View Upcoming Classes

BI Web Reporting for Analysts

BI Analysts will learn how to create and manipulate MicroStrategy reports to deliver specific data to their customers. Analysts will learn about MicroStrategy reporting objects, including attributes, facts, metrics, and hierarchies. You will discover how to manipulate application objects such as templates, filters and prompts to provide BI users with the desired data slice. You will also learn how to apply custom formatting to BI reports.

Sponsored by the Office of Information Technology
View Upcoming Classes

INTRODUCTION TO EXCEL 2013

The Introduction to Microsoft Excel 2013 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 benefits of working with Excel, how to create and format an Excel worksheet, how to navigate the Microsoft Excel 2013 environment, customize the Quick Access Toolbar and Ribbon, create a basic worksheet by entering text, values and formulas, create formulas using Excel's built-in functions, move and copy data using shortcut menus, edit data using drag and drop features, change the appearance of worksheet data using a variety of formatting techniques, apply headers and footers to the worksheet, and prepare a worksheet for printing.

Sponsored by the Office of Information Technology
View Upcoming Classes

INTERMEDIATE EXCEL 2013

The Microsoft Excel 2013 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 features; use data filters to fine tune result sets; create multi-level sort lists, remove duplicates from a list, and work with templates.

Sponsored by the Office of Information Technology
View Upcoming Classes

Advanced Excel 2013

The Microsoft Excel 2013 Advanced Level course builds upon the data organization and spreadsheet skills learned in the Introduction and Intermediate Excel 2013 courses. You will learn how to apply conditional formatting to emphasize specific data elements, work with comments, differentiate between formulas, values and formats when using the Paste Special command, create range names, set up a basic pivot table, show data trends with sparklines, evaluate data with subtotals, and correct worksheet errors.

Sponsored by the Office of Information Technology
View Upcoming Classes

INTRODUCTION TO POWERPOINT 2013

Do you need to add pizazz to your professional presentations and slide shows? Learn how to identify on-screen features; navigate through a presentation; create and edit slides; use Slide Master to format multiple slides at one time; visually enhance slides using Clip Art, Smart Art, and Word Art objects; create organization charts; create and edit graphs; run a slide show; add notes to a slide; and print presentation handouts.

Sponsored by the Office of Information Technology
View Upcoming Classes

ADVANCED POWERPOINT 2013

Take your basic PowerPoint presentations to the next level. Build upon the presentation skills learned in the introductory course. Learn how to link to a file from a slide, embed document content on a slide, add narration to a presentation, create a new Slide Master, enhance slide layouts, and add movies to slides.

Sponsored by the Office of Information Technology
View Upcoming Classes

CAYUSE

Users will learn how Cayuse, a fast, easy-to-use Web application, can simplify the creation, review, approval, and electronic submission of their grant proposals. Access to this system is granted by the Office of Sponsored Programs.

Sponsored by the Office of Information Technology
View Upcoming Classes

R25/25 LIVE

R25/25Live is the web-based application used to schedule space for campus events and publicize on the master calendar. This course will teach pre-approved Sub-Schedulers (space assigners) how to process requests, assign spaces, create new events, run space utilization reports and much more.

Enrollment questions should be directed to University Event Scheduling 202-885-3939.

INTRODUCTION TO SHAREPOINT 2010

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.

Sponsored by the Office of Information Technology
View Upcoming Classes

SHAREPOINT 2010 ADVANCED CONTRIBUTORS TRAINING

This course will build upon skills learned in the Introduction to SharePoint 2010 course. You will learn how to customize standard list templates such as the Discussion Board and Calendar templates, and how to create a custom list, You will also learn how to customize SharePoint libraries, and how to create Slide and Wiki libraries. Security and permissions will be discussed in detail, including how to set permissions on a list, library, and document.
Prerequisite: Introduction to SharePoint 2010

Sponsored by the Office of Information Technology
View Upcoming Classes

SHAREPOINT 2010 TEAM SITE ADMINISTRATION

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.

Sponsored by the Office of Information Technology
View Upcoming Classes

MICROSOFT EXCEL 2013 ADVANCED TOPICS - PART I

The Microsoft Excel 2013 Advanced Topics - Part I workshop covers in greater detail the following topics: cell formatting (fractions, shading rows, date and time, scrollable area, criteria-based custom formats), time-saving tips (fill handle, fill series, dealing with blank cells, cell values in formulas, adv. formatting, more formulas), advanced filters; naming/applying dynamic named ranges and creating a Gantt chart.

Sponsored by the Office of Information Technology
View Upcoming Classes

MICROSOFT EXCEL 2013 ADVANCED TOPICS - PART II

The Microsoft Excel 2013 Advanced Topics - Part II workshop covers in greater detail the following topics: lookups, how to use error formulas to return data, nested conditional functions, using the Slicer tool with a pivot table, macros, introduction to Visual Basic for Applications, assigning program code to a button.

Sponsored by the Office of Information Technology
View Upcoming Classes

 

Back to Top


Summary of Technical Training Opportunities

Please click on one of the training series listed below to view the full course descriptions and schedule for the upcoming training sessions. Many of the sessions require advance registration.

AU Enterprise Applications

Microsoft Office Applications

Library and Research Tools

Multimedia Applications


Back to Top


Course Descriptions for AU Enterprise Applications

Cayuse

Users will learn how Cayuse, a fast, easy-to-use Web application, can simplify the creation, review, approval, and electronic submission of their grant proposals. Access to this system is granted by the Office of Sponsored Programs.

3 Hour Instructor-Led Training Sessions
Advance Registration Required
Sponsored by the Office of Information Technology
View Upcoming Classes

Colleague Training

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 reports 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. Prerequisite: A valid Datatel account and supervisory permission is required to attend this course.

1.5 Hour Instructor-Led Training Sessions
Advance Registration Required
Sponsored by the Office of Information Technology
View Upcoming Classes

The Purchasing course provides you with an overview of the American University Purchasing Cycle and gives you hands-on experience creating purchase requisitions and researching purchase order and vendor/voucher information in the Datatel Colleague Financial System. Prerequisite: A valid Datatel account and supervisory permission is required to attend this course.

1.5 Hour Instructor-Led Training Sessions
Advance Registration Required
Sponsored by the Office of Information Technology
View Upcoming Classes


Datatel UI Training

The Introduction to Datatel UI course is an overview of the newest version of the Datatel software, known as UI. It offers a variety of features designed to enhance ease of use while maintaining the highest levels of functionality and security. This training will focus on new, time-saving features, such as how to customize the UI environment, create favorites, invoke mouse-over descriptions, and navigate screen tabs. You will also learn how to utilize these new features to maximize your efficient use of the Datatel software. This course focuses exclusively on the new features and benefits of Datatel UI, and is recommended for all current Datatel users. Completion of this introductory course is mandatory in order to obtain your Datatel credentials. Contact the IT Help Desk at 202-885-2550, helpdesk@american.edu or AskAmericanUHelp to reach one of our professional staff who can provide you with details on accessing the tutorial.

1 Hour On-line Tutorial
Sponsored by the Office of Information Technology

The Datatel Web UI 4.3 New Features video is intended to introduce current users to the exciting new features and functionality of Datatel UI 4.3. These features include:
  • Person and Organization search
  • Card View Display
  • Grid View Display
  • Mapping
  • Adding People Favorites
  • and much more!

Please note: users who are new to Datatel will need to complete the online Introduction to Datatel UI course for more in-depth instruction, before receiving their Datatel credentials.

EagleData Training

The Introduction to EagleData course is for American University employees who will be using the EagleData Warehouse. The Eagledata application provides fast and easy access to information in a self-service manner, so users can get reports when they need them. In this course, you will learn how to log on to EagleData, understand the application interface, access report links, and export a report to Microsoft Excel. Completion of this introductory course is mandatory in order to obtain your EagleData credentials. Contact the IT Help Desk at 202-885-2550, helpdesk@american.edu or AskAmericanUHelp to reach one of our professional staff who can provide you with details on accessing the tutorial.

1 Hour On-line Tutorial
Sponsored by the Office of Information Technology

Event Planner 101 Training

This course is required to gain access to the online space request form and to edit events on the Master Calendar. The program is designed for anyone on campus who requests space for events, meetings, or class-related activities scheduled in event space. Topics include: instructions for completing the space request form for the purposes of requesting space and posting to the Master Calendar, guidelines for posting events to the Master Calendar, and processes for making changes to events before and after the event has been confirmed. The course is open to faculty, staff and graduate level assistants (undergraduate assistants may attend the training on a case-by-case basis).

1.5 Hour Instructor-Led Training Session
Advance Registration Required
Sponsored by the University Events Scheduling
View Calendar for Event Planner Training Series

Faculty Activity Reporting System

Are you a faculty member that needs to add your activities to the Faculty Activity Reporting System for the annual report? Learn how to navigate this user-friendly system to record your 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. Participants will also learn how to run their annual report with a few keystrokes.

Workshop length: 1.5 hours
Advance Registration Required
Sponsored by the Office of Information Technology
View Upcoming Classes

 Lotus Notes Training

The Introduction to Lotus Notes course provides training on the industry leading groupware application facilitating data sharing and communications between staff. You will learn the basic skills and knowledge necessary to use the essential features including how to customize the components of the Notes workstation environment, manage your mail, personalize email letterhead, use address books, designate mail delivery options, secure messages, delegate mail tasks, add mail and calendar groups, use and manage a personal calendar and utilize the Out of Office agent.

The Advanced Lotus Notes course builds upon the skills learned in the Introductory course. You will learn how to search for mail messages; use advanced calendaring features; manage your To Do list; create lists with bullets, numbers, and checkmarks; and add a table, picture, and URL link to your mail messages.

2 Hour Instructor-Led Training Session for the Introductory and Advanced Course

Advance Registration Required

Sponsored by the Office of Information Technology

View Upcoming Classes  

R25/25Live

R25/25Live, is American University’s integrated web-based event scheduling application that allows events, meetings, and course sessions to be scheduled and rooms or spaces to be assigned or booked. R25/25Live is utilized for scheduling and coordination of events from simple meetings to complex conferences. This course will teach R25/25Live Sub Schedulers how to search for available spaces, reserve space, create repeating and one-time events, search for and edit scheduled events and much more.

2 Hour Instructor-Led Training Session
Advance Registration Required
Sponsored by the Office of Information Technology
View Upcoming Classes

Research Grants Reporting

Do you need help managing your research grant budget? This course will teach you how to look at the budget, expenses, and unobligated amounts for your research grant(s). See details about the funds that have already been spent, view purchase order encumbrances, learn about the option to model unobligated funds into the future

(Prerequisite: A valid Microstrategy account)

2 Hour Instructor-Led Training Session
Advanced Registration Required
Sponsored by the Office of Information Technology
View Upcoming Classes

Introduction to Sharepoint 2010

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.

Sponsored by the Office of Information Technology
View Upcoming Classes

SharePoint Advanced Contributors Training

This course will build upon skills learned in the Introduction to SharePoint 2010 course. You will learn how to customize standard list templates such as the Discussion Board and Calendar templates, and how to create a custom list, You will also learn how to customize SharePoint libraries, and how to create Slide and Wiki libraries. Security and permissions will be discussed in detail, including how to set permissions on a list, library, and document.
Prerequisite: Introduction to SharePoint 2010

Sponsored by the Office of Information Technology
View Upcoming Classes

Sharepoint 2010 Team Site Administration

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.

Sponsored by the Office of Information Technology
View Upcoming Classes

Back to Top


Course Descriptions for Library and Research Tools

EViews Training

The Introductory and Intermediate workshops introduce EViews, a software application that blends the best of modern spreadsheet and relational database technology with the traditional tasks of statistical software.

1 Hour Instructor-Led Training Session
Walk-ins Welcome
Sponsored by the Center for Teaching, Research & Learning
View Calendar for EViews Training Series


SAS Training

The Introductory and Intermediate workshops introduce the Statistical Analysis System (SAS). SAS is a tool for data management and production of descriptive and inferential statistics, which is particularly suited for use with large databases and has advanced modeling and simulation features.

1 Hour Instructor-Led Training Session
Walk-ins Welcome
Sponsored by the Center for Teaching, Research & Learning
View Calendar for SAS Training Series


SPSS Training

The Introductory and Intermediate workshops introduce the Statistical Package for the Social Sciences (SPSS). SPSS is a statistical analysis tool for data management and production of descriptive and inferential statistics. SPSS has modeling capabilities and a comprehensive system for a variety of statistical analyses and is most useful in analyzing survey data.

1 Hour Instructor-Led Training Session
Walk-ins Welcome
Sponsored by the Center for Teaching, Research & Learning
View Calendar for SPSS Training Series


STATA Training

The Introductory and Intermediate workshops introduce STATA. This complete, integrated statistical package provides everything you need for data analysis, data management, and graphics.

1 Hour Instructor-Led Training Session
Walk-ins Welcome
Sponsored by the Center for Teaching, Research & Learning
View Calendar for STATA Training Series


Back to Top


Course Descriptions for Microsoft Office Applications

Microsoft Excel 2013 Training

In the Microsoft Excel 2013 Introduction Level class you will learn to navigate the Microsoft Excel environment; create a basic worksheet by entering text, values and formulas; create formulas using Excel's built-in functions; move and copy data using shortcut menus; edit data using drag and drop features; change the appearance of worksheet data; apply headers and footers to the worksheet; and prepare a worksheet for printing.

Grow your expertise with Excel in the Microsoft Excel 2013 Intermediate Level course. Learn how to work with multiple worksheets in a single workbook, control the appearance of worksheet data, organize data using charting features, add three-dimensional references to formulas, consolidate data, format worksheet numbers in a variety of styles, use data filters, sort lists, remove duplicates from a list, and work with templates.

In the Microsoft Excel 2013 Advanced Level course you will build upon the data organization and spreadsheet skills learned in the introductory and intermediate courses. Learn how to customize the Excel environment; apply conditional formatting to emphasize specific data elements; work with comments; differentiate between formulas, values, and formats when using the Paste Special command; create range names; work with pivot tables; evaluate data with subtotals; and correct worksheet errors.

3 Hour Instructor-Led Training Sessions
Advance Registration Required
Sponsored by the Office of Information Technology
View Upcoming Classes

Microsoft Office 2013 New Features Training

The Microsoft Office 2013 - New Features class is intended to introduce current users to the exciting new features and functionality of Office 2013. Office 2013 offers new design options to help you express your ideas with more impact. Some of these new options include new and improved picture formatting tools, a wider range of new customizable themes, and a greater selection of SmartArt graphic layouts. This new class will introduce you to the enhanced functionality of the Office 2013 suite of programs. This course is designed for experienced Microsoft Office users who have worked with earlier versions of Microsoft Word, Microsoft Excel, and Microsoft PowerPoint and who have or are planning to upgrade to Microsoft Office 2013.

1.5 Hour Instructor-Led Training Session
Advance Registration Required
Sponsored by the Office of Information Technology
View Upcoming Classes


Microsoft PowerPoint 2013 Training

The Introduction to Microsoft Powerpoint 2013 course illustrates why PowerPoint is such a powerful tool to create professional looking presentations and slide shows. This course will teach you how to identify on-screen features, navigate through a presentation, create new slides and edit existing ones, use Slide Master to format multiple slides at one time, visually enhance slides using Clip Art, Smart Art and Word Art objects, create organization charts, create and edit graphs, run a slide show, add notes to a slide, and print presentation handouts.

The Microsoft Powerpoint 2013 Advanced Level course builds upon the presentation skills learned in the Introduction course. You will learn how to link to a file from a slide, embed document content on a slide, add narration to a presentation, create a new Slide Master, enhance slide layouts, and add movies to slides.

3 Hour Instructor-Led Training Sessions
Advance Registration Required
Sponsored by the Office of Information Technology
View Upcoming Classes


Back to Top


Course Descriptions for Multimedia Applications

Adobe Photoshop Training

The Introduction to Adobe Photoshop course provides an overview of this professional graphics and image-editing software application. You will learn the basic techniques of graphic manipulation including how to adjust the color of photographs, drawings, and other images, crop and recast the image, create web-ready graphics, use the painting and editing tools, add filters to images, and save images in various graphics formats.

The Advanced Adobe Photoshop course will build on the skills learned in the Introduction course. You will learn how to create and use masks and buttons, retouch and repair images, and remove red-eye. You will also learn how to automate a multi-step task and create a web-gallery album.

3 Hour Instructor-Led Training Session
Advance Registration Required
Sponsored by the Office of Information Technology
View Upcoming Classes



CommonSpot Training

The Introduction to CommonSpot course is the first class in a series that will introduce you to CommonSpot, American University's Content Management System. This class will discuss CommonSpot access, user roles, page types, and image requirements. You will learn to log on to the system, and create News and Success Stories based on AU Content Templates. You will also learn how to import images into CommonSpot and modify them to meet CommonSpot requirements.

The Intermediate CommonSpot course builds upon the skills learned in the Introduction to CommonSpot course. You will learn how to create a custom landing page, or entry point into your departmental web site. You will also learn how to create custom elements, including: a hero filmstrip, touts, and quicklinks.

The Advanced CommonSpot course is for American University staff who will serve as departmental contributors to CommonSpot, American University's Content Management System. This third class in a series will build upon skills learned in the Intermediate CommonSpot class. You will learn how to add video media elements to your Web page, edit the left navigation for your subsite, manage Web profiles and departmental data, create a simple form, and create a calendar page for your subsite.

The CommonSpot New Features video online course will introduce you to the time-saving new features of CommonSpot 6.2.. You will learn about the ribbon-like user interface, easier to find pages and uploaded documents, the improved Rich Text Editor, and more.

2 Hour Instructor-Led Training Session for Introductory Course
3 Hour Instructor-Led Training Session for Intermediate and Advanced Course
Advance Registration Required
Sponsored by the Office of Information Technology
View Upcoming Classes


Dreamweaver/Web Design Training

The Introduction to Dreamweaver course will teach you how to use an HTML editor to create great looking Web pages, even if you don’t know any HTML. You will learn the basics of Dreamweaver including how to create simple web pages, work with hyperlinks, format text to visually enhance a web page, create a mail link, add graphics and manage your web files using the site window.

The Dreamweaver Advanced Level course will build on content learned from the Introduction class. You will learn how to create rollovers, create a navigation bar, create Flash text and buttons, create Library items, create templates, and upload files to a website.

3 Hour Instructor-Led Training Sessions
Advance Registration Required
Sponsored by the Office of Information Technology
View Upcoming Classes


Back to Top