Learning | 7641BC17227F76C7D2C73D038B79B4F42BEB245B

Learning

Name	Learning	DOWNLOAD Copy Link
Total Size	2.2 GB
Total Files	696
Hash	7641BC17227F76C7D2C73D038B79B4F42BEB245B

/00 Introduction/
0001 Welcome.mov	6.1 MB
0002 Using the exercise files.mov	524.8 KB
/.../01 Access Basics/
0101 Database concepts and terminology.mov	5.3 MB
0107 Exploring ribbons.mov	3.9 MB
0106 Backstage view.mov	3.2 MB
0108 Using the Navigation pane.mov	2.7 MB
0109 Getting help.mov	2.6 MB
0105 The Quick Access toolbar.mov	1.3 MB
0103 Creating a new file.mov	1.2 MB
0102 Starting Access.mov	1.1 MB
0104 Trusting a file.mov	970.2 KB
/.../02 Creating a First Database and Using the Tools/
0202 Creating tables using Application Parts.mov	7.2 MB
0206 Creating a lookup field.mov	4.6 MB
0203 Creating tables in Layout view with Quick Start.mov	4.2 MB
0204 Creating and editing tables in Design view.mov	2.9 MB
0207 Creating multi-value fields.mov	2.7 MB
0201 Planning and designing your database.mov	1.6 MB
0205 Setting a primary key.mov	1.5 MB
0208 Using calculated fields.mov	1.1 MB
/.../03 Setting Up the Data/
0301 Setting field properties.mov	8.4 MB
0303 Setting validation rules.mov	3.8 MB
0302 Setting input masks.mov	2.4 MB
/.../04 Building Structure/
0401 Creating relationships and enforcing referential integrity.mov	5.0 MB
0402 Viewing subdatasheets.mov	1.2 MB
/.../05 Formatting and Appearance/
0501 Entering data into your tables.mov	9.9 MB
0503 Finding, sorting, and filtering records.mov	8.6 MB
0502 Formatting tables.mov	6.4 MB
/06 Forms/
0604 Using Design view.mov	19.1 MB
0603 Modifying a form in Layout view.mov	9.3 MB
0607 Using navigation forms.mov	4.5 MB
0601 Creating data-entry forms.mov	3.1 MB
0606 Adding buttons to a form.mov	2.5 MB
0605 Setting tab stops.mov	2.3 MB
0602 Using the Form Wizard.mov	1.8 MB
/07 Queries/
0703 Creating a query in Design view with criteria.mov	4.8 MB
0710 Using update queries.mov	3.5 MB
0707 Creating and and or queries.mov	3.4 MB
0709 Creating statistical queries.mov	3.3 MB
0708 Building calculation queries.mov	3.2 MB
0712 Creating crosstab queries.mov	2.5 MB
0702 Using the Query Wizard.mov	2.5 MB
0711 Using delete queries.mov	2.2 MB
0705 Creating reusable parameter queries.mov	1.8 MB
0706 Creating yes no queries.mov	1.7 MB
0704 Creating wildcard queries.mov	1.6 MB
0701 Introduction to queries.mov	1.5 MB
/08 Reports/
0803 Formatting reports in Layout view.mov	7.4 MB
0807 Adding totals and subtotals to a report.mov	4.4 MB
0805 Adding group and sort capabilities to a report.mov	3.6 MB
0808 Adding conditional formatting and data bars to a report.mov	3.4 MB
0804 Identifying report structure in Design view.mov	3.2 MB
0810 Creating mailing labels.mov	3.0 MB
0806 Adding existing fields from other tables.mov	2.8 MB
0802 Using the Report Wizard.mov	2.5 MB
0801 Introduction to reports.mov	2.3 MB
0809 Creating multi-table reports.mov	2.0 MB
0811 Printing reports.mov	1.7 MB
/.../09 Putting Data to Work/
0901 PivotTables.mov	3.1 MB
0902 PivotCharts.mov	2.6 MB
/.../10 Automating with Macros/
1001 Creating macros.mov	3.4 MB
1002 Attaching macros to objects.mov	2.9 MB
1003 Using data macros.mov	2.7 MB
/.../11 Using Other Applications with Access/
1101 Importing Excel and text data.mov	5.1 MB
1107 Collecting data over email.mov	3.6 MB
1109 Publishing to SharePoint.mov	3.6 MB
1105 Publishing to a web browser in HTML or XML.mov	3.2 MB
1108 Using Package and Sign.mov	1.8 MB
1102 Exporting data into Excel.mov	1.7 MB
1103 Exporting to PDF.mov	1.3 MB
1106 Sharing via email.mov	1.2 MB
1104 Exporting into a Word Mail Merge.mov	1.2 MB
1110 Importing and exporting with SharePoint.mov	994.3 KB
/.../12 Advanced Tools in the Database/
1203 Encrypting a database and setting a password.mov	3.1 MB
1204 Splitting a database.mov	2.9 MB
1202 Using data analysis tools.mov	1.5 MB
1201 Compacting and repairing a database.mov	1.3 MB
/13 Customization/
1302 Setting Access options.mov	8.4 MB
1301 Customizing the ribbons.mov	1.8 MB
/14 Conclusion/
1401 Goodbye.mov	210.4 KB
/Exercise Files/Chapter 1/
TwoTreesOliveOil_navigationpane.accdb	2.4 MB
TwoTreesOliveOil_ribbons.accdb	2.1 MB
TwoTreesOliveOil_help.accdb	372.7 KB
TwoTreesOliveOil_backstage.accdb	372.7 KB
TwoTreesOliveOil_quickaccess.accdb	368.6 KB
TwoTreesOliveOil_trusted.accdb	356.4 KB
/Exercise Files/Chapter 10/
TwoTreesOliveOil_datamacros.accdb	2.6 MB
TwoTreesOliveOil_macrobuttons.accdb	2.5 MB
TwoTreesOliveOil_macros.accdb	2.5 MB
/Exercise Files/Chapter 11/
TwoTreesOliveOil_sharepoint.accdb	2.6 MB
TwoTreesOliveOil_packageandsign.accdb	2.6 MB
TwoTreesOliveOil_exportingexcel.accdb	2.6 MB
TwoTreesOliveOil_collectingemail.accdb	2.6 MB
TwoTreesOliveOil_exportingpdf.accdb	2.5 MB
TwoTreesOliveOil_htmlxml.accdb	2.5 MB
TwoTreesOliveOil_sendingemail.accdb	2.5 MB
TwoTreesOliveOil_mailmerge.accdb	2.5 MB
TwoTreesOliveOil_importingcsv.accdb	2.5 MB
TwoTreesOliveOil_signed.accdc	690.9 KB
Olive Cost.xlsx	10.8 KB
Olive Inventory.csv	0.6 KB
/Exercise Files/Chapter 12/
TwoTreesOliveOil_compactrepair.accdb	2.7 MB
TwoTreesOliveOil_password.accdb	2.6 MB
TwoTreesOliveOil_splitting.accdb	2.6 MB
TwoTreesOliveOil_databaseanalysis.accdb	2.6 MB
TwoTreesOliveOil_splitting.laccdb	0.1 KB
/Exercise Files/Chapter 13/
TwoTreesOliveOil_options.accdb	2.6 MB
TwoTreesOliveOil_customizeribbons.accdb	2.6 MB
/Exercise Files/Chapter 2/
TwoTreesOliveOil_calculatedfields.accdb	618.5 KB
TwoTreesOliveOil_multivalue.accdb	593.9 KB
TwoTreesOliveOil_lookupfields.accdb	585.7 KB
TwoTreesOliveOil_primarykey.accdb	557.1 KB
TwoTreesOliveOil_designview.accdb	512.0 KB
TwoTreesOliveOil_tablelayout.accdb	450.6 KB
TwoTreesOliveOil_applicationparts.accdb	356.4 KB
/Exercise Files/Chapter 3/
TwoTreesOliveOil_inputmasks.accdb	647.2 KB
TwoTreesOliveOil_validation.accdb	647.2 KB
TwoTreesOliveOil_fieldproperties.accdb	647.2 KB
/Exercise Files/Chapter 4/
TwoTreesOliveOil_subdatasheets.accdb	1.3 MB
TwoTreesOliveOil_relationships.accdb	745.5 KB
/Exercise Files/Chapter 5/
TwoTreesOliveOil_filtering.accdb	1.3 MB
TwoTreesOliveOil_formatting.accdb	1.3 MB
TwoTreesOliveOil_enteringdata.accdb	819.2 KB
apollock.jpg	32.7 KB
Reseller Contract2.docx	19.3 KB
Reseller Contract.docx	19.0 KB
/Exercise Files/Chapter 6/
TwoTreesOliveOil_navigation.accdb	2.5 MB
TwoTreesOliveOil_tabstops.accdb	1.9 MB
TwoTreesOliveOil_buttons.accdb	1.9 MB
TwoTreesOliveOil_layoutview.accdb	1.7 MB
TwoTreesOliveOil_formdesign.accdb	1.6 MB
TwoTreesOliveOil_formwizard.accdb	1.4 MB
TwoTreesOliveOil_forms.accdb	1.3 MB
TwoTreesLogo-SquareGradient.jpg	252.4 KB
/Exercise Files/Chapter 7/
TwoTreesOliveOil_statisticalquery.accdb	2.1 MB
TwoTreesOliveOil_aboutqueries.accdb	2.1 MB
TwoTreesOliveOil_crosstabquery.accdb	2.0 MB
TwoTreesOliveOil_deletequery.accdb	2.0 MB
TwoTreesOliveOil_updatequery.accdb	2.0 MB
TwoTreesOliveOil_calculationquery.accdb	2.0 MB
TwoTreesOliveOil_parameterquery.accdb	1.9 MB
TwoTreesOliveOil_yesnoquery.accdb	1.9 MB
TwoTreesOliveOil_andorquery.accdb	1.9 MB
TwoTreesOliveOil_wildcards.accdb	1.9 MB
TwoTreesOliveOil_querydesign.accdb	1.9 MB
TwoTreesOliveOil_querywizard.accdb	1.9 MB
/Exercise Files/Chapter 8/
TwoTreesOliveOil_printing.accdb	2.3 MB
TwoTreesOliveOil_conditionalformatting.accdb	2.3 MB
TwoTreesOliveOil_labels.accdb	2.3 MB
TwoTreesOliveOil_multitable.accdb	2.3 MB
TwoTreesOliveOil_reporttotals.accdb	2.2 MB
TwoTreesOliveOil_addingafield.accdb	2.2 MB
TwoTreesOliveOil_groupingsorting.accdb	2.2 MB
TwoTreesOliveOil_reportdesign.accdb	2.1 MB
TwoTreesOliveOil_reportlayout.accdb	2.1 MB
TwoTreesOliveOil_reportwizard.accdb	2.1 MB
TwoTreesOliveOil_aboutreports.accdb	2.0 MB
/Exercise Files/Chapter 9/
TwoTreesOliveOil_pivotcharts.accdb	2.4 MB
TwoTreesOliveOil_pivottables.accdb	2.3 MB
/Access 2010 Essential Training/
برنامج لتشغيل الفيديو.exe	15.6 MB
NFO.txt	0.9 KB
/00 Introduction/
0001 Welcome.mov	4.3 MB
0002 Using the exercise files.mov	502.5 KB
/.../01 The New Interface/
0104 Working with Application Parts.mov	3.3 MB
0101 Exploring Backstage view.mov	3.0 MB
0103 Using the improved ribbons.mov	2.8 MB
0102 Enabling Trusted Documents.mov	1.3 MB
/.../02 The New Table Features/
0201 Improving structure with the table tools.mov	5.2 MB
0202 Using QuickStart fields.mov	2.3 MB
0203 Creating calculated fields.mov	1.5 MB
/.../03 The New Form and Report Features/
0303 Using conditional formatting.mov	3.5 MB
0301 Exploring Layout view.mov	3.0 MB
0302 Understanding navigation forms.mov	2.8 MB
/04 Macros/
0401 Developing macros with Macro Designer.mov	3.4 MB
0402 Triggering data macros.mov	3.2 MB
/.../05 The New Importing and Exporting Options/
0501 Working with external data.mov	4.7 MB
/.../06 SharePoint Server/
0601 Integrating SharePoint publishing.mov	2.3 MB
/07 Conclusion/
0701 Goodbye.mov	187.7 KB
/Exercise Files/Chapter 01/
Two Trees Olive Oil_01_01.accdb	3.7 MB
Two Trees Olive Oil_01_04.accdb	524.3 KB
Two Trees Olive Oil_01_02.accdb	376.8 KB
/Exercise Files/Chapter 02/
Two Trees Olive Oil_02_03.accdb	606.2 KB
Two Trees Olive Oil_02_01.accdb	561.2 KB
Two Trees Olive Oil_02_02.accdb	376.8 KB
/Exercise Files/Chapter 03/
Two Trees Olive Oil_03_02.accdb	725.0 KB
Two Trees Olive Oil_03_03.accdb	725.0 KB
Two Trees Olive Oil_03_01.accdb	700.4 KB
/Exercise Files/Chapter 04/
Two Trees Olive Oil_04_02.accdb	786.4 KB
Two Trees Olive Oil_04_01.accdb	716.8 KB
/Exercise Files/Chapter 05/
Two Trees Olive Oil_05_01.accdb	794.6 KB
/Exercise Files/Chapter 06/
Two Trees Olive Oil_06_01.accdb	806.9 KB
/Access 2010 New Features/
برنامج لتشغيل الفيديو.exe	15.6 MB
NFO.txt	0.8 KB
/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/chapt 1/
backstage view.xlsx	155.1 KB
ribbon bar.xlsx	155.1 KB
current format.xlsx	149.8 KB
what is excel for.xlsx	147.0 KB
touring the interface.xlsx	140.2 KB
older format workbook.xls	35.3 KB
/Exercise Files/chapt 10/
data tables.xlsx	142.3 KB
analysis toolpack.xlsx	141.4 KB
auditing.xlsx	141.3 KB
goal seek.xlsx	138.3 KB
scenarios.xlsx	136.4 KB
evaluate.xlsx	22.6 KB
/Exercise Files/chapt 11/
pivot table.xlsx	159.5 KB
pivot chart.xlsx	151.0 KB
modifying a pivottable.xlsx	144.2 KB
create pivot table.xlsx	139.3 KB
/Exercise Files/chapt 12/
placing chart.xlsx	140.3 KB
modifying a chart.xlsx	139.9 KB
sparklines.xlsx	139.8 KB
column chart.xlsx	138.1 KB
pie chart.xlsx	138.1 KB
insert pie chart.pptx	77.0 KB
insert pie chart.docx	44.3 KB
/Exercise Files/chapt 13/
editing macro.xlsm	160.3 KB
west data.xlsx	138.5 KB
overseas data.xlsx	138.3 KB
recording macro.xlsx	138.0 KB
northeast data.xlsx	138.0 KB
southeast data.xlsx	137.9 KB
/Exercise Files/chapt 14/
setting options.xlsx	141.6 KB
customizing ribbon.xlsx	141.6 KB
customizing QAT.xlsx	141.6 KB
Bob's Customizations.exportedUI	1.1 KB
/Exercise Files/chapt 2/
rows and columns.xlsx	140.2 KB
selections.xlsx	11.8 KB
autofill.xlsx	9.4 KB
clipboard.xlsx	9.0 KB
/Exercise Files/chapt 3/
sumif.xlsx	141.1 KB
if.xlsx	139.0 KB
creating range names.xlsx	21.1 KB
sum.xlsx	12.9 KB
whole worksheet.xlsx	12.9 KB
average.xlsx	12.9 KB
dates.xlsx	11.7 KB
manual.xlsx	11.5 KB
absolute refs.xlsx	11.4 KB
expense report.xlsx	9.6 KB
formulas and functions.xlsx	9.6 KB
/Exercise Files/chapt 4/
custom conditional formatting.xlsx	139.8 KB
conditional formatting.xlsx	139.8 KB
pictures - finished.xlsx	75.8 KB
bottle.jpg	49.6 KB
pictures.xlsx	14.9 KB
adjusting.xlsx	12.4 KB
fonts.xlsx	12.0 KB
formatting numbers.xlsx	11.9 KB
/Exercise Files/chapt 5/
logo.jpg	164.7 KB
custom styles.xlsx	141.3 KB
styles.xlsx	141.0 KB
merge styles.xlsx	140.3 KB
smart art.xlsx	139.1 KB
turn into template.xlsx	138.9 KB
garlic.jpg	52.2 KB
gift pack.jpg	32.1 KB
themes.xlsx	26.1 KB
herbs.jpg	19.8 KB
/Exercise Files/chapt 6/
create PDFs.xlsx	91.3 KB
headers and footers.xlsx	69.5 KB
page size.xlsx	69.3 KB
logo.jpg	24.7 KB
/Exercise Files/chapt 7/
freezing panes.xlsx	157.1 KB
3D formulas.xlsx	155.5 KB
views.xlsx	143.5 KB
grouping.xlsx	140.9 KB
repeating rows.xlsx	140.6 KB
find and replace.xlsx	140.5 KB
managing worksheets.xlsx	139.8 KB
/Exercise Files/chapt 8/
comments.xlsx	206.3 KB
permissions.xlsx	147.5 KB
sharing.xlsx	142.1 KB
protecting.xlsx	142.1 KB
import into this.xlsx	139.6 KB
export this.xlsx	139.2 KB
kalamata.jpg	63.8 KB
multi-pack 1.jpg	32.1 KB
saving shared locations.xlsx	12.2 KB
import data.csv	2.2 KB
import data.txt	2.2 KB
/Exercise Files/chapt 9/
tables.xlsx	143.0 KB
subtotals.xlsx	142.8 KB
sorting.xlsx	142.4 KB
merging.xlsx	142.4 KB
splitting.xlsx	142.1 KB
lookups.xlsx	138.3 KB
/Excel 2010 Essential Training/
برنامج لتشغيل الفيديو.exe	15.6 MB
NFO.txt	0.9 KB
/00 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
/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
/Exercise Files/Chapter_01/
New Employee Orientation 01.pptx	3.7 MB
/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
/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
/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
/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
/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
/Exercise Files/Chapter_07/
Adding Process Cycle and other Diagrams.pptx	4.6 MB
Adding Organizational Charts.pptx	4.4 MB
/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
/PowerPoint 2010 Essential Training/
برنامج لتشغيل الفيديو.exe	15.6 MB
NFO.txt	1.2 KB
/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/Chapter 01/
Definitions Enhanced.docx	1.0 MB
TwoTreesHandbook.docx	68.0 KB
01_03_Definitions.docx	17.1 KB
Definitions.docx	17.1 KB
/Exercise Files/Chapter 02/
02_03_TwoTreesHandbook.docx	68.0 KB
02_01_Definitions - v2003.doc	31.2 KB
Report Enhanced.wps	17.4 KB
/Exercise Files/Chapter 03/
Definitions with Photos.docx	1.0 MB
Definitions.docx	17.1 KB
03_02_Rearrange.docx	16.9 KB
03_03_UndoRedo.docx	16.2 KB
03_04_FindReplace.docx	13.4 KB
03_02_Chart.xlsx	11.5 KB
/Exercise Files/Chapter 04/
04_05_Text Effects.docx	101.2 KB
04_04_Changing Case.docx	17.6 KB
Definitions.docx	17.1 KB
/Exercise Files/Chapter 05/
05_05 Keeping Text Together.docx	18.6 KB
05_03 Definitions - Tabs.docx	18.1 KB
05_06 Definitions.docx	17.4 KB
05_02 Definitions.docx	17.4 KB
05_01 Definitions.docx	17.4 KB
05_05 Definitions.docx	17.4 KB
05_04 Lists.docx	14.2 KB
/Exercise Files/Chapter 06/
06_03_Definitions.docx	108.0 KB
06_TwoTreesHandbook.docx	62.2 KB
06_09 Two Trees Handbook - Selection.docx	21.8 KB
06_02_Definitions.docx	20.7 KB
06_05_Definitions.docx	17.9 KB
06_04_Definitions - Manual.docx	17.4 KB
Definitions.docx	17.1 KB
06_04_Definitions - draft.docx	17.0 KB
06_09 Handbook Insert.docx	14.1 KB
06_09 Multi-Level List.docx	13.0 KB
/Exercise Files/Chapter 07/
07-05 Retail Store Locations.docx	21.4 KB
07-08 Retail Store Locations.docx	18.2 KB
07-07 Retail Store Locations.docx	17.9 KB
07-04 Retail Store Locations.docx	17.8 KB
07-01 Benefits Costs.docx	15.0 KB
07-03 Retail Store Locations.docx	15.0 KB
07-02 Retail Store Locations.docx	13.9 KB
/Exercise Files/Chapter 08/
08_02 Positioning Graphics.docx	909.7 KB
08_06 Two Photos.docx	557.0 KB
08_03 Wrapping Text.docx	445.7 KB
08_05 Adjusting Photos.docx	445.6 KB
08_04 Manufacturing Benefits.docx	168.2 KB
08_09 SmartArt.docx	151.3 KB
08_08 Head Count.xlsx	100.2 KB
08_11 WordArt.docx	18.9 KB
08_08 Charts.docx	16.2 KB
08_07 Picture Styles.docx	15.2 KB
08_10 Screenshots.docx	13.4 KB
/Exercise Files/Chapter 09/
09_04_TwoTreesHandbook.docx	1.3 MB
09_03_TwoTreesHandbook.docx	93.7 KB
09_02_TwoTreesHandbook.docx	67.5 KB
09_01_Faded Glory.docx	60.7 KB
09_05_Two Trees Graphic Footer.docx	27.2 KB
09_06_Quick Parts.docx	13.5 KB
/Exercise Files/Chapter 10/
10_04_TwoTreesHandbook.docx	1.3 MB
10_03_TwoTreesHandbook.docx	1.3 MB
10_02_TwoTreesHandbook.docx	1.3 MB
10_01_TwoTreesHandbook.docx	1.3 MB
/Exercise Files/Chapter 11/
11_02 Proofing Tools.docx	17.7 KB
11_03 Proofing Tools.docx	17.7 KB
11_01 Proofing Tools.docx	16.7 KB
/Exercise Files/Chapter 12/
Co-authoring.docx	54.7 KB
Original Policy with comments from legal.docx	21.2 KB
12_02_tracking.docx	18.2 KB
12_01_tracking.docx	17.6 KB
12-03 Legal Review.docx	17.0 KB
Story with all comments.docx	16.9 KB
12-03 Current Policy.docx	16.9 KB
Draft Story with Hector Edits.docx	16.2 KB
12_03_Story of Two Trees - Maria Ann edits.docx	14.3 KB
12_03_Story of Two Trees - Hector Edits.docx	14.2 KB
12_03_Story of Two Trees - Original.docx	14.1 KB
/Exercise Files/Chapter 13/
13_09 Employee Handbook Verification.docx	471.0 KB
13_07 Two Trees Handbook.docx	67.0 KB
13_01 Draft Quote.docx	21.0 KB
13_01 Draft Quote - Copy.docx	21.0 KB
13_08 Restrict Editing.docx	15.0 KB
13_06 for blog.docx	13.1 KB
/Exercise Files/Chapter 14/
14_04_Two Trees Handbook Original Text.docx	54.7 KB
14_03_Two Trees Handbook Original Text.docx	54.7 KB
14_03_Test Doc for Macros.docx	15.8 KB
/Exercise Files/Images/Logos/
two trees logo #2.jpg	33.4 KB
Thumbs.db	5.1 KB
/.../Photos needing correction/
IMG_6286.JPG	5.6 MB
IMG_6309.JPG	5.0 MB
IMG_6310.JPG	4.8 MB
IMG_6287.JPG	4.5 MB
IMG_6389.JPG	3.7 MB
Thumbs.db	7.7 KB
/Exercise Files/Images/
olive tree_IMG_6281_original size_LARGE.jpg	10.6 MB
olives on vine_IMG_6246_original image_LARGE.jpg	4.8 MB
olive tree_IMG_6281_original size_SMALL.jpg	3.6 MB
oil press.JPG	3.4 MB
olives on vine_IMG_6246_original image_SMALL.jpg	1.2 MB
olives on vine VERY SMALL.jpg	32.4 KB
Thumbs.db	29.2 KB
olives on vine TINY.jpg	24.5 KB
/Word 2010 Essential Training/
برنامج لتشغيل الفيديو.exe	15.6 MB
NFO.txt	0.9 KB
Total files 696