Lynda Excel 3Courses - Team MJY

1. Essential Training/00 Introduction/0001 Welcome.mov7.26MB
2. Essential Training/00 Introduction/0002 Using the exercise files.mov756.53KB
3. Essential Training/01 Getting Started/0101 Exploring three common uses for Excel.mov3.27MB
4. Essential Training/01 Getting Started/0102 Touring the interface.mov7.18MB
5. Essential Training/01 Getting Started/0103 Finding the commands you need.mov5MB
6. Essential Training/01 Getting Started/0104 Using Backstage view or the File tab.mov3.92MB
7. Essential Training/01 Getting Started/0105 Maintaining file compatibility.mov7.16MB
8. Essential Training/02 Worksheet Basics/0201 Creating a worksheet.mov5.38MB
9. Essential Training/02 Worksheet Basics/0202 Techniques for copying and pasting.mov4.3MB
10. Essential Training/02 Worksheet Basics/0203 Entering data automatically with Auto Fill.mov5.76MB
11. Essential Training/02 Worksheet Basics/0204 Targeting large data groups.mov6.07MB
12. Essential Training/02 Worksheet Basics/0205 Changing a worksheet's structure.mov3.68MB
13. Essential Training/03 Excel Formula Basics/0301 Understanding formulas and functions.mov4.63MB
14. Essential Training/03 Excel Formula Basics/0302 Entering data in a worksheet.mov3.33MB
15. Essential Training/03 Excel Formula Basics/0303 Adding numbers manually.mov4.86MB
16. Essential Training/03 Excel Formula Basics/0304 Adding numbers using Sum and AutoSum.mov6.72MB
17. Essential Training/03 Excel Formula Basics/0305 Adding a whole worksheet.mov1.86MB
18. Essential Training/03 Excel Formula Basics/0306 Working with numbers in columns.mov5.11MB
19. Essential Training/03 Excel Formula Basics/0307 Preventing errors using absolute references.mov6.07MB
20. Essential Training/03 Excel Formula Basics/0308 Working with times and dates.mov3.38MB
21. Essential Training/03 Excel Formula Basics/0309 Using IF.mov4.83MB
22. Essential Training/03 Excel Formula Basics/0310 Using SUMIF and AVERAGEIF.mov5.55MB
23. Essential Training/03 Excel Formula Basics/0311 Naming and using cell ranges.mov4.11MB
24. Essential Training/04 Essential Formatting/0401 Formatting numbers and dates.mov7.81MB
25. Essential Training/04 Essential Formatting/0402 Applying fonts, background colors, and borders.mov5.38MB
26. Essential Training/04 Essential Formatting/0403 Adjusting columns, rows, and text.mov5.59MB
27. Essential Training/04 Essential Formatting/0404 Using conditional formatting.mov5.5MB
28. Essential Training/04 Essential Formatting/0405 Using custom conditional formatting.mov7.72MB
29. Essential Training/04 Essential Formatting/0406 Adding pictures and shapes.mov9.81MB
30. Essential Training/05 Advanced Formatting/0501 Inserting SmartArt.mov8.56MB
31. Essential Training/05 Advanced Formatting/0502 Coordinating a look using themes.mov4.82MB
32. Essential Training/05 Advanced Formatting/0503 Applying built-in styles.mov4.68MB
33. Essential Training/05 Advanced Formatting/0504 Creating and sharing styles.mov7.31MB
34. Essential Training/05 Advanced Formatting/0505 Using templates.mov4.56MB
35. Essential Training/05 Advanced Formatting/0506 Creating and using original templates.mov3.06MB
36. Essential Training/06 Printing Preparation/0601 Making the pieces fit.mov6.11MB
37. Essential Training/06 Printing Preparation/0602 Inserting headers and footers.mov4.43MB
38. Essential Training/06 Printing Preparation/0603 Printing and PDFs.mov5.13MB
39. Essential Training/07 Large Excel Projects/0701 Finding and replacing data.mov3.97MB
40. Essential Training/07 Large Excel Projects/0702 Freezing panes.mov4.86MB
41. Essential Training/07 Large Excel Projects/0703 Repeating row and column titles.mov4.34MB
42. Essential Training/07 Large Excel Projects/0704 Creating multiple custom worksheet views.mov8.78MB
43. Essential Training/07 Large Excel Projects/0705 Hiding or grouping rows and columns.mov7.51MB
44. Essential Training/07 Large Excel Projects/0706 Managing worksheets.mov7.79MB
45. Essential Training/07 Large Excel Projects/0707 Calculating formulas across worksheets.mov7.06MB
46. Essential Training/08 Collaborating with Others/0801 Importing and exporting data in Excel.mov10.1MB
47. Essential Training/08 Collaborating with Others/0802 Setting workbook permissions.mov7.35MB
48. Essential Training/08 Collaborating with Others/0803 Inserting and editing comments.mov8.46MB
49. Essential Training/08 Collaborating with Others/0804 Sharing a workbook.mov1.76MB
50. Essential Training/08 Collaborating with Others/0805 Tracking changes.mov3.65MB
51. Essential Training/08 Collaborating with Others/0806 Saving files in shared locations.mov12.08MB
52. Essential Training/09 Exploring Excel's Database Features/0901 Splitting cell data into multiple cells.mov3MB
53. Essential Training/09 Exploring Excel's Database Features/0902 Joining data from multiple cells.mov5.18MB
54. Essential Training/09 Exploring Excel's Database Features/0903 Basic and multi-field sorting.mov8.32MB
55. Essential Training/09 Exploring Excel's Database Features/0904 Using tables to sort and filter data.mov6.67MB
56. Essential Training/09 Exploring Excel's Database Features/0905 Inserting automatic subtotals.mov4.69MB
57. Essential Training/09 Exploring Excel's Database Features/0906 Creating lookup tables.mov6.78MB
58. Essential Training/10 Analyzing Data/1001 Using auditing to diagram.mov7.07MB
59. Essential Training/10 Analyzing Data/1002 Using evaluation in Excel.mov2.24MB
60. Essential Training/10 Analyzing Data/1003 Working with Goal Seek.mov5.8MB
61. Essential Training/10 Analyzing Data/1004 Using data tables in formulas.mov6.51MB
62. Essential Training/10 Analyzing Data/1005 Using scenarios in formulas.mov5.94MB
63. Essential Training/10 Analyzing Data/1006 Exploring the Analysis Toolpak.mov8.96MB
64. Essential Training/11 Advanced Analysis with PivotTables/1101 Discovering PivotTables.mov2.28MB
65. Essential Training/11 Advanced Analysis with PivotTables/1102 Creating a basic PivotTable.mov3.03MB
66. Essential Training/11 Advanced Analysis with PivotTables/1103 Modifying a PivotTable.mov7.64MB
67. Essential Training/11 Advanced Analysis with PivotTables/1104 Creating and modifying a PivotChart.mov7.14MB
68. Essential Training/12 Creating and Using Charts/1201 Choosing chart types.mov1.73MB
69. Essential Training/12 Creating and Using Charts/1202 Inserting Sparklines.mov4.52MB
70. Essential Training/12 Creating and Using Charts/1203 Creating a column chart.mov3.66MB
71. Essential Training/12 Creating and Using Charts/1204 Modifying a column chart.mov6.84MB
72. Essential Training/12 Creating and Using Charts/1205 Creating and modifying a pie chart.mov8.13MB
73. Essential Training/12 Creating and Using Charts/1206 Placing Excel charts into other Office applications.mov5.83MB
74. Essential Training/13 Creating and Using Macros/1301 Understanding macros.mov2.8MB
75. Essential Training/13 Creating and Using Macros/1302 Recording and using a simple macro.mov14.08MB
76. Essential Training/13 Creating and Using Macros/1303 Editing a macro.mov7.21MB
77. Essential Training/14 Customizing Excel/1401 Customizing the Quick Access toolbar.mov4.31MB
78. Essential Training/14 Customizing Excel/1402 Customizing the Ribbon bar.mov13.18MB
79. Essential Training/14 Customizing Excel/1403 Setting Excel options.mov9.69MB
80. Essential Training/15 Conclusion/1501 Goodbye.mov244.38KB
81. Managing Multiple Worksheets and Workbooks/00 Introduction/0001 Welcome.mov12.33MB
82. Managing Multiple Worksheets and Workbooks/00 Introduction/0002 Using the exercise files.mov1.36MB
83. Managing Multiple Worksheets and Workbooks/01 Mastering the Utility Tasks Associated with Multiple Worksheets/0101 Learning basic navigation tips.mov18.34MB
84. Managing Multiple Worksheets and Workbooks/01 Mastering the Utility Tasks Associated with Multiple Worksheets/0102 Inserting and deleting new sheets.mov8.33MB
85. Managing Multiple Worksheets and Workbooks/01 Mastering the Utility Tasks Associated with Multiple Worksheets/0103 Copying and moving sheets within a workbook.mov7.55MB
86. Managing Multiple Worksheets and Workbooks/01 Mastering the Utility Tasks Associated with Multiple Worksheets/0104 Changing tab colors and renaming sheets.mov5.39MB
87. Managing Multiple Worksheets and Workbooks/01 Mastering the Utility Tasks Associated with Multiple Worksheets/0105 Using the Hide function on worksheet tabs.mov11.09MB
88. Managing Multiple Worksheets and Workbooks/02 Working with Multiple Worksheets/0201 Displaying multiple worksheets from the same workbook.mov17.55MB
89. Managing Multiple Worksheets and Workbooks/02 Working with Multiple Worksheets/0202 Copying, moving, and inserting data on different sheets.mov5.61MB
90. Managing Multiple Worksheets and Workbooks/02 Working with Multiple Worksheets/0203 Applying global changes to worksheets.mov7.37MB
91. Managing Multiple Worksheets and Workbooks/03 Linking Worksheets with Formulas/0301 Creating linkage formulas.mov6.84MB
92. Managing Multiple Worksheets and Workbooks/03 Linking Worksheets with Formulas/0302 Creating 3D formulas for worksheets with identical layouts.mov10.32MB
93. Managing Multiple Worksheets and Workbooks/03 Linking Worksheets with Formulas/0303 Summarizing multiple worksheets with PivotTables or Consolidate.mov19.51MB
94. Managing Multiple Worksheets and Workbooks/04 Working with Multiple Workbooks/0401 Navigating between open workbooks.mov7MB
95. Managing Multiple Worksheets and Workbooks/04 Working with Multiple Workbooks/0402 Displaying multiple worksheets from different workbooks.mov9.97MB
96. Managing Multiple Worksheets and Workbooks/04 Working with Multiple Workbooks/0403 Copying and moving data and entire worksheets across different workbooks.mov11.98MB
97. Managing Multiple Worksheets and Workbooks/05 Linking Formulas Across Multiple Workbooks/0501 Creating formulas that link worksheets in different workbooks.mov7.71MB
98. Managing Multiple Worksheets and Workbooks/05 Linking Formulas Across Multiple Workbooks/0502 Locating and managing links between multiple workbooks.mov11.02MB
99. Managing Multiple Worksheets and Workbooks/05 Linking Formulas Across Multiple Workbooks/0503 Summarizing data from multiple workbooks with PivotTables or Consolidate.mov19.17MB
100. Managing Multiple Worksheets and Workbooks/06 Conclusion/0601 Final thoughts.mov2.71MB