My webs: Office 2007 TV

http://www.msoffice.us/Buy/Office_2007_TV.htm

Access 2007 Essential Training:

Access 2007 Essential Training covers each step of understanding, creating, and modifying databases for custom business purposes.

· Create database, interface

· Create a table, set a primary key, select data type, add and remove data

· Table properties, field size, input masks, default, validation and indexes

· Normalize data, structured database design, input, divide data & create relationship

· Simple queries, design a select query and set simple criteria

· Simple forms, layout, and design view, work with data

· Design a form, form wizard, add fields and work with controls and formats

· Query design, multiple table queries and joins

· Advanced queries, make a new table, append, update data and view SQL codes

· Simple reports wizard, leverage criteria and create mailing labels

· Report design, format, groups and calculated fields

· Advanced forms, create sub forms, tabbed forms, add controls

· Simple macros, create, add, run macros, add controls and link events

· Calculate with queries, add calculated fields, work with totals and create crosstab queries

· Pivot charts, insert sub reports and add controls

· Database tools, administer a database, and backup, repair data

· Security, set permissions, package and sign and encrypt DB and use trust center

· External data, import and export data and manage e-mail

· Create an application, object, macros and switchboards

· Exam preparation

Excel 2007 Essential Training:

Like the other applications in Microsoft Office 2007, Excel 2007 boasts upgraded features and a brand-new lookThe training begins with the essentials of using the program, including how and why to use a spreadsheet, how to set up and modify worksheets, and how to import and export data

· Ribbon, button, interface and file types

· Excel 2007 basics and formatting

· Spreadsheet formatting, styles

· Database tools

· Working with charts

· Collaborate, share data

· Consolidate data, manage multiple worksheets

· Pivot reports, insert pivot table/chart

· Basic formulas, modify text, paste values

· Conditional formulas, IF formulas, named ranges

· Data integrity, formula auditing

· Summarize data, subtotals, modify formula

· Prepare to print/distribute

· Data security, encrypt, digitally sign

· What-If analysis, data tables, scenarios

Microsoft Outlook 2007 Essential Training:

MS Outlook 2007 is the latest full-featured emailing and contact management software from the Microsoft Office suite

· Installing Office Outlook 2007

· Getting started, interface tour

· Adding email accounts and profiles

· Sending, receiving, replying to email

· Formatting email, inserting objects

· Advanced formatting, themes, styles

· Attachments, signatures

· Viewing email, notifications

· Customized views, Instant search

· Categorization, archiving, search folders

· Calendar basics, time zones, formatting

· Scheduling meetings, sending invitations

· Sharing calendars, viewing options

· Sending calendars through email, adding holidays

· Creating/sharing contacts, distribution lists

· Creating/assigning a task, notes

· Advanced features, RSS feeds, out of office

· Junk mail, mail security

Microsoft PowerPoint 2007 Essential Training:

PowerPoint 2007 joins its Office counterparts by featuring a brand-new interface, as well as a selection of new powerful presentation featuresInstructor David Rivers explains each of its new features in detail, including an essential overview of the new interface, navigating a presentation, creating and editing presentations, working with tables and charts, importing and exporting data, and sharing presentations via various mediaExercise files accompany the tutorials.

· Installing PowerPoint 2007

· PowerPoint ribbon/button, view panes

· Creating presentations, templates, outlines

· Creating and editing text

· Auto formatting, spell check, languages

· Inserting/formatting tables and charts

· Clipart, adding pictures

· Shapes, Word Art, Smart Art

· Audio, video, linked objects

· Exporting, publishing, file formats

· Changing themes, color/font schemes

· Formatting graphics, color, shapes, sizing

· Formatting backgrounds, colors, textures

· Formatting slides, transitions

· Formatting slide masters, viewing/editing

· Setup and delivery, organizing slides

· Presentations "Live", content, clarity

· Presentations "Recorded", diffbetween live/recorded, narration

Microsoft Word 2007 Essential Training:

From a new interface to timesaving content galleries, the latest version of Word brings a lot to the tableThe training explains each of its new features and attributes, from understanding and navigating its new interface, to using new formatting controls and extensive page layout techniques.

· Installing Office Word 2007

· Office Word ribbon, button, quick access toolbar

· Creating documents, templates, page views

· Entering text and symbols

· Manipulating text, grammar check

· Autocorrect, math autocorrect

· Autoformat, Smart tags, quick parts

· Using graphics, inserting clipart/pictures

· Autoshapes, word art

· Modifying diagrams, using text pane

· Creating/modifying charts, linking data

· Formatting text, changing fonts