Excel 2010 Introduction: Part II

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.

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.

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.

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