Lynda - Office 365: Excel Essential Training

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