The Advanced CommonSpot course is for American University staff who will serve as departmental contributors to CommonSpot, American University's Content Management System.
In this course, add video to a News template and as an element on a webpage, edit the left navigation bar, create a form with fields for visitor input, customize Twitter and Facebook elements, update staff/faculty profile ...more
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