This excellent Office 2007 course will get you up to speed with this outstanding software suite. During the course you will learn tips for using each product as well as how to create an integrative workflow amongst all the applications. The course has been created by an expert instructor with years of experience, as you can imagine, you will be given an abundance of insider knowledge and tips.
Our learning material is available to students 24/7 anywhere in the world, so it’s extremely convenient. These intensive online courses are open to everyone, as long as you have an interest in the topic! We provide world-class learning led by IAP, so you can be assured that the material is high quality, accurate and up-to-date.
Geoff Blake is a Toronto-based author, trainer, designer, and artist. For the past ten years, he’s provided a wide range of graphic design, artwork, consulting, in-class training, and web design services.
A professional public speaker since 1997, Geoff has taught desktop publishing, web design ,and graphics courses in both the corporate and post-secondary environments, working closely with some of the largest training providers and colleges in the Toronto area. His appearances, in-class training, and consulting have taken him throughout North America, where he’s built a solid reputation for delivering otherwise jargony material in a fun, enjoyable, and entertaining way. With his diverse print and web experience, he regularly contributes to magazines and web sites, and is currently working on a series of print, web, and design books—penning Ten Ton Dreamweaver in 2006 with Peachpit Press, and following up with Ten Ton Flash, which is in current production.
Geoff is very comfortable with modern digital and pre-press print preparation, cutting edge web design techniques, and software/hardware troubleshooting. Throughout his career, he’s provided expert training and support for a variety of applications, including Microsoft Office, Dreamweaver, Flash, Photoshop, Acrobat, InDesign, Illustrator.
You can visit Geoff online at tentonbooks.com, where he posts his latest tricks, techniques, reviews, and other discoveries in the ever-expanding world of technology.
Those who successfully pass this course will be awarded a Office 2007: Getting Up to Speed certificate. Anyone eligible for certification will receive a free e-certificate, and printed certificate.
With this qualification, you are able to fulfil various roles in a range of industries, such as:
PLEASE NOTE: We do not provide any software with this course.
1: GETTING STARTED WITH WORD | |||
1. Touring the New Office 2007 Interface | |||
2. Formatting Basic Text | |||
3. Applying Formatting to a Paragraph | |||
4. Creating Bulleted & Numbered Lists | |||
5. Working with Styles | |||
6. Making Changes to the Styles | |||
7. Saving & Removing Formatting | |||
8. Changing Style Sets | |||
9. Proofing Your Work | |||
2: REFINING WORD® DOCUMENTS | |||
1. Adding Headers & Footers | |||
2. Inserting Watermarks | |||
3. Formatting the Overall Document | |||
4. Inserting Graphical Elements | |||
5. Inserting Clip Art | |||
6. Using SmartArt | |||
7. Inserting Tables | |||
8. Formatting Tables | |||
9. Creating a Cover Page with Themes | |||
10. Saving a Document | |||
11. Outputting to PDF | |||
3: EXPLORING EXCEL® | |||
1. Touring the Excel Interface | |||
2. Inserting, Moving & Selecting Content | |||
3. Format Numerical Data & Reference Cells | |||
4. Building a Table & Using AutoFill | |||
5. Inserting & Deleting Rows & Columns | |||
6. Introducing Formulas | |||
7. Introducing Functions | |||
8. Using the Insert Function Dialog Box | |||
9. Using Statistical Functions & the Status Bar | |||
10. Using Auditing Commands | |||
11. Exploring Absolute Cell Referencing | |||
12. Naming Cell Ranges & Using Name Manager | |||
13. Pasting Data & Using the Clipboard | |||
4: FORMATTING & STYLIZING IN EXCEL® | |||
1. Formatting Cells | |||
2. Using Format Painter | |||
3. Number Formatting | |||
4. Using Cell Styles | |||
5. Creating Cell Styles | |||
6. Changing Styles | |||
7. Using & Creating Table Styles | |||
8. Filtering a Table Layout | |||
9. Using Conditional Formatting | |||
10. Formatting Worksheets with Themes | |||
11. Inserting Graphical Elements | |||
12. Managing Multiple Worksheets | |||
13. Outputting a Document | |||
14. Saving a Document | |||
5: POWERING UP WITH POWERPOINT® | |||
1. Touring the PowerPoint Interface | |||
2. Formatting Text | |||
3. Changing the Slide Layout | |||
4. Adding Additional Slides | |||
5. Creating a Slide Design | |||
6. Customizing Slides | |||
7. Inserting Objects | |||
8. Using SmartArt | |||
9. Creating & Formatting Charts | |||
10. Using WordArt Styles | |||
11. Changing Chart Types | |||
12. Applying Themes | |||
13. Setting Animation Effects | |||
14. Working with Different Views | |||
15. Setting Up a Slide Show | |||
16. Running a Slide Show | |||
17. Outputting a Presentation | |||
6: STAYING CONNECTED IN OUTLOOK® | |||
1. Touring the Outlook Interface | |||
2. Using E-mail | |||
3. Creating Signatures & New Folders | |||
4. Using a Calendar & Adding Events | |||
5. Working with Multiple Calendars | |||
6. Sharing Calendars | |||
7. Adding & Viewing Contacts | |||
8. Creating, Viewing & Flagging Tasks | |||
7: MANAGING DATA WITH ACCESS™ | |||
1. Introducing Access & Touring the Interface | |||
2. Adding & Deleting Contacts | |||
3. Filtering Data | |||
4. Creating & Exporting Forms | |||
5. Creating Reports | |||
6. Exporting Data | |||
8: A SEAMLESS OFFICE 2007 WORKFLOW | |||
1. Formatting & Sorting Data | |||
2. Using Freeze Panes | |||
3. Grouping Data into Outlines | |||
4. Creating Charts in Excel | |||
5. Sharing Workbooks | |||
6. Using Excel with Word | |||
7. Protecting a Document | |||
8. Using Cross-References | |||
9. Inserting Objects | |||
10. Using Excel with PowerPoint | |||
11. Publishing Handouts to Word | |||
12. Going from Word to Outlook | |||
13. Sending Invites with Outlook | |||
14. Sending Meeting Requests | |||
15. Final Comments & Credits |