Categories Pricing Corporate
Professional eBook

Excel 2010 Introduction: Part II

Printing, Names and Sheets

(164 ratings)
3 reviews
100
Language:  English
In the second part of the Excel 2010 introduction series you will learn more about printing, names and sheets.
Professional Plus subscription free for the first 30 days, then $8.99/mo
Få åtkomst till boken på vår läsplatta. Ingen reklam i boken.
Description
Content
Reviews

In the second part of the Excel 2010 introduction series you will learn more about printing, names and sheets. If you want to learn about formulas, functions and formatting, download the first part of the Excel 2010 Introduction ebook.

Excel 2010 printing

When you want a hard copy of worksheet data, Excel gives you many tools for choosing how that printout will look. In the section about Excel 2010 printing you will learn for example how to set up printing preferences by using the page setup dialog. Insert and edit headers and footers and use print preview and page layout views.

Excel 2010 names

When entering formulas or referring to any area in a workbook, it is usual to refer to a ‘range’. For example, B6 is a range reference; B6:B10 is also a range reference. One problem with this sort of reference is that it is not very meaningful and therefore easily forgettable. In the section about names you will learn how to name cells and ranges by three methods. Further you will learn how to edit and manage names and how to sort and filter names.

Excel 2010 sheets

When you create a new workbook, Excel gives you multiple pages within that workbook called worksheets. In the section about sheets you will learn how to deal with sheets in Excel 2010. You will learn for example how to create and rename worksheets, how to create formulas and functions across worksheets and how to group worksheets.

  1. SECTION 8. EXCEL 2010 NAMES
    1. NAMING CELLS AND RANGES
    2. Rules When Naming Cells
    3. NAME BOX
    4. Method 1 (Define)
    5. Method 2 (Direct)
    6. Method 3 (By Selection)
    7. Selecting Names (Navigation)
    8. Manage Names By Using The Name Manager.
    9. Names In Functions
    10. Paste List Of Names
    11. Intersecting Names
    12. Applying Names
    13. Filtering Out Needed Named Ranges
  2. SECTION 9. EXCEL 2010 SHEETS
    1. MULTIPLE WORKSHEETS
    2. Moving Between The Workbook Sheets
    3. Worksheet Names
    4. Move And Copy Worksheets
    5. Insert And Delete Worksheets
    6. ACTIVATE GROUP MODE
    7. Group Adjacent Sheets
    8. Group Non-Adjacent Sheets
    9. Deactivate Group Mode
    10. FILL DATA ACROSS WORKSHEETS
    11. 3-D Formulae
    12. References To Other Sheets
    13. PROTECT WORKSHEET DATA
    14. Unlock Cells
    15. Worksheet Protection
    16. Unprotect Sheets
    17. View Worksheets Side By Side
    18. Hide Windows 106
    19. Watch Window
    20. Change Colour Of Worksheet Tab
  3. SECTION 10. EXCEL 2010 PRINTING
    1. PRINTING OPTIONS
    2. Print Preview
    3. PAGE SETUP
    4. Page Setup Group On The Page Layout Ribbon
    5. PAGE TAB
    6. Print Preview Options
    7. MARGINS TAB
    8. To Change Header And Footer Position:
    9. HEADER/FOOTER TAB
    10. Header
    11. Footer
    12. New Methods For Headers And Footers In 2010
    13. Insert Specific Elements In A Header Or Footer
    14. Add A Predefined Header Or Footer
    15. Choose The Header And Footer Options
    16. Custom Header Or Footer For A Chart
    17. SHEET TAB
    18. Print Area
    19. Print Titles
    20. Print
    21. To Change Sheet Tab Print Settings:
    22. Page Breaks
    23. PRINT DATA
    24. Copies
  4. SECTION 11. UTILISING LARGE WORKSHEETS
    1. USEFUL TOOLS FOR LARGE SHEETS
    2. Split Screen
    3. Freeze Panes
    4. Zoom
    5. NAVIGATION
    6. Go To
    7. Navigating With Name Box
  5. SECTION 12. CUSTOMISING EXCEL
    1. SET EXCEL OPTIONS
    2. General
    3. Formulas Sheet
    4. Proofing
    5. Save
    6. Language
    7. Advanced Options
    8. Customise Excel Ribbons
    9. Customise Quick Access Toolbar
Great book, easy to understand. I give it an A plus.
An excellent illustrated resume covering its purpose in an efficient concise approach.
Simply excellent.
More reviews
About the Author

Stephen Moffat, The Mouse Training Company