Excel 2010 Introduction: Part I

Descripción

Excel 2010 is a powerful spreadsheet application that allows users to produce tables containing calculations and graphs. These can range from simple formulas through to complex functions and mathematical models.

After reading this eBook you will be able to understand the differences between Excel 2010 formulas and functions. Further you will learn how to use simple functions and formulas, like addition, subtraction and multiplications.

Contenido

1. INTRODUCTION
   1. How To Use This Guide
   2. Objectives
   3. Instructions
   4. Appendices
2. SECTION 1 THE BASICS
   1. WINDOWS CONCEPTS
   2. Menus
   3. Ribbons
   4. Dialog Box
   5. File Ribbon
   6. Toolbars
   7. Mini Toolbar
   8. Name Box
   9. Formula Bar
   10. Worksheets
   11. Status Bar
   12. Task Pane
   13. Smart Tags
   14. GETTING HELP
   15. MICROSOFT EXCEL HELP
3. SECTION 2 MOVE AROUND AND ENTER DATA
   1. MOVING
   2. Moving Around Workbook
   3. Scrolling
   4. USEFUL KEYS FOR MOVING
   5. WORKBOOK SHEETS
   6. Moving Around Sheet
   7. DATA ENTRY
   8. Enter Text And Numbers
   9. Cancelling And Editing Data Entries
   10. Enter Dates
   11. Autocomplete
   12. Pick From List
   13. EDITING
   14. Typing Replaces Selection
   15. Use The Mouse To Edit
   16. Using The Keyboard
   17. Select Information
   18. Select Multiple Sheets
   19. Select Non-Adjacent Sheets
   20. Clear Contents, Formats And Comments
   21. The Fill Handle
   22. USEFUL INFORMATION
   23. Scrolling
   24. Data Entry
   25. Select Cells To Limit Data Entry
   26. Select Cells For Multiple Entry
4. SECTION 3 EXCEL 2010 FORMULAS AND FUNCTIONS
   1. FORMULAE
   2. Typing Formulae
   3. Entering Formulae By Pointing
   4. Errors In Formulae
   5. Filling Formulae
   6. The Fill Handle And Formulae
   7. Fill Formulae Using Keystrokes
   8. BoDMAS With Formulae
   9. EXCEL 2010 FUNCTIONS
   10. Basic Sum Function
   11. Autosum
   12. Other Common Functions
   13. Function Library
   14. Insert Function
   15. Function Box
   16. Type Functions
   17. Function Argument Tool Tips
   18. Cell References
   19. ABSOLUTE AND RELATIVE REFERENCES
   20. Relative References
   21. Absolute References
   22. Fill Handle
   23. Absolute References
5. SECTION 4 FILE OPERATIONS
   1. Save Files
   2. File Types And File Names
   3. Saving Changes To Files
   4. Saving As A Different Type Or Different Name
   5. Close Files
   6. Open Files
   7. New Files
6. SECTION 5 MOVING AND COPYING DATA
   1. Moving Items
   2. Copying Items
   3. Clipboard
   4. Drag And Drop
   5. Shortcut Menus
   6. Moving And Copying Between Files
   7. Insert Paste
   8. Moving And Copying Between Worksheets
   9. Paste Special
7. SECTION 6 EXCEL 2010 FORMATTING
   1. QUICK FORMATS
   2. Formatting Groups On Home Ribbon
   3. Font
   4. Point Size
   5. Bold, Italic And Underline
   6. Font Colour
   7. Background Fill Colour
   8. Borders
   9. Alignment
   10. Merge Cells
   11. Indents
   12. Number Formats
   13. ADVANCED FORMATS
   14. Format Cells Dialog
   15. Custom Number Formats
   16. FORMATTING COLUMNS AND ROWS
   17. Column Width
   18. Row Height
   19. Hide Columns, Rows And Sheets
   20. INSERT AND DELETE CELLS, ROWS, COLUMNS OR SHEETS
   21. Add Cells
   22. Delete Cells
   23. Format Painter
   24. Shortcut Keys For Formatting
8. SECTION 7 NAMES
   1. NAMING CELLS AND RANGES
   2. Rules When Naming Cells
   3. Selecting Names (Navigation)
   4. Manage Names By Using The Name Manager.
   5. Names In Functions
   6. Paste List Of Names
   7. Intersecting Names
   8. Applying Names
   9. Filtering out needed named ranges
9. SECTION 8 WORKING WITH 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
   19. Watch Window
   20. Change Colour Of Worksheet Tab
10. SECTION 9 PRINTING
    1. PRINT PREVIEW
    2. PAGE SETUP
    3. page setup group on the page layout ribbon
    4. PAGE TAB
    5. Print preview options
    6. MARGINS TAB
    7. To change header and footer position
    8. HEADER/FOOTER TAB
    9. Header
    10. Footer
    11. New Methods For Headers And Footers In 2010
    12. Insert Specific Elements In A Header Or Footer
    13. Add A Predefined Header Or Footer
    14. Choose The Header And Footer Options
    15. Custom Header Or Footer For A Chart
    16. SHEET TAB
    17. Print Area
    18. Print Titles
    19. Print
    20. To change Sheet tab Print settings:
    21. Page Breaks
    22. PRINT DATA
    23. Copies
11. SECTION 10 MANIPULATING 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
12. SECTION 11 SORTING & SUBTOTALLING DATA
    1. LISTS
    2. Do
    3. Do Not
    4. SORTING LIST DATA
    5. Quick Sort
    6. Multi Level Sort
    7. SUBTOTALS
    8. Organising The List For Subtotals
    9. Example
    10. Summarising A Subtotalled List
    11. Show And Hide By Level
    12. Remove Subtotals
13. 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