| | | 01_01-Welcome.mp4 | 4.97 MB |
| | | 01_02-Using the exercise files.mp4 | 1004.81 KB |
| | | 02_01-What you can do with Excel 2016.mp4 | 6.42 MB |
| | | 02_02-Exploring the Excel 2016 program window.mp4 | 11.72 MB |
| | | 02_03-Introducing the Ribbon for the Mac.mp4 | 9.7 MB |
| | | 02_04-Setting program preferences.mp4 | 10.19 MB |
| | | 02_05-Getting help in Excel.mp4 | 7.95 MB |
| | | 03_01-Opening, creating, and saving workbooks.mp4 | 8.33 MB |
| | | 03_02-Setting workbook properties.mp4 | 6.16 MB |
| | | 03_03-Creating and modifying workbook templates.mp4 | 8.55 MB |
| | | 03_04-Managing workbooks across multiple versions of Excel.mp4 | 6.83 MB |
| | | 04_01-Selecting cells and groups of cells.mp4 | 9.84 MB |
| | | 04_02-Copying and pasting cell data.mp4 | 9.95 MB |
| | | 04_03-Entering data using AutoFill and other techniques.mp4 | 8.78 MB |
| | | 04_04-Inserting symbols and special characters.mp4 | 12.12 MB |
| | | 04_05-Creating named ranges.mp4 | 14.71 MB |
| | | 04_06-Creating an Excel table.mp4 | 10.47 MB |
| | | 04_07-Locating and changing data using Find and Replace.mp4 | 13.79 MB |
| | | 04_08-Restricting input using validation rules.mp4 | 16.91 MB |
| | | 04_09-Using lists to limit data entered into a cell.mp4 | 6.91 MB |
| | | 05_01-Sorting worksheet data.mp4 | 7.44 MB |
| | | 05_02-Creating a custom sort order.mp4 | 11.41 MB |
| | | 05_03-Filtering worksheet data.mp4 | 8.77 MB |
| | | 05_04-Inserting, moving, and deleting cells and cell ranges.mp4 | 9.7 MB |
| | | 05_05-Splitting and freezing rows and columns.mp4 | 15.15 MB |
| | | 05_06-Managing worksheets.mp4 | 11.43 MB |
| | | 05_07-Creating, editing, and deleting headers and footers.mp4 | 8.27 MB |
| | | 06_01-Introducing Excel formulas and functions.mp4 | 6.76 MB |
| | | 06_02-Adding a formula to a cell.mp4 | 9.04 MB |
| | | 06_03-Introducing arithmetic operators.mp4 | 9.97 MB |
| | | 06_04-Using relative and absolute cell references.mp4 | 13.17 MB |
| | | 06_05-Controlling how Excel copies and pastes formulas.mp4 | 10.29 MB |
| | | 06_06-Referring to Excel table data in formulas.mp4 | 8.33 MB |
| | | 06_07-Creating an AutoSum formula.mp4 | 9.4 MB |
| | | 06_08-Summarizing data on the status bar.mp4 | 5.29 MB |
| | | 06_09-Summarizing data using an IF function.mp4 | 10.74 MB |
| | | 06_10-Summarizing data using SUMIF and other conditional functions.mp4 | 14.4 MB |
| | | 07_01-Creating formulas to count cells.mp4 | 6.02 MB |
| | | 07_02-Rounding cell values.mp4 | 9.06 MB |
| | | 07_03-Joining text in cells with concatenation.mp4 | 8.09 MB |
| | | 07_04-Finding data using VLOOKUP and HLOOKUP.mp4 | 7.77 MB |
| | | 07_05-Auditing formulas by identifying precedents and dependents.mp4 | 6.8 MB |
| | | 07_06-Managing Excel formula error indicators.mp4 | 10.12 MB |
| | | 07_07-Managing scenarios.mp4 | 15.95 MB |
| | | 07_08-Performing Goal Seek analysis.mp4 | 6.66 MB |
| | | 08_01-Applying fonts, background colors, and borders.mp4 | 11.84 MB |
| | | 08_02-Applying number and date formats to cells.mp4 | 11.94 MB |
| | | 08_03-Managing text alignment.mp4 | 10.61 MB |
| | | 08_04-Copying cell formats.mp4 | 7.91 MB |
| | | 08_05-Managing cell styles.mp4 | 10.56 MB |
| | | 08_06-Managing Office themes.mp4 | 13.6 MB |
| | | 08_07-Creating rulebased conditional formats.mp4 | 10.68 MB |
| | | 08_08-Defining top 10 conditional formats.mp4 | 10.93 MB |
| | | 08_09-Defining data bar, color scale, and icon set conditional formats.mp4 | 15.91 MB |
| | | 08_10-Editing, ordering, and deleting conditional formats.mp4 | 9.62 MB |
| | | 09_01-Creating bar and column charts.mp4 | 11.95 MB |
| | | 09_02-Creating pie charts.mp4 | 5.51 MB |
| | | 09_03-Creating line charts.mp4 | 7.43 MB |
| | | 09_04-Creating XY scatter charts.mp4 | 5.6 MB |
| | | 09_05-Creating stock charts.mp4 | 5.94 MB |
| | | 09_06-Changing chart types and layouts.mp4 | 5.8 MB |
| | | 09_07-Changing the appearance of chart elements.mp4 | 8.08 MB |
| | | 09_08-Managing chart axes and numbering.mp4 | 6.77 MB |
| | | 09_09-Adding trendlines to charts.mp4 | 7.87 MB |
| | | 09_10-Creating sparkline charts.mp4 | 9.81 MB |
| | | 10_01-Importing data from commaseparated value CSV or text files.mp4 | 8.94 MB |
| | | 10_02-Connecting to an external data source.mp4 | 3.4 MB |
| | | 10_03-Using hyperlinks.mp4 | 9.5 MB |
| | | 10_04-Including an Excel workbook in another Office document.mp4 | 8.06 MB |
| | | 10_05-Linking to an Excel chart from another Office program.mp4 | 5.74 MB |
| | | 11_01-Creating and formatting shapes.mp4 | 12.68 MB |
| | | 11_02-Adding and adjusting images.mp4 | 13.05 MB |
| | | 11_03-Manipulating text boxes.mp4 | 7.88 MB |
| | | 11_04-Cropping, compressing, and removing image backgrounds.mp4 | 11.96 MB |
| | | 11_05-Creating SmartArt graphics.mp4 | 9.52 MB |
| | | 11_06-Creating WordArt.mp4 | 6.26 MB |
| | | 11_07-Aligning and layering objects.mp4 | 11.99 MB |
| | | 12_01-Introducing PivotTable reports.mp4 | 6.66 MB |
| | | 12_02-Creating a PivotTable report.mp4 | 7.47 MB |
| | | 12_03-Pivoting a PivotTable report.mp4 | 7.3 MB |
| | | 12_04-Managing subtotals and grand totals.mp4 | 7.8 MB |
| | | 12_05-Summarizing more than one data field.mp4 | 4.6 MB |
| | | 12_06-Changing the data field summary operation.mp4 | 11.9 MB |
| | | 12_07-Changing the data field number format.mp4 | 4.66 MB |
| | | 12_08-Filtering a PivotTable report.mp4 | 14.91 MB |
| | | 12_09-Applying a PivotTable style.mp4 | 6.36 MB |
| | | 13_01-Checking spelling.mp4 | 6.47 MB |
| | | 13_02-Setting AutoCorrect and automatic Replace options.mp4 | 9.99 MB |
| | | 13_03-Managing workbook comments.mp4 | 7.43 MB |
| | | 13_04-Tracking and reviewing changes.mp4 | 9.89 MB |
| | | 13_05-Printing a worksheet or workbook.mp4 | 6.72 MB |
| | | 13_06-Setting and removing print areas.mp4 | 6.07 MB |
| | | 13_07-Exporting to other formats.mp4 | 6.64 MB |
| | | 13_08-Protecting a workbook.mp4 | 7.53 MB |
| | | 14_01-Running an existing macro.mp4 | 7.86 MB |
| | | 14_02-Recording a macro.mp4 | 6.37 MB |
| | | 14_03-Renaming, viewing, and deleting macros.mp4 | 6.1 MB |
| | | 14_04-Adding comments to a macro.mp4 | 5.62 MB |
| | | 14_05-Turning off screen updating in a macro.mp4 | 7.77 MB |
| | | 15_01-Next steps.mp4 | 3.2 MB |
| | | Ex_Files_ExcelMac2016_EssT.zip | 1.35 MB |