Skip navigation

Bookboon.com Download free eBooks and textbooks

Choose a category

Excel 2010 Introduction: Part II

Printing, Names and Sheets

Excel 2010 Introduction: Part II
4.4 (56 reviews) Read reviews
ISBN: 978-87-7681-805-0
1 edition
Pages : 100
Price: Free

Download for FREE in 4 easy steps...

We are terribly sorry, but in order to download our books or watch our videos, you will need a browser that allows JavaScript.
After entering your email address, a confirmation email will be sent to your inbox. Please approve this email to receive our weekly eBook update. We will not share your personal information with any third party.

This is a Premium eBook - get it free for 30 days

You can also read this in Bookboon.com Premium

Summary

In the second part of the Excel 2010 introduction series you will learn more about printing, names and sheets.

300+ Business books exclusively in our Premium eReader

  • No adverts
  • Advanced features
  • Personal library
More about Premium

Buy this eBook

Buy now

Subscribe to all 800+ eBooks

Start free trial 30 day FREE trial

About the book

  1. Description
  2. Content
  3. Embed
  4. Reviews

Description

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.

Content

  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

Embed

Size
Choose color
Implementation code. Copy into your own page
Embed Frame - Terms of Use

The embed frame is free to use for private persons, universities and schools. It is not allowed to be used by any company for commercial purposes unless it is for media coverage. You may not modify, build upon, or block any portion or functionality of the embed frame, including but not limited to links back to the bookboon.com website.

The Embed frame may not be used as part of a commercial business offering. The embed frame is intended for private people who want to share eBooks on their website or blog, professors or teaching professionals who want to make an eBook available directly on their page, and media, journalists or bloggers who wants to discuss a given eBook

If you are in doubt about whether you can implement the embed frame, you are welcome to contact Thomas Buus Madsen on tbm@bookboon.com and seek permission.

Reviews

Dinesh Mishra ★★★★★

Simply excellent.