Excel | 1A54EC102D1640855E997F07694F9BC46B4733A8

Excel

Name	excel	DOWNLOAD Copy Link
Total Size	3.5 GB
Total Files	661
Hash	1A54EC102D1640855E997F07694F9BC46B4733A8

/Exercise Files/
Ex_Files_Ex2010_Pivot.zip	169.7 MB
/.../02 Formula and Function Tools x/
0201 Reviewing function basics.mov	30.5 MB
0204 Using mixed references.mov	11.3 MB
0202 Using and extending AutoSum.mov	10.8 MB
0203 Using absolute and relative references.mov	9.4 MB
/.../01 Formula and Function Tips and Shortcuts x/
0106 Displaying and highlighting formulas.mov	22.8 MB
0101 Using the entire row column references.mov	15.4 MB
0108 Enhancing readability with range names.mov	13.4 MB
0104 Creating 3D formulas to gather data from multiple sheets.mov	10.5 MB
0102 Copying column formulas instantly.mov	10.4 MB
0107 Simplifying debugging formulas.mov	8.8 MB
0103 Converting formulas to values with a simple drag.mov	6.3 MB
0105 Updating values without formulas.mov	5.8 MB
/.../13 Reference Functions/
1302 Returning references with INDIRECT.mov	21.2 MB
1301 Getting data from remote cells with OFFSET.mov	8.0 MB
/00 Introduction/
0001 Welcome.mov	19.4 MB
0002 Using the exercise files.mov	347.9 KB
/.../09 Array Formulas and Functions x/
0901 Extending formula capabilities with arrays.mov	18.5 MB
0902 Counting unique entries in a range with an array formula.mov	12.0 MB
0906 Combining multiple functions in arrays.mov	9.5 MB
0904 Flipping row column orientation with TRANSPOSE.mov	9.4 MB
0905 Building analysis via regression techniques with TREND and GROWTH.mov	9.0 MB
0903 Determining frequency distributions with FREQUENCY.mov	6.3 MB
/.../01.Getting Started with Access/
01_01_concepts.mov	18.3 MB
01_06_work_area.mov	15.1 MB
01_07_customize.mov	11.7 MB
01_02_starting.mov	7.8 MB
01_03_getting_started.mov	7.1 MB
01_04_quick_access.mov	7.0 MB
01_05_open.mov	5.4 MB
/.../08.Working with Reports/
08_04_reportformat.mov	18.1 MB
08_02_reportdesign.mov	13.4 MB
08_05_reportsummary.mov	12.9 MB
08_03_reportcalcs.mov	11.6 MB
08_06_reportlabels.mov	9.3 MB
08_01_reportwizard.mov	7.8 MB
08_07_reportprinting.mov	7.3 MB
/.../07.Working with Forms/
07_08_switchboard.mov	17.6 MB
07_04_formdesign.mov	16.6 MB
07_05_subforms.mov	10.4 MB
07_06_formcommands.mov	9.8 MB
07_07_sortfilter.mov	8.4 MB
07_02_formwizard.mov	7.5 MB
07_03_formscratch.mov	6.6 MB
07_01_forms.mov	2.0 MB
/.../7. Reading and Manipulating Table Data/
87007_07_08_SC11_find.mp4	16.7 MB
87007_07_03_SC11_edit.mp4	12.4 MB
87007_07_09_SC11_move.mp4	9.8 MB
87007_07_04_SC11_transact.mp4	9.8 MB
87007_07_07_SC11_delete.mp4	9.4 MB
87007_07_05_SC11_def.mp4	8.3 MB
87007_07_10_SC11_count.mp4	7.2 MB
87007_07_01_SC11_displayall.mp4	7.0 MB
87007_07_06_SC11_close.mp4	6.9 MB
87007_07_02_SC11_addnew.mp4	6.8 MB
/.../01 Getting Started x/
62643_01_02_SC11_Examples.mov	16.2 MB
62643_01_03_SC11_Security.mov	11.2 MB
62643_01_04_SC11_Recording.mov	10.3 MB
62643_01_01_SC11_Definition.mov	6.2 MB
62643_01_05_SC11_Other.mov	4.9 MB
/.../08 Math Functions x/
0801 Working with rounding functions.mov	16.2 MB
0803 Building random number generators with RAND and RANDBETWEEN.mov	11.9 MB
0805 Using the powerful new AGGREGATE function to bypass errors and hidden data.mov	11.3 MB
0802 Finding the remainder with MOD and using MOD with conditional formatting.mov	10.9 MB
0804 Converting a value between measurement systems with CONVERT.mov	8.3 MB
/.../05 Power Functions x/
0502 Tabulating information on multiple criteria with COUNTIFS, SUMIFS, and AVERAGEIFS.mov	15.7 MB
0501 Tabulating information on a single criterion with COUNTIF, SUMIF, and AVERAGEIF.mov	9.3 MB
/.../11.Working with Charts/
11_01_charts.mov	14.9 MB
11_02_pivotcharts.mov	7.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
/.../04 Lookup and Reference Function x/
0408 Using MATCH and INDEX together.mov	14.5 MB
0402 Finding approximate matches with VLOOKUP.mov	14.4 MB
0404 Nesting LOOKUP functions.mov	13.5 MB
0406 Locating data with MATCH.mov	11.0 MB
0401 Looking up information with VLOOKUP and HLOOKUP.mov	10.7 MB
0407 Retrieving information by location with INDEX.mov	10.1 MB
0403 Finding exact matches with VLOOKUP.mov	8.2 MB
0405 Finding table-like information within a function with CHOOSE.mov	6.6 MB
/.../1. Automating Processes Using Macros/
87007_01_04_SC11_run.mp4	14.5 MB
87007_01_03_SC11_data.mp4	8.8 MB
87007_01_01_SC11_overview.mp4	7.7 MB
87007_01_05_SC11_security.mp4	7.2 MB
87007_01_02_SC11_createmacro.mp4	5.4 MB
/.../8. Manipulating a Database Using the Application Object/
87007_08_04_SC11_meter.mp4	14.2 MB
87007_08_03_SC11_lookup.mp4	6.5 MB
87007_08_01_SC11_summary.mp4	6.1 MB
87007_08_02_SC11_firstlast.mp4	5.4 MB
/.../9. Controlling Forms and Reports Using the Me Object/
87007_09_02_SC11_filter.mp4	14.1 MB
87007_09_03_SC11_caption.mp4	11.8 MB
87007_09_01_SC11_edits.mp4	10.6 MB
87007_09_04_SC11_requery.mp4	10.0 MB
87007_09_05_SC11_recordsource.mp4	6.7 MB
87007_09_06_SC11_scroll.mp4	6.0 MB
87007_09_07_SC11_visible.mp4	5.8 MB
/.../4. Defining Variables, Constants, and Calculations/
87007_04_06_SC11_msg.mp4	14.0 MB
87007_04_07_SC11_array.mp4	11.6 MB
87007_04_02_SC11_dim.mp4	11.5 MB
87007_04_04_SC11_static.mp4	11.4 MB
87007_04_05_SC11_ops.mp4	10.3 MB
87007_04_03_SC11_scope.mp4	10.2 MB
87007_04_08_SC11_obj.mp4	8.3 MB
87007_04_01_SC11_types.mp4	5.3 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
/.../07 Data Functions x/
0701 Understanding Excel date time capabilities in formulas.mov	13.7 MB
0702 Identifying the day of the week with WEEKDAY.mov	12.6 MB
0705 Tabulating date time differences with DATEDIF.mov	8.9 MB
0703 Counting working days with NETWORKDAYS.mov	5.5 MB
0704 Determining a completion date with WORKDAY.mov	4.5 MB
/.../03 IF and Related Functions x/
0303 Using the AND, OR, and NOT functions with IF to create compound logical tests.mov	13.6 MB
0301 Exploring IF logical tests and using relational operators.mov	8.4 MB
0302 Creating and expanding the use of nested IF statements.mov	7.6 MB
/.../12 Charting and Visual Object Tips/
1204 Linking and unlinking pictures.mov	13.5 MB
1203 Creating and manipulating shapes.mov	6.4 MB
1201 Placing and adjusting charts.mov	3.3 MB
1202 Creating chart titles from cell content.mov	2.8 MB
/.../12 Information Functions/
1202 Using error-checking functions ISERR, ISERROR, IFERROR.mov	13.4 MB
1201 Working with the IS information functions.mov	8.6 MB
/.../03 Display Shortcuts/
0301 Split screens and frozen titles in a flash.mov	13.3 MB
0302 Repeating title creation and suppression.mov	10.3 MB
0303 Customizing your display of Status Bar totals.mov	2.8 MB
/.../6. Manipulating Database Objects Using DoCmd/
87007_06_01_SC11_openform.mp4	13.2 MB
87007_06_10_SC11_warn.mp4	11.6 MB
87007_06_02_SC11_openreport.mp4	10.9 MB
87007_06_07_SC11_beep.mp4	10.8 MB
87007_06_06_SC11_quit.mp4	9.1 MB
87007_06_03_SC11_opentable.mp4	8.0 MB
87007_06_04_SC11_openquery.mp4	7.7 MB
87007_06_05_SC11_closeobject.mp4	7.4 MB
87007_06_09_SC11_print.mp4	7.2 MB
87007_06_08_SC11_command.mp4	6.8 MB
/.../04.Creating Data Entry Rules/
04_03_rules.mov	13.0 MB
04_01_properties.mov	7.6 MB
04_02_masks.mov	7.6 MB
/.../2. Introducing Visual Basic for Applications (VBA)/
87007_02_04_SC11_modules.mp4	12.8 MB
87007_02_06_SC11_function.mp4	7.7 MB
87007_02_02_SC11_accobjmod.mp4	6.3 MB
87007_02_07_SC11_comments.mp4	6.0 MB
87007_02_03_SC11_vbe.mp4	5.8 MB
87007_02_01_SC11_introobj.mp4	4.8 MB
87007_02_05_SC11_sub.mp4	3.2 MB
87007_02_08_SC11_run.mp4	2.6 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
/.../5. Adding Logic to Your VBA Code/
87007_05_05_SC11_if.mp4	12.6 MB
87007_05_06_SC11_case.mp4	9.3 MB
87007_05_02_SC11_each.mp4	9.0 MB
87007_05_01_SC11_for.mp4	7.9 MB
87007_05_03_SC11_while.mp4	7.9 MB
87007_05_04_SC11_until.mp4	6.8 MB
/.../06 Data Entry and Editing Shortcuts/
0604 Custom lists for rapid entry.mov	12.2 MB
0601 Accelerating data entry.mov	7.8 MB
0602 Auto-Fill techniques for entering dates.mov	6.4 MB
0605 Cell editing tips.mov	3.5 MB
0603 Auto-Fill techniques for entering times.mov	3.1 MB
/00 Introduction/
0001 Welcome.mov	12.0 MB
0002 Using the exercise files.mov	858.0 KB
/.../10 Text Functions/
1006 Adjusting character content with REPLACE and SUBSTITUTE.mov	11.9 MB
1001 Locating and extracting data with FIND and MID.mov	11.5 MB
1003 Removing excess spaces with TRIM.mov	10.9 MB
1007 Reviewing additional text functions.mov	10.8 MB
1005 Adjusting case within cells with PROPER, UPPER, and LOWER.mov	9.9 MB
1004 Using CONCATENATE with functions.mov	7.6 MB
1002 Extracting specific data with LEFT and RIGHT.mov	6.1 MB
/.../09 Operational Shortcuts/
0901 Controlling rows and columns.mov	11.6 MB
0903 Handling blank cells.mov	7.8 MB
0904 Collapsing and expanding detail.mov	6.0 MB
0902 Realigning imported text.mov	2.9 MB
/.../05 Creating Non-Recordable VBA Code x/
62643_05_01_SC11_absrel.mov	11.4 MB
62643_05_03_SC11_doloop.mov	9.0 MB
62643_05_02_SC11_forloop.mov	8.9 MB
62643_05_04_SC11_interactive.mov	6.8 MB
/.../06 Statistical Functions x/
0602 Ranking data without sorting with RANK.mov	11.2 MB
0604 Tabulating blank cells with COUNTBLANK.mov	9.0 MB
0601 Finding the middle value with MEDIAN.mov	3.5 MB
0603 Finding the magnitude data with LARGE and SMALL.mov	3.4 MB
/.../04 Recording a Macro in Stages x/
62643_04_02_SC11_addcode.mov	11.2 MB
62643_04_01_SC11_simple.mov	3.7 MB
/.../06 Macro Project - Converting a Mailing List into a Database List x/
62643_06_01_SC11_scopying.mov	10.9 MB
62643_06_07_SC11_streamline.mov	10.4 MB
62643_06_04_SC11_step.mov	9.6 MB
62643_06_02_SC11_partial.mov	8.5 MB
62643_06_06_SC11_joining.mov	7.1 MB
62643_06_05_SC01_sorting.mov	7.0 MB
62643_06_03_SC11_loop.mov	5.4 MB
/.../10 Formatting Shortcuts/
1001 Formatting numbers.mov	10.8 MB
1005 Creating custom formats.mov	9.4 MB
1003 Adding background color for readability.mov	8.7 MB
1002 Aligning data.mov	5.3 MB
1007 Applying strikethroughs and borders.mov	4.5 MB
1006 Formatting periods over 24 hours.mov	3.9 MB
1004 Formatting data conditionally.mov	3.0 MB
/.../09.Working with Macros/
09_03_automateinput.mov	10.6 MB
09_04_validationmacro.mov	9.7 MB
09_02_attachmacro.mov	8.5 MB
09_01_createmacro.mov	6.5 MB
09_05_autoexec.mov	3.7 MB
/.../07 The Personal Macro Workbook x/
62643_07_01_SC11_personal.mov	10.4 MB
62643_07_02_SC11_save.mov	2.4 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
/.../02.Creating Databases and Tables/
02_07_data.mov	10.3 MB
02_08_spelling.mov	7.7 MB
02_05_fields.mov	6.9 MB
02_06_records.mov	5.8 MB
02_04_tables.mov	4.7 MB
02_02_fields.mov	4.0 MB
02_03_keys.mov	2.9 MB
02_01_planning.mov	2.8 MB
/.../08 Manipulating PivotTables Using Macros/
77968_08_02_SC11_run.mov	10.2 MB
77968_08_01_SC11_record.mov	6.9 MB
77968_08_03_SC11_present.mov	5.3 MB
/.../06.Working with Queries/
06_05_parameterquery.mov	10.2 MB
06_02_queryscratch.mov	8.7 MB
06_01_querywizard.mov	6.6 MB
06_03_querydesign.mov	5.9 MB
06_04_querycount.mov	3.3 MB
/.../3. Debugging Your VBA Code/
87007_03_01_SC11_handle.mp4	9.9 MB
87007_03_04_SC11_msg.mp4	9.0 MB
87007_03_02_SC11_step.mp4	7.1 MB
87007_03_05_SC11_watch.mp4	6.0 MB
87007_03_03_SC11_break.mp4	5.4 MB
/.../11 Database Techniques/
1102 Cleaning up spaces.mov	9.4 MB
1103 Identifying duplicates.mov	6.6 MB
1104 Splitting columns.mov	5.3 MB
1106 Forcing dates to be weekdays only.mov	4.5 MB
1101 Sorting shortcuts.mov	3.8 MB
1105 Ensuring unique entries.mov	3.1 MB
1107 Displaying unique items from large lists.mov	2.0 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
/.../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
/.../10.Sharing Data with Word and Excel/
10_01_import.mov	9.1 MB
10_02_packagesign.mov	8.4 MB
10_04_export.mov	8.2 MB
10_03_email.mov	7.0 MB
/.../03.Working with Fields and Records/
03_01_modify_table.mov	9.0 MB
03_03_sort.mov	7.7 MB
03_02_find.mov	5.5 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
/.../04 Formatting PivotTables/
77968_04_02_SC11_create.mov	8.8 MB
77968_04_01_SC11_apply.mov	8.7 MB
77968_04_03_SC11_layout.mov	5.0 MB
77968_04_04_SC11_dataformat.mov	3.0 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
/.../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
/.../03 Using VBA x/
62643_03_01_SC11_VBA.mov	8.4 MB
62643_03_02_SC11_code.mov	6.7 MB
/00 Introduction/
62643_00_01_MM01_welcome.mov	8.3 MB
62643_00_02_SC11_exerfiles.mov	334.0 KB
/.../11 Financial Functions/
1101 Calculating payments with PMT.mov	8.2 MB
1103 Determining total amount of future payments with PV.mov	8.0 MB
1102 Finding future values with FV.mov	6.6 MB
/.../04 Navigation Shortcuts/
0403 Navigating within worksheets.mov	8.2 MB
0402 Tips for navigating between workbooks.mov	6.9 MB
0401 Navigation shortcuts.mov	3.9 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
/.../10 Working with DAX Expressions/
77968_10_06_SC11_filter.mov	7.7 MB
77968_10_05_SC11_aggregate.mov	7.0 MB
77968_10_02_SC11_ops.mov	6.6 MB
77968_10_04_SC11_measure.mov	6.5 MB
77968_10_03_SC11_functions.mov	5.7 MB
77968_10_01_SC11_intro.mov	5.0 MB
/00 Introduction T/
0001 Welcome.mov	7.6 MB
0002 Using the exercise files.mov	774.7 KB
/.../02 Ribbon and Quick Access Toolbar Tips/
0203 Quick Access toolbar display tips.mov	7.6 MB
0201 Expanding and collapsing the Ribbon and Full Screen view.mov	2.9 MB
0202 Keyboard command access.mov	2.9 MB
/.../01 Getting Started T/
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
/.../03 Adding Logic to Your VBA Code x/
0304 Performing a task when conditions are met using If Then.mov	7.5 MB
0303 Repeating a task with a Do loop.mov	5.6 MB
0302 Stepping through all items of a collection using a For Each loop.mov	3.2 MB
0301 Repeating a task using a For Next loop.mov	2.6 MB
0305 Selecting which action to take using a Case statement.mov	1.8 MB
/.../05.Relational Database Techniques/
05_02_relationships.mov	7.5 MB
05_01_keys.mov	6.9 MB
05_04_subdatasheets.mov	5.8 MB
05_03_refintegrity.mov	5.0 MB
/.../06 Creating and Manipulating PivotCharts/
77968_06_06_SC11_type.mov	7.5 MB
77968_06_04_SC11_format.mov	6.3 MB
77968_06_01_SC11_create.mov	5.4 MB
77968_06_03_SC11_ptfilter.mov	5.4 MB
77968_06_02_SC11_pivot.mov	4.5 MB
77968_06_05_SC11_layout.mov	4.4 MB
77968_06_07_SC11_trend.mov	3.9 MB
77968_06_06_SC12_type.mov	99.7 KB
/.../09 Getting Started with PowerPivot/
77968_09_06_SC11_relate.mov	7.5 MB
77968_09_04_SC11_manage.mov	7.1 MB
77968_09_02_SC11_download.mov	5.6 MB
77968_09_03_SC11_import.mov	5.5 MB
77968_09_05_SC11_add.mov	4.5 MB
77968_09_01_SC11_intro.mov	3.6 MB
/.../02 Defining Variables, Constants, and Calculations x/
0206 Defining arrays.mov	7.4 MB
0201 Introducing Excel VBA data types.mov	7.0 MB
0204 Defining static variables and constants.mov	5.3 MB
0202 Declaring variables and requiring declaration before use.mov	4.4 MB
0203 Managing variable scope.mov	3.9 MB
0208 Streamlining code references using With End With statements.mov	3.8 MB
0205 Creating a calculation using mathematical operators.mov	3.7 MB
0207 Defining and using object variables.mov	2.9 MB
/.../01 Creating and Pivoting PivotTables/
77968_01_09_SC11_update.mov	7.4 MB
77968_01_02_SC11_dataprep.mov	7.1 MB
77968_01_08_SC11_consolidate.mov	7.1 MB
77968_01_01_SC11_introPivot.mov	6.9 MB
77968_01_03_SC11_create.mov	6.8 MB
77968_01_06_SC11_external.mov	6.1 MB
77968_01_10_SC11_manage.mov	5.6 MB
77968_01_04_SC01_pivot.mov	4.5 MB
77968_01_05_SC01_configure.mov	4.2 MB
77968_01_07_SC11_access.mov	3.8 MB
/.../02 Summarizing PivotTable Data/
77968_02_06_SC11_getpivotdata.mov	7.3 MB
77968_02_02_SC11_summary.mov	7.2 MB
77968_02_01_SC11_subandgrand.mov	5.5 MB
77968_02_03_SC11_more.mov	5.0 MB
77968_02_05_SC11_group.mov	4.6 MB
77968_02_04_SC11_calculated.mov	3.9 MB
77968_02_07_SC11_drill.mov	2.6 MB
/.../03 Sorting and Filtering PivotTable Data/
77968_03_08_SC11_report.mov	7.3 MB
77968_03_06_SC11_slicer.mov	6.4 MB
77968_03_07_SC11_formatslicer.mov	5.9 MB
77968_03_02_SC11_custom.mov	5.8 MB
77968_03_03_SC11_select.mov	4.7 MB
77968_03_05_SC11_search.mov	4.6 MB
77968_03_04_SC11_rule.mov	4.3 MB
77968_03_01_SC11_sort.mov	3.0 MB
77968_03_09_SC11_clear.mov	2.2 MB
/.../05 Selection Shortcuts/
0502 Selecting noncontiguous ranges and visible cells only.mov	7.1 MB
0503 Selecting the current region and moving around region corne.mov	6.9 MB
0501 Selecting an entire row column or worksheet.mov	5.6 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
/.../08 Formula Shortcuts/
0802 Selecting all cells that depend on the active cell.mov	7.0 MB
0805 Rounding shortcuts.mov	5.8 MB
0801 Rapid formula creation.mov	4.8 MB
0807 Counting unique entries.mov	4.6 MB
0806 Generating random numbers.mov	4.1 MB
0808 Performing calculations without formulas.mov	3.9 MB
0803 Selecting all cells that can affect the active cell.mov	3.6 MB
0804 AutoSum shortcuts.mov	3.4 MB
/.../01 Introducing Visual Basic for Applications x/
0105 Creating, exporting, and deleting code modules.mov	6.9 MB
0106 Creating a subroutine or function.mov	6.0 MB
0103 Working in the Visual Basic editor.mov	5.2 MB
0109 Running a VBA routine.mov	4.8 MB
0102 Examining the Excel object model.mov	3.8 MB
0108 Adding comments to the code.mov	3.7 MB
0107 Controlling procedure scope and visibility.mov	3.4 MB
0110 Adding code to a recorded macro.mov	3.3 MB
0104 Setting VBA project properties.mov	2.5 MB
0101 Introducing object-oriented programming.mov	1.7 MB
/.../07 Printing PivotTables and PivotCharts/
77968_07_01_SC11_print.mov	6.7 MB
77968_07_02_SC11_each.mov	5.5 MB
77968_07_03_SC11_printchart.mov	2.9 MB
/.../01 Top Ten Shortcuts/
0110 Zooming in and out quickly.mov	6.6 MB
0105 Instantly displaying all worksheet formulas.mov	5.2 MB
0109 Undo Redo Repeat.mov	5.1 MB
0103 Copying data or formulas down a column instantly.mov	4.0 MB
0102 Converting formulas to values with a simple drag.mov	3.6 MB
0104 Adjusting all or selected column widths or row heights in a.mov	3.4 MB
0101 Entering data or formulas in non-adjacent cells simultaneou.mov	2.8 MB
0107 Print Preview.mov	1.8 MB
0106 Two quick shortcuts for creating charts.mov	1.5 MB
0108 Instant date or time entry.mov	1.4 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
/.../02 Worksheet Basics T/
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
/.../08 Putting it All Together x/
0801 Applying techniques in a Capstone project.mov	6.4 MB
/.../05 Applying Conditional Formatting to PivotTables/
77968_05_03_SC11_databars.mov	6.2 MB
77968_05_04_SC11_colorscale.mov	6.0 MB
77968_05_02_SC11_top.mov	5.4 MB
77968_05_07_SC11_multi.mov	5.4 MB
77968_05_01_SC11_rule.mov	4.4 MB
77968_05_06_SC11_edit.mov	3.7 MB
77968_05_08_SC11_delete.mov	3.4 MB
77968_05_05_SC01_icons.mov	3.4 MB
/.../04 Debugging You VBA Code x/
0402 Stepping through a subroutine or function.mov	5.9 MB
0401 Managing errors using On Error statements.mov	4.9 MB
0404 Verifying output using the Immediate window.mov	4.0 MB
0405 Watching a value in a routine.mov	3.1 MB
0403 Setting breakpoints in the code.mov	2.7 MB
/.../05 Managing Workbook Elements and Data in VBA x/
0507 Managing worksheets with VBA.mov	5.9 MB
0502 Cutting, copying, and pasting cell data.mov	5.4 MB
0503 Finding values in cells.mov	4.4 MB
0505 Concatenating text strings.mov	4.2 MB
0508 Managing workbooks with VBA.mov	4.1 MB
0501 Writing a value to a cell.mov	3.8 MB
0504 Referring to cells using the Offset function.mov	3.1 MB
0506 Returning part of a string.mov	3.0 MB
/00 Introduction/
77968_00_01_SC03_Welcome.mov	5.7 MB
77968_00_02_SC11_exerfiles.mov	872.9 KB
/.../06 Adding Advanced Elements to Your Workbook x/
0603 Acquiring values using an input box or message box.mov	5.4 MB
0601 Turning off screen updating within a macro.mov	2.7 MB
0602 Using worksheet functions in a macro.mov	2.5 MB
0604 Calling a subroutine from another subroutine.mov	2.1 MB
/.../02 Running a Macro (Execute, Play Back, Etc.) x/
62643_02_04_SC11_Shape.mov	5.1 MB
62643_02_03_SC11_Button.mov	3.4 MB
62643_02_02_SC11_KB.mov	2.6 MB
62643_02_01_SC11_Ribbon.mov	2.5 MB
/.../07 Drag-and-Drop Techniques/
0703 Dragging and inserting variations.mov	5.0 MB
0704 Instantly displaying Paste Special options.mov	4.5 MB
0701 Copy Move acceleration tips.mov	4.4 MB
0702 Worksheet Copy Move shortcuts.mov	3.4 MB
/00 Introduction/
0001 Welcome.mov	4.9 MB
0002 Using the exercise files.mov	286.3 KB
/.../07 Using Excel Events in Your VBA Code x/
0702 Running a procedure when a cell range changes.mov	4.8 MB
0701 Running a procedure when you open, close, or save a workbook.mov	4.5 MB
0703 Triggering a procedure using a specific key sequence.mov	3.9 MB
/0. Introduction/
87007_00_01_SC03_intro.mp4	4.8 MB
87007_00_03_SC11_exerfiles.mp4	1.2 MB
87007_00_02_SC11_know.mp4	949.5 KB
/Exercises/
Exercise_Files.zip	4.2 MB
Exercise_Files.sitx	4.0 MB
/14 Conclusion/
1401 Final thoughts.mov	2.5 MB
/Conclusion/
87007_10_01_SC11_goodbye.mp4	1.6 MB
/11 Conclusion/
77968_11_01_SC11_done.mov	1.2 MB
/Exercise Files/
Ex_Files_Excel_VBA.zip	1.2 MB
/.../Exercise Files-Access 2007_2010/Chapter04/
Access VBA Chapter04.accdb	1.1 MB
._Access VBA Chapter04.accdb	4.1 KB
/.../Exercise Files-Access 2007_2010/Chapter06/
Access VBA Chapter06.accdb	1.1 MB
._Access VBA Chapter06.accdb	4.1 KB
/.../Exercise Files-Access 2007_2010/Chapter05/
Access VBA Chapter05.accdb	1.1 MB
/00.Introduction/
00_01_Intro.mov	909.1 KB
/.../Exercise Files-Access 2007_2010/Chapter01/
Access VBA Chapter01.accdb	888.8 KB
._Access VBA Chapter01.accdb	4.1 KB
/Exercise Files/
Ex_Files_Excel_10_Ad_Form.zip	840.0 KB
/.../Exercise Files-Access 2007_2010/Chapter09/
Access VBA Chapter09.accdb	692.2 KB
Confidential.png	7.8 KB
._Access VBA Chapter09.accdb	4.1 KB
._Confidential.png	4.1 KB
/.../Exercise Files-Access 2007_2010/Chapter08/
Access VBA Chapter08.accdb	679.9 KB
._Access VBA Chapter08.accdb	4.1 KB
/.../Exercise Files-Access 2003/Chapter04/
Access VBA Chapter04.mdb	647.2 KB
._Access VBA Chapter04.mdb	4.1 KB
/.../Exercise Files-Access 2007_2010/Chapter02/
Access VBA Chapter02.accdb	634.9 KB
/Exercise Files/
Chapter04.xlsx	611.4 KB
Chapter11.xlsx	289.8 KB
Chapter10.xlsx	232.9 KB
Chapter01.xlsx	161.9 KB
Chapter06.xlsx	121.0 KB
Chapter07.xlsx	119.6 KB
Chapter09.xlsx	118.6 KB
Chapter03.xlsx	117.5 KB
Chapter12.xlsx	115.5 KB
Chapter08.xlsx	109.1 KB
Chapter02.xlsx	108.5 KB
Chapter05.xlsx	107.8 KB
Chapter04A.xlsx	27.4 KB
/.../Exercise Files-Access 2007_2010/Chapter03/
Access VBA Chapter03.accdb	585.7 KB
/.../Exercise Files-Access 2003/Chapter01/
Access VBA Chapter01.mdb	573.4 KB
._Access VBA Chapter01.mdb	4.1 KB
/.../Exercise Files-Access 2003/Chapter06/
Access VBA Chapter06.mdb	524.3 KB
._Access VBA Chapter06.mdb	4.1 KB
/.../Exercise Files-Access 2007_2010/Chapter07/
Access VBA Chapter07.accdb	507.9 KB
._Access VBA Chapter07.accdb	4.1 KB
/.../Exercise Files-Access 2003/Chapter08/
Access VBA Chapter08.mdb	483.3 KB
._Access VBA Chapter08.mdb	4.1 KB
/.../Exercise Files-Access 2003/Chapter02/
Access VBA Chapter02.mdb	458.8 KB
/.../Exercise Files-Access 2003/Chapter05/
Access VBA Chapter05.mdb	450.6 KB
/.../Exercise Files-Access 2003/Chapter07/
Access VBA Chapter07.mdb	405.5 KB
._Access VBA Chapter07.mdb	4.1 KB
/.../Exercise Files-Access 2003/Chapter03/
Access VBA Chapter03.accdb	393.2 KB
Access VBA Chapter03.mdb	311.3 KB
/08 Conclusion/
62643_08_01_SC11_goodbye.mov	381.3 KB
/.../Exercise Files-Access 2003/Chapter09/
Access VBA Chapter09.mdb	335.9 KB
Confidential.png	7.8 KB
._Access VBA Chapter09.mdb	4.1 KB
._Confidential.png	4.1 KB
/Exercise Files/Exercise Files/Chapter 06/
Scoping.xlsm	269.5 KB
Final.xlsm	181.3 KB
Partial-6.xlsm	180.9 KB
Partial-5.xlsm	179.5 KB
Partial-4.xlsm	175.6 KB
Partial-2.xlsm	167.1 KB
Partial-3.xlsm	166.9 KB
Partial.xlsm	161.2 KB
/09 Conclusion/
0901 Goodbye.mov	256.9 KB
/15 Conclusion/
1501 Goodbye.mov	250.2 KB
/Exercise Files/Exercise Files/Chapter 05/
Interactive.xlsm	207.0 KB
DoLoops.xlsm	170.9 KB
MailingLists.xlsx	165.4 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/Exercise Files/Chapter 01/
Large Macro Example.xlsm	171.0 KB
Introduction_Other.xlsm	122.1 KB
IntroductionRecording.xlsm	120.3 KB
Introduction.xlsm	116.0 KB
Profits.xlsx	28.4 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 13/
editing macro.xlsm	160.3 KB
recording macro.xlsm	146.6 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 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 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 1 T/
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 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
/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 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 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 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 2 T/
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 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
/13 Conclusion/
1301 Goodbye.mov	135.0 KB
/Exercise Files/Exercise Files/Chapter 04/
AddCode.xlsm	125.2 KB
WatchCode.xlsm	122.3 KB
/Exercise Files/Exercise Files/Chapter 07/
Macros-Personal.xlsm	124.9 KB
CompanyData.xlsm	118.9 KB
/Exercise Files/Exercise Files/Chapter 02/
Playback_Button.xlsm	122.3 KB
Playback_Ribbon.xlsm	121.9 KB
Playback_KB.xlsm	121.7 KB
Phone List_after.xlsm	41.6 KB
Phone List.xlsm	33.1 KB
/Exercise Files/Exercise Files/Chapter 03/
VBA.xlsm	122.1 KB
Code.xlsm	120.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
/2 Lynda.com Excel.2010.Power.Shortcuts x/
jgtiso.nfo	7.5 KB
/.../Exercise Files-Access 2003/
._Chapter08	4.1 KB
._Chapter09	4.1 KB
._Chapter07	4.1 KB
._Chapter06	4.1 KB
._Chapter04	4.1 KB
._Chapter01	4.1 KB
/.../Exercise Files-Access 2007_2010/
._Chapter01	4.1 KB
._Chapter04	4.1 KB
._Chapter06	4.1 KB
._Chapter07	4.1 KB
._Chapter09	4.1 KB
._Chapter08	4.1 KB
Total files 661