{"product_id":"excel-2010-all-in-one-for-dummies-isbn-9780470489598","title":"Excel 2010 All-in-One For Dummies","description":"\u003cb\u003eA comprehensive, up-to-date, user-friendly guide to Excel 2010\u003c\/b\u003e  \u003cp\u003eExcel is the standard for spreadsheet applications and is used worldwide, but it's not always user-friendly. That makes it a perfect \u003ci\u003eFor Dummies\u003c\/i\u003e topic, and this handy all-in-one guide covers all the essentials, the new features, how to analyze data with Excel, and much more.\u003c\/p\u003e \u003cp\u003eEight minibooks address Excel basics, worksheet design, formulas and functions, worksheet collaboration and review, charts and graphics, data management, data analysis, and Excel and VBA.\u003c\/p\u003e \u003cul\u003e \u003cli\u003eExcel is the leading spreadsheet\/data analysis software and is used throughout the world; the newest revision includes upgraded tools and a redesigned interface\u003c\/li\u003e \u003cli\u003eFor Dummies books are the bestselling guides to Excel, with more than three million copies sold\u003c\/li\u003e \u003cli\u003eExcel 2010 All-in-One For Dummies covers the changes in the newest version as well as familiar tasks, such as creating and editing worksheets, setting up formulas, and performing statistical functions\u003c\/li\u003e \u003cli\u003eEight self-contained minibooks cover the basics, worksheet design, formulas and functions, worksheet collaboration, presenting data in charts and graphics, data management, data analysis, and creating macros with VBA.\u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003eNewcomers to Excel as well as veterans who just want to learn the latest version will find \u003ci\u003eExcel 2010 All-in-One For Dummies\u003c\/i\u003e has everything they need to know.\u003c\/p\u003e  \u003cb\u003eIntroduction.\u003c\/b\u003e  \u003cp\u003e\u003cb\u003eBook I: Excel Basics.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 1: The Excel 2010 User Experience.\u003c\/p\u003e \u003cp\u003eChapter 2: Getting Help, Tips, and Updates.\u003c\/p\u003e \u003cp\u003eChapter 3: Customizing Excel.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eBook II: Worksheet Design.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 1: Building Worksheets.\u003c\/p\u003e \u003cp\u003eChapter 2: Formatting Worksheets.\u003c\/p\u003e \u003cp\u003eChapter 3: Editing and Proofi ng Worksheets.\u003c\/p\u003e \u003cp\u003eChapter 4: Managing Worksheets.\u003c\/p\u003e \u003cp\u003eChapter 5: Printing Worksheets.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eBook III: Formulas and Functions.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 1: Building Basic Formulas.\u003c\/p\u003e \u003cp\u003eChapter 2: Logical Functions and Error Trapping.\u003c\/p\u003e \u003cp\u003eChapter 3: Date and Time Formulas.\u003c\/p\u003e \u003cp\u003eChapter 4: Financial Formulas.\u003c\/p\u003e \u003cp\u003eChapter 5: Math and Statistical Formulas.\u003c\/p\u003e \u003cp\u003eChapter 6: Lookup, Information, and Text Formulas.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eBook IV: Worksheet Collaboration and Review.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 1: Protecting Workbooks and Worksheet Data.\u003c\/p\u003e \u003cp\u003eChapter 2: Linking Workbooks with Hyperlinks.\u003c\/p\u003e \u003cp\u003eChapter 3: Sending Workbooks Out for Review.\u003c\/p\u003e \u003cp\u003eChapter 4: Sharing Worksheets and Worksheet Data.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eBook V: Charts and Graphics.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 1: Charting Worksheet Data.\u003c\/p\u003e \u003cp\u003eChapter 2: Adding Graphic Objects.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eBook VI: Data Management.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 1: Building and Maintaining Data Lists.\u003c\/p\u003e \u003cp\u003eChapter 2: Filtering and Querying a Data List.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eBook VII: Data Analysis.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 1: Performing What-If Scenarios.\u003c\/p\u003e \u003cp\u003eChapter 2: Generating Pivot Tables.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eBook VIII: Excel and VBA.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 1: Building and Running Macros.\u003c\/p\u003e \u003cp\u003eChapter 2: VBA Programming.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eAppendix: Using XML File Formats.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eIndex.\u003c\/b\u003e\u003c\/p\u003e  \u003cp\u003e\u003cb\u003eGreg Harvey, PhD,\u003c\/b\u003e is president of Mind Over Media, Inc. He is the author of all editions of \u003ci\u003eExcel For Dummies, Excel All-in-One For Dummies, Excel Workbook For Dummies\u003c\/i\u003e, and \u003ci\u003eWindows For Dummies Quick Reference\u003c\/i\u003e. He's also an experienced educator.    \u003c\/p\u003e\u003cp\u003e\u003cb\u003e8 BOOKS IN 1\u003c\/b\u003e  \u003c\/p\u003e\u003cul\u003e \u003cli\u003e\u003cb\u003eExcel Basics\u003c\/b\u003e\u003c\/li\u003e \u003cli\u003e\u003cb\u003eWorksheet Design\u003c\/b\u003e\u003c\/li\u003e \u003cli\u003e\u003cb\u003eFormulas and Functions\u003c\/b\u003e\u003c\/li\u003e \u003cli\u003e\u003cb\u003eWorksheet Collaboration and Review\u003c\/b\u003e\u003c\/li\u003e \u003cli\u003e\u003cb\u003eCharts and Graphics\u003c\/b\u003e\u003c\/li\u003e \u003cli\u003e\u003cb\u003eData Management\u003c\/b\u003e\u003c\/li\u003e \u003cli\u003e\u003cb\u003eData Analysis\u003c\/b\u003e\u003c\/li\u003e \u003cli\u003e\u003cb\u003eExcel and VBA\u003c\/b\u003e\u003c\/li\u003e \u003c\/ul\u003e  \u003cp\u003e\u003cb\u003eHere's everything you need to know about using Excel  in one handy package!\u003c\/b\u003e  \u003c\/p\u003e\u003cp\u003eExcel is such a powerhouse, it takes eight self-contained minibooks to cover all its features! Open this All-in-One and find just what you need to know, from how to use the Ribbon interface and Backstage View and how to set up your first spreadsheet to collaborating on a worksheet, presenting results with cool charts and graphs, and understanding formulas and functions.  \u003c\/p\u003e\u003cul\u003e \u003cli\u003e\n\u003cb\u003eWelcome to 2010\u003c\/b\u003e  explore the new user experience, learn where to get help, and customize your Excel\u003c\/li\u003e \u003cli\u003e\n\u003cb\u003eWorkin' with worksheets\u003c\/b\u003e  learn to build, format, edit, proof, manage, and print them\u003c\/li\u003e \u003cli\u003e\n\u003cb\u003eFormula for success\u003c\/b\u003e  find out what formulas and functions do and how to use them\u003c\/li\u003e \u003cli\u003e\n\u003cb\u003eShare and collaborate\u003c\/b\u003e  discover how to send workbooks out for review and incorporate input from multiple users\u003c\/li\u003e \u003cli\u003e\n\u003cb\u003eResults that are pretty\u003c\/b\u003e  find out which type of chart shows off your data to best advantage\u003c\/li\u003e \u003cli\u003e\n\u003cb\u003eKeeping data in line\u003c\/b\u003e  learn to maintain, sort, and filter data lists using Excel\u003c\/li\u003e \u003cli\u003e\n\u003cb\u003eAnalyze this\u003c\/b\u003e  use Excel's computational ability to predict possible outcomes\u003c\/li\u003e \u003cli\u003e\n\u003cb\u003eMaking macros\u003c\/b\u003e  use Visual Basic\u003csup\u003e®\u003c\/sup\u003e for Applications, record macros, edit VBA code, and make Excel do your bidding\u003c\/li\u003e \u003c\/ul\u003e  \u003cp\u003e\u003cb\u003eOpen the book and find:\u003c\/b\u003e \u003c\/p\u003e\u003cul\u003e \u003cli\u003e\u003cb\u003eHow to navigate the Ribbon and Backstage View\u003c\/b\u003e\u003c\/li\u003e \u003cli\u003e\u003cb\u003eShortcuts for switching from older versions\u003c\/b\u003e\u003c\/li\u003e \u003cli\u003e\u003cb\u003eTricks for eliminating Text to Speech errors\u003c\/b\u003e\u003c\/li\u003e \u003cli\u003e\u003cb\u003eAll about functions and how they work in formulas\u003c\/b\u003e\u003c\/li\u003e \u003cli\u003e\u003cb\u003eHow to secure data and still enable user edits\u003c\/b\u003e\u003c\/li\u003e \u003cli\u003e\u003cb\u003eHow to use line charts, pie charts, and scatter charts\u003c\/b\u003e\u003c\/li\u003e \u003cli\u003e\u003cb\u003eTips for creating macros and custom functions\u003c\/b\u003e\u003c\/li\u003e \u003cli\u003e\u003cb\u003eHow to perform what-if analysis\u003c\/b\u003e\u003c\/li\u003e \u003c\/ul\u003e","brand":"For Dummies","offers":[{"title":"Default Title","offer_id":47989181481189,"sku":"NP9780470489598","price":34.99,"currency_code":"USD","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1842\/7735\/files\/9780470489598.jpg?v=1761783114","url":"https:\/\/k12savings.com\/products\/excel-2010-all-in-one-for-dummies-isbn-9780470489598","provider":"K12savings","version":"1.0","type":"link"}