{"product_id":"getting-great-results-with-excel-pivot-tables-powerquery-and-powerpivot-paperback-softback-9781394243051","title":"Getting Great Results with Excel Pivot Tables, PowerQuery and PowerPivot (Paperback \/ softback) 9781394243051","description":"\u003cfont face=\"Georgia\"\u003e\r\n\u003cp\u003e\u003cfont size=\"6\"\u003eGetting Great Results with Excel Pivot Tables, PowerQuery and PowerPivot\u003c\/font\u003e\u003cbr\u003e\r\n\r\n\r\n\r\n\r\n\r\n\u003c\/p\u003e\n\u003cp\u003e\u003cfont size=\"4\"\u003eThomas Fragale (Author)\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\u003cp\u003e\u003cfont size=\"3\"\u003e9781394243051, Wiley\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\u003cp\u003e\u003cfont size=\"3\"\u003ePaperback \/ softback, published 29 April 2024\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\u003cp\u003e\u003cfont size=\"3\"\u003e304 pages\u003cbr\u003e23.4 x 18.5 x 1.8 cm, 0.431 kg\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\r\n\r\n\r\n\r\n\u003cp align=\"justify\"\u003e\u003cstrong\u003e\u003cfont size=\"3\"\u003e\u003cp\u003e\u003cb\u003eGet more out of your data with step-by-step tutorials for the Excel features you need to know\u003c\/b\u003e \u003c\/p\u003e\n\u003cp\u003eExcel is still the most popular tool for organizing and analyzing data, and today's professionals are expected to have a high degree of fluency with it. Complex Excel tools like Pivot Tables, PowerQuery, and PowerPivot can help you manage and report on data the way you need to. \u003ci\u003eGetting Great Results with Excel Pivot Tables, PowerQuery and PowerPivot\u003c\/i\u003e offers a fresh look at how these tools can help you. Author and Microsoft Certified Trainer Thomas Fragale breaks down the topics into easy-to-use steps and screenshots, so you'll be able to put your advanced Excel skills into practice right away. \u003c\/p\u003e\n\u003cp\u003eUsing Pivot Tables, PowerQuery, and PowerPivot, you can import, sort, transform, summarize, and present your data, all without having to be a programmer. This book takes the technical jargon out of using these features, so you can do your job more efficiently, bring value to your teams, and advance your career. The plain-English instructions inside will help anyone learn to get quick, meaningful results from your data, without having a degree in computing. \u003c\/p\u003e\n\u003cul\u003e \u003cli\u003eGet easy-to-understand walkthroughs for analyzing data and creating dashboards in Microsoft Excel\u003c\/li\u003e \u003cli\u003eLearn how to organize data in Excel and use advanced features to find patterns and insights\u003c\/li\u003e \u003cli\u003eSummarize any kind of data faster and easier, leaving you more time for other tasks\u003c\/li\u003e \u003cli\u003eTurn raw numbers into new knowledge, reports, and charts that tell coworkers and customers what they need to know\u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003eThis book is great for anybody who has tons of raw data and needs to make sense of it. Managers, salespeople, finance professionals, marketers—along with anyone else who works with large amounts of data—will love this quick and easy guide to Pivot Tables, PowerQuery, and PowerPivot.\u003c\/p\u003e\u003c\/font\u003e\u003c\/strong\u003e\u003c\/p\u003e\r\n\r\n\u003cp\u003e\u003cfont size=\"3\"\u003e\u003cp\u003eForeword xxi\u003c\/p\u003e \u003cp\u003eIntroduction xxiii\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 1 Preparing the Data for an Excel Pivot Table 1\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eWhat Is Data? 2\u003c\/p\u003e \u003cp\u003eWhat the Data Should Look Like 3\u003c\/p\u003e \u003cp\u003eTypes of Data That Can Be Used in Excel Pivot Tables 6\u003c\/p\u003e \u003cp\u003eUsing Excel Data 7\u003c\/p\u003e \u003cp\u003eImporting Data from External Data Sources into Excel 9\u003c\/p\u003e \u003cp\u003eImporting Data from a Text\/CSV File 10\u003c\/p\u003e \u003cp\u003eImporting Data from an Access Database 13\u003c\/p\u003e \u003cp\u003eImporting Data from a Web Page 13\u003c\/p\u003e \u003cp\u003eConnecting to an ODBC Database 16\u003c\/p\u003e \u003cp\u003eImporting Data from a Different Excel Workbook 17\u003c\/p\u003e \u003cp\u003eRefreshing the Data 18\u003c\/p\u003e \u003cp\u003eUsing Power Query to Clean the Data 20\u003c\/p\u003e \u003cp\u003eUsing the Queries \u0026amp; Connections Window 21\u003c\/p\u003e \u003cp\u003eAnalyzing the Table 23\u003c\/p\u003e \u003cp\u003eSplitting a Column 24\u003c\/p\u003e \u003cp\u003eMerging Columns 25\u003c\/p\u003e \u003cp\u003eChanging Data Types 26\u003c\/p\u003e \u003cp\u003eRemoving Columns and Rows 26\u003c\/p\u003e \u003cp\u003eUndoing Steps in Power Query 28\u003c\/p\u003e \u003cp\u003eReplacing Values 29\u003c\/p\u003e \u003cp\u003eTrimming Spaces from the Beginning and End of the Data in a Column 30\u003c\/p\u003e \u003cp\u003eCombining Tables Using the Append Query 31\u003c\/p\u003e \u003cp\u003eCombining Tables Using the Merge Query 32\u003c\/p\u003e \u003cp\u003eCreating Subtotals in Your Data Using the GroupBy Query 34\u003c\/p\u003e \u003cp\u003eUsing Power Query to Create Calculations 36\u003c\/p\u003e \u003cp\u003eCalculating Age\/Years of Service 37\u003c\/p\u003e \u003cp\u003eUsing the Built-in Date Functions 38\u003c\/p\u003e \u003cp\u003eUsing the Built-In Time Functions 39\u003c\/p\u003e \u003cp\u003eUsing a Custom Column for Other Calculations 40\u003c\/p\u003e \u003cp\u003eCalculating a Line Total 40\u003c\/p\u003e \u003cp\u003eCalculating the Days to Ship 41\u003c\/p\u003e \u003cp\u003eCalculating the New Total 41\u003c\/p\u003e \u003cp\u003eChanging or Viewing an Existing Custom Column 43\u003c\/p\u003e \u003cp\u003eUsing a Conditional Column for Calculations 44\u003c\/p\u003e \u003cp\u003eCalculating a Reorder 44\u003c\/p\u003e \u003cp\u003eChanging or Viewing an Existing Conditional Column 45\u003c\/p\u003e \u003cp\u003eSummary 46\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 2 Summarizing and Presenting Data with a Pivot Table 47\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eWhat Is a Pivot Table? 47\u003c\/p\u003e \u003cp\u003eMaking a Pivot Table from Scratch 48\u003c\/p\u003e \u003cp\u003eThe PivotTable Fields Window 50\u003c\/p\u003e \u003cp\u003eSummarizing Data on One Field 53\u003c\/p\u003e \u003cp\u003eThe Default Calculation in the Values Section 55\u003c\/p\u003e \u003cp\u003eShowing the Detail with a Drill Down 55\u003c\/p\u003e \u003cp\u003eCreating a Cross Tab or Cross Reference 56\u003c\/p\u003e \u003cp\u003eAdding More Layers of Detail to the Pivot Table 57\u003c\/p\u003e \u003cp\u003eCreating and Managing Groups 57\u003c\/p\u003e \u003cp\u003eChanging the Grouping Order 58\u003c\/p\u003e \u003cp\u003eAdding Groupings to Columns 58\u003c\/p\u003e \u003cp\u003eCreating Your Own Group 58\u003c\/p\u003e \u003cp\u003eRemoving Your Own Group 59\u003c\/p\u003e \u003cp\u003eUsing Recommended PivotTables and Analyzing Data 60\u003c\/p\u003e \u003cp\u003eCreating a Pivot Table Using Recommended PivotTables 60\u003c\/p\u003e \u003cp\u003eCreating a Pivot Table Using Analyze Data 61\u003c\/p\u003e \u003cp\u003eMaking the Pivot Table Look Better 62\u003c\/p\u003e \u003cp\u003eFormatting Numbers 63\u003c\/p\u003e \u003cp\u003eManaging Subtotals 63\u003c\/p\u003e \u003cp\u003eCalculating Grand Totals 64\u003c\/p\u003e \u003cp\u003eWorking with Blank Rows 65\u003c\/p\u003e \u003cp\u003eChanging the Layout 65\u003c\/p\u003e \u003cp\u003eApplying Styles 67\u003c\/p\u003e \u003cp\u003eReplacing Spaces and Other Options 68\u003c\/p\u003e \u003cp\u003eUsing Conditional Formatting 71\u003c\/p\u003e \u003cp\u003eSummary 72\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 3 Using Calculations in Pivot Tables 73\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eUsing Built-In Calculations in Your Pivot Table 73\u003c\/p\u003e \u003cp\u003eAdding Calculation Fields to the Pivot Table 74\u003c\/p\u003e \u003cp\u003eChanging the Calculation Type of a Field 75\u003c\/p\u003e \u003cp\u003eChanging the Order of the Calculations 78\u003c\/p\u003e \u003cp\u003eThe Calculations in the Summarize Values By Tab 78\u003c\/p\u003e \u003cp\u003eThe Calculations in the Show Values As Tab 79\u003c\/p\u003e \u003cp\u003eRemoving Calculations from the Pivot Table 86\u003c\/p\u003e \u003cp\u003eDelaying Calculations in a Pivot Table 86\u003c\/p\u003e \u003cp\u003eChanging the Way Errors Display in the Pivot Table 87\u003c\/p\u003e \u003cp\u003eCreating Custom Calculations 89\u003c\/p\u003e \u003cp\u003eCalculated Fields 89\u003c\/p\u003e \u003cp\u003eTo Change or Delete a Calculated Field 92\u003c\/p\u003e \u003cp\u003eCalculated Items 93\u003c\/p\u003e \u003cp\u003eTo Change or Delete a Calculated Item 95\u003c\/p\u003e \u003cp\u003eThe Solve Order 96\u003c\/p\u003e \u003cp\u003eDocumenting Your Calculated Items and Fields 98\u003c\/p\u003e \u003cp\u003eLimitations of Calculated Fields and Items 99\u003c\/p\u003e \u003cp\u003eRefreshing Values on the Pivot Table 100\u003c\/p\u003e \u003cp\u003eManual Refresh 101\u003c\/p\u003e \u003cp\u003eAutomatic Refresh 102\u003c\/p\u003e \u003cp\u003eChanging the Data Source 103\u003c\/p\u003e \u003cp\u003eUsing Numbers from the Pivot Table in Other Calculations 105\u003c\/p\u003e \u003cp\u003eEnabling the GETPIVOTDATA Function 105\u003c\/p\u003e \u003cp\u003eUsing the GETPIVOTDATA Function 106\u003c\/p\u003e \u003cp\u003eSummary 107\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 4 Sorting and Filtering the Pivot Table 109\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eSorting the Pivot Table 110\u003c\/p\u003e \u003cp\u003eSorting by a Column 110\u003c\/p\u003e \u003cp\u003eSorting by a Row 112\u003c\/p\u003e \u003cp\u003ePutting the Pivot Table in Ascending Order 113\u003c\/p\u003e \u003cp\u003eCreating Your Own Sort Order 113\u003c\/p\u003e \u003cp\u003eCreating Your Own Sort Order by Dragging Cells 113\u003c\/p\u003e \u003cp\u003eCreating Your Own Sort Order by Using a Custom List 114\u003c\/p\u003e \u003cp\u003eSorting a Pivot Table with Multiple Fields 119\u003c\/p\u003e \u003cp\u003eFiltering the Pivot Table 121\u003c\/p\u003e \u003cp\u003eFilter by Selection 122\u003c\/p\u003e \u003cp\u003eClearing the Filter 123\u003c\/p\u003e \u003cp\u003eUsing AutoFilters 123\u003c\/p\u003e \u003cp\u003eLabel Filters 125\u003c\/p\u003e \u003cp\u003eValue Filters 127\u003c\/p\u003e \u003cp\u003eTop 10 Filters 129\u003c\/p\u003e \u003cp\u003eDate Filters 131\u003c\/p\u003e \u003cp\u003eShowing Items with No Data 132\u003c\/p\u003e \u003cp\u003eUsing the Filters Section 134\u003c\/p\u003e \u003cp\u003eCreating New Sheets from the Field in the Filters Section 136\u003c\/p\u003e \u003cp\u003eUsing Slicers and Timelines 137\u003c\/p\u003e \u003cp\u003eCreating a Timeline 140\u003c\/p\u003e \u003cp\u003eUpdating Multiple Pivot Tables Using Slicers and Timelines 142\u003c\/p\u003e \u003cp\u003eRemoving a Slicer or a Timeline Window 143\u003c\/p\u003e \u003cp\u003eSummary 143\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 5 Making the Pivot Table More Visual with Charts 145\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eCreating a Chart from a Pivot Table 146\u003c\/p\u003e \u003cp\u003ePivotChart Features 148\u003c\/p\u003e \u003cp\u003eThe Design Tab and the Format Tab for a Chart 151\u003c\/p\u003e \u003cp\u003eManaging and Modifying Chart Elements 153\u003c\/p\u003e \u003cp\u003eThe Chart Title 154\u003c\/p\u003e \u003cp\u003eData Labels 156\u003c\/p\u003e \u003cp\u003eChanging the Number Format of the Data Labels 156\u003c\/p\u003e \u003cp\u003eChanging the Data Labels to Display Vertically 158\u003c\/p\u003e \u003cp\u003eTrendlines 161\u003c\/p\u003e \u003cp\u003eAdding a Trendline to a Chart 161\u003c\/p\u003e \u003cp\u003eCreating a Forecast from a Trendline 162\u003c\/p\u003e \u003cp\u003eFormatting the Numbers of the Y-Axis or X-Axis 164\u003c\/p\u003e \u003cp\u003eCreating and Managing a Pie Chart 166\u003c\/p\u003e \u003cp\u003eChanging the Data Labels on the Pie Chart to Percents 166\u003c\/p\u003e \u003cp\u003eSeparating a Section from a Pie Chart 168\u003c\/p\u003e \u003cp\u003eChanging the Pie Chart to a Doughnut Chart 168\u003c\/p\u003e \u003cp\u003eCreating a Combo Chart 169\u003c\/p\u003e \u003cp\u003eCreating and Using Chart Templates 171\u003c\/p\u003e \u003cp\u003eSummary 174\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 6 Summarizing Data by Date and Time 175\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eSummarizing a Pivot Table by the Built-in Date Periods 176\u003c\/p\u003e \u003cp\u003eSummarizing a Pivot Table by a Single Period of Time 176\u003c\/p\u003e \u003cp\u003eSummarizing a Pivot Table by More Than One Time Period 180\u003c\/p\u003e \u003cp\u003eShowing\/Hiding the Totals for Each Time Period 180\u003c\/p\u003e \u003cp\u003eExpanding\/Collapsing Time Periods in the Pivot Table 181\u003c\/p\u003e \u003cp\u003eUsing Slicers to Filter the Pivot Table by Date and Time 181\u003c\/p\u003e \u003cp\u003eDisplaying Earliest and Most Recent Dates 184\u003c\/p\u003e \u003cp\u003eSummarizing the Pivot Table by Number of Days 186\u003c\/p\u003e \u003cp\u003eSummarizing the Pivot Table Using Custom Date Calculations 188\u003c\/p\u003e \u003cp\u003eSummarizing the Pivot Table by Week 189\u003c\/p\u003e \u003cp\u003eUsing the Day of the Week in a Pivot Table 191\u003c\/p\u003e \u003cp\u003eUsing a Fiscal Period in a Pivot Table 194\u003c\/p\u003e \u003cp\u003eSummary 197\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 7 Creating a Pivot Table from Multiple Spreadsheets 199\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eCreating a Pivot Table from Multiple Ranges Using the PivotTable Wizard 200\u003c\/p\u003e \u003cp\u003eCreating a Pivot Table Using the Data Model 205\u003c\/p\u003e \u003cp\u003eAdding, Changing, or Deleting Relationships 210\u003c\/p\u003e \u003cp\u003eAdding Additional Tables into the Data Model 211\u003c\/p\u003e \u003cp\u003eCreating and Managing Sets 213\u003c\/p\u003e \u003cp\u003eChanging or Deleting a Set 216\u003c\/p\u003e \u003cp\u003eSummary 217\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 8 Improving a Pivot Table with Power Pivot 219\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eActivating the Power Pivot Add-In 220\u003c\/p\u003e \u003cp\u003eUsing the Power Pivot Add-In 222\u003c\/p\u003e \u003cp\u003eAdding Tables to the Data Model 223\u003c\/p\u003e \u003cp\u003eAdding Formatted Excel Tables into the Data Model 224\u003c\/p\u003e \u003cp\u003eAdding Tables from Other Sources into the Data Model 224\u003c\/p\u003e \u003cp\u003eJoining Tables 227\u003c\/p\u003e \u003cp\u003eChanging, Deleting, and Managing the Relationships 229\u003c\/p\u003e \u003cp\u003eCreating a Pivot Table from the Power Pivot for Excel Window 230\u003c\/p\u003e \u003cp\u003eAdding Calculations to a Pivot Table Using the Data Model 232\u003c\/p\u003e \u003cp\u003eAdding a Calculated Column to a Table in the Data Model 232\u003c\/p\u003e \u003cp\u003eAdding a Measure into the Data Model 234\u003c\/p\u003e \u003cp\u003eCreating a KPI 236\u003c\/p\u003e \u003cp\u003eSummary 239\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 9 Pulling It All Together: Creating a Dashboard from Pivot Tables 241\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eLooking at a Finished Dashboard 242\u003c\/p\u003e \u003cp\u003eCreating Your Own Dashboard 243\u003c\/p\u003e \u003cp\u003eAdding Charts to Your Dashboard 244\u003c\/p\u003e \u003cp\u003eAdding Slicers and Timelines to Your Dashboard 245\u003c\/p\u003e \u003cp\u003eDisplaying Totals and Percent of Totals 247\u003c\/p\u003e \u003cp\u003eWorking with Form Controls, Macros, and VBA Code 248\u003c\/p\u003e \u003cp\u003eThe Developer Tab 249\u003c\/p\u003e \u003cp\u003eAdding Command Buttons 250\u003c\/p\u003e \u003cp\u003eSaving a Workbook with a Macro 253\u003c\/p\u003e \u003cp\u003eAdding a Combo Box 255\u003c\/p\u003e \u003cp\u003eAdding Finishing Touches to Your Dashboard 260\u003c\/p\u003e \u003cp\u003eHiding Sheets 261\u003c\/p\u003e \u003cp\u003eHiding the Pivot Table, Gridlines, Column Headings, and the Formula 262\u003c\/p\u003e \u003cp\u003eSummary 264\u003c\/p\u003e \u003cp\u003eIndex 265\u003c\/p\u003e\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\u003cp\u003e\u003cfont size=\"3\"\u003eSubject Areas: Business applications [\u003ca title=\"See our other books on Business applications\" href=\"https:\/\/freshlyprintedbooks.co.uk\/search?q=%22Business%20applications%20%5BUF%5D%22\"\u003eUF\u003c\/a\u003e]\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\r\n\u003c\/font\u003e","brand":"Wiley","offers":[{"title":"Brand New","offer_id":52173816758552,"sku":"9781394243051","price":24.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0730\/2037\/5320\/files\/9781394243051.jpg?v=1781173314","url":"https:\/\/freshlyprintedbooks.co.uk\/products\/getting-great-results-with-excel-pivot-tables-powerquery-and-powerpivot-paperback-softback-9781394243051","provider":"Freshly Printed Books","version":"1.0","type":"link"}