Lynda - Office 365 Excel Essential Training Updated 09 2015

1. 13. Data Management Features/13_02-Inserting subtotals in a sorted list.mp442.64MB
2. 05. Formatting/05_08-Creating and using tables.mp440.28MB
3. 13. Data Management Features/13_01-Sorting data.mp438.76MB
4. 15. PivotTables/15_01-Creating PivotTables.mp436.59MB
5. 15. PivotTables/15_03-Grouping by date and time.mp436.37MB
6. 16. Introduction to Macros/16_03-Running a macro.mp434.42MB
7. 16. Introduction to Macros/16_02-Creating a simple macro.mp432.7MB
8. 10. Multiple Worksheets and Workbooks/10_01-Displaying multiple worksheets and workbooks.mp431.69MB
9. 05. Formatting/05_09-Inserting shapes, arrows, and other visual features.mp429.74MB
10. 15. PivotTables/15_02-Manipulating PivotTable data.mp429.27MB
11. 07. Printing/07_01-Exploring the Page Layout tab and Page Layout view.mp428.8MB
12. 07. Printing/07_03-Working with Page Setup and printing controls.mp428.25MB
13. 05. Formatting/05_07-Using conditional formatting.mp428.14MB
14. 13. Data Management Features/13_07-Using validation tools.mp426.73MB
15. 09. Adjusting Worksheet Views/09_01-Freezing and unfreezing panes.mp426.27MB
16. 08. Printing/08_02-Exploring chart types.mp425.82MB
17. 13. Data Management Features/13_04-Splitting data into multiple columns.mp425.8MB
18. 09. Adjusting Worksheet Views/09_02-Splitting screens horizontally and vertically.mp425.42MB
19. 06. Adjusting Worksheet Layout and Data/06_01-Inserting and deleting rows and columns.mp425.24MB
20. 11. IF, VLOOKUP, and Power Functions/11_03-Getting exact table data with the VLOOKUP function.mp425.09MB
21. 05. Formatting/05_05-Exploring numeric and special formatting.mp424.89MB
22. 07. Printing/07_02-Previewing page breaks.mp424.62MB
23. 12. Security and Sharing/12_01-Unlocking cells and protecting worksheets.mp424.2MB
24. 13. Data Management Features/13_03-Using filters.mp423.89MB
25. 04. Creating Formulas and Functions/04_07-Using other common functions.mp423.14MB
26. 02. Getting Started with Excel/02_10-Using Excel Help.mp422.52MB
27. 14. Data Analysis Tools/14_03-Using Scenario Manager.mp422.28MB
28. 09. Adjusting Worksheet Views/09_03-Collapsing and expanding data views with outlining.mp421.82MB
29. 13. Data Management Features/13_05-Splitting and combining columnar data with Flash Fill.mp421.33MB
30. 05. Formatting/05_06-Formatting numbers and dates.mp421.3MB
31. 08. Printing/08_03-Formatting charts.mp420.65MB
32. 10. Multiple Worksheets and Workbooks/10_04-Using formulas to link worksheets and workbooks.mp420.55MB
33. 08. Printing/08_05-Creating incell charts with sparklines.mp419.63MB
34. 02. Getting Started with Excel/02_06-Using the Status bar.mp419.4MB
35. 16. Introduction to Macros/16_01-Exploring the need for macros.mp419.36MB
36. 15. PivotTables/15_05-Using slicers to clarify and manipulate fields.mp419.36MB
37. 06. Adjusting Worksheet Layout and Data/06_04-Finding and replacing data.mp419.08MB
38. 14. Data Analysis Tools/14_01-Using Goal Seek.mp418.91MB
39. 14. Data Analysis Tools/14_02-Using Solver.mp418.88MB
40. 02. Getting Started with Excel/02_03-Using the Quick Access Toolbar.mp418.68MB
41. 05. Formatting/05_03-Working with alignment and Wrap Text.mp418.65MB
42. 06. Adjusting Worksheet Layout and Data/06_02-Hiding and unhiding rows and columns.mp418.61MB
43. 10. Multiple Worksheets and Workbooks/10_05-Locating and maintaining links.mp418.61MB
44. 08. Printing/08_01-Creating charts.mp418.43MB
45. 04. Creating Formulas and Functions/04_04-Creating a percentagechange formula.mp418.25MB
46. 06. Adjusting Worksheet Layout and Data/06_03-Moving, copying, and inserting data.mp418.23MB
47. 11. IF, VLOOKUP, and Power Functions/11_02-Getting approximate table data with the VLOOKUP function.mp417.82MB
48. 08. Printing/08_04-Working with axes, titles, and other chart elements.mp417.54MB
49. 14. Data Analysis Tools/14_04-Using data tables.mp416.98MB
50. 04. Creating Formulas and Functions/04_01-Creating simple formulas.mp416.97MB
51. 12. Security and Sharing/12_02-Protecting workbooks.mp416.81MB
52. 05. Formatting/05_02-Adjusting row heights and column widths.mp416.37MB
53. 02. Getting Started with Excel/02_02-Using the menu system.mp415.78MB
54. 12. Security and Sharing/12_05-Tracking changes.mp415.75MB
55. 10. Multiple Worksheets and Workbooks/10_03-Moving, copying, and grouping sheets.mp415.57MB
56. 11. IF, VLOOKUP, and Power Functions/11_04-Using the COUNTIF family of functions.mp415.47MB
57. 04. Creating Formulas and Functions/04_05-Working with relative, absolute, and mixed references.mp415.27MB
58. 02. Getting Started with Excel/02_08-Using shortcut menus and the Mini toolbar.mp413.91MB
59. 11. IF, VLOOKUP, and Power Functions/11_01-Using IF functions and relational operators.mp413.41MB
60. 04. Creating Formulas and Functions/04_06-Using SUM and AVERAGE.mp413.24MB
61. 15. PivotTables/15_06-Using PivotCharts.mp413.08MB
62. 15. PivotTables/15_04-Grouping by other factors.mp412.45MB
63. 12. Security and Sharing/12_04-Sharing workbooks.mp412.34MB
64. 02. Getting Started with Excel/02_04-Understanding workbooks and worksheets.mp411.99MB
65. 10. Multiple Worksheets and Workbooks/10_02-Renaming, inserting, and deleting sheets.mp411.26MB
66. 02. Getting Started with Excel/02_07-Using navigation tools.mp410.15MB
67. 03. Entering Data/03_06-Using Save or Save As.mp410.09MB
68. 05. Formatting/05_01-Exploring font styles and effects.mp410.04MB
69. 03. Entering Data/03_03-Working with dates and times.mp49.91MB
70. 03. Entering Data/03_04-Using Undo and Redo.mp49.75MB
71. 03. Entering Data/03_02-Entering data with AutoFill.mp49.72MB
72. 04. Creating Formulas and Functions/04_03-Calculating yeartodate totals.mp49.24MB
73. 13. Data Management Features/13_06-Removing duplicate records.mp49.19MB
74. 04. Creating Formulas and Functions/04_02-Copying a formula into adjacent cells.mp49.18MB
75. 02. Getting Started with Excel/02_09-Creating new workbooks.mp48.7MB
76. 02. Getting Started with Excel/02_01-What is Excel used for.mp48.56MB
77. 05. Formatting/05_04-Designing borders.mp48.45MB
78. 03. Entering Data/03_01-Exploring data entry and editing techniques.mp48.18MB
79. 01. Introduction/01_01-Welcome.mp48.05MB
80. 12. Security and Sharing/12_03-Assigning passwords to workbooks.mp47.72MB
81. 03. Entering Data/03_05-Adding comments.mp45.64MB
82. 02. Getting Started with Excel/02_05-Using the Formula bar.mp43.87MB
83. 17. Conclusion/17_01-Goodbye.mp41.78MB
84. 01. Introduction/01_02-Using the exercise files.mp41.53MB