Microsoft Excel 2007 - Advanced
Course Description: This course in Microsoft Excel 2007 puts the program’s more advanced features and extra functions at your fingertips. Your work will become easier when you discover all Excel can do for you. From “if statements” to cost extension and amortization tables, Excel to excellence.
Total Time: 5hrs. 5min.
| Lessons (To View Complete Course, Login & Click Below) | Time (Min:Sec) |
|---|---|
| Introduction - Preview | 14:20 |
| 1. Pivot Tables - Preview | 17:51 |
| 2. Hyperlinks - Preview | 08:22 |
| 3. Importing External Data | 07:51 |
| 4. Importing External Data from Access | 02:51 |
| 5. Importing a Text File | 09:49 |
| 6. Concatenation Screens | 14:34 |
| 7. Creating Queries | 12:17 |
| 8. Linking Worksheets and Workbooks | 27:33 |
| 9. Conditional Formatting and Comments | 17:32 |
| 10. V Lookups and Name Ranges | 21:09 |
| 11. Working with Macros | 08:47 |
| 12. Debugging Techniques | 21:05 |
| 13. VBA Code | 09:32 |
| 14. Visual Basic Commands | 21:47 |
| 15. Recording Macros | 06:42 |
| 16. Macro Codes and Commands | 15:07 |
| 17.The Case Command | 09:58 |
| 18. Debugging and Saving Your Macros | 06:51 |
| 19. Templates | 10:17 |
| 20. Working with Large Worksheets | 28:11 |
| 21. Subtotals | 12:55 |
