ICT FOR ALL

CONTACT US

EXCEL 2007 tutorials sorted

Enjoy, watch, learn and experience EXCEL- you will be surprised!

  1. Excel window

  2. Cell adresses

  3. Rows and columns

  4. Inserting data

  5. Hiding rows and columns

  6. Formatting cells

  7. Number formats

  8. Dealing with number formats in cells

  9. Inserting separators in cells

  10. Conditional formatting

  11. Autofill feature

  12. Formula basics

  13. Complex formula with relative cell refernces

  14. Complex formula with absolute cell references

  15. Working with basic functions

  16. Inserting function assistant

  17. Freezing worksheet panes

  18. Printing worksheets

  19. Using the print title command

  20. Working with worksheets

  21. Sorting and filtering

  22. Displaying formulas

  23. Functions

  24. Rank function

  25. If function

  26. Vlookup function

  27. Excel charts