Lynda - Office 2016 for Mac Essential Training: Excel

1. 019 Restricting input using validation rules.mp416.91MB
2. 044 Managing scenarios.mp415.95MB
3. 054 Defining data bar, color scale, and icon set conditional formats.mp415.91MB
4. 025 Splitting and freezing rows and columns.mp415.15MB
5. 085 Filtering a PivotTable report.mp414.91MB
6. 016 Creating named ranges.mp414.71MB
7. 037 Summarizing data using SUMIF and other conditional functions.mp414.4MB
8. 018 Locating and changing data using Find and Replace.mp413.79MB
9. 051 Managing Office themes.mp413.6MB
10. 031 Using relative and absolute cell references.mp413.17MB
11. 072 Adding and adjusting images.mp413.05MB
12. 071 Creating and formatting shapes.mp412.68MB
13. 015 Inserting symbols and special characters.mp412.12MB
14. 077 Aligning and layering objects.mp411.99MB
15. 074 Cropping, compressing, and removing image backgrounds.mp411.96MB
16. 056 Creating bar and column charts.mp411.95MB
17. 047 Applying number and date formats to cells.mp411.94MB
18. 083 Changing the data field summary operation.mp411.9MB
19. 046 Applying fonts, background colors, and borders.mp411.84MB
20. 004 Exploring the Excel 2016 program window.mp411.72MB
21. 026 Managing worksheets.mp411.43MB
22. 022 Creating a custom sort order.mp411.41MB
23. 053 Defining top 10 conditional formats.mp410.93MB
24. 036 Summarizing data using an IF function.mp410.74MB
25. 052 Creating rule-based conditional formats.mp410.68MB
26. 048 Managing text alignment.mp410.61MB
27. 050 Managing cell styles.mp410.56MB
28. 017 Creating an Excel table.mp410.47MB
29. 032 Controlling how Excel copies and pastes formulas.mp410.29MB
30. 006 Setting program preferences.mp410.19MB
31. 043 Managing Excel formula error indicators.mp410.12MB
32. 088 Setting AutoCorrect and automatic Replace options.mp49.99MB
33. 030 Introducing arithmetic operators.mp49.97MB
34. 013 Copying and pasting cell data.mp49.95MB
35. 090 Tracking and reviewing changes.mp49.89MB
36. 012 Selecting cells and groups of cells.mp49.84MB
37. 065 Creating sparkline charts.mp49.81MB
38. 024 Inserting, moving, and deleting cells and cell ranges.mp49.7MB
39. 005 Introducing the Ribbon for the Mac.mp49.7MB
40. 055 Editing, ordering, and deleting conditional formats.mp49.62MB
41. 075 Creating SmartArt graphics.mp49.52MB
42. 068 Using hyperlinks.mp49.5MB
43. 034 Creating an AutoSum formula.mp49.4MB
44. 039 Rounding cell values.mp49.06MB
45. 029 Adding a formula to a cell.mp49.04MB
46. 066 Importing data from comma-separated value (CSV) or text files.mp48.94MB
47. 014 Entering data using AutoFill and other techniques.mp48.78MB
48. 023 Filtering worksheet data.mp48.77MB
49. 010 Creating and modifying workbook templates.mp48.55MB
50. 033 Referring to Excel table data in formulas.mp48.33MB
51. 008 Opening, creating, and saving workbooks.mp48.33MB
52. 027 Creating, editing, and deleting headers and footers.mp48.27MB
53. 040 Joining text in cells with concatenation.mp48.09MB
54. 062 Changing the appearance of chart elements.mp48.08MB
55. 069 Including an Excel workbook in another Office document.mp48.06MB
56. 007 Getting help in Excel.mp47.95MB
57. 049 Copying cell formats.mp47.91MB
58. 073 Manipulating text boxes.mp47.88MB
59. 064 Adding trendlines to charts.mp47.87MB
60. 095 Running an existing macro.mp47.86MB
61. 081 Managing subtotals and grand totals.mp47.8MB
62. 041 Finding data using VLOOKUP and HLOOKUP.mp47.77MB
63. 099 Turning off screen updating in a macro.mp47.77MB
64. 094 Protecting a workbook.mp47.53MB
65. 079 Creating a PivotTable report.mp47.47MB
66. 021 Sorting worksheet data.mp47.44MB
67. 089 Managing workbook comments.mp47.43MB
68. 058 Creating line charts.mp47.43MB
69. 080 Pivoting a PivotTable report.mp47.3MB
70. 020 Using lists to limit data entered into a cell.mp46.91MB
71. 011 Managing workbooks across multiple versions of Excel.mp46.83MB
72. 042 Auditing formulas by identifying precedents and dependents.mp46.8MB
73. 063 Managing chart axes and numbering.mp46.77MB
74. 028 Introducing Excel formulas and functions.mp46.76MB
75. 091 Printing a worksheet or workbook.mp46.72MB
76. 078 Introducing PivotTable reports.mp46.66MB
77. 045 Performing Goal Seek analysis.mp46.66MB
78. 093 Exporting to other formats.mp46.64MB
79. 087 Checking spelling.mp46.47MB
80. 003 What you can do with Excel 2016.mp46.42MB
81. 096 Recording a macro.mp46.37MB
82. 086 Applying a PivotTable style.mp46.36MB
83. 076 Creating WordArt.mp46.26MB
84. 009 Setting workbook properties.mp46.17MB
85. 097 Renaming, viewing, and deleting macros.mp46.1MB
86. 092 Setting and removing print areas.mp46.07MB
87. 038 Creating formulas to count cells.mp46.02MB
88. 060 Creating stock charts.mp45.94MB
89. 061 Changing chart types and layouts.mp45.8MB
90. 070 Linking to an Excel chart from another Office program.mp45.74MB
91. 098 Adding comments to a macro.mp45.62MB
92. 059 Creating XY (scatter) charts.mp45.6MB
93. 057 Creating pie charts.mp45.51MB
94. 035 Summarizing data on the status bar.mp45.29MB
95. 001 Welcome.mp44.97MB
96. 084 Changing the data field number format.mp44.66MB
97. 082 Summarizing more than one data field.mp44.6MB
98. 067 Connecting to an external data source.mp43.4MB
99. 100 Next steps.mp43.2MB
100. 002 Using the exercise files.mp41004.85KB