EXCEL 2000 LESSONS with (duration)

  1. Exploring Excel (37 minutes)
  2. Using Basic Workbook Skills (46 minutes)
  3. Working with Ranges  (21 minutes)
  4. Creating Simple Formulas (43 minutes)
  5. Copying and Moving Data (42 minutes)
  6. Printing  (15 minutes)
  7. Using Page Setup (41 minutes)
  8. Formatting Numbers (21 minutes)
  9. Formatting Text (40 minutes)
  10. Working with Columns and Rows (41 minutes)
  11. Formatting Cells (50 minutes)
  12. Using Automatic Formatting and Styles (49 minutes)
  13. Use HTML Files (25 minutes)
  14. Working With the Office Assistant  (17 minutes)
  15. Using Online Help (27 minutes)
  16. Using Large Worksheets (30 minutes)
  17. Working with Multiple Worksheets (26 minutes)
  18. Managing Worksheets (35 minutes)
  19. Working with Outlines (21 minutes)
  20. Using Paste Special (27 minutes)
  21. Using Range Names (45 minutes)
  22. Working with Labels in Formulas (37 minutes)
  23. Using Other Functions (35 minutes)
  24. Managing Data (19 minutes)
  25. Using Worksheet Protection (40 minutes)
  26. Importing and Exporting Data (44 minutes)
  27. Creating Charts (38 minutes)
  28. Editing Charts (19 minutes)
  29. Managing Files (36 minutes)
  30. Customizing Excel Preferences (22 minutes)
  31. Working with Databases (50 minutes)
  32. Working with the Data Form (24 minutes)
  33. Using AutoFilter (15 minutes)
  34. Working with Advanced Filters (37 minutes)
  35. Using Advanced Functions (1 hour 12 minutes)
  36. Creating/Revising PivotTables (1 hour 18 minutes)
  37. Using Multiple Workbooks  (42 minutes)
  38. Using Conditional and Custom Formats (37 minutes)
  39. Using Templates (25 minutes)
  40. Sharing Workbooks (50 minutes)
  41. Working with Comments (20 minutes)
  42. Working with Data Series (17 minutes)
  43. Using Scenarios and Goal Seeking (24 minutes)
  44. Using Data Tables (16 minutes)
  45. Using Auditing Tools (22 minutes)
  46. Consolidating Worksheets (23 minutes)
  47. Solving Problems (27 minutes)
  48. Working with Views (15 minutes)
  49. Using the Report Manager (19 minutes)
  50. Using Macros (26 minutes)
  51. Recording Macros (39 minutes)
  52. Editing Macros (34 minutes)
  53. Using Custom Toolbars and Buttons (27 minutes)
  54. Creating a Macro Button (22 minutes)
  55. Modifying Charts (53 minutes)
  56. Working with the Data Map (29 minutes)
  57. Drawing An Object (44 minutes)
  58. Using Additional Effects & Objects (26 minutes)
  59. Using AutoShapes (27 minutes)