BACK

PC152-2010 – Intermediate Spreadsheets 2 (Excel)

Table of Contents

1. Introduction 23. Ex-Header & Footer
2. Wrapping Text in a Cell 24. Hiding Rows & Columns
3. Ex-Wrapping Text in a Cell 25. Ex-Hiding Rows & Columns
4. Changing the Orientation of Data 26. Sorting Data
5. Ex-Changing the Orientation of Data 27. Ex-Sorting Data
6. Cell Borders 28. Filtering Data
7. Ex-Cell Borders 29. Ex-Filtering Data
8. Cell Shading 30. Print Area
9. Ex-Cell Shading 31. Ex-Print Area
10. Styles 32. Print Scaling
11. Ex-Styles 33. Ex-Print Scaling
12. Inserting Clip Art 34. Printing Titles & Gridlines
13. Ex-Inserting Clip Art 35. Ex-Print Titles & Gridlines
14. Ex-Resizing Clip Art 36. Creating Charts
15. Adding Drawings 37. Ex-Creating Charts
16. Ex-Adding Drawings 38. Modifying Charts-1
17. Modifying Drawings 39. Modifying Charts-2
18. Ex-Modifying Drawings 40. Ex-Modifying Charts
19. Quiz 1 41. Interpreting Data & Charts
20. Page Breaks 42. RS-Guidelines for Creating Spreadsheets
21. Ex-Page Breaks 43. Quiz 2
22. Header & Footer 44. End