Log in

This website uses cookies

We use cookies to improve user experience. Choose which cookies you allow us to use. You can read more about our Cookie Policy in our privacy policy

See Cookies Details
Categories About Us
Professional eBook

Excel 2010 Introduction: Part I

Formulas, Functions and Formatting

by Stephen Moffat, The Mouse Training Company
(178 ratings )
4 reviews
128
Language :  English
Excel 2010 is a powerful spreadsheet application that allows users to produce tables containing calculations and graphs.
Professional Plus subscription free for the first 30 days, then $6.99/mo
Description
Content
Reviews

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.

  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
chetan M.
Helpful book to improve knowledge on Excel.
Retno Suliati Akt
Very helpful to us graduate students. This book explains us how to solve a very complicated statistical model.
Angelina Chimweta
Very helpful and refreshing
Lawrence Nyamunderu
its a good book
More reviews
Write a review
About the Author

Stephen Moffat, The Mouse Training Company

Related Content