WSCUY COM Microsoft Excel - From Beginner to Expert in 6 Hours

1. 22. Farewell/1. Until We Meet Again!.mp41.15MB
2. 1. Course Information/3. The Quizzes Are Optional.mp42.32MB
3. 1. Course Information/1. Screen Settings.mp42.5MB
4. 6. Harvesting Data From The Web/5. Transposing Data.mp44.19MB
5. 10. Formatting For Impact/9. Inserting & Deleting Cells, Columns, & Rows.mp44.34MB
6. 6. Harvesting Data From The Web/11. Web Scraping Software.mp44.5MB
7. 4. Working With Functions/11. Conditional Formatting.mp44.51MB
8. 4. Working With Functions/7. VLOOKUP Function & Gradebooks.mp45.16MB
9. 9. Going Pro With Pivot Tables/11. Using Slicers in Pivot Tables.mp45.55MB
10. 7. Manipulating Data/7. Sorting Data.mp45.62MB
11. 21. Just For Fun!/1. Bloopers.mp45.7MB
12. 16. Hands-On Creating A Gradebook/4. Gradebook Adjustments.mp46.31MB
13. 10. Formatting For Impact/1. Formatting Your Worksheet.mp46.49MB
14. 4. Working With Functions/9. IF, Concatenate, & Evaluation.mp46.57MB
15. 7. Manipulating Data/3. Filtering Data.mp46.99MB
16. 8. Advanced Filtering/3. Exploring Filters Further.mp47.05MB
17. 4. Working With Functions/13. IFERROR Function & Dynamic Amortization Tables.mp47.07MB
18. 7. Manipulating Data/1. Freeze Panes.mp47.1MB
19. 16. Hands-On Creating A Gradebook/2. Initial Considerations.mp47.27MB
20. 9. Going Pro With Pivot Tables/13. Creating Pivot Charts.mp47.41MB
21. 6. Harvesting Data From The Web/1. Finding Data.mp48.22MB
22. 15. Enhancing Your Value with Bonus Skills/3. Google Form Examples.mp48.42MB
23. 16. Hands-On Creating A Gradebook/10. Freeze Panes and Sorting.mp48.76MB
24. 16. Hands-On Creating A Gradebook/9. Looking Up The Letter Grade.mp48.88MB
25. 5. Creating Charts & Graphs/11. Pivot Charts.mp49.2MB
26. 16. Hands-On Creating A Gradebook/1. Creating A Gradebook.mp49.38MB
27. 9. Going Pro With Pivot Tables/7. Recommended Pivot Tables.mp49.4MB
28. 5. Creating Charts & Graphs/1. Visually Representing Data.mp49.8MB
29. 14. Printing & Sharing Your Work/3. Printing & Sharing.mp49.81MB
30. 10. Formatting For Impact/13. Formatting Examples.mp410.08MB
31. 9. Going Pro With Pivot Tables/9. Grouping in Pivot Tables.mp410.15MB
32. 1. Course Information/5. Getting Your Certificate of Completion.mp410.29MB
33. 4. Working With Functions/5. Future Value Function & Pensions.mp410.41MB
34. 2. Quick Start/2. Relative References.mp410.42MB
35. 9. Going Pro With Pivot Tables/1. Introduction to Pivot Tables.mp410.74MB
36. 3. Getting Started/5. Formula Essentials.mp410.81MB
37. 10. Formatting For Impact/3. Formatting Essentials.mp410.83MB
38. 6. Harvesting Data From The Web/7. Copying Data From The Web II.mp411.36MB
39. 7. Manipulating Data/5. Removing Duplicates.mp411.49MB
40. 2. Quick Start/1. Excel Quick Start.mp411.79MB
41. 4. Working With Functions/3. Payment Function & Loans.mp411.89MB
42. 10. Formatting For Impact/7. Design Considerations.mp412.09MB
43. 3. Getting Started/7. Relative, Absolute, & Mixed References.mp412.47MB
44. 2. Quick Start/3. Absolute References.mp412.52MB
45. 16. Hands-On Creating A Gradebook/7. Automated Error Checking.mp412.6MB
46. 10. Formatting For Impact/5. Formatting Fundamentals.mp412.82MB
47. 9. Going Pro With Pivot Tables/5. Exploring Pivot Tables.mp413.13MB
48. 5. Creating Charts & Graphs/5. Formatting Charts.mp413.68MB
49. 2. Quick Start/4. Functions.mp413.76MB
50. 16. Hands-On Creating A Gradebook/5. Entering and Adjusting Data.mp414.84MB
51. 11. Saving Time With Macros/3. Macro Automation.mp414.96MB
52. 3. Getting Started/3. Writing Formulas.mp415.06MB
53. 12. Integrating Word & Excel/1. Object Linking & Embedding.mp415.16MB
54. 10. Formatting For Impact/11. Formatting Options.mp415.35MB
55. 15. Enhancing Your Value with Bonus Skills/1. Awesome Stuff With Google.mp415.61MB
56. 13. Securing Your Work/3. Securing Your Workbooks.mp415.7MB
57. 18. Hands-On Creating A Loan Amortization/1. Creating A Loan Amortization Schedule.mp415.94MB
58. 16. Hands-On Creating A Gradebook/6. Entering Formulas and Functions.mp416.13MB
59. 2. Quick Start/7. Gathering Data With Google Forms.mp416.41MB
60. 2. Quick Start/5. Creating Charts.mp416.49MB
61. 4. Working With Functions/1. Introduction to Functions.mp417.45MB
62. 9. Going Pro With Pivot Tables/3. Creating a Pivot Table.mp417.46MB
63. 11. Saving Time With Macros/1. Understanding Macros.mp417.98MB
64. 3. Getting Started/1. Introduction To Excel.mp418.36MB
65. 7. Manipulating Data/9. Subtotaling Data.mp418.54MB
66. 16. Hands-On Creating A Gradebook/3. Tracking Attendance.mp418.72MB
67. 5. Creating Charts & Graphs/3. Creating Charts.mp419MB
68. 16. Hands-On Creating A Gradebook/8. Calculating All Grades.mp419.01MB
69. 7. Manipulating Data/11. Data Tables.mp419.78MB
70. 5. Creating Charts & Graphs/7. Scatter Charts.mp419.9MB
71. 10. Formatting For Impact/15. Formatting Secrets.mp420.48MB
72. 5. Creating Charts & Graphs/9. Combo Charts.mp420.75MB
73. 13. Securing Your Work/1. Securing Your Worksheets.mp422.31MB
74. 14. Printing & Sharing Your Work/1. Preparing To Print.mp423.52MB
75. 8. Advanced Filtering/7. The Find Function II.mp423.91MB
76. 8. Advanced Filtering/5. The Advanced Filter.mp426.52MB
77. 6. Harvesting Data From The Web/9. Parsing Data.mp428.09MB
78. 6. Harvesting Data From The Web/3. Copying Data From The Web.mp429.08MB
79. 17. Hands-On Bringing Grades From Blackboard Into Excel/1. Importing Data From Blackboard.mp429.48MB
80. 8. Advanced Filtering/1. Exploring The Find Function.mp431.5MB
81. 2. Quick Start/6. Calculating A Grade Example.mp440.66MB