Skip navigation

Bookboon.com Ladda ner e-böcker och kurslitteratur gratis

Choose a category

Excel 2010 Introduction: Part II

Printing, Names and Sheets

Excel 2010 Introduction: Part II
4,7 (160 läsarrecensioner) Läs recensioner
ISBN: 978-87-7681-805-0
1. Utgåva
Sidor : 100
  • Pris 75,50 kr
  • Pris €8,99
  • Pris £8,99
  • Pris ₹150
  • Pris $8,99
  • Pris 75,50 kr
  • Pris 75,50 kr

Ladda ner e-boken GRATIS i 4 enkla steg...

Vi beklagar verkligen, men för att kunna ladda ner våra böcker eller titta på våra videos måste din webbläsare tillåta JavaScript.
Är du intresserad av att få GRATIS eBöcker och uppdateringar från Bookboon?
Du kommer att få ett e-postmeddelande där du blir ombedd att bekräfta din e-postadress. Därefter kommer du att få ett meddelande om våra nya e-böcker varje vecka. Inga kontaktuppgifter som du uppger till oss kommer att lämnas ut till någon tredje part.
eLib
Ta vara på din organisations potential
Titta på demo

Ditt företags eBibliotek

Maximera ditt företags kompetens med hjälp av våra verktyg

Detta är en Premium eBok

Bookboon Premium - Få tillgång till över 800 reklamfria eBöcker

Du kan anmäla dig till Bookboon Premium och få GRATIS tillgång till denna samt 800 andra böcker i 30 dagar. Du kan köpa boken nedan.

  • Starta dina GRATIS 30 dagar. Därefter 39,99 kr/månad
  • Starta dina GRATIS 30 dagar. Därefter €5,99/månad
  • Starta dina GRATIS 30 dagar. Därefter £4,99/månad
  • Starta dina GRATIS 30 dagar. Därefter ₹299/månad
  • Starta dina GRATIS 30 dagar. Därefter $3,99/månad
  • Starta dina GRATIS 30 dagar. Därefter 39,99 kr/månad
  • Starta dina GRATIS 30 dagar. Därefter 39,99 kr/månad
eLib
Ta vara på din organisations potential
Klicka här!

Ditt företags eBibliotek

Maximera ditt företags kompetens med hjälp av våra verktyg

Om boken

  1. Läsarrecensioner
  2. Förklaring
  3. Innehåll

Läsarrecensioner

Jean Wilner Guerrier ★★★★★

Great book, easy to understand. I give it an A plus.

Professor M M Kenawi ★★★★★

An excellent illustrated resume covering its purpose in an efficient concise approach.

Dinesh Mishra ★★★★★

Simply excellent.

Förklaring

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.

Innehåll

  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
This website uses cookies to improve user experience. By using our website you consent to all cookies in accordance with EU regulation.