Skip navigation

Bookboon.com Download free eBooks and textbooks

Choose a category

Excel 2010 Introduction: Part I

Formulas, Functions and Formatting

Excel 2010 Introduction: Part I
4.5 (96 reviews) Read reviews
ISBN: 978-87-7681-804-3
1 edition
Pages : 128
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.

You can also read this in Bookboon.com Premium

Summary

Excel 2010 is a powerful spreadsheet application that allows users to produce tables containing calculations and graphs.

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

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.

Having produced a spreadsheet, it may be formatted to achieve a more professional and more easily readable layout of data for both screen display and printout. There are several different ways of formatting data in Excel 2010 to produce extremely impressive effects. You will learn more about Excel 2010 formatting in the final section of this ebook.

Download here part II of this series:

  • Excel 2010 Introduction: Part II - Printing, Names and Sheets

  • Content

  • INTRODUCTION
    1. How To Use This Guide
    2. Objectives
    3. Instructions
    4. Appendices
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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

    Angelina Chimweta ★★★★★

    Very helpful and refreshing

    Lawrence Nyamunderu ★★★☆☆

    its a good book