Excel 2010 - The Missing Manual

Informationen zum Autor Matthew MacDonald is a science and technology writer with well over a dozen books to his name. Web novices can tiptoe out onto the Internet with him in Creating a Website: The Missing Manual. HTML fans can learn about the cutting edge of web design in HTML5: The Missing Manual. And human beings of all description can discover just how strange they really are in the quirky handbooks Your Brain: The Missing Manual and Your Body: The Missing Manual. Klappentext Excel, the world's most popular spreadsheet program, has the muscle to analyze heaps of data. Beyond basic number-crunching, Excel 2010 has many impressive features that are hard to find, much less master -- especially from online help pages. This Missing Manual clearly explains how everything works with a unique and witty style to help you learn quickly. * Navigate with ease. Master Excel's tabbed toolbar and its new backstage view * Perform a variety of calculations. Write formulas for rounding numbers, calculating mortgage payments, and more * Organize your data. Search, sort, and filter huge amounts of information * Illustrate trends. Bring your data to life with charts and graphics -- including miniature charts called Sparklines * Examine your data. Summarize information and find hidden patterns with pivot tables and slicers * Share your spreadsheets. Use the Excel Web App to collaborate with colleagues online * Rescue lost data. Restore old versions of data and find spreadsheets you forgot to save Zusammenfassung Shows you how to get the most out of Excel 2010 - from building your first spreadsheet to working with Pivot tables. This title helps to learn how to develop a spreadsheet from scratch, create formulas, add data, and analyze and graph data so you can make informed business decisions. Inhaltsverzeichnis The Missing Credits Introduction Part One: Worksheet Basics Chapter 1: Creating Your First Spreadsheet Chapter 2: Adding Information to Worksheets Chapter 3: Moving Data Chapter 4: Managing Worksheets Chapter 5: Formatting Cells Chapter 6: Smart Formatting Tricks Chapter 7: Viewing and Printing Worksheets Part Two: Formulas and Functions Chapter 8: Building Basic Formulas Chapter 9: Math and Statistical Functions Chapter 10: Financial Functions Chapter 11: Manipulating Dates, Times, and Text Chapter 12: Lookup, Reference, and Information Functions Chapter 13: Advanced Formula Writing and Troubleshooting Part Three: Organizing Worksheets Chapter 14: Tables: List Management Made Easy Chapter 15: Grouping and Outlining Data Chapter 16: Templates Part Four: Charts and Graphics Chapter 17: Creating Basic Charts Chapter 18: Formatting and Perfecting Charts Chapter 19: Inserting Graphics Part Five: Advanced Data Analysis Chapter 20: Visualizing Your Data Chapter 21: Scenarios and Goal Seeking Chapter 22: Pivot Tables Chapter 23: Analyzing Databases, XML, and Web Pages Part Six: Sharing Data with the Rest of the World Chapter 24: Protecting Your Workbooks Chapter 25: Worksheet Collaboration Chapter 26: Using Excel on the Web Chapter 27: Exchanging Data with Other Programs Part Seven: Programming Excel Chapter 28: Automating Tasks with Macros Chapter 29: Programming Spreadsheets with VBA Part Eight: Appendix Customizing the Ribbon ...

Sommario

• 
  The Missing Credits
  


• 
  Introduction
  


• 
  Part One: Worksheet Basics
  
  
  
  • 
    Chapter 1: Creating Your First Spreadsheet
    
  
  
  • 
    Chapter 2: Adding Information to Worksheets
    
  
  
  • 
    Chapter 3: Moving Data
    
  
  
  • 
    Chapter 4: Managing Worksheets
    
  
  
  • 
    Chapter 5: Formatting Cells
    
  
  
  • 
    Chapter 6: Smart Formatting Tricks
    
  
  
  • 
    Chapter 7: Viewing and Printing Worksheets
    
  
  
  
  
  
• 
  Part Two: Formulas and Functions
  
  
  
  • 
    Chapter 8: Building Basic Formulas
    
  
  
  • 
    Chapter 9: Math and Statistical Functions
    
  
  
  • 
    Chapter 10: Financial Functions
    
  
  
  • 
    Chapter 11: Manipulating Dates, Times, and Text
    
  
  
  • 
    Chapter 12: Lookup, Reference, and Information Functions
    
  
  
  • 
    Chapter 13: Advanced Formula Writing and Troubleshooting
    
  
  
  
  
  
• 
  Part Three: Organizing Worksheets
  
  
  
  • 
    Chapter 14: Tables: List Management Made Easy
    
  
  
  • 
    Chapter 15: Grouping and Outlining Data
    
  
  
  • 
    Chapter 16: Templates
    
  
  
  
  
  
• 
  Part Four: Charts and Graphics
  
  
  
  • 
    Chapter 17: Creating Basic Charts
    
  
  
  • 
    Chapter 18: Formatting and Perfecting Charts
    
  
  
  • 
    Chapter 19: Inserting Graphics
    
  
  
  
  
  
• 
  Part Five: Advanced Data Analysis
  
  
  
  • 
    Chapter 20: Visualizing Your Data
    
  
  
  • 
    Chapter 21: Scenarios and Goal Seeking
    
  
  
  • 
    Chapter 22: Pivot Tables
    
  
  
  • 
    Chapter 23: Analyzing Databases, XML, and Web Pages
    
  
  
  
  
  
• 
  Part Six: Sharing Data with the Rest of the World
  
  
  
  • 
    Chapter 24: Protecting Your Workbooks
    
  
  
  • 
    Chapter 25: Worksheet Collaboration
    
  
  
  • 
    Chapter 26: Using Excel on the Web
    
  
  
  • 
    Chapter 27: Exchanging Data with Other Programs
    
  
  
  
  
  
• 
  Part Seven: Programming Excel
  
  
  
  • 
    Chapter 28: Automating Tasks with Macros
    
  
  
  • 
    Chapter 29: Programming Spreadsheets with VBA
    
  
  
  
  
  
• 
  Part Eight: Appendix
  
  
  
  • 
    Customizing the Ribbon
    
  
  
  
  
  
  
  

Dettagli sul prodotto

• Autori: Matthew MacDonald
• Editore: External catalogues US
• Lingue: Inglese
• Formato: Tascabile
• Pubblicazione: 13.07.2010
• EAN: 9781449382353
• ISBN: 978-1-4493-8235-3
• Serie: The missing manual; Missing Manual
• Categorie: Scienze naturali, medicina, informatica, tecnica > Informatica, EDP; Excel, Spreadsheet software, COMPUTERS / Business & Productivity Software / Spreadsheets