Introduction To Microsoft Excel 2010

Posted on  by
  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

Introduction To Microsoft Excel 2010 Tutorial

Introduction To Microsoft Excel 2010

How To Open Microsoft Excel

Introduction to. Microsoft Excel 2010. Screen Elements. The Ribbon The Ribbon is designed to help you quickly find the commands that you need to complete a task. Commands are organized in logical groups, which are collected together under tabs. Each tab relates to a type of activity, such as formatting or laying out a page. To reduce clutter. Then you need to master Microsoft Excel 2010 - and this is the place to do it. Even non-techie' beginners will find it easy to learn Excel in this fun, step-by-step online course. These lessons will teach you dozens of shortcuts and tricks for setting up fully formatted worksheets quickly and efficiently.