| | | 01_01-Welcome.mp4 | 8.05 MB |
| | | 01_02-Using the exercise files.mp4 | 1.53 MB |
| | | 02_10-Using Excel Help.mp4 | 22.52 MB |
| | | 02_06-Using the Status bar.mp4 | 19.4 MB |
| | | 02_03-Using the Quick Access Toolbar.mp4 | 18.68 MB |
| | | 02_02-Using the menu system.mp4 | 15.78 MB |
| | | 02_08-Using shortcut menus and the Mini toolbar.mp4 | 13.91 MB |
| | | 02_04-Understanding workbooks and worksheets.mp4 | 11.99 MB |
| | | 02_07-Using navigation tools.mp4 | 10.15 MB |
| | | 02_09-Creating new workbooks.mp4 | 8.7 MB |
| | | 02_01-What is Excel used for.mp4 | 8.56 MB |
| | | 02_05-Using the Formula bar.mp4 | 3.87 MB |
| | | 03_06-Using Save or Save As.mp4 | 10.09 MB |
| | | 03_03-Working with dates and times.mp4 | 9.91 MB |
| | | 03_04-Using Undo and Redo.mp4 | 9.75 MB |
| | | 03_02-Entering data with AutoFill.mp4 | 9.72 MB |
| | | 03_01-Exploring data entry and editing techniques.mp4 | 8.18 MB |
| | | 03_05-Adding comments.mp4 | 5.64 MB |
| | | 04_07-Using other common functions.mp4 | 23.14 MB |
| | | 04_04-Creating a percentagechange formula.mp4 | 18.25 MB |
| | | 04_01-Creating simple formulas.mp4 | 16.97 MB |
| | | 04_05-Working with relative, absolute, and mixed references.mp4 | 15.27 MB |
| | | 04_06-Using SUM and AVERAGE.mp4 | 13.24 MB |
| | | 04_03-Calculating yeartodate totals.mp4 | 9.24 MB |
| | | 04_02-Copying a formula into adjacent cells.mp4 | 9.18 MB |
| | | 05_08-Creating and using tables.mp4 | 40.28 MB |
| | | 05_09-Inserting shapes, arrows, and other visual features.mp4 | 29.74 MB |
| | | 05_07-Using conditional formatting.mp4 | 28.14 MB |
| | | 05_05-Exploring numeric and special formatting.mp4 | 24.89 MB |
| | | 05_06-Formatting numbers and dates.mp4 | 21.3 MB |
| | | 05_03-Working with alignment and Wrap Text.mp4 | 18.65 MB |
| | | 05_02-Adjusting row heights and column widths.mp4 | 16.37 MB |
| | | 05_01-Exploring font styles and effects.mp4 | 10.04 MB |
| | | 05_04-Designing borders.mp4 | 8.45 MB |
| | | 06_01-Inserting and deleting rows and columns.mp4 | 25.24 MB |
| | | 06_04-Finding and replacing data.mp4 | 19.08 MB |
| | | 06_02-Hiding and unhiding rows and columns.mp4 | 18.61 MB |
| | | 06_03-Moving, copying, and inserting data.mp4 | 18.23 MB |
| | | 07_01-Exploring the Page Layout tab and Page Layout view.mp4 | 28.8 MB |
| | | 07_03-Working with Page Setup and printing controls.mp4 | 28.25 MB |
| | | 07_02-Previewing page breaks.mp4 | 24.62 MB |
| | | 08_02-Exploring chart types.mp4 | 25.82 MB |
| | | 08_03-Formatting charts.mp4 | 20.65 MB |
| | | 08_05-Creating incell charts with sparklines.mp4 | 19.63 MB |
| | | 08_01-Creating charts.mp4 | 18.43 MB |
| | | 08_04-Working with axes, titles, and other chart elements.mp4 | 17.54 MB |
| | | 09_01-Freezing and unfreezing panes.mp4 | 26.27 MB |
| | | 09_02-Splitting screens horizontally and vertically.mp4 | 25.42 MB |
| | | 09_03-Collapsing and expanding data views with outlining.mp4 | 21.82 MB |
| | | 10_01-Displaying multiple worksheets and workbooks.mp4 | 31.69 MB |
| | | 10_04-Using formulas to link worksheets and workbooks.mp4 | 20.55 MB |
| | | 10_05-Locating and maintaining links.mp4 | 18.61 MB |
| | | 10_03-Moving, copying, and grouping sheets.mp4 | 15.57 MB |
| | | 10_02-Renaming, inserting, and deleting sheets.mp4 | 11.26 MB |
| | | 11_03-Getting exact table data with the VLOOKUP function.mp4 | 25.09 MB |
| | | 11_02-Getting approximate table data with the VLOOKUP function.mp4 | 17.82 MB |
| | | 11_04-Using the COUNTIF family of functions.mp4 | 15.47 MB |
| | | 11_01-Using IF functions and relational operators.mp4 | 13.41 MB |
| | | 12_01-Unlocking cells and protecting worksheets.mp4 | 24.2 MB |
| | | 12_02-Protecting workbooks.mp4 | 16.81 MB |
| | | 12_05-Tracking changes.mp4 | 15.75 MB |
| | | 12_04-Sharing workbooks.mp4 | 12.34 MB |
| | | 12_03-Assigning passwords to workbooks.mp4 | 7.72 MB |
| | | 13_02-Inserting subtotals in a sorted list.mp4 | 42.64 MB |
| | | 13_01-Sorting data.mp4 | 38.76 MB |
| | | 13_07-Using validation tools.mp4 | 26.73 MB |
| | | 13_04-Splitting data into multiple columns.mp4 | 25.8 MB |
| | | 13_03-Using filters.mp4 | 23.89 MB |
| | | 13_05-Splitting and combining columnar data with Flash Fill.mp4 | 21.33 MB |
| | | 13_06-Removing duplicate records.mp4 | 9.19 MB |
| | | 14_03-Using Scenario Manager.mp4 | 22.28 MB |
| | | 14_01-Using Goal Seek.mp4 | 18.91 MB |
| | | 14_02-Using Solver.mp4 | 18.88 MB |
| | | 14_04-Using data tables.mp4 | 16.98 MB |
| | | 15_01-Creating PivotTables.mp4 | 36.59 MB |
| | | 15_03-Grouping by date and time.mp4 | 36.37 MB |
| | | 15_02-Manipulating PivotTable data.mp4 | 29.27 MB |
| | | 15_05-Using slicers to clarify and manipulate fields.mp4 | 19.36 MB |
| | | 15_06-Using PivotCharts.mp4 | 13.08 MB |
| | | 15_04-Grouping by other factors.mp4 | 12.45 MB |
| | | 16_03-Running a macro.mp4 | 34.42 MB |
| | | 16_02-Creating a simple macro.mp4 | 32.7 MB |
| | | 16_01-Exploring the need for macros.mp4 | 19.36 MB |
| | | 17_01-Goodbye.mp4 | 1.78 MB |
| | | 12 - DatabaseFeatures.xlsx | 300.91 KB |
| | | 12 - Data Management Features.xlsx | 297.3 KB |
| | | ~$12 - Data Management Features.xlsx | 165 bytes |
| | | 01 - Examples.xlsx | 287.38 KB |
| | | 01 - Getting Started.xlsx | 69.05 KB |
| | | ~$01 - Getting Started.xlsx | 165 bytes |
| | | 09 - 04 - EmployeeTable.xlsx | 238.79 KB |
| | | 09 - 01 - EmployeeTable.xlsx | 210.3 KB |
| | | 09 - 05 - EmployeeTable.xlsx | 208.73 KB |
| | | 09 - 01 - Home Product Line.xlsx | 50.83 KB |
| | | 09 - 02 - RegionalSales.xlsx | 34.81 KB |
| | | 09 - 05 - RegionalSales.xlsx | 22.87 KB |
| | | 09 - 01 - RegionalSales.xlsx | 19.38 KB |
| | | 09 - 04 - RegionalSales.xlsx | 19.02 KB |
| | | 09 - 03 - RegionalSales.xlsx | 18.67 KB |
| | | 06 - Printing.xlsx | 189.01 KB |
| | | 08 - Worksheet Views.xlsx | 187.99 KB |
| | | ~$08 - Worksheet Views.xlsx | 165 bytes |
| | | 14 - PivotTables.xlsx | 167.38 KB |
| | | 14 - DataAnalysis.xlsx | 121.34 KB |
| | | 05 - Layout.xlsx | 167.31 KB |
| | | 10 - IF VLOOKUP COUNTIF.xlsx | 166.83 KB |
| | | 13 - PivotTables.xlsx | 166.2 KB |
| | | 14 - PivotTables.xlsx | 166.2 KB |
| | | 13 - DataAnalysis.xlsx | 101.19 KB |
| | | 11 - Security&Sharing.xlsx | 132.57 KB |
| | | 11 - TrackingChanges.xlsx | 131.48 KB |
| | | 11-TrackingChanges.xlsx | 131.48 KB |
| | | 11 - Workbook before Sharing.xlsx | 28.62 KB |
| | | 04 - Formatting.xlsx | 127.51 KB |
| | | Twenty Second Sneakers_with logo_91548475.jpg | 61.13 KB |
| | | No_Obstacles_logo_transparent.jpg | 51.69 KB |
| | | Bamboo_Slicker_with logo_YELLOW_101817957.jpg | 49.11 KB |
| | | Ex_Files_Office365_Excel_EssT.zip | 3.69 MB |