BACK

PC151-2010 – Intermediate Spreadsheets 1 (Excel)

Table of Contents

1. Introduction 20. Inserting Functions in Formulas
2. Filling Cells 21. Ex-Inserting Functions in Formulas
3. Ex-Filling Cells 22. Modifying Formulas & Functions
4. Editing Data Efficiently 23. Ex-Modifying Formulas & Functions
5. Ex-Editing Data Efficiently 24. Copying Formulas & Functions
6. Inserting & Deleting Cells 25. Ex-Copying Formulas & Functions
7. Ex-Inserting & Deleting Cells 26. Formula & Function Errors
8. Inserting & Deleting Rows & Columns 27. Ex-Formula & Function Errors
9. Ex-Inserting & Deleting Rows & Columns 28. Organizing Worksheets
10. Data Fitting Errors 29. Ex-Organizing Worksheets
11. Spelling Check 30. Templates
12. Ex-Spelling Check 31. Ex-Templates
13. Find & Replace 32. Time Saving Tips
14. Ex-Find & Replace 33. Ex-Time Saving Tips
15. Quiz 1 34. RS-Save Formats
16. Formulas Containing Multiple Operators 35. Ex-Save Formats
17. Ex-Formulas Containing Multiple Operators 36. Quiz 2
18. Commonly Used Functions 37. End
19. Ex-Commonly Used Functions