{"title":"Spreadsheet software Books","description":"","products":[{"product_id":"microsoft-excel-inside-out-office-2021-and-microsoft-365-9780137559534","title":"Microsoft Excel Inside Out Office 2021 and","description":"\u003cb\u003eBook Synopsis\u003c\/b\u003e\u003cbr\u003e\u003cbr\u003e\u003cbr\u003e\u003cb\u003eTable of Contents\u003c\/b\u003e\u003cbr\u003e\u003cp\u003ePart I The Excel interface \u003c\/p\u003e \u003cp\u003eChapter 1 What's new in Microsoft 365 Excel \u003c\/p\u003e \u003cp\u003eChapter 2 Using the Excel interface \u003c\/p\u003e \u003cp\u003eChapter 3 Customizing Excel \u003c\/p\u003e \u003cp\u003eChapter 4 Keyboard shortcuts \u003c\/p\u003e \u003cp\u003e \u003c\/p\u003e \u003cp\u003ePart II Calculating with Excel \u003c\/p\u003e \u003cp\u003eChapter 5 Understanding formulas \u003c\/p\u003e \u003cp\u003eChapter 6 Controlling formulas \u003c\/p\u003e \u003cp\u003eChapter 7 Understanding functions \u003c\/p\u003e \u003cp\u003eChapter 8 Using everyday functions: math, date and time, and text functions \u003c\/p\u003e \u003cp\u003eChapter 9 Using powerful functions: logical, lookup, and database functions \u003c\/p\u003e \u003cp\u003eChapter 10 Using names, LET, LAMBDA, and Data Types in Excel \u003c\/p\u003e \u003cp\u003eChapter 11 Connecting worksheets and workbooks \u003c\/p\u003e \u003cp\u003eChapter 12 Dynamic array formulas and names in Excel \u003c\/p\u003e \u003cp\u003e\u003cbr\u003e\u003c\/p\u003e \u003cp\u003ePart III Data analysis with Excel \u003c\/p\u003e \u003cp\u003eChapter 13 Transforming data with Power Query \u003c\/p\u003e \u003cp\u003eChapter 14 Summarizing data using subtotals or filter \u003c\/p\u003e \u003cp\u003eChapter 15 Using pivot tables to analyze data \u003c\/p\u003e \u003cp\u003eChapter 16 Using slicers and filtering a pivot table \u003c\/p\u003e \u003cp\u003eChapter 17 Mashing up data with Power Pivot \u003c\/p\u003e \u003cp\u003eChapter 18 Using What-If, Scenario Manager, Goal Seek, and Solver \u003c\/p\u003e \u003cp\u003eChapter 19 Automating repetitive functions using VBA macros \u003c\/p\u003e \u003cp\u003eChapter 20 More tips and tricks for Excel \u003c\/p\u003e \u003cp\u003e \u003c\/p\u003e \u003cp\u003ePart IV Excel visuals \u003c\/p\u003e \u003cp\u003eChapter 21 Formatting worksheets \u003c\/p\u003e \u003cp\u003eChapter 22 Using data visualizations and conditional formatting \u003c\/p\u003e \u003cp\u003eChapter 23 Graphing data using Excel charts \u003c\/p\u003e \u003cp\u003eChapter 24 Using 3D Maps \u003c\/p\u003e \u003cp\u003eChapter 25 Using sparklines \u003c\/p\u003e \u003cp\u003eChapter 26 Formatting spreadsheets for presentation \u003c\/p\u003e \u003cp\u003eChapter 27 Printing \u003c\/p\u003e \u003cp\u003eChapter 28 Collaborating in Excel \u003c\/p\u003e \u003cp\u003e \u003c\/p\u003e \u003cp\u003ePart V Appendixes \u003c\/p\u003e \u003cp\u003eAppendix A Excel functions \u003c\/p\u003e \u003cp\u003eAppendix B Excel functions with DAX or Power Query equivalents \u003c\/p\u003e \u003cp\u003eAppendix C Adding functionality to Excel with add-ins \u003c\/p\u003e \u003cp\u003eIndex \u003c\/p\u003e","brand":"Pearson Education (US)","offers":[{"title":"Default Title","offer_id":48732341895511,"sku":"9780137559534","price":34.84,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0817\/1739\/5799\/files\/9780137559534.jpg?v=1719996488"},{"product_id":"microsoft-excel-step-by-step-office-2021-and-microsoft-365-9780137564279","title":"Microsoft Excel Step by Step Office 2021 and","description":"\u003cb\u003eBook Synopsis\u003c\/b\u003e\u003cbr\u003e\u003cp class=\"MsoNormal\" style=\"margin:\" calibri sans-serif font-size:=\"\" font-family:=\"\"\u003e\u003cb\u003eJoan Lambert\u003c\/b\u003e has worked closely with Microsoft technologies since 1986, and in the training and certification industry since 1997, guiding the translation of technical information and requirements into useful, relevant, and measurable resources for people seeking certification of their computer skills or who simply want to get things done efficiently. She has written more than 50 books about Windows, Office, and SharePoint technologies, including dozens of Step by Step books and five generations of Microsoft Office Specialist certification study guides. Students who use the GO! with Microsoft Office textbook products may overhear her cheerfully demonstrating Office features in the videos that accompany the series. \u003co:p\u003e\u003c\/o:p\u003e\u003c\/p\u003e \u003cp class=\"MsoNormal\" style=\"margin:\" calibri sans-serif font-size:=\"\" font-family:=\"\"\u003e\u003cbr\u003e\u003c\/p\u003e \u003cp class=\"MsoNormal\" style=\"margin:\" font-famil font-size:=\"\"\u003e\u003cbr\u003e\u003cb\u003eTable of Contents\u003c\/b\u003e\u003cbr\u003e\u003c\/p\u003e\u003cp\u003eIntroduction \u003c\/p\u003e \u003cp\u003ePart 1: Create and format workbooks \u003c\/p\u003e \u003cp\u003e1 Set up a workbook \u003c\/p\u003e \u003cp\u003e2 Work with data and Excel tables \u003c\/p\u003e \u003cp\u003e3 Perform calculations on data \u003c\/p\u003e \u003cp\u003e4 Change workbook appearance \u003c\/p\u003e \u003cp\u003e \u003c\/p\u003e \u003cp\u003ePart 2: Analyze and present data \u003c\/p\u003e \u003cp\u003e5 Manage worksheet data \u003c\/p\u003e \u003cp\u003e6 Reorder and summarize data \u003c\/p\u003e \u003cp\u003e7 Combine data from multiple sources \u003c\/p\u003e \u003cp\u003e8 Analyze alternative data sets \u003c\/p\u003e \u003cp\u003e9 Create charts and graphics. 207 \u003c\/p\u003e \u003cp\u003e10 Create PivotTables and PivotCharts \u003c\/p\u003e \u003cp\u003e \u003c\/p\u003e \u003cp\u003ePart 3: Collaborate and share in Excel \u003c\/p\u003e \u003cp\u003e11 Print worksheets and charts \u003c\/p\u003e \u003cp\u003e12 Automate tasks and input \u003c\/p\u003e \u003cp\u003e13 Work with other Microsoft 365 apps \u003c\/p\u003e \u003cp\u003e14 Collaborate with colleagues \u003c\/p\u003e \u003cp\u003e \u003c\/p\u003e \u003cp\u003ePart 4: Perform advanced analysis \u003c\/p\u003e \u003cp\u003e15 Perform business intelligence analysis \u003c\/p\u003e \u003cp\u003e16 Create forecasts and visualizations \u003c\/p\u003e","brand":"Pearson Education (US)","offers":[{"title":"Default Title","offer_id":48732341928279,"sku":"9780137564279","price":28.04,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0817\/1739\/5799\/files\/9780137564279.jpg?v=1719996487"},{"product_id":"microsoft-excel-2019-step-by-step-9781509307678","title":"Microsoft Excel 2019 Step by Step","description":"\u003cb\u003eBook Synopsis\u003c\/b\u003e\u003cbr\u003e\u003cp\u003e\u003cb\u003eThe quick way to learn Microsoft Excel 2019!\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eThis is learning made easy. Get more done quickly with Microsoft Excel 2019. Jump in wherever you need answers–brisk lessons and detailed screenshots show you exactly what to do, step by step.\u003c\/p\u003e \u003cp\u003e\u003c\/p\u003e \u003cul\u003e\n\u003cli\u003eQuickly set up workbooks, enter data, and format it for easier viewing\u003c\/li\u003e\n\u003cli\u003ePerform calculations and find and correct errors\u003c\/li\u003e\n\u003cli\u003eCreate sophisticated forecast worksheets, key performance indicators (KPIs), and timelines\u003c\/li\u003e\n\u003cli\u003eVisualize data with 3D maps, funnel charts, and other powerful tools \u003c\/li\u003e\n\u003cli\u003eImport, process, summarize, and analyze huge datasets with Excel’s improved PowerPivot and Power Query\u003c\/li\u003e\n\u003cli\u003eBuild powerful data models and use them in business intelligence \u003c\/li\u003e\n\u003cli\u003eLook up just the tasks and lessons you need\u003c\/li\u003e\n\u003c\/ul\u003e \u003cp\u003e\u003c\/p\u003e \u003cp\u003e\u003c\/p\u003e \u003cp\u003e\u003c\/p\u003e \u003cp\u003e\u003c\/p\u003e \u003cp\u003e\u003c\/p\u003e \u003cp\u003e\u003c\/p\u003e \u003cp\u003e\u003c\/p\u003e\u003cbr\u003e\u003cbr\u003e\u003cb\u003eTable of Contents\u003c\/b\u003e\u003cbr\u003e\u003cul\u003e\n\u003cli\u003e Part 1: Create and format workbooks \u003c\/li\u003e\n\u003cli\u003e Chapter 1: Set up a workbook \u003c\/li\u003e\n\u003cli\u003e Chapter 2: Work with data and Excel tables \u003c\/li\u003e\n\u003cli\u003e Chapter 3: Perform calculations on data \u003c\/li\u003e\n\u003cli\u003e Chapter 4: Change workbook appearance \u003c\/li\u003e\n\u003cli\u003e Part 2: Analyze and present data \u003c\/li\u003e\n\u003cli\u003e Chapter 5: Manage worksheet data \u003c\/li\u003e\n\u003cli\u003e Chapter 6: Reorder and summarize data \u003c\/li\u003e\n\u003cli\u003e Chapter 7: Combine data from multiple sources \u003c\/li\u003e\n\u003cli\u003e Chapter 8: Analyze alternative data sets \u003c\/li\u003e\n\u003cli\u003e Chapter 9: Create charts and graphics \u003c\/li\u003e\n\u003cli\u003e Chapter 10: Create dynamic worksheets by using PivotTables \u003c\/li\u003e\n\u003cli\u003e Part 3: Collaborate and share in Excel \u003c\/li\u003e\n\u003cli\u003e Chapter 11: Print worksheets and charts \u003c\/li\u003e\n\u003cli\u003e Chapter 12: Automate repetitive tasks by using macros \u003c\/li\u003e\n\u003cli\u003e Chapter 13: Work with other Microsoft Office apps \u003c\/li\u003e\n\u003cli\u003e Chapter 14: Collaborate with colleagues \u003c\/li\u003e\n\u003cli\u003e Part 4: Perform advanced analysis \u003c\/li\u003e\n\u003cli\u003e Chapter 15: Perform business intelligence analysis \u003c\/li\u003e\n\u003cli\u003e Chapter 16: Create forecasts and visualizations \u003c\/li\u003e\n\u003c\/ul\u003e","brand":"Microsoft Press,U.S.","offers":[{"title":"Default Title","offer_id":48739834462551,"sku":"9781509307678","price":25.49,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0817\/1739\/5799\/files\/9781509307678.jpg?v=1720053256"},{"product_id":"microsoft-excel-2019-pivot-table-data-crunching-9781509307241","title":"Microsoft Excel 2019 Pivot Table Data Crunching","description":"\u003cb\u003eBook Synopsis\u003c\/b\u003e\u003cbr\u003e\u003cp\u003eRenowned Excel experts Bill Jelen (MrExcel) and Michael Alexander help you crunch data from any source with Excel 2019 pivot tables. \u003c\/p\u003e \u003cp\u003e \u003c\/p\u003e \u003cp\u003eUse Excel 2019 pivot tables and pivot charts to produce powerful, dynamic reports in minutes instead of hours, to take control of your data and your business. Even if you’ve never created a pivot table before, this book will help you leverage all their remarkable flexibility and analytical power–including valuable improvements in Excel 2019 and Excel in Office 365. Drawing on more than 45 combined years of Excel experience, Bill Jelen and Michael Alexander offer practical “recipes” for solving real business problems, help you avoid common mistakes, and present tips and tricks you’ll find nowhere else. \u003c\/p\u003e \u003cp\u003e\u003cbr\u003e\u003c\/p\u003e \u003cp\u003eBy reading this book, you will: \u003c\/p\u003e \u003cp\u003e• Master easy, powerful ways to create, customize, change, and control pivot tables \u003c\/p\u003e \u003cp\u003e• Control all future pivot tables using new pivot table defaults \u003c\/p\u003e \u003cp\u003e• Transform huge data sets into clear summary reports \u003c\/p\u003e \u003cp\u003e• Instantly highlight your most profitable customers, products, or regions \u003c\/p\u003e \u003cp\u003e• Use Power Query to quickly import, clean, shape, and analyze disparate data sources \u003c\/p\u003e \u003cp\u003e• Build geographical pivot tables with 3D Map \u003c\/p\u003e \u003cp\u003e• Construct and share state-of-the-art dynamic dashboards \u003c\/p\u003e \u003cp\u003e• Revamp analyses on the fly by dragging and dropping fields \u003c\/p\u003e \u003cp\u003e• Build dynamic self-service reporting systems \u003c\/p\u003e \u003cp\u003e• Share your pivot tables with colleagues \u003c\/p\u003e \u003cp\u003e• Create data mashups using the full Power Pivot capabilities of Excel 2019 and Excel in Office 365 \u003c\/p\u003e \u003cp\u003e• Automate pivot tables with macros and VBA \u003c\/p\u003e \u003cp\u003e• Save time by adapting reports with GetPivotData \u003c\/p\u003e \u003cp\u003e• Discover today’s most useful pivot table tips and shortcuts \u003c\/p\u003e \u003cp\u003e \u003c\/p\u003e\u003cbr\u003e\u003cbr\u003e\u003cb\u003eTable of Contents\u003c\/b\u003e\u003cbr\u003eIntroduction \u003col\u003e\n\u003cli\u003ePivot Table Fundamentals\u003c\/li\u003e\n\u003cli\u003eCreating a Basic Pivot Table\u003c\/li\u003e\n\u003cli\u003eCustomizing a Pivot Table\u003c\/li\u003e\n\u003cli\u003eGrouping, Sorting, and Filtering Pivot Data\u003c\/li\u003e\n\u003cli\u003ePerforming Calculations in Pivot Tables\u003c\/li\u003e\n\u003cli\u003eUsing Pivot Charts and Other Visualizations\u003c\/li\u003e\n\u003cli\u003eAnalyzing Disparate Data Sources with Pivot Tables\u003c\/li\u003e\n\u003cli\u003eSharing Dashboards with Power BI\u003c\/li\u003e\n\u003cli\u003eUsing Cube Formulas with the Data Model or OLAP Data\u003c\/li\u003e\n\u003cli\u003eUnlocking Features with the Data Model and Power Pivot\u003c\/li\u003e\n\u003cli\u003eAnalyzing Geographic Data with 3D Map\u003c\/li\u003e\n\u003cli\u003eEnhancing Pivot Table reports with Macros\u003c\/li\u003e\n\u003cli\u003eUsing VBA to Create Pivot Tables\u003c\/li\u003e\n\u003cli\u003eAdvanced Pivot Table Tips and Techniques\u003c\/li\u003e\n\u003cli\u003eDr. Jekyll and Mr. GetPivotData\u003c\/li\u003e\n\u003c\/ol\u003e","brand":"Microsoft Press,U.S.","offers":[{"title":"Default Title","offer_id":48739834954071,"sku":"9781509307241","price":25.49,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0817\/1739\/5799\/files\/9781509307241.jpg?v=1720053257"},{"product_id":"even-you-can-learn-statistics-and-analytics-9780137654765","title":"Even You Can Learn Statistics and Analytics","description":"\u003cb\u003eBook Synopsis\u003c\/b\u003e\u003cbr\u003e\u003cp\u003e\u003cb\u003eDavid M. Levine\u003c\/b\u003e and \u003cb\u003eDavid F. Stephan\u003c\/b\u003e are part of a writing team known for their series of business statistics textbooks that include \u003ci\u003eBasic Business Statistics, Business Statistics: A First Course, and Statistics for Managers Using Microsoft Excel\u003c\/i\u003e. In long teaching careers at Baruch College, both were known for their classroom innovations, with Levine being honored with a Presidential Excellence Award for Distinguished Teaching Award and Stephan granted the privilege to design and develop the College's first computer-based classroom. Both are active members of the Data, Analytics and Statistics Instruction SIG of the Decision Sciences Institute.\u003c\/p\u003e \u003cp\u003e\u003cbr\u003e\u003c\/p\u003e \u003cp\u003e\u003cbr\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eLevine\u003c\/b\u003e is Professor Emeritus of Information Systems at Baruch College. He is nationally recognized innovator in business statistics education and is also the coauthor of \u003ci\u003eApplied Statistics for Engineers and Scientists Using Microsoft Excel and Minitab\u003c\/i\u003e. Levine is also the author\u003cbr\u003e\u003cbr\u003e\u003cb\u003eTable of Contents\u003c\/b\u003e\u003cbr\u003eIntroduction The Even You Can Learn Statistics and Analytics Owner's Manual. xiii \u003cbr\u003e Chapter 1 Fundamentals of Statistics. 1 \u003cbr\u003e 1.1 The First Three Words of Statistics. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 \u003cbr\u003e 1.2 The Fourth and Fifth Words. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4 \u003cbr\u003e 1.3 The Branches of Statistics. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4 \u003cbr\u003e 1.4 Sources of Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 \u003cbr\u003e 1.5 Sampling Concepts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7 \u003cbr\u003e 1.6 Sample Selection Methods. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8 \u003cbr\u003e Chapter 2 Presenting Data in Tables and Charts . 15 \u003cbr\u003e 2.1 Presenting Categorical Variables. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15 \u003cbr\u003e 2.2 Presenting Numerical Variables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23 \u003cbr\u003e 2.3 “Bad” Charts. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 29 \u003cbr\u003e Chapter 3 Descriptive Statistics. 45 \u003cbr\u003e 3.1 Measures of Central Tendency. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 45 \u003cbr\u003e 3.2 Measures of Position. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 49 \u003cbr\u003e 3.3 Measures of Variation. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 54 \u003cbr\u003e 3.4 Shape of Distributions. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 59 \u003cbr\u003e Chapter 4 Probability. 75 \u003cbr\u003e 4.1 Events. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 75 \u003cbr\u003e 4.2 More Definitions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 76 \u003cbr\u003e 4.3 Some Rules of Probability. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 78 \u003cbr\u003e 4.4 Assigning Probabilities. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 81 \u003cbr\u003e Chapter 5 Probability Distributions. 87 \u003cbr\u003e 5.1 Probability Distributions for Discrete Variables. . . . . . . . . . . . . . . . . . . . . . . . 87 \u003cbr\u003e 5.2 The Binomial and Poisson Probability Distributions. . . . . . . . . . . . . . . . . . . . 93 \u003cbr\u003e 5.3 Continuous Probability Distributions and the Normal Distribution . . . . . . . 100 \u003cbr\u003e 5.4 The Normal Probability Plot. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 108 \u003cbr\u003e Chapter 6 Sampling Distributions and Confidence Intervals. 121 \u003cbr\u003e 6.1 Foundational Concepts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 122 \u003cbr\u003e 6.2 Sampling Error and Confidence Intervals. . . . . . . . . . . . . . . . . . . . . . . . . . . 125 \u003cbr\u003e 6.3 Confidence Interval Estimate for the Mean Using the t Distribution (? Unknown). . . 128 \u003cbr\u003e 6.4 Confidence Interval Estimation for Categorical Variables . . . . . . . . . . . . . . . 131 \u003cbr\u003e 6.5 Confidence Interval Estimation When Normality Cannot Be Assumed. . . . . 134 \u003cbr\u003e Chapter 7 Fundamentals of Hypothesis Testing. 145 \u003cbr\u003e 7.1 The Null and Alternative Hypotheses. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 145 \u003cbr\u003e 7.2 Hypothesis Testing Issues. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 147 \u003cbr\u003e 7.3 Decision-Making Risks. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 149 \u003cbr\u003e 7.4 Performing Hypothesis Testing. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 150 \u003cbr\u003e 7.5 Types of Hypothesis Tests. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 152 \u003cbr\u003e Chapter 8 Hypothesis Testing: Z and t Tests. 157 \u003cbr\u003e 8.1 Test for the Difference Between Two Proportions . . . . . . . . . . . . . . . . . . . . . 157 \u003cbr\u003e 8.2 Test for the Difference Between the Means of Two Independent Groups . . . . 163 \u003cbr\u003e 8.3 The Paired t Test. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 168 \u003cbr\u003e Chapter 9 Hypothesis Testing: Chi-Square Tests and the One-Way Analysis of Variance (ANOVA). 183 \u003cbr\u003e 9.1 Chi-Square Test for Two-Way Tables. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 183 \u003cbr\u003e 9.2 One-Way Analysis of Variance (ANOVA): Testing for the \u003cbr\u003e Differences Among the Means of More Than Two Groups. . . . . . . . . . . . . . . 191 \u003cbr\u003e Chapter 10 Simple Linear Regression. 211 \u003cbr\u003e 10.1 Basics of Regression Analysis . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 211 \u003cbr\u003e 10.2 Developing a Simple Linear Regression Model. . . . . . . . . . . . . . . . . . . . . . 214 \u003cbr\u003e 10.3 Measures of Variation. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 221 \u003cbr\u003e 10.4 Inferences About the Slope. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 226 \u003cbr\u003e 10.5 Common Mistakes When Using Regression Analysis . . . . . . . . . . . . . . . . . 229 \u003cbr\u003e Chapter 11 Multiple Regression. 243 \u003cbr\u003e 11.1 The Multiple Regression Model . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 243 \u003cbr\u003e 11.2 Coefficient of Multiple Determination . . . . . . . . . . . . . . . . . . . . . . . . . . . . 246 \u003cbr\u003e 11.3 The Overall F Test . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 246 \u003cbr\u003e 11.4 Residual Analysis for the Multiple Regression Model . . . . . . . . . . . . . . . . . 247 \u003cbr\u003e 11.5 Inferences Concerning the Population Regression Coefficients. . . . . . . . . . 248 \u003cbr\u003e Chapter 12 Introduction to Analytics. 259 \u003cbr\u003e 12.1 Basic Concepts. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 259 \u003cbr\u003e 12.2 Descriptive Analytics. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 265 \u003cbr\u003e 12.3 Typical Descriptive Analytics Visualizations. . . . . . . . . . . . . . . . . . . . . . . . 269 \u003cbr\u003e Chapter 13 Predictive Analytics. 279 \u003cbr\u003e 13.1 Predictive Analytics Methods. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 279 \u003cbr\u003e 13.2 More About Predictive Models. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 281 \u003cbr\u003e 13.3 Tree Induction. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 284 \u003cbr\u003e 13.4 Clustering . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 287 \u003cbr\u003e 13.5 Association Analysis. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 290 \u003cbr\u003e Appendix A Microsoft Excel Operation and Configuration . 299 \u003cbr\u003e Appendix B Review of Arithmetic and Algebra. 301 \u003cbr\u003e Appendix C Statistical Tables. 311 \u003cbr\u003e Appendix D Spreadsheet Tips . 339 \u003cbr\u003e Appendix E Advanced Techniques. 343 \u003cbr\u003e Appendix F Documentation for Downloadable Files. 353 \u003cbr\u003e \u003cbr\u003e \u003cbr\u003e 9780137654765, TOC, 4\/25\/2022 \u003cbr\u003e \u003cbr\u003e\u003c\/p\u003e","brand":"Pearson Education (US)","offers":[{"title":"Default Title","offer_id":48864175784279,"sku":"9780137654765","price":23.39,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0817\/1739\/5799\/files\/9780137654765.jpg?v=1722270748"},{"product_id":"modeling-structured-finance-cash-flows-with-microsoftexcel-9780470042908","title":"Modeling Structured Finance Cash Flows with","description":"\u003cb\u003eBook Synopsis\u003c\/b\u003e\u003cbr\u003e\u003cb\u003eA practical guide to building fully operational financial cash flow models for structured finance transactions\u003c\/b\u003e \u003cp\u003eStructured finance and securitization deals are becoming more commonplace on Wall Street. Up until now, however, market participants have had to create their own models to analyze these deals, and new entrants have had to learn as they go. \u003ci\u003eModeling Structured Finance Cash Flows with Microsoft Excel\u003c\/i\u003e provides readers with the information they need to build a cash flow model for structured finance and securitization deals. Financial professional Keith Allman explains individual functions and formulas, while also explaining the theory behind the spreadsheets. Each chapter begins with a discussion of theory, followed by a section called Model Builder, in which Allman translates the theory into functions and formulas. In addition, the companion website features all of the modeling exercises, as well as a final version of the model that is created in the text.\u003c\/p\u003e \u003cp\u003e\u003cbr\u003e\u003cb\u003eTable of Contents\u003c\/b\u003e\u003cbr\u003e\u003c\/p\u003e\u003cp\u003ePreface xi\u003c\/p\u003e \u003cp\u003eAcknowledgments xiii\u003c\/p\u003e \u003cp\u003eAbout the Author xv\u003c\/p\u003e \u003cp\u003e\u003cb\u003eIntroduction 1\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eThe Three Basic Elements of a Cash Flow Model 3\u003c\/p\u003e \u003cp\u003eInputs 3\u003c\/p\u003e \u003cp\u003eCash Flow Structure 4\u003c\/p\u003e \u003cp\u003eOutputs 5\u003c\/p\u003e \u003cp\u003eThe Process of Building a Cash Flow Model 5\u003c\/p\u003e \u003cp\u003ePlan and Design 5\u003c\/p\u003e \u003cp\u003eObtain All Necessary Information 6\u003c\/p\u003e \u003cp\u003eConstruct Basic Framework 6\u003c\/p\u003e \u003cp\u003eDevelop Advanced Structure 6\u003c\/p\u003e \u003cp\u003eValidate Assumptions 6\u003c\/p\u003e \u003cp\u003eTest Model 7\u003c\/p\u003e \u003cp\u003eHow This Book Is Designed 7\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 1 Dates and Timing 9\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eTime Progression 9\u003c\/p\u003e \u003cp\u003eDates and Timing on the Inputs Sheet 10\u003c\/p\u003e \u003cp\u003eDay-Count Systems: 30\/360 versus Actual\/360 versus Actual\/ 365 11\u003c\/p\u003e \u003cp\u003eModel Builder 1.1: Inputs Sheet—Dates and Timing 12\u003c\/p\u003e \u003cp\u003eDates and Timing on the Cash Flow Sheet 14\u003c\/p\u003e \u003cp\u003eModel Builder 1.2: Cash Flow Sheet—Dates and Timing 15\u003c\/p\u003e \u003cp\u003eToolbox 18\u003c\/p\u003e \u003cp\u003eNaming Cells and Ranges 18\u003c\/p\u003e \u003cp\u003eData Validation Lists 19\u003c\/p\u003e \u003cp\u003eEDATE 21\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 2 Asset Cash Flow Generation 23\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eLoan Level versus Representative Line Amortization 23\u003c\/p\u003e \u003cp\u003eHow Asset Generation Is Demonstrated in Model Builder 27\u003c\/p\u003e \u003cp\u003eAsset Generation on the Inputs Sheet 27\u003c\/p\u003e \u003cp\u003eFixed Rate Amortization Inputs 28\u003c\/p\u003e \u003cp\u003eFloating Rate Amortization Inputs 28\u003c\/p\u003e \u003cp\u003eModel Builder 2.1: Inputs Sheet Asset Assumptions and the Vectors Sheet 29\u003c\/p\u003e \u003cp\u003eAsset Generation on the Cash Flow Sheet 33\u003c\/p\u003e \u003cp\u003eModel Builder 2.2: Notional Asset Amortization on the Cash Flow Sheet 33\u003c\/p\u003e \u003cp\u003eTOOLBOX 40\u003c\/p\u003e \u003cp\u003eOFFSET 40\u003c\/p\u003e \u003cp\u003eMATCH 40\u003c\/p\u003e \u003cp\u003eMOD 41\u003c\/p\u003e \u003cp\u003ePMT 41\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 3 Prepayments 43\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eHow Prepayments Are Tracked 43\u003c\/p\u003e \u003cp\u003eSMM: Single Monthly Mortality 44\u003c\/p\u003e \u003cp\u003eCPR: Conditional Prepayment Rate 44\u003c\/p\u003e \u003cp\u003ePSA: Public Securities Association 44\u003c\/p\u003e \u003cp\u003eABS: Absolute Prepayment Speed 45\u003c\/p\u003e \u003cp\u003eHistorical Prepayment Data Formats 46\u003c\/p\u003e \u003cp\u003eBuilding Prepayment Curves 46\u003c\/p\u003e \u003cp\u003ePrepayment Curves in Project Model Builder 47\u003c\/p\u003e \u003cp\u003eThe Effect of Prepayments on Structured Transactions 48\u003c\/p\u003e \u003cp\u003eModel Builder 3.1: Historical Prepayment Analysis and Creating a Projected Prepayment Curve 48\u003c\/p\u003e \u003cp\u003eModel Builder 3.2: Integrating Projected Prepayments in Asset Amortization 53\u003c\/p\u003e \u003cp\u003eToolbox 56\u003c\/p\u003e \u003cp\u003eWeighted Averages Using SUMPRODUCT and SUM 56\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 4 Delinquency, Default, and Loss Analysis 59\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eDelinquencies versus Defaults versus Loss 59\u003c\/p\u003e \u003cp\u003eThe Importance of Analyzing Delinquency 60\u003c\/p\u003e \u003cp\u003eModel Builder 4.1: Building Historical Delinquency Curves 62\u003c\/p\u003e \u003cp\u003eDeriving Historical Loss Curves 64\u003c\/p\u003e \u003cp\u003eModel Builder 4.2: Building Historical and Projected Loss Curves 67\u003c\/p\u003e \u003cp\u003eAnalyzing Historical Loss Curves 69\u003c\/p\u003e \u003cp\u003eModel Builder 4.2 Continued 69\u003c\/p\u003e \u003cp\u003eProjecting Loss Curves 70\u003c\/p\u003e \u003cp\u003eModel Builder 4.2 Continued 71\u003c\/p\u003e \u003cp\u003eIntegrating Loss Projections 73\u003c\/p\u003e \u003cp\u003eThe Effects of Seasoning and Default Timing 75\u003c\/p\u003e \u003cp\u003eModel Builder 4.3: Integrating Defaults in Asset Amortization 76\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 5 Recoveries 83\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eModel Builder 5.1: Historical Recovery Analysis 85\u003c\/p\u003e \u003cp\u003eProjecting Recoveries in a Cash Flow Model 86\u003c\/p\u003e \u003cp\u003eModel Builder 5.2: Integrating Recoveries into Project Model Builder 87\u003c\/p\u003e \u003cp\u003eFinal Points Regarding Recoveries 88\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 6 Liabilities and the Cash Flow Waterfall 89\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003ePriority of Payments and the Cash Flow Waterfall 89\u003c\/p\u003e \u003cp\u003eThe Movement of Cash for an Individual Liability 90\u003c\/p\u003e \u003cp\u003eTypes of Liabilities 91\u003c\/p\u003e \u003cp\u003eFees 91\u003c\/p\u003e \u003cp\u003eModel Builder 6.1: Calculating Fees in the Waterfall 91\u003c\/p\u003e \u003cp\u003eInterest 94\u003c\/p\u003e \u003cp\u003eModel Builder 6.2: Calculating Interest in the Waterfall 95\u003c\/p\u003e \u003cp\u003ePrincipal 100\u003c\/p\u003e \u003cp\u003eModel Builder 6.3: Calculating Principal in the Waterfall 100\u003c\/p\u003e \u003cp\u003eUnderstanding Basic Asset and Liability Interactions 105\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 7 Advanced Liability Structures: Triggers, Interest Rate Swaps, and Reserve Accounts 107\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eTriggers and Their Affect on the Liability Structure 107\u003c\/p\u003e \u003cp\u003eModel Builder 7.1: Incorporating Triggers 108\u003c\/p\u003e \u003cp\u003eSwaps 113\u003c\/p\u003e \u003cp\u003eModel Builder 7.2: Incorporating a Basic Interest Rate Swap 114\u003c\/p\u003e \u003cp\u003eFinal Notes on Swaps 117\u003c\/p\u003e \u003cp\u003eReserve Accounts 117\u003c\/p\u003e \u003cp\u003eModel Builder 7.3: Incorporating a Cash-Funded Reserve Account 118\u003c\/p\u003e \u003cp\u003eConclusion of the Cash Flow Waterfall 122\u003c\/p\u003e \u003cp\u003eToolbox 123\u003c\/p\u003e \u003cp\u003eAND and OR 123\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 8 Analytics and Output Reporting 125\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eInternal Testing 125\u003c\/p\u003e \u003cp\u003eCash In versus Cash Out 125\u003c\/p\u003e \u003cp\u003eModel Builder 8.1: Cash In versus Cash Out Test 126\u003c\/p\u003e \u003cp\u003eBalances at Maturity 128\u003c\/p\u003e \u003cp\u003eModel Builder 8.2: Balances at Maturity Tests 128\u003c\/p\u003e \u003cp\u003eAsset Principal Check 129\u003c\/p\u003e \u003cp\u003eModel Builder 8.3: Asset Principal Check Test 129\u003c\/p\u003e \u003cp\u003ePerformance Analytics 130\u003c\/p\u003e \u003cp\u003eMonthly Yield 130\u003c\/p\u003e \u003cp\u003eModel Builder 8.4: Calculating Monthly Yield 130\u003c\/p\u003e \u003cp\u003eCalculating the Monthly Yield 132\u003c\/p\u003e \u003cp\u003eBond-Equivalent Yield 133\u003c\/p\u003e \u003cp\u003eModel Builder 8.5: Calculating Bond-Equivalent Yield 133\u003c\/p\u003e \u003cp\u003eModified Duration 133\u003c\/p\u003e \u003cp\u003eModel Builder 8.6: Calculating Modified Duration 134\u003c\/p\u003e \u003cp\u003eOutput Reporting 135\u003c\/p\u003e \u003cp\u003eModel Builder 8.7: Creating the Output Report 136\u003c\/p\u003e \u003cp\u003eThe Importance of Testing and Output 140\u003c\/p\u003e \u003cp\u003eToolbox 140\u003c\/p\u003e \u003cp\u003eConditional Formatting 140\u003c\/p\u003e \u003cp\u003eGoal Seek 141\u003c\/p\u003e \u003cp\u003eArray Formulas 142\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 9 Understanding the Model 145\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eThe Complete Model in Review 145\u003c\/p\u003e \u003cp\u003eUnderstanding the Effects of Increased Loss 147\u003c\/p\u003e \u003cp\u003eVarying Principal Allocation Methodologies 150\u003c\/p\u003e \u003cp\u003eVarying Prepayment Rates 151\u003c\/p\u003e \u003cp\u003eVarying Loss Timing 152\u003c\/p\u003e \u003cp\u003eVarying Recovery Rate and Lag 152\u003c\/p\u003e \u003cp\u003eThe Value of a Swap 153\u003c\/p\u003e \u003cp\u003eAdditional Testing 153\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 10 Automation Using Visual Basic Applications (VBA) 155\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eConventions of This Chapter 155\u003c\/p\u003e \u003cp\u003eThe Visual Basic Editor 156\u003c\/p\u003e \u003cp\u003eThe Menu Bar 156\u003c\/p\u003e \u003cp\u003eThe Project Explorer and the Properties Window 157\u003c\/p\u003e \u003cp\u003eVBA Code 157\u003c\/p\u003e \u003cp\u003eSimple Automation for Printing and Goal Seek 158\u003c\/p\u003e \u003cp\u003eModel Builder 10.1: Automating Print Procedures 158\u003c\/p\u003e \u003cp\u003eModel Builder 10.2: Automating Goal Seek to Optimize Advance Rates 161\u003c\/p\u003e \u003cp\u003eUnderstanding Looping to Automate the Analytics Sheet 164\u003c\/p\u003e \u003cp\u003eModel Builder 10.3: Automating Goal Seek to Perform Transaction Analytics 164\u003c\/p\u003e \u003cp\u003eAutomated Scenario Generation 167\u003c\/p\u003e \u003cp\u003eModel Builder 10.4: Creating a Transaction Scenario Generator 167\u003c\/p\u003e \u003cp\u003eWorking with Macros in Excel 173\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 11 Conclusion 175\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eThe Investment Banker’s Perspective 175\u003c\/p\u003e \u003cp\u003eThe Investor’s Perspective 176\u003c\/p\u003e \u003cp\u003eThe Issuer’s Perspective 176\u003c\/p\u003e \u003cp\u003eThe Financial Guarantor’s Perspective 177\u003c\/p\u003e \u003cp\u003eThe Big Picture Perspective 177\u003c\/p\u003e \u003cp\u003eAppendix: Using This Book with Excel 2007 179\u003c\/p\u003e \u003cp\u003eAbout the CD-ROM 189\u003c\/p\u003e \u003cp\u003eIndex 193\u003c\/p\u003e","brand":"John Wiley \u0026 Sons Inc","offers":[{"title":"Default Title","offer_id":48864621986135,"sku":"9780470042908","price":54.75,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0817\/1739\/5799\/files\/9780470042908.jpg?v=1722272769"},{"product_id":"excel-workbook-for-dummies-9781119832157","title":"Excel Workbook For Dummies","description":"\u003cb\u003eBook Synopsis\u003c\/b\u003e\u003cbr\u003eGet practical walkthroughs for the most useful Excel features Looking for easy-to-understand, practical guidance on how to go from Excel newbie to number crunching pro? Excel Workbook For Dummies is the hands-on tutorial you've been waiting for. This step-by-step guide is packed with exercises that walk you through the basic and advanced functions and formulas included in Excel. At your own speed, you'll learn how to enter data, format your spreadsheet, and apply the mathematical and statistical capabilities of the program. Work through the book from start to finish or, if you'd prefer, jump right to the section that's giving you trouble, whether that's data visualization, macros, analysis, or anything else. You can also: Brush up on and practice time-saving keyboard shortcuts for popular commands and actionsGet a handle on multi-functional and practical pivot tables with intuitive practice exercisesLearn to secure your data with spreadsheet password protections Perfect for new users of Excel, Excel Workbook For Dummies is also the ideal resource for those who know their way around a spreadsheet but need a refresher on some of the more advanced features of this powerful program.\u003cbr\u003e\u003cbr\u003e\u003cb\u003eTable of Contents\u003c\/b\u003e\u003cbr\u003e\u003cp\u003eIntroduction 1\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart 1: Building Worksheets 5\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 1: Getting Familiar with the Excel Interface 7\u003c\/p\u003e \u003cp\u003eChapter 2: Entering the Worksheet Data 21\u003c\/p\u003e \u003cp\u003eChapter 3: Formatting the Worksheet 37\u003c\/p\u003e \u003cp\u003eChapter 4: Printing Worksheet Reports 59\u003c\/p\u003e \u003cp\u003eChapter 5: Modifying the Worksheet 79\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart 2: Using Formulas and Functions 101\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 6: Building Formulas 103\u003c\/p\u003e \u003cp\u003eChapter 7: Copying and Correcting Formulas 123\u003c\/p\u003e \u003cp\u003eChapter 8: Creating Date and Time Formulas 145\u003c\/p\u003e \u003cp\u003eChapter 9: Financial Formulas and Functions 155\u003c\/p\u003e \u003cp\u003eChapter 10: Using Math Functions 167\u003c\/p\u003e \u003cp\u003eChapter 11: Using Common Statistical Functions 179\u003c\/p\u003e \u003cp\u003eChapter 12: Using Lookup Functions 187\u003c\/p\u003e \u003cp\u003eChapter 13: Using Logical Functions 197\u003c\/p\u003e \u003cp\u003eChapter 14: Text Formulas and Functions 209\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart 3: Working with Graphics 217\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 15: Charting Worksheet Data 219\u003c\/p\u003e \u003cp\u003eChapter 16: Adding Graphics to Worksheets 231\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart 4: Managing and Securing Data 249\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 17: Building and Maintaining Tables 251\u003c\/p\u003e \u003cp\u003eChapter 18: Protecting Workbooks and Worksheet Data 271\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart 5: Doing Data Analysis 283\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 19: Performing What-If Analysis 285\u003c\/p\u003e \u003cp\u003eChapter 20: Generating PivotTables 299\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart 6: Macros and Visual Basic for Applications 315\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 21: Using Macros 317\u003c\/p\u003e \u003cp\u003eChapter 22: Using the Visual Basic Editor 327\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart 7: The Part of Tens 341\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 23: Top Ten Features in Excel 343\u003c\/p\u003e \u003cp\u003eChapter 24: Top Ten Tips for Using Excel Like a Pro 347\u003c\/p\u003e \u003cp\u003eIndex 355\u003c\/p\u003e","brand":"John Wiley \u0026 Sons Inc","offers":[{"title":"Default Title","offer_id":48866419310935,"sku":"9781119832157","price":20.39,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0817\/1739\/5799\/files\/9781119832157.jpg?v=1722278556"},{"product_id":"python-for-excel-9781492081005","title":"Python for Excel","description":"\u003cb\u003eBook Synopsis\u003c\/b\u003e\u003cbr\u003eWhile Excel remains ubiquitous in the business world, recent Microsoft feedback forums are full of requests to include Python as an Excel scripting language. What makes this combination so compelling? In this hands-on guide, Felix Zumstein shows experienced Excel users how to integrate these two worlds efficiently.","brand":"O'Reilly Media","offers":[{"title":"Default Title","offer_id":48867309519191,"sku":"9781492081005","price":50.34,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0817\/1739\/5799\/files\/9781492081005.jpg?v=1722282721"},{"product_id":"microsoft-excel-2019-vba-and-macros-9781509306114","title":"Microsoft Excel 2019 VBA and Macros","description":"\u003cb\u003eBook Synopsis\u003c\/b\u003e\u003cbr\u003e\u003cp\u003eRenowned Excel experts Bill Jelen (MrExcel) and Tracy Syrstad explain how to build more powerful, reliable, and efficient Excel spreadsheets.\u003c\/p\u003e \u003cp\u003e \u003c\/p\u003e \u003cp\u003eUse this guide to automate virtually any routine Excel task: save yourself hours, days, maybe even weeks. Make Excel do things you thought were impossible, discover macro techniques you won’t find anywhere else, and create automated reports that are amazingly powerful. Bill Jelen and Tracy Syrstad help you instantly visualize information to make it actionable; capture data from anywhere, and use it anywhere; and automate the best new features in Excel 2019 and Excel in Office 365. You’ll find simple, step-by-step instructions, real-world case studies, and 50 workbooks packed with examples and complete, easy-to-adapt solutions.\u003c\/p\u003e \u003cp\u003e \u003c\/p\u003e \u003cp\u003eBy reading this book, you will:\u003c\/p\u003e \u003cp\u003e\u003c\/p\u003e \u003cul\u003e\n\u003cli\u003eQuickly master Excel macro development\u003c\/li\u003e\n\u003cli\u003eWork more efficiently with ranges, cells, and formulas\u003c\/li\u003e\n\u003cli\u003eGenerate automated reports and quickly adapt them for new requirements\u003c\/li\u003e\n\u003cli\u003eLearn to automate pivot tables to summarize, analyze, explore, and present data\u003c\/li\u003e\n\u003cli\u003eUse custom dialog boxes to collect data from others using Excel\u003c\/li\u003e\n\u003cli\u003eImprove the reliability and resiliency of your macros\u003c\/li\u003e\n\u003cli\u003eIntegrate data from the internet, Access databases, and other sources\u003c\/li\u003e\n\u003cli\u003eAutomatically generate charts, visualizations, sparklines, and Word documents\u003c\/li\u003e\n\u003cli\u003eCreate powerful solutions with classes, collections, and custom functions\u003c\/li\u003e\n\u003cli\u003eSolve sophisticated business analysis problems more rapidly\u003c\/li\u003e\n\u003c\/ul\u003e \u003cp\u003e\u003c\/p\u003e \u003cp\u003e \u003c\/p\u003e \u003cp\u003eAbout This Book\u003c\/p\u003e \u003cp\u003e\u003c\/p\u003e \u003cul\u003e\n\u003cli\u003eFor everyone who wants to get more done with Microsoft Excel in less time\u003c\/li\u003e\n\u003cli\u003eFor business and financial professionals, entrepreneurs, students, and others who need to efficiently manage and analyze data\u003c\/li\u003e\n\u003c\/ul\u003e \u003cp\u003e\u003c\/p\u003e \u003cp\u003e \u003c\/p\u003e\u003cbr\u003e\u003cbr\u003e\u003cb\u003eTable of Contents\u003c\/b\u003e\u003cbr\u003eIntroduction \u003col\u003e\n\u003cli\u003eUnleash the Power of Excel with VBA\u003c\/li\u003e\n\u003cli\u003eThis Sounds Like BASIC, So Why Doesn't It Look Familiar?\u003c\/li\u003e\n\u003cli\u003eReferring to Ranges\u003c\/li\u003e\n\u003cli\u003eLooping and Flow Control\u003c\/li\u003e\n\u003cli\u003eR1C1-style Formulas\u003c\/li\u003e\n\u003cli\u003eCreating and manipulating Names in VBA\u003c\/li\u003e\n\u003cli\u003eEvent Programming\u003c\/li\u003e\n\u003cli\u003eArrays\u003c\/li\u003e\n\u003cli\u003eCreating Classes and Collections\u003c\/li\u003e\n\u003cli\u003eUserforms: An Introduction\u003c\/li\u003e\n\u003cli\u003eData Mining with Advanced Filter\u003c\/li\u003e\n\u003cli\u003eUsing VBA to Create Pivot Tables\u003c\/li\u003e\n\u003cli\u003eExcel Power\u003c\/li\u003e\n\u003cli\u003eSample User-Defined Functions\u003c\/li\u003e\n\u003cli\u003eCreating Charts\u003c\/li\u003e\n\u003cli\u003eData Visualizations and Conditional Formatting\u003c\/li\u003e\n\u003cli\u003eDashboarding with Sparklines\u003c\/li\u003e\n\u003cli\u003eReading from and Writing to the Web\u003c\/li\u003e\n\u003cli\u003eText File Processing\u003c\/li\u003e\n\u003cli\u003eAutomating Word\u003c\/li\u003e\n\u003cli\u003eUsing Access as a Back End to Enhance Multiuser Access to Data\u003c\/li\u003e\n\u003cli\u003eAdvanced Userform Techniques\u003c\/li\u003e\n\u003cli\u003eWindows Application Programming Interface (API)\u003c\/li\u003e\n\u003cli\u003eHandling Errors\u003c\/li\u003e\n\u003cli\u003eCustomizing the Ribbon to Run Macros\u003c\/li\u003e\n\u003cli\u003eCreating Add-Ins\u003c\/li\u003e\n\u003cli\u003eAn Introduction to Creating Office Add-ins\u003c\/li\u003e\n\u003cli\u003eWhat's New in Excel 2019 and What's Changed\u003c\/li\u003e\n\u003c\/ol\u003e","brand":"Microsoft Press,U.S.","offers":[{"title":"Default Title","offer_id":48867386392919,"sku":"9781509306114","price":25.49,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0817\/1739\/5799\/files\/9781509306114.jpg?v=1722283064"},{"product_id":"the-absolute-guide-to-dashboarding-and-reporting-with-power-bi-how-to-design-and-create-a-financial-dashboard-with-power-bi-end-to-end-9781615470570","title":"The Absolute Guide to Dashboarding and Reporting","description":"\u003cb\u003eBook Synopsis\u003c\/b\u003e\u003cbr\u003eWritten by a member of Microsoft’s Power BI team, this resource provides a practical step by step guide on creating a financial dashboard. The book covers in detail how to combine and shape the relevant data, build the dashboard in Power BI, providing layout and design tips and tricks, prepare the model to work with fiscal dates, and show values used in many financial reports, including year-to-date, variance-to-target, percentage-of-total, and running totals reports.","brand":"Holy Macro! Books","offers":[{"title":"Default Title","offer_id":48867772072279,"sku":"9781615470570","price":22.91,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0817\/1739\/5799\/files\/9781615470570.jpg?v=1722284887"},{"product_id":"excel-vba-in-easy-steps-9781787910034","title":"Excel VBA in easy steps","description":"\u003cb\u003eBook Synopsis\u003c\/b\u003e\u003cbr\u003e\u003cp\u003eGet more out of Microsoft Excel and save time by learning Excel VBA (Visual Basic for Applications). \u003cstrong\u003eExcel VBA in easy steps, 4th edition\u003c\/strong\u003e demonstrates VBA macro programming in a clear and concise manner, and will take your Excel proficiency to the next level:\u003c\/p\u003e\u003cli\u003eWrite your own Excel macros so that you can do a series of tasks at the click of a button.\u003c\/li\u003e\u003cli\u003eUse VBA to automate repetitive tasks, and for functions and commands beyond Excel. \u003c\/li\u003e\u003cli\u003eCreate dialog boxes for user interactions and then define processes to handle user input. \u003c\/li\u003e\u003cli\u003eDevelop and share your Excel apps with colleagues they'll be impressed! \u003c\/li\u003e\u003cp\u003eWhether you're upgrading to Excel in Office 365 or new to macro programming, use this guide to master Excel VBA essentials \u003cstrong\u003ein easy steps\u003c\/strong\u003e! \u003c\/p\u003e\u003cp\u003eComes with free downloadable code to help you get started with Excel VBA right away! \u003c\/p\u003e","brand":"In Easy Steps Limited","offers":[{"title":"Default Title","offer_id":48868426154327,"sku":"9781787910034","price":12.34,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0817\/1739\/5799\/files\/9781787910034.jpg?v=1722287970"},{"product_id":"microsoft-excel-in-easy-steps-illustrated-using-excel-in-microsoft-365-9781840789966","title":"Microsoft Excel in easy steps: Illustrated using","description":"\u003cb\u003eBook Synopsis\u003c\/b\u003e\u003cbr\u003e\u003cp\u003e\u003cstrong\u003eMicrosoft Excel in easy steps guides you through the essential functions of Microsoft Excel whether you are new to Excel and the spreadsheet concept, or just upgrading from an older version. This edition is illustrated using the most up-to-date version of Excel in Microsoft 365 at the time of printing. \u003c\/strong\u003e \u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eMicrosoft Excel in easy steps\u003c\/strong\u003e starts with the basics then reveals the key clever features on offer all in easy steps! Areas covered include:\u003c\/p\u003e\u003cli\u003eCreating, editing, and manipulating worksheets.\u003c\/li\u003e\u003cli\u003eFormulas, functions, tables and importing data. \u003c\/li\u003e\u003cli\u003eHandy templates to give you a head start. \u003c\/li\u003e\u003cli\u003eMacros for everyday tasks to save time. \u003c\/li\u003e\u003cli\u003eCharts to get an overview of your data. \u003c\/li\u003e\u003cli\u003eWhat-if, Goal Seek and Optimization. \u003c\/li\u003e\u003cli\u003eUsing the Excel Online app to share and collaborate on spreadsheets and workbooks. \u003c\/li\u003e\u003cli\u003eAdding images and illustrations to your spreadsheets to impress your colleagues! \u003c\/li\u003e\u003cp\u003eWhether you're new to Microsoft Excel or new to spreadsheets, use this guide to get more out of Microsoft Excel, and manage your finances and data effectively both at home and at work!\u003c\/p\u003e","brand":"In Easy Steps Limited","offers":[{"title":"Default Title","offer_id":48868654154071,"sku":"9781840789966","price":11.39,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0817\/1739\/5799\/files\/9781840789966.jpg?v=1722289077"},{"product_id":"mos-study-guide-for-microsoft-excel-exam-mo200-9780136627159","title":"MOS Study Guide for Microsoft Excel Exam MO200","description":"\u003cb\u003eBook Synopsis\u003c\/b\u003e\u003cbr\u003e\u003cdiv\u003e \u003cp style=\"margin:0px;\"\u003e\u003cb\u003eJoan Lambert\u003c\/b\u003e has worked closely with Microsoft technologies since 1986, and in the training and certification industry since 1997, guiding the translation of technical information and requirements into useful, relevant, and measurable resources for people who are seeking certification of their computer skills or who simply want to get things done efficiently. Joan is the author or coauthor of more than four dozen books about Windows and Office (for Windows, Mac, and iPad), six generations of Microsoft Office Specialist certification study guides, video-based training courses for SharePoint and OneNote, QuickStudy guides for Windows 10 and Office 2016, and GO! series books for Outlook. Joan is a Microsoft Certified Professional, Microsoft Office Specialist Master (for all versions of Office since Office 2003), Microsoft Certified Technology Specialist (for Windows and Windows Server), Microsoft Certified Technology Associate (for Windows), Microsoft Dy\u003cbr\u003e\u003cbr\u003e\u003cb\u003eTable of Contents\u003c\/b\u003e\u003cbr\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003e1 Manage worksheets and workbooks\u003c\/strong\u003e \u003c\/li\u003e\n\u003cli\u003eObjective 1.1: Import data into workbooks \u003c\/li\u003e\n\u003cli\u003eObjective 1.2: Navigate within workbooks \u003c\/li\u003e\n\u003cli\u003eObjective 1.3: Format worksheets and workbooks \u003c\/li\u003e\n\u003cli\u003eObjective 1.4: Customize options and views \u003c\/li\u003e\n\u003cli\u003eObjective 1.5: Configure content for collaboration \u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003e2 Manage data cells and ranges\u003c\/strong\u003e \u003c\/li\u003e\n\u003cli\u003eObjective 2.1: Manipulate data in worksheets \u003c\/li\u003e\n\u003cli\u003eObjective 2.2: Format cells and ranges \u003c\/li\u003e\n\u003cli\u003eObjective 2.3: Define and reference named ranges \u003c\/li\u003e\n\u003cli\u003eObjective 2.4: Summarize data visually \u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003e3 Manage tables and table data\u003c\/strong\u003e \u003c\/li\u003e\n\u003cli\u003eObjective 3.1: Create and format tables \u003c\/li\u003e\n\u003cli\u003eObjective 3.2: Modify tables \u003c\/li\u003e\n\u003cli\u003eObjective 3.3: Filter and sort table data \u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003e4 Perform operations by using formulas and functions\u003c\/strong\u003e \u003c\/li\u003e\n\u003cli\u003eObjective 4.1: Insert references in formulas \u003c\/li\u003e\n\u003cli\u003eObjective 4.2: Calculate and transform data by using functions \u003c\/li\u003e\n\u003cli\u003eObjective 4.3: Format and modify text by using functions \u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003e5 Manage charts\u003c\/strong\u003e \u003c\/li\u003e\n\u003cli\u003eObjective 5.1: Create charts \u003c\/li\u003e\n\u003cli\u003eObjective 5.2: Modify charts \u003c\/li\u003e\n\u003cli\u003eObjective 5.3: Format charts \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e","brand":"Pearson Education (US)","offers":[{"title":"Default Title","offer_id":48883798573399,"sku":"9780136627159","price":17.09,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0817\/1739\/5799\/files\/9780136627159.jpg?v=1722529090"},{"product_id":"bayesian-analysis-with-excel-and-r-9780137580989","title":"Bayesian Analysis with Excel and R","description":"\u003cb\u003eBook Synopsis\u003c\/b\u003e\u003cbr\u003e\u003cp\u003e\u003cstrong\u003eConrad Carlberg\u003c\/strong\u003e is a nationally recognized expert on quantitative analysis, data analysis, and management applications such as Microsoft Excel, SAS, and Oracle. He holds a Ph.D. in statistics from the University of Colorado and is a many-time recipient of Microsoft's Excel MVP designation. He is the author of many books, including \u003cem\u003eBusiness Analysis with Microsoft Excel\u003c\/em\u003e, Fifth Edition, \u003cem\u003eStatistical Analysis: Microsoft Excel 2016\u003c\/em\u003e, \u003cem\u003eRegression Analysis Microsoft Excel\u003c\/em\u003e, and \u003cem\u003eR for Microsoft Excel Users\u003c\/em\u003e.\u003c\/p\u003e \u003cp\u003eCarlberg is a Southern California native. After college he moved to Colorado, where he worked for a succession of startups and attended graduate school. He spent two years in the Middle East, teaching computer science and dodging surly camels. After finishing graduate school, Carlberg worked at US West (a Baby Bell) in product management and at Motorola.\u003c\/p\u003e \u003cp\u003eIn 1995 he started a small consulting business (www.conradcarlberg.com)\u003cbr\u003e\u003cbr\u003e\u003cb\u003eTable of Contents\u003c\/b\u003e\u003cbr\u003e\u003c\/p\u003e\u003cp\u003ePreface\u003cbr\u003e\u003cstrong\u003eChapter 1\u003c\/strong\u003e Bayesian Analysis and R: An Overview\u003cbr\u003e Bayes Comes Back\u003cbr\u003e About Structuring Priors\u003cbr\u003e Watching the Jargon\u003cbr\u003e Priors, Likelihoods, and Posteriors\u003cbr\u003e The Prior\u003cbr\u003e The Likelihood\u003cbr\u003e Contrasting a Frequentist Analysis with a Bayesian\u003cbr\u003e The Frequentist Approach\u003cbr\u003e The Bayesian Approach\u003cbr\u003e Summary\u003cbr\u003e\u003cstrong\u003eChapter 2\u003c\/strong\u003e Generating Posterior Distributions with the Binomial Distribution\u003cbr\u003e Understanding the Binomial Distribution\u003cbr\u003e Understanding Some Related Functions\u003cbr\u003e Working with R's Binomial Functions\u003cbr\u003e Using R's dbinom Function\u003cbr\u003e Using R's pbinom Function\u003cbr\u003e Using R's qbinom Function\u003cbr\u003e Using R's rbinom Function\u003cbr\u003e Grappling with the Math \u003cbr\u003e Summary\u003cbr\u003e\u003cstrong\u003eChapter 3\u003c\/strong\u003e Understanding the Beta Distribution\u003cbr\u003e Establishing the Beta Distribution in Excel\u003cbr\u003e Comparing the Beta Distribution with the Binomial Distribution\u003cbr\u003e Decoding Excel's Help Documentation for BETA.DIST\u003cbr\u003e Replicating the Analysis in R\u003cbr\u003e Understanding dbeta\u003cbr\u003e Understanding pbeta\u003cbr\u003e Understanding qbeta\u003cbr\u003e About Confidence Intervals\u003cbr\u003e Applying qbeta to Confidence Intervals\u003cbr\u003e Applying BETA.INV to Confidence Intervals\u003cbr\u003e Summary\u003cbr\u003e\u003cstrong\u003eChapter 4\u003c\/strong\u003e Grid Approximation and the Beta Distribution\u003cbr\u003e More on Grid Approximation\u003cbr\u003e Setting the Prior\u003cbr\u003e Using the Results of the Beta Function\u003cbr\u003e Tracking the Shape and Location of the Distribution\u003cbr\u003e Inventorying the Necessary Functions\u003cbr\u003e Looking Behind the Curtains\u003cbr\u003e Moving from the Underlying Formulas to the Functions\u003cbr\u003e Comparing Built-in Functions with Underlying Formulas\u003cbr\u003e Understanding Conjugate Priors \u003cbr\u003e Summary\u003cbr\u003e\u003cstrong\u003eChapter 5\u003c\/strong\u003e Grid Approximation with Multiple Parameters\u003cbr\u003e Setting the Stage\u003cbr\u003e Global Options\u003cbr\u003e Local Variables\u003cbr\u003e Specifying the Order of Execution\u003cbr\u003e Normal Curves, Mu and Sigma\u003cbr\u003e Visualizing the Arrays\u003cbr\u003e Combining Mu and Sigma\u003cbr\u003e Putting the Data Together\u003cbr\u003e Calculating the Probabilities\u003cbr\u003e Folding in the Prior\u003cbr\u003e Inventorying the Results\u003cbr\u003e Viewing the Results from Different Perspectives\u003cbr\u003e Summary\u003cbr\u003e\u003cstrong\u003eChapter 6\u003c\/strong\u003e Regression Using Bayesian Methods\u003cbr\u003e Regression a la Bayes\u003cbr\u003e Sample Regression Analysis\u003cbr\u003e Matrix Algebra Methods\u003cbr\u003e Understanding quap\u003cbr\u003e Continuing the Code\u003cbr\u003e A Full Example\u003cbr\u003e Designing the Multiple Regression\u003cbr\u003e Arranging a Bayesian Multiple Regression\u003cbr\u003e Summary\u003cbr\u003e\u003cstrong\u003eChapter 7\u003c\/strong\u003e Handling Nominal Variables\u003cbr\u003e Using Dummy Coding \u003cbr\u003e Supplying Text Labels in Place of Codes\u003cbr\u003e Comparing Group Means\u003cbr\u003e Summary\u003cbr\u003e\u003cstrong\u003eChapter 8\u003c\/strong\u003e MCMC Sampling Methods\u003cbr\u003e Quick Review of Bayesian Sampling\u003cbr\u003e Grid Approximation\u003cbr\u003e Quadratic Approximation\u003cbr\u003e MCMC Gets Up To Speed\u003cbr\u003e A Sample MCMC Analysis\u003cbr\u003e ulam's Output\u003cbr\u003e Validating the Results\u003cbr\u003e Getting Trace Plot Charts\u003cbr\u003e Summary and Concluding Thoughts\u003cbr\u003e\u003cstrong\u003eAppendix\u003c\/strong\u003e Installation Instructions for RStan and the \u003cem\u003erethinking\u003c\/em\u003e Package on the Windows Platform\u003cbr\u003e\u003cstrong\u003eGlossary\u003c\/strong\u003e\u003c\/p\u003e \u003cp\u003e \u003c\/p\u003e \u003cp\u003e\u003cstrong\u003eDownloadable Bonus Content\u003c\/strong\u003e\u003c\/p\u003e \u003cp\u003eExcel Worksheets \u003cbr\u003e Book: \u003cem\u003eStatistical Analysis: Microsoft Excel 2016\u003c\/em\u003e (PDF)\u003c\/p\u003e \u003cp\u003e \u003c\/p\u003e \u003cp\u003e \u003c\/p\u003e \u003cp\u003e9780137580989 TOC 10\/24\/2022\u003c\/p\u003e \u003cp\u003e \u003c\/p\u003e","brand":"Pearson Education (US)","offers":[{"title":"Default Title","offer_id":48883800211799,"sku":"9780137580989","price":34.19,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0817\/1739\/5799\/files\/9780137580989.jpg?v=1722529100"},{"product_id":"mos-2016-study-guide-for-microsoft-excel-expert-9780735699427","title":"MOS 2016 Study Guide for Microsoft Excel Expert","description":"\u003cb\u003eBook Synopsis\u003c\/b\u003e\u003cbr\u003e\u003cp style=\"MARGIN:\"\u003e\u003cb\u003ePaul McFedries\u003c\/b\u003e is a full-time technical author who has worked with computers in one form or another since 1975. He is the author of more than 90 computer books that have sold more than 4 million copies worldwide. His recent Office-related titles include \u003ci\u003eMy Office 2016\u003c\/i\u003e, \u003ci\u003eMy Office 2016 for Mac\u003c\/i\u003e, and \u003ci\u003eFormulas and Functions for Microsoft Excel 2016\u003c\/i\u003e. His other titles include \u003ci\u003eWindows 10 In Depth\u003c\/i\u003e, (with Brian Knittel), \u003ci\u003ePCs for Grownups\u003c\/i\u003e, and \u003ci\u003eFixing Your Computer Absolute Beginner's Guide\u003c\/i\u003e. \u003c\/p\u003e\u003cbr\u003e\u003cbr\u003e\u003cb\u003eTable of Contents\u003c\/b\u003e\u003cbr\u003eChapter 1 — Manage and share workbooks \u003cbr\u003e1.1 Manage workbooks \u003cbr\u003e1.2 Manage workbook review \u003cbr\u003eChapter 2 — Apply custom formats and layouts \u003cbr\u003e2.1 Apply custom data formats \u003cbr\u003e2.2 Apply advanced conditional formatting and filtering \u003cbr\u003e2.3 Apply custom styles and templates \u003cbr\u003e2.4 Prepare workbooks for internationalization and accessibility \u003cbr\u003eChapter 3 — Create advanced formulas \u003cbr\u003e3.1 Apply functions in formulas \u003cbr\u003e3.2 Look up data by using functions \u003cbr\u003e3.3 Apply advanced date and time functions \u003cbr\u003e3.4 Perform data analysis and business intelligence \u003cbr\u003e3.5 Troubleshoot formulas \u003cbr\u003e3.6 Define named ranges and objects \u003cbr\u003eChapter 4 — Create advanced charts and tables \u003cbr\u003e4.1 Create advanced chart elements \u003cbr\u003e4.2 Create and manage PivotTables \u003cbr\u003e4.3 Create and manage PivotCharts \u003cbr\u003e","brand":"Microsoft Press,U.S.","offers":[{"title":"Default Title","offer_id":48884318142807,"sku":"9780735699427","price":16.64,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0817\/1739\/5799\/files\/9780735699427.jpg?v=1722531418"},{"product_id":"mos-2016-study-guide-for-microsoft-excel-9780735699434","title":"MOS 2016 Study Guide for Microsoft Excel","description":"\u003cb\u003eBook Synopsis\u003c\/b\u003e\u003cbr\u003e\u003cp style=\"margin:0px;\"\u003e\u003cb\u003eJoan Lambert\u003c\/b\u003e has worked closely with Microsoft technologies since 1986, and in the training and certification industry since 1997. As President and CEO of Online Training Solutions, Inc. (OTSI), Joan guides the translation of technical information and requirements into useful, relevant, and measurable resources for people who are seeking certification of their computer skills or who simply want to know how to get things done efficiently.\u003c\/p\u003e \u003cp style=\"margin:0px;\"\u003e\u003cbr\u003e\u003c\/p\u003e \u003cp style=\"margin:0px;\"\u003eJoan is the author or coauthor of more than four dozen books about Windows and Office (for Windows, Mac, and iPad), five generations of Microsoft Office Specialist certification study guides, video-based training courses for SharePoint and OneNote, QuickStudy guides for Windows and Office, and the GO! series book for Outlook 2016.\u003c\/p\u003e \u003cp style=\"margin:0px;\"\u003e\u003cbr\u003e\u003c\/p\u003e \u003cp style=\"margin:0px;\"\u003eBlissfully based in America's Finest City, Joan is a Microsoft Certified\u003cbr\u003e\u003cbr\u003e\u003cb\u003eTable of Contents\u003c\/b\u003e\u003cbr\u003e\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003e Introduction \u003c\/li\u003e\n\u003cli\u003e Taking a Microsoft Office Specialist exam \u003c\/li\u003e\n\u003cli\u003e Exam 77-727: Microsoft Excel 2016 Core Prerequisites \u003c\/li\u003e\n\u003cli\u003e Objective group 1: Create and manage worksheets and workbooks \u003c\/li\u003e\n\u003cli\u003e Objective 1.1: Create worksheets and workbooks \u003c\/li\u003e\n\u003cli\u003e Objective 1.2: Navigate in worksheets and workbooks \u003c\/li\u003e\n\u003cli\u003e Objective 1.3: Format worksheets and workbooks \u003c\/li\u003e\n\u003cli\u003e Objective 1.4: Customize options and views for worksheets and workbooks \u003c\/li\u003e\n\u003cli\u003e Objective 1.5: Configure worksheets and workbooks for distribution \u003c\/li\u003e\n\u003cli\u003e Objective group 2: Manage data cells and ranges \u003c\/li\u003e\n\u003cli\u003e Objective 2.1: Insert data in cells and ranges \u003c\/li\u003e\n\u003cli\u003e Objective 2.2: Format cells and ranges \u003c\/li\u003e\n\u003cli\u003e Objective 2.3: Summarize and organize data \u003c\/li\u003e\n\u003cli\u003e Objective group 3: Create tables \u003c\/li\u003e\n\u003cli\u003e Objective 3.1: Create and manage tables \u003c\/li\u003e\n\u003cli\u003e Objective 3.2: Manage table styles and options \u003c\/li\u003e\n\u003cli\u003e Objective 3.3: Filter and sort tables \u003c\/li\u003e\n\u003cli\u003e Objective group 4: Perform operations by using formulas and functions \u003c\/li\u003e\n\u003cli\u003e Objective 4.1: Summarize data by using functions \u003c\/li\u003e\n\u003cli\u003e Objective 4.2: Perform conditional operations by using functions \u003c\/li\u003e\n\u003cli\u003e Objective 4.3: Format and modify text by using functions \u003c\/li\u003e\n\u003cli\u003e Objective group 5: Create charts and objects \u003c\/li\u003e\n\u003cli\u003e Objective 5.1: Create charts \u003c\/li\u003e\n\u003cli\u003e Objective 5.2: Format charts \u003c\/li\u003e\n\u003cli\u003e Objective 5.3: Insert and format objects \u003c\/li\u003e\n\u003c\/ul\u003e","brand":"Microsoft Press,U.S.","offers":[{"title":"Default Title","offer_id":48884318339415,"sku":"9780735699434","price":15.29,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0817\/1739\/5799\/files\/9780735699434.jpg?v=1722531420"},{"product_id":"microsoft-excel-2016-step-by-step-9780735698802","title":"Microsoft Excel 2016 Step by Step","description":"\u003cb\u003eBook Synopsis\u003c\/b\u003e\u003cbr\u003e\u003cstrong\u003eCurtis Frye\u003c\/strong\u003e is the author of more than 30 books, including  \u003ci\u003eMicrosoft Excel 2013 Step by Step\u003c\/i\u003e for Microsoft Press and  \u003ci\u003eBrilliant Excel VBA Programming\u003c\/i\u003e for Pearson, UK. He has also created and recorded more than three dozen courses for lynda.com, including  \u003ci\u003eExcel for Mac 2016 Essential Training\u003c\/i\u003e and  \u003ci\u003eExcel 2013: PivotTables in Depth\u003c\/i\u003e. In addition to his work as a writer, Curt is a popular conference speaker and performer, both as a solo presenter and as part of the Portland, Oregon ComedySportz improvisational comedy troupe. He lives in Portland with his wife and three cats.\u003cbr\u003e\u003cbr\u003e\u003cb\u003eTable of Contents\u003c\/b\u003e\u003cbr\u003e\u003cb\u003eIntroduction xiii \u003c\/b\u003e \u003cbr\u003eWho this book is for xiii \u003cbr\u003eThe Step by Step approach xiii \u003cbr\u003eDownload the practice files xiv \u003cbr\u003eSidebar: Adapt exercise steps xviii \u003cbr\u003eEbook edition xx \u003cbr\u003eGet support and give feedback xx \u003cbr\u003eErrata and support xx \u003cbr\u003eWe want to hear from you xx \u003cbr\u003eStay in touch xx \u003cbr\u003e \u003cb\u003ePart 1: Create and format workbooks \u003cbr\u003eChapter 1: Set up a workbook 3 \u003c\/b\u003e \u003cbr\u003eExplore the editions of Excel 2016 4 \u003cbr\u003eExcel 2016 4 \u003cbr\u003eExcel Online 4 \u003cbr\u003eExcel Mobile Apps 5 \u003cbr\u003eBecome familiar with new features in Excel 2016 6 \u003cbr\u003eCreate workbooks 7 \u003cbr\u003eModify workbooks 13 \u003cbr\u003eModify worksheets 18 \u003cbr\u003eMerge and unmerge cells 23 \u003cbr\u003eCustomize the Excel 2016 app window 26 \u003cbr\u003eZoom in on a worksheet 26 \u003cbr\u003eArrange multiple workbook windows 28 \u003cbr\u003eAdd buttons to the Quick Access Toolbar 30 \u003cbr\u003eCustomize the ribbon 33 \u003cbr\u003eSkills review 39 \u003cbr\u003ePractice tasks 40 \u003cbr\u003e \u003cb\u003eChapter 2: Work with data and Excel tables 43 \u003c\/b\u003e \u003cbr\u003eEnter and revise data 44 \u003cbr\u003eManage data by using Flash Fill 48 \u003cbr\u003eMove data within a workbook 51 \u003cbr\u003eFind and replace data 56 \u003cbr\u003eCorrect and expand upon data 60 \u003cbr\u003eDefine Excel tables 65 \u003cbr\u003eSkills review 69 \u003cbr\u003ePractice tasks 70 \u003cbr\u003e \u003cb\u003eChapter 3: Perform calculations on data 73 \u003c\/b\u003e \u003cbr\u003eName groups of data 74 \u003cbr\u003eCreate formulas to calculate values 77 \u003cbr\u003eSidebar: Operators and Precedence 88 \u003cbr\u003eSummarize data that meets specific conditions 90 \u003cbr\u003eSet iterative calculation options and enable or disable automatic calculation 96 \u003cbr\u003eUse array formulas 98 \u003cbr\u003eFind and correct errors in calculations 100 \u003cbr\u003eSkills review 106 \u003cbr\u003ePractice tasks 107 \u003cbr\u003e \u003cb\u003eChapter 4: Change workbook appearance 111\u003c\/b\u003e \u003cbr\u003eFormat cells 112 \u003cbr\u003eDefine styles 118 \u003cbr\u003eApply workbook themes and Excel table styles 121 \u003cbr\u003eMake numbers easier to read 127 \u003cbr\u003eChange the appearance of data based on its value 130 \u003cbr\u003eAdd images to worksheets 138 \u003cbr\u003eSkills review 142 \u003cbr\u003ePractice tasks 143 \u003cbr\u003e \u003cb\u003ePart 2: Analyze and present data\u003cbr\u003eChapter 5: Manage worksheet data 147\u003c\/b\u003e \u003cbr\u003eLimit data that appears on your screen 148 \u003cbr\u003eManipulate worksheet data 153 \u003cbr\u003eSidebar: Select list rows at random 154 \u003cbr\u003eSummarize data in worksheets that have hidden and filtered rows 155 \u003cbr\u003eFind unique values within a data set 161 \u003cbr\u003eDefine valid sets of values for ranges of cells 163 \u003cbr\u003eSkills review 165 \u003cbr\u003ePractice tasks 166 \u003cbr\u003e \u003cb\u003eChapter 6: Reorder and summarize data 169\u003c\/b\u003e \u003cbr\u003eSort worksheet data 170 \u003cbr\u003eSort data by using custom lists 176 \u003cbr\u003eOrganize data into levels 179 \u003cbr\u003eLook up information in a worksheet 184 \u003cbr\u003eSkills review 187 \u003cbr\u003ePractice tasks 188 \u003cbr\u003e \u003cb\u003eChapter 7: Combine data from multiple sources 191 \u003c\/b\u003e \u003cbr\u003eUse workbooks as templates for other workbooks 192 \u003cbr\u003eLink to data in other worksheets and workbooks 197 \u003cbr\u003eConsolidate multiple sets of data into a single workbook 202 \u003cbr\u003eSkills review 205 \u003cbr\u003ePractice tasks 206 \u003cbr\u003e \u003cb\u003eChapter 8: Analyze alternative data sets 209\u003c\/b\u003e \u003cbr\u003eExamine data by using the Quick Analysis Lens 210 \u003cbr\u003eDefine an alternative data set 212 \u003cbr\u003eDefine multiple alternative data sets 216 \u003cbr\u003eAnalyze data by using data tables 218 \u003cbr\u003eVary your data to get a specific result by using Goal Seek 221 \u003cbr\u003eFind optimal solutions by using Solver 223 \u003cbr\u003eAnalyze data by using descriptive statistics 229 \u003cbr\u003eSkills review 231 \u003cbr\u003ePractice tasks 232 \u003cbr\u003e \u003cb\u003eChapter 9: Create charts and graphics 237 \u003c\/b\u003e \u003cbr\u003eCreate charts 238 \u003cbr\u003eCreate new types of charts 248 \u003cbr\u003eCustomize chart appearance 252 \u003cbr\u003eFind trends in your data 260 \u003cbr\u003eCreate dual-axis charts 263 \u003cbr\u003eSummarize your data by using sparklines 264 \u003cbr\u003eCreate diagrams by using SmartArt 266 \u003cbr\u003eCreate shapes and mathematical equations 271 \u003cbr\u003eSkills review 277 \u003cbr\u003ePractice tasks 278 \u003cbr\u003e \u003cb\u003eChapter 10: Create dynamic worksheets by using PivotTables 281 \u003c\/b\u003e \u003cbr\u003eAnalyze data dynamically by using PivotTables 282 \u003cbr\u003eFilter, show, and hide PivotTable data 290 \u003cbr\u003eEdit PivotTables 301 \u003cbr\u003eFormat PivotTables 305 \u003cbr\u003eCreate PivotTables from external data 309 \u003cbr\u003eCreate dynamic charts by using PivotCharts 313 \u003cbr\u003eSkills review 316 \u003cbr\u003ePractice tasks 317 \u003cbr\u003e \u003cb\u003ePart 3: Collaborate and share in Excel \u003cbr\u003eChapter 11: Print worksheets and charts 323 \u003c\/b\u003e \u003cbr\u003eAdd headers and footers to printed pages 324 \u003cbr\u003ePrepare worksheets for printing 330 \u003cbr\u003eFit your worksheet contents to the printed page 331 \u003cbr\u003eChange page breaks in a worksheet 334 \u003cbr\u003eChange the page printing order for worksheets 335 \u003cbr\u003ePrint worksheets 337 \u003cbr\u003ePrint parts of worksheets 339 \u003cbr\u003ePrint charts 343 \u003cbr\u003eSkills review 345 \u003cbr\u003ePractice tasks 346 \u003cbr\u003e \u003cb\u003eChapter 12: Automate repetitive tasks by using macros 349 \u003c\/b\u003e \u003cbr\u003eEnable and examine macros 350 \u003cbr\u003eSet macro security levels in Excel 2016 350 \u003cbr\u003eExamine macros 353 \u003cbr\u003eCreate and modify macros 356 \u003cbr\u003eRun macros when you click a button 357 \u003cbr\u003eRun a macro when you open a workbook 361 \u003cbr\u003eInsert form controls into a worksheet 362 \u003cbr\u003eSkills review 369 \u003cbr\u003ePractice tasks 370 \u003cbr\u003e \u003cb\u003eChapter 13: Work with other Microsoft Office apps 373 \u003c\/b\u003e \u003cbr\u003eInclude Office documents in workbooks and other files 374 \u003cbr\u003eLink Office documents to Excel workbooks 375 \u003cbr\u003eEmbed files in Excel and other Office apps 377 \u003cbr\u003eCreate hyperlinks 379 \u003cbr\u003ePaste charts into documents 384 \u003cbr\u003eSkills review 385 \u003cbr\u003ePractice tasks 386 \u003cbr\u003e \u003cb\u003eChapter 14: Collaborate with colleagues 389 \u003c\/b\u003e \u003cbr\u003eShare workbooks 390 \u003cbr\u003eSave workbooks for electronic distribution 394 \u003cbr\u003eManage comments 395 \u003cbr\u003eTrack and manage colleagues’ changes 398 \u003cbr\u003eAdd protection to workbooks and worksheets 401 \u003cbr\u003eFinalize workbooks 408 \u003cbr\u003eAuthenticate workbooks 410 \u003cbr\u003eSave workbooks for the web 412 \u003cbr\u003eImport and export XML data 414 \u003cbr\u003eWork with OneDrive and Excel Online 418 \u003cbr\u003eSkills review 424 \u003cbr\u003ePractice tasks 425 \u003cbr\u003e \u003cb\u003ePart 4: Perform advanced analysis \u003cbr\u003eChapter 15: Perform business intelligence analysis 431 \u003c\/b\u003e \u003cbr\u003eEnable the Data Analysis add-ins 432 \u003cbr\u003eDefine relationships between tables 434 \u003cbr\u003eAnalyze data by using Power Pivot 438 \u003cbr\u003eView data by using timelines 442 \u003cbr\u003eBring in external data by using Power Query 446 \u003cbr\u003eSkills review 451 \u003cbr\u003ePractice tasks 452 \u003cbr\u003e \u003cb\u003eChapter 16: Create forecasts and visualizations 455 \u003c\/b\u003e \u003cbr\u003eCreate Forecast Worksheets 456 \u003cbr\u003eDefine and manage measures 461 \u003cbr\u003eDefine and display Key Performance Indicators 464 \u003cbr\u003eCreate 3D maps 468 \u003cbr\u003eSkills review 475 \u003cbr\u003ePractice tasks 476 \u003cbr\u003e \u003cb\u003eKeyboard shortcuts 479 \u003cbr\u003eGlossary 89 \u003cbr\u003eIndex 95 \u003cbr\u003eAbout the author 521\u003c\/b\u003e","brand":"Microsoft Press,U.S.","offers":[{"title":"Default Title","offer_id":48884318470487,"sku":"9780735698802","price":22.09,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0817\/1739\/5799\/files\/9780735698802.jpg?v=1722531420"},{"product_id":"excel-cookbook-9781098143329","title":"Excel Cookbook","description":"\u003cb\u003eBook Synopsis\u003c\/b\u003e\u003cbr\u003e","brand":"O'Reilly","offers":[{"title":"Default Title","offer_id":48885253112151,"sku":"9781098143329","price":42.39,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0817\/1739\/5799\/files\/9781098143329.jpg?v=1722535579"},{"product_id":"modern-data-analytics-in-excel-9781098148829","title":"Modern Data Analytics in Excel","description":"\u003cb\u003eBook Synopsis\u003c\/b\u003e\u003cbr\u003e","brand":"O'Reilly","offers":[{"title":"Default Title","offer_id":48885253472599,"sku":"9781098148829","price":38.39,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0817\/1739\/5799\/files\/9781098148829.jpg?v=1722535581"},{"product_id":"getting-great-results-with-excel-pivot-tables-powerquery-and-powerpivot-9781394243051","title":"Getting Great Results with Excel Pivot Tables","description":"\u003cb\u003eBook Synopsis\u003c\/b\u003e\u003cbr\u003eGet more out of your data with step-by-step tutorials for the Excel features you need to know Excel 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. Getting Great Results with Excel Pivot Tables, PowerQuery and PowerPivot 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. Using 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 c","brand":"John Wiley \u0026 Sons","offers":[{"title":"Default Title","offer_id":48885461483863,"sku":"9781394243051","price":30.39,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0817\/1739\/5799\/files\/9781394243051.jpg?v=1722536497"},{"product_id":"up-up-and-array-9781484289655","title":"Up Up and Array","description":"\u003cb\u003eBook Synopsis\u003c\/b\u003e\u003cbr\u003eUnderstand the power of dynamic arrays:a single formula can generate new and vastly more efficient spreadsheet possibilities. This bookintroduces spreadsheet users to dynamic array functions in Microsoft Excel 365, defines and details the distinctive ways in which they work, and shows how they can be applied to a wide swath of data-analytic tasks. While array formulas and functions have long held a place in the spreadsheet toolbox (although, for many of us, shunted to an obscure corner), the dynamic array engine offers a more user-friendly and intelligible set of means for manipulating spreadsheet data in the array mode. The single-formula, multi-cell capability of dynamic arrays has been extended to nearly all existing spreadsheet functions, offering a new, default way of working. As a result, many tasks can now be executed with dynamic arrays without having to resort to the new functions at all. After defining arrays and dynamic array formulas, this book helps you examine the dyn\u003cbr\u003e\u003cbr\u003e\u003cb\u003eTable of Contents\u003c\/b\u003e\u003cbr\u003e\u003cp\u003eChapter 1: What’s An Array, Anyway?\u003c\/p\u003e \u003cp\u003eChapter 2: Array Formula Basics\u003c\/p\u003e \u003cp\u003eChapter 3: Dynamic Arrays -- Time for Some Heavy Lifting\u003c\/p\u003e \u003cp\u003e Chapter 4: The SEQUENCE Function: Made to Order\u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e \u003cp\u003e\u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e \u003cp\u003eChapter 5: UNIQUE -- A Singular Function \u003c\/p\u003e Chapter 6: SORT and SORTBY: The ABCs (and the CBAs)\u003cp\u003e\u003c\/p\u003e \u003cp\u003e\u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e \u003cp\u003eChapter 7: The FILTER Function: Cutting the Data Down to Size\u003c\/p\u003e \u003cp\u003eChapter 8: RANDARRAY: Unpredictably Useful\u003cbr\u003e\u003c\/p\u003e \u003cp\u003eChapter 9: The Implicit Intersection Operator: The Function You'll Probably Never Use\u003cbr\u003e\u003c\/p\u003e\u003cp\u003eChapter 10: TEXTSPLIT, TEXTBEFORE, and TEXTAFTER: Putting Words in Their Places\u003cbr\u003e\u003c\/p\u003e\u003cp\u003eChapter 11: TOCOL and TOROW -- Straightening Out the Data\u003cbr\u003e\u003c\/p\u003e\u003cp\u003eChapter 12: WRAPCOLS and WRAPROWS: Giving Some Direction to the Data\u003cbr\u003e\u003c\/p\u003e\u003cp\u003eChapter 13: VSTACK and HSTACK: What They're About\u003cbr\u003e\u003c\/p\u003e\u003cp\u003eChapter 14: CHOOSECOLS and CHOOSEROWS: Less is More\u003cbr\u003e\u003c\/p\u003e\u003cp\u003eChapter 15: TAKE and DROP: Selecting and Rejecting the Data\u003cbr\u003e\u003c\/p\u003e\u003cp\u003eChapter 16: EXPAND: Bulking Up the Data\u003cbr\u003e\u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e","brand":"APress","offers":[{"title":"Default Title","offer_id":48885830484311,"sku":"9781484289655","price":37.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0817\/1739\/5799\/files\/9781484289655.jpg?v=1722537850"},{"product_id":"microsoft-excel-2019-data-analysis-and-business-modeling-9781509305889","title":"Microsoft Excel 2019 Data Analysis and Business","description":"\u003cb\u003eBook Synopsis\u003c\/b\u003e\u003cbr\u003eMaster business modeling and analysis techniques with Microsoft Excel 2019, and transform data into bottom-line results. Written by award-winning educator Wayne Winston, this hands-on, scenario-focused guide shows you how to use the latest Excel tools to integrate data from multiple tables–and how to effectively build a relational data source inside an Excel workbook.\u003cbr\u003e\u003cbr\u003e\u003cb\u003eTable of Contents\u003c\/b\u003e\u003cbr\u003e\u003cul\u003e\n\u003cli\u003eChapter 1 Basic spreadsheet modeling \u003c\/li\u003e\n\u003cli\u003eChapter 2 Range names \u003c\/li\u003e\n\u003cli\u003eChapter 3 Lookup functions \u003c\/li\u003e\n\u003cli\u003eChapter 4 The INDEX function \u003c\/li\u003e\n\u003cli\u003eChapter 5 The MATCH function \u003c\/li\u003e\n\u003cli\u003eChapter 6 Text functions \u003c\/li\u003e\n\u003cli\u003eChapter 7 Dates and date functions \u003c\/li\u003e\n\u003cli\u003eChapter 8 Evaluating investment by using net present value criteria \u003c\/li\u003e\n\u003cli\u003eChapter 9 Internal rate of return \u003c\/li\u003e\n\u003cli\u003eChapter 10 More Excel financial functions \u003c\/li\u003e\n\u003cli\u003eChapter 11 Circular references \u003c\/li\u003e\n\u003cli\u003eChapter 12 IF statements \u003c\/li\u003e\n\u003cli\u003eChapter 13 Time and time functions \u003c\/li\u003e\n\u003cli\u003eChapter 14 The Paste Special command \u003c\/li\u003e\n\u003cli\u003eChapter 15 Three-dimensional formulas and hyperlinks \u003c\/li\u003e\n\u003cli\u003eChapter 16 The auditing tool \u003c\/li\u003e\n\u003cli\u003eChapter 17 Sensitivity analysis with data tables \u003c\/li\u003e\n\u003cli\u003eChapter 18 The Goal Seek command \u003c\/li\u003e\n\u003cli\u003eChapter 19 Using the Scenario Manager for sensitivity analysis \u003c\/li\u003e\n\u003cli\u003eChapter 20 The COUNTIF, COUNTIFS, COUNT, COUNTA, and COUNTBLANK functions \u003c\/li\u003e\n\u003cli\u003eChapter 21 The SUMIF, AVERAGEIF, SUMIFS, and AVERAGEIFS functions \u003c\/li\u003e\n\u003cli\u003eChapter 22 The OFFSET function \u003c\/li\u003e\n\u003cli\u003eChapter 23 The INDIRECT function \u003c\/li\u003e\n\u003cli\u003eChapter 24 Conditional formatting \u003c\/li\u003e\n\u003cli\u003eChapter 25 Sorting in Excel \u003c\/li\u003e\n\u003cli\u003eChapter 26 Tables \u003c\/li\u003e\n\u003cli\u003eChapter 27 Spin buttons, scroll bars, option buttons, check boxes, combo boxes, and group list boxes \u003c\/li\u003e\n\u003cli\u003eChapter 28 The analytics revolution \u003c\/li\u003e\n\u003cli\u003eChapter 29 An introduction to optimization with Excel Solver \u003c\/li\u003e\n\u003cli\u003eChapter 30 Using Solver to determine the optimal product mix \u003c\/li\u003e\n\u003cli\u003eChapter 31 Using Solver to schedule your workforce \u003c\/li\u003e\n\u003cli\u003eChapter 32 Using Solver to solve transportation or distribution problems \u003c\/li\u003e\n\u003cli\u003eChapter 33 Using Solver for capital budgeting \u003c\/li\u003e\n\u003cli\u003eChapter 34 Using Solver for financial planning \u003c\/li\u003e\n\u003cli\u003eChapter 35 Using Solver to rate sports teams \u003c\/li\u003e\n\u003cli\u003eChapter 36 Warehouse location and the GRG Multistart and Evolutionary Solver engines \u003c\/li\u003e\n\u003cli\u003eChapter 37 Penalties and the Evolutionary Solver \u003c\/li\u003e\n\u003cli\u003eChapter 38 The traveling salesperson problem \u003c\/li\u003e\n\u003cli\u003eChapter 39 Importing data from a text file or document \u003c\/li\u003e\n\u003cli\u003eChapter 40 Validating data \u003c\/li\u003e\n\u003cli\u003eChapter 41 Summarizing data by using histograms and Pareto charts \u003c\/li\u003e\n\u003cli\u003eChapter 42 Summarizing data by using descriptive statistics \u003c\/li\u003e\n\u003cli\u003eChapter 43 Using PivotTables and slicers to describe data \u003c\/li\u003e\n\u003cli\u003eChapter 44 The Data Model \u003c\/li\u003e\n\u003cli\u003eChapter 45 Power Pivot \u003c\/li\u003e\n\u003cli\u003eChapter 46 Power View and 3D Maps \u003c\/li\u003e\n\u003cli\u003eChapter 47 Sparklines \u003c\/li\u003e\n\u003cli\u003eChapter 48 Summarizing data with database statistical functions \u003c\/li\u003e\n\u003cli\u003eChapter 49 Filtering data and removing duplicates \u003c\/li\u003e\n\u003cli\u003eChapter 50 Consolidating data \u003c\/li\u003e\n\u003cli\u003eChapter 51 Creating subtotals \u003c\/li\u003e\n\u003cli\u003eChapter 52 Charting tricks \u003c\/li\u003e\n\u003cli\u003eChapter 53 Estimating straight-line relationships \u003c\/li\u003e\n\u003cli\u003eChapter 54 Modeling exponential growth \u003c\/li\u003e\n\u003cli\u003eChapter 55 The power curve \u003c\/li\u003e\n\u003cli\u003eChapter 56 Using correlations to summarize relationships \u003c\/li\u003e\n\u003cli\u003eChapter 57 Introduction to multiple regression \u003c\/li\u003e\n\u003cli\u003eChapter 58 Incorporating qualitative factors into multiple regression \u003c\/li\u003e\n\u003cli\u003eChapter 59 Modeling nonlinearities and interactions \u003c\/li\u003e\n\u003cli\u003eChapter 60 Analysis of variance: One-way ANOVA \u003c\/li\u003e\n\u003cli\u003eChapter 61 Randomized blocks and two-way ANOVA \u003c\/li\u003e\n\u003cli\u003eChapter 62 Using moving averages to understand time series \u003c\/li\u003e\n\u003cli\u003eChapter 63 Winters method \u003c\/li\u003e\n\u003cli\u003eChapter 64 Ratio-to-moving-average forecast method \u003c\/li\u003e\n\u003cli\u003eChapter 65 Forecasting in the presence of special events \u003c\/li\u003e\n\u003cli\u003eChapter 66 An introduction to probability \u003c\/li\u003e\n\u003cli\u003eChapter 67 An introduction to random variables \u003c\/li\u003e\n\u003cli\u003eChap\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"Microsoft Press,U.S.","offers":[{"title":"Default Title","offer_id":48885915222359,"sku":"9781509305889","price":32.29,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0817\/1739\/5799\/files\/9781509305889.jpg?v=1722538148"},{"product_id":"turning-spreadsheets-into-corporate-data-9781634622288","title":"Turning Spreadsheets into Corporate Data","description":"\u003cb\u003eBook Synopsis\u003c\/b\u003e\u003cbr\u003eFor years, business users have leveraged spreadsheets for storing and communicating data. Although spreadsheets may be easy to create and update, making important corporate decisions based on spreadsheets is risky due to the lack of data credibility. Whether you are a manager, developer, end user, or student, this book will help you turn spreadsheet data into credible, useful, reliable data that can be trusted in order to make important decisions. A chapter is dedicated to each of the following topics: Brief history of spreadsheets; Spreadsheet paradox; Spreadsheet varieties; The PDF spreadsheet; Spreadsheet formatting; Spreadsheet disambiguation; The intermediate database; The ssdef database; The corporate database; The metadata database (mnemonic database); Political considerations; Data modelling and the spreadsheet; Case study.","brand":"Technics Publications LLC","offers":[{"title":"Default Title","offer_id":48887162208599,"sku":"9781634622288","price":999.99,"currency_code":"GBP","in_stock":false}]},{"product_id":"excel-2016-in-easy-steps-9781840786514","title":"Excel 2016 in Easy Steps","description":"\u003cb\u003eBook Synopsis\u003c\/b\u003e\u003cbr\u003e\u003cp\u003e\u003cstrong\u003eExcel 2016 in easy steps\u003c\/strong\u003e will help you get to grips with the latest version of this popular spreadsheet application. Areas covered include:\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eCreating, editing and manipulating worksheets\u003c\/li\u003e\n\u003cli\u003eFormulas, Functions and Pivot Tables\u003c\/li\u003e\n\u003cli\u003eHandy templates to give you a head start\u003c\/li\u003e\n\u003cli\u003eMacros for everyday tasks to save time\u003c\/li\u003e\n\u003cli\u003eCharts to get an overview of your data\u003c\/li\u003e\n\u003cli\u003eLinking workbooks for automatic updates\u003c\/li\u003e\n\u003cli\u003eUsing the Excel Online app to share and collaborate on spreadsheets and workbooks\u003c\/li\u003e\n\u003cli\u003eAdding images and illustrations to your spreadsheet to impress your colleagues!\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eWhether you're upgrading to Excel 2016 or new to the spreadsheet concept, use this guide to learn the key features constructively and get more out of Excel 2016 \u003cstrong\u003ein easy steps\u003c\/strong\u003e!\u003c\/p\u003e","brand":"In Easy Steps Limited","offers":[{"title":"Default Title","offer_id":48888021385559,"sku":"9781840786514","price":999.99,"currency_code":"GBP","in_stock":false}]},{"product_id":"100-top-tips-microsoft-excel-9781840788792","title":"100 Top Tips - Microsoft Excel","description":"\u003cb\u003eBook Synopsis\u003c\/b\u003e\u003cbr\u003e\u003cp\u003e\u003cstrong\u003e100 Top Tips Microsoft Excel\u003c\/strong\u003e will help you boost your productivity and get more value from your spreadsheets with this powerful book of tips. It showcases: \u003c\/p\u003e\u003cli\u003eTime-saving features (including data entry shortcuts)\u003c\/li\u003e\u003cli\u003ePowerful functions for processing text and numbers\u003c\/li\u003e\u003cli\u003eInsightful data analysis features, including pivot tables and what-if analysis. \u003c\/li\u003e\u003cli\u003eHow to use graphs\u003c\/li\u003e\u003cli\u003eDebugging formulas\u003c\/li\u003e\u003cli\u003ePrinting clearly\u003c\/li\u003e\u003cp\u003eAnd much more!\u003c\/p\u003e\u003cp\u003eYou'll also discover how to use graphs, debug formulas, and print everything out cleanly. Whether you've been using Excel for years and never gone beyond the basics, or are just entering the world of spreadsheets, this book will quickly supercharge your skills.\u003c\/p\u003e\u003cp\u003eAs you would expect from the \u003cstrong\u003eIn Easy Steps\u003c\/strong\u003e brand the book is written in an approachable style with step by step instructions provided for many of the tips, and full colour screenshots guiding you through the processes. \u003c\/p\u003e","brand":"In Easy Steps Limited","offers":[{"title":"Default Title","offer_id":48888025448791,"sku":"9781840788792","price":7.49,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0817\/1739\/5799\/files\/9781840788792.jpg?v=1722547384"},{"product_id":"excel-functions-and-formulas-in-easy-steps-9781840788815","title":"Excel Functions and Formulas in easy steps","description":"\u003cb\u003eBook Synopsis\u003c\/b\u003e\u003cbr\u003e\u003cp\u003e\u003cstrong\u003eExcel Functions and Formulas in easy steps\u003c\/strong\u003e shows you how to use the power of Excel functions and formulas to take full advantage of this popular spreadsheet application. Learn how to:\u003c\/p\u003e\u003cli\u003e Save time by utilizing Excel functions to carry out often-used operations, for error checking and tracing cells.\u003c\/li\u003e\u003cli\u003eBuild powerful spreadsheets using the features of Excel formulas. \u003c\/li\u003e\u003cli\u003eExplore all the categories of Excel functions including financial, logical, mathematical, lookup and other data-related functions. \u003c\/li\u003e\u003cli\u003eReview business-oriented scenarios and examples of functions in each of the groups. \u003c\/li\u003e\u003cli\u003eCreate your own simple macros, and more. \u003c\/li\u003e\u003cp\u003eCovering all recent versions of Excel including Excel in Office 365, this book will guide you through a myriad of Excel functions and formulas clearly, concisely and \u003cstrong\u003ein easy steps\u003c\/strong\u003e!\u003c\/p\u003e","brand":"In Easy Steps Limited","offers":[{"title":"Default Title","offer_id":48888025481559,"sku":"9781840788815","price":999.99,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0817\/1739\/5799\/files\/9781840788815.jpg?v=1722547385"},{"product_id":"ocr-level-1-itq-unit-69-spreadsheet-software-using-microsoft-excel-2007-9781860058950","title":"OCR Level 1 ITQ - Unit 69 - Spreadsheet Software","description":"\u003cb\u003eBook Synopsis\u003c\/b\u003e\u003cbr\u003e","brand":"CiA Training Ltd","offers":[{"title":"Default Title","offer_id":48888189682007,"sku":"9781860058950","price":15.76,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0817\/1739\/5799\/files\/9781860058950.jpg?v=1722548161"},{"product_id":"microsoft-excel-functions-and-formulas-9781944534639","title":"Microsoft Excel Functions and Formulas","description":"\u003cb\u003eBook Synopsis\u003c\/b\u003e\u003cbr\u003eMicrosoft Excel Functions \u0026amp; Formulas 4\/e demonstrates the secrets of Excel through the use of practical and useful examples in a quick reference format. Easy to use and equipped with a variety of functions, Microsoft Excel is the tool of choice when it comes to crunching numbers, building charts, and analyzing tables.","brand":"Mercury Learning \u0026 Information","offers":[{"title":"Default Title","offer_id":48888835539287,"sku":"9781944534639","price":36.4,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0817\/1739\/5799\/files\/9781944534639.jpg?v=1722551368"},{"product_id":"drag-drop-ms-excel-2010-9788120757387","title":"Drag Drop Ms Excel 2010","description":"\u003cb\u003eBook Synopsis\u003c\/b\u003e\u003cbr\u003e","brand":"Sterling Publishers Pvt.Ltd","offers":[{"title":"Default Title","offer_id":48889469600087,"sku":"9788120757387","price":6.81,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0817\/1739\/5799\/files\/9788120757387.jpg?v=1722554511"},{"product_id":"excel-2002-training-guide-9788176566667","title":"Excel 2002 - Training Guide","description":"\u003cb\u003eBook Synopsis\u003c\/b\u003e\u003cbr\u003e","brand":"BPB Publications","offers":[{"title":"Default Title","offer_id":48889634881879,"sku":"9788176566667","price":5.48,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0817\/1739\/5799\/files\/9788176566667.jpg?v=1722555229"},{"product_id":"microsoft-excel-functions-and-formulas-9788183331821","title":"Microsoft: Excel Functions and Formulas","description":"\u003cb\u003eBook Synopsis\u003c\/b\u003e\u003cbr\u003e","brand":"BPB Publications","offers":[{"title":"Default Title","offer_id":48889704251735,"sku":"9788183331821","price":14.99,"currency_code":"GBP","in_stock":false}]},{"product_id":"microsoft-excel-2019-formulas-and-functions-9781509306190","title":"Microsoft Excel 2019 Formulas and Functions","description":"\u003cb\u003eBook Synopsis\u003c\/b\u003e\u003cbr\u003eMaster core Excel tools for building powerful, reliable spreadsheets with \u003ci\u003eExcel 2019 Formulas and Functions\u003c\/i\u003e. Excel expert Paul McFedries shows how to use Excel core features to solve problems and get the answers you need. Using real-world examples, McFedries helps you get the absolute most out of features and improvements ranging from AutoFill to Excel’s newest functions. Along the way, you discover the fastest, best ways to handle essential day-to-day tasks ranging from generating account numbers to projecting the impact of inflation. \u003cbr\u003e \u003cbr\u003eBecoming an Excel expert has never been easier! You’ll find crystal-clear instructions; insider insights; even complete step-by-step projects for building timesheets, projecting cash flow, aging receivables, analyzing defects, and more. \u003cbr\u003e \u003cbr\u003e• Quickly create powerful spreadsheets with range names and array formulas \u003cbr\u003e• Use conditional formatting to instantly reveal anomalies, problems, or opportunities \u003cbr\u003e• Analyze your data with standard tables and PivotTables \u003cbr\u003e• Use complex criteria to filter data in lists \u003cbr\u003e• Understand correlations between data \u003cbr\u003e• Perform sophisticated what-if analyses \u003cbr\u003e• Use regression to track trends and make forecasts \u003cbr\u003e• Build loan, investment, and discount formulas \u003cbr\u003e• Validate data, troubleshoot problems, and build more accurate, trustworthy spreadsheets \u003cbr\u003e\u003cbr\u003e\u003cbr\u003e\u003cb\u003eTable of Contents\u003c\/b\u003e\u003cbr\u003e\u003cp\u003e\u003cb\u003ePart I—Mastering Excel formulas\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 1—Building basic formulas \u003c\/p\u003e \u003cp\u003eChapter 2—Creating advanced formulas \u003c\/p\u003e \u003cp\u003eChapter 3—Troubleshooting formulas \u003c\/p\u003e \u003cp\u003e\u003cb\u003e\u003cbr\u003e\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart II—Harnessing the power of functions\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 4—Understanding functions\u003c\/p\u003e \u003cp\u003eChapter 5—Working with text functions \u003c\/p\u003e \u003cp\u003eChapter 6—Working with logical and information functions \u003c\/p\u003e \u003cp\u003eChapter 7—Working with lookup functions\u003c\/p\u003e \u003cp\u003eChapter 8—Working with date and time functions \u003c\/p\u003e \u003cp\u003eChapter 9—Working with math functions \u003c\/p\u003e \u003cp\u003e\u003cb\u003e\u003cbr\u003e\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart III—Building business formulas\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 10—Implementing basic business formulas \u003c\/p\u003e \u003cp\u003eChapter 11—Building descriptive statistical formulas \u003c\/p\u003e \u003cp\u003eChapter 12—Building inferential statistical formulas \u003c\/p\u003e \u003cp\u003eChapter 13—Applying regression to track trends and make forecasts \u003c\/p\u003e \u003cp\u003eChapter 14—Building loan formulas\u003c\/p\u003e \u003cp\u003eChapter 15—Working with investment formulas\u003c\/p\u003e \u003cp\u003eChapter 16—Building discount formulas \u003c\/p\u003e \u003cp\u003e\u003cb\u003e\u003cbr\u003e\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart IV—Building business models\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 17—Analyzing data with tables \u003c\/p\u003e \u003cp\u003eChapter 18—Analyzing data with PivotTables\u003c\/p\u003e \u003cp\u003eChapter 19—Using Excel's business modeling tools \u003c\/p\u003e Chapter 20—Solving complex problems with Solver","brand":"Microsoft Press,U.S.","offers":[{"title":"Default Title","offer_id":49084049031511,"sku":"9781509306190","price":25.49,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0817\/1739\/5799\/files\/9781509306190.jpg?v=1725550897"},{"product_id":"mrexcel-23-the-greatest-excel-tips-of-all-time-9781615470792","title":"MrExcel 23: The Greatest Excel Tips of All Time","description":"\u003cb\u003eBook Synopsis\u003c\/b\u003e\u003cbr\u003e\u003cb\u003eExcel tips to skyrocket white-collar productivity.\u003c\/b\u003e\u003cbr\u003e\u003cbr\u003e Originally designed for Bill Jelen's live Power Excel seminars, the target audience already uses Excel 40 hours a week. These tips are the \"aha\" tips that uncover secret methods in Excel. The book covers general Excel functions, pivot tables, and formulas such as VLOOKUP and the new XLOOKUP. It introduces elements of modern Excel such as the Power Pivot Data Model and cleaning data with Power Query. Updated annually, this edition for 2021 adds information on LET and LAMBDA functions, amazing new data types, dynamic array formulas, and more.\u003cbr\u003e\u003cbr\u003e\u003cb\u003eTable of Contents\u003c\/b\u003e\u003cbr\u003e1 - Fast Formula Copy2 - Break Apart Data3 - Convert text #'s4 - Filter by Selection5 - Total Visible Rows6 - The Fill Handle 1, 2, 3… 7 - Fast Worksheet Copy8 - Defaults Future WB9 - Recover Unsaved Workbooks10 - Search in File, Open11 - Show Changes 60 Days12 - Collab13 - Sheet View14 - Threaded Comments 15 - Perfect 1-Click Charts16 - Paste New Data on a Chart17 - Create Interactive Charts18 - Chart 2 Orders of Magnitude19 - Waterfall Charts20 - Funnel Charts21 - Map Charts22 - Bell Curve23 - Plot People on a Bell Curve24 - Data Visualizations25 - Cutout People26 - Semi-Transparent Image27 - Save any object as image28 - List Format29 - Sort Using a Custom List30 - Sort Left to Right31 - Sort Subtotals32 - Sort \u0026amp; Filter by Color \/ Icon33 - Consolidate Qtr Worksheets34 - Create Your First Pivot Table35 - PT Year-over-Year36 - Change PT Calculation37 - True Top 5 in a PT38 - Defaults for All Future PT39 - PT Expandable Using Ctrl+T40 - Replicate a PT for Each Rep41 - Use a PT to Compare Lists42 - Sparklines and Slicers43 - GETPIVOTDATA use44 - Ask a Question45 - Data Model to Eliminate XLOOKUP46 - Budg v. Act'l via Power Pivot47 - PT Slicers from 2 Data Sets48 - F4 for $A$1 or Repeat49 - Formulas to Values50 - See All Formulas51 - Audit With Inquire52 - New Fx by Using fx 53 - Fx Args Nested Fx54 - Nonstandard Work Weeks55 - Sideways with a Formula56 - Multiple Conditions IF57 - Troubleshoot VLOOKUP58 - Wildcard in Lookup59 - 12 Benefits of XLOOKUP60 - Preview Remove Duplicates61 - Nested IFs v. Lookup62 - Suppress Errors with IFERROR63 - Plural Conditions w\/ SUMIFS64 - Geo, XE \u0026amp; Stock Data Types 65 - STOCKHISTORY66 - Wolfram Alpha67 - Historical Weather for City68 - Create Data Types using PQ69 - Which language in Bilingual70 - Dynamic Arrays Can Spill71 - Sorting with a Formula72 - Filter with a Formula73 - Formula for Unique or Distinct74 - Fx Can Accept Arrays75 - 1 Hit Wonders with UNIQUE76 - SEQUENCE inside IPMT77 - Random #'s in Excel78 - PT with 3 DA79 - Dependent Validation DA80 - Complex Validation Formula81 - Stack Arrays82 - Drop, Take, Choose from Array83 - Reshaping Arrays84 - UNIQUE of Rectangular Range85 - Shuffle \u0026amp; Deal Cards86 - A2:INDEX() non-Volatile OFFSET87 - Microsoft 365 features88 - Perf Improvements89 - Unhide Multiple Worksheets90 - Action Pen91 - Take Panes Collapse92 - Feedback to the Excel Team93 - Date Tricks94 - LET95 - LAMBDA96 - Lamda helper functions97 - MAXIFS98 - TEXTBEFORE or AFTER99 - TEXTSPLIT100 - Less CSV Nagging+Autocomplete101 - Protect All Formula Cells102 - Goal Seek103 - Do 60 What-If Analyses104 - Solver105 - Interpolate106 - Improve Macro Recording107 - Clean Data Power Query108 - Fuzzy Match in PQ109 - PT on a Map 3D Maps110 - Forecast Seasonality111 - Sentiment Analysis112 - Visio Flowcharts113 - Fill in a Flash114 - Format as a Faç ade115 - Taskbar all open workbooks116 - Paste to Other Computer117 - Surveys \u0026amp; Forms in Excel118 - Windows Magnifier119 - Scrolling Tricks120 - Word for Excellers121 - Speak Cells122 - Customize QAT123 - QAT VBA Macros124 - Fav Keyb Shortcuts125 - Ctrl+Click to Unselect126 - Collapse the Search Box127 - More Excel Tips128 - Excel Stories129 - Quick Fx Reference","brand":"Holy Macro! Books","offers":[{"title":"Default Title","offer_id":49084193636695,"sku":"9781615470792","price":26.31,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0817\/1739\/5799\/files\/9781615470792.jpg?v=1725551353"},{"product_id":"mos-study-guide-for-microsoft-excel-expert-exam-mo201-9780136627524","title":"MOS Study Guide for Microsoft Excel Expert Exam","description":"\u003cb\u003eBook Synopsis\u003c\/b\u003e\u003cbr\u003e\u003cp style=\"margin:0px;\"\u003ePaul McFedries, a Microsoft Office expert and owner of the technical writing company Logophilia Limited, has authored nearly 100 books, including \u003ci\u003eMicrosoft Excel 2019 Formulas and Functions\u003c\/i\u003e. Combined, his books have sold more than 4 million copies worldwide.\u003c\/p\u003e\u003cbr\u003e\u003cbr\u003e\u003cb\u003eTable of Contents\u003c\/b\u003e\u003cbr\u003e\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eChapter 1 – Manage workbook options and settings\u003c\/strong\u003e \u003c\/li\u003e\n\u003cli\u003eObjective 1.1: Manage workbooks \u003c\/li\u003e\n\u003cli\u003eObjective 1.2: Prepare workbooks for collaboration \u003c\/li\u003e\n\u003cli\u003eObjective 1.3: Use and configure language options \u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eChapter 2 – Manage and format data\u003c\/strong\u003e \u003c\/li\u003e\n\u003cli\u003eObjective 2.1: Fill cells based on existing data \u003c\/li\u003e\n\u003cli\u003eObjective 2.2: Format and validate data \u003c\/li\u003e\n\u003cli\u003eObjective 2.3: Apply advanced conditional formatting and filtering \u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eChapter 3 – Create advanced formulas and macros\u003c\/strong\u003e \u003c\/li\u003e\n\u003cli\u003eObjective 3.1: Perform logical operations in formulas \u003c\/li\u003e\n\u003cli\u003eObjective 3.2: Look up data by using functions \u003c\/li\u003e\n\u003cli\u003eObjective 3.3: Apply advanced date and time functions \u003c\/li\u003e\n\u003cli\u003eObjective 3.4: Perform data analysis \u003c\/li\u003e\n\u003cli\u003eObjective 3.5: Troubleshoot formulas \u003c\/li\u003e\n\u003cli\u003eObjective 3.6: Create and modify simple macros \u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eChapter 4 – Manage advanced charts and tables\u003c\/strong\u003e \u003c\/li\u003e\n\u003cli\u003eObjective 4.1: Create and modify advanced charts \u003c\/li\u003e\n\u003cli\u003eObjective 4.2: Create and modify PivotTables \u003c\/li\u003e\n\u003cli\u003eObjective 4.3: Create and modify PivotCharts \u003c\/li\u003e\n\u003c\/ul\u003e","brand":"Pearson Education (US)","offers":[{"title":"Default Title","offer_id":49369130598743,"sku":"9780136627524","price":17.09,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0817\/1739\/5799\/files\/9780136627524.jpg?v=1730128507"},{"product_id":"microsoft-excel-2013-building-data-models-with-powerpivot-9780735676343","title":"Microsoft Excel 2013 Building Data Models with","description":"\u003cb\u003eBook Synopsis\u003c\/b\u003e\u003cbr\u003e\u003cp\u003e\u003cb\u003eAlberto Ferrari \u003c\/b\u003ehas achieved Microsoft SQL Server Analysis Services (SSAS) Maestro status and is a consultant and trainer who specializes in developing Microsoft BI solutions. He is the coauthor of Microsoft PowerPivot for Excel 2010 and Expert Cube Development with Microsoft SQL Server 2008 Analysis Services and SQLBI Methodology.\u003c\/p\u003e\u003cbr\u003e\u003cbr\u003e\u003cb\u003eTable of Contents\u003c\/b\u003e\u003cbr\u003e\u003cul\u003e\n\u003cli\u003e Introduction \u003c\/li\u003e\n\u003cli\u003e Chapter 1: Introduction to PowerPivot \u003c\/li\u003e\n\u003cli\u003e Chapter 2: Using the unique features of PowerPivot \u003c\/li\u003e\n\u003cli\u003e Chapter 3: Introducing DAX \u003c\/li\u003e\n\u003cli\u003e Chapter 4: Understanding data models \u003c\/li\u003e\n\u003cli\u003e Chapter 5: Publishing to SharePoint \u003c\/li\u003e\n\u003cli\u003e Chapter 6: Loading data \u003c\/li\u003e\n\u003cli\u003e Chapter 7: Understanding evaluation contexts \u003c\/li\u003e\n\u003cli\u003e Chapter 8: Understanding CALCULATE \u003c\/li\u003e\n\u003cli\u003e Chapter 9: Using hierarchies \u003c\/li\u003e\n\u003cli\u003e Chapter 10: Using Power View \u003c\/li\u003e\n\u003cli\u003e Chapter 11: Shaping the reports \u003c\/li\u003e\n\u003cli\u003e Chapter 12: Performing date calculations in DAX \u003c\/li\u003e\n\u003cli\u003e Chapter 13: Using advanced DAX \u003c\/li\u003e\n\u003cli\u003e Chapter 14: Using DAX as a query language \u003c\/li\u003e\n\u003cli\u003e Chapter 15: Automating operations using VBA \u003c\/li\u003e\n\u003cli\u003e Chapter 16: Comparing Excel and SQL Server Analysis Services \u003c\/li\u003e\n\u003cli\u003e About the Authors \u003c\/li\u003e\n\u003c\/ul\u003e","brand":"Microsoft Press,U.S.","offers":[{"title":"Default Title","offer_id":49371750531415,"sku":"9780735676343","price":26.54,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0817\/1739\/5799\/files\/9780735676343.jpg?v=1730154407"},{"product_id":"reverse-engineering-deals-on-wall-street-with-microsoft-excel-website-9780470242056","title":"Reverse Engineering Deals on Wall Street with","description":"\u003cb\u003eBook Synopsis\u003c\/b\u003e\u003cbr\u003e\u003cb\u003eA serious source of information for those looking to reverse engineer business deals\u003c\/b\u003e \u003cp\u003eIt's clear from the current turbulence on Wall Street that the inner workings of its most complex transactions are poorly understood. Wall Street deals parse risk using intricate legal terminology that is difficult to translate into an analytical model. \u003ci\u003eReverse Engineering Deals on Wall Street: A Step-By-Step Guide\u003c\/i\u003e takes readers through a detailed methodology of deconstructing the public deal documentation of a modern Wall Street transaction and applying the deconstructed elements to create a fully dynamic model that can be used for risk and investment analysis.\u003c\/p\u003e \u003cp\u003eAppropriate for the current market climate, an actual residential mortgage backed security (RMBS) transaction is taken from prospectus to model by the end of the book. Step by step, Allman walks the reader through the reversing process with textual excerpts from the prospectus and discussions on how it directly transfer\u003cbr\u003e\u003cbr\u003e\u003cb\u003eTable of Contents\u003c\/b\u003e\u003cbr\u003ePreface. \u003c\/p\u003e\u003cp\u003eAcknowledgments.\u003c\/p\u003e \u003cp\u003eAbout the Author.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCHAPTER 1: Introduction.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eThe Transaction.\u003c\/p\u003e \u003cp\u003eThe Documents.\u003c\/p\u003e \u003cp\u003eThe Process.\u003c\/p\u003e \u003cp\u003eHow This Book Works.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCHAPTER 2: Determining Dates and Setting Up Timing.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eDifferences in Timing Approaches.\u003c\/p\u003e \u003cp\u003eA First Look at the Prospectus.\u003c\/p\u003e \u003cp\u003eImportant Dates.\u003c\/p\u003e \u003cp\u003eTransforming Dates and Timing from Words to a Model.\u003c\/p\u003e \u003cp\u003eModel Builder 2.1: Reversing Dates and Timing.\u003c\/p\u003e \u003cp\u003eConclusion of Dates and Timing.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCHAPTER 3: Creating Asset Cash Flow from Prospectus Data.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eIt’s All in the Prospectus Supplement.\u003c\/p\u003e \u003cp\u003eThe Basics of Amortization.\u003c\/p\u003e \u003cp\u003ePerformance and the Prospectus Supplement.\u003c\/p\u003e \u003cp\u003eDelinquency.\u003c\/p\u003e \u003cp\u003eLoss.\u003c\/p\u003e \u003cp\u003ePrepayment.\u003c\/p\u003e \u003cp\u003eRecovery.\u003c\/p\u003e \u003cp\u003eCreating Cash Flow.\u003c\/p\u003e \u003cp\u003eA Complex Implementation.\u003c\/p\u003e \u003cp\u003eModel Builder 3.1: Entering in the Raw Asset Information.\u003c\/p\u003e \u003cp\u003eModel Builder 3.2: Entering in the Default and Prepayment Assumptions.\u003c\/p\u003e \u003cp\u003eModel Builder 3.3: Interest Rates and Additional Asset Amortization Inputs.\u003c\/p\u003e \u003cp\u003eModel Builder 3.4: Introducing VBA and Moving Data In and Out of the Model.\u003c\/p\u003e \u003cp\u003eModel Builder 3.5: Loading Loan Performance Assumptions into VBA.\u003c\/p\u003e \u003cp\u003eModel Builder 3.6: Global Functions.\u003c\/p\u003e \u003cp\u003eModel Builder 3.7: Loan-Level Asset Amortization.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCHAPTER 4: Setting Up Liability Assumptions, Paying Fees, and Distributing Interest.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eIdentifying the Offered Securities.\u003c\/p\u003e \u003cp\u003eModel Builder 4.1: Transferring the Liability Information to a Consolidated Sheet.\u003c\/p\u003e \u003cp\u003eThe Liability Waterfall: A System of Priority.\u003c\/p\u003e \u003cp\u003eModel Builder 4.2: Starting the Waterfall with Fees.\u003c\/p\u003e \u003cp\u003eInterest: No Financing Is Free.\u003c\/p\u003e \u003cp\u003eModel Builder 4.3: Continuing the Waterfall with Interest Paid to the Certificate Holders.\u003c\/p\u003e \u003cp\u003eMore on Waterfalls and Wall Street’s Risk Parsing.\u003c\/p\u003e \u003cp\u003eModel Builder 4.4: Mezzanine Interest.\u003c\/p\u003e \u003cp\u003eContinuing the Waterfall: It Only Gets More Complicated.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCHAPTER 5: Principal Repayment and the Shifting Nature of a Wall Street Deal.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eModel Builder 5.1: The Deal State and Senior Principal.\u003c\/p\u003e \u003cp\u003eMezzanine Principal Returns.\u003c\/p\u003e \u003cp\u003eModel Builder 5.2: The Mezzanine Certificates’ Priority of Payments.\u003c\/p\u003e \u003cp\u003eNumber Games or Risk Parsing?\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCHAPTER 6: Credit Enhancement Mechanisms to Mitigate Loss.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eModel Builder 6.1: Excess Spread, Overcollateralization, and Credit Enhancement.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCHAPTER 7: Auditing the Model.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eModel Builder 7.1.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCHAPTER 8: Conclusion of Example Transaction and Final Thoughts on Reverse Engineering.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eMortgage Insurance and Servicer Advances.\u003c\/p\u003e \u003cp\u003eReverse Engineering in the Current and Future Market.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eAppendix.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eAutomatic Range Naming.\u003c\/p\u003e \u003cp\u003eAbout the CD-ROM.\u003c\/p\u003e \u003cp\u003eIndex.\u003c\/p\u003e","brand":"John Wiley \u0026 Sons Inc","offers":[{"title":"Default Title","offer_id":49402307576151,"sku":"9780470242056","price":56.25,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0817\/1739\/5799\/files\/9780470242056.jpg?v=1730480016"},{"product_id":"excel-for-chemists-with-cdrom-9780470381236","title":"Excel for Chemists with CDROM","description":"\u003cb\u003eBook Synopsis\u003c\/b\u003e\u003cbr\u003eReviews from previous editions: \"Excel for Chemists should be part of any academic library offering courses and programs in Chemistry. \" Choice \"I highly recommend the book; treat yourself to it; assign it to a class; give it as a gift.\u003cbr\u003e\u003cbr\u003e\u003cb\u003eTrade Review\u003c\/b\u003e\u003cbr\u003e\u003cp\u003e“Finally this new edition, provides chemists and students a detailed guide and examples how to apply the current versions of Excel to their needs. It should be added to the shelves of those using this program within their scientific work.” (\u003ci\u003eMaterials and Corrosion\u003c\/i\u003e, 1 November 2012)\u003c\/p\u003e\u003cbr\u003e\u003cbr\u003e\u003cb\u003eTable of Contents\u003c\/b\u003e\u003cbr\u003e\u003cp\u003ePreface to the Third Edition xxv\u003c\/p\u003e \u003cp\u003eBefore You Begin xxvii\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart I The Basics\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 1 Working with Excel 2007 or Excel 2010 3\u003c\/p\u003e \u003cp\u003eChapter 2 Working with Excel 2003 79\u003c\/p\u003e \u003cp\u003eChapter 3 Excel Formulas and Functions 137\u003c\/p\u003e \u003cp\u003eChapter 4 Excel 2007\/2010 Charts 177\u003c\/p\u003e \u003cp\u003eChapter 5 Excel 2003 Charts 209\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart II Advanced Spreadsheet Topics\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 6 Advanced Worksheet Formulas 233\u003c\/p\u003e \u003cp\u003eChapter 7 Array Formulas 267\u003c\/p\u003e \u003cp\u003eChapter 8 Advanced Charting Techniques 289\u003c\/p\u003e \u003cp\u003eChapter 9 Using Excel's Database Features 327\u003c\/p\u003e \u003cp\u003eChapter 10 Importing Data into Excel 349\u003c\/p\u003e \u003cp\u003eChapter 11 Adding Controls to a Spreadsheet 365\u003c\/p\u003e \u003cp\u003eChapter 12 Other Language Versions of Excel 385\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart III Spreadsheet Mathematics\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 13 Mathematical Methods for Spreadsheet Calculations 403\u003c\/p\u003e \u003cp\u003eChapter 14 Linear Regression and Curve Fitting 435\u003c\/p\u003e \u003cp\u003eChapter 15 Nonlinear Regression Using the Solver 463\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart IV Excel's Visual Basic for Applications\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 16 Visual Basic for Applications: An Introduction 491\u003c\/p\u003e \u003cp\u003eChapter 17 Programming with VBA 503\u003c\/p\u003e \u003cp\u003eChapter 18 Working with Arrays in VBA 543\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart V Some Applications of VBA\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 19 Command Macros 557\u003c\/p\u003e \u003cp\u003eChapter 20 Custom Functions 571\u003c\/p\u003e \u003cp\u003eChapter 21 Automatic Procedures 589\u003c\/p\u003e \u003cp\u003eChapter 22 Custom Menus 595\u003c\/p\u003e \u003cp\u003eChapter 23 Custom Toolbars and Toolbuttons 607\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart VI Appendices\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eAppendix A What's Where in Excel 2007\/2010 629\u003c\/p\u003e \u003cp\u003eAppendix B Selected Worksheet Functions by Category 633\u003c\/p\u003e \u003cp\u003eAppendix C Alphabetical List of Selected Worksheet Functions 639\u003c\/p\u003e \u003cp\u003eAppendix D Renamed Functions in Excel 2010 661\u003c\/p\u003e \u003cp\u003eAppendix E Selected Visual Basic Keywords by Category 663\u003c\/p\u003e \u003cp\u003eAppendix F Alphabetical List of Selected Visual Basic Keywords 667\u003c\/p\u003e \u003cp\u003eAppendix G Selected Excel 4 Macro Functions 689\u003c\/p\u003e \u003cp\u003eAppendix H Shortcut Keys by Keystroke 693\u003c\/p\u003e \u003cp\u003eAppendix I Selected Shortcut Keys by Category 703\u003c\/p\u003e \u003cp\u003eAppendix J ASCII Codes 707\u003c\/p\u003e \u003cp\u003eAppendix K Contents of the CD-ROM 709\u003c\/p\u003e \u003cp\u003eIndex 719\u003c\/p\u003e","brand":"John Wiley \u0026 Sons Inc","offers":[{"title":"Default Title","offer_id":49402319143255,"sku":"9780470381236","price":53.96,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0817\/1739\/5799\/files\/9780470381236.jpg?v=1730480056"},{"product_id":"excel-2010-for-dummies-9780470489536","title":"Excel 2010 For Dummies","description":"\u003cb\u003eBook Synopsis\u003c\/b\u003e\u003cbr\u003eThe bestselling Excel book on the market, updated for Excel 2010 As the world's leading spreadsheet application, Excel has a huge user base.\u003cbr\u003e\u003cbr\u003e\u003cb\u003eTable of Contents\u003c\/b\u003e\u003cbr\u003e\u003cp\u003eIntroduction 1\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart I: Getting In on the Ground Floor 9\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 1: The Excel 2010 User Experience 11\u003c\/p\u003e \u003cp\u003eChapter 2: Creating a Spreadsheet from Scratch 49\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart II: Editing without Tears 95\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 3: Making It All Look Pretty 97\u003c\/p\u003e \u003cp\u003eChapter 4: Going Through Changes 145\u003c\/p\u003e \u003cp\u003eChapter 5: Printing the Masterpiece 175\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart III: Getting Organized and Staying That Way 199\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 6: Maintaining the Worksheet 201\u003c\/p\u003e \u003cp\u003eChapter 7: Maintaining Multiple Worksheets 229\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart IV: Digging Data Analysis 253\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 8: Doing What-If Analysis 255\u003c\/p\u003e \u003cp\u003eChapter 9: Playing with Pivot Tables 267\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart V: Life beyond the Spreadsheet 283\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 10: Charming Charts and Gorgeous Graphics 285\u003c\/p\u003e \u003cp\u003eChapter 11: Getting on the Data List 319\u003c\/p\u003e \u003cp\u003eChapter 12: Linking, Automating, and Sharing Spreadsheets 345\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart VI: The Part of Tens 363\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 13: Top Ten Features in Excel 2010 365\u003c\/p\u003e \u003cp\u003eChapter 14: Top Ten Beginner Basics 369\u003c\/p\u003e \u003cp\u003eChapter 15: The Ten Commandments of Excel 2010 371\u003c\/p\u003e \u003cp\u003eIndex 373\u003c\/p\u003e","brand":"John Wiley \u0026 Sons Inc","offers":[{"title":"Default Title","offer_id":49402342375767,"sku":"9780470489536","price":999.99,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0817\/1739\/5799\/files\/9780470489536.jpg?v=1730480124"},{"product_id":"credit-risk-modeling-using-excel-and-vba-9780470660928","title":"Credit Risk Modeling using Excel and VBA","description":"\u003cb\u003eBook Synopsis\u003c\/b\u003e\u003cbr\u003eIt is common to blame the inadequacy of credit risk models for the fact that the financial crisis has caught many market participants by surprise. On closer inspection, though, it often appears that market participants failed to understand or to use the models correctly.\u003cbr\u003e\u003cbr\u003e\u003cb\u003eTable of Contents\u003c\/b\u003e\u003cbr\u003e\u003cp\u003ePreface to the 2nd edition xi\u003c\/p\u003e \u003cp\u003ePreface to the 1st edition xiii\u003c\/p\u003e \u003cp\u003eSome Hints for Troubleshooting xv\u003c\/p\u003e \u003cp\u003e\u003cb\u003e1 Estimating Credit Scores with Logit 1\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eLinking scores, default probabilities and observed default behavior 1\u003c\/p\u003e \u003cp\u003eEstimating logit coefficients in Excel 4\u003c\/p\u003e \u003cp\u003eComputing statistics after model estimation 8\u003c\/p\u003e \u003cp\u003eInterpreting regression statistics 10\u003c\/p\u003e \u003cp\u003ePrediction and scenario analysis 12\u003c\/p\u003e \u003cp\u003eTreating outliers in input variables 16\u003c\/p\u003e \u003cp\u003eChoosing the functional relationship between the score and explanatory variables 20\u003c\/p\u003e \u003cp\u003eConcluding remarks 25\u003c\/p\u003e \u003cp\u003eAppendix 25\u003c\/p\u003e \u003cp\u003eLogit and probit 25\u003c\/p\u003e \u003cp\u003eMarginal effects 25\u003c\/p\u003e \u003cp\u003eNotes and literature 26\u003c\/p\u003e \u003cp\u003e\u003cb\u003e2 The Structural Approach to Default Prediction and Valuation 27\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eDefault and valuation in a structural model 27\u003c\/p\u003e \u003cp\u003eImplementing the Merton model with a one-year horizon 30\u003c\/p\u003e \u003cp\u003eThe iterative approach 30\u003c\/p\u003e \u003cp\u003eA solution using equity values and equity volatilities 35\u003c\/p\u003e \u003cp\u003eImplementing the Merton model with a T -year horizon 39\u003c\/p\u003e \u003cp\u003eCredit spreads 43\u003c\/p\u003e \u003cp\u003eCreditGrades 44\u003c\/p\u003e \u003cp\u003eAppendix 50\u003c\/p\u003e \u003cp\u003eNotes and literature 52\u003c\/p\u003e \u003cp\u003eAssumptions 52\u003c\/p\u003e \u003cp\u003eLiterature 53\u003c\/p\u003e \u003cp\u003e\u003cb\u003e3 Transition Matrices 55\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eCohort approach 56\u003c\/p\u003e \u003cp\u003eMulti-period transitions 61\u003c\/p\u003e \u003cp\u003eHazard rate approach 63\u003c\/p\u003e \u003cp\u003eObtaining a generator matrix from a given transition matrix 69\u003c\/p\u003e \u003cp\u003eConfidence intervals with the binomial distribution 71\u003c\/p\u003e \u003cp\u003eBootstrapped confidence intervals for the hazard approach 74\u003c\/p\u003e \u003cp\u003eNotes and literature 78\u003c\/p\u003e \u003cp\u003eAppendix 78\u003c\/p\u003e \u003cp\u003eMatrix functions 78\u003c\/p\u003e \u003cp\u003e\u003cb\u003e4 Prediction of Default and Transition Rates 83\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eCandidate variables for prediction 83\u003c\/p\u003e \u003cp\u003ePredicting investment-grade default rates with linear regression 85\u003c\/p\u003e \u003cp\u003ePredicting investment-grade default rates with Poisson regression 88\u003c\/p\u003e \u003cp\u003eBacktesting the prediction models 94\u003c\/p\u003e \u003cp\u003ePredicting transition matrices 99\u003c\/p\u003e \u003cp\u003eAdjusting transition matrices 100\u003c\/p\u003e \u003cp\u003eRepresenting transition matrices with a single parameter 101\u003c\/p\u003e \u003cp\u003eShifting the transition matrix 103\u003c\/p\u003e \u003cp\u003eBacktesting the transition forecasts 108\u003c\/p\u003e \u003cp\u003eScope of application 108\u003c\/p\u003e \u003cp\u003eNotes and literature 110\u003c\/p\u003e \u003cp\u003eAppendix 110\u003c\/p\u003e \u003cp\u003e\u003cb\u003e5 Prediction of Loss Given Default 115\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eCandidate variables for prediction 115\u003c\/p\u003e \u003cp\u003eInstrument-related variables 116\u003c\/p\u003e \u003cp\u003eFirm-specific variables 117\u003c\/p\u003e \u003cp\u003eMacroeconomic variables 118\u003c\/p\u003e \u003cp\u003eIndustry variables 118\u003c\/p\u003e \u003cp\u003eCreating a data set 119\u003c\/p\u003e \u003cp\u003eRegression analysis of LGD 120\u003c\/p\u003e \u003cp\u003eBacktesting predictions 123\u003c\/p\u003e \u003cp\u003eNotes and literature 126\u003c\/p\u003e \u003cp\u003eAppendix 126\u003c\/p\u003e \u003cp\u003e\u003cb\u003e6 Modeling and Estimating Default Correlations with the Asset Value Approach 131\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eDefault correlation, joint default probabilities and the asset value approach 131\u003c\/p\u003e \u003cp\u003eCalibrating the asset value approach to default experience: the method of moments 133\u003c\/p\u003e \u003cp\u003eEstimating asset correlation with maximum likelihood 136\u003c\/p\u003e \u003cp\u003eExploring the reliability of estimators with a Monte Carlo study 144\u003c\/p\u003e \u003cp\u003eConcluding remarks 147\u003c\/p\u003e \u003cp\u003eNotes and literature 147\u003c\/p\u003e \u003cp\u003e\u003cb\u003e7 Measuring Credit Portfolio Risk with the Asset Value Approach 149\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eA default-mode model implemented in the spreadsheet 149\u003c\/p\u003e \u003cp\u003eVBA implementation of a default-mode model 152\u003c\/p\u003e \u003cp\u003eImportance sampling 156\u003c\/p\u003e \u003cp\u003eQuasi Monte Carlo 160\u003c\/p\u003e \u003cp\u003eAssessing Simulation Error 162\u003c\/p\u003e \u003cp\u003eExploiting portfolio structure in the VBA program 165\u003c\/p\u003e \u003cp\u003eDealing with parameter uncertainty 168\u003c\/p\u003e \u003cp\u003eExtensions 170\u003c\/p\u003e \u003cp\u003eFirst extension: Multi-factor model 170\u003c\/p\u003e \u003cp\u003eSecond extension: t-distributed asset values 171\u003c\/p\u003e \u003cp\u003eThird extension: Random LGDs 173\u003c\/p\u003e \u003cp\u003eFourth extension: Other risk measures 175\u003c\/p\u003e \u003cp\u003eFifth extension: Multi-state modeling 177\u003c\/p\u003e \u003cp\u003eNotes and literature 179\u003c\/p\u003e \u003cp\u003e\u003cb\u003e8 Validation of Rating Systems 181\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eCumulative accuracy profile and accuracy ratios 182\u003c\/p\u003e \u003cp\u003eReceiver operating characteristic (ROC) 185\u003c\/p\u003e \u003cp\u003eBootstrapping confidence intervals for the accuracy ratio 187\u003c\/p\u003e \u003cp\u003eInterpreting caps and ROCs 190\u003c\/p\u003e \u003cp\u003eBrier score 191\u003c\/p\u003e \u003cp\u003eTesting the calibration of rating-specific default probabilities 192\u003c\/p\u003e \u003cp\u003eValidation strategies 195\u003c\/p\u003e \u003cp\u003eTesting for missing information 198\u003c\/p\u003e \u003cp\u003eNotes and literature 201\u003c\/p\u003e \u003cp\u003e\u003cb\u003e9 Validation of Credit Portfolio Models 203\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eTesting distributions with the Berkowitz test 203\u003c\/p\u003e \u003cp\u003eExample implementation of the Berkowitz test 206\u003c\/p\u003e \u003cp\u003eRepresenting the loss distribution 207\u003c\/p\u003e \u003cp\u003eSimulating the critical chi-square value 209\u003c\/p\u003e \u003cp\u003eTesting modeling details: Berkowitz on subportfolios 211\u003c\/p\u003e \u003cp\u003eAssessing power 214\u003c\/p\u003e \u003cp\u003eScope and limits of the test 216\u003c\/p\u003e \u003cp\u003eNotes and literature 217\u003c\/p\u003e \u003cp\u003e\u003cb\u003e10 Credit Default Swaps and Risk-Neutral Default Probabilities 219\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eDescribing the term structure of default: PDs cumulative, marginal and seen from today 220\u003c\/p\u003e \u003cp\u003eFrom bond prices to risk-neutral default probabilities 221\u003c\/p\u003e \u003cp\u003eConcepts and formulae 221\u003c\/p\u003e \u003cp\u003eImplementation 225\u003c\/p\u003e \u003cp\u003ePricing a CDS 232\u003c\/p\u003e \u003cp\u003eRefining the PD estimation 234\u003c\/p\u003e \u003cp\u003eMarket values for a CDS 237\u003c\/p\u003e \u003cp\u003eExample 239\u003c\/p\u003e \u003cp\u003eEstimating upfront CDS and the ‘Big Bang’ protocol 240\u003c\/p\u003e \u003cp\u003ePricing of a pro-rata basket 241\u003c\/p\u003e \u003cp\u003eForward CDS spreads 242\u003c\/p\u003e \u003cp\u003eExample 243\u003c\/p\u003e \u003cp\u003ePricing of swaptions 243\u003c\/p\u003e \u003cp\u003eNotes and literature 247\u003c\/p\u003e \u003cp\u003eAppendix 247\u003c\/p\u003e \u003cp\u003eDeriving the hazard rate for a CDS 247\u003c\/p\u003e \u003cp\u003e\u003cb\u003e11 Risk Analysis and Pricing of Structured Credit: CDOs and First-to-Default\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eSwaps 249\u003c\/p\u003e \u003cp\u003eEstimating CDO risk with Monte Carlo simulation 249\u003c\/p\u003e \u003cp\u003eThe large homogeneous portfolio (LHP) approximation 253\u003c\/p\u003e \u003cp\u003eSystemic risk of CDO tranches 256\u003c\/p\u003e \u003cp\u003eDefault times for first-to-default swaps 259\u003c\/p\u003e \u003cp\u003eCDO pricing in the LHP framework 263\u003c\/p\u003e \u003cp\u003eSimulation-based CDO pricing 272\u003c\/p\u003e \u003cp\u003eNotes and literature 281\u003c\/p\u003e \u003cp\u003eAppendix 282\u003c\/p\u003e \u003cp\u003eClosed-form solution for the LHP model 282\u003c\/p\u003e \u003cp\u003eCholesky decomposition 283\u003c\/p\u003e \u003cp\u003eEstimating PD structure from a CDS 284\u003c\/p\u003e \u003cp\u003e\u003cb\u003e12 Basel II and Internal Ratings 285\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eCalculating capital requirements in the Internal Ratings-Based (IRB) approach 285\u003c\/p\u003e \u003cp\u003eAssessing a given grading structure 288\u003c\/p\u003e \u003cp\u003eTowards an optimal grading structure 294\u003c\/p\u003e \u003cp\u003eNotes and literature 297\u003c\/p\u003e \u003cp\u003eAppendix A1 Visual Basics for Applications (VBA) 299\u003c\/p\u003e \u003cp\u003eAppendix A2 Solver 307\u003c\/p\u003e \u003cp\u003eAppendix A3 Maximum Likelihood Estimation and Newton’s Method 313\u003c\/p\u003e \u003cp\u003eAppendix A4 Testing and Goodness of Fit 319\u003c\/p\u003e \u003cp\u003eAppendix A5 User-defined Functions 325\u003c\/p\u003e \u003cp\u003eIndex 333\u003c\/p\u003e","brand":"John Wiley \u0026 Sons Inc","offers":[{"title":"Default Title","offer_id":49402395590999,"sku":"9780470660928","price":69.35,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0817\/1739\/5799\/files\/9780470660928.jpg?v=1730480271"},{"product_id":"cash-cdo-modeling-in-excel-9780470741573","title":"Cash CDO Modeling in Excel","description":"\u003cb\u003eBook Synopsis\u003c\/b\u003e\u003cbr\u003eThis book is an introduction to the modelling of cash collateralised debt obligations (CDOs). It is intended that the reader have a basic understanding of CDOs and a basic working knowledge of Microsoft Office Excel. There will be written explanations of concepts along with understandable mathematical explanations and examples provided in Excel.\u003cbr\u003e\u003cbr\u003e\u003cb\u003eTable of Contents\u003c\/b\u003e\u003cbr\u003eForeword. \u003cp\u003eAcknowledgments.\u003c\/p\u003e \u003cp\u003e\u003cb\u003e1 Introduction.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e1.1 To Excel or Not to Excel?\u003c\/p\u003e \u003cp\u003e1.2 Existing Tools and Software.\u003c\/p\u003e \u003cp\u003e\u003cb\u003e2 What is a Cash CDOs?\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e2.1 Types of CDOs.\u003c\/p\u003e \u003cp\u003e2.2 Description of a Cash Flow CDO.\u003c\/p\u003e \u003cp\u003e2.3 Life Cycle of a Cash CDO.\u003c\/p\u003e \u003cp\u003e2.4 Contribution to the “Credit Crunch”.\u003c\/p\u003e \u003cp\u003e\u003cb\u003e3 Introduction to Modelling.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e3.1 Goals in Modelling.\u003c\/p\u003e \u003cp\u003e3.2 Modelling Philosophies and Trade-Offs.\u003c\/p\u003e \u003cp\u003e3.3 Flexibility.\u003c\/p\u003e \u003cp\u003e3.4 Organization and Layout of a Model.\u003c\/p\u003e \u003cp\u003e3.5 Life-Cycle Issues: Building an Adaptable Model.\u003c\/p\u003e \u003cp\u003e\u003cb\u003e4 Prerequisites to Cash Flow Modelling.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e4.1 Modelling Dates.\u003c\/p\u003e \u003cp\u003e4.2 Interest Rate Curve Modelling.\u003c\/p\u003e \u003cp\u003e4.3 Present Value Modelling.\u003c\/p\u003e \u003cp\u003e\u003cb\u003e5 Getting Started.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e5.1 Create the Input Sheet.\u003c\/p\u003e \u003cp\u003e5.2 The Value of Labelling.\u003c\/p\u003e \u003cp\u003e\u003cb\u003e6 Modelling Assets.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e6.1 Initial Asset Pool: Rep Line Modelling vs. Actual Assets.\u003c\/p\u003e \u003cp\u003e6.2 The Collateral Sheet in the Cash Flow Model.\u003c\/p\u003e \u003cp\u003e6.3 Modelling Defaults and Recoveries.\u003c\/p\u003e \u003cp\u003e6.4 Amortization.\u003c\/p\u003e \u003cp\u003e6.5 Modelling Reinvestment.\u003c\/p\u003e \u003cp\u003e6.6 Reinvestment Cohorts.\u003c\/p\u003e \u003cp\u003e6.7 Accounts.\u003c\/p\u003e \u003cp\u003e6.8 Timing Models vs. Actual Timing.\u003c\/p\u003e \u003cp\u003e6.9 Simple Warehouse Modelling.\u003c\/p\u003e \u003cp\u003e\u003cb\u003e7 Basic Waterfall Modelling.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e7.1 Basic Waterfalls.\u003c\/p\u003e \u003cp\u003e7.2 Layout and Design.\u003c\/p\u003e \u003cp\u003e7.3 Avoiding Negative Values.\u003c\/p\u003e \u003cp\u003e7.4 Timing Modelled vs. Actual Timing.\u003c\/p\u003e \u003cp\u003e7.5 Liabilities Cash Flows.\u003c\/p\u003e \u003cp\u003e7.6 Fees and Expenses Cash Flows.\u003c\/p\u003e \u003cp\u003e7.7 Interest Waterfall.\u003c\/p\u003e \u003cp\u003e7.8 Interest Waterfall (Available Funds after Payment).\u003c\/p\u003e \u003cp\u003e7.9 Interest Waterfall Calculations.\u003c\/p\u003e \u003cp\u003e7.10 Principal Waterfall.\u003c\/p\u003e \u003cp\u003e7.11 Principle Waterfall (Available Funds after Payment).\u003c\/p\u003e \u003cp\u003e7.12 Principal Waterfall Calculations.\u003c\/p\u003e \u003cp\u003e7.13 Adding Over-Collaterization Tests.\u003c\/p\u003e \u003cp\u003e7.14 Adding Interest Coverage Tests.\u003c\/p\u003e \u003cp\u003e7.15 Technical Issues with Coverage Tests.\u003c\/p\u003e \u003cp\u003e\u003cb\u003e8 Outputs Sheet.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e8.1 Purpose of the Outputs Sheet.\u003c\/p\u003e \u003cp\u003e8.2 Collating Waterfall Outputs.\u003c\/p\u003e \u003cp\u003e8.3 Present Value.\u003c\/p\u003e \u003cp\u003e8.4 Duration.\u003c\/p\u003e \u003cp\u003e8.5 Weighted Average Life and Internal Rate of Return.\u003c\/p\u003e \u003cp\u003e8.6 Equity Analysis.\u003c\/p\u003e \u003cp\u003e8.7 Basic Auditing.\u003c\/p\u003e \u003cp\u003e\u003cb\u003e9 Moody’s Rating Agency Methodology.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e9.1 Introduction to Agency Methodologies.\u003c\/p\u003e \u003cp\u003e9.2 The Bet Approach.\u003c\/p\u003e \u003cp\u003e9.3 Evaluating the Collateral.\u003c\/p\u003e \u003cp\u003e9.4 Creating the Moody’s Sheet and Related References in the Cash Flow Model.\u003c\/p\u003e \u003cp\u003e9.5 Default Profiles.\u003c\/p\u003e \u003cp\u003e9.6 Interest Rate Profiles.\u003c\/p\u003e \u003cp\u003e9.7 Running the Analysis.\u003c\/p\u003e \u003cp\u003e9.8 Variations on the BET.\u003c\/p\u003e \u003cp\u003e9.9 2009 Methodology Update.\u003c\/p\u003e \u003cp\u003e\u003cb\u003e10 Standard \u0026amp; Poor’s Rating Methodology.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e10.1 The S\u0026amp;P Approach.\u003c\/p\u003e \u003cp\u003e10.2 Evaluating the Collateral.\u003c\/p\u003e \u003cp\u003e10.3 Modelling Recovery Rates.\u003c\/p\u003e \u003cp\u003e10.4 CDO Evaluator.\u003c\/p\u003e \u003cp\u003e10.5 Default Rates.\u003c\/p\u003e \u003cp\u003e10.6 Interest Rate Stresses.\u003c\/p\u003e \u003cp\u003e10.7 Amortization.\u003c\/p\u003e \u003cp\u003e10.8 Additional S\u0026amp;P Modelling Criteria.\u003c\/p\u003e \u003cp\u003e10.9 Building the S7P Sheet and Related References.\u003c\/p\u003e \u003cp\u003e10.10 Running the Stress Scenarios.\u003c\/p\u003e \u003cp\u003e\u003cb\u003e11 Advanced Waterfall Modelling.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e11.1 Hedge Agreements.\u003c\/p\u003e \u003cp\u003e11.2 Fixed Notes.\u003c\/p\u003e \u003cp\u003e11.3 Variable Funding Notes.\u003c\/p\u003e \u003cp\u003e11.4 Liquidity Facilities.\u003c\/p\u003e \u003cp\u003e11.5 Interest Reserve Accounts.\u003c\/p\u003e \u003cp\u003e11.6 Other Structural Features.\u003c\/p\u003e \u003cp\u003e11.7 Combination Notes.\u003c\/p\u003e \u003cp\u003e11.8 Collateral Manager Equity Analysis.\u003c\/p\u003e \u003cp\u003e\u003cb\u003e12 Maintaining the Cash Flow Model.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e12.1 Adapting Your Model for Different Capital Structures.\u003c\/p\u003e \u003cp\u003e12.2 Audit Sheet.\u003c\/p\u003e \u003cp\u003e12.3 Debugging.\u003c\/p\u003e \u003cp\u003e\u003cb\u003e13 Advanced Structuring Issues.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e13.1 Projecting Accrued Interest.\u003c\/p\u003e \u003cp\u003e13.2 Collating Collateral Cash Flows.\u003c\/p\u003e \u003cp\u003e\u003cb\u003e14 Sourcing and Integrating Data From External Systems.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e14.1 Data Requirements.\u003c\/p\u003e \u003cp\u003e14.2 Trustee Reports.\u003c\/p\u003e \u003cp\u003e14.3 Bloomberg.\u003c\/p\u003e \u003cp\u003e14.4 Loan Level Information Sources.\u003c\/p\u003e \u003cp\u003e\u003cb\u003e15 Regulatory Applications of CDO Technology.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e15.1 The Basel Accords.\u003c\/p\u003e \u003cp\u003e15.2 Regulatory Capital Requirements for CDO Notes.\u003c\/p\u003e \u003cp\u003e15.3 The Standardized Approach for CDOs.\u003c\/p\u003e \u003cp\u003e15.4 The Internal Ratings-Based Approach for CDOs.\u003c\/p\u003e \u003cp\u003e15.5 The Internal Ratings-Based Approach for CDOs: The Ratings-Based Approach.\u003c\/p\u003e \u003cp\u003e15.6 The Internal Ratings-Based Approach for CDOs: The Supervisory Formula Approach.\u003c\/p\u003e \u003cp\u003e15.7 The Internal Ratings-Based Approach: Liquidity Facilities, Overlapping Exposures, Credit Risk Mitigation and Early Amortization Features.\u003c\/p\u003e \u003cp\u003e15.8 Supervisory Provisions.\u003c\/p\u003e \u003cp\u003e15.9 Updates to Basel II.\u003c\/p\u003e \u003cp\u003e\u003cb\u003e16 CDO Valuation.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e16.1 Introduction.\u003c\/p\u003e \u003cp\u003e16.2 Basic Valuation Approaches.\u003c\/p\u003e \u003cp\u003e16.3 Traditional Underwriter Analysis.\u003c\/p\u003e \u003cp\u003e16.4 Fundamental Cash Flow Analysis.\u003c\/p\u003e \u003cp\u003e16.5 Using Rating Agency Models.\u003c\/p\u003e \u003cp\u003e16.6 Transition Matrices.\u003c\/p\u003e \u003cp\u003e16.7 Conclusion.\u003c\/p\u003e \u003cp\u003e\u003cb\u003e17 In Conclusion.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eIndex.\u003c\/p\u003e","brand":"John Wiley \u0026 Sons Inc","offers":[{"title":"Default Title","offer_id":49402420724055,"sku":"9780470741573","price":46.54,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0817\/1739\/5799\/files\/9780470741573.jpg?v=1730480347"},{"product_id":"advanced-modelling-in-finance-using-excel-and-vba-9780471499220","title":"Advanced Modelling in Finance Using Excel and VBA","description":"\u003cb\u003eBook Synopsis\u003c\/b\u003e\u003cbr\u003eThis new and unique book demonstrates that Excel and VBA can play an important role in the explanation and implementation of numerical methods across finance. Advanced Modelling in Finance provides a comprehensive look at equities, options on equities and options on bonds from the early 1950s to the late 1990s. \u003cp\u003eThe book adopts a step-by-step approach to understanding the more sophisticated aspects of Excel macros and VBA programming, showing how these programming techniques can be used to model and manipulate financial data, as applied to equities, bonds and options. The book is essential for financial practitioners who need to develop their financial modelling skill sets as there is an increase in the need to analyse and develop ever more complex ''what if'' scenarios.\u003c\/p\u003e \u003cul\u003e \u003cli\u003eSpecifically applies Excel and VBA to the financial markets\u003c\/li\u003e \u003cli\u003ePackaged with a CD containing the software from the examples throughout the book\u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003e\u003cb\u003eNote:\u003c\/b\u003e CD-ROM\/DVD and other supp\u003cbr\u003e\u003cbr\u003e\u003cb\u003eTrade Review\u003c\/b\u003e\u003cbr\u003eNo. 4 bestseller in 'General Finance' (erivativesreview.com, December 2001)\u003cbr\u003e\u003cbr\u003e\u003cb\u003eTable of Contents\u003c\/b\u003e\u003cbr\u003e\u003c\/p\u003e\u003cp\u003ePreface xi\u003c\/p\u003e \u003cp\u003eAcknowledgements xii\u003c\/p\u003e \u003cp\u003e\u003cb\u003e1 Introduction \u003c\/b\u003e\u003cb\u003e1\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e1.1 Finance insights 1\u003c\/p\u003e \u003cp\u003e1.2 Asset price assumptions 2\u003c\/p\u003e \u003cp\u003e1.3 Mathematical and statistical problems 2\u003c\/p\u003e \u003cp\u003e1.4 Numerical methods 2\u003c\/p\u003e \u003cp\u003e1.5 Excel solutions 3\u003c\/p\u003e \u003cp\u003e1.6 Topics covered 3\u003c\/p\u003e \u003cp\u003e1.7 Related Excel workbooks 5\u003c\/p\u003e \u003cp\u003e1.8 Comments and suggestions 5\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart One Advanced Modelling in Excel \u003c\/b\u003e\u003cb\u003e7\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003e2 Advanced Excel functions and procedures \u003c\/b\u003e\u003cb\u003e9\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e2.1 Accessing functions in Excel 9\u003c\/p\u003e \u003cp\u003e2.2 Mathematical functions 10\u003c\/p\u003e \u003cp\u003e2.3 Statistical functions 12\u003c\/p\u003e \u003cp\u003e2.3.1 Using the frequency function 12\u003c\/p\u003e \u003cp\u003e2.3.2 Using the quartile function 14\u003c\/p\u003e \u003cp\u003e2.3.3 Using Excel’s normal functions 15\u003c\/p\u003e \u003cp\u003e2.4 Lookup functions 16\u003c\/p\u003e \u003cp\u003e2.5 Other functions 18\u003c\/p\u003e \u003cp\u003e2.6 Auditing tools 19\u003c\/p\u003e \u003cp\u003e2.7 Data Tables 20\u003c\/p\u003e \u003cp\u003e2.7.1 Setting up Data Tables with one input 20\u003c\/p\u003e \u003cp\u003e2.7.2 Setting up Data Tables with two inputs 22\u003c\/p\u003e \u003cp\u003e2.8 XY charts 23\u003c\/p\u003e \u003cp\u003e2.9 Access to Data Analysis and Solver 26\u003c\/p\u003e \u003cp\u003e2.10 Using range names 27\u003c\/p\u003e \u003cp\u003e2.11 Regression 28\u003c\/p\u003e \u003cp\u003e2.12 Goal Seek 31\u003c\/p\u003e \u003cp\u003e2.13 Matrix algebra and related functions 33\u003c\/p\u003e \u003cp\u003e2.13.1 Introduction to matrices 33\u003c\/p\u003e \u003cp\u003e2.13.2 Transposing a matrix 33\u003c\/p\u003e \u003cp\u003e2.13.3 Adding matrices 34\u003c\/p\u003e \u003cp\u003e2.13.4 Multiplying matrices 34\u003c\/p\u003e \u003cp\u003e2.13.5 Matrix inversion 35\u003c\/p\u003e \u003cp\u003e2.13.6 Solving systems of simultaneous linear equations 36\u003c\/p\u003e \u003cp\u003e2.13.7 Summary of Excel’s matrix functions 37\u003c\/p\u003e \u003cp\u003eSummary 37\u003c\/p\u003e \u003cp\u003e\u003cb\u003e3 Introduction to VBA \u003c\/b\u003e\u003cb\u003e39\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e3.1 Advantages of mastering VBA 39\u003c\/p\u003e \u003cp\u003e3.2 Object-oriented aspects of VBA 40\u003c\/p\u003e \u003cp\u003e3.3 Starting to write VBA macros 42\u003c\/p\u003e \u003cp\u003e3.3.1 Some simple examples of VBA subroutines 42\u003c\/p\u003e \u003cp\u003e3.3.2 MsgBox for interaction 43\u003c\/p\u003e \u003cp\u003e3.3.3 The writing environment 44\u003c\/p\u003e \u003cp\u003e3.3.4 Entering code and executing macros 44\u003c\/p\u003e \u003cp\u003e3.3.5 Recording keystrokes and editing code 45\u003c\/p\u003e \u003cp\u003e3.4 Elements of programming 47\u003c\/p\u003e \u003cp\u003e3.4.1 Variables and data types 48\u003c\/p\u003e \u003cp\u003e3.4.2 VBA array variables 48\u003c\/p\u003e \u003cp\u003e3.4.3 Control structures 50\u003c\/p\u003e \u003cp\u003e3.4.4 Control of repeating procedures 51\u003c\/p\u003e \u003cp\u003e3.4.5 Using Excel functions and VBA functions in code 52\u003c\/p\u003e \u003cp\u003e3.4.6 General points on programming 53\u003c\/p\u003e \u003cp\u003e3.5 Communicating between macros and the spreadsheet 53\u003c\/p\u003e \u003cp\u003e3.6 Subroutine examples 56\u003c\/p\u003e \u003cp\u003e3.6.1 Charts 56\u003c\/p\u003e \u003cp\u003e3.6.2 Normal probability plot 59\u003c\/p\u003e \u003cp\u003e3.6.3 Generating the efficient frontier with Solver 61\u003c\/p\u003e \u003cp\u003eSummary 65\u003c\/p\u003e \u003cp\u003eReferences 65\u003c\/p\u003e \u003cp\u003eAppendix 3A The Visual Basic Editor 65\u003c\/p\u003e \u003cp\u003eStepping through a macro and using other debug tools 68\u003c\/p\u003e \u003cp\u003eAppendix 3B Recording keystrokes in ‘relative references’ mode 69\u003c\/p\u003e \u003cp\u003e\u003cb\u003e4 Writing VBA user-defined functions \u003c\/b\u003e\u003cb\u003e73\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e4.1 A simple sales commission function 73\u003c\/p\u003e \u003cp\u003e4.2 Creating Commission(Sales) in the spreadsheet 74\u003c\/p\u003e \u003cp\u003e4.3 Two functions with multiple inputs for valuing options 75\u003c\/p\u003e \u003cp\u003e4.4 Manipulating arrays in VBA 78\u003c\/p\u003e \u003cp\u003e4.5 Expected value and variance functions with array inputs 79\u003c\/p\u003e \u003cp\u003e4.6 Portfolio variance function with array inputs 81\u003c\/p\u003e \u003cp\u003e4.7 Functions with array output 84\u003c\/p\u003e \u003cp\u003e4.8 Using Excel and VBA functions in user-defined functions 85\u003c\/p\u003e \u003cp\u003e4.8.1 Using VBA functions in user-defined functions 85\u003c\/p\u003e \u003cp\u003e4.8.2 Add-ins 86\u003c\/p\u003e \u003cp\u003e4.9 Pros and cons of developing VBA functions 86\u003c\/p\u003e \u003cp\u003eSummary 87\u003c\/p\u003e \u003cp\u003eAppendix 4A Functions illustrating array handling 88\u003c\/p\u003e \u003cp\u003eAppendix 4B Binomial tree option valuation functions 89\u003c\/p\u003e \u003cp\u003eExercises on writing functions 94\u003c\/p\u003e \u003cp\u003eSolution notes for exercises on functions 95\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart Two Equities \u003c\/b\u003e\u003cb\u003e99\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003e5 Introduction to equities \u003c\/b\u003e\u003cb\u003e101\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003e6 Portfolio optimisation \u003c\/b\u003e\u003cb\u003e103\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e6.1 Portfolio mean and variance 103\u003c\/p\u003e \u003cp\u003e6.2 Risk–return representation of portfolios 105\u003c\/p\u003e \u003cp\u003e6.3 Using Solver to find efficient points 106\u003c\/p\u003e \u003cp\u003e6.4 Generating the efficient frontier (Huang and Litzenberger’s approach) 109\u003c\/p\u003e \u003cp\u003e6.5 Constrained frontier portfolios 111\u003c\/p\u003e \u003cp\u003e6.6 Combining risk-free and risky assets 113\u003c\/p\u003e \u003cp\u003e6.7 Problem One–combining a risk-free asset with a risky asset 114\u003c\/p\u003e \u003cp\u003e6.8 Problem Two–combining two risky assets 115\u003c\/p\u003e \u003cp\u003e6.9 Problem Three–combining a risk-free asset with a risky portfolio 117\u003c\/p\u003e \u003cp\u003e6.10 User-defined functions in Module1 119\u003c\/p\u003e \u003cp\u003e6.11 Functions for the three generic portfolio problems in Module1 120\u003c\/p\u003e \u003cp\u003e6.12 Macros in ModuleM 121\u003c\/p\u003e \u003cp\u003eSummary 123\u003c\/p\u003e \u003cp\u003eReferences 123\u003c\/p\u003e \u003cp\u003e\u003cb\u003e7 Asset pricing \u003c\/b\u003e\u003cb\u003e125\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e7.1 The single-index model 125\u003c\/p\u003e \u003cp\u003e7.2 Estimating beta coefficients 126\u003c\/p\u003e \u003cp\u003e7.3 The capital asset pricing model 129\u003c\/p\u003e \u003cp\u003e7.4 Variance–covariance matrices 130\u003c\/p\u003e \u003cp\u003e7.5 Value-at-Risk 131\u003c\/p\u003e \u003cp\u003e7.6 Horizon wealth 134\u003c\/p\u003e \u003cp\u003e7.7 Moments of related distributions such as normal and lognormal 136\u003c\/p\u003e \u003cp\u003e7.8 User-defined functions in Module1 136\u003c\/p\u003e \u003cp\u003eSummary 138\u003c\/p\u003e \u003cp\u003eReferences 138\u003c\/p\u003e \u003cp\u003e\u003cb\u003e8 Performance measurement and attribution \u003c\/b\u003e\u003cb\u003e139\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e8.1 Conventional performance measurement 140\u003c\/p\u003e \u003cp\u003e8.2 Active–passive management 141\u003c\/p\u003e \u003cp\u003e8.3 Introduction to style analysis 144\u003c\/p\u003e \u003cp\u003e8.4 Simple style analysis 145\u003c\/p\u003e \u003cp\u003e8.5 Rolling-period style analysis 146\u003c\/p\u003e \u003cp\u003e8.6 Confidence intervals for style weights 148\u003c\/p\u003e \u003cp\u003e8.7 User-defined functions in Module1 151\u003c\/p\u003e \u003cp\u003e8.8 Macros in ModuleM 151\u003c\/p\u003e \u003cp\u003eSummary 152\u003c\/p\u003e \u003cp\u003eReferences 153\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart Three Options on Equities \u003c\/b\u003e\u003cb\u003e155\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003e9 Introduction to options on equities \u003c\/b\u003e\u003cb\u003e157\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e9.1 The genesis of the Black–Scholes formula 158\u003c\/p\u003e \u003cp\u003e9.2 The Black–Scholes formula 158\u003c\/p\u003e \u003cp\u003e9.3 Hedge portfolios 159\u003c\/p\u003e \u003cp\u003e9.4 Risk-neutral valuation 161\u003c\/p\u003e \u003cp\u003e9.5 A simple one-step binomial tree with risk-neutral valuation 162\u003c\/p\u003e \u003cp\u003e9.6 Put–call parity 163\u003c\/p\u003e \u003cp\u003e9.7 Dividends 163\u003c\/p\u003e \u003cp\u003e9.8 American features 164\u003c\/p\u003e \u003cp\u003e9.9 Numerical methods 164\u003c\/p\u003e \u003cp\u003e9.10 Volatility and non-normal share returns 165\u003c\/p\u003e \u003cp\u003eSummary 165\u003c\/p\u003e \u003cp\u003eReferences 166\u003c\/p\u003e \u003cp\u003e\u003cb\u003e10 Binomial trees \u003c\/b\u003e\u003cb\u003e167\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e10.1 Introduction to binomial trees 167\u003c\/p\u003e \u003cp\u003e10.2 A simplified binomial tree 168\u003c\/p\u003e \u003cp\u003e10.3 The Jarrow and Rudd binomial tree 170\u003c\/p\u003e \u003cp\u003e10.4 The Cox, Ross and Rubinstein tree 173\u003c\/p\u003e \u003cp\u003e10.5 Binomial approximations and Black–Scholes formula 175\u003c\/p\u003e \u003cp\u003e10.6 Convergence of CRR binomial trees 176\u003c\/p\u003e \u003cp\u003e10.7 The Leisen and Reimer tree 177\u003c\/p\u003e \u003cp\u003e10.8 Comparison of CRR and LR trees 178\u003c\/p\u003e \u003cp\u003e10.9 American options and the CRR American tree 180\u003c\/p\u003e \u003cp\u003e10.10 User-defined functions in Module0 and Module1 182\u003c\/p\u003e \u003cp\u003eSummary 183\u003c\/p\u003e \u003cp\u003eReferences 184\u003c\/p\u003e \u003cp\u003e\u003cb\u003e11 The Black–Scholes formula \u003c\/b\u003e\u003cb\u003e185\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e11.1 The Black–Scholes formula 185\u003c\/p\u003e \u003cp\u003e11.2 Black–Scholes formula in the spreadsheet 186\u003c\/p\u003e \u003cp\u003e11.3 Options on currencies and commodities 187\u003c\/p\u003e \u003cp\u003e11.4 Calculating the option’s ‘greek’ parameters 189\u003c\/p\u003e \u003cp\u003e11.5 Hedge portfolios 190\u003c\/p\u003e \u003cp\u003e11.6 Formal derivation of the Black–Scholes formula 192\u003c\/p\u003e \u003cp\u003e11.7 User-defined functions in Module1 194\u003c\/p\u003e \u003cp\u003eSummary 195\u003c\/p\u003e \u003cp\u003eReferences 196\u003c\/p\u003e \u003cp\u003e\u003cb\u003e12 Other numerical methods for European options \u003c\/b\u003e\u003cb\u003e197\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e12.1 Introduction to Monte Carlo simulation 197\u003c\/p\u003e \u003cp\u003e12.2 Simulation with antithetic variables 199\u003c\/p\u003e \u003cp\u003e12.3 Simulation with quasi-random sampling 200\u003c\/p\u003e \u003cp\u003e12.4 Comparing simulation methods 202\u003c\/p\u003e \u003cp\u003e12.5 Calculating greeks in Monte Carlo simulation 203\u003c\/p\u003e \u003cp\u003e12.6 Numerical integration 203\u003c\/p\u003e \u003cp\u003e12.7 User-defined functions in Module1 205\u003c\/p\u003e \u003cp\u003eSummary 207\u003c\/p\u003e \u003cp\u003eReferences 207\u003c\/p\u003e \u003cp\u003e\u003cb\u003e13 Non-normal distributions and implied volatility \u003c\/b\u003e\u003cb\u003e209\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e13.1 Black–Scholes using alternative distributional assumptions 209\u003c\/p\u003e \u003cp\u003e13.2 Implied volatility 211\u003c\/p\u003e \u003cp\u003e13.3 Adapting for skewness and kurtosis 212\u003c\/p\u003e \u003cp\u003e13.4 The volatility smile 215\u003c\/p\u003e \u003cp\u003e13.5 User-defined functions in Module1 217\u003c\/p\u003e \u003cp\u003eSummary 219\u003c\/p\u003e \u003cp\u003eReferences 220\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart Four Options on Bonds \u003c\/b\u003e\u003cb\u003e221\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003e14 Introduction to valuing options on bonds \u003c\/b\u003e\u003cb\u003e223\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e14.1 The term structure of interest rates 224\u003c\/p\u003e \u003cp\u003e14.2 Cash flows for coupon bonds and yield to maturity 225\u003c\/p\u003e \u003cp\u003e14.3 Binomial trees 226\u003c\/p\u003e \u003cp\u003e14.4 Black’s bond option valuation formula 227\u003c\/p\u003e \u003cp\u003e14.5 Duration and convexity 228\u003c\/p\u003e \u003cp\u003e14.6 Notation 230\u003c\/p\u003e \u003cp\u003eSummary 230\u003c\/p\u003e \u003cp\u003eReferences 230\u003c\/p\u003e \u003cp\u003e\u003cb\u003e15 Interest rate models \u003c\/b\u003e\u003cb\u003e231\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e15.1 Vasicek’s term structure model 231\u003c\/p\u003e \u003cp\u003e15.2 Valuing European options on zero-coupon bonds, Vasicek’s model 234\u003c\/p\u003e \u003cp\u003e15.3 Valuing European options on coupon bonds, Vasicek’s model 235\u003c\/p\u003e \u003cp\u003e15.4 CIR term structure model 236\u003c\/p\u003e \u003cp\u003e15.5 Valuing European options on zero-coupon bonds, CIR model 237\u003c\/p\u003e \u003cp\u003e15.6 Valuing European options on coupon bonds, CIR model 238\u003c\/p\u003e \u003cp\u003e15.7 User-defined functions in Module1 239\u003c\/p\u003e \u003cp\u003eSummary 240\u003c\/p\u003e \u003cp\u003eReferences 241\u003c\/p\u003e \u003cp\u003e\u003cb\u003e16 Matching the term structure \u003c\/b\u003e\u003cb\u003e243\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e16.1 Trees with lognormally distributed interest rates 243\u003c\/p\u003e \u003cp\u003e16.2 Trees with normal interest rates 246\u003c\/p\u003e \u003cp\u003e16.3 The Black, Derman and Toy tree 247\u003c\/p\u003e \u003cp\u003e16.4 Valuing bond options using BDT trees 248\u003c\/p\u003e \u003cp\u003e16.5 User-defined functions in Module1 250\u003c\/p\u003e \u003cp\u003eSummary 252\u003c\/p\u003e \u003cp\u003eReferences 252\u003c\/p\u003e \u003cp\u003e\u003cb\u003eAppendix Other VBA functions \u003c\/b\u003e\u003cb\u003e253\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eForecasting 253\u003c\/p\u003e \u003cp\u003eARIMA modelling 254\u003c\/p\u003e \u003cp\u003eSplines 256\u003c\/p\u003e \u003cp\u003eEigenvalues and eigenvectors 257\u003c\/p\u003e \u003cp\u003eReferences 258\u003c\/p\u003e \u003cp\u003eIndex 259\u003c\/p\u003e","brand":"John Wiley \u0026 Sons Inc","offers":[{"title":"Default Title","offer_id":49402619625815,"sku":"9780471499220","price":75.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0817\/1739\/5799\/files\/9780471499220.jpg?v=1730481000"},{"product_id":"emerging-trends-in-database-and-knowledge-based-machines-9780818665523","title":"Emerging Trends in Database and Knowledge Based","description":"\u003cb\u003eBook Synopsis\u003c\/b\u003e\u003cbr\u003e","brand":"IEEE Computer Society Press,U.S.","offers":[{"title":"Default Title","offer_id":49405983326551,"sku":"9780818665523","price":62.06,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0817\/1739\/5799\/files\/9780818665523.jpg?v=1730494137"},{"product_id":"7-financial-models-for-analysts-investors-and-finance-professionals-9780857195739","title":"7 Financial Models for Analysts Investors and","description":"\u003cb\u003eBook Synopsis\u003c\/b\u003e\u003cbr\u003e\u003cp\u003eFinancial models in Excel allow investment analysts and other finance professionals to take the laborious number crunching out of financial analysis and forecasting. Models help them to gain meaningful insights into the way that a business is working and focus attention on areas to improve bottom-line results. They can also be used as powerful tools to test the potential impact of various risks on business performance.\u003cbr\u003e\u003cbr\u003eIn this brand new guide, financial modelling expert Paul Lower presents step-by-step instructions for seven spreadsheet models that will help the user to gain a better understanding of the financial data coming out of a business.\u003cbr\u003e\u003cbr\u003eThese seven models can be used to:\u003cbr\u003e\u003cbr\u003e1. Assess how a business is performing on key financial indicators.\u003cbr\u003e2. Produce sales and cost forecasts.\u003cbr\u003e3. Create a cash flow forecast.\u003cbr\u003e4. Understand the impact of product price changes on profitability.\u003cbr\u003e5. Assess potential investment decisions.\u003cbr\u003e6. Check the sensitivity of key financial measures to risk events.\u003cbr\u003e7. Produce a business valuation.\u003cbr\u003e\u003cbr\u003eThe book also includes downloadable spreadsheets of the author''s original Excel models and introductory chapters about best practice when modelling in Excel.\u003cbr\u003e\u003cbr\u003eWith this suite of seven tools, a financial analyst will be equipped to use Excel to achieve a deep understanding of a business and its financial data.\u003c\/p\u003e","brand":"Harriman House Publishing","offers":[{"title":"Default Title","offer_id":49406281187671,"sku":"9780857195739","price":36.0,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0817\/1739\/5799\/files\/9780857195739.jpg?v=1730495219"},{"product_id":"financial-modeling-with-crystal-ball-and-excel-website-9781118175446","title":"Financial Modeling with Crystal Ball and Excel","description":"\u003cb\u003eBook Synopsis\u003c\/b\u003e\u003cbr\u003e\u003cb\u003eUpdated look at financial modeling and Monte Carlo simulation with software by Oracle Crystal Ball\u003c\/b\u003e \u003cp\u003eThis revised and updated edition of the bestselling book on financial modeling provides the tools and techniques needed to perform spreadsheet simulation. It answers the essential question of why risk analysis is vital to the decision-making process, for any problem posed in finance and investment. This reliable resource reviews the basics and covers how to define and refine probability distributions in financial modeling, and explores the concepts driving the simulation modeling process. It also discusses simulation controls and analysis of simulation results.\u003c\/p\u003e \u003cp\u003eThe second edition of \u003ci\u003eFinancial Modeling with Crystal Ball and Excel\u003c\/i\u003e contains instructions, theory, and practical example models to help apply risk analysis to such areas as derivative pricing, cost estimation, portfolio allocation and optimization, credit risk, and cash flow analysis. It includes the resou\u003cbr\u003e\u003cbr\u003e\u003cb\u003eTable of Contents\u003c\/b\u003e\u003cbr\u003e\u003c\/p\u003e\u003cp\u003ePreface xi\u003c\/p\u003e \u003cp\u003eAcknowledgments xvii\u003c\/p\u003e \u003cp\u003eAbout the Author xix\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 1 Introduction 1\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e1.1 Financial Modeling 2\u003c\/p\u003e \u003cp\u003e1.2 Risk Analysis 2\u003c\/p\u003e \u003cp\u003e1.3 Monte Carlo Simulation 4\u003c\/p\u003e \u003cp\u003e1.4 Risk Management 8\u003c\/p\u003e \u003cp\u003e1.5 Benefits and Limitations of Using Crystal Ball 9\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 2 Analyzing Crystal Ball Forecasts 11\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e2.1 Simulating a 50–50 Portfolio 11\u003c\/p\u003e \u003cp\u003e2.2 Varying the Allocations 22\u003c\/p\u003e \u003cp\u003e2.3 Presenting the Results 27\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 3 Building A Crystal Ball Model 29\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e3.1 Simulation Modeling Process 29\u003c\/p\u003e \u003cp\u003e3.2 Defining Crystal Ball Assumptions and Forecasts 30\u003c\/p\u003e \u003cp\u003e3.3 Running Crystal Ball 33\u003c\/p\u003e \u003cp\u003e3.4 Sources of Error 34\u003c\/p\u003e \u003cp\u003e3.5 Controlling Model Error 36\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 4 Selecting Crystal Ball Assumptions 37\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e4.1 Crystal Ball’s Basic Distributions 37\u003c\/p\u003e \u003cp\u003e4.2 Using Historical Data to Choose Distributions 55\u003c\/p\u003e \u003cp\u003e4.3 Specifying Correlations 64\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 5 Using Decision Variables 79\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e5.1 Defining Decision Variables 79\u003c\/p\u003e \u003cp\u003e5.2 Decision Table with One Decision Variable 81\u003c\/p\u003e \u003cp\u003e5.3 Decision Table with Two Decision Variables 87\u003c\/p\u003e \u003cp\u003e5.4 Using OptQuest 98\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 6 Selecting Run Preferences 105\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e6.1 Trials 105\u003c\/p\u003e \u003cp\u003e6.2 Sampling 109\u003c\/p\u003e \u003cp\u003e6.3 Speed 111\u003c\/p\u003e \u003cp\u003e6.4 Options 113\u003c\/p\u003e \u003cp\u003e6.5 Statistics 115\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 7 Net Present Value and Internal Rate of Return 117\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e7.1 Deterministic NPV and IRR 117\u003c\/p\u003e \u003cp\u003e7.2 Simulating NPV and IRR 119\u003c\/p\u003e \u003cp\u003e7.3 Capital Budgeting 123\u003c\/p\u003e \u003cp\u003e7.4 Customer Net Present Value 133\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 8 Modeling Financial Statements 137\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e8.1 Deterministic Model 137\u003c\/p\u003e \u003cp\u003e8.2 Tornado Chart and Sensitivity Analysis 138\u003c\/p\u003e \u003cp\u003e8.3 Crystal Ball Sensitivity Chart 139\u003c\/p\u003e \u003cp\u003e8.4 Conclusion 143\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 9 Portfolio Models 145\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e9.1 Single-period Crystal Ball Model 145\u003c\/p\u003e \u003cp\u003e9.2 Single-period Analytical Solution 148\u003c\/p\u003e \u003cp\u003e9.3 Multi-period Crystal Ball Model 149\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 10 Value at Risk 155\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e10.1 VaR 155\u003c\/p\u003e \u003cp\u003e10.2 Shortcomings of VaR 157\u003c\/p\u003e \u003cp\u003e10.3 Conditional Value at Risk 157\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 11 Simulating Financial Time Series 163\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e11.1 White Noise 163\u003c\/p\u003e \u003cp\u003e11.2 Random Walk 165\u003c\/p\u003e \u003cp\u003e11.3 Autocorrelation 166\u003c\/p\u003e \u003cp\u003e11.4 Additive Random Walk with Drift 170\u003c\/p\u003e \u003cp\u003e11.5 Multiplicative Random Walk Model 173\u003c\/p\u003e \u003cp\u003e11.6 Geometric Brownian Motion Model 176\u003c\/p\u003e \u003cp\u003e11.7 Mean-reverting Model 180\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 12 Financial Options 187\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e12.1 Types of Options 187\u003c\/p\u003e \u003cp\u003e12.2 Risk-neutral Pricing and the Black-Scholes Model 188\u003c\/p\u003e \u003cp\u003e12.3 Portfolio Insurance 192\u003c\/p\u003e \u003cp\u003e12.4 American Option Pricing 194\u003c\/p\u003e \u003cp\u003e12.5 Exotic Option Pricing 197\u003c\/p\u003e \u003cp\u003e12.6 Bull Spread 201\u003c\/p\u003e \u003cp\u003e12.7 Principal-protected Instrument 201\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 13 Real Options 205\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e13.1 Financial Options and Real Options 205\u003c\/p\u003e \u003cp\u003e13.2 Applications of Real Options Analysis 206\u003c\/p\u003e \u003cp\u003e13.3 Black-Scholes Real Options Insights 209\u003c\/p\u003e \u003cp\u003e13.4 Real Options Valuation Tool 211\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 14 Credit Risk 221\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e14.1 Expected Loss 221\u003c\/p\u003e \u003cp\u003e14.2 Credit Risk Simulation Model 223\u003c\/p\u003e \u003cp\u003e14.3 Conditional Value at Risk 225\u003c\/p\u003e \u003cp\u003e14.4 Using CVaR to Manage Credit Risk 227\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 15 Construction Project Management 229\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e15.1 Project Description 229\u003c\/p\u003e \u003cp\u003e15.2 Choosing Construction Methods 231\u003c\/p\u003e \u003cp\u003e15.3 Risk Analysis 231\u003c\/p\u003e \u003cp\u003e15.4 Stochastic Optimization 234\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 16 Oil and GasExploration 235\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e16.1 Well Properties 235\u003c\/p\u003e \u003cp\u003e16.2 Statistical Models 236\u003c\/p\u003e \u003cp\u003e16.3 Conclusion 239\u003c\/p\u003e \u003cp\u003e\u003cb\u003eAppendix A Crystal Ball’s Probability Distributions 241\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eA.1 Bernoulli 241\u003c\/p\u003e \u003cp\u003eA.2 Beta 243\u003c\/p\u003e \u003cp\u003eA.3 Beta PERT 244\u003c\/p\u003e \u003cp\u003eA.4 Binomial 246\u003c\/p\u003e \u003cp\u003eA.5 Custom 247\u003c\/p\u003e \u003cp\u003eA.6 Discrete Uniform 251\u003c\/p\u003e \u003cp\u003eA.7 Exponential 252\u003c\/p\u003e \u003cp\u003eA.8 Gamma 254\u003c\/p\u003e \u003cp\u003eA.9 Geometric 255\u003c\/p\u003e \u003cp\u003eA.10 Hypergeometric 257\u003c\/p\u003e \u003cp\u003eA.11 Logistic 259\u003c\/p\u003e \u003cp\u003eA.12 Lognormal 260\u003c\/p\u003e \u003cp\u003eA.13 Maximum Extreme 262\u003c\/p\u003e \u003cp\u003eA.14 Minimum Extreme 263\u003c\/p\u003e \u003cp\u003eA.15 Negative Binomial 264\u003c\/p\u003e \u003cp\u003eA.16 Normal 266\u003c\/p\u003e \u003cp\u003eA.17 Pareto 267\u003c\/p\u003e \u003cp\u003eA.18 Poisson 269\u003c\/p\u003e \u003cp\u003eA.19 Student’s t 270\u003c\/p\u003e \u003cp\u003eA.20 Triangular 272\u003c\/p\u003e \u003cp\u003eA.21 Uniform 273\u003c\/p\u003e \u003cp\u003eA.22 Weibull 275\u003c\/p\u003e \u003cp\u003eA.23 Yes-No 276\u003c\/p\u003e \u003cp\u003e\u003cb\u003eAppendix B Generating Assumption Values 279\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eB.1 Generating Random Numbers 279\u003c\/p\u003e \u003cp\u003eB.2 Generating Random Variates 282\u003c\/p\u003e \u003cp\u003eB.3 Latin Hypercube Sampling 284\u003c\/p\u003e \u003cp\u003e\u003cb\u003eAppendix C Variance Reduction Techniques 287\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eC.1 Using Crystal Ball to Value an Asian Option 288\u003c\/p\u003e \u003cp\u003eC.2 Antithetic Variates 289\u003c\/p\u003e \u003cp\u003eC.3 Control Variates 289\u003c\/p\u003e \u003cp\u003eC.4 Comparison 290\u003c\/p\u003e \u003cp\u003eC.5 Conclusion 292\u003c\/p\u003e \u003cp\u003e\u003cb\u003eAppendix D About the Download 293\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eGlossary 297\u003c\/p\u003e \u003cp\u003eReferences 301\u003c\/p\u003e \u003cp\u003eIndex 311\u003c\/p\u003e","brand":"John Wiley \u0026 Sons Inc","offers":[{"title":"Default Title","offer_id":49406839390551,"sku":"9781118175446","price":52.5,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0817\/1739\/5799\/files\/9781118175446.jpg?v=1730497296"},{"product_id":"marketing-analytics-9781118373439","title":"Marketing Analytics","description":"\u003cb\u003eBook Synopsis\u003c\/b\u003e\u003cbr\u003eHelping tech-savvy marketers and data analysts solve real-world business problems with Excel Using data-driven business analytics to understand customers and improve results is a great idea in theory, but in today's busy offices, marketers and analysts need simple, low-cost ways to process and make the most of all that data.\u003cbr\u003e\u003cbr\u003e\u003cb\u003eTable of Contents\u003c\/b\u003e\u003cbr\u003e\u003cp\u003eIntroduction xxiii\u003c\/p\u003e \u003cp\u003e\u003cb\u003eI \u003c\/b\u003e\u003cb\u003eUsing Excel to Summarize Marketing Data 1\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003e1 \u003c\/b\u003e\u003cb\u003eSlicing and Dicing Marketing Data with PivotTables 3\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eAnalyzing Sales at True Colors Hardware 3\u003c\/p\u003e \u003cp\u003eAnalyzing Sales at La Petit Bakery 14\u003c\/p\u003e \u003cp\u003eAnalyzing How Demographics Affect Sales 21\u003c\/p\u003e \u003cp\u003ePulling Data from a PivotTable with the GETPIVOTDATA Function 25\u003c\/p\u003e \u003cp\u003eSummary 27\u003c\/p\u003e \u003cp\u003eExercises 27\u003c\/p\u003e \u003cp\u003e\u003cb\u003e2 \u003c\/b\u003e\u003cb\u003eUsing Excel Charts to Summarize Marketing Data 29\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eCombination Charts 29\u003c\/p\u003e \u003cp\u003eUsing a PivotChart to Summarize Market Research Surveys 36\u003c\/p\u003e \u003cp\u003eEnsuring Charts Update Automatically When New Data is Added 39\u003c\/p\u003e \u003cp\u003eMaking Chart Labels Dynamic 40\u003c\/p\u003e \u003cp\u003eSummarizing Monthly Sales-Force Rankings 43\u003c\/p\u003e \u003cp\u003eUsing Check Boxes to Control Data in a Chart 45\u003c\/p\u003e \u003cp\u003eUsing Sparklines to Summarize Multiple Data Series 48\u003c\/p\u003e \u003cp\u003eUsing GETPIVOTDATA to Create the End-of-Week Sales Report 52\u003c\/p\u003e \u003cp\u003eSummary 55\u003c\/p\u003e \u003cp\u003eExercises 55\u003c\/p\u003e \u003cp\u003e\u003cb\u003e3 \u003c\/b\u003e\u003cb\u003eUsing Excel Functions to Summarize Marketing Data 59\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eSummarizing Data with a Histogram 59\u003c\/p\u003e \u003cp\u003eUsing Statistical Functions to Summarize Marketing Data 64\u003c\/p\u003e \u003cp\u003eSummary 79\u003c\/p\u003e \u003cp\u003eExercises 80\u003c\/p\u003e \u003cp\u003e\u003cb\u003eII \u003c\/b\u003e\u003cb\u003ePricing 83\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003e4 \u003c\/b\u003e\u003cb\u003eEstimating Demand Curves and Using Solver to Optimize Price 85\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eEstimating Linear and Power Demand Curves 85\u003c\/p\u003e \u003cp\u003eUsing the Excel Solver to Optimize Price 90\u003c\/p\u003e \u003cp\u003ePricing Using Subjectively Estimated Demand Curves 96\u003c\/p\u003e \u003cp\u003eUsing SolverTable to Price Multiple Products 99\u003c\/p\u003e \u003cp\u003eSummary 103\u003c\/p\u003e \u003cp\u003eExercises 104\u003c\/p\u003e \u003cp\u003e\u003cb\u003e5 \u003c\/b\u003e\u003cb\u003ePrice Bundling 107\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eWhy Bundle? 107\u003c\/p\u003e \u003cp\u003eUsing Evolutionary Solver to Find Optimal Bundle Prices 111\u003c\/p\u003e \u003cp\u003eSummary 119\u003c\/p\u003e \u003cp\u003eExercises 119\u003c\/p\u003e \u003cp\u003e\u003cb\u003e6 \u003c\/b\u003e\u003cb\u003eNonlinear Pricing 123\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eDemand Curves and Willingness to Pay 124\u003c\/p\u003e \u003cp\u003eProfit Maximizing with Nonlinear Pricing Strategies 125\u003c\/p\u003e \u003cp\u003eSummary 131\u003c\/p\u003e \u003cp\u003eExercises 132\u003c\/p\u003e \u003cp\u003e\u003cb\u003e7 \u003c\/b\u003e\u003cb\u003ePrice Skimming and Sales 135\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eDropping Prices Over Time 135\u003c\/p\u003e \u003cp\u003eWhy Have Sales? 138\u003c\/p\u003e \u003cp\u003eSummary 142\u003c\/p\u003e \u003cp\u003eExercises 142\u003c\/p\u003e \u003cp\u003e\u003cb\u003e8 \u003c\/b\u003e\u003cb\u003eRevenue Management 143\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eEstimating Demand for the Bates Motel and Segmenting Customers 144\u003c\/p\u003e \u003cp\u003eHandling Uncertainty 150\u003c\/p\u003e \u003cp\u003eMarkdown Pricing 153\u003c\/p\u003e \u003cp\u003eSummary 156\u003c\/p\u003e \u003cp\u003eExercises 156\u003c\/p\u003e \u003cp\u003e\u003cb\u003eIII \u003c\/b\u003e\u003cb\u003eForecasting .159\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003e9 \u003c\/b\u003e\u003cb\u003eSimple Linear Regression and Correlation 161\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eSimple Linear Regression 161\u003c\/p\u003e \u003cp\u003eUsing Correlations to Summarize Linear Relationships 170\u003c\/p\u003e \u003cp\u003eSummary 174\u003c\/p\u003e \u003cp\u003eExercises 175\u003c\/p\u003e \u003cp\u003e\u003cb\u003e10 \u003c\/b\u003e\u003cb\u003eUsing Multiple Regression to Forecast Sales 177\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eIntroducing Multiple Linear Regression 178\u003c\/p\u003e \u003cp\u003eRunning a Regression with the Data Analysis Add-In 179\u003c\/p\u003e \u003cp\u003eInterpreting the Regression Output 182\u003c\/p\u003e \u003cp\u003eUsing Qualitative Independent Variables in Regression 186\u003c\/p\u003e \u003cp\u003eModeling Interactions and Nonlinearities 192\u003c\/p\u003e \u003cp\u003eTesting Validity of Regression Assumptions 195\u003c\/p\u003e \u003cp\u003eMulticollinearity 204\u003c\/p\u003e \u003cp\u003eValidation of a Regression 207\u003c\/p\u003e \u003cp\u003eSummary 209\u003c\/p\u003e \u003cp\u003eExercises 210\u003c\/p\u003e \u003cp\u003e\u003cb\u003e11 \u003c\/b\u003e\u003cb\u003eForecasting in the Presence of Special Events 213\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eBuilding the Basic Model 213\u003c\/p\u003e \u003cp\u003eSummary 222\u003c\/p\u003e \u003cp\u003eExercises 222\u003c\/p\u003e \u003cp\u003e\u003cb\u003e12 \u003c\/b\u003e\u003cb\u003eModeling Trend and Seasonality 225\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eUsing Moving Averages to Smooth Data and Eliminate Seasonality 225\u003c\/p\u003e \u003cp\u003eAn Additive Model with Trends and Seasonality 228\u003c\/p\u003e \u003cp\u003eA Multiplicative Model with Trend and Seasonality 231\u003c\/p\u003e \u003cp\u003eSummary 234\u003c\/p\u003e \u003cp\u003eExercises 234\u003c\/p\u003e \u003cp\u003e\u003cb\u003e13 \u003c\/b\u003e\u003cb\u003eRatio to Moving Average Forecasting Method 235\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eUsing the Ratio to Moving Average Method 235\u003c\/p\u003e \u003cp\u003eApplying the Ratio to Moving Average Method to Monthly Data 238\u003c\/p\u003e \u003cp\u003eSummary 238\u003c\/p\u003e \u003cp\u003eExercises 239\u003c\/p\u003e \u003cp\u003e\u003cb\u003e14 \u003c\/b\u003e\u003cb\u003eWinter’s Method 241\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eParameter Definitions for Winter’s Method 241\u003c\/p\u003e \u003cp\u003eInitializing Winter’s Method 243\u003c\/p\u003e \u003cp\u003eEstimating the Smoothing Constants 244\u003c\/p\u003e \u003cp\u003eForecasting Future Months 246\u003c\/p\u003e \u003cp\u003eMean Absolute Percentage Error (MAPE) 247\u003c\/p\u003e \u003cp\u003eSummary 248\u003c\/p\u003e \u003cp\u003eExercises 248\u003c\/p\u003e \u003cp\u003e\u003cb\u003e15 \u003c\/b\u003e\u003cb\u003eUsing Neural Networks to Forecast Sales 249\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eRegression and Neural Nets 249\u003c\/p\u003e \u003cp\u003eUsing Neural Networks 250\u003c\/p\u003e \u003cp\u003eUsing NeuralTools to Predict Sales 253\u003c\/p\u003e \u003cp\u003eUsing NeuralTools to Forecast Airline Miles 258\u003c\/p\u003e \u003cp\u003eSummary 259\u003c\/p\u003e \u003cp\u003eExercises 259\u003c\/p\u003e \u003cp\u003e\u003cb\u003eIV \u003c\/b\u003e\u003cb\u003eWhat do Customers Want? 261\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003e16 \u003c\/b\u003e\u003cb\u003eConjoint Analysis 263\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eProducts, Attributes, and Levels 263\u003c\/p\u003e \u003cp\u003eFull Profile Conjoint Analysis 265\u003c\/p\u003e \u003cp\u003eUsing Evolutionary Solver to Generate Product Profiles 272\u003c\/p\u003e \u003cp\u003eDeveloping a Conjoint Simulator 277\u003c\/p\u003e \u003cp\u003eExamining Other Forms of Conjoint Analysis 279\u003c\/p\u003e \u003cp\u003eSummary 281\u003c\/p\u003e \u003cp\u003eExercises 281\u003c\/p\u003e \u003cp\u003e\u003cb\u003e17 \u003c\/b\u003e\u003cb\u003eLogistic Regression 285\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eWhy Logistic Regression Is Necessary 286\u003c\/p\u003e \u003cp\u003eLogistic Regression Model 289\u003c\/p\u003e \u003cp\u003eMaximum Likelihood Estimate of Logistic Regression Model 290\u003c\/p\u003e \u003cp\u003eUsing StatTools to Estimate and Test Logistic Regression Hypotheses 293\u003c\/p\u003e \u003cp\u003ePerforming a Logistic Regression with Count Data 298\u003c\/p\u003e \u003cp\u003eSummary 300\u003c\/p\u003e \u003cp\u003eExercises 300\u003c\/p\u003e \u003cp\u003e\u003cb\u003e18 \u003c\/b\u003e\u003cb\u003eDiscrete Choice Analysis 303\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eRandom Utility Theory 303\u003c\/p\u003e \u003cp\u003eDiscrete Choice Analysis of Chocolate Preferences 305\u003c\/p\u003e \u003cp\u003eIncorporating Price and Brand Equity into Discrete Choice Analysis 309\u003c\/p\u003e \u003cp\u003eDynamic Discrete Choice 315\u003c\/p\u003e \u003cp\u003eIndependence of Irrelevant Alternatives (IIA) Assumption 316\u003c\/p\u003e \u003cp\u003eDiscrete Choice and Price Elasticity 317\u003c\/p\u003e \u003cp\u003eSummary 318\u003c\/p\u003e \u003cp\u003eExercises 319\u003c\/p\u003e \u003cp\u003e\u003cb\u003e19 \u003c\/b\u003e\u003cb\u003eCalculating Lifetime Customer Value 327\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eBasic Customer Value Template 328\u003c\/p\u003e \u003cp\u003eMeasuring Sensitivity Analysis with Two-way Tables 330\u003c\/p\u003e \u003cp\u003eAn Explicit Formula for the Multiplier r 331\u003c\/p\u003e \u003cp\u003eVarying Margins 331\u003c\/p\u003e \u003cp\u003eDIRECTV, Customer Value, and \u003ci\u003eFriday Night Lights (FNL) \u003c\/i\u003e333\u003c\/p\u003e \u003cp\u003eEstimating the Chance a Customer Is Still Active 334\u003c\/p\u003e \u003cp\u003eGoing Beyond the Basic Customer Lifetime Value Model 335\u003c\/p\u003e \u003cp\u003eSummary 336\u003c\/p\u003e \u003cp\u003eExercises 336\u003c\/p\u003e \u003cp\u003e\u003cb\u003e20 \u003c\/b\u003e\u003cb\u003eUsing Customer Value to Value a Business 339\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eA Primer on Valuation 339\u003c\/p\u003e \u003cp\u003eUsing Customer Value to Value a Business 340\u003c\/p\u003e \u003cp\u003eMeasuring Sensitivity Analysis with a One-way Table 343\u003c\/p\u003e \u003cp\u003eUsing Customer Value to Estimate a Firm’s Market Value 344\u003c\/p\u003e \u003cp\u003eSummary 344\u003c\/p\u003e \u003cp\u003eExercises 345\u003c\/p\u003e \u003cp\u003e\u003cb\u003e21 \u003c\/b\u003e\u003cb\u003eCustomer Value, Monte Carlo Simulation, and Marketing Decision Making 347\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eA Markov Chain Model of Customer Value 347\u003c\/p\u003e \u003cp\u003eUsing Monte Carlo Simulation to Predict Success of a Marketing Initiative 353\u003c\/p\u003e \u003cp\u003eSummary 359\u003c\/p\u003e \u003cp\u003eExercises 360\u003c\/p\u003e \u003cp\u003e\u003cb\u003e22 \u003c\/b\u003e\u003cb\u003eAllocating Marketing Resources between Customer Acquisition and Retention 347\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eModeling the Relationship between Spending and Customer Acquisition and Retention 365\u003c\/p\u003e \u003cp\u003eBasic Model for Optimizing Retention and Acquisition Spending 368\u003c\/p\u003e \u003cp\u003eAn Improvement in the Basic Model 371\u003c\/p\u003e \u003cp\u003eSummary 373\u003c\/p\u003e \u003cp\u003eExercises 374\u003c\/p\u003e \u003cp\u003e\u003cb\u003eVI \u003c\/b\u003e\u003cb\u003eMarket Segmentation 375\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003e23 \u003c\/b\u003e\u003cb\u003eCluster Analysis 377\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eClustering U.S. Cities 378\u003c\/p\u003e \u003cp\u003eUsing Conjoint Analysis to Segment a Market 386\u003c\/p\u003e \u003cp\u003eSummary 391\u003c\/p\u003e \u003cp\u003eExercises 391\u003c\/p\u003e \u003cp\u003e\u003cb\u003e24 \u003c\/b\u003e\u003cb\u003eCollaborative Filtering 393\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eUser-Based Collaborative Filtering 393\u003c\/p\u003e \u003cp\u003eItem-Based Filtering 398\u003c\/p\u003e \u003cp\u003eComparing Item- and User-Based Collaborative Filtering 400\u003c\/p\u003e \u003cp\u003eThe Netflix Competition 401\u003c\/p\u003e \u003cp\u003eSummary 401\u003c\/p\u003e \u003cp\u003eExercises 402\u003c\/p\u003e \u003cp\u003e\u003cb\u003e25 \u003c\/b\u003e\u003cb\u003eUsing Classification Trees for Segmentation 403\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eIntroducing Decision Trees 403\u003c\/p\u003e \u003cp\u003eConstructing a Decision Tree 404\u003c\/p\u003e \u003cp\u003ePruning Trees and CART 409\u003c\/p\u003e \u003cp\u003eSummary 410\u003c\/p\u003e \u003cp\u003eExercises 410\u003c\/p\u003e \u003cp\u003e\u003cb\u003e26 \u003c\/b\u003e\u003cb\u003eUsing S Curves to Forecast Sales of a New Product 415\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eExamining S Curves 415\u003c\/p\u003e \u003cp\u003eFitting the Pearl or Logistic Curve 418\u003c\/p\u003e \u003cp\u003eFitting an S Curve with Seasonality 420\u003c\/p\u003e \u003cp\u003eFitting the Gompertz Curve 422\u003c\/p\u003e \u003cp\u003ePearl Curve versus Gompertz Curve 425\u003c\/p\u003e \u003cp\u003eSummary 425\u003c\/p\u003e \u003cp\u003eExercises 425\u003c\/p\u003e \u003cp\u003e\u003cb\u003e27 \u003c\/b\u003e\u003cb\u003eThe Bass Diffusion Model 427\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eIntroducing the Bass Model 427\u003c\/p\u003e \u003cp\u003eEstimating the Bass Model 428\u003c\/p\u003e \u003cp\u003eUsing the Bass Model to Forecast New Product Sales 431\u003c\/p\u003e \u003cp\u003eDeflating Intentions Data 434\u003c\/p\u003e \u003cp\u003eUsing the Bass Model to Simulate Sales of a New Product 435\u003c\/p\u003e \u003cp\u003eModifications of the Bass Model 437\u003c\/p\u003e \u003cp\u003eSummary 438\u003c\/p\u003e \u003cp\u003eExercises 438\u003c\/p\u003e \u003cp\u003e\u003cb\u003e28 \u003c\/b\u003e\u003cb\u003eUsing the Copernican Principle to Predict Duration of Future Sales 439\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eUsing the Copernican Principle 439\u003c\/p\u003e \u003cp\u003eSimulating Remaining Life of Product 440\u003c\/p\u003e \u003cp\u003eSummary 441\u003c\/p\u003e \u003cp\u003eExercises 441\u003c\/p\u003e \u003cp\u003e\u003cb\u003e29 \u003c\/b\u003e\u003cb\u003eMarket Basket Analysis and Lift 445\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eComputing Lift for Two Products 445\u003c\/p\u003e \u003cp\u003eComputing Three-Way Lifts 449\u003c\/p\u003e \u003cp\u003eA Data Mining Legend Debunked! 453\u003c\/p\u003e \u003cp\u003eUsing Lift to Optimize Store Layout 454\u003c\/p\u003e \u003cp\u003eSummary 456\u003c\/p\u003e \u003cp\u003eExercises 456\u003c\/p\u003e \u003cp\u003e\u003cb\u003e30 \u003c\/b\u003e\u003cb\u003eRFM Analysis and Optimizing Direct Mail Campaigns 459\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eRFM Analysis 459\u003c\/p\u003e \u003cp\u003eAn RFM Success Story 465\u003c\/p\u003e \u003cp\u003eUsing the Evolutionary Solver to Optimize a Direct Mail Campaign 465\u003c\/p\u003e \u003cp\u003eSummary 468\u003c\/p\u003e \u003cp\u003eExercises 468\u003c\/p\u003e \u003cp\u003e\u003cb\u003e31 \u003c\/b\u003e\u003cb\u003eUsing the SCAN*PRO Model and Its Variants 471\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eIntroducing the SCAN*PRO Model 471\u003c\/p\u003e \u003cp\u003eModeling Sales of Snickers Bars 472\u003c\/p\u003e \u003cp\u003eForecasting Software Sales 475\u003c\/p\u003e \u003cp\u003eSummary 480\u003c\/p\u003e \u003cp\u003eExercises 480\u003c\/p\u003e \u003cp\u003e\u003cb\u003e32 \u003c\/b\u003e\u003cb\u003eAllocating Retail Space and Sales Resources 483\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eIdentifying the Sales to Marketing Effort Relationship 483\u003c\/p\u003e \u003cp\u003eModeling the Marketing Response to Sales Force Effort 484\u003c\/p\u003e \u003cp\u003eOptimizing Allocation of Sales Effort 489\u003c\/p\u003e \u003cp\u003eUsing the Gompertz Curve to Allocate\u003c\/p\u003e \u003cp\u003eSupermarket Shelf Space 492\u003c\/p\u003e \u003cp\u003eSummary 492\u003c\/p\u003e \u003cp\u003eExercises 493\u003c\/p\u003e \u003cp\u003e\u003cb\u003e33 \u003c\/b\u003e\u003cb\u003eForecasting Sales from Few Data Points 495\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003ePredicting Movie Revenues 495\u003c\/p\u003e \u003cp\u003eModifying the Model to Improve Forecast Accuracy 498\u003c\/p\u003e \u003cp\u003eUsing 3 Weeks of Revenue to Forecast Movie Revenues 499\u003c\/p\u003e \u003cp\u003eSummary 501\u003c\/p\u003e \u003cp\u003eExercises 501\u003c\/p\u003e \u003cp\u003e\u003cb\u003e34 \u003c\/b\u003e\u003cb\u003eMeasuring the Effectiveness of Advertising 505\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eThe Adstock Model 505\u003c\/p\u003e \u003cp\u003eAnother Model for Estimating Ad Effectiveness 509\u003c\/p\u003e \u003cp\u003eOptimizing Advertising: Pulsing versus Continuous Spending 511\u003c\/p\u003e \u003cp\u003eSummary 514\u003c\/p\u003e \u003cp\u003eExercises 515\u003c\/p\u003e \u003cp\u003e\u003cb\u003e35 \u003c\/b\u003e\u003cb\u003eMedia Selection Models 517\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eA Linear Media Allocation Model 517\u003c\/p\u003e \u003cp\u003eQuantity Discounts 520\u003c\/p\u003e \u003cp\u003eA Monte Carlo Media Allocation Simulation 522\u003c\/p\u003e \u003cp\u003eSummary 527\u003c\/p\u003e \u003cp\u003eExercises 527\u003c\/p\u003e \u003cp\u003e\u003cb\u003e36 \u003c\/b\u003e\u003cb\u003ePay per Click (PPC) Online Advertising 529\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eDefining Pay per Click Advertising 529\u003c\/p\u003e \u003cp\u003eProfitability Model for PPC Advertising 531\u003c\/p\u003e \u003cp\u003eGoogle AdWords Auction 533\u003c\/p\u003e \u003cp\u003eUsing Bid Simulator to Optimize Your Bid 536\u003c\/p\u003e \u003cp\u003eSummary 537\u003c\/p\u003e \u003cp\u003eExercises 537\u003c\/p\u003e \u003cp\u003e\u003cb\u003eX \u003c\/b\u003e\u003cb\u003eMarketing Research Tools 539\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003e37 \u003c\/b\u003e\u003cb\u003ePrincipal Components Analysis (PCA) 541\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eDefining PCA 541\u003c\/p\u003e \u003cp\u003eLinear Combinations, Variances, and Covariances 542\u003c\/p\u003e \u003cp\u003eDiving into Principal Components Analysis 548\u003c\/p\u003e \u003cp\u003eOther Applications of PCA 556\u003c\/p\u003e \u003cp\u003eSummary 557\u003c\/p\u003e \u003cp\u003eExercises 558\u003c\/p\u003e \u003cp\u003e\u003cb\u003e38 \u003c\/b\u003e\u003cb\u003eMultidimensional Scaling (MDS) 559\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eSimilarity Data 559\u003c\/p\u003e \u003cp\u003eMDS Analysis of U.S. City Distances 560\u003c\/p\u003e \u003cp\u003eMDS Analysis of Breakfast Foods 566\u003c\/p\u003e \u003cp\u003eFinding a Consumer’s Ideal Point 570\u003c\/p\u003e \u003cp\u003eSummary 574\u003c\/p\u003e \u003cp\u003eExercises 574\u003c\/p\u003e \u003cp\u003e\u003cb\u003e39 \u003c\/b\u003e\u003cb\u003eClassification Algorithms: Naive Bayes Classifier and Discriminant Analysis 577\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eConditional Probability 578\u003c\/p\u003e \u003cp\u003eBayes’ Theorem 579\u003c\/p\u003e \u003cp\u003eNaive Bayes Classifier 581\u003c\/p\u003e \u003cp\u003eLinear Discriminant Analysis 586\u003c\/p\u003e \u003cp\u003eModel Validation 591\u003c\/p\u003e \u003cp\u003eThe Surprising Virtues of Naive Bayes 592\u003c\/p\u003e \u003cp\u003eSummary 592\u003c\/p\u003e \u003cp\u003eExercises 593\u003c\/p\u003e \u003cp\u003e\u003cb\u003e40 \u003c\/b\u003e\u003cb\u003eAnalysis of Variance: One-way ANOVA 595\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eTesting Whether Group Means Are Different 595\u003c\/p\u003e \u003cp\u003eExample of One-way ANOVA 596\u003c\/p\u003e \u003cp\u003eThe Role of Variance in ANOVA 598\u003c\/p\u003e \u003cp\u003eForecasting with One-way ANOVA 599\u003c\/p\u003e \u003cp\u003eContrasts 601\u003c\/p\u003e \u003cp\u003eSummary 603\u003c\/p\u003e \u003cp\u003eExercises 604\u003c\/p\u003e \u003cp\u003e\u003cb\u003e41 \u003c\/b\u003e\u003cb\u003eAnalysis of Variance: Two-way ANOVA 607\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eIntroducing Two-way ANOVA 607\u003c\/p\u003e \u003cp\u003eTwo-way ANOVA without Replication 608\u003c\/p\u003e \u003cp\u003eTwo-way ANOVA with Replication 611\u003c\/p\u003e \u003cp\u003eSummary 616\u003c\/p\u003e \u003cp\u003eExercises 617\u003c\/p\u003e \u003cp\u003e\u003cb\u003eXI \u003c\/b\u003e\u003cb\u003eInternet and Social Marketing 619\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003e42 \u003c\/b\u003e\u003cb\u003eNetworks 621\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eMeasuring the Importance of a Node 621\u003c\/p\u003e \u003cp\u003eMeasuring the Importance of a Link 626\u003c\/p\u003e \u003cp\u003eSummarizing Network Structure 628\u003c\/p\u003e \u003cp\u003eRandom and Regular Networks 631\u003c\/p\u003e \u003cp\u003eThe Rich Get Richer 634\u003c\/p\u003e \u003cp\u003eKlout Score 636\u003c\/p\u003e \u003cp\u003eSummary 637\u003c\/p\u003e \u003cp\u003eExercises 638\u003c\/p\u003e \u003cp\u003e\u003cb\u003e43 \u003c\/b\u003e\u003cb\u003eThe Mathematics Behind \u003ci\u003eThe Tipping Point \u003c\/i\u003e641\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eNetwork Contagion 641\u003c\/p\u003e \u003cp\u003eA Bass Version of the Tipping Point 646\u003c\/p\u003e \u003cp\u003eSummary 650\u003c\/p\u003e \u003cp\u003eExercises 650\u003c\/p\u003e \u003cp\u003e\u003cb\u003e44 \u003c\/b\u003e\u003cb\u003eViral Marketing 653\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eWatts’ Model 654\u003c\/p\u003e \u003cp\u003eA More Complex Viral Marketing Model 655\u003c\/p\u003e \u003cp\u003eSummary 660\u003c\/p\u003e \u003cp\u003eExercises 661\u003c\/p\u003e \u003cp\u003e\u003cb\u003e45 \u003c\/b\u003e\u003cb\u003eText Mining 663\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eText Mining Definitions 664\u003c\/p\u003e \u003cp\u003eGiving Structure to Unstructured Text 664\u003c\/p\u003e \u003cp\u003eApplying Text Mining in Real Life Scenarios 668\u003c\/p\u003e \u003cp\u003eSummary 671\u003c\/p\u003e \u003cp\u003eExercises 671\u003c\/p\u003e \u003cp\u003eIndex 673\u003c\/p\u003e","brand":"John Wiley \u0026 Sons Inc","offers":[{"title":"Default Title","offer_id":49406861148503,"sku":"9781118373439","price":33.59,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0817\/1739\/5799\/files\/9781118373439.jpg?v=1730497366"},{"product_id":"excel-2013-power-programming-with-vba-9781118490396","title":"Excel 2013 Power Programming with VBA","description":"\u003cb\u003eBook Synopsis\u003c\/b\u003e\u003cbr\u003eMaximize your Excel 2013 experience using VBA application development The new Excel 2013 boasts updated features, enhanced power, and new capabilities.\u003cbr\u003e\u003cbr\u003e\u003cb\u003eTable of Contents\u003c\/b\u003e\u003cbr\u003e\u003cp\u003eIntroduction 1\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart I: Some Essential Background\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 1: Excel in a Nutshell 11\u003c\/p\u003e \u003cp\u003eChapter 2: Formula Tricks and Techniques 39\u003c\/p\u003e \u003cp\u003eChapter 3: Understanding Excel Files 75\u003c\/p\u003e \u003cp\u003eChapter 4: Essentials of Spreadsheet Application Development 97\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart II: Understanding Visual Basic for Applications\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 5: Introducing Visual Basic for Applications 119\u003c\/p\u003e \u003cp\u003eChapter 6: VBA Programming Fundamentals 177\u003c\/p\u003e \u003cp\u003eChapter 7: Working with VBA Sub Procedures 227\u003c\/p\u003e \u003cp\u003eChapter 8: Creating Function Procedures 269\u003c\/p\u003e \u003cp\u003eChapter 9: VBA Programming Examples and Techniques 317\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart III: Working with UserForms\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 10: Custom Dialog Box Alternatives 395\u003c\/p\u003e \u003cp\u003eChapter 11: Introducing UserForms 417\u003c\/p\u003e \u003cp\u003eChapter 12: UserForm Examples 453\u003c\/p\u003e \u003cp\u003eChapter 13: Advanced UserForm Techniques 491\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart IV: Advanced Programming Techniques\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 14: Developing Excel Utilities with VBA 543\u003c\/p\u003e \u003cp\u003eChapter 15: Working with Pivot Tables 565\u003c\/p\u003e \u003cp\u003eChapter 16: Working with Charts 583\u003c\/p\u003e \u003cp\u003eChapter 17: Understanding Excel’s Events 645\u003c\/p\u003e \u003cp\u003eChapter 18: Interacting with Other Applications 685\u003c\/p\u003e \u003cp\u003eChapter 19: Creating and Using Add-Ins 711\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart V: Developing Applications\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 20: Working with the Ribbon 743\u003c\/p\u003e \u003cp\u003eChapter 21: Working with Shortcut Menus 779\u003c\/p\u003e \u003cp\u003eChapter 22: Providing Help for Your Applications 801\u003c\/p\u003e \u003cp\u003eChapter 23: Developing User-Oriented Applications. 821\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart VI: Other Topics\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 24: Compatibility Issues 837\u003c\/p\u003e \u003cp\u003eChapter 25: Manipulating Files with VBA 851\u003c\/p\u003e \u003cp\u003eChapter 26: Manipulating Visual Basic Components 885\u003c\/p\u003e \u003cp\u003eChapter 27: Understanding Class Modules 911\u003c\/p\u003e \u003cp\u003eChapter 28: Working with Colors 927\u003c\/p\u003e \u003cp\u003eChapter 29: Frequently Asked Questions about Excel Programming 953\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart VII: Appendixes\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eAppendix A: VBA Statements and Functions Reference 989\u003c\/p\u003e \u003cp\u003eAppendix B: VBA Error Codes 999\u003c\/p\u003e \u003cp\u003eAppendix C: This Book’s Website 1003\u003c\/p\u003e \u003cp\u003eIndex 1019\u003c\/p\u003e","brand":"John Wiley \u0026 Sons Inc","offers":[{"title":"Default Title","offer_id":49406879170903,"sku":"9781118490396","price":999.99,"currency_code":"GBP","in_stock":false}]},{"product_id":"advanced-excel-reporting-for-management-accountants-9781118657720","title":"Advanced Excel Reporting for Management","description":"\u003cb\u003eBook Synopsis\u003c\/b\u003e\u003cbr\u003e\u003cb\u003eThe advanced tools accountants need to build automated, reliable, and scalable reports using Excel\u003c\/b\u003e \u003cp\u003eLearn about the functions that work together to automate many of the processes involved in Management Reporting. See how to take advantage of the many new features of Excel 2007 and 2010. Find out how to build validation structures into your spreadsheet reports. Discover how to identify missing or new codes, either in the creation process or in the day-to-day running of the reports. Do it all with \u003ci\u003eAdvanced Excel Reporting for Management Accountants\u003c\/i\u003e.\u003c\/p\u003e \u003cul\u003e \u003cli\u003eExplore the structures that simplify the report creation process and make the reports more maintainable\u003c\/li\u003e \u003cli\u003eLearn techniques to cleanse data so that it is ready for use in Pivot Tables and formula-based reports\u003c\/li\u003e \u003cli\u003eFind out the tips and tricks that can make the creation process quicker and easier\u003c\/li\u003e \u003cli\u003eDiscover all you need to know about Excel''s summing functions and how versatile they can be\u003c\/li\u003e \u003cbr\u003e\u003cbr\u003e\u003cb\u003eTable of Contents\u003c\/b\u003e\u003cbr\u003e\u003cp\u003ePreface xiii\u003c\/p\u003e \u003cp\u003eAcknowledgments xv\u003c\/p\u003e \u003cp\u003eIntroduction 1\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 1 Management Accounting and Excel 3\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eAssumptions 3\u003c\/p\u003e \u003cp\u003eThe Goal of Reporting 5\u003c\/p\u003e \u003cp\u003eWhy Use Excel? 5\u003c\/p\u003e \u003cp\u003eThe Goal of This Book 6\u003c\/p\u003e \u003cp\u003eMonthly Management Reports 7\u003c\/p\u003e \u003cp\u003eMacro Policy 7\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 2 Building Reporting Models 9\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eNeeds Analysis 10\u003c\/p\u003e \u003cp\u003eScope Definition 10\u003c\/p\u003e \u003cp\u003eDesign 11\u003c\/p\u003e \u003cp\u003eConstruction 11\u003c\/p\u003e \u003cp\u003eTesting 12\u003c\/p\u003e \u003cp\u003eOperation 12\u003c\/p\u003e \u003cp\u003eMaintenance 12\u003c\/p\u003e \u003cp\u003eTime, Effort, and Cost 12\u003c\/p\u003e \u003cp\u003ePractical Considerations 13\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 3 Building Tips 15\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eDisplay Tips 16\u003c\/p\u003e \u003cp\u003eKeyboard Shortcuts 26\u003c\/p\u003e \u003cp\u003eMouse Shortcuts 33\u003c\/p\u003e \u003cp\u003eKeyboard and Mouse Shortcuts 42\u003c\/p\u003e \u003cp\u003eGeneral Tips 48\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 4 Design and Structure 57\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eStructure = Flexibility 57\u003c\/p\u003e \u003cp\u003eModular Sheet Design 58\u003c\/p\u003e \u003cp\u003eStandardised Report Layout 60\u003c\/p\u003e \u003cp\u003eTable-Based Systems 62\u003c\/p\u003e \u003cp\u003eSpreadsheet Best Practices 63\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 5 Setting the Foundation 67\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eTerminology 68\u003c\/p\u003e \u003cp\u003eData Rules 68\u003c\/p\u003e \u003cp\u003eData Structures 69\u003c\/p\u003e \u003cp\u003eFormat as Table 70\u003c\/p\u003e \u003cp\u003eData Cleansing Techniques 74\u003c\/p\u003e \u003cp\u003eExternal Data 80\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 6 Pivot Tables (Do-It-Yourself Reporting) 85\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eThe Pros and Cons of a Pivot Table 85\u003c\/p\u003e \u003cp\u003eCreating a Pivot Table 88\u003c\/p\u003e \u003cp\u003ePowerPivot 108\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 7 Tools of the Trade: Summing Functions 111\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eRange Names 112\u003c\/p\u003e \u003cp\u003eUsing Cells and Ranges in Formulas 112\u003c\/p\u003e \u003cp\u003eThe Humble SUM Function 116\u003c\/p\u003e \u003cp\u003eAdvanced SUM and 3D Formulas 117\u003c\/p\u003e \u003cp\u003eSubtotaling 120\u003c\/p\u003e \u003cp\u003eThe SUBTOTAL Function 121\u003c\/p\u003e \u003cp\u003eThe AGGREGATE Function 125\u003c\/p\u003e \u003cp\u003eFunction Wizard 127\u003c\/p\u003e \u003cp\u003eConditional Summing 127\u003c\/p\u003e \u003cp\u003eThe SUMIF Function 131\u003c\/p\u003e \u003cp\u003eSUMIF Uses 135\u003c\/p\u003e \u003cp\u003eHelper Cells 135\u003c\/p\u003e \u003cp\u003eThe SUMIFS Function 136\u003c\/p\u003e \u003cp\u003eThe SUMPRODUCT Function 138\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 8 Accessories: Other Reporting Functions and Features 153\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eHelper Cells 153\u003c\/p\u003e \u003cp\u003eLogic Functions 155\u003c\/p\u003e \u003cp\u003eThe IF Function 157\u003c\/p\u003e \u003cp\u003eThe AND and OR Functions 161\u003c\/p\u003e \u003cp\u003eLookup Functions 164\u003c\/p\u003e \u003cp\u003eThe VLOOKUP Function 164\u003c\/p\u003e \u003cp\u003eThe HLOOKUP Function 168\u003c\/p\u003e \u003cp\u003eAn Alternative to VLOOKUP 170\u003c\/p\u003e \u003cp\u003eThe INDEX and MATCH Functions 170\u003c\/p\u003e \u003cp\u003eThe MATCH Function 170\u003c\/p\u003e \u003cp\u003eThe INDEX Function 172\u003c\/p\u003e \u003cp\u003eThe INDEX-MATCH Combination 174\u003c\/p\u003e \u003cp\u003eError Handling Functions 175\u003c\/p\u003e \u003cp\u003eThe IFERROR Function 175\u003c\/p\u003e \u003cp\u003eHandling Specific Errors 177\u003c\/p\u003e \u003cp\u003eText-Based Functions 180\u003c\/p\u003e \u003cp\u003eThe TEXT Function 181\u003c\/p\u003e \u003cp\u003eLEFT and RIGHT Functions 183\u003c\/p\u003e \u003cp\u003eThe MID Function 184\u003c\/p\u003e \u003cp\u003eFlexible Text Manipulations 185\u003c\/p\u003e \u003cp\u003eThe SEARCH Function 185\u003c\/p\u003e \u003cp\u003eThe LEN Function 187\u003c\/p\u003e \u003cp\u003eFlexible Splitting 187\u003c\/p\u003e \u003cp\u003eThe SUBSTITUTE Function 188\u003c\/p\u003e \u003cp\u003eConverting Text to Numbers 190\u003c\/p\u003e \u003cp\u003eDate Functions 190\u003c\/p\u003e \u003cp\u003eThe DATE Function 191\u003c\/p\u003e \u003cp\u003eOther Useful Functions 192\u003c\/p\u003e \u003cp\u003eArray Formulas 201\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 9 Range Names 209\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eAdvantages 210\u003c\/p\u003e \u003cp\u003eDisadvantages 210\u003c\/p\u003e \u003cp\u003eCreating a Range Name 211\u003c\/p\u003e \u003cp\u003eUsing Range Names 213\u003c\/p\u003e \u003cp\u003eName Manager 216\u003c\/p\u003e \u003cp\u003eNaming a Range 218\u003c\/p\u003e \u003cp\u003eCreating Names Automatically 222\u003c\/p\u003e \u003cp\u003eName Intersections 227\u003c\/p\u003e \u003cp\u003eDynamic Range Names 228\u003c\/p\u003e \u003cp\u003eUsing Structure in Range Names 233\u003c\/p\u003e \u003cp\u003eINDIRECT and Range Names 236\u003c\/p\u003e \u003cp\u003eListing Range Names 237\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 10 Maintenance Issues 239\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eMaintenance Instructions 239\u003c\/p\u003e \u003cp\u003eThe Advantages of Using Tables 240\u003c\/p\u003e \u003cp\u003eCommon Issues 241\u003c\/p\u003e \u003cp\u003eRolling the Year 241\u003c\/p\u003e \u003cp\u003eWorking with Days 242\u003c\/p\u003e \u003cp\u003eSimplifying the Interface by Using Controls 244\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 11 Choosing the Right Format 255\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eColour Blindness 255\u003c\/p\u003e \u003cp\u003eFormat Painter 256\u003c\/p\u003e \u003cp\u003eLess Is More 256\u003c\/p\u003e \u003cp\u003eFonts 257\u003c\/p\u003e \u003cp\u003eClear and Start Again 257\u003c\/p\u003e \u003cp\u003eThe Format Cells Dialog Box 257\u003c\/p\u003e \u003cp\u003eStyles 270\u003c\/p\u003e \u003cp\u003eConditional Formatting 272\u003c\/p\u003e \u003cp\u003ePrinting Issues 293\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 12 Picture Perfect: Charting Techniques 299\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChart versus Graph 300\u003c\/p\u003e \u003cp\u003eChart Basics 300\u003c\/p\u003e \u003cp\u003eCharts for Reports 302\u003c\/p\u003e \u003cp\u003eAutomating Charts 302\u003c\/p\u003e \u003cp\u003eMixing Chart Types 307\u003c\/p\u003e \u003cp\u003eDual-Axis Charts 308\u003c\/p\u003e \u003cp\u003eHandling Missing Data 311\u003c\/p\u003e \u003cp\u003eLabeling Highs and Lows 313\u003c\/p\u003e \u003cp\u003eTrendlines and Moving Averages 315\u003c\/p\u003e \u003cp\u003ePlotting the Variance 316\u003c\/p\u003e \u003cp\u003eDashboard Techniques 317\u003c\/p\u003e \u003cp\u003eText in a Chart 331\u003c\/p\u003e \u003cp\u003eThe Data Series Formula 332\u003c\/p\u003e \u003cp\u003eBefore and After Charts 333\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 13 Quality Control: Report Validation 337\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eIdentifying Errors 337\u003c\/p\u003e \u003cp\u003eValidations 338\u003c\/p\u003e \u003cp\u003eError Tracking 340\u003c\/p\u003e \u003cp\u003eIdentifying New Codes 346\u003c\/p\u003e \u003cp\u003eConditional Formatting 347\u003c\/p\u003e \u003cp\u003eSuggested Validation Structure 347\u003c\/p\u003e \u003cp\u003eReasonableness Checks 349\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 14 Case Study One: Month and Year-to-Date Reporting 351\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eScenario 351\u003c\/p\u003e \u003cp\u003eData Requirements 352\u003c\/p\u003e \u003cp\u003eProcesses 352\u003c\/p\u003e \u003cp\u003eStructure 354\u003c\/p\u003e \u003cp\u003eDesign 354\u003c\/p\u003e \u003cp\u003eReport Layout 355\u003c\/p\u003e \u003cp\u003eThe Creation Process 355\u003c\/p\u003e \u003cp\u003eThe Reports 363\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 15 Case Study Two: 12-Month Reporting 379\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eScenario 379\u003c\/p\u003e \u003cp\u003eData Requirements 380\u003c\/p\u003e \u003cp\u003eProcesses 381\u003c\/p\u003e \u003cp\u003eStructure 381\u003c\/p\u003e \u003cp\u003eDesign 382\u003c\/p\u003e \u003cp\u003eThe Creation Process 382\u003c\/p\u003e \u003cp\u003eThe Reports 387\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 16 Final Thoughts 407\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eFeedback 408\u003c\/p\u003e \u003cp\u003eLast Words 408\u003c\/p\u003e \u003cp\u003eAbout the Author 409\u003c\/p\u003e \u003cp\u003eAbout the Companion Website 411\u003c\/p\u003e \u003cp\u003eIndex 413\u003c\/p\u003e\n\u003c\/ul\u003e","brand":"John Wiley \u0026 Sons Inc","offers":[{"title":"Default Title","offer_id":49406901748055,"sku":"9781118657720","price":37.5,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0817\/1739\/5799\/files\/9781118657720.jpg?v=1730497498"},{"product_id":"data-analysis-using-sql-and-excel-9781119021438","title":"Data Analysis Using SQL and Excel","description":"\u003cb\u003eBook Synopsis\u003c\/b\u003e\u003cbr\u003e\u003cb\u003eA practical guide to data mining using SQL and Excel\u003c\/b\u003e \u003cp\u003e\u003ci\u003eData Analysis Using SQL and Excel, 2nd Edition\u003c\/i\u003e shows you how to leverage the two most popular tools for data query and analysisSQL and Excelto perform sophisticated data analysis without the need for complex and expensive data mining tools. Written by a leading expert on business data mining, this book shows you how to extract useful business information from relational databases. You''ll learn the fundamental techniques before moving into the where and why of each analysis, and then learn how to design and perform these analyses using SQL and Excel. Examples include SQL and Excel code, and the appendix shows how non-standard constructs are implemented in other major databases, including Oracle and IBM DB2\/UDB. The companion website includes datasets and Excel spreadsheets, and the book provides hints, warnings, and technical asides to help you every step of the way.\u003c\/p\u003e \u003cp\u003e\u003ci\u003eData Analysis Using SQL and Excel, 2nd \u003cbr\u003e\u003cbr\u003e\u003cb\u003eTable of Contents\u003c\/b\u003e\u003cbr\u003e\u003c\/i\u003e\u003c\/p\u003e\u003cp\u003eForeword xxxiii\u003c\/p\u003e \u003cp\u003eIntroduction xxxvii\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 1 A Data Miner Looks at SQL 1\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eDatabases, SQL, and Big Data 2\u003c\/p\u003e \u003cp\u003ePicturing the Structure of the Data 6\u003c\/p\u003e \u003cp\u003ePicturing Data Analysis Using Dataflows 16\u003c\/p\u003e \u003cp\u003eSQL Queries 21\u003c\/p\u003e \u003cp\u003eSubqueries and Common Table Expressions Are Our Friends 36\u003c\/p\u003e \u003cp\u003eLessons Learned 47\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 2 What’s in a Table? Getting Started with Data Exploration 49\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eWhat Is Data Exploration? 50\u003c\/p\u003e \u003cp\u003eExcel for Charting 51\u003c\/p\u003e \u003cp\u003eSparklines 65\u003c\/p\u003e \u003cp\u003eWhat Values Are in the Columns? 68\u003c\/p\u003e \u003cp\u003eMore Values to Explore—Min, Max, and Mode 79\u003c\/p\u003e \u003cp\u003eExploring String Values 81\u003c\/p\u003e \u003cp\u003eExploring Values in Two Columns 86\u003c\/p\u003e \u003cp\u003eFrom Summarizing One Column to Summarizing All Columns 90\u003c\/p\u003e \u003cp\u003eLessons Learned 96\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 3 How Different Is Different? 97\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eBasic Statistical Concepts 98\u003c\/p\u003e \u003cp\u003eHow Different Are the Averages? 105\u003c\/p\u003e \u003cp\u003eSampling from a Table 110\u003c\/p\u003e \u003cp\u003eCounting Possibilities 115\u003c\/p\u003e \u003cp\u003eRatios and Their Statistics 128\u003c\/p\u003e \u003cp\u003eChi-Square 132\u003c\/p\u003e \u003cp\u003eWhat Months and Payment Types Have Unusual Affinities for Which Types of Products? 140\u003c\/p\u003e \u003cp\u003eLessons Learned 143\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 4 Where Is It All Happening? Location, Location, Location 145\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eLatitude and Longitude 146\u003c\/p\u003e \u003cp\u003eCensus Demographics 160\u003c\/p\u003e \u003cp\u003eGeographic Hierarchies 172\u003c\/p\u003e \u003cp\u003eMapping in Excel 188\u003c\/p\u003e \u003cp\u003eLessons Learned 194\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 5 It’s a Matter of Time 197\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eDates and Times in Databases 198\u003c\/p\u003e \u003cp\u003eStarting to Investigate Dates 204\u003c\/p\u003e \u003cp\u003eHow Long Between Two Dates? 218\u003c\/p\u003e \u003cp\u003eYear-over-Year Comparisons 229\u003c\/p\u003e \u003cp\u003eCounting Active Customers by Day 239\u003c\/p\u003e \u003cp\u003eSimple Chart Animation in Excel 247\u003c\/p\u003e \u003cp\u003eLessons Learned 254\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 6 How Long Will Customers Last? Survival Analysis to Understand Customers and Their Value 255\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eBackground on Survival Analysis 256\u003c\/p\u003e \u003cp\u003eThe Hazard Calculation 260\u003c\/p\u003e \u003cp\u003eSurvival and Retention 269\u003c\/p\u003e \u003cp\u003eComparing Different Groups of Customers 280\u003c\/p\u003e \u003cp\u003eComparing Survival over Time 287\u003c\/p\u003e \u003cp\u003eImportant Measures Derived from Survival 293\u003c\/p\u003e \u003cp\u003eUsing Survival for Customer Value Calculations 298\u003c\/p\u003e \u003cp\u003eForecasting 308\u003c\/p\u003e \u003cp\u003eLessons Learned 314\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 7 Factors Affecting Survival: The What and Why of Customer Tenure 315\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eWhich Factors Are Important and When 316\u003c\/p\u003e \u003cp\u003eLeft Truncation 328\u003c\/p\u003e \u003cp\u003eTime Windowing 336\u003c\/p\u003e \u003cp\u003eCompeting Risks 342\u003c\/p\u003e \u003cp\u003eBefore and After 353\u003c\/p\u003e \u003cp\u003eLessons Learned 366\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 8 Customer Purchases and Other Repeated Events 367\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eIdentifying Customers 368\u003c\/p\u003e \u003cp\u003eRFM Analysis 393\u003c\/p\u003e \u003cp\u003eWhich Households Are Increasing Purchase Amounts Over Time? 404\u003c\/p\u003e \u003cp\u003eTime to Next Event 416\u003c\/p\u003e \u003cp\u003eLessons Learned 420\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 9 What’s in a Shopping Cart? Market Basket Analysis 421\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eExploring the Products 422\u003c\/p\u003e \u003cp\u003eProducts and Customer Worth 437\u003c\/p\u003e \u003cp\u003eProduct Geographic Distribution 448\u003c\/p\u003e \u003cp\u003eWhich Customers Have Particular Products? 451\u003c\/p\u003e \u003cp\u003eLessons Learned 463\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 10 Association Rules and Beyond 465\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eItem Sets 466\u003c\/p\u003e \u003cp\u003eThe Simplest Association Rules 480\u003c\/p\u003e \u003cp\u003eOne-Way Association Rules 483\u003c\/p\u003e \u003cp\u003eTwo-Way Associations 489\u003c\/p\u003e \u003cp\u003eExtending Association Rules 499\u003c\/p\u003e \u003cp\u003eLessons Learned 506\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 11 Data Mining Models in SQL 507\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eIntroduction to Directed Data Mining 508\u003c\/p\u003e \u003cp\u003eLook-Alike Models 515\u003c\/p\u003e \u003cp\u003eLookup Model for Most Popular Product 522\u003c\/p\u003e \u003cp\u003eLookup Model for Order Size 528\u003c\/p\u003e \u003cp\u003eLookup Model for Probability of Response 534\u003c\/p\u003e \u003cp\u003eNaive Bayesian Models (Evidence Models) 546\u003c\/p\u003e \u003cp\u003eLessons Learned 559\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 12 The Best-Fit Line: Linear Regression Models 561\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eThe Best-Fit Line 562\u003c\/p\u003e \u003cp\u003eMeasuring Goodness of Fit Using R\u003csup\u003e2\u003c\/sup\u003e 581\u003c\/p\u003e \u003cp\u003eDirect Calculation of Best-Fit Line Coefficients 584\u003c\/p\u003e \u003cp\u003eWeighted Linear Regression 592\u003c\/p\u003e \u003cp\u003eMore Than One Input Variable 600\u003c\/p\u003e \u003cp\u003eLessons Learned 607\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 13 Building Customer Signatures for Further Analysis 609\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eWhat Is a Customer Signature? 610\u003c\/p\u003e \u003cp\u003eDesigning Customer Signatures 617\u003c\/p\u003e \u003cp\u003eOperations to Build Customer Signatures 622\u003c\/p\u003e \u003cp\u003eExtracting Features 639\u003c\/p\u003e \u003cp\u003eSummarizing Customer Behaviors 644\u003c\/p\u003e \u003cp\u003eLessons Learned 653\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 14 Performance Is the Issue: Using SQL Effectively 655\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eQuery Engines and Performance 656\u003c\/p\u003e \u003cp\u003eConsiderations When Thinking About Performance 660\u003c\/p\u003e \u003cp\u003ePerformance: Its Meaning and Measurement 663\u003c\/p\u003e \u003cp\u003ePerformance Improvement 101 665\u003c\/p\u003e \u003cp\u003eUsing Indexes Effectively 668\u003c\/p\u003e \u003cp\u003eWhen OR Is a Bad Thing 683\u003c\/p\u003e \u003cp\u003ePros and Cons: Different Ways of Expressing the Same Thing 686\u003c\/p\u003e \u003cp\u003eWindow Functions 694\u003c\/p\u003e \u003cp\u003eLessons Learned 701\u003c\/p\u003e \u003cp\u003eAppendix Equivalent Constructs Among Databases 703\u003c\/p\u003e \u003cp\u003eIndex 731\u003c\/p\u003e","brand":"John Wiley \u0026 Sons Inc","offers":[{"title":"Default Title","offer_id":49406967939415,"sku":"9781119021438","price":37.05,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0817\/1739\/5799\/files\/9781119021438.jpg?v=1730497727"},{"product_id":"introduction-to-quantitative-methods-in-business-9781119221074","title":"Introduction to Quantitative Methods in Business","description":"\u003cb\u003eBook Synopsis\u003c\/b\u003e\u003cbr\u003e\u003cp\u003eSet includes Introduction to Quantitative Methods in Business: With Applications Using Microsoft Office Excel ISBN 978-1-119-22097-8 and the accompanying Solutions Manual ISBN 978-1-119-22102-9\u003c\/p\u003e \u003cp\u003e\u003cb\u003eA well-balanced and accessible introduction to the elementary quantitative methods and Microsoft Office Excel applications used to guide business decision making\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eFeaturing quantitative techniques essential for modeling modern business situations, \u003ci\u003eIntroduction \u003c\/i\u003e\u003ci\u003eto Quantitative Methods in Business: With Applications Using Microsoft Office Excel\u003c\/i\u003e provides guidance to assessing real-world data sets using Excel. The book presents a balanced approach to the mathematical tools and techniques with applications used in the areas of business, finance, economics, marketing, and operations.\u003c\/p\u003e \u003cp\u003eThe authors begin by establishing a solid foundation of basic mathematics and statistics before moving on to more advanced concepts. The first part of the book starts by develop\u003c\/p\u003e","brand":"John Wiley \u0026 Sons Inc","offers":[{"title":"Default Title","offer_id":49407010046295,"sku":"9781119221074","price":107.96,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0817\/1739\/5799\/files\/9781119221074.jpg?v=1730497874"},{"product_id":"solutions-manual-to-accompany-introduction-to-quantitative-methods-in-business-with-applications-using-microsoft-office-excel-9781119221029","title":"Solutions Manual to Accompany Introduction to","description":"\u003cb\u003eBook Synopsis\u003c\/b\u003e\u003cbr\u003eSolutions Manual to accompany Introduction to Quantitative Methods in Business: With Applications Using Microsoft(R) Office Excel(R).\u003cbr\u003e\u003cbr\u003e\u003cb\u003eTable of Contents\u003c\/b\u003e\u003cbr\u003e\u003cp\u003e\u003cb\u003e1. The Mathematical Toolbox: A Summary 1\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e1.2 Linear Functions 1\u003c\/p\u003e \u003cp\u003e1.3.1 Solving Two Simultaneous Linear Equations 1\u003c\/p\u003e \u003cp\u003e1.4 Summation Notation 2\u003c\/p\u003e \u003cp\u003e1.5 Sets 3\u003c\/p\u003e \u003cp\u003e1.6 Functions and Graphs 3\u003c\/p\u003e \u003cp\u003e1.7 Working with Functions 4\u003c\/p\u003e \u003cp\u003e1.8 Differentiation and Integration 5\u003c\/p\u003e \u003cp\u003eSolutions to Odd-Numbered Exercises 8\u003c\/p\u003e \u003cp\u003e\u003cb\u003e2. Applications of Linear and Nonlinear Functions: A Summary 32\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e2.2 Linear Demand and Supply Functions 32\u003c\/p\u003e \u003cp\u003e2.3 Linear Total Cost and Total Revenue Functions 33\u003c\/p\u003e \u003cp\u003e2.4 Market Equilibrium 33\u003c\/p\u003e \u003cp\u003e2.6 Applications of Nonlinear Functions 34\u003c\/p\u003e \u003cp\u003e2.7 Present Value of an Income Stream 35\u003c\/p\u003e \u003cp\u003e2.8 Average Values 35\u003c\/p\u003e \u003cp\u003e2.9 Marginal Values 36\u003c\/p\u003e \u003cp\u003e2.10 Elasticity 36\u003c\/p\u003e \u003cp\u003eSolutions to Odd-Numbered Exercises 37\u003c\/p\u003e \u003cp\u003e\u003cb\u003e3. Optimization: A Summary 47\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e3.2 Unconstrained Optimization 47\u003c\/p\u003e \u003cp\u003e3.2.1 Models of Profit and Revenue Maximization 47\u003c\/p\u003e \u003cp\u003e3.2.3 Solution Using the Calculus Approach 47\u003c\/p\u003e \u003cp\u003e3.2.5 Solution Using the Calculus Approach 47\u003c\/p\u003e \u003cp\u003e3.3 Models of Cost Minimization: Inventory Cost Functions and Economic Order Quantity (EOQ) 48\u003c\/p\u003e \u003cp\u003e3.3.2 Solution Using the Calculus Approach 49\u003c\/p\u003e \u003cp\u003e3.4 Constrained Optimization: Linear Programming 50\u003c\/p\u003e \u003cp\u003e3.4.1 Linear Programming: Maximization 50\u003c\/p\u003e \u003cp\u003e3.4.2 Linear Programming: Minimization 51\u003c\/p\u003e \u003cp\u003eSolutions to Odd-Numbered Exercises 52\u003c\/p\u003e \u003cp\u003e\u003cb\u003e4. What Is Business Statistics? 68\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e4.3 Descriptive Statistics: Tabular and Graphical Techniques 68\u003c\/p\u003e \u003cp\u003e4.4 Descriptive Statistics: Numerical Measures of Central Tendency or Location of Data 70\u003c\/p\u003e \u003cp\u003e4.4.1 Population Mean 70\u003c\/p\u003e \u003cp\u003e4.4.2 Sample Mean 70\u003c\/p\u003e \u003cp\u003e4.4.3 Weighted Mean 70\u003c\/p\u003e \u003cp\u003e4.4.4 Mean of a Frequency Distribution: Grouped Data 71\u003c\/p\u003e \u003cp\u003e4.4.5 Geometric Mean 71\u003c\/p\u003e \u003cp\u003e4.4.6 Median 71\u003c\/p\u003e \u003cp\u003e4.4.7 Quantiles, Quartiles, Deciles, and Percentiles 71\u003c\/p\u003e \u003cp\u003e4.4.8 Mode 72\u003c\/p\u003e \u003cp\u003e4.5 Descriptive Statistics: Measures of Dispersion (Variability or Spread) 73\u003c\/p\u003e \u003cp\u003e4.5.2 Variance 73\u003c\/p\u003e \u003cp\u003e4.5.3 Standard Deviation 74\u003c\/p\u003e \u003cp\u003e4.5.4 Coefficient of Variation 74\u003c\/p\u003e \u003cp\u003e4.5.5 Some Important Uses of the Standard Deviation 75\u003c\/p\u003e \u003cp\u003e1. Standardization of Values 75\u003c\/p\u003e \u003cp\u003e2. Chebysheff’s Theorem 75\u003c\/p\u003e \u003cp\u003e4.5.6 Empirical Rule 75\u003c\/p\u003e \u003cp\u003e4.6 Measuring Skewness 76\u003c\/p\u003e \u003cp\u003eSolutions to Odd-Numbered Exercises 76\u003c\/p\u003e \u003cp\u003e\u003cb\u003e5. Probability and Applications 96\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e5.2 Some Useful Definitions 96\u003c\/p\u003e \u003cp\u003e5.3 Probability Sources 96\u003c\/p\u003e \u003cp\u003e5.3.1 Objective Probability 96\u003c\/p\u003e \u003cp\u003e5.4 Some Useful Definitions Involving Sets of Events in the Sample Space 96\u003c\/p\u003e \u003cp\u003e5.5 Probability Laws 97\u003c\/p\u003e \u003cp\u003e5.5.2 Rule of Complements 97\u003c\/p\u003e \u003cp\u003e5.5.3 Conditional Probability 97\u003c\/p\u003e \u003cp\u003e5.5.4 General Multiplication Rule (Product Rule) 97\u003c\/p\u003e \u003cp\u003e5.5.5 Independent Events 98\u003c\/p\u003e \u003cp\u003e5.5.6 Probability Tree Approach 98\u003c\/p\u003e \u003cp\u003e5.6 Contingency Table 98\u003c\/p\u003e \u003cp\u003eSolutions to Odd-Numbered Exercises 100\u003c\/p\u003e \u003cp\u003e\u003cb\u003e6. Random Variables and Probability Distributions 105\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e6.2 Probability Distribution of a Discrete Random Variable X 105\u003c\/p\u003e \u003cp\u003e6.3 Expected Value, Variance, and Standard Deviation of a Discrete Random Variable 106\u003c\/p\u003e \u003cp\u003e6.3.1 Some Basic Rules of Expectation 106\u003c\/p\u003e \u003cp\u003e6.3.2 Some Useful Properties of the Variance of X 107\u003c\/p\u003e \u003cp\u003e6.4 Continuous Random Variables and Their Probability Distributions 107\u003c\/p\u003e \u003cp\u003e6.5 A Specific Discrete Probability Distribution: The Binomial Case 108\u003c\/p\u003e \u003cp\u003e6.5.1 Binomial Probability Distribution 108\u003c\/p\u003e \u003cp\u003e6.5.2 Mean and Standard Deviation of the Binomial Random Variable 109\u003c\/p\u003e \u003cp\u003e6.5.3 Cumulative Binomial Probability Distribution 110\u003c\/p\u003e \u003cp\u003eSolutions to Odd-Numbered Exercises 110\u003c\/p\u003e \u003cp\u003eIndex 119\u003c\/p\u003e","brand":"John Wiley \u0026 Sons Inc","offers":[{"title":"Default Title","offer_id":49407010079063,"sku":"9781119221029","price":24.65,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0817\/1739\/5799\/files\/9781119221029.jpg?v=1730497874"}],"url":"https:\/\/bookcurl.com\/collections\/spreadsheet-software.oembed?page=4","provider":"Book Curl","version":"1.0","type":"link"}