Register for any of the FREE technical workshops sponsored by the Center for Teaching, Research & Learning, the Office of Information Technology, University 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
Updated for Microsoft Office version 2010!INTRODUCTION TO EXCEL 2010
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 benefits of working with Excel, how to create and format an Excel worksheet, how to navigate the Microsoft Excel 2010 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 Calendar for Excel Training Series
INTERMEDIATE EXCEL 2010
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 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 Calendar for Excel Training Series
Advanced Excel 2010
The Microsoft Excel 2010 Advanced Level course builds upon the data organization and spreadsheet skills learned in the Introduction and Intermediate Excel 2010 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 Calendar for Excel Training Series
INTRODUCTION TO POWERPOINT 2010
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 Calendar for Powerpoint Training Series
ADVANCED POWERPOINT 2010
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 Calendar for Powerpoint Training Series
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 Calendar for Cayuse Training Series
MICROSOFT EXCEL 2010 ADVANCED TOPICS - PART I
The Microsoft Excel 2010 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 Calendar for Excel Training Series
MICROSOFT EXCEL 2010 ADVANCED TOPICS - PART II
The Microsoft Excel 2010 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 Calendar for Excel Training Series
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 Calendar for Cayuse Training Series
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 Calendar for Colleague Training Series
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 Calendar for Colleague Training Series
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
- 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.
1.5 Hour Instructor-Led Training Session
Advance Registration Required
Sponsored by the Office of Information Technology
View Calendar for Datatel UI Training Series
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 Calendar for FARS - Faculty Activity Reporting System
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 CourseAdvance Registration Required
Sponsored by the Office of Information Technology
View Calendar for Lotus Notes Training Series
R25 - Resource 25
R25, is American University’s integrated event scheduling application that allows events, meetings, and course sessions to be scheduled and rooms or spaces to be assigned or booked. R25 is utilized for scheduling and coordination of events from simple meetings to complex conferences. This course will teach R25 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 Calendar for R25 - Resource 25 Training Series
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 Calendar for Research Grants Reporting Series
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 2010 Training
In the Microsoft Excel 2010 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 2010 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 2010 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 Calendar for Microsoft Excel Training Series
Microsoft Office 2010 New Features Training
The Microsoft Office 2010 - New Features class is intended to introduce current users to the exciting new features and functionality of Office 2010. Office 2010 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 2010 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 2010.
1.5 Hour Instructor-Led Training Session
Advance Registration Required
Sponsored by the Office of Information Technology
View Calendar for Microsoft Office New Features Training Series
Microsoft PowerPoint 2010 Training
The Introduction to Microsoft Powerpoint 2010 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 2010 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 Calendar for Microsoft PowerPoint Training Series
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 Calendar for Adobe Photoshop Training Series
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.
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 Calendar for CommonSpot Training Series
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 Calendar for Dreamweaver Training Series
Back to Top
