- Teacher: Josh Bouthot
- Teacher: Josh Bouthot
In Outlook 2010 Essential Training, author Karen Fredricks provides in-depth instruction on the key features of Outlook 2010. The course shows how to master fundamental Outlook features including sending and receiving email, creating an address book, and scheduling activities and tasks. It also covers basic administrative tasks including backing up the data file, setting up email accounts, and organizing data both manually and automatically.
Topics include:
- Using the Office 2010 Backstage View
- Using and customizing the Office 2010 Ribbon
- Using Outlook as an email client
- Filtering email with Quick Steps
- Scheduling with multiple calendars
- Creating tasks for to-do items
- Taking notes
- Adding multiple addresses and phone numbers for contacts
- Reading blog posts
- Integrating with social networking sites
- Teacher: Josh Bouthot
In PowerPoint 2010 Essential Training, author David Diskin demonstrates how to engage an audience with images, video, sound, charts, and diagrams in professional presentations. The course also covers a variety of methods to share presentations with others, and provides comprehensive tutorials on how to design presentations that successfully deliver a quality message. Exercise files accompany the course.
Topics include:
- Using the Office 2010 Backstage View
- Using and customizing the Office 2010 ribbon
- Starting a presentation from scratch
- Applying slide layouts for consistency
- Rearranging slides
- Running a presentation for an audience
- Formatting with font, color, bullets, and alignment
- Adding and customizing photos, clip art, shapes, audio, and video
- Applying picture effects such as background removal, brightness, and color effects
- Modifying slide masters
- Adding a logo to the background
- Adding and customizing tables, charts, diagrams, and data from Excel
- Printing a presentation
- Sharing a presentation with others through video, the web, SharePoint, and PDF
- Teacher: Josh Bouthot
In Excel 2010 Essential Training, Bob Flisser demonstrates the core features and tools in Excel 2010. The course introduces key Excel skills, shows how to utilize these skills with in-depth tutorials on Excel functions and spreadsheet formatting. It also covers prepping documents for printing, working with large worksheets and workbooks, collaborating with others, using Excel as a database, analyzing data, charting, and automating and customizing Excel. Exercise files are included with the course.
Topics include:
- Copying and pasting techniques
- Working with formulas and functions
- Dealing with formula errors
- Creating lookup tables
- Naming cell ranges
- Formatting data and worksheets
- Finding and replacing data
- Creating SmartArt diagrams
- Creating charts and PivotTables
- Recording macros
- Sharing workbooks
- Teacher: Josh Bouthot
In Word 2010 Essential Training, Gini Courter uses real-world examples to teach the core features and tools in Word 2010. The course starts off with an orientation of the Word 2010 interface, and then delves into the functionality at the heart of Word: creating, editing, and formatting documents. It also covers proofing documents, reviewing documents with others, sharing and securing documents, working with tables, and illustrating documents. Exercise files are included with the course.
Topics include:
- Creating documents with templates
- Adding SmartArt diagrams to documents
- Working with fonts
- Setting up document styles
- Formatting headers, footers, and cover pages
- Organizing text in tables
- Modifying page layout, including margins, orientation, and page size
- Tracking changes and showing markup
- Sharing documents