Excel 2010 Introduction: Part I Formulas, Functions and Formatting
Publisher: Bookboon.com
Published: 2013
ISBN-13: 9788776818043
Table of contents: title: Content; title: 1. INTRODUCTION; title: 1.1. How To Use This Guide; title: 1.2. Objectives; title: 1.3. Instructions; title: 1.4. Appendices; title: 2. SECTION 1 THE BASICS; title: 2.1. WINDOWS CONCEPTS; title: 2.2. Menus; title: 2.3. Ribbons; title: 2.4. Dialog Box; title: 2.5. File Ribbon; title: 2.6. Toolbars; title: 2.7. Mini Toolbar; title: 2.8. Name Box; title: 2.9. Formula Bar; title: 2.10. Worksheets; title: 2.11. Status Bar; title: 2.12. Task Pane; title: 2.13. Smart Tags; title: 2.14. GETTING HELP; title: 2.15. MICROSOFT EXCEL HELP; title: 3. SECTION 2 MOVE AROUND AND ENTER DATA; title: 3.1. MOVING; title: 3.2. Moving Around Workbook; title: 3.3. Scrolling; title: 3.4. USEFUL KEYS FOR MOVING; title: 3.5. WORKBOOK SHEETS; title: 3.6. Moving Around Sheet; title: 3.7. DATA ENTRY; title: 3.8. Enter Text And Numbers; title: 3.9. Cancelling And Editing Data Entries; title: 3.10. Enter Dates; title: 3.11. Autocomplete; title: 3.12. Pick From List; title: 3.13. EDITING; title: 3.14. Typing Replaces Selection; title: 3.15. Use The Mouse To Edit; title: 3.16. Using The Keyboard; title: 3.17. Select Information; title: 3.18. Select Multiple Sheets; title: 3.19. Select Non-Adjacent Sheets; title: 3.20. Clear Contents, Formats And Comments; title: 3.21. The Fill Handle; title: 3.22. USEFUL INFORMATION; title: 3.23. Scrolling; title: 3.24. Data Entry; title: 3.25. Select Cells To Limit Data Entry; title: 3.26. Select Cells For Multiple Entry; title: 4. SECTION 3 EXCEL 2010 FORMULAS AND FUNCTIONS; title: 4.1. FORMULAE; title: 4.2. Typing Formulae; title: 4.3. Entering Formulae By Pointing; title: 4.4. Errors In Formulae; title: 4.5. Filling Formulae; title: 4.6. The Fill Handle And Formulae; title: 4.7. Fill Formulae Using Keystrokes; title: 4.8. BoDMAS With Formulae; title: 4.9. EXCEL 2010 FUNCTIONS; title: 4.10. Basic Sum Function; title: 4.11. Autosum; title: 4.12. Other Common Functions; title: 4.13. Function Library; title: 4.14. Insert Function; title: 4.15. Function Box; title: 4.16. Type Functions; title: 4.17. Function Argument Tool Tips; title: 4.18. Cell References; title: 4.19. ABSOLUTE AND RELATIVE REFERENCES; title: 4.20. Relative References; title: 4.21. Absolute References; title: 4.22. Fill Handle; title: 4.23. Absolute References; title: 5. SECTION 4 FILE OPERATIONS; title: 5.1. Save Files; title: 5.2. File Types And File Names; title: 5.3. Saving Changes To Files; title: 5.4. Saving As A Different Type Or Different Name; title: 5.5. Close Files; title: 5.6. Open Files; title: 5.7. New Files; title: 6. SECTION 5 MOVING AND COPYING DATA; title: 6.1. Moving Items; title: 6.2. Copying Items; title: 6.3. Clipboard; title: 6.4. Drag And Drop; title: 6.5. Shortcut Menus; title: 6.6. Moving And Copying Between Files; title: 6.7. Insert Paste; title: 6.8. Moving And Copying Between Worksheets; title: 6.9. Paste Special; title: 7. SECTION 6 EXCEL 2010 FORMATTING; title: 7.1. QUICK FORMATS; title: 7.2. Formatting Groups On Home Ribbon; title: 7.3. Font; title: 7.4. Point Size; title: 7.5. Bold, Italic And Underline; title: 7.6. Font Colour; title: 7.7. Background Fill Colour; title: 7.8. Borders; title: 7.9. Alignment; title: 7.10. Merge Cells; title: 7.11. Indents; title: 7.12. Number Formats; title: 7.13. ADVANCED FORMATS; title: 7.14. Format Cells Dialog; title: 7.15. Custom Number Formats; title: 7.16. FORMATTING COLUMNS AND ROWS; title: 7.17. Column Width; title: 7.18. Row Height; title: 7.19. Hide Columns, Rows And Sheets; title: 7.20. INSERT AND DELETE CELLS, ROWS, COLUMNS OR SHEETS; title: 7.21. Add Cells; title: 7.22. Delete Cells; title: 7.23. Format Painter; title: 7.24. Shortcut Keys For Formatting; title: 8. SECTION 7 NAMES; title: 8.1. NAMING CELLS AND RANGES; title: 8.2. Rules When Naming Cells; title: 8.3. Selecting Names (Navigation); title: 8.4. Manage Names By Using The Name Manager.; title: 8.5. Names In Functions; title: 8.6. Paste List Of Names; title: 8.7. Intersecting Names; title: 8.8. Applying Names; title: 8.9. Filtering out needed named ranges; title: 9. SECTION 8 WORKING WITH SHEETS; title: 9.1. MULTIPLE WORKSHEETS; title: 9.2. Moving Between The Workbook Sheets; title: 9.3. Worksheet Names; title: 9.4. Move And Copy Worksheets; title: 9.5. Insert And Delete Worksheets; title: 9.6. ACTIVATE GROUP MODE; title: 9.7. Group Adjacent Sheets; title: 9.8. Group Non-Adjacent Sheets; title: 9.9. Deactivate Group Mode; title: 9.10. FILL DATA ACROSS WORKSHEETS; title: 9.11. 3-D Formulae; title: 9.12. References to other sheets; title: 9.13. PROTECT WORKSHEET DATA; title: 9.14. Unlock Cells; title: 9.15. Worksheet Protection; title: 9.16. Unprotect Sheets; title: 9.17. View Worksheets Side By Side; title: 9.18. Hide Windows; title: 9.19. Watch Window; title: 9.20. Change Colour Of Worksheet Tab; title: 10. SECTION 9 PRINTING; title: 10.1. PRINT PREVIEW; title: 10.2. PAGE SETUP; title: 10.3. page setup group on the page layout ribbon; title: 10.4. PAGE TAB; title: 10.5. Print preview options; title: 10.6. MARGINS TAB; title: 10.7. To change header and footer position; title: 10.8. HEADER/FOOTER TAB; title: 10.9. Header; title: 10.10. Footer; title: 10.11. New Methods For Headers And Footers In 2010; title: 10.12. Insert Specific Elements In A Header Or Footer; title: 10.13. Add A Predefined Header Or Footer; title: 10.14. Choose The Header And Footer Options; title: 10.15. Custom Header Or Footer For A Chart; title: 10.16. SHEET TAB; title: 10.17. Print Area; title: 10.18. Print Titles; title: 10.19. Print; title: 10.20. To change Sheet tab Print settings:; title: 10.21. Page Breaks; title: 10.22. PRINT DATA; title: 10.23. Copies; title: 11. SECTION 10 MANIPULATING LARGE WORKSHEETS; title: 11.1. USEFUL TOOLS FOR LARGE SHEETS; title: 11.2. Split Screen; title: 11.3. Freeze Panes; title: 11.4. Zoom; title: 11.5. NAVIGATION; title: 11.6. Go To; title: 11.7. Navigating with name box; title: 12. SECTION 11 SORTING & SUBTOTALLING DATA; title: 12.1. LISTS; title: 12.2. Do; title: 12.3. Do Not; title: 12.4. SORTING LIST DATA; title: 12.5. Quick Sort; title: 12.6. Multi Level Sort; title: 12.7. SUBTOTALS; title: 12.8. Organising The List For Subtotals; title: 12.9. Example; title: 12.10. Summarising A Subtotalled List; title: 12.11. Show And Hide By Level; title: 12.12. Remove Subtotals; title: 13. SECTION 12 CUSTOMISING EXCEL; title: 13.1. SET EXCEL OPTIONS; title: 13.2. General; title: 13.3. Formulas Sheet; title: 13.4. Proofing; title: 13.5. Save; title: 13.6. Language; title: 13.7. Advanced Options; title: 13.8. Customise Excel Ribbons; title: 13.9. Customise Quick Access Toolbar