Participants in this workshop will identify the collaborative tools available through the Office of Information Technology, including SharePoint, and Office 365. 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 menubar 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.
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, and work with the HTML editor. Participants will also use the News template to quickly add content to a site, and filter a news element to display only selected content created via the News template.
Commonspot – Advanced
Learn to enhance the visual design of a webpage using American University’s content management system, Commonspot. Using a responsive template, participants will manage web layouts and elements that facilitate the viewing of a webpage on any device: desktop computer, laptop, iPad, or smart phone.
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 – 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.
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.
Participants in this workshop will customize Office 365 options and learn the top features of Mail, Calendar, personal OneDrive, OneDrive for Business, and OneNote. Also featured will be the collaborative use of the cloud versions of Word, Excel and Powerpoint.
Introduction to MicroStrategy BI
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.
MicroStrategy BI Reporting
Participants in this workshop will learn to create new reports using both a blank template and by editing an existing report, and format a report using: autostyle, banding, conditional formatting, advanced threshold editor, totals and adding new metrics.
Introduction to PowerPoint
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.
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
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 for Team Site Owners
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.
Design Basics – MS Publisher, Adobe InDesign, Photoshop
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.
Skype for Business
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.
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.
Faculty Activity Reporting Reporting System
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.
Introduction to BI Reporting
Learn to analyze data in pre-defined reports using standards features such as page-by, visual threshold editor, sort, filter, and drill.
Introduction to Colleague UI 4.5
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.
Introduction to Eagledata
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.
Colleague 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).
Learn to create purchase requisitions and research purchase order and vendor/voucher information.
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.
DUO Multi-Factor Authentication Application
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 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.