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
Use Photoshop to create perfect compositions, vivid collages, and breathtaking scenes. Learn about the more sophisticated features of Adobe Photoshop, including flexible layers and precise selection and masking tools that help you design images to make your visions real. Explore ways to retouch and repair images, automate tasks, and create a web gallery album.
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 and view alternate ways .pdf files can be viewed.
American University uses the MicroStrategy BI tool to analyze trends, perform forecasting, create scorecards and dashboards, and proactively deliver timely information to users both within and outside the organization. In this course, you will use interactive reports or key performance indicator dashboards without changing the report structure or content, and tailor interactive reports by ...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.