{"product_id":"excel-2019-all-in-one-for-dummies-isbn-9781119517948","title":"Excel 2019 All-in-One For Dummies","description":"\u003cp\u003e\u003cb\u003eMake Excel work for you\u003c\/b\u003e \u003c\/p\u003e \u003cp\u003e\u003ci\u003eExcel 2019 All-In-One For Dummies\u003c\/i\u003e offers eight books in one!! It is completely updated to reflect the major changes Microsoft is making to Office with the 2019 release. From basic Excel functions, such as creating and editing worksheets, to sharing and reviewing worksheets, to editing macros with Visual Basic, it provides you with a broad scope of the most common Excel applications and functions—including formatting worksheets, setting up formulas, protecting worksheets, importing data, charting data, and performing statistical functions. \u003cbr\u003e    \u003cbr\u003eThe book covers importing data, building and editing worksheets, creating formulas, generating pivot tables, and performing financial functions, what-if scenarios, database functions, and Web queries. More advanced topics include worksheet sharing and auditing, performing error trapping, building and running macros, charting data, and using Excel in conjunction with Microsoft Power BI (Business Intelligence) to analyze, model, and visualize vast quantities of data from a variety of local and online sources.  \u003c\/p\u003e \u003cul\u003e \u003cli\u003eGet familiar with Worksheet design\u003c\/li\u003e \u003cli\u003eFind out how to work with charts and graphics\u003c\/li\u003e \u003cli\u003eUse Excel for data management, analysis, modeling, and visualization\u003c\/li\u003e \u003cli\u003eMake sense of macros and VBA\u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003eIf you’re a new or inexperienced user looking to spend more time on your projects than trying to figure out how to make Excel work for you, this all-encompassing book makes it easy!\u003c\/p\u003e \u003cp\u003e\u003cb\u003eIntroduction\u003c\/b\u003e\u003cb\u003e 1\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eAbout This Book 2\u003c\/p\u003e \u003cp\u003eFoolish Assumptions 2\u003c\/p\u003e \u003cp\u003eHow This Book Is Organized 3\u003c\/p\u003e \u003cp\u003eConventions Used in This Book 7\u003c\/p\u003e \u003cp\u003eIcons Used in This Book 9\u003c\/p\u003e \u003cp\u003eBeyond the Book 9\u003c\/p\u003e \u003cp\u003eWhere to Go from Here 10\u003c\/p\u003e \u003cp\u003e\u003cb\u003eBook 1: Excel Basics\u003c\/b\u003e\u003cb\u003e 11\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 1: The Excel 2019 User Experience\u003c\/b\u003e\u003cb\u003e 13\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eExcel 2019’s Sleek Look and Feel 14\u003c\/p\u003e \u003cp\u003eExcel’s Start Screen 15\u003c\/p\u003e \u003cp\u003eExcel’s Ribbon User Interface 16\u003c\/p\u003e \u003cp\u003eGetting Help 36\u003c\/p\u003e \u003cp\u003eLaunching and Quitting Excel 39\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 2: Customizing Excel 2019\u003c\/b\u003e\u003cb\u003e 45\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eTailoring the Quick Access Toolbar to Your Tastes 46\u003c\/p\u003e \u003cp\u003eExercising Your Options 49\u003c\/p\u003e \u003cp\u003eUsing Office Add-ins 72\u003c\/p\u003e \u003cp\u003eUsing Excel’s Own Add-ins 74\u003c\/p\u003e \u003cp\u003e\u003cb\u003eBook 2: Worksheet Design\u003c\/b\u003e\u003cb\u003e 79\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 1: Building Worksheets\u003c\/b\u003e\u003cb\u003e 81\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eDesigner Spreadsheets 82\u003c\/p\u003e \u003cp\u003eIt Takes All Kinds (Of Cell Entries) 92\u003c\/p\u003e \u003cp\u003eData Entry 101 99\u003c\/p\u003e \u003cp\u003eSaving the Data 124\u003c\/p\u003e \u003cp\u003eDocument Recovery to the Rescue 130\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 2: Formatting Worksheets\u003c\/b\u003e\u003cb\u003e 133\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eMaking Cell Selections 134\u003c\/p\u003e \u003cp\u003eAdjusting Columns and Rows 143\u003c\/p\u003e \u003cp\u003eFormatting Tables from the Ribbon 148\u003c\/p\u003e \u003cp\u003eFormatting Tables with the Quick Analysis Tool 152\u003c\/p\u003e \u003cp\u003eFormatting Cells from the Ribbon 153\u003c\/p\u003e \u003cp\u003eFormatting Cell Ranges with the Mini-Toolbar 156\u003c\/p\u003e \u003cp\u003eUsing the Format Cells Dialog Box 158\u003c\/p\u003e \u003cp\u003eHiring Out the Format Painter 177\u003c\/p\u003e \u003cp\u003eUsing Cell Styles 178\u003c\/p\u003e \u003cp\u003eConditional Formatting 183\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 3: Editing and Proofing Worksheets\u003c\/b\u003e\u003cb\u003e 193\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eOpening a Workbook 194\u003c\/p\u003e \u003cp\u003eCell Editing 101 201\u003c\/p\u003e \u003cp\u003eA Spreadsheet with a View 209\u003c\/p\u003e \u003cp\u003eCopying and Moving Stuff Around 216\u003c\/p\u003e \u003cp\u003eFind and Replace This Disgrace! 227\u003c\/p\u003e \u003cp\u003eSpell Checking Heaven 232\u003c\/p\u003e \u003cp\u003eLooking Up and Translating Stuff 236\u003c\/p\u003e \u003cp\u003eMarking Invalid Data 237\u003c\/p\u003e \u003cp\u003eEliminating Errors with Text to Speech 238\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 4: Managing Worksheets\u003c\/b\u003e\u003cb\u003e 241\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eReorganizing the Worksheet 242\u003c\/p\u003e \u003cp\u003eReorganizing the Workbook 257\u003c\/p\u003e \u003cp\u003eWorking with Multiple Workbooks 267\u003c\/p\u003e \u003cp\u003eConsolidating Worksheets 270\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 5: Printing Worksheets\u003c\/b\u003e\u003cb\u003e 277\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003ePrinting from the Excel 2019 Backstage View 278\u003c\/p\u003e \u003cp\u003eQuick Printing the Worksheet 284\u003c\/p\u003e \u003cp\u003eWorking with the Page Setup Options 285\u003c\/p\u003e \u003cp\u003eUsing the Print Options on the Sheet tab of the Page Setup dialog box 293\u003c\/p\u003e \u003cp\u003eHeaders and Footers 294\u003c\/p\u003e \u003cp\u003eSolving Page Break Problems 301\u003c\/p\u003e \u003cp\u003ePrinting the Formulas in a Report 303\u003c\/p\u003e \u003cp\u003e\u003cb\u003eBook 3: Formulas and Functions\u003c\/b\u003e\u003cb\u003e 305\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 1: Building Basic Formulas\u003c\/b\u003e\u003cb\u003e 307\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eFormulas 101 308\u003c\/p\u003e \u003cp\u003eCopying Formulas 321\u003c\/p\u003e \u003cp\u003eAdding Array Formulas 327\u003c\/p\u003e \u003cp\u003eRange Names in Formulas 332\u003c\/p\u003e \u003cp\u003eAdding Linking Formulas 341\u003c\/p\u003e \u003cp\u003eControlling Formula Recalculation 343\u003c\/p\u003e \u003cp\u003eCircular References 345\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 2: Logical Functions and Error Trapping\u003c\/b\u003e\u003cb\u003e 347\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eUnderstanding Error Values 348\u003c\/p\u003e \u003cp\u003eUsing Logical Functions 349\u003c\/p\u003e \u003cp\u003eError-Trapping Formulas 353\u003c\/p\u003e \u003cp\u003eWhiting-Out Errors with Conditional Formatting 356\u003c\/p\u003e \u003cp\u003eFormula Auditing 358\u003c\/p\u003e \u003cp\u003eRemoving Errors from the Printout 370\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 3: Date and Time Formulas\u003c\/b\u003e\u003cb\u003e 371\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eUnderstanding Dates and Times 371\u003c\/p\u003e \u003cp\u003eUsing Date Functions 374\u003c\/p\u003e \u003cp\u003eUsing Time Functions 383\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 4: Financial Formulas\u003c\/b\u003e\u003cb\u003e 387\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eFinancial Functions 101 387\u003c\/p\u003e \u003cp\u003eThe PV, NPV, and FV Functions 388\u003c\/p\u003e \u003cp\u003eThe PMT Function 392\u003c\/p\u003e \u003cp\u003eDepreciation Functions 395\u003c\/p\u003e \u003cp\u003eAnalysis ToolPak Financial Functions 398\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 5: Math and Statistical Formulas\u003c\/b\u003e\u003cb\u003e 401\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eMath \u0026amp; Trig Functions 402\u003c\/p\u003e \u003cp\u003eStatistical Functions 412\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 6: Lookup, Information, and Text Formulas\u003c\/b\u003e\u003cb\u003e 421\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eLookup and Reference 422\u003c\/p\u003e \u003cp\u003eInformation, Please 433\u003c\/p\u003e \u003cp\u003eMuch Ado about Text 438\u003c\/p\u003e \u003cp\u003e\u003cb\u003eBook 4: Worksheet Collaboration and Review\u003c\/b\u003e\u003cb\u003e 445\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 1: Protecting Workbooks and Worksheet Data\u003c\/b\u003e\u003cb\u003e 447\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003ePassword-Protecting the File 448\u003c\/p\u003e \u003cp\u003eProtecting the worksheet 456\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 2: Using Hyperlinks\u003c\/b\u003e\u003cb\u003e 469\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eHyperlinks 101 469\u003c\/p\u003e \u003cp\u003eUsing the HYPERLINK Function 475\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 3: Preparing a Workbook for Distribution \u003c\/b\u003e\u003cb\u003e477\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eGetting Your Workbook Ready for Review 478\u003c\/p\u003e \u003cp\u003eAnnotating Workbooks 484\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 4: Sharing Workbooks and Worksheet Data\u003c\/b\u003e\u003cb\u003e 491\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eSharing Your Workbooks Online 492\u003c\/p\u003e \u003cp\u003eExcel 2019 Data Sharing Basics 503\u003c\/p\u003e \u003cp\u003eExporting Workbooks to Other Usable File Formats 511\u003c\/p\u003e \u003cp\u003e\u003cb\u003eBook 5: Charts and Graphics\u003c\/b\u003e\u003cb\u003e 517\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 1: Charting Worksheet Data\u003c\/b\u003e\u003cb\u003e 519\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eWorksheet Charting 101 520\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 2: Adding Graphic Objects \u003c\/b\u003e\u003cb\u003e553\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eGraphic Objects 101 554\u003c\/p\u003e \u003cp\u003eInserting Different Types of Graphics 562\u003c\/p\u003e \u003cp\u003eDrawing Graphics 569\u003c\/p\u003e \u003cp\u003eAdding Screenshots of the Windows 10 Desktop 580\u003c\/p\u003e \u003cp\u003eUsing Themes 581\u003c\/p\u003e \u003cp\u003e\u003cb\u003eBook 6: Data Management\u003c\/b\u003e\u003cb\u003e 583\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 1: Building and Maintaining Data Lists\u003c\/b\u003e\u003cb\u003e 585\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eData List Basics 586\u003c\/p\u003e \u003cp\u003eDesigning the basic data list 586\u003c\/p\u003e \u003cp\u003eAdd new records to a data list 589\u003c\/p\u003e \u003cp\u003eEliminating records with duplicate fields 595\u003c\/p\u003e \u003cp\u003eSorting Data 596\u003c\/p\u003e \u003cp\u003eSorting records on a single field 597\u003c\/p\u003e \u003cp\u003eSorting records on multiple fields 597\u003c\/p\u003e \u003cp\u003eSorting the columns of a data list 601\u003c\/p\u003e \u003cp\u003eSorting a data list on font and fill colors and cell icons 604\u003c\/p\u003e \u003cp\u003eSubtotaling Data 605\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 2: Filtering and Querying a Data List\u003c\/b\u003e\u003cb\u003e 609\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eData List Filtering 101 610\u003c\/p\u003e \u003cp\u003eFiltering Data 611\u003c\/p\u003e \u003cp\u003eUsing the Database Functions 628\u003c\/p\u003e \u003cp\u003eExternal Data Query 631\u003c\/p\u003e \u003cp\u003e\u003cb\u003eBook 7: Data Analysis\u003c\/b\u003e\u003cb\u003e 647\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 1: Performing What-If Scenarios\u003c\/b\u003e\u003cb\u003e 649\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eUsing Data Tables 650\u003c\/p\u003e \u003cp\u003eExploring Different Scenarios 656\u003c\/p\u003e \u003cp\u003eHide and Goal Seeking 662\u003c\/p\u003e \u003cp\u003eUsing the Solver 664\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 2: Performing Large-Scale Data Analysis\u003c\/b\u003e\u003cb\u003e 673\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eCreating Pivot Tables 674\u003c\/p\u003e \u003cp\u003eFormatting a Pivot Table 683\u003c\/p\u003e \u003cp\u003eSorting and Filtering the Pivot Table Data 688\u003c\/p\u003e \u003cp\u003eModifying the Pivot Table 693\u003c\/p\u003e \u003cp\u003eCreating Pivot Charts 699\u003c\/p\u003e \u003cp\u003eUsing the Power Pivot Add-in 702\u003c\/p\u003e \u003cp\u003eUsing the 3D Map feature 709\u003c\/p\u003e \u003cp\u003eCreating Forecast Worksheets 714\u003c\/p\u003e \u003cp\u003e\u003cb\u003eBook 8: Macros and VBA\u003c\/b\u003e\u003cb\u003e 719\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 1: Recording and Running Macros\u003c\/b\u003e\u003cb\u003e 721\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eMacro Basics 722\u003c\/p\u003e \u003cp\u003eAssigning Macros to the Ribbon and the Quick Access Toolbar 728\u003c\/p\u003e \u003cp\u003eMacro Security 730\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 2: VBA Programming\u003c\/b\u003e\u003cb\u003e 733\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eUsing the Visual Basic Editor 734\u003c\/p\u003e \u003cp\u003eCreating Custom Excel Functions 747\u003c\/p\u003e \u003cp\u003eIndex 757\u003c\/p\u003e  \u003cp\u003e\u003cb\u003eGreg Harvey, PhD,\u003c\/b\u003e is a veteran computer educator dating back to the days of DOS and Lotus 1-2-3. He has taught spreadsheet and database management courses at Golden Gate University and written dozens of books, including many in the \u003ci\u003eFor Dummies\u003c\/i\u003e series.   \u003c\/p\u003e\u003cp\u003e\u003cb\u003eYour complete guide to Microsoft Excel 2019\u003c\/b\u003e  \u003c\/p\u003e\u003cp\u003eExcel is the number one number-crunching program just about everywhere. Everything you need to know to take advantage of this winning spreadsheet application is right here! Learn how to create, edit, share and review worksheets. Then take your skills to another level by creating formulas, editing macros, generating pivot tables, charting and analyzing data, and so much more—take a deep dive into Excel with this all-in-one approach!  \u003c\/p\u003e\u003cp\u003e\u003cb\u003e8 Books Inside…\u003c\/b\u003e \u003c\/p\u003e\u003cul\u003e \u003cli\u003eExcel Basics\u003c\/li\u003e \u003cli\u003eWorksheet Design\u003c\/li\u003e \u003cli\u003eFormulas and Functions\u003c\/li\u003e \u003cli\u003eWorksheet Collaboration and Review\u003c\/li\u003e \u003cli\u003eCharts and Graphics\u003c\/li\u003e \u003cli\u003eData Management\u003c\/li\u003e \u003cli\u003eData Analysis\u003c\/li\u003e \u003cli\u003eMacros and VBA\u003c\/li\u003e \u003c\/ul\u003e","brand":"For Dummies","offers":[{"title":"Default Title","offer_id":47989181841637,"sku":"NP9781119517948","price":39.99,"currency_code":"USD","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1842\/7735\/files\/9781119517948.jpg?v=1761783116","url":"https:\/\/k12savings.com\/products\/excel-2019-all-in-one-for-dummies-isbn-9781119517948","provider":"K12savings","version":"1.0","type":"link"}