MS Office 2007 Getting Up to Speed Online Course

0( 0 REVIEWS )

371 STUDENTS

ACCREDITED BY

Buy Now

Overview:

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.

What skills will I gain?

Get to know Word’s new Ribbon-based interface and streamline common edits by learning shortcuts for selecting, moving, copying, and replacing text
Find out how to use Excel to create a new spreadsheet and add a new worksheet within the same file
Manage Layouts, Themes, and Colours to save time with each new project
Get better at using charts and similar content taken from an Excel spreadsheet

Meet the Instructor:

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.

Course Outline:

Module 01: Getting Started With Word
Module 02: Refining Word® Documents
Module 03: Exploring Excel®
Module 04: Formatting & Stylizing In Excel®
Module 05: Powering Up With Powerpoint®
Module 06: Staying Connected In Outlook®
Module 07: Managing Data With Access™
Module 08: A Seamless Office 2007 Workflow

How will I be assessed?

You will have one assignment. Pass mark is 65%.
You will only need to pay £19 for assessment.
You will receive the results within 72 hours of submittal, and will be sent a certificate in 7-14 days.

What Certification am I going to receive?

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.

What are requirements?

You must be 16 or over
You should have a basic understanding of English, Maths and ICT
You will need a computer or tablet with internet connection (or access to one)

What careers can I get with this qualification?

With this qualification, you are able to fulfil various roles in a range of industries, such as:

Bookkeeping
Accounting
Office
Business
Entrepreneurship

PLEASE NOTE: We do not provide any software with this course.

Key Features

Gain an accredited UK qualification

Access to excellent quality study materials

Learners will be eligible for TOTUM Discount Card

Personalized learning experience

One year’s access to the course

Support by phone, live chat, and email

Course Curriculum Total Units : 93

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