| | 0001 Welcome.mov | 7.26 MB |
| | 0002 Using the exercise files.mov | 756.53 KB |
| | 0102 Touring the interface.mov | 7.18 MB |
| | 0105 Maintaining file compatibility.mov | 7.16 MB |
| | 0103 Finding the commands you need.mov | 5 MB |
| | 0104 Using Backstage view or the File tab.mov | 3.92 MB |
| | 0101 Exploring three common uses for Excel.mov | 3.27 MB |
| | 0204 Targeting large data groups.mov | 6.07 MB |
| | 0203 Entering data automatically with Auto Fill.mov | 5.76 MB |
| | 0201 Creating a worksheet.mov | 5.38 MB |
| | 0202 Techniques for copying and pasting.mov | 4.3 MB |
| | 0205 Changing a worksheet's structure.mov | 3.68 MB |
| | 0304 Adding numbers using Sum and AutoSum.mov | 6.72 MB |
| | 0307 Preventing errors using absolute references.mov | 6.07 MB |
| | 0310 Using SUMIF and AVERAGEIF.mov | 5.55 MB |
| | 0306 Working with numbers in columns.mov | 5.11 MB |
| | 0303 Adding numbers manually.mov | 4.86 MB |
| | 0309 Using IF.mov | 4.83 MB |
| | 0301 Understanding formulas and functions.mov | 4.63 MB |
| | 0311 Naming and using cell ranges.mov | 4.11 MB |
| | 0308 Working with times and dates.mov | 3.38 MB |
| | 0302 Entering data in a worksheet.mov | 3.33 MB |
| | 0305 Adding a whole worksheet.mov | 1.86 MB |
| | 0406 Adding pictures and shapes.mov | 9.81 MB |
| | 0401 Formatting numbers and dates.mov | 7.81 MB |
| | 0405 Using custom conditional formatting.mov | 7.72 MB |
| | 0403 Adjusting columns, rows, and text.mov | 5.59 MB |
| | 0404 Using conditional formatting.mov | 5.5 MB |
| | 0402 Applying fonts, background colors, and borders.mov | 5.38 MB |
| | 0501 Inserting SmartArt.mov | 8.56 MB |
| | 0504 Creating and sharing styles.mov | 7.31 MB |
| | 0502 Coordinating a look using themes.mov | 4.82 MB |
| | 0503 Applying built-in styles.mov | 4.68 MB |
| | 0505 Using templates.mov | 4.56 MB |
| | 0506 Creating and using original templates.mov | 3.06 MB |
| | 0601 Making the pieces fit.mov | 6.11 MB |
| | 0603 Printing and PDFs.mov | 5.13 MB |
| | 0602 Inserting headers and footers.mov | 4.43 MB |
| | 0704 Creating multiple custom worksheet views.mov | 8.78 MB |
| | 0706 Managing worksheets.mov | 7.79 MB |
| | 0705 Hiding or grouping rows and columns.mov | 7.51 MB |
| | 0707 Calculating formulas across worksheets.mov | 7.06 MB |
| | 0702 Freezing panes.mov | 4.86 MB |
| | 0703 Repeating row and column titles.mov | 4.34 MB |
| | 0701 Finding and replacing data.mov | 3.97 MB |
| | 0806 Saving files in shared locations.mov | 12.08 MB |
| | 0801 Importing and exporting data in Excel.mov | 10.1 MB |
| | 0803 Inserting and editing comments.mov | 8.46 MB |
| | 0802 Setting workbook permissions.mov | 7.35 MB |
| | 0805 Tracking changes.mov | 3.65 MB |
| | 0804 Sharing a workbook.mov | 1.76 MB |
| | 0903 Basic and multi-field sorting.mov | 8.32 MB |
| | 0906 Creating lookup tables.mov | 6.78 MB |
| | 0904 Using tables to sort and filter data.mov | 6.67 MB |
| | 0902 Joining data from multiple cells.mov | 5.18 MB |
| | 0905 Inserting automatic subtotals.mov | 4.69 MB |
| | 0901 Splitting cell data into multiple cells.mov | 3 MB |
| | 1006 Exploring the Analysis Toolpak.mov | 8.96 MB |
| | 1001 Using auditing to diagram.mov | 7.07 MB |
| | 1004 Using data tables in formulas.mov | 6.51 MB |
| | 1005 Using scenarios in formulas.mov | 5.94 MB |
| | 1003 Working with Goal Seek.mov | 5.8 MB |
| | 1002 Using evaluation in Excel.mov | 2.24 MB |
| | 1103 Modifying a PivotTable.mov | 7.64 MB |
| | 1104 Creating and modifying a PivotChart.mov | 7.14 MB |
| | 1102 Creating a basic PivotTable.mov | 3.03 MB |
| | 1101 Discovering PivotTables.mov | 2.28 MB |
| | 1205 Creating and modifying a pie chart.mov | 8.13 MB |
| | 1204 Modifying a column chart.mov | 6.84 MB |
| | 1206 Placing Excel charts into other Office applications.mov | 5.83 MB |
| | 1202 Inserting Sparklines.mov | 4.52 MB |
| | 1203 Creating a column chart.mov | 3.66 MB |
| | 1201 Choosing chart types.mov | 1.73 MB |
| | 1302 Recording and using a simple macro.mov | 14.08 MB |
| | 1303 Editing a macro.mov | 7.21 MB |
| | 1301 Understanding macros.mov | 2.8 MB |
| | 1402 Customizing the Ribbon bar.mov | 13.18 MB |
| | 1403 Setting Excel options.mov | 9.69 MB |
| | 1401 Customizing the Quick Access toolbar.mov | 4.31 MB |
| | 1501 Goodbye.mov | 244.38 KB |
| | Comments.xlsx | 201.43 KB |
| | permissions.xlsx | 144 KB |
| | SHARING.xlsx | 138.76 KB |
| | protecting.xlsx | 138.75 KB |
| | import into this.xlsx | 136.31 KB |
| | export this.xlsx | 135.95 KB |
| | kalamata.jpg | 62.34 KB |
| | multi-pack 1.jpg | 31.38 KB |
| | saving shared locations.xlsx | 11.88 KB |
| | import data.txt | 2.11 KB |
| | import data.csv | 2.11 KB |
| | logo.jpg | 160.84 KB |
| | custom styles.xlsx | 137.97 KB |
| | styles.xlsx | 137.69 KB |
| | merge styles.xlsx | 137 KB |
| | smart art.xlsx | 135.87 KB |
| | turn into template.xlsx | 135.62 KB |
| | GARLIC.jpg | 50.95 KB |
| | Gift Pack.jpg | 31.38 KB |
| | Themes.xlsx | 25.47 KB |
| | Herbs.jpg | 19.33 KB |
| | editing macro.xlsm | 156.54 KB |
| | west data.xlsx | 135.21 KB |
| | overseas data.xlsx | 135.07 KB |
| | recording macro.xlsx | 134.74 KB |
| | northeast data.xlsx | 134.73 KB |
| | southeast data.xlsx | 134.72 KB |
| | pivot table.xlsx | 155.76 KB |
| | pivot chart.xlsx | 147.5 KB |
| | modifying a pivottable.xlsx | 140.87 KB |
| | create pivot table.xlsx | 136.04 KB |
| | freezing panes.xlsx | 153.39 KB |
| | 3D formulas.xlsx | 151.87 KB |
| | views.xlsx | 140.17 KB |
| | grouping.xlsx | 137.57 KB |
| | repeating rows.xlsx | 137.26 KB |
| | find and replace.xlsx | 137.24 KB |
| | managing worksheets.xlsx | 136.53 KB |
| | backstage view.xlsx | 151.49 KB |
| | ribbon bar.xlsx | 151.46 KB |
| | current format.xlsx | 146.3 KB |
| | what is excel for.xlsx | 143.51 KB |
| | touring the interface.xlsx | 136.93 KB |
| | older format workbook.xls | 34.5 KB |
| | tables.xlsx | 139.67 KB |
| | subtotals.xlsx | 139.44 KB |
| | sorting.xlsx | 139.02 KB |
| | merging.xlsx | 139.02 KB |
| | Splitting.xlsx | 138.79 KB |
| | lookups.xlsx | 135.1 KB |
| | data tables.xlsx | 138.97 KB |
| | analysis toolpack.xlsx | 138.12 KB |
| | auditing.xlsx | 138 KB |
| | goal seek.xlsx | 135.09 KB |
| | Scenarios.xlsx | 133.17 KB |
| | evaluate.xlsx | 22.08 KB |
| | setting options.xlsx | 138.28 KB |
| | customizing ribbon.xlsx | 138.28 KB |
| | customizing QAT.xlsx | 138.28 KB |
| | Bob's Customizations.exportedui | 1.06 KB |
| | SUMIF.xlsx | 137.79 KB |
| | if.xlsx | 135.75 KB |
| | creating range names.xlsx | 20.64 KB |
| | sum.xlsx | 12.62 KB |
| | whole worksheet.xlsx | 12.6 KB |
| | AVERAGE.xlsx | 12.6 KB |
| | dates.xlsx | 11.43 KB |
| | Manual.xlsx | 11.25 KB |
| | absolute refs.xlsx | 11.15 KB |
| | Expense Report.xlsx | 9.39 KB |
| | formulas and functions.xlsx | 9.33 KB |
| | placing chart.xlsx | 137 KB |
| | modifying a chart.xlsx | 136.59 KB |
| | sparklines.xlsx | 136.5 KB |
| | column chart.xlsx | 134.82 KB |
| | Pie chart.xlsx | 134.82 KB |
| | insert pie chart.pptx | 75.16 KB |
| | insert pie chart.docx | 43.22 KB |
| | Rows and Columns.xlsx | 136.93 KB |
| | Selections.xlsx | 11.55 KB |
| | autofill.xlsx | 9.19 KB |
| | Clipboard.xlsx | 8.77 KB |
| | custom conditional formatting.xlsx | 136.56 KB |
| | conditional formatting.xlsx | 136.5 KB |
| | pictures - finished.xlsx | 73.98 KB |
| | bottle.jpg | 48.46 KB |
| | Pictures.xlsx | 14.51 KB |
| | adjusting.xlsx | 12.13 KB |
| | Fonts.xlsx | 11.76 KB |
| | formatting numbers.xlsx | 11.62 KB |
| | create PDFs.xlsx | 89.16 KB |
| | headers and footers.xlsx | 67.83 KB |
| | page size.xlsx | 67.65 KB |
| | logo.jpg | 24.15 KB |