The Microsoft Excel 2013 Advanced Level course builds upon the data organization and spreadsheet skills learned in the Introduction and Intermediate Excel 2013 courses. 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, ...more
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.
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 ...more
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 learn how to work with existing content, add elements to a page, and manage existing content.
Are you going to be contributing to a University or departmental website, using CommonSpot, American University's Content Management System? In this course, you will: complete a CMS account request, understand the layout of a webpage on www.american.edu, be able to define the parts of a CMS webpage, understand site/subsite/news/success folder navigation, edit the elements on an existing page, ...more
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.
This course is for beginners and those interested in a spreadsheet refresher course. Learn the benefits of working with Excel as well as how to create a basic Excel worksheet that combines text and numbers. ...more
Do you want to learn how to create great looking Web pages and sites? Learn 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.