Lynda - Excel for Mac 2016 Essential Training

1. 01. Introduction/01_01-Welcome.mp44.97MB
2. 01. Introduction/01_02-Using the exercise files.mp41004.81KB
3. 02. Getting Started with Excel/02_01-What you can do with Excel 2016.mp46.42MB
4. 02. Getting Started with Excel/02_02-Exploring the Excel 2016 program window.mp411.72MB
5. 02. Getting Started with Excel/02_03-Introducing the Ribbon for the Mac.mp49.7MB
6. 02. Getting Started with Excel/02_04-Setting program preferences.mp410.19MB
7. 02. Getting Started with Excel/02_05-Getting help in Excel.mp47.95MB
8. 03. Managing Workbooks/03_01-Opening, creating, and saving workbooks.mp48.33MB
9. 03. Managing Workbooks/03_02-Setting workbook properties.mp46.16MB
10. 03. Managing Workbooks/03_03-Creating and modifying workbook templates.mp48.55MB
11. 03. Managing Workbooks/03_04-Managing workbooks across multiple versions of Excel.mp46.83MB
12. 04. Working with Worksheets, Cells, and Cell Data/04_01-Selecting cells and groups of cells.mp49.84MB
13. 04. Working with Worksheets, Cells, and Cell Data/04_02-Copying and pasting cell data.mp49.95MB
14. 04. Working with Worksheets, Cells, and Cell Data/04_03-Entering data using AutoFill and other techniques.mp48.78MB
15. 04. Working with Worksheets, Cells, and Cell Data/04_04-Inserting symbols and special characters.mp412.12MB
16. 04. Working with Worksheets, Cells, and Cell Data/04_05-Creating named ranges.mp414.71MB
17. 04. Working with Worksheets, Cells, and Cell Data/04_06-Creating an Excel table.mp410.47MB
18. 04. Working with Worksheets, Cells, and Cell Data/04_07-Locating and changing data using Find and Replace.mp413.79MB
19. 04. Working with Worksheets, Cells, and Cell Data/04_08-Restricting input using validation rules.mp416.91MB
20. 04. Working with Worksheets, Cells, and Cell Data/04_09-Using lists to limit data entered into a cell.mp46.91MB
21. 05. Sorting, Filtering, and Managing Worksheets/05_01-Sorting worksheet data.mp47.44MB
22. 05. Sorting, Filtering, and Managing Worksheets/05_02-Creating a custom sort order.mp411.41MB
23. 05. Sorting, Filtering, and Managing Worksheets/05_03-Filtering worksheet data.mp48.77MB
24. 05. Sorting, Filtering, and Managing Worksheets/05_04-Inserting, moving, and deleting cells and cell ranges.mp49.7MB
25. 05. Sorting, Filtering, and Managing Worksheets/05_05-Splitting and freezing rows and columns.mp415.15MB
26. 05. Sorting, Filtering, and Managing Worksheets/05_06-Managing worksheets.mp411.43MB
27. 05. Sorting, Filtering, and Managing Worksheets/05_07-Creating, editing, and deleting headers and footers.mp48.27MB
28. 06. Summarizing Data Using Formulas and Functions/06_01-Introducing Excel formulas and functions.mp46.76MB
29. 06. Summarizing Data Using Formulas and Functions/06_02-Adding a formula to a cell.mp49.04MB
30. 06. Summarizing Data Using Formulas and Functions/06_03-Introducing arithmetic operators.mp49.97MB
31. 06. Summarizing Data Using Formulas and Functions/06_04-Using relative and absolute cell references.mp413.17MB
32. 06. Summarizing Data Using Formulas and Functions/06_05-Controlling how Excel copies and pastes formulas.mp410.29MB
33. 06. Summarizing Data Using Formulas and Functions/06_06-Referring to Excel table data in formulas.mp48.33MB
34. 06. Summarizing Data Using Formulas and Functions/06_07-Creating an AutoSum formula.mp49.4MB
35. 06. Summarizing Data Using Formulas and Functions/06_08-Summarizing data on the status bar.mp45.29MB
36. 06. Summarizing Data Using Formulas and Functions/06_09-Summarizing data using an IF function.mp410.74MB
37. 06. Summarizing Data Using Formulas and Functions/06_10-Summarizing data using SUMIF and other conditional functions.mp414.4MB
38. 07. Analyzing Data and Formulas/07_01-Creating formulas to count cells.mp46.02MB
39. 07. Analyzing Data and Formulas/07_02-Rounding cell values.mp49.06MB
40. 07. Analyzing Data and Formulas/07_03-Joining text in cells with concatenation.mp48.09MB
41. 07. Analyzing Data and Formulas/07_04-Finding data using VLOOKUP and HLOOKUP.mp47.77MB
42. 07. Analyzing Data and Formulas/07_05-Auditing formulas by identifying precedents and dependents.mp46.8MB
43. 07. Analyzing Data and Formulas/07_06-Managing Excel formula error indicators.mp410.12MB
44. 07. Analyzing Data and Formulas/07_07-Managing scenarios.mp415.95MB
45. 07. Analyzing Data and Formulas/07_08-Performing Goal Seek analysis.mp46.66MB
46. 08. Formatting Worksheet Elements/08_01-Applying fonts, background colors, and borders.mp411.84MB
47. 08. Formatting Worksheet Elements/08_02-Applying number and date formats to cells.mp411.94MB
48. 08. Formatting Worksheet Elements/08_03-Managing text alignment.mp410.61MB
49. 08. Formatting Worksheet Elements/08_04-Copying cell formats.mp47.91MB
50. 08. Formatting Worksheet Elements/08_05-Managing cell styles.mp410.56MB
51. 08. Formatting Worksheet Elements/08_06-Managing Office themes.mp413.6MB
52. 08. Formatting Worksheet Elements/08_07-Creating rulebased conditional formats.mp410.68MB
53. 08. Formatting Worksheet Elements/08_08-Defining top 10 conditional formats.mp410.93MB
54. 08. Formatting Worksheet Elements/08_09-Defining data bar, color scale, and icon set conditional formats.mp415.91MB
55. 08. Formatting Worksheet Elements/08_10-Editing, ordering, and deleting conditional formats.mp49.62MB
56. 09. Working with Charts/09_01-Creating bar and column charts.mp411.95MB
57. 09. Working with Charts/09_02-Creating pie charts.mp45.51MB
58. 09. Working with Charts/09_03-Creating line charts.mp47.43MB
59. 09. Working with Charts/09_04-Creating XY scatter charts.mp45.6MB
60. 09. Working with Charts/09_05-Creating stock charts.mp45.94MB
61. 09. Working with Charts/09_06-Changing chart types and layouts.mp45.8MB
62. 09. Working with Charts/09_07-Changing the appearance of chart elements.mp48.08MB
63. 09. Working with Charts/09_08-Managing chart axes and numbering.mp46.77MB
64. 09. Working with Charts/09_09-Adding trendlines to charts.mp47.87MB
65. 09. Working with Charts/09_10-Creating sparkline charts.mp49.81MB
66. 10. Working with External Data/10_01-Importing data from commaseparated value CSV or text files.mp48.94MB
67. 10. Working with External Data/10_02-Connecting to an external data source.mp43.4MB
68. 10. Working with External Data/10_03-Using hyperlinks.mp49.5MB
69. 10. Working with External Data/10_04-Including an Excel workbook in another Office document.mp48.06MB
70. 10. Working with External Data/10_05-Linking to an Excel chart from another Office program.mp45.74MB
71. 11. Working with Objects/11_01-Creating and formatting shapes.mp412.68MB
72. 11. Working with Objects/11_02-Adding and adjusting images.mp413.05MB
73. 11. Working with Objects/11_03-Manipulating text boxes.mp47.88MB
74. 11. Working with Objects/11_04-Cropping, compressing, and removing image backgrounds.mp411.96MB
75. 11. Working with Objects/11_05-Creating SmartArt graphics.mp49.52MB
76. 11. Working with Objects/11_06-Creating WordArt.mp46.26MB
77. 11. Working with Objects/11_07-Aligning and layering objects.mp411.99MB
78. 12. Exploring PivotTables/12_01-Introducing PivotTable reports.mp46.66MB
79. 12. Exploring PivotTables/12_02-Creating a PivotTable report.mp47.47MB
80. 12. Exploring PivotTables/12_03-Pivoting a PivotTable report.mp47.3MB
81. 12. Exploring PivotTables/12_04-Managing subtotals and grand totals.mp47.8MB
82. 12. Exploring PivotTables/12_05-Summarizing more than one data field.mp44.6MB
83. 12. Exploring PivotTables/12_06-Changing the data field summary operation.mp411.9MB
84. 12. Exploring PivotTables/12_07-Changing the data field number format.mp44.66MB
85. 12. Exploring PivotTables/12_08-Filtering a PivotTable report.mp414.91MB
86. 12. Exploring PivotTables/12_09-Applying a PivotTable style.mp46.36MB
87. 13. Reviewing and Sharing Your Spreadsheets/13_01-Checking spelling.mp46.47MB
88. 13. Reviewing and Sharing Your Spreadsheets/13_02-Setting AutoCorrect and automatic Replace options.mp49.99MB
89. 13. Reviewing and Sharing Your Spreadsheets/13_03-Managing workbook comments.mp47.43MB
90. 13. Reviewing and Sharing Your Spreadsheets/13_04-Tracking and reviewing changes.mp49.89MB
91. 13. Reviewing and Sharing Your Spreadsheets/13_05-Printing a worksheet or workbook.mp46.72MB
92. 13. Reviewing and Sharing Your Spreadsheets/13_06-Setting and removing print areas.mp46.07MB
93. 13. Reviewing and Sharing Your Spreadsheets/13_07-Exporting to other formats.mp46.64MB
94. 13. Reviewing and Sharing Your Spreadsheets/13_08-Protecting a workbook.mp47.53MB
95. 14. Automating Workbooks Using Macros/14_01-Running an existing macro.mp47.86MB
96. 14. Automating Workbooks Using Macros/14_02-Recording a macro.mp46.37MB
97. 14. Automating Workbooks Using Macros/14_03-Renaming, viewing, and deleting macros.mp46.1MB
98. 14. Automating Workbooks Using Macros/14_04-Adding comments to a macro.mp45.62MB
99. 14. Automating Workbooks Using Macros/14_05-Turning off screen updating in a macro.mp47.77MB
100. 15. Conclusion/15_01-Next steps.mp43.2MB