Microsoft Excel 2007

  1. What is a Spreadsheet Program?
  2. Getting Started with Microsoft Excel
  3. Windows and Views
  4. Basic Spreadsheet Skills
  5. Using the Help System
  6. Opening, Saving and Closing Workbooks
  7. Creating New Workbooks
  8. Selecting Cells
  9. Cell Referencing
  10. AutoSum and AutoFill
  11. Formatting Numbers
  12. Formatting Cells
  13. Cell Alignment
  14. Cells, Rows and Columns
  15. Working with Worksheets
  16. Edit, Undo, Cut, Copy and Paste
  17. Proofing and Previewing Workbooks
  18. Page Layout
  19. Printing Workbooks
  20. E-mailing Worksheets
  21. Chart Basics and Inserting Charts
  22. Chart Design
  23. Chart Layout
  24. Chart Format and Themes
  25. Find and Replace
  26. Sort and Filter
  27. Defined Names
  28. Introduction to Functions
  29. Date Functions
  30. Logical Functions
  31. Information Functions
  32. Financial Functions
  33. Adding Comments
  34. Headers and Footers
  35. Illustrations, Text Boxes and WordArt
  36. Text to Columns
  37. Remove Duplicates
  38. Data Validation
  39. Consolidate Data
  40. What-if Analysis - Data Tables
  41. What-if Analysis - Scenarios
  42. What-if Analysis - Goal Seek
  43. Subtotals and Grouping
  44. Text Functions
  45. Lookup Functions
  46. Maths and Trig Functions
  47. Database Functions
  48. Auditing and Error Tracing
  49. Excel Tables
  50. Linking Data
  51. Getting External Data
  52. Pivot Tables and Pivot Charts
  53. Protecting and Sharing Worksheets and Workbooks
  54. Workbook Properties and Inspection
  55. Encrypting and Finalising Workbooks
  56. Digital Signatures
  57. An Introduction to Macros
  58. Custom Number Formats
  59. Statistical Functions
  60. More About Charts
  61. Custom Lists
  62. Working with Templates
  63. Paste Special
  64. Hyperlinks
  65. Sharing Workbooks
  66. Tracking Changes
  67. Compare and Merge Workbooks