Premium Bundle - Microsoft Office 2010 Training Video

Información importante

Curso

Online

Cuándo:A definir

Descripción

Premium Bundle - Learning Microsoft Office 2010 Training Video A Practical Training Course That Teaches Real World Skills In this project-based Premium Bundle - Learning Microsoft Office 2010 video tutorial series, you'll quickly have relevant skills for real-world applications. Follow along with our expert instructor in this Premium Bundle - Microsoft Office 2010 Training Video course to get: Concise, informative and broadcast-quality Premium Bundle - Learning Microsoft Office 2010 training videos delivered to your desktop The ability to learn at your own pace with our intuitive, easy-to-use interface A quick grasp of even the most complex Premium Bundle - Learning Microsoft Office 2010 subjects because they're broken into simple, easy to follow tutorial videos Practical working files further enhance the learning process and provide a degree of retention that is unmatched by any other form of Premium Bundle - Learning Microsoft Office 2010 tutorial, online or offline... so you'll know the exact steps for your own projects. Course Fast Facts: Only 51.5 hours to complete this course 782 tutorial videos Expert instructors lead each course Download to any Windows PC or Mac and save for viewing off line Course is accessible 24/7 from any computer once downloaded You can study from home or at work at your own pace in your own time Course Description Learning Microsoft Word 2010 Learning Microsoft Excel 2010 Learning Microsoft PowerPoint 2010 Learning Microsoft Outlook 2010 Learning Microsoft Project 2010 Learning Microsoft Access 2010
Authors Guy Vaccaro and Tim Ellwood guide you through these powerful Microsoft programs in this computer based training. With over 51 hours of comprehensive instruction, you will very quickly learn everything that you need to to be comfortable with these widely used Office Application programs, including the powerful Microsoft Project and...

Información importante

Requisitos: System Requirements - DVD and Digital Download Digital Download: Microsoft Windows XP or higher, Mac OS X 10.4 or higher. Minimum screen resolution of 1024x768 Digital Download specific requirements: Between 1GB and 6GB of available hard drive space (depending on the training course) An Internet connection with sufficient bandwidth. You must have at least a 56K modem connection (Broadband recommended). Most modern ADSL and Cable internet solutions will be sufficient. Do...

Instalaciones

¿Dónde se da y en qué fecha?

comienzo

Ubicación

A definir

Online

¿Qué aprendes en este curso?

Microsoft Project

Excel

Word

Powerpoint

Access

Presentation

Options

Basic

Windows

Basic IT training

Office IT

Microsoft Excel

Microsoft Word

Microsoft Powerpoint

Database

Database training

Animation

Basic IT

Graphics

Layout

Printing

Drawing

Art

Web

Project

Ms Office

Microsoft excel training

MS Excel

Ms PowerPoint

Skills and Training

Microsoft Office

Ms Word

Temario

01. Microsoft Word 2010 - Introduction

0101 Welcome And Introduction

0102 Accessing MS Word

0103 Backstage

0104 The Ribbon

0105 Quick Access Toolbar

0106 Help Options

02. Microsoft Word 2010 - Starting A Word Document

0201 Opening A New Blank Document

0202 Inserting Text

0203 Navigation

03. Microsoft Word 2010 - Editing Text

0301 Editing Text

0302 Selecting Text

0303 Cut Copy And Move

0304 Paste Preview

0305 Find And Replace

0306 Undo And Redo

04. Microsoft Word 2010 - Formatting Text

0401 Home Tab Font Basic Options

0402 Default Font Settings

0403 Text Effects

0404 Format Painter

0405 Character Spacing

0406 Mini Toolbar

05. Microsoft Word 2010 - Formatting Paragraphs

0501 Alignment

0502 Indentation And Line Spacing

0503 Bulleted And Numbered Lists

0504 Hyphenation

0505 Paragraph Borders And Shading

0506 Controlling Pagination

0507 Using Tabs

0508 Clearing Tabs

06. Microsoft Word 2010 - Formatting Documents

0601 Page And Section Breaks

0602 Page Setup

0603 Page Numbering

0604 Headers And Footers

0605 Footnotes And Endnotes

0606 Creating Columns

0607 Lining Up Columns

0608 Revising Column Structure

07. Microsoft Word 2010 - Styles

0701 Applying Styles

0702 Amending Styles

0703 Creating New Styles

0704 Using Style Sets

08. Microsoft Word 2010 - Index And Contents

0801 Insert A TOC

0802 Updating A TOC

0803 Mark Entries And Insert An Index

09. Microsoft Word 2010 - Tables

0901 Creating A Table

0902 Inserting And Deleting Rows And Columns

0903 Positioning A Table

0904 Row Height And Column Width

0905 Table Borders And Shading

0906 Formatting Cells In A Table

0907 Calculations In Tables

10. Microsoft Word 2010 - Inserting Graphics

1001 Inserting Pictures

1002 Insert ClipArt

1003 Picture Styles

1004 Picture Effects

1005 Shapes

1006 SmartArt

1007 Charts

1008 Screenshots

11. Microsoft Word 2010 - Inserting Links & Text

1101 Using Hyperlinks

1102 Bookmarks

1103 Cross-references

1104 Text Boxes

1105 Quick Parts

1106 WordArt

1107 Insert Symbols

1108 Other Insert Tab Options

12. Microsoft Word 2010 - Page Layout

1201 Themes

1202 Insert A Watermark

1203 Page Background

13. Microsoft Word 2010 - Mailings

1301 Envelopes And Labels

1302 Mail Merge - Data Source

1303 Mail Merge Document - Inserting Fields

1304 Finishing A Mail Merge

14. Microsoft Word 2010 - Proofing

1401 AutoCorrect

1402 Spelling And Grammar

1403 Thesaurus

1404 Translate Options

1405 Tracking Changes

1406 Accepting And Rejecting Changes

1407 Comparing Documents

1408 Publishing And Sharing

1409 Prepare For Sharing

15. Microsoft Word 2010 - View Options

1501 Document Views

1502 Navigation Pane

1503 Zoom Options

1504 Windows

16. Microsoft Word 2010 - Save And Printing

1601 Save A Document

1602 Compatibility Mode

1603 Open A Recent Document

1604 Protecting Documents

1605 Print Preview

1606 Printing A Document

17. Microsoft Word 2010 - Macros

1701 Recording Macros

1702 Viewing And Editing Macros

1703 Running Macros

18. Microsoft Word 2010 - Customizing

1801 Word Options

1802 Advanced Word Options

1803 Customizing The Ribbon

1804 Customizing Quick Access Toolbar

1805 Templates

01. Microsoft Excel 2010 - Getting Started

0101 Overview Of Excel 2010

0102 The New File Menu In Excel 2010

0103 Exploring The Excel Workbook

0104 What Will I Be Able To Do At The End Of This Course

0105 Customizing The Quick Access Toolbar

0106 Working With The Ribbons

0107 Using The Files Included With This Course

02. Microsoft Excel 2010 - Working With An Excel Worksheet

0201 Creating A New Workbook

0202 Saving A Workbook

0203 Saving In Other Formats

0204 Open A Existing Workbook

0205 Navigating An Excel Workbook

03. Microsoft Excel 2010 - Selecting And Entering Data

0301 Entering Text And Numbers

0302 Entering Numbers As Text

0303 Inputting Dates And Times

0304 Editing The Contents Of A Cell

0305 Using Copy And Paste

0306 The FILL Handle

0307 Using Undo And Redo

0308 Shortcuts For Selecting Cells

0309 Inserting Cells, Columns And Rows

0310 Deleting Cells, Columns And Rows

0311 Changing Column Widths And Row Heights

0312 Hiding And Unhiding A Column Or Row

0313 Searching For Values In A Worksheet

04. Microsoft Excel 2010 - Developing A Workbook

Formatting And Naming Of Worksheet Tabs

Moving Worksheets Within And Between Workbooks

Copying Worksheets Within Workbooks

Inserting And Deleting Worksheets

Viewing More Than One Workbook

Hiding And Unhiding Worksheets

05. Microsoft Excel 2010 - Printing And Page Setup

Using The Print Area Command To Control What Excel Prints

Setting Page Margins And Page Orientation

Creating A Header And Footer

Using Page Break View

Setting Print Titles For Large Worksheets

Printing Gridlines Column Row Headings And Other Related Options

Enabling The New Page Layout View

Running The Spell Checker

Print Preview And Printing The Whole Or Part Of The Worksheet

06. Microsoft Excel 2010 - Workbook Formatting

Modifying Typeface, Font Size And Colors

Merging Cells

Applying Number Formats

Aligning Cell Contents

Changing The Text Direction In A Cell

Adding Borders To Cells And Ranges

Applying A Date Format To A Cell Or Range

Use Of The Format Painter

Clearing Cell Contents And/Or Formatting

07. Microsoft Excel 2010 - Carrying Out Calculations

Getting Started With Basic Math Formula Addition

Getting Started With Basic Math Formula Subtraction

Getting Started With Basic Math Formula Multiplication

Getting Started With Basic Math Formula Division

Getting Started With Basic Math Formula Operand

Order Of Operations with BODMAS

Introduction To Excel Formulas: SUM

Copying Formulas And Functions

Displaying Formulae On A Worksheet

Some Useful Functions For Counting

Some Useful Functions For Averages

Some Useful Functions For Highest And Lowest

Absolute Referencing Requirements

Formulas Across Worksheets

Functions Across Worksheets

3D Referencing

Making Use Of Named Cells And Ranges

08. Microsoft Excel 2010 - Advanced Formatting

Enhancing Worksheets Using Themes

Working With Comments

Creating Your Own AutoFill List

Turning Your Data Into A Table For Formatting

09. Microsoft Excel 2010 - Security

Using Protection On A Worksheet

Protecting Part Of A Worksheet To Facilitate Data Entry

Controlling Access To Cell Ranges By Password And Or User Accounts

Saving A Workbook With Password Protection

10. Microsoft Excel 2010 - Using Templates

Creating A Workbook From A Template

Creating Your Own Custom Template

11. Microsoft Excel 2010 - Graphics Objects

Inserting And Modifying Clipart

Using SmartArt Graphics

Adding Drawn Shapes To A Worksheet

Inserting An External Picture

Adding A Background Image To A Worksheet

Formatting Graphic Objects

Controlling Stacking Order And Alignment Of Multiple Graphics Objects

Grouping Graphic Objects

Accessing Formula Results In A Callout Bubble

12. Microsoft Excel 2010 - Using Excel As A Database

Fixing Rows And Columns On Screen

Fixing Rows And Columns For Print

Sorting Data In A Worksheet

Filtering Data In A Worksheet

Removing Duplicates In An Excel Database

Adding And Using Subtotals In An Excel Database

Splitting One Column Of Data Into More Columns

Splitting The Screen To View Different Parts Of The Same Worksheet

Linking To Data On A Webpage

13. Microsoft Excel 2010 - Using Charts In Excel

Creating A Chart The Long Way

Creating A Chart The Quick Way

Changing A Chart From A Sheet Object To A Sheet

Modifying Your Chart Type

Controlling Chart Style And Layout

Adding A Trend line To A Chart

Pie Charts In More Detail

14. Microsoft Excel 2010 - More Advanced Formula

Adding An IF Function For Cell Comparisons

Using the IF Function To Suppress Excel Error Messages

Text Manipulation With Formulae - Part 1

Text Manipulation With Formulae - Part 2

Date Formula In Excel

DATEDIF - A Hidden But Useful Formula

SUMIF COUNTIF And AVERAGEIF

Use Of A Formula To Rank Scores

15. Microsoft Excel 2010 - Conditional Formatting

Changing Cell Appearance Based On Its Value

Editing Conditional Formatting Rules On A Worksheet

Removing Conditional Formatting Rules

Highlighting Duplicate Values Using Conditional Formatting

Identifying The Top Or Bottom Percentage Of A Range

Use Of Data Bars Within Conditional Formatting

Use Of Colour Scales Within Conditional Formatting

Applying An Icon Set To Conditional Formatting Rules

16. Microsoft Excel 2010 - Office Web Apps And Excel

What Is Office Web Apps?

Sign In To Or Sign Up For Your Own SkyDrive

Saving An Excel Workbook Into SkyDrive

Accessing And Editing An Excel Workbook Through SkyDrive

Telling Others Where Your Public Documents Are

Direct Linking Or Embedding Of SkyDrive Documents

Creating A Folder Structure Within SkyDrive

Deleting Files From SkyDrive

17. Microsoft Excel 2010 - Credits And Beyond

About The Author

01. Microsoft PowerPoint 2010 - Before We Begin

0101 What Will I Be Able To Do At The End Of This Course

0102 The New PowerPoint 2010 Interface Views And Ribbons

0103 The File Menu In PowerPoint 2010

0104 Customizing The Quick Access Toolbar

0105 Using The Files Provided With PowerPoint 2010

02. Microsoft PowerPoint 2010 - Getting Started

0201 Starting PowerPoint And A New Presentation

0202 Saving Presentations

0203 Opening And Closing Existing Presentations

0204 Working With More Than One Presentation Open At The Same Time

0205 Screen Layout Options And Zooming

0206 Turn On And Off The Ruler Gridlines And Guides

0207 Adding Extra Slides

0208 Entering Text Onto Slides

0209 Copy And Paste Slide Content

0210 Undo And Redo

0211 Changing The Slide Layout Of An Existing Slide

0212 Spellchecking A Presentation

03. Microsoft PowerPoint 2010 - Slide Design

0301 Using A Presentation Theme

0302 Change Font Style Size And Color

0303 Controlling Your Bullet Point Styles

0304 Paragraph Formatting

0305 Superscript And Subscript

0306 Managing Autocorrect In PowerPoint

04. Microsoft PowerPoint 2010 - Charts And Graphs

0401 Adding Charts To A Presentation

0402 Editing The Data For The Chart

0403 Change The Chart Type

0404 Using A Different Layout And Style

0405 Changing Chart Layout Options

0406 Formatting A Chart

0407 Pie Chart Specific Formatting

0408 Add A Chart To A Slide Without A Chart Placeholder

0409 Removing A Chart From A Slide

05. Microsoft PowerPoint 2010 - Organization Charts

0501 Adding A Slide With An Organization Chart

0502 Insert An Organizational Chart On Any Slide

0503 Adding A New Box To The Chart

0504 Remove A Box From The Organization Chart

0505 Rearranging Box Order Promoting And Demoting

0506 Edit The Organization Chart Layout

0507 Altering The Style Of The Chart And Or Individual Boxes

0508 Removing An Organization Chart From A Presentation

06. Microsoft PowerPoint 2010 - Using Clip Art, Smart Art Or Images

0601 Inserting A Piece Of Clip Art

0602 Inserting Clip Art To Any Slide

0603 Moving And Resizing Clip Art

0604 Remove Clip Art From A Slide

0605 Adding Moving Resizing And Removing Your Own Photographs

0606 Using The Picture Tools Ribbon For Photograph Enhancements

0607 Inserting A Smart Art Object To A Slide

0608 Customizing The Smart Art Graphic

0609 Removing A Smart Art Graphic

07. Microsoft PowerPoint 2010 - Word Art And Managing Drawing Objects

0701 Add Word Art To A Slide

0702 Editing Word Art Content And Style

0703 Removing A Piece Of Word Art

0704 Adding Drawn Shapes To A Slide

0705 Formatting A Drawn Shape

0706 Advanced Editing Of A Shape

0707 Remove A Drawing Object

0708 Aligning Multiple Objects On A Slide

0709 Controlling Stacking Order And Grouping Shapes As One

08. Microsoft PowerPoint 2010 - Managing The Presentation

0801 Exploring The Views Available In PowerPoint

0802 Changing The Display Order Of Slides

0803 Deleting And Hiding Slides

0804 Insert Slides From Another Presentation

09. Microsoft PowerPoint 2010 - Running A Slideshow

0901 Running Your Presentation

0902 Useful Keyboard Commands During A Slideshow

0903 Drawing On A Slide Whilst Running The Slideshow

0904 PowerPoint Laser Pointer For Use During A Slideshow

0905 Rehearsing And Setting Slide Show Timings

0906 Record Narration For A Slideshow

0907 Setting Up A Slideshow

0908 Creating And Using A Custom Show

0909 Saving As A PowerPoint Show

0910 Broadcasting A Presentation In Real Time Across The Internet

10. Microsoft PowerPoint 2010 - Office Web Apps And PowerPoint

1001 What Is Office Web Apps

1002 Sign In To Or Sign Up For Your Own SkyDrive

1003 Uploading Files To Your SkyDrive

1004 Saving A PowerPoint Presentation Directly Into SkyDrive

1005 Accessing And Editing A Presentation Through SkyDrive

1006 Telling Others Where Your SkyDrive Public Documents Are

1007 Direct Linking Or Embedding Of SkyDrive Documents

1008 Creating A Folder Structure Within SkyDrive

1009 Moving Copying And Deleting Files On SkyDrive

1010 Editing Sharing Permissions On Folders In SkyDrive

11. Microsoft PowerPoint 2010 - Templates

1101 Using The Microsoft Supplied PowerPoint Templates

1102 Designing Saving And Using Your Own Template

12. Microsoft PowerPoint 2010 - Animation

1201 Adding Transition Effects To Slides

1202 Adding An Animation Effect To An Object On A Slide

1203 Copying An Animation Effect To Another Object

1204 Previewing Animation Effects

1205 Adding A Secondary (Exit) Animation Effect To An Object

1206 Making An Animation Object Follow A Path

1207 Managing The Order In Which Animations Occur

1208 Change The Animation Effect Assigned To An Object

1209 Removing An Animation Effect From An Object

1210 Changing The Trigger For An Animation Effect

1211 Editing The Effect Options For An Animation Effect

1212 Animating Charts And Smart Art

13. Microsoft PowerPoint 2010 - Speaker Notes

1301 Adding Speaker Notes

1302 Control Layout Of Notes Page Using The Notes Master

1303 Adding A Footer A Header Page Number And Date To The Notes Pages

1304 Printing The Notes Pages

14. Microsoft PowerPoint 2010 - Master Views

1401 Overview And Accessing The Master View

1402 Changing Slide Background Colours

1403 Add A Image As Your Presentation Background

1404 Add A Company Logo To Every Slide

1405 Include A Footer Slide Number And Or Date On Slides

1406 Animating The Slide Master

1407 Using The Handout Master

1408 The Need For Multiple Slide Masters

15. Microsoft PowerPoint 2010 - Printing

1501 Printing Slides

1502 Printing The Presentations Text Content Using Outline View

1503 Printing Handouts

1504 Printing The Notes Pages

16. Microsoft PowerPoint 2010 - Tables

1601 Inserting Tables Onto Slides

1602 Entering Text Into A Table

1603 Inserting And Removing Rows And Columns

1604 Adjusting Row Height And Or Column Width

1605 Merging Multiple Cells Into One Or Splitting One Cell Into Many

1606 Table Styles Explained

1607 Custom Formatting Of Table Colors And Borders

1608 Removing A Table

17. Microsoft PowerPoint 2010 - Flowcharts

1701 Adding A Flowchart...

Información adicional

Digital Download FAQs

Q: What is a digital download?

A digital download is training that you download from the internet using your web browser instead of us shipping you a physical CD.

Q: How instant is the "Instant Purchase"?

If you complete your purchase, you are emailed your access key within minutes of the transaction completing.