In this course, you will: apply conditional formatting to emphasize specific data elements, work with comments, use Paste Special options, create dynamic named ranges, set up a basic pivot table, show data trends with sparklines, evaluate data with subtotals, work with macros and Visual Basic programming and correct worksheet errors.
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.
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 basic benefits of working with Excel and how to create and format an Excel worksheet. You will also learn how to navigate the Microsoft Excel 2010 environment, customize the Quick Access ...more
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, ...more
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.
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 ...more