Read more
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 ...
