Excel Advanced: Pivot Tables/Charts and Macros
Learn how to summarize, analyze, and present data with pivot tables and pivot charts. Also learn how to automate tasks with Excel macros.
PowerPoint: Add the “WOW” Factor to Presentations
Learn how to quickly add slides to a presentation using Word outlines and the duplicate and reuse slides features. Use Slide Masters to add content to all presentation slides (for example, a company logo). In addition, add interest and impact to your presentations using charts, SmartArt, images, audio, video and animation.
Outlook: Beyond the Basics
The course will cover how to use Outlook to schedule calendar appointments and meetings and share calendars; create, update and manage tasks; and use advanced email organization features, such as Quick Steps and Rules.
Learn how to work in a Documents Library to edit, upload, search for, and set alerts for documents. In addition, use lists such as calendars, tasks, announcements and discussion boards.
Advanced Excel: Formulas, Forecasts and Macros
Learn how to create advanced functions and formulas including logical, statistical, math and lookup functions. Analyze worksheet data with Data Analysis scenarios, data tables and goal seek. In addition, learn how to automate Excel tasks with macros.