X Online Skill Test

Arrange for a Callback

Name   Mobile
Email
Call us at:- +91-9958934646
Go

Create a free profile as



Sample Certificate

international-students
Office_2007_GettingUp_Speed.jpg

Office 2007: Getting Up to Speed

Indian : Rs.3068
International : $47
INTRODUCTION
Learn how to use Microsoft Office 2007 efficiently and effectively with minimal effort now! You’ll learn tips for using each product as well as how to create an integrative workflow amongst all the applications.
OBJECTIVE
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.
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.
CONTENT
Chapter I: GETTING STARTED WITH WORD (33 min)
  • Touring the New Office 2007 Interface
  • Formatting Basic Text
  • Applying Formatting to a Paragraph
  • Creating Bulleted & Numbered Lists
  • Working with Styles
  • Making Changes to the Styles
  • Saving & Removing Formatting
  • Changing Style Sets
  • Proofing Your Work

Chapter II: REFINING WORD® DOCUMENTS (45 min)
  • Adding Headers & Footers
  • Inserting Watermarks
  • Formatting the Overall Document
  • Inserting Graphical Elements
  • Inserting Clip Art
  • Using SmartArt
  • Inserting Tables
  • Formatting Tables
  • Creating a Cover Page with Themes
  • Saving a Document
  • Outputting to PDF

Chapter III: EXPLORING EXCEL® (77 min)
  • Touring the Excel Interface
  • Inserting, Moving & Selecting Content
  • Format Numerical Data & Reference Cells
  • Building a Table & Using AutoFill
  • Inserting & Deleting Rows & Columns
  • Introducing Formulas
  • Introducing Functions
  • Using the Insert Function Dialog Box
  • Using Statistical Functions & the Status Bar
  • Using Auditing Commands
  • Exploring Absolute Cell Referencing
  • Naming Cell Ranges & Using Name Manager
  • Pasting Data & Using the Clipboard

Chapter IV: FORMATTING & STYLIZING IN EXCEL® (68 min)
  • Formatting Cells
  • Using Format Painter
  • Number Formatting
  • Using Cell Styles
  • Creating Cell Styles
  • Changing Styles
  • Using & Creating Table Styles
  • Filtering a Table Layout
  • Using Conditional Formatting
  • Formatting Worksheets with Themes
  • Inserting Graphical Elements
  • Managing Multiple Worksheets
  • Outputting a Document
  • Saving a Document

Chapter V: POWERING UP WITH POWERPOINT® (60 min)
  • Touring the PowerPoint Interface
  • Formatting Text
  • Changing the Slide Layout
  • Adding Additional Slides
  • Creating a Slide Design
  • Customizing Slides
  • Inserting Objects
  • Using SmartArt
  • Creating & Formatting Charts
  • Using WordArt Styles
  • Changing Chart Types
  • Applying Themes
  • Setting Animation Effects
  • Working with Different Views
  • Setting Up a Slide Show
  • Running a Slide Show
  • Outputting a Presentation

Chapter VI: STAYING CONNECTED IN OUTLOOK® (25 min)
  • Touring the Outlook Interface
  • Using E-mail
  • Creating Signatures & New Folders
  • Using a Calendar & Adding Events
  • Working with Multiple Calendars
  • Sharing Calendars
  • Adding & Viewing Contacts
  • Creating, Viewing & Flagging Tasks

Chapter VII: MANAGING DATA WITH ACCESS™ (21 min)
  • Introducing Access & Touring the Interface
  • Adding & Deleting Contacts
  • Filtering Data
  • Creating & Exporting Forms
  • Creating Reports
  • Exporting Data

Chapter VIII: A SEAMLESS OFFICE 2007 WORKFLOW (50 min)
  • Formatting & Sorting Data
  • Using Freeze Panes
  • Grouping Data into Outlines
  • Creating Charts in Excel
  • Sharing Workbooks
  • Using Excel with Word
  • Protecting a Document
  • Using Cross-References
  • Inserting Objects
  • Using Excel with PowerPoint
  • Publishing Handouts to Word
  • Going from Word to Outlook
  • Sending Invites with Outlook
  • Sending Meeting Requests
  • Final Comments & Credits
LENGTH
Total Run Time: 6 hrs
PRESENTER INFO
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.
Frequently Asked Questions


traingtoatalcrse.png

Total Training

Total Training is a pioneer in innovative online and DVD-based training for leading creative design, digital video, and office productivity software programs.

Ranging from casual hobbyists to the most seasoned professionals, our users quickly learn new software applications and broaden their knowledge of programs currently used. Narrated in an entertaining format by industry experts and leading authors, our video-based software training titles are critical tools for anyone wanting to learn tips, techniques, and best practices from the most respected names in the business.

We currently offer affordable subscriptions to our All-Access Library, which contains hundreds of courses, thousands of clips, and project files so users can follow along.

Hot Courses

Our Partners

×