Lynda - Office 365 for Mac Essential Training: Excel

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