MS OFFICE 2010 COMPLETE VIDEO TRAINING JMD007 | B38CE70CBEE54C966C6DB0004F2EC11C3C0351F8

MS OFFICE 2010 COMPLETE VIDEO TRAINING JMD007

Name	MS OFFICE 2010 COMPLETE VIDEO TRAINING JMD007	DOWNLOAD Copy Link
Total Size	1.7 GB
Total Files	307
Hash	B38CE70CBEE54C966C6DB0004F2EC11C3C0351F8

/00 Introduction/
0001 Welcome.mov	7.6 MB
0002 Using the exercise files.mov	774.7 KB
/.../01 Getting Started/
0102 Touring the interface.mov	7.5 MB
0105 Maintaining file compatibility.mov	7.5 MB
0103 Finding the commands you need.mov	5.2 MB
0104 Using Backstage view or the File tab.mov	4.1 MB
0101 Exploring three common uses for Excel.mov	3.4 MB
/.../02 Worksheet Basics/
0204 Targeting large data groups.mov	6.4 MB
0203 Entering data automatically with Auto Fill.mov	6.0 MB
0201 Creating a worksheet.mov	5.6 MB
0202 Techniques for copying and pasting.mov	4.5 MB
0205 Changing a worksheet's structure.mov	3.9 MB
/.../03 Excel Formula Basics/
0304 Adding numbers using Sum and AutoSum.mov	7.0 MB
0307 Preventing errors using absolute references.mov	6.4 MB
0310 Using SUMIF and AVERAGEIF.mov	5.8 MB
0306 Working with numbers in columns.mov	5.4 MB
0303 Adding numbers manually.mov	5.1 MB
0309 Using IF.mov	5.1 MB
0301 Understanding formulas and functions.mov	4.9 MB
0311 Naming and using cell ranges.mov	4.3 MB
0308 Working with times and dates.mov	3.5 MB
0302 Entering data in a worksheet.mov	3.5 MB
0305 Adding a whole worksheet.mov	2.0 MB
/.../04 Essential Formatting/
0406 Adding pictures and shapes.mov	10.3 MB
0401 Formatting numbers and dates.mov	8.2 MB
0405 Using custom conditional formatting.mov	8.1 MB
0403 Adjusting columns, rows, and text.mov	5.9 MB
0404 Using conditional formatting.mov	5.8 MB
0402 Applying fonts, background colors, and borders.mov	5.6 MB
/.../05 Advanced Formatting/
0501 Inserting SmartArt.mov	9.0 MB
0504 Creating and sharing styles.mov	7.7 MB
0502 Coordinating a look using themes.mov	5.1 MB
0503 Applying built-in styles.mov	4.9 MB
0505 Using templates.mov	4.8 MB
0506 Creating and using original templates.mov	3.2 MB
/.../06 Printing Preparation/
0601 Making the pieces fit.mov	6.4 MB
0603 Printing and PDFs.mov	5.4 MB
0602 Inserting headers and footers.mov	4.6 MB
/.../07 Large Excel Projects/
0704 Creating multiple custom worksheet views.mov	9.2 MB
0706 Managing worksheets.mov	8.2 MB
0705 Hiding or grouping rows and columns.mov	7.9 MB
0707 Calculating formulas across worksheets.mov	7.4 MB
0702 Freezing panes.mov	5.1 MB
0703 Repeating row and column titles.mov	4.5 MB
0701 Finding and replacing data.mov	4.2 MB
/.../08 Collaborating with Others/
0806 Saving files in shared locations.mov	12.7 MB
0801 Importing and exporting data in Excel.mov	10.6 MB
0803 Inserting and editing comments.mov	8.9 MB
0802 Setting workbook permissions.mov	7.7 MB
0805 Tracking changes.mov	3.8 MB
0804 Sharing a workbook.mov	1.8 MB
/.../09 Exploring Excel's Database Features/
0903 Basic and multi-field sorting.mov	8.7 MB
0906 Creating lookup tables.mov	7.1 MB
0904 Using tables to sort and filter data.mov	7.0 MB
0902 Joining data from multiple cells.mov	5.4 MB
0905 Inserting automatic subtotals.mov	4.9 MB
0901 Splitting cell data into multiple cells.mov	3.2 MB
/.../10 Analyzing Data/
1006 Exploring the Analysis Toolpak.mov	9.4 MB
1001 Using auditing to diagram.mov	7.4 MB
1004 Using data tables in formulas.mov	6.8 MB
1005 Using scenarios in formulas.mov	6.2 MB
1003 Working with Goal Seek.mov	6.1 MB
1002 Using evaluation in Excel.mov	2.4 MB
/.../11 Advanced Analysis with PivotTables/
1103 Modifying a PivotTable.mov	8.0 MB
1104 Creating and modifying a PivotChart.mov	7.5 MB
1102 Creating a basic PivotTable.mov	3.2 MB
1101 Discovering PivotTables.mov	2.4 MB
/.../12 Creating and Using Charts/
1205 Creating and modifying a pie chart.mov	8.5 MB
1204 Modifying a column chart.mov	7.2 MB
1206 Placing Excel charts into other Office applications.mov	6.1 MB
1202 Inserting Sparklines.mov	4.7 MB
1203 Creating a column chart.mov	3.8 MB
1201 Choosing chart types.mov	1.8 MB
/.../13 Creating and Using Macros/
1302 Recording and using a simple macro.mov	14.8 MB
1303 Editing a macro.mov	7.6 MB
1301 Understanding macros.mov	2.9 MB
/.../14 Customizing Excel/
1402 Customizing the Ribbon bar.mov	13.8 MB
1403 Setting Excel options.mov	10.2 MB
1401 Customizing the Quick Access toolbar.mov	4.5 MB
/15 Conclusion/
1501 Goodbye.mov	250.2 KB
/Exercise Files/
Ex_Files_Excel2010_EssT.zip	8.6 MB
/.../Ex_Files_PP_2010_EssT/Exercise Files/Assets/
Video Tour.wmv	21.0 MB
New Employee Orientation with Modifications.pptx	3.7 MB
Jazzy Groove.mp3	2.8 MB
Money Fan.JPG	1.5 MB
Brochure.doc	1.5 MB
Headshot Maria.jpg	1.0 MB
Ranch 1.jpg	610.7 KB
Ranch 3.JPG	592.9 KB
Ranch 4.JPG	460.9 KB
Background 1.jpg	455.4 KB
Catalog.docx	374.9 KB
Ranch 2.JPG	352.3 KB
Background 2.jpg	253.9 KB
Olive 5.JPG	245.1 KB
Olive 4.jpg	226.4 KB
Processing 2.JPG	223.3 KB
Processing 1.JPG	180.5 KB
Appetizer.jpg	176.1 KB
Website.png	175.0 KB
Product Line.jpg	165.2 KB
TwoTrees-RoundedGreenLogo.jpg	164.7 KB
Olive 2.JPG	160.3 KB
Controls 1.JPG	159.0 KB
Olive 1.JPG	155.0 KB
Controls 2.JPG	154.7 KB
Bottle Close-Up.jpg	147.9 KB
Olive 3.JPG	111.3 KB
Bottle.jpg	76.9 KB
Headshot Andrew.jpg	55.6 KB
Illustration Olive Tree.jpg	41.8 KB
Headshot Tony.jpg	40.7 KB
Headshot Jimmy.jpg	39.9 KB
Headshot Andy.jpg	36.3 KB
TwoOlives Bullet.png	26.7 KB
Illustration Olives and Bread.jpg	15.1 KB
Why We're Special.docx	13.5 KB
Quarterly Sales Results.xlsx	13.3 KB
Thumbs.db	7.7 KB
/.../Ex_Files_PP_2010_EssT/Exercise Files/Chapter_01/
New Employee Orientation 01.pptx	3.7 MB
/.../Ex_Files_PP_2010_EssT/Exercise Files/Chapter_02/
Running the Show.pptx	442.7 KB
Applying a Theme.pptx	354.8 KB
Saving Your Presentation.pptx	354.8 KB
Using the Thesaurus.pptx	354.8 KB
Cheking Your Speling.pptx	354.3 KB
Adding a Photo and Clip Art.pptx	62.2 KB
Separating Your Show into Sections.pptx	58.1 KB
Rearranging Slides.pptx	57.9 KB
Saving Time with Outline Mode.pptx	57.8 KB
Deleting Slides and Changing Layouts.pptx	42.3 KB
Adding and Deleting Slides.pptx	31.7 KB
/.../Ex_Files_PP_2010_EssT/Exercise Files/Chapter_03/
Applying Slide Transitions.pptx	3.3 MB
Saving the Design Template.pptx	3.3 MB
Adding a Logo to the Background.pptx	2.7 MB
Understanding Slide Masters.pptx	2.4 MB
Changing Slide Backgrounds.pptx	2.4 MB
Removing Backgrounds from Photos.pptx	456.4 KB
Picture Effects.pptx	454.6 KB
Changing Text Alignment.pptx	454.6 KB
Adding Bullets and Numbered Lists.pptx	454.4 KB
Using Font and Color.pptx	442.7 KB
/.../Ex_Files_PP_2010_EssT/Exercise Files/Chapter_04/
Pasting Charts from Excel.pptx	3.3 MB
Creating a Chart.pptx	3.3 MB
Pasting a Table from Excel.pptx	3.3 MB
Formatting Tables.pptx	3.3 MB
Creating a Table.pptx	3.3 MB
/.../Ex_Files_PP_2010_EssT/Exercise Files/Chapter_05/
Animating Text Shapes and Other Objects.pptx	4.4 MB
Working with Layers.pptx	3.5 MB
Adding Text Boxes.pptx	3.5 MB
Adding Text to Shapes.pptx	3.5 MB
Moving Resizing Formatting and Rotating Shapes.pptx	3.5 MB
Adding Shapes.pptx	3.3 MB
/.../Ex_Files_PP_2010_EssT/Exercise Files/Chapter_06/
Cropping a Video.pptx	28.6 MB
Adding Video.pptx	7.3 MB
Adding an Audio Clip.pptx	4.4 MB
/.../Ex_Files_PP_2010_EssT/Exercise Files/Chapter_07/
Adding Process Cycle and other Diagrams.pptx	4.6 MB
Adding Organizational Charts.pptx	4.4 MB
/.../Ex_Files_PP_2010_EssT/Exercise Files/Chapter_08/
Broadcasting on the Web.pptx	4.7 MB
PowerPoint Web App.pptx	4.7 MB
Presenting on Another Laptop.pptx	4.7 MB
Saving as a Video.pptx	4.7 MB
Saving Your Presentation as a PDF.pptx	4.7 MB
Printing a Presentation.pptx	4.6 MB
Adding Speaker Notes.pptx	4.6 MB
/.../Ex_Files_PP_2010_EssT/Exercise Files/
Thumbs.db	12.8 KB
/01 - Introduction/
0001 Welcome.mov	8.8 MB
0002 What is PowerPoint.mov	2.7 MB
0003 Using the exercise files.mov	1.2 MB
/.../01 Understanding the PowerPoint 2010 Interface/
0104 Customizing the Office Ribbon.mov	9.9 MB
0103 Customizing the view.mov	8.6 MB
0102 Using the Office Ribbon.mov	7.6 MB
0101 Managing your presentations with Backstage.mov	5.8 MB
/.../02 Getting Started/
0207 Adding photos and clip art.mov	6.6 MB
0206 Separating your show into sections.mov	6.1 MB
0211 Applying a theme.mov	5.6 MB
0210 Saving a presentation.mov	5.2 MB
0208 Spell-checking.mov	4.6 MB
0205 Saving time with Outline mode.mov	4.5 MB
0212 Running the show.mov	4.0 MB
0202 Adding slides and content.mov	3.5 MB
0201 Starting from scratch.mov	2.9 MB
0203 Deleting slides and changing layouts.mov	2.8 MB
0204 Rearranging slides.mov	2.4 MB
0209 Using the thesaurus.mov	1.5 MB
/.../03 Formatting a Presentation/
0309 Applying slide transitions.mov	13.0 MB
0308 Adding a logo to the background.mov	9.7 MB
0301 Using fonts and color.mov	9.3 MB
0304 Using picture effects.mov	7.8 MB
0305 Removing backgrounds from photos.mov	7.7 MB
0306 Understanding slide masters.mov	5.3 MB
0307 Changing slide backgrounds.mov	4.9 MB
0303 Changing text alignment.mov	2.7 MB
0310 Saving the design template.mov	2.6 MB
0302 Adding bullets and list numbering.mov	2.4 MB
/.../04 Adding Tables and Charts/
0403 Pasting tables from Excel.mov	6.8 MB
0402 Formatting tables.mov	5.2 MB
0405 Pasting charts from Excel.mov	4.9 MB
0404 Creating charts.mov	3.5 MB
0401 Creating tables.mov	2.8 MB
/.../05 Working with Shapes/
0505 Working with layers (Send to Back and Send to Front).mov	8.9 MB
0502 Moving, resizing, formatting, and rotating shapes.mov	8.1 MB
0506 Animating text, shapes, and other objects.mov	6.4 MB
0504 Adding text boxes.mov	5.0 MB
0503 Adding text to shapes.mov	4.2 MB
0501 Adding shapes.mov	4.1 MB
/.../06 Adding Audio and Video/
0603 Cropping video.mov	10.1 MB
0602 Adding video.mov	9.3 MB
0601 Adding an audio clip.mov	4.1 MB
/.../07 Adding SmartArt and Diagrams/
0702 Adding cycle diagrams, Venn diagrams, and other diagrams.mov	13.1 MB
0701 Adding organizational charts.mov	7.0 MB
/.../08 Sharing with Others/
0801 Printing a presentation.mov	6.9 MB
0806 Saving as a video.mov	5.9 MB
0805 Broadcasting on the web.mov	5.4 MB
0804 Presenting on another laptop (packaging).mov	5.3 MB
0807 Using web apps through SharePoint.mov	4.7 MB
0803 Saving your presentation as a PDF.mov	4.4 MB
0802 Adding speaker notes.mov	3.7 MB
/09 Conclusion/
0901 Goodbye.mov	3.8 MB
/00 Introduction/
0001 Welcome.mov	9.1 MB
0003 Creating placeholder text.mov	3.6 MB
0002 Using the exercise files.mov	1.7 MB
/.../01 Getting Started with Word 2010/
0104 Using Word's document tools.mov	15.4 MB
0105 Using the Navigation pane to find words or phrases in a document.mov	10.6 MB
0102 Understanding the Ribbon.mov	10.6 MB
0103 Customizing the Quick Access toolbar.mov	3.6 MB
0101 Using the Word interface.mov	262.1 KB
/.../02 Word Backstage From New to Print/
0204 Saving a Word document for yourself or others.mov	9.6 MB
0206 Setting print options.mov	7.0 MB
0202 Creating a new document from a template.mov	6.6 MB
0203 Making it easy to find and open documents.mov	5.6 MB
0201 Managing documents with Backstage view.mov	5.1 MB
0205 Printing a document and choosing a printer.mov	5.0 MB
/.../03 Editing Text/
0304 Finding and replacing text.mov	11.6 MB
0302 Rearranging text using Cut, Copy, and Paste.mov	8.8 MB
0301 Selecting text using the mouse and keyboard shortcuts.mov	7.0 MB
0303 Undoing and redoing actions.mov	4.7 MB
/.../04 Formatting Text/
0402 Working with fonts.mov	8.5 MB
0403 Applying basic formatting.mov	7.1 MB
0401 Understanding fonts.mov	6.5 MB
0405 Using text effects and adding impact to a document.mov	5.5 MB
0404 Changing the case of text.mov	4.9 MB
/.../05 Formatting Paragraphs/
0503 Using indents and setting tabs.mov	8.9 MB
0504 Creating a bulleted or numbered list.mov	6.9 MB
0502 Changing line spacing.mov	5.9 MB
0505 Keeping text together through page breaks.mov	4.5 MB
0501 Aligning and justifying paragraphs.mov	3.3 MB
/.../06 Using Styles for More Effective Formatting/
0601 Power formatting with styles.mov	10.3 MB
0602 Changing a document's theme.mov	9.9 MB
0604 Applying Quick Styles and clearing formatting.mov	9.4 MB
0609 Creating a multilevel list using styles.mov	9.2 MB
0605 Creating a Quick Style set.mov	8.6 MB
0607 Easily creating a table of contents.mov	7.8 MB
0608 Restricting formatting to a selection of styles.mov	6.1 MB
0606 Using the Navigation pane with styles.mov	5.4 MB
0603 Changing style sets, color sets, fonts, and paragraph spacing.mov	5.3 MB
/.../07 Working with Tables/
0708 Inserting an Excel table for calculations and charts.mov	10.2 MB
0706 Merging, splitting, and formatting cells to create a form.mov	9.8 MB
0701 Creating a table to organize text.mov	7.3 MB
0705 Sorting table data.mov	6.4 MB
0704 Adding and removing columns.mov	6.1 MB
0703 Formatting tables for readability.mov	5.3 MB
0709 Using Quick Tables.mov	5.0 MB
0702 Converting text to tables.mov	3.8 MB
0707 Converting a table to text.mov	3.0 MB
/.../08 Illustrating a Document/
0809 Illustrating with diagrams Using SmartArt.mov	16.0 MB
0801 Illustrating documents with pictures, shapes, and clip art.mov	13.8 MB
0808 Illustrating with charts Inserting a chart from Excel.mov	12.0 MB
0802 Positioning, sizing, and cropping graphics.mov	9.5 MB
0804 Laying out text and graphics with a table.mov	9.3 MB
0807 Applying styles to graphics.mov	9.2 MB
0803 Wrapping text around graphics.mov	7.8 MB
0806 Applying special effects to graphics.mov	7.1 MB
0805 Adjusting brightness, contrast, and sharpness of photos.mov	6.5 MB
0811 Illustrating with WordArt.mov	5.1 MB
0810 Illustrating with screenshots Capturing screenshots from your computer.mov	3.9 MB
/.../09 Document Building Blocks/
0904 Using text boxes for document design.mov	13.6 MB
0902 Numbering pages and applying headers and footers.mov	10.0 MB
0905 Creating and saving custom headers and footers.mov	7.2 MB
0901 Understanding building blocks.mov	6.0 MB
0906 Creating and saving Quick Parts.mov	5.9 MB
0903 Adding cover pages and blank pages.mov	5.8 MB
/.../10 Modifying Page Layout/
62219_10_04_SC11_watermarks[1].mov	9.8 MB
62219_10_01_SC11_margins[1].mov	9.0 MB
62219_10_02_SC11_sections[1].mov	8.0 MB
62219_10_03_SC11_columns[1].mov	7.8 MB
/.../11 Proofing Documents/
1103 Using the Thesaurus and Research and Translation tools.mov	12.8 MB
1102 Setting proofing and AutoCorrect options.mov	7.7 MB
1101 Checking spelling and grammar.mov	6.9 MB
/.../12 Reviewing Documents with Others/
1203 Comparing and combining documents.mov	11.5 MB
1201 Tracking changes and showing markup.mov	6.3 MB
1202 Accepting and rejecting changes.mov	5.8 MB
1204 Coauthoring documents with SharePoint.mov	5.4 MB
/.../13 Sharing Documents/
1301 Trouble-free document sharing.mov	9.2 MB
1308 Restricting editing for all or part of a document.mov	8.7 MB
1309 Digitally signing a document.mov	7.2 MB
1302 Emailing a document.mov	6.1 MB
1306 Blogging with a document.mov	5.7 MB
1304 Saving to SharePoint and sharing a document link.mov	5.0 MB
1307 Finalizing and password-protecting a document.mov	4.9 MB
1303 Saving a document to a Windows Live drive.mov	4.7 MB
1305 Using Word on the web.mov	3.6 MB
/.../14 Customizing Word/
1402 Customizing the Ribbon.mov	9.8 MB
1403 Creating and playing a macro.mov	9.6 MB
1401 Changing Word options.mov	6.6 MB
1404 Assigning a macro to the Ribbon.mov	5.8 MB
/15 Conclusion/
1501 Goodbye.mov	447.3 KB
/Exercise Files/
Ex_Files_Word_2010_EssT.zip	60.4 MB
Total files 307