karasi-kazan · 04-Май-09 18:22(16 лет 2 месяца назад, ред. 04-Май-09 22:34)
VTC - Microsoft Office 2007 Video Tutorials Производитель: VTC Computer Software Training Год выпуска: 2007 Язык: английский Уроки в сборнике:
Microsoft Word 2007Microsoft Word 2007 is one of the most robust upgrades in years. With its easy to use interface and advanced set of writing tools, users will be able to create and share great looking documents with ease. In this VTC course, author and Noted Expert, Brian Culp, takes users through the many new features of this essential word processing tool. The focus throughout is on how to leverage the many new features to unlock your creativity, and to make your word processing more efficient than ever before. Уроков: 121 Длительность: 7 ч.
Содержание
A Look Around
Welcome and What is New (03:31)
The Word 2007 Interface (05:34)
Using the Ribbon (04:01)
Using the Mini Toolbar (03:12)
Using Keyboard Shortcuts (04:37)
Using the Document Views (04:32) Working With Text
Opening a New File (05:07)
Insert and Edit Text (04:13)
Text Navigation (02:45)
Cut/Copy/Move (03:29)
Changing Text Properties (04:09)
Use Find and Replace (02:59) Save and Printing Documents
Save a Word Document (05:26)
The New File Extensions (05:59)
Open a Recent Document (03:37)
Protecting Content (03:34)
Print a Document (03:25)
Save a Document As a Template (06:32) Advanced Text
Formatting Text (03:26)
Changing the Font (02:30)
Apply Indents and Spacing (04:41)
Add a Symbol (04:54)
Creating a List (03:30)
Set Tabs (04:37)
Modify Tabs (05:27)
Create an Outline (03:51)
Apply a Style (03:23)
Change an Existing Style (02:38)
Creating a New Style (03:36)
Compare Formatting (02:26)
Review Formatting (03:59)
Paragraph Shading (01:43)
Controlling Pagination (02:59)
Paragraph Borders (03:03)
Switching Windows (03:42)
Insert a Hyperlink (02:22)
Document Margins (03:55)
Orientation and Size (03:06) Combine Graphics and Text
Insert a Screen Capture (02:53)
Insert Word Art (02:25)
Insert a Photo (03:14)
Insert Clip Art (03:56)
Insert Smart Art (04:51)
Insert a Shape (03:53)
Format a Shape (03:18)
Use a Theme (03:20)
Add a Page Border (02:29)
Text Wrapping Options (05:00)
More Text Wrapping (02:56)
Insert a Watermark (02:54)
Insert Figure Caption (02:25)
Insert Table of Figures (04:22)
Insert Audio and Video (03:29) Using Long Documents
Insert a Page Number (03:12)
Getting a Word Count (02:19)
Insert a Section Break (03:22)
Adding Footnotes and Endnotes (03:06)
Working with Headers (03:35)
Working with Footers (03:10)
Create a Bookmark (03:58)
Document Map (03:13)
Work with Columns (03:04)
Line Numbering (02:13)
Tables of Contents (04:16)
Custom TOC (02:31)
Add an Index (04:43)
Create Bibliography (04:29)
Add a Cover Page (02:20) Combine Data and Text
Insert a Table (03:59)
Modify a Table (05:00)
Working With Table Cells (05:01)
Split Cells and Tables (04:08)
Perform Table Calculations (02:55)
Insert a Chart (05:01)
Insert Research Material (02:06)
Envelopes and Labels (03:27)
Change Return Address (02:33)
a Mail Merge (04:07)
Finish a Mail Merge Start (03:54)
Print a Mail Merge (02:52) Correct/Revise/Collaborate
Use AutoCorrect to Reduce Mistakes (03:35)
Use AutoComplete To Save Time (04:01)
Use Smart Tags (04:03)
Use the Thesaurus (02:27)
Customize the Dictionary (02:16)
Correct Your Spelling (03:41)
Correct Your Grammar (04:29)
Perform Research On Topics (04:09)
Translate To Another Language (03:46)
Customize the Proofing Tools (02:57)
AutoRecover (01:47)
Add a Comment (04:23)
Track Changes (03:39)
Accept or Reject Changes (02:43)
Mark Document as Final (03:46)
Inspect a Document (03:30)
Compare Documents Side by Side (03:09)
Combine Documents (04:16)
Print Changes (02:30)
Hide Text (01:47) Customize and Automate
Customize the Ribbon (03:24)
Customize the Quick Launch Toolbar (02:26)
Add Ribbon Command to Quick Launch (01:13)
Creating a Macro (03:56)
Edit a Macro (02:42)
Use QuickParts (02:29)
Add a Template (01:50)
Dictating Text (01:59)
Advanced Save Options (02:45) Cool Tips and Tricks
Create Any Document (03:30)
Insert Into Document (01:24)
Create a PowerPoint Slide in Word (03:09)
Use a Drop Cap (02:05)
Convert Footnotes to Endnotes (01:32)
Change Document Properties (02:57)
View Styles At a Glance (01:29)
Change the Normal Template (04:11)
Blogging in Word (04:09)
Fixing Word (02:04) Wrap Up
Wrap Up (03:01) About the Author
About the Author (01:55)
Microsoft Excel 2007 Though Microsoft Excel has been around for many years, Excel 2007 has an entirely new look and feel. Many new features have been added to improve productivity and workflow. In this in-depth VTC course, VTC Author Cheryl Brumbaugh-Duncan explores using Excel to сreate, manage, and analyze spreadsheet data. Users will learn to develop all the necessary worksheets and workbooks for financial and informational data, for a company that distributes healthy snacks to companies throughout a city. The course steps the participant through the various topics and skills needed to master Excel 2007 and provides a fun project for applying the new knowledge. Work Files are included. Уроков: 115 Длительность: 8 ч.
Содержание
Introduction to Excel 2007
Welcome to Excel 2007 (02:26)
Overview of Spreadsheets and Excel 2007 (01:47)
Overview of Course (03:18)
New in Excel 2007 pt. 1 (05:51)
New in Excel 2007 pt. 2 (04:56)
Understanding the Excel 2007 Workspace (04:34)
Introducing the New Excel 2007 Ribbon (06:21)
Using the Quick Access Toolbar (03:58)
Compatibility with Earlier Versions (05:32) Installing Excel 2007
Considerations Before You Install (02:10)
Installing Excel (03:14) Microsoft Excel 2007 He|p
Accessing Microsoft Excel 2007 He|p (00:42)
Using Excel 2007 He|p (03:45)
Using Microsoft Office On-line (02:07)
Accessing the Support Knowledge Base (01:48) Working with Worksheets and Workbooks
Launching Excel (03:29)
Planning a Project (02:59)
Creating a New Workbook (05:18)
Adding and Deleting Data (04:58)
Importing Data into Excel (06:30)
Naming and Saving a Workbook (03:31)
Managing Multiple Worksheets (06:04)
Printing a Worksheet pt. 1 (02:22)
Printing a Worksheet pt. 2 (06:37)
Opening and Closing a Workbook (03:42)
Renaming and Deleting a Workbook (02:49) Editing Techniques
Selecting Cells / Rows / Columns (03:47)
Cut / Copy / Paste (06:10)
Copy and Paste Special (03:29)
Editing or Replacing Content in a Cell (04:13)
Undo / Redo / Repeat Edits (05:57)
Adjusting Row Height (05:07)
Adjusting Column Width (02:55)
Inserting and Deleting Rows / Columns / Cells (05:55)
Merging and Splitting Cells (03:48)
Clearing a Cell (02:39)
Finding and Replacing Data (05:07)
Using AutoFill (05:12) Customizing Excel 2007
Customizing the Excel Workspace (03:59)
Splitting the Screen (06:29)
Freezing and Locking Cells (04:35)
Hiding and Showing Rows / Columns / Sheets (04:35)
Using Different Views (04:41)
Arranging Multiple Workbooks (04:41)
Displaying Gridlines and Headings (04:23)
Setting a Trusted Location (03:51)
Using Excel Options (03:45) Changing the Appearance of a Worksheet
Formatting Options in the Ribbon (02:57)
Formatting Text (06:18)
Formatting Numbers (04:02)
Adding Borders (05:26)
Adding Fill Colors and Patterns (05:09)
Using the Format Painter (05:02)
Using Cell Styles (03:20)
Using Document Themes (04:04)
Using Wrap Text (02:15)
AutoCorrect (03:48)
Setting Page Layout Options (04:20)
Adding Headers and Footers (04:59)
Setting Page Breaks (05:49)
Using Templates (03:58)
Using Conditional Formatting (04:28) Working with Formulas
Using Formulas (04:03)
Formula Writing Made Easy (05:12)
Creating Simple Formulas (02:20)
Order of Operations (03:36)
Creating Formulas with Operators and Cell References (05:21)
Understanding Cell References (03:21)
Calculating Totals with AutoSum (07:03)
Common Functions (06:43)
Creating Formulas with Functions (07:14)
Creating Formulas with Nested Functions (07:09)
Creating and Managing Names (06:50)
Creating Formulas with Names (02:49)
Displaying and Printing Formulas (02:15)
Error Checking (05:19)
Common Errors When Creating Formulas (02:47) Managing Data
Overview of Excel Data Handling Tools (01:09)
Creating an Excel Table (05:25)
Sorting an Excel Table (02:32)
Filtering an Excel Table (03:15)
Formatting Excel Table Data (02:27)
Working with Excel Table Rows and Columns (05:48)
Displaying and Calculating Table Data Totals (03:26)
Using Structured References (02:31)
Validating Data (07:04)
Linking Data Between Worksheets (05:19)
Linking Data Between Multiple Workbooks (06:24)
Exporting Data (04:59) Charts and Graphics
Overview of Charts and Excel (02:14)
Understanding Chart Types (02:56)
Creating a Chart (06:06)
Changing the Chart Type of an Existing Chart (03:55)
Moving and Deleting a Chart (02:56)
Changing the Charted Data (06:04)
Editing Charts (04:20)
Formatting a Chart - Design Tab (04:16)
Formatting a Chart - Layout Tab (07:03)
Formatting a Chart - Format Tab (04:45)
Creating a Chart Template (03:02)
Applying a Chart Template (02:15)
Importing Graphics into Excel (07:06)
Modifying Imported Images (05:02) Excel 2007 Plays Well with Others
Overview of Sharing and Collaborating (01:48)
Excel and Other Office Applications (07:18)
Using the Office Clipboard (03:40)
Creating PDF Files (02:53)
Opening and Saving Files in Other Formats (03:08)
Excel and Databases (02:34)
Using Queries (04:12)
Using with a Document Management Server (02:21)
Publishing an Excel Worksheet (01:06)
Excel XML Files (02:58)
Wrap Up (01:50) Credits
About This Author (02:41)
Microsoft Access 2007 Microsoft Access 2007 helps you effectively track, report, and share information in a manageable environment. With a library of pre-built tracking applications (database solutions) and the Microsoft Office Fluent user interface, Access 2007 does not require deep database knowledge or programming skills. In this VTC course, Author / IT Instructor, Tim Warner introduces users to database design concepts while assisting them in becoming proficient with building and maintaining an Access 2007 database. Уроков: 132 Длительность: 8 ч. 30 мин.
Содержание
Introducing Access 2007
Course Introduction (03:29)
What is Microsoft Access? (03:59)
About Relational Databases (04:03)
Access and SQL Server (03:21)
Getting He|p pt. 1 (04:02)
Getting He|p pt. 2 (04:41)
Staying Up-to-Date (04:03) Exploring Access 2007
Using the Getting Started Window (04:12)
Introducing the Ribbon (04:48)
Using the Navigation Pane (04:33)
Opening and Closing Databases (04:31)
Managing Macro Security (04:31)
Exploring Tables (04:40)
Exploring Queries (04:37)
Exploring Forms (04:11)
Exploring Reports (03:26)
Exploring Macros (03:47)
Exploring Modules (02:29) Creating a Database
Creating a Database from a Template (05:21)
Creating a Database from Scratch (04:53)
Creating a Table from a Template (04:43)
Creating a Table from Scratch (04:57)
Using Fields and Data Types pt. 1 (04:17)
Using Fields and Data Types pt. 2 (04:30)
Setting Table Properties (04:40)
Working in Datasheet View pt. 1 (04:52)
Working in Datasheet View pt. 2 (04:54) Importing Data
Leveraging Data Import (03:27)
Importing from Text pt. 1 (04:41)
Importing from Text pt. 2 (04:38)
Importing from Excel (03:51)
Importing from XML (04:29)
Importing from Outlook (02:57)
Importing from Access (03:49) Exporting Data
Exporting to Text (04:04)
Exporting to Excel (02:47)
Exporting to XML (03:15)
Exporting to Word (03:15)
Exporting to Access (03:19) Modifying Table Design
Renaming Tables (03:45)
Dropping Tables (02:36)
Managing Fields pt. 1 (04:03)
Managing Fields pt. 2 (04:55)
Managing Fields pt. 3 (03:40)
Using Undo and Redo (04:52)
Changing the Primary Key pt. 1 (03:51)
Changing the Primary Key pt. 2 (04:10)
Setting Table Relationships pt. 1 (03:56)
Setting Table Relationships pt. 2 (04:45)
Setting Table Relationships pt. 3 (02:47)
Using the Table Analyzer Wizard (03:16) Maintaining Data Integrity
Introduction to Data Types (04:15)
Managing Data Types pt. 1 (04:02)
Managing Field Data Types pt. 2 (03:12)
Setting Field Length (03:17)
Using Input Masks pt. 1 (04:25)
Using Input Masks pt. 2 (04:08)
Using Default Values pt. 1 (03:08)
Using Default Values pt. 2 (03:00)
Setting a Validation Rule (04:52)
Creating a Lookup List pt. 1 (03:47)
Creating a Lookup List pt. 2 (03:30)
Creating a Lookup List pt. 3 (04:52)
Compacting the Database (01:39)
Backing Up the Database (01:19) Using Forms
Understanding Forms (04:16)
Navigating in Forms (03:54)
Creating a Form Quickly (04:41)
Using the Form Wizard (04:03)
Understanding Form Views (03:39)
Creating a Blank Form pt. 1 (03:22)
Creating a Blank form pt. 2 (03:32)
Aligning Controls (04:24)
Sizing Controls (04:50)
Controlling Data Input (03:44)
Creating an Option Group pt. 1 (03:32)
Creating an Option Group pt. 2 (03:34)
Formatting a Form (03:10)
Using AutoFormat (02:04)
Setting Tab Order (01:33)
Creating Subforms pt. 1 (03:18)
Creating Subforms pt. 2 (03:09) Querying Data
Sorting Table Records (04:15)
Using Basic Filters (04:03)
Using Filter By Form (03:07)
Using Advanced Filters (03:31)
Understanding Queries (04:19)
Using the Query Wizard (04:08)
Designing Select Queries (04:30)
Adding Query Criteria (04:54)
Designing Parameter Queries (03:54)
Using Calculated Fields (03:15)
Designing Action Queries pt. 1 (03:58)
Designing Action Queries pt. 2 (03:54)
Designing Action Queries pt. 3 (05:10)
Generating Totals and Averages (03:24)
Using Expression Builder (03:32) Working with Reports
Understanding Reports (02:19)
Creating a Report Quickly (03:58)
Using the Report Wizard (04:52)
Formatting a Report (04:49)
Creating a Blank Report pt. 1 (04:27)
Creating a Blank Report pt. 2 (02:49)
Creating a Blank Report pt. 3 (04:40)
Using Queries in Reports (05:26)
Using Calculated Values (04:25)
Previewing and Printing a Report (03:40)
Saving a Report as PDF (03:03) Securing and Sharing Data
Password-Protecting Your Database pt. 1 (04:08)
Password-Protecting Your Database pt. 2 (04:17)
Securing Database Code (04:24)
Distributing Your Database pt. 1 (04:08)
Distributing Your Database pt. 2 (03:36) Customizing Your Database
Creating a Switchboard pt. 1 (04:19)
Creating a Switchboard pt. 2 (03:56)
Creating a Switchboard pt. 3 (03:42)
Understanding the Navigation Pane (04:28)
Defining Custom Categories pt. 1 (03:55)
Defining Custom Categories pt. 2 (03:31)
Setting Global Options (04:54)
Customizing Quick Access pt. 1 (03:35)
Customizing Quick Access pt. 2 (04:09)
Creating a Custom Ribbon (04:38)
Using Performance Analyzer (03:41)
Using Database Documenter (02:31) Five Cool Access Tips and Tricks
Getting Certified in Access 2007 (04:25)
Great Access 2007 Resources (04:10)
Microsoft Virtual Labs (02:40)
Access Ribbon Mapping Workbook (02:44)
Keyboard Shortcuts (04:37) Wrap-Up
Wrap-Up (03:11) About the Author
About the Author (03:24)
Microsoft Outlook 2007 Microsoft Outlook 2007 provides an integrated solution for managing and organizing e-mail messages, schedules, tasks, notes, contacts, and more. With its new design and advanced customization features, Microsoft Outlook 2007 is much more than just an e-mail/calendar application. Author Brian Culp guides users through using this exciting new program, from installation to utilizing it as a complete task and communication management program. As a part of Microsoft Office, or as a stand alone program, Brian Culp will show users how to get the most out of Microsoft Outlook 2007, and he even includes 10 of his favorite tips / tricks. Уроков: 99 Длительность: 6 ч.
Содержание
Setting Up Outlook 2007
Intro and Overview (04:00)
New Features and Capabilities (04:52)
Setting up an E-mail Account (06:17)
Create an Outlook Profile (04:41)
Personalize the Outlook Workspace (04:54) Send and Receive E-mail
Compose an E-mail Message (06:09)
Send an E-mail Message (04:04)
Format Your Messages (04:56)
Attach Files to E-mails (04:23)
Resend and Recall (04:23)
Configure E-mail Notifications (02:53)
Receive and Handle E-mail (04:56)
Create an Appointment From a Message (02:31) Manage the Inbox
Search the Inbox (04:23)
Sort E-mail (04:40)
Customize the View (03:33)
Reset the View (01:52)
Categorize E-mail (04:40)
Using Flags (03:09)
Printing an E-mail (04:23) Manage Contacts
Use the Contacts Window (05:33)
Handle Duplicate Contacts (03:29)
Update Contact Information (03:51)
Create a Distribution List (04:42)
Use Different Views (03:53)
Change the Business Card (01:57)
Print Contact Information (03:09) Manage Time
Schedule an Appointment (04:30)
Change Appointments (04:23)
Create and Delete an Event (02:47)
Send Meeting Requests (04:47)
Using the Calendar Views (04:55)
Customize Calendar Views (03:52)
More Calendar Customization (02:34)
Change the Time Zone (02:37)
Print a Calendar (02:41)
Send a Calendar as E-mail (02:58) Tasks and Notes
Create a Task (04:35)
Task Options (02:19)
Task Views (03:15)
Create a Note (02:43)
Link a Note (02:10)
Organize Notes (02:32)
Create a Shortcut (03:01)
Create a Shortcut Grouping (02:26)
Assign Tasks (05:03) Customizing Outlook 2007
Using Search Folders (04:52)
Deleting Items in Search Folders (02:30)
Handling E-mail with Rules (04:18)
Manually Create a Rule (04:40)
Change the Quick Access Toolbar (02:49)
Manage Editor Options (02:20)
E-mail Signatures (02:51)
E-mail Stationary (02:03)
Manually Add a Signature (01:30)
Delivery Options (02:49)
Archive E-mail (04:05)
Archive Items Manually (03:00)
Archive for Performance (03:29)
Customize Printing (04:34) Outlook Maintenance
Backup Your Personal Folders File (07:13)
Restore Your Personal Folders File (02:51)
Repair Personal Folders File (02:53)
Deleted Items Folder (03:39)
Retrieve Deleted Items (04:08)
Use Other Data Files (04:25)
Export Contacts (02:40)
Import Contacts (02:52)
Send/Receive Groups (05:01)
Message Headers (03:30) Advanced Outlook
Using the Research Pane (05:05)
Configure the Research Pane (04:21)
Translation and Dictionaries (03:35)
Auto Respond to Messages pt. 1 (02:23)
Auto Respond to Messages pt. 2 (03:41)
Share a Calendar with Internet Free/Busy (02:24)
Publish with Office Online (02:03)
Send Internet Free/Busy Info (02:08)
Create Group Schedule (02:39)
Create a Group Meeting (03:33)
Block HTML Content (05:10)
Dealing with Junk Mail (03:53)
Configure Junk Mail Settings (03:25)
Security with Digital Certificates (04:09)
Sign a Single E-mail (03:34)
Encrypt E-mail (01:58) Ten Cool Outlook Tips and Tricks
Use Outlook as an RSS Feed Reader (04:44)
Managing RSS Feeds (03:28)
Use Internet Calendars (03:18)
Use Multiple Calendars (03:00)
Add Holidays to the Calendar (01:38)
Use Office 2007 Themes (01:30)
Automatically Accept Meetings (02:07)
Automatically Close Replied-to Mail (01:32)
Clear the AutoComplete Cache (03:01)
Create a Rule From an Existing E-mail (01:47)
Change File Preview Behavior (02:04) Wrap Up
Wrap Up (04:16) Credits
About Brian Culp (01:44)
Microsoft PowerPoint 2007 Microsoft PowerPoint 2007 is one of the most robust upgrades in years. With its easy to use interface and advanced set of creative tools, users will be able to create everything from simple sales presentations to full-blown multimedia productions. In this VTC course, author and noted expert John Kuhlman, takes users through the many new features of this essential presentation tool, including the integration with other Microsoft Office Applications. Work Files are included. Уроков: 93 Длительность: 5 ч. 30 мин.
Содержание
Introduction
Introduction (04:25)
What is Microsoft PowerPoint (03:46)
Using PowerPoint Views pt. 1 (03:35)
Using PowerPoint Views pt. 2 (03:25)
Using Keyboard Shortcuts (04:48)
Getting Started (05:15) Getting Familiar with PowerPoint 2007
Working with the Ribbon (02:55)
Exploring Themes / Layouts and Quick Styles (04:53)
Using SmartArt Graphics (03:55)
Using the Presenter View (01:54)
Exploring New Text Options (06:00)
Redesigning Tables and Charts (03:56)
Utilizing Slide Libraries (01:38)
Working with XML Formats (01:33)
Protecting and Managing Information (04:43) Getting Started
Working with a Blank Presentation (02:04)
Working with an Existing Presentation (02:12)
Creating a New Slide (01:25)
Customizing Your Slide Layout (03:04)
Using a Design Template (03:08) Working with Text
Entering Text on a Slide (03:45)
Managing Text Overflow (05:36)
Formatting Text (06:27)
Importing Text (04:16)
Using Spell Checker (04:56)
Working with Bullets and Numbering (05:41)
Creating Titles (04:01)
Creating Slide Content (02:39)
Using Speaker Notes (02:50) Working with Graphics
Working with SmartArt Graphics (06:52)
Working with WordArt (04:31)
Inserting a Photo (03:26)
Resizing and Rotating a photo (02:05)
Formatting a Photo (04:22)
Working with Clip Art (02:21)
Formatting Clip Art (03:02) Working with Tables and Charts
Inserting a Table (03:53)
Entering Table Data (02:44)
Formatting Tables (06:26)
Inserting a Word or Excel Chart (03:44)
Inserting a Chart (02:54)
Entering Chart Data (02:59)
Formatting Charts (05:06)
Inserting a Word or Excel Chart (01:56) Drawing Shapes
Inserting Shapes (04:24)
Drawing Shapes (03:57)
Using 3D Effects (02:39)
Working with Fill & Line Color (03:16)
Aligning and Grouping Shapes pt. 1 (03:24)
Aligning and Grouping Shapes pt. 2 (04:44)
Drawing a Curve (03:52)
Using Quick Styles (02:31)
Using Action Buttons (03:10) Creating Custom Themes and Quick Styles
Using Theme Colors (04:24)
Modifying Theme Fonts (02:23)
Working with Theme Effects (01:26)
Editing a Theme Master (01:44)
Creating a Background (03:59)
Applying Quick Styles (05:08)
Editing a Quick Style (02:05) Working with Multimedia
Using Multimedia on Slides (02:45)
Inserting Movies (05:38)
Managing Movie Action (05:36)
Inserting Audio Clips (06:34)
Managing Audio Playback (05:14)
Using CD Music (02:43)
Working with Hyperlinks (03:18) Applying Transitions and Animations
Understanding Transitions (02:41)
Applying a Transition to a Slide pt. 1 (04:33)
Applying a Transition to a Slide pt. 2 (03:29)
Using Animation (02:30)
Applying Animation to Text (01:58)
Applying Animation to an Object (03:43)
Animating a SmartArt Graphic (02:43)
Creating a Custom Animation (04:13) Preparing Your Final Presentation
Sorting Slides (03:03)
Rehearsing a Show (03:29)
Using Hidden Slides (01:46)
Creating Custom Shows (02:55)
Printing Audience Handouts and Speaker Notes (03:12) Delivering Your Presentation
Keyboard Shortcuts for Moving Between Slides (02:25)
Using Pointers and Annotations (01:50)
Saving for the Web (03:03)
Setting Security Options (02:34) Tips and Tricks
Putting it All Together pt. 1 (04:23)
Putting it All Together pt. 2 (03:40)
Putting it All Together pt. 3 (03:32)
Putting it All Together pt. 4 (03:36)
Putting it All Together pt. 5 (03:05)
Putting it All Together pt. 6 (02:37)
Putting it All Together pt. 7 (02:32)
Top Five Ways to Kill Your Presentation (05:41) Credits
About this Author (02:15)
Microsoft Project 2007 Product managers need to track project resources, time and cost, schedule tasks efficiently, exchange project information, and communicate with resources while maintaining control over the project. This can be a daunting task unless you have the right tools, and know how to use them. In this course VTC author, Brian Culp, teaches users Microsoft Project 2007, an invaluable project management tool. Learn how to start projects, create and edit tasks, assign resources to tasks, share project information, and much more. Уроков: 90 Длительность: 5 ч.
Содержание
Setting Up Project 2007
Intro and Overview (04:28)
Starting Project (04:04)
New Features (05:18)
Save a Project (02:15)
Import Outlook Tasks (02:33) Start a New Project
Create a New Project (03:41)
Entering Tasks (03:58)
Insert Tasks (02:08)
Elapsed Duration (02:28)
Set a Milestone (02:49)
Use Summary Tasks (02:44)
Link Tasks (07:20)
Set Non-Working Time (02:27) Working with Resources
Setting up People (05:43) T
Adjusting Availability (04:40) T
Setting up Equipment (03:24) T
Setting up Material (02:00) T
Setting up Costs (02:00) T
Entering Pay Rates (03:12) T Task Management
Assign Work to a Task (04:09)
Add Additional Resources (04:33)
Assign Material (02:43)
Assign a Calendar to a Task (02:48)
Lag and Lead Time (02:55)
Recurring Tasks (03:17)
Using Constraints (04:24)
The Critical Path (03:02)
Create a Task Calendar (03:29)
Delete a Calendar (02:02)
Change the Timeline (02:13)
Project Duration (03:13) Create a Project Plan
Create a Resource Pool (04:45)
Change Resource Information (03:14)
Use the Resource Pool (02:34)
Viewing Overallocations (05:21)
Overallocation Report (02:46)
Resolve Overallocations (04:20)
Level Resources Automatically (05:37)
View Leveling Results (02:17)
Assign Fixed Cost (02:37) Edit Task Details
Split a Task (03:01)
Change Task Type (04:22)
Entering Deadline Dates (02:37)
Add a Note (04:19)
Effort Driven Tasks (02:24)
Sort Project Details (04:03)
Group Project Details (03:22)
Filtering Project Details (04:05)
Customize Tables (04:21)
Customize Views (03:07) Edit Assignment Details
Multiple Pay Rates (03:01)
Multiple Availability Dates (01:56)
Delay Start of Assignment (03:47)
Apply a Work Contour (02:24)
Manually Adjust Contour (02:06)
Use Cost Tables (02:40)
Variable Material Rates (02:13) Tracking Progress
Link Summary Tasks (03:21)
Save a Baseline (02:15)
Track as Scheduled (02:57)
Entering Completion Percentage (02:31)
Using Actuals (02:24)
Updating the Baseline (02:10)
Check Project Duration (01:12)
Add a Note (01:36)
Manually Update Actual Work (03:26) Share Project Information
Project Summary Reports (03:22)
Critical Tasks Reports (02:42)
Create a To Do List (01:40)
Create a Picture (02:15)
Use Visual Reports (03:30)
Export to PowerPoint (03:23)
Import Project Information (03:07)
Print a Report (02:15)
Print a View (03:33)
Insert Drawings (01:26)
Create a Custom Gantt (03:00) Cool Project Tips and Tricks
Printing a Project Calendar (02:28)
Change Text Styles (01:55)
Create Outlook Tasks (05:43)
Use a Fixed-Cost Resource (03:04)
Use Graphical Indicators (03:22)
Insert Task Instructions (02:31)
Consolidate Projects (02:21)
Dependencies Between Projects (03:15)
Save a Workspace (02:08)
Customize the Toolbar (02:42)
Use the Organizer (03:06) Wrap Up
Final Thoughts (02:30) Credits
About the Author (01:27)
Microsoft Publisher 2007 Microsoft Publisher 2007 is one of the most robust upgrades in years. With its easy to use interface and advanced set of creative tools, users will be able to create web sites, forms, business cards, flyers, calendars, greeting cards, signs, posters, email marketing campaigns and much much more! Pre-designed templates allow users to create professional files that can be printed locally, packed for a commercial printer, emailed or uploaded to the Web. This useful "how to" course by Microsoft Office expert Melanie Hedgespeth, uses practical examples for both home and business users. Work Files are included. Уроков: 105 Длительность: 7 ч. 30 мин.
Содержание
Introducing Publisher 2007
Course Introduction (02:14)
Getting Publisher 2007 on Your PC (05:30)
Publication Possibilities (04:59) Publisher 2007 Foundation
Office Window Elements (07:20)
Publisher Desktop Elements (05:15)
Working with Toolbars (04:46)
Using Rulers and Guides (03:31)
More with Rulers (02:32) Getting He|p
Microsoft Office He|p (04:53)
Office Online (04:37)
Publisher Tasks (02:31) Creating and Managing a New Publication
Planning and Preparation (05:39)
Program and File Basics (04:54)
Make a Publication (03:58)
Task Pane Options (04:10)
Working with Objects (04:41)
File Management (03:31) Working With Text
Creating a Text Box (04:14)
Adding Text (04:12)
Editing Text (04:59)
Formatting Text Boxes (03:55)
More Formatting Options (04:22)
Working with Text Boxes (03:14)
Linking Text Boxes (02:46)
More Linking Options (02:31)
Find and Replace Text (02:20) Text Enhancements
Columns (05:01)
Bullets and Numbering (05:37)
Styles (05:17)
Text and Character Spacing (04:49)
Drop Caps and Reverse Text (03:02)
Symbols (02:36) Formatting Publications
Page Formatting (04:12)
Working with Pages (04:13)
Headers and Footers (03:58) Tables
Inserting Tables (02:20)
Manipulating Tables (02:21)
Merging Cells (02:01)
Table Formatting (03:50)
More with Tables (02:59) Graphics
About Graphics in Publisher (06:54)
Adding Pictures (06:20)
Adding ClipArt (05:50)
More with ClipArt (06:14)
Picture Placeholders (03:14)
Digital Camera Pictures (04:24)
Graphics and the Content Library (02:31)
Copy and Paste Graphics (02:18)
Design Gallery Objects (02:32)
Positioning Graphics (05:19)
Manipulating Graphics (04:42)
More Manipulation Techniques (02:30)
Using the Picture Toolbar (04:03)
Wrapping Text Around Graphics (03:21)
Drawing Tools (03:44)
More Drawing Tools (02:50)
AutoShapes pt. 1 (03:14)
AutoShapes pt. 2 (04:18) Publisher Efficiency Elements
Content Library (06:46)
Master Pages (06:48)
Design Checker (03:17)
Templates pt. 1 (04:06)
Templates pt. 2 (03:56)
Templates pt. 3 (07:15)
Make Your Own Template (05:39)
Modify Your Template (02:46)
Add-Ins (04:23) Mail Merge
About Mail Merge (05:15)
Mail Merge Letters pt. 1 (05:31)
Mail Merge Letters pt. 2 (03:42)
Mail Merge Letters pt. 3 (02:37)
Mail Merge Envelopes (05:37)
Editing Address Lists pt. 1 (06:51)
Editing Address Lists pt. 2 (06:51)
Editing Address Lists pt. 3 (02:46)
Email Merge (06:09)
Catalog Merge (03:41)
Mail Merge Labels (03:26)
Mail Merge Postcards (02:40) Printing and Distribution
Printing Basics (06:11)
Pack & Go (06:04)
Email (06:23) Websites
Planning a Site (07:09)
Creating Your Website (06:52)
Editing Text (04:58)
Task Pane Options (05:23)
Graphics (05:29)
Web Tools Toolbar (03:34)
Navigation (04:07)
Links (05:50)
Forms pt. 1 (03:47)
Forms pt. 2 (03:46)
Web Site Hosting (05:45) Publications Step by Step
Gift Tag Labels (06:15)
Return Address Labels (05:39)
CD/DVD Labels (04:18)
Greeting Cards (05:12)
Resumes (05:13)
Banners (05:25)
Certificates (04:56)
Envelopes (04:24)
Business Cards (05:47)
Flyers (04:12) Wrap Up
Tutorial Wrap Up (02:17) About the Author
Author (01:32)
Microsoft Visio 2007 Microsoft Visio 2007 makes it easy for IT and business professionals to visualize, explore, and communicate complex ideas. Go from complicated text and tables that are hard to understand to Visio diagrams that communicate information at a glance. Instead of static pictures, create data-connected Visio diagrams that display information and ideas. Whether creating network diagrams, flowcharts, calendars, or organizational charts, Visio can make a professional drafter out of practically anyone. VTC Author and Trainer Timothy Warner provides the user with easy-to-follow instructions for learning this powerful application. Уроков: 152 Длительность: 10 ч.
Содержание
Introducing Visio 2007
Course Overview (02:34)
Understanding Visio 2007 Product Editions (04:10)
Installing Visio 2007 (04:27)
Updating Visio 2007 (03:11)
Maintaining Visio 2007 (03:31)
Using Microsoft Office Diagnostics (04:11)
Uninstalling Visio 2007 (02:38) Navigating Visio 2007
Touring the Visio 2007 Interface (05:30)
Accessing Sample Drawings (04:25)
Creating a New Diagram (05:38)
Using Menus and Toolbars (04:47)
Using Undo and Redo (05:12)
Using View Windows and the Task Pane (04:57)
Saving and Opening Visio Drawings (06:04)
Exporting to Alternate File Formats (04:52)
Accessing Page Setup (05:30)
Using Print Preview (03:46)
Printing a Visio Drawing (04:15) Getting Help in Visio 2007
Configuring Online Content Settings (03:08)
Using Online Assistance pt. 1 (03:42)
Using Online Assistance pt. 2 (04:32)
Using Online Assistance pt. 3 (03:57)
Accessing Visio 2007 Downloads (04:25)
Using the Visio 2007 Viewer (02:56) Using Stencils
Introducing Stencils (04:21)
Opening and Closing Stencils (02:35)
Moving Stencils Around (03:45)
Accessing the Document Stencil (02:53)
Creating a New Stencil (05:20)
Modifying Stencils (05:21) Working with Shapes
Adding Shapes to a Drawing (04:33)
Searching for Shapes (04:04)
Using My Shapes (04:30)
Resizing and Rotating Shapes (04:43)
Resizing and Rotating Lines (04:19)
Cloning Shapes (03:48)
Grouping and Ungrouping Shapes (03:16)
Advanced Shape Operations (03:53)
Aligning and Distributing Shapes (03:17)
Adding Text to Shapes (04:01)
Formatting Shapes (04:30)
Using the Drawing Tools (03:32)
Using Themes (04:42) Connecting Shapes
Introducing Connection Points (04:15)
Introducing Glue (04:15)
Using AutoConnect (02:40)
More About Connectors (03:57)
Using Stencil-Based Connectors (04:11)
Formatting Connectors (04:25)
Controlling Shape Layout (03:42) Adding Text to a Drawing
Understanding Text Blocks pt. 1 (04:12)
Understanding Text Blocks pt. 2 (02:44)
Understanding Text Boxes pt. 1 (03:39)
Understanding Text Boxes pt. 2 (03:52)
Applying Character Formatting (03:51)
Applying Paragraph Formatting (03:33)
Understanding Shape Protection (04:00)
Rotating Text (03:27)
Using Format Painter (02:52)
Adding Callouts and Annotations (04:16)
Using the Spelling Checker (04:50)
Accessing AutoCorrect Options (04:14) Working Precisely with Visio 2007
Using the Drawing Grid (04:11)
Using the Dynamic Grid (02:24)
Setting the Drawing Scale pt. 1 (03:23)
Setting the Drawing Scale pt. 2 (03:01)
Setting Snap and Glue Options (04:28)
Using Guides and Guide Points pt. 1 (02:45)
Using Guides and Guide Points pt. 2 (02:37)
Using Zoom Controls pt. 1 (02:39)
Using Zoom Controls pt. 2 (02:18)
Panning and Zooming (03:01)
Using the Size and Position Window (03:00)
Using the Drawing Explorer (02:39) Working with Pages
Navigating Multi-Page Documents (03:33)
Inserting and Removing Pages (04:15)
Renaming and Reordering Pages (03:36)
Assigning a Page Background (04:30)
Converting Pages (02:38)
Rotating Pages (02:13)
Hyperlinking Between Pages (04:17)
Using Hyperlink Navigation Shapes (04:42) Using Layers
Understanding Layers (02:27)
Defining an Active Layer (04:29)
Creating and Renaming Layers (03:45)
Assigning Shapes to Layers (04:34)
Showing and Hiding Layers (02:01)
Color-Coding Layers (01:49)
Locking and Unlocking Layers (02:51)
Removing Layers (03:03) Adding Custom Data to a Visio Drawing
Add Shape Data to a Drawing (04:37)
Defining Shape Data (04:27)
Using Data Graphics pt. 1 (04:20)
Using Data Graphics pt. 2 (04:44)
Creating Reports pt. 1 (04:10)
Creating Reports pt. 2 (04:48)
Linking Shape Data pt. 1 (04:53)
Linking Shape Data pt. 2 (04:24)
Creating a PivotDiagram pt. 1 (03:44)
Creating a PivotDiagram pt. 2 (03:54)
Creating a PivotDiagram pt. 3 (03:54) Using Visio 2007 Markup Tools
Adding Comments (04:13)
Editing Comments (01:53)
Tracking Changes pt. 1 (04:05)
Tracking Changes pt. 2 (04:43)
Tracking Changes pt. 3 (03:48) Adding Pizzazz to Visio Drawings
Adding a Page Border (04:07)
Adding Embellishments (03:39)
Inserting Clip Art pt. 1 (04:24)
Inserting Clip Art pt. 2 (03:41)
Using the Clip Organizer (04:23)
Using Office Online (04:37)
Inserting Images (04:17) Customizing Visio 2007
Configuring Properties (04:11)
Setting Global Options (05:02)
Customizing the Toolbars pt. 1 (04:08)
Customizing the Toolbars pt. 2 (04:39)
Creating New Toolbars (03:30)
Creating Visio Templates (05:20)
Using Custom Stencils pt. 1 (04:10)
Using Custom Stencils pt. 2 (03:24) Creating Flowcharts
Creating a Basic Flowchart pt. 1 (04:08)
Creating a Basic Flowchart pt. 2 (04:35)
Creating a Cross-Functional Flowchart pt. 1 (03:53)
Creating a Cross-Functional Flowchart pt. 2 (04:39) Creating Organizational Charts
Creating an Org Chart pt. 1 (04:36)
Creating an Org Chart pt. 2 (04:20)
Importing Org Chart Data pt. 1 (03:42)
Importing Org Chart Data pt. 2 (03:58) Creating IT Diagrams
Creating Basic Network Diagrams pt. 1 (04:23)
Creating Basic Network Diagrams pt. 2 (04:39)
Creating Basic Network Diagrams pt. 3 (04:14)
Creating Server Rack Diagrams pt. 1 (05:02)
Creating Server Rack Diagrams pt. 2 (04:07)
Creating Server Rack Diagrams pt. 3 (03:11) Creating Building Plan Diagrams
Creating an Office Layout pt. 1 (05:04)
Creating an Office Layout pt. 2 (04:49)
Creating an Office Layout pt. 3 (04:39) Creating Maps
Creating a Directional Map pt. 1 (04:16)
Creating a Directional Map pt. 2 (04:07)
Creating a Directional Map pt. 3 (01:47)
Creating a 3D Map pt. 1 (03:46)
Creating a 3D Map pt. 2 (04:28) Creating Charts and Graphs
Creating Charts and Graphs pt. 1 (04:06)
Creating Charts and Graphs pt. 2 (04:58)
Creating Charts and Graphs pt. 3 (05:02) Creating Project Schedule Diagrams
Creating Calendars pt. 1 (05:05)
Creating Calendars pt. 2 (03:34)
Creating Timelines pt. 1 (04:35)
Creating Timelines pt. 2 (05:53) Wrap-Up and Credits
Course Conclusion (04:16)
Useful Web Sites (03:13)
About the Author (03:09)
По вышеприведенным ссылкам некоторые уроки доступны для ознакомительного просмотра. Видео: QuickTime MPEG-4 Video, 800x600 Аудио: MPEG Layer 3, Stereo, 22.050
Всем спасибо, всё скачал очень быстро! У меня только одна загвоздка... изображение транслируемое в ролике я совершенно не могу распознать и вычленить из него хоть что-то информативное, оно больше похоже на сон наркомана:) вот так это примерно выглядит звук нормальный идет. Только у меня такая проблема или у всех скачавших?
Проигрываю свежим квиктаймом, в чём проблема не понимаю Странно, но VLC плеер открывает ролики хорошо, всё отлично видно и слышно, а родной квиктайм не показывает у меня. В любом случае, с роликами всё нормально, проблема в моём плеере.
Народ хелп
скачал только Word а он ISO, с размером 713 мб,т,е не помешается на СД диск а на двд тоже не записывается,как его можно впихнуть на СД?
спасибо
