courses / products
View Complete List...
View Complete List...
View Complete List...
View Complete List...
View Complete List...
View Complete List...
View Complete List...
View Complete List...
View Complete List...
View Complete List...
View Complete List...
View Complete List...
View Complete List...
SUBSCRIBE
Subscribe to Receive Special Offers & New Release Updates
100% Satisfaction Guaranteed

CareerVision is committed to providing our customers with the best service and products available.

We back our training products with a 100% Satisfaction or Your Money Back Guarantee, so you can buy worry free. More....



FAST UK DELIVERY
Order Today, Learn Tomorrow!

Pay as You Learn

SECURE PAYMENT
PROCESSING


We Accept All Major Credit Cards, PayPal and Google Checkout

Credit Cards Accepted
PayPal Accepted



Follow us on Facebook

Office 2007 Getting up to Speed

 
Bookmark and Share
MS Office 2007 Getting up to Speed Training DVD-ROM
Save 20% on Total Training
All Access Online Subscriptions

12 Months - Only £127
6 Months - Only £79
Office 2007 Getting up to Speed
 


PACKAGE INCLUDES

 •  Format - DVD-ROM
 •  Duration - 6 Hours of Beginner to Intermediate Training
 •  Author - Geoff Blake
 •  Platform - Windows
 •  Project Files - Included

 

COURSE INTRODUCTION

These tutorials make all programs in Microsoft Office 2007 a breeze to use. You are introduced to the new interfaces and taught how to use each application's key features. This includes how to save time creating shortcuts for formatting Word documents, spreadsheets, and presentations. Plus, see how to manage your email, calendar, and list of contacts. Learn how to use Office 2007 efficiently and effectively with minimal effort now!


Highlights

Microsoft Word
 •  Get to know Word's new Ribbon-based interface and streamline common edits
        by learning shortcuts for selecting, moving, copying, and replacing text.
 •  Learn how easy it is to standardize page layouts with indents, spacing, and tabs.
 •  Harness the power of Word's styles to quickly format and control the look of your
        overall document; then use 2007's latest Style features to go even further.

Microsoft Excel
 •  Find out how to use Excel to create a new spreadsheet and add a new worksheet
        within the same file.
 •  Get up to speed on how to work with and format cell contents and worksheets
        for easy reading.
 •  Learn how to build lists, sort, and filter for quick access to important data;
        e.g. sales leads.

Microsoft PowerPoint
 •  Manage Layouts, Themes, and Colors to save time with each new project.
 •  See how to insert Smart Art objects, graphs, and organizational charts,
        plus add animation effects to make your presentations come to life.
 •  Sit back and watch as your presentation runs itself with the numerous options and
        timing settings. You can even convert your presentation to a website or a PDF.

Workflow
 •  Get better at using charts and similar content taken from an Excel spreadsheet.
 •  Find out tricks for sharing content between Word, Excel, and PowerPoint.
 •  Share your work via Outlook with your newly created address book of contacts;
        then setup meetings and appointments in multiple calendars.

Introducing Total Training Online


 

COURSE OUTLINE

Lesson 1: GETTING STARTED WITH WORD (33 min)
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

Lesson 2: REFINING WORD DOCUMENTS (45 min)
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

Lesson 3: EXPLORING EXCEL (77 min)
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

Lesson 4: FORMATTING & STYLIZING IN EXCEL (68 min)
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

Lesson 5: POWERING UP WITH POWERPOINT (60 min)
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

Lesson 6: STAYING CONNECTED IN OUTLOOK (25 min)
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

Lesson 7: MANAGING DATA WITH ACCESS (21 min)
1. Introducing Access & Touring the Interface
2. Adding & Deleting Contacts
3. Filtering Data
4. Creating & Exporting Forms
5. Creating Reports
6. Exporting Data

Lesson 8: A SEAMLESS OFFICE 2007 WORKFLOW (50 min)
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


 

 
 
Print Image Printer friendly version   
Top of page
A-Z COURSE LIST   PROVIDERS   CBT TRAINING  CVISION NEWS  CONTACT US   SITEMAP  

MCITP Training Courses  MCPD Training Courses  MCTS Training Courses
MCITP Database Developer Training Courses  MCITP Database Administrator Training Courses
Flash Tutorials & Training Courses  MCSE CBT Training Adobe Photoshop Tutorials & CBT Training Microsoft Certification Training

CareerVision
61 Caroline Street, Birmingham, B3 1UF, UK
Tel: 0121 248 2400, Fax: 0121248 2800,
Email: sales@cvision.co.uk |Web: www.cvision.co.uk

red arrow Website design by Aimpro UK red arrow Terms