Excel 2010 Introduction: Part II
Publisher: Bookboon.com
Published: 2013
ISBN-13: 9788776818050
Table of contents: title: Content; title: 1. SECTION 8. EXCEL 2010 NAMES; title: 1.1. NAMING CELLS AND RANGES; title: 1.2. Rules When Naming Cells; title: 1.3. NAME BOX; title: 1.4. Method 1 (Define); title: 1.5. Method 2 (Direct); title: 1.6. Method 3 (By Selection); title: 1.7. Selecting Names (Navigation); title: 1.8. Manage Names By Using The Name Manager.; title: 1.9. Names In Functions; title: 1.10. Paste List Of Names; title: 1.11. Intersecting Names; title: 1.12. Applying Names; title: 1.13. Filtering Out Needed Named Ranges; title: 2. SECTION 9.	EXCEL 2010 SHEETS; title: 2.1. MULTIPLE WORKSHEETS; title: 2.2. Moving Between The Workbook Sheets; title: 2.3. Worksheet Names; title: 2.4. Move And Copy Worksheets; title: 2.5. Insert And Delete Worksheets; title: 2.6. ACTIVATE GROUP MODE; title: 2.7. Group Adjacent Sheets; title: 2.8. Group Non-Adjacent Sheets; title: 2.9. Deactivate Group Mode; title: 2.10. FILL DATA ACROSS WORKSHEETS; title: 2.11. 3-D Formulae; title: 2.12. References To Other Sheets; title: 2.13. PROTECT WORKSHEET DATA; title: 2.14. Unlock Cells; title: 2.15. Worksheet Protection; title: 2.16. Unprotect Sheets; title: 2.17. View Worksheets Side By Side; title: 2.18. Hide Windows	106; title: 2.19. Watch Window; title: 2.20. Change Colour Of Worksheet Tab; title: 3. SECTION 10. EXCEL 2010 PRINTING; title: 3.1. PRINTING OPTIONS; title: 3.2. Print Preview; title: 3.3. PAGE SETUP; title: 3.4. Page Setup Group On The Page Layout Ribbon; title: 3.5. PAGE TAB; title: 3.6. Print Preview Options; title: 3.7. MARGINS TAB; title: 3.8.To Change Header And Footer Position:; title: 3.9. HEADER/FOOTER TAB; title: 3.10. Header; title: 3.11. Footer; title: 3.12. New Methods For Headers And Footers In 2010; title: 3.13. Insert Specific Elements In A Header Or Footer; title: 3.14. Add A Predefined Header Or Footer; title: 3.15. Choose The Header And Footer Options; title: 3.16. Custom Header Or Footer For A Chart; title: 3.17. SHEET TAB; title: 3.18. Print Area; title: 3.19. Print Titles; title: 3.20. Print; title: 3.21. To Change Sheet Tab Print Settings:; title: 3.22. Page Breaks; title: 3.23. PRINT DATA; title: 3.24. Copies; title: 4. SECTION 11. UTILISING LARGE WORKSHEETS; title: 4.1. USEFUL TOOLS FOR LARGE SHEETS; title: 4.2. Split Screen; title: 4.3. Freeze Panes; title: 4.4. Zoom; title: 4.5. NAVIGATION; title: 4.6. Go To; title: 4.7. Navigating With Name Box; title: 5. SECTION 12. CUSTOMISING EXCEL; title: 5.1. SET EXCEL OPTIONS; title: 5.2. General; title: 5.3. Formulas Sheet; title: 5.4. Proofing; title: 5.5. Save; title: 5.6. Language; title: 5.7. Advanced Options; title: 5.8. Customise Excel Ribbons; title: 5.9. Customise Quick Access Toolbar