| | | 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 |