{"product_id":"excel-2013-all-in-one-for-dummies","title":"Excel 2013 All-In-One for Dummies","description":"\u003ctable align=\"center\" border=\"0\" cellpadding=\"2\" cellspacing=\"0\" width=\"100%\"\u003e\n\u003ctr\u003e\n\u003ctd class=\"productDetailSmallElements\"\u003e\n\u003cp\u003e\n\u003cstrong\u003eMarc Notes\u003c\/strong\u003e:\u003cbr\u003e\n\t\t\t\t\t\t\t\t8 books in 1: Excel basics, Worksheet design, Formulas and functions, Worksheet collaboration and review, Charts and graphics, Data management, Data analysis, Macros and VBA--Cover.;Includes index.;Due to publisher license, access is restricted to authorised GRAIL clients only. Please contact GRAIL staff.;The comprehensive reference, now completely up-to-date for Excel 2013!As the standard for spreadsheet applications, Excel is used worldwide - but it's not always user-friendly. However, in the hands of veteran bestselling author Greg Harvey, Excel gets a whole lot easier to understand! This handy all-in-one guide covers all the essentials, the new features, how to analyze data with Excel, and much more. The featured minibooks address Excel basics, worksheet design, formulas and functions, worksheet collaboration and review, charts and graphics, data management, data analysis, and Excel and VBA. 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 Walks you through the new analysis tools that help make it easier to visualize data with the click of a mouseDetails new ways to explore your data more intuitively and then analyze and display your results with a single clickWhether you're an Excel newbie or a veteran user to wants to get familiar with the latest version, Excel 2013 All-in-One For Dummies has everything you need to know.;EBSCO complete collection.\u003cbr\u003e\u003cbr\u003e\n\u003cstrong\u003eBiographical Note\u003c\/strong\u003e:\u003cbr\u003e\n\u003c\/p\u003e\n\u003cp\u003e\u003cb\u003eGreg Harvey\u003c\/b\u003e, PhD, is President of Mind Over Media and a highly skilled instructor. He has been writing computer books for more than 20 years, and his long list of bestsellers includes all editions of \u003ci\u003eExcel For Dummies\u003c\/i\u003e, \u003ci\u003e Excel All-in-One For Dummies\u003c\/i\u003e, and \u003ci\u003eExcel Workbook For Dummies\u003c\/i\u003e.\u003c\/p\u003e\n\u003cbr\u003e\u003cbr\u003e\n\u003cstrong\u003eTable of Contents\u003c\/strong\u003e:\u003cbr\u003e\n\t\t\t\t\t\t\t\tIntroduction 1 \n\u003cp\u003eAbout This Book 1\u003c\/p\u003e\n\u003cp\u003eFoolish Assumptions 2\u003c\/p\u003e\n\u003cp\u003eHow This Book Is Organized 3\u003c\/p\u003e\n\u003cp\u003eBook I: Excel Basics 3\u003c\/p\u003e\n\u003cp\u003eBook II: Worksheet Design 3\u003c\/p\u003e\n\u003cp\u003eBook III: Formulas and Functions 4\u003c\/p\u003e\n\u003cp\u003eBook IV: Worksheet Collaboration and Review 5\u003c\/p\u003e\n\u003cp\u003eBook V: Charts and Graphics 5\u003c\/p\u003e\n\u003cp\u003eBook VI: Data Management 6\u003c\/p\u003e\n\u003cp\u003eBook VII: Data Analysis 6\u003c\/p\u003e\n\u003cp\u003eBook VIII: Macros and VBA 6\u003c\/p\u003e\n\u003cp\u003eConventions Used in This Book 7\u003c\/p\u003e\n\u003cp\u003eIcons Used in This Book 8\u003c\/p\u003e\n\u003cp\u003eWhere to Go from Here 9\u003c\/p\u003e\n\u003cp\u003e\u003cb\u003eBook I: Excel Basics 11\u003c\/b\u003e\u003c\/p\u003e\n\u003cp\u003eChapter 1: The Excel 2013 User Experience 13\u003c\/p\u003e\n\u003cp\u003eChapter 2: Customizing Excel 2013 41\u003c\/p\u003e\n\u003cp\u003e\u003cb\u003eBook II: Worksheet Design 73\u003c\/b\u003e\u003c\/p\u003e\n\u003cp\u003eChapter 1: Building Worksheets 75\u003c\/p\u003e\n\u003cp\u003eChapter 2: Formatting Worksheets 125\u003c\/p\u003e\n\u003cp\u003eChapter 3: Editing and Proofing Worksheets 183\u003c\/p\u003e\n\u003cp\u003eChapter 4: Managing Worksheets 231\u003c\/p\u003e\n\u003cp\u003eChapter 5: Printing Worksheets 269\u003c\/p\u003e\n\u003cp\u003e\u003cb\u003eBook III: Formulas and Functions 297\u003c\/b\u003e\u003c\/p\u003e\n\u003cp\u003eChapter 1: Building Basic Formulas 299\u003c\/p\u003e\n\u003cp\u003eChapter 2: Logical Functions and Error Trapping 339\u003c\/p\u003e\n\u003cp\u003eChapter 3: Date and Time Formulas 361\u003c\/p\u003e\n\u003cp\u003eChapter 4: Financial Formulas 375\u003c\/p\u003e\n\u003cp\u003eChapter 5: Math and Statistical Formulas 389\u003c\/p\u003e\n\u003cp\u003eChapter 6: Lookup, Information, and Text Formulas 409\u003c\/p\u003e\n\u003cp\u003e\u003cb\u003eBook IV: Worksheet Collaboration and Review 431\u003c\/b\u003e\u003c\/p\u003e\n\u003cp\u003eChapter 1: Protecting Workbooks and Worksheet Data 433\u003c\/p\u003e\n\u003cp\u003eChapter 2: Using Hyperlinks 455\u003c\/p\u003e\n\u003cp\u003eChapter 3: Sending Workbooks Out for Review 463\u003c\/p\u003e\n\u003cp\u003eChapter 4: Sharing Workbooks and Worksheet Data 489\u003c\/p\u003e\n\u003cp\u003e\u003cb\u003eBook V: Charts and Graphics 513\u003c\/b\u003e\u003c\/p\u003e\n\u003cp\u003eChapter 1: Charting Worksheet Data 515\u003c\/p\u003e\n\u003cp\u003eChapter 2: Adding Graphic Objects 545\u003c\/p\u003e\n\u003cp\u003e\u003cb\u003eBook VI: Data Management 575\u003c\/b\u003e\u003c\/p\u003e\n\u003cp\u003eChapter 1: Building and Maintaining Data Lists 577\u003c\/p\u003e\n\u003cp\u003eChapter 2: Filtering and Querying a Data List 601\u003c\/p\u003e\n\u003cp\u003e\u003cb\u003eBook VII: Data Analysis 643\u003c\/b\u003e\u003c\/p\u003e\n\u003cp\u003eChapter 1: Performing What-If Scenarios 645\u003c\/p\u003e\n\u003cp\u003eChapter 2: Generating Pivot Tables 667\u003c\/p\u003e\n\u003cp\u003e\u003cb\u003eBook VIII: Macros and VBA 707\u003c\/b\u003e\u003c\/p\u003e\n\u003cp\u003eChapter 1: Building and Running Macros 709\u003c\/p\u003e\n\u003cp\u003eChapter 2: VBA Programming 721\u003c\/p\u003e\n\u003cp\u003eIndex 745\u003c\/p\u003e\n\u003cbr\u003e\u003cbr\u003e\n\u003cstrong\u003eJacket Description\/Back\u003c\/strong\u003e:\u003cbr\u003e\n\u003cp\u003e8 books in 1\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eExcel Basics\u003c\/li\u003e\n\u003cli\u003eWorksheet Design\u003c\/li\u003e\n\u003cli\u003eFormulas and Functions\u003c\/li\u003e\n\u003cli\u003eWorksheet Collaboration and Review\u003c\/li\u003e\n\u003cli\u003eCharts and Graphics\u003c\/li\u003e\n\u003cli\u003eData Management\u003c\/li\u003e\n\u003cli\u003eData Analysis\u003c\/li\u003e\n\u003cli\u003eMacros and VBA\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eExcel newbie or expert in older versions -- here's the reference you need for Excel 2013!\u003c\/p\u003e\n\u003cp\u003eUnderstanding how to use the many features of Excel 2013 is only half the battle. The other half is understanding what these features can do for you. So whether you're starting out or upgrading, using Excel on your desktop or tablet, this all-in-one guide covers what you need to know to master worksheets, formulas, functions, charts, even data analysis.\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eFor beginners -- start out right with an entire minibook devoted to mastering Excel basics\u003c\/li\u003e\n\u003cli\u003eWorking with worksheets -- learn to set up, edit, manage, and dress up worksheets and print reports\u003c\/li\u003e\n\u003cli\u003eGet functional -- explore formulas and functions from basic to complex and put them to work\u003c\/li\u003e\n\u003cli\u003eTeam effort -- share and collaborate on worksheets while keeping your data secure\u003c\/li\u003e\n\u003cli\u003eMake it look great -- present your data with impressive charts and graphs that help interpret the information\u003c\/li\u003e\n\u003cli\u003eManage your data -- take advantage of Excel's tools for managing large amounts of data and filtering out the information you need\u003c\/li\u003e\n\u003cli\u003eLook ahead -- use Excel's computational abilities to forecast and predict possible future outcomes\u003c\/li\u003e\n\u003cli\u003eExtend Excel -- install Apps for Office, use COM add-ins, and write macros and custom functions with the Visual Basic Editor\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eOpen the book and find: \u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eHow to build your own workbook templates\u003c\/li\u003e\n\u003cli\u003eInstructions for using Excel on a touchscreen\u003c\/li\u003e\n\u003cli\u003eAll the ways to enter data\u003c\/li\u003e\n\u003cli\u003eTips for preventing formula errors\u003c\/li\u003e\n\u003cli\u003eHints for sharing data with other Office 2013 programs\u003c\/li\u003e\n\u003cli\u003eGraphics you can include in your charts\u003c\/li\u003e\n\u003cli\u003eHow to query external data sources\u003c\/li\u003e\n\u003cli\u003eA guide to PowerPivot and Power View add-ins\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cbr\u003e\u003cbr\u003e\n\u003cstrong\u003ePublisher Marketing\u003c\/strong\u003e:\u003cbr\u003e\n\u003cp\u003e\u003cb\u003eThe comprehensive reference, now completely up-to-date for Excel 2013!\u003c\/b\u003e\u003c\/p\u003e\n\u003cp\u003eAs the standard for spreadsheet applications, Excel is used worldwide - but it's not always user-friendly. However, in the hands of veteran bestselling author Greg Harvey, Excel gets a whole lot easier to understand! This handy all-in-one guide covers all the essentials, the new features, how to analyze data with Excel, and much more. The featured 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\n\u003cul\u003e\n\u003cli\u003eCovers 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\n\u003cli\u003eWalks you through the new analysis tools that help make it easier to visualize data with the click of a mouse\u003c\/li\u003e\n\u003cli\u003eDetails new ways to explore your data more intuitively and then analyze and display your results with a single click\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eWhether you're an Excel newbie or a veteran user to wants to get familiar with the latest version, \u003ci\u003eExcel 2013 All-in-One For Dummies\u003c\/i\u003e has everything you need to know.\u003c\/p\u003e\n\u003cbr\u003e\u003cbr\u003e\n\n\u003cbr\u003e\n\u003cbr\u003e\n\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003c\/table\u003e\u003cp\u003e\u003cb\u003eAuthor:\u003c\/b\u003e Harvey, Greg\u003cbr\u003e\u003cb\u003ePublisher:\u003c\/b\u003e For Dummies\u003cbr\u003e\u003cb\u003eBinding:\u003c\/b\u003e Paperback\u003cbr\u003e\u003cb\u003ePub Date:\u003c\/b\u003e 2013-03-04\u003cbr\u003e\u003cb\u003eBISAC:\u003c\/b\u003e Computers|Business \u0026amp; Productivity Software|Spreadsheets\u003cbr\u003e\u003cb\u003eSubjects:\u003c\/b\u003e Electronic spreadsheets\u003cbr\u003e\u003cb\u003eWeight:\u003c\/b\u003e 2.15 lbs\u003cbr\u003e\u003cb\u003eISBN:\u003c\/b\u003e 9781118510100\u003cbr\u003e\u003cb\u003eASIN:\u003c\/b\u003e -\u003cbr\u003e\u003cb\u003eSKU:\u003c\/b\u003e SP-9781118510100\u003c\/p\u003e","brand":"For Dummies","offers":[{"title":"Default Title","offer_id":52148101873945,"sku":"SP-9781118510100","price":44.99,"currency_code":"USD","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0913\/0380\/5209\/files\/06e76a23-25c7-47bc-b73b-ccfa9cc4a8c8.jpg?v=1784489174","url":"https:\/\/westbindery.com\/products\/excel-2013-all-in-one-for-dummies","provider":"West Bindery","version":"1.0","type":"link"}