Spreadsheet software Books
Microsoft Press,U.S. MOS 2016 Study Guide for Microsoft Excel Expert
Book SynopsisPaul McFedries 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 My Office 2016, My Office 2016 for Mac, and Formulas and Functions for Microsoft Excel 2016. His other titles include Windows 10 In Depth, (with Brian Knittel), PCs for Grownups, and Fixing Your Computer Absolute Beginner's Guide. Table of ContentsChapter 1 — Manage and share workbooks 1.1 Manage workbooks 1.2 Manage workbook review Chapter 2 — Apply custom formats and layouts 2.1 Apply custom data formats 2.2 Apply advanced conditional formatting and filtering 2.3 Apply custom styles and templates 2.4 Prepare workbooks for internationalization and accessibility Chapter 3 — Create advanced formulas 3.1 Apply functions in formulas 3.2 Look up data by using functions 3.3 Apply advanced date and time functions 3.4 Perform data analysis and business intelligence 3.5 Troubleshoot formulas 3.6 Define named ranges and objects Chapter 4 — Create advanced charts and tables 4.1 Create advanced chart elements 4.2 Create and manage PivotTables 4.3 Create and manage PivotCharts
£16.64
Pearson Education Microsoft Copilot Studio Step by Step
a huge range and FREE tracked UK delivery on ALL orders.
£44.64
In Easy Steps Limited Microsoft Excel in easy steps: Illustrated using
Book SynopsisMicrosoft 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. Microsoft Excel in easy steps starts with the basics then reveals the key clever features on offer all in easy steps! Areas covered include:Creating, editing, and manipulating worksheets.Formulas, functions, tables and importing data. Handy templates to give you a head start. Macros for everyday tasks to save time. Charts to get an overview of your data. What-if, Goal Seek and Optimization. Using the Excel Online app to share and collaborate on spreadsheets and workbooks. Adding images and illustrations to your spreadsheets to impress your colleagues! Whether 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!
£11.39
In Easy Steps Limited Excel Functions and Formulas in easy steps
Book SynopsisExcel Functions and Formulas in easy steps shows you how to use the power of Excel functions and formulas to take full advantage of this popular spreadsheet application. Learn how to: Save time by utilizing Excel functions to carry out often-used operations, for error checking and tracing cells.Build powerful spreadsheets using the features of Excel formulas. Explore all the categories of Excel functions including financial, logical, mathematical, lookup and other data-related functions. Review business-oriented scenarios and examples of functions in each of the groups. Create your own simple macros, and more. Covering 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 in easy steps!
£11.39
No Starch Press,US Python for Excel Power Users
£33.74
In Easy Steps Limited 100 Top Tips - Microsoft Excel
Book Synopsis100 Top Tips Microsoft Excel will help you boost your productivity and get more value from your spreadsheets with this powerful book of tips. It showcases: Time-saving features (including data entry shortcuts)Powerful functions for processing text and numbersInsightful data analysis features, including pivot tables and what-if analysis. How to use graphsDebugging formulasPrinting clearlyAnd much more!You'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.As you would expect from the In Easy Steps 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.
£7.49
Pearson Education (US) MOS Study Guide for Microsoft Excel Exam MO200
Book Synopsis Joan Lambert 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 DyTable of Contents 1 Manage worksheets and workbooks Objective 1.1: Import data into workbooks Objective 1.2: Navigate within workbooks Objective 1.3: Format worksheets and workbooks Objective 1.4: Customize options and views Objective 1.5: Configure content for collaboration 2 Manage data cells and ranges Objective 2.1: Manipulate data in worksheets Objective 2.2: Format cells and ranges Objective 2.3: Define and reference named ranges Objective 2.4: Summarize data visually 3 Manage tables and table data Objective 3.1: Create and format tables Objective 3.2: Modify tables Objective 3.3: Filter and sort table data 4 Perform operations by using formulas and functions Objective 4.1: Insert references in formulas Objective 4.2: Calculate and transform data by using functions Objective 4.3: Format and modify text by using functions 5 Manage charts Objective 5.1: Create charts Objective 5.2: Modify charts Objective 5.3: Format charts
£17.09
In Easy Steps Limited Excel VBA in easy steps
Book SynopsisGet more out of Microsoft Excel and save time by learning Excel VBA (Visual Basic for Applications). Excel VBA in easy steps, 4th edition demonstrates VBA macro programming in a clear and concise manner, and will take your Excel proficiency to the next level:Write your own Excel macros so that you can do a series of tasks at the click of a button.Use VBA to automate repetitive tasks, and for functions and commands beyond Excel. Create dialog boxes for user interactions and then define processes to handle user input. Develop and share your Excel apps with colleagues they'll be impressed! Whether you're upgrading to Excel in Office 365 or new to macro programming, use this guide to master Excel VBA essentials in easy steps! Comes with free downloadable code to help you get started with Excel VBA right away!
£12.34
John Wiley & Sons Inc Excel Macros for Dummies
Book SynopsisTable of ContentsIntroduction 1 Part 1: Holy Macro Batman! 7 Chapter 1: Macro Fundamentals 9 Chapter 2: Getting Cozy with the Visual Basic Editor 29 Chapter 3: The Anatomy of Macros 43 Part 2: Making Short Work of Workbook Tasks 57 Chapter 4: Working with Workbooks 59 Chapter 5: Working with Worksheets 81 Part 3: One-Touch Data Manipulation 107 Chapter 6: Feeling at Home on the Range 109 Chapter 7: Manipulating Data with Macros 129 Part 4: Macro-Charging Reports and Emails 163 Chapter 8: Automating Common Reporting Tasks 165 Chapter 9: Sending Emails from Excel 199 Chapter 10: Wrangling External Data with Macros 217 Part 5: Part of Tens 235 Chapter 11: Ten Handy Visual Basic Editor Tips 237 Chapter 12: Ten Places to Turn for Macro Help 247 Chapter 13: Ten Ways to Speed Up Your Macros 253 Index 263
£24.79
John Wiley & Sons Inc Marketing Analytics
Book SynopsisHelping 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.Table of ContentsIntroduction xxiii I Using Excel to Summarize Marketing Data 1 1 Slicing and Dicing Marketing Data with PivotTables 3 Analyzing Sales at True Colors Hardware 3 Analyzing Sales at La Petit Bakery 14 Analyzing How Demographics Affect Sales 21 Pulling Data from a PivotTable with the GETPIVOTDATA Function 25 Summary 27 Exercises 27 2 Using Excel Charts to Summarize Marketing Data 29 Combination Charts 29 Using a PivotChart to Summarize Market Research Surveys 36 Ensuring Charts Update Automatically When New Data is Added 39 Making Chart Labels Dynamic 40 Summarizing Monthly Sales-Force Rankings 43 Using Check Boxes to Control Data in a Chart 45 Using Sparklines to Summarize Multiple Data Series 48 Using GETPIVOTDATA to Create the End-of-Week Sales Report 52 Summary 55 Exercises 55 3 Using Excel Functions to Summarize Marketing Data 59 Summarizing Data with a Histogram 59 Using Statistical Functions to Summarize Marketing Data 64 Summary 79 Exercises 80 II Pricing 83 4 Estimating Demand Curves and Using Solver to Optimize Price 85 Estimating Linear and Power Demand Curves 85 Using the Excel Solver to Optimize Price 90 Pricing Using Subjectively Estimated Demand Curves 96 Using SolverTable to Price Multiple Products 99 Summary 103 Exercises 104 5 Price Bundling 107 Why Bundle? 107 Using Evolutionary Solver to Find Optimal Bundle Prices 111 Summary 119 Exercises 119 6 Nonlinear Pricing 123 Demand Curves and Willingness to Pay 124 Profit Maximizing with Nonlinear Pricing Strategies 125 Summary 131 Exercises 132 7 Price Skimming and Sales 135 Dropping Prices Over Time 135 Why Have Sales? 138 Summary 142 Exercises 142 8 Revenue Management 143 Estimating Demand for the Bates Motel and Segmenting Customers 144 Handling Uncertainty 150 Markdown Pricing 153 Summary 156 Exercises 156 III Forecasting .159 9 Simple Linear Regression and Correlation 161 Simple Linear Regression 161 Using Correlations to Summarize Linear Relationships 170 Summary 174 Exercises 175 10 Using Multiple Regression to Forecast Sales 177 Introducing Multiple Linear Regression 178 Running a Regression with the Data Analysis Add-In 179 Interpreting the Regression Output 182 Using Qualitative Independent Variables in Regression 186 Modeling Interactions and Nonlinearities 192 Testing Validity of Regression Assumptions 195 Multicollinearity 204 Validation of a Regression 207 Summary 209 Exercises 210 11 Forecasting in the Presence of Special Events 213 Building the Basic Model 213 Summary 222 Exercises 222 12 Modeling Trend and Seasonality 225 Using Moving Averages to Smooth Data and Eliminate Seasonality 225 An Additive Model with Trends and Seasonality 228 A Multiplicative Model with Trend and Seasonality 231 Summary 234 Exercises 234 13 Ratio to Moving Average Forecasting Method 235 Using the Ratio to Moving Average Method 235 Applying the Ratio to Moving Average Method to Monthly Data 238 Summary 238 Exercises 239 14 Winter’s Method 241 Parameter Definitions for Winter’s Method 241 Initializing Winter’s Method 243 Estimating the Smoothing Constants 244 Forecasting Future Months 246 Mean Absolute Percentage Error (MAPE) 247 Summary 248 Exercises 248 15 Using Neural Networks to Forecast Sales 249 Regression and Neural Nets 249 Using Neural Networks 250 Using NeuralTools to Predict Sales 253 Using NeuralTools to Forecast Airline Miles 258 Summary 259 Exercises 259 IV What do Customers Want? 261 16 Conjoint Analysis 263 Products, Attributes, and Levels 263 Full Profile Conjoint Analysis 265 Using Evolutionary Solver to Generate Product Profiles 272 Developing a Conjoint Simulator 277 Examining Other Forms of Conjoint Analysis 279 Summary 281 Exercises 281 17 Logistic Regression 285 Why Logistic Regression Is Necessary 286 Logistic Regression Model 289 Maximum Likelihood Estimate of Logistic Regression Model 290 Using StatTools to Estimate and Test Logistic Regression Hypotheses 293 Performing a Logistic Regression with Count Data 298 Summary 300 Exercises 300 18 Discrete Choice Analysis 303 Random Utility Theory 303 Discrete Choice Analysis of Chocolate Preferences 305 Incorporating Price and Brand Equity into Discrete Choice Analysis 309 Dynamic Discrete Choice 315 Independence of Irrelevant Alternatives (IIA) Assumption 316 Discrete Choice and Price Elasticity 317 Summary 318 Exercises 319 19 Calculating Lifetime Customer Value 327 Basic Customer Value Template 328 Measuring Sensitivity Analysis with Two-way Tables 330 An Explicit Formula for the Multiplier r 331 Varying Margins 331 DIRECTV, Customer Value, and Friday Night Lights (FNL) 333 Estimating the Chance a Customer Is Still Active 334 Going Beyond the Basic Customer Lifetime Value Model 335 Summary 336 Exercises 336 20 Using Customer Value to Value a Business 339 A Primer on Valuation 339 Using Customer Value to Value a Business 340 Measuring Sensitivity Analysis with a One-way Table 343 Using Customer Value to Estimate a Firm’s Market Value 344 Summary 344 Exercises 345 21 Customer Value, Monte Carlo Simulation, and Marketing Decision Making 347 A Markov Chain Model of Customer Value 347 Using Monte Carlo Simulation to Predict Success of a Marketing Initiative 353 Summary 359 Exercises 360 22 Allocating Marketing Resources between Customer Acquisition and Retention 347 Modeling the Relationship between Spending and Customer Acquisition and Retention 365 Basic Model for Optimizing Retention and Acquisition Spending 368 An Improvement in the Basic Model 371 Summary 373 Exercises 374 VI Market Segmentation 375 23 Cluster Analysis 377 Clustering U.S. Cities 378 Using Conjoint Analysis to Segment a Market 386 Summary 391 Exercises 391 24 Collaborative Filtering 393 User-Based Collaborative Filtering 393 Item-Based Filtering 398 Comparing Item- and User-Based Collaborative Filtering 400 The Netflix Competition 401 Summary 401 Exercises 402 25 Using Classification Trees for Segmentation 403 Introducing Decision Trees 403 Constructing a Decision Tree 404 Pruning Trees and CART 409 Summary 410 Exercises 410 26 Using S Curves to Forecast Sales of a New Product 415 Examining S Curves 415 Fitting the Pearl or Logistic Curve 418 Fitting an S Curve with Seasonality 420 Fitting the Gompertz Curve 422 Pearl Curve versus Gompertz Curve 425 Summary 425 Exercises 425 27 The Bass Diffusion Model 427 Introducing the Bass Model 427 Estimating the Bass Model 428 Using the Bass Model to Forecast New Product Sales 431 Deflating Intentions Data 434 Using the Bass Model to Simulate Sales of a New Product 435 Modifications of the Bass Model 437 Summary 438 Exercises 438 28 Using the Copernican Principle to Predict Duration of Future Sales 439 Using the Copernican Principle 439 Simulating Remaining Life of Product 440 Summary 441 Exercises 441 29 Market Basket Analysis and Lift 445 Computing Lift for Two Products 445 Computing Three-Way Lifts 449 A Data Mining Legend Debunked! 453 Using Lift to Optimize Store Layout 454 Summary 456 Exercises 456 30 RFM Analysis and Optimizing Direct Mail Campaigns 459 RFM Analysis 459 An RFM Success Story 465 Using the Evolutionary Solver to Optimize a Direct Mail Campaign 465 Summary 468 Exercises 468 31 Using the SCAN*PRO Model and Its Variants 471 Introducing the SCAN*PRO Model 471 Modeling Sales of Snickers Bars 472 Forecasting Software Sales 475 Summary 480 Exercises 480 32 Allocating Retail Space and Sales Resources 483 Identifying the Sales to Marketing Effort Relationship 483 Modeling the Marketing Response to Sales Force Effort 484 Optimizing Allocation of Sales Effort 489 Using the Gompertz Curve to Allocate Supermarket Shelf Space 492 Summary 492 Exercises 493 33 Forecasting Sales from Few Data Points 495 Predicting Movie Revenues 495 Modifying the Model to Improve Forecast Accuracy 498 Using 3 Weeks of Revenue to Forecast Movie Revenues 499 Summary 501 Exercises 501 34 Measuring the Effectiveness of Advertising 505 The Adstock Model 505 Another Model for Estimating Ad Effectiveness 509 Optimizing Advertising: Pulsing versus Continuous Spending 511 Summary 514 Exercises 515 35 Media Selection Models 517 A Linear Media Allocation Model 517 Quantity Discounts 520 A Monte Carlo Media Allocation Simulation 522 Summary 527 Exercises 527 36 Pay per Click (PPC) Online Advertising 529 Defining Pay per Click Advertising 529 Profitability Model for PPC Advertising 531 Google AdWords Auction 533 Using Bid Simulator to Optimize Your Bid 536 Summary 537 Exercises 537 X Marketing Research Tools 539 37 Principal Components Analysis (PCA) 541 Defining PCA 541 Linear Combinations, Variances, and Covariances 542 Diving into Principal Components Analysis 548 Other Applications of PCA 556 Summary 557 Exercises 558 38 Multidimensional Scaling (MDS) 559 Similarity Data 559 MDS Analysis of U.S. City Distances 560 MDS Analysis of Breakfast Foods 566 Finding a Consumer’s Ideal Point 570 Summary 574 Exercises 574 39 Classification Algorithms: Naive Bayes Classifier and Discriminant Analysis 577 Conditional Probability 578 Bayes’ Theorem 579 Naive Bayes Classifier 581 Linear Discriminant Analysis 586 Model Validation 591 The Surprising Virtues of Naive Bayes 592 Summary 592 Exercises 593 40 Analysis of Variance: One-way ANOVA 595 Testing Whether Group Means Are Different 595 Example of One-way ANOVA 596 The Role of Variance in ANOVA 598 Forecasting with One-way ANOVA 599 Contrasts 601 Summary 603 Exercises 604 41 Analysis of Variance: Two-way ANOVA 607 Introducing Two-way ANOVA 607 Two-way ANOVA without Replication 608 Two-way ANOVA with Replication 611 Summary 616 Exercises 617 XI Internet and Social Marketing 619 42 Networks 621 Measuring the Importance of a Node 621 Measuring the Importance of a Link 626 Summarizing Network Structure 628 Random and Regular Networks 631 The Rich Get Richer 634 Klout Score 636 Summary 637 Exercises 638 43 The Mathematics Behind The Tipping Point 641 Network Contagion 641 A Bass Version of the Tipping Point 646 Summary 650 Exercises 650 44 Viral Marketing 653 Watts’ Model 654 A More Complex Viral Marketing Model 655 Summary 660 Exercises 661 45 Text Mining 663 Text Mining Definitions 664 Giving Structure to Unstructured Text 664 Applying Text Mining in Real Life Scenarios 668 Summary 671 Exercises 671 Index 673
£33.59
John Wiley & Sons Inc Excel Workbook For Dummies
Book SynopsisGet 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.Table of ContentsIntroduction 1 Part 1: Building Worksheets 5 Chapter 1: Getting Familiar with the Excel Interface 7 Chapter 2: Entering the Worksheet Data 21 Chapter 3: Formatting the Worksheet 37 Chapter 4: Printing Worksheet Reports 59 Chapter 5: Modifying the Worksheet 79 Part 2: Using Formulas and Functions 101 Chapter 6: Building Formulas 103 Chapter 7: Copying and Correcting Formulas 123 Chapter 8: Creating Date and Time Formulas 145 Chapter 9: Financial Formulas and Functions 155 Chapter 10: Using Math Functions 167 Chapter 11: Using Common Statistical Functions 179 Chapter 12: Using Lookup Functions 187 Chapter 13: Using Logical Functions 197 Chapter 14: Text Formulas and Functions 209 Part 3: Working with Graphics 217 Chapter 15: Charting Worksheet Data 219 Chapter 16: Adding Graphics to Worksheets 231 Part 4: Managing and Securing Data 249 Chapter 17: Building and Maintaining Tables 251 Chapter 18: Protecting Workbooks and Worksheet Data 271 Part 5: Doing Data Analysis 283 Chapter 19: Performing What-If Analysis 285 Chapter 20: Generating PivotTables 299 Part 6: Macros and Visual Basic for Applications 315 Chapter 21: Using Macros 317 Chapter 22: Using the Visual Basic Editor 327 Part 7: The Part of Tens 341 Chapter 23: Top Ten Features in Excel 343 Chapter 24: Top Ten Tips for Using Excel Like a Pro 347 Index 355
£20.39
Pearson Education Microsoft Excel Pivot Table Data Crunching
Book Synopsis
£29.69
Pearson Education (US) Microsoft Excel Step by Step Office 2021 and
Book SynopsisJoan Lambert 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. Table of ContentsIntroduction Part 1: Create and format workbooks 1 Set up a workbook 2 Work with data and Excel tables 3 Perform calculations on data 4 Change workbook appearance Part 2: Analyze and present data 5 Manage worksheet data 6 Reorder and summarize data 7 Combine data from multiple sources 8 Analyze alternative data sets 9 Create charts and graphics. 207 10 Create PivotTables and PivotCharts Part 3: Collaborate and share in Excel 11 Print worksheets and charts 12 Automate tasks and input 13 Work with other Microsoft 365 apps 14 Collaborate with colleagues Part 4: Perform advanced analysis 15 Perform business intelligence analysis 16 Create forecasts and visualizations
£28.04
Taylor & Francis Ltd Business Statistics Using Excel
Book SynopsisThis book gives readers a hands-on understanding of Excel-assisted statistical techniques to take effective business decisions. It showcases applications of the tools and techniques of statistics for analysing business data from the domain of business statistics.The volume provides an exhaustive introduction to the application of statistics in solving business problems and implementing data analytics for effective decision making in all kinds of business situations around the world. With an emphasis on simplicity in presentation of concepts of statistical methods and associated Excel functions, the volume explores the implementation of Excel functions through well-defined sequences of steps. It covers an array of key topics which include Discussions on real-world problems, decision support systems, scope of business statistics, types, and steps of research; Introduction to Excel and its mathematical and preliminary statistical functions; usage of different Table of Contents1. Introduction 2. Introduction to Excel 3. Count, Frequency and Histogram 4. Average Functions 5. Median and Mode 6. Measures of Variation 7. Measures Of Skewness 8. Probability Distributions 9. Sampling Distribution of Mean and Variance 10. Testing Of Hypothesis 11. Chi-Square Test 12. Nonparametric Test 13. Correlation and Covariance 14. Forecasting 15. Analysis of Variance (Anova) 16. Charts 17. Linear Programming
£35.99
Microsoft Press,U.S. Microsoft Excel 2019 Formulas and Functions
Book SynopsisMaster core Excel tools for building powerful, reliable spreadsheets with Excel 2019 Formulas and Functions. 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. Becoming 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. • Quickly create powerful spreadsheets with range names and array formulas • Use conditional formatting to instantly reveal anomalies, problems, or opportunities • Analyze your data with standard tables and PivotTables • Use complex criteria to filter data in lists • Understand correlations between data • Perform sophisticated what-if analyses • Use regression to track trends and make forecasts • Build loan, investment, and discount formulas • Validate data, troubleshoot problems, and build more accurate, trustworthy spreadsheets Table of ContentsPart I—Mastering Excel formulas Chapter 1—Building basic formulas Chapter 2—Creating advanced formulas Chapter 3—Troubleshooting formulas Part II—Harnessing the power of functions Chapter 4—Understanding functions Chapter 5—Working with text functions Chapter 6—Working with logical and information functions Chapter 7—Working with lookup functions Chapter 8—Working with date and time functions Chapter 9—Working with math functions Part III—Building business formulas Chapter 10—Implementing basic business formulas Chapter 11—Building descriptive statistical formulas Chapter 12—Building inferential statistical formulas Chapter 13—Applying regression to track trends and make forecasts Chapter 14—Building loan formulas Chapter 15—Working with investment formulas Chapter 16—Building discount formulas Part IV—Building business models Chapter 17—Analyzing data with tables Chapter 18—Analyzing data with PivotTables Chapter 19—Using Excel's business modeling tools Chapter 20—Solving complex problems with Solver
£25.49
John Wiley & Sons Getting Great Results with Excel Pivot Tables
Book SynopsisGet 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
£30.39
Pearson Education Collect Combine and Transform Data Using Power
Book SynopsisDaniil Maslyuk is an independent business intelligence consultant, trainer, and speaker who specializes in Microsoft Power BI. Daniil is the author of all official Microsoft Power BI exam reference books. For his community contributions, Daniil has been recognized as a Microsoft MVP. Daniil blogs at xxlbi.com and posts on X as @DMaslyuk. Gil Raviv is a seasoned Data & AI expert, founder of DataChant Consulting, and the creator of BI Pixie, an enterprise solution that measures the engagement, adoption, and user satisfaction of Microsoft Power BI audiences. Gil started his Power Query journey as a senior program manager on the Microsoft Excel Product team, where he led the design and integration of Power Query as the next-generation Get Data and data-wrangling technology in Excel 2016. Since then, Gil has been a devoted Power Query practitioner. With the knowledge of Power Query at his disposal, Gil moved to consulting, and over the course of s
£26.99
Pearson Education (US) Microsoft Excel Inside Out Office 2021 and
Book SynopsisTable of ContentsPart I The Excel interface Chapter 1 What's new in Microsoft 365 Excel Chapter 2 Using the Excel interface Chapter 3 Customizing Excel Chapter 4 Keyboard shortcuts Part II Calculating with Excel Chapter 5 Understanding formulas Chapter 6 Controlling formulas Chapter 7 Understanding functions Chapter 8 Using everyday functions: math, date and time, and text functions Chapter 9 Using powerful functions: logical, lookup, and database functions Chapter 10 Using names, LET, LAMBDA, and Data Types in Excel Chapter 11 Connecting worksheets and workbooks Chapter 12 Dynamic array formulas and names in Excel Part III Data analysis with Excel Chapter 13 Transforming data with Power Query Chapter 14 Summarizing data using subtotals or filter Chapter 15 Using pivot tables to analyze data Chapter 16 Using slicers and filtering a pivot table Chapter 17 Mashing up data with Power Pivot Chapter 18 Using What-If, Scenario Manager, Goal Seek, and Solver Chapter 19 Automating repetitive functions using VBA macros Chapter 20 More tips and tricks for Excel Part IV Excel visuals Chapter 21 Formatting worksheets Chapter 22 Using data visualizations and conditional formatting Chapter 23 Graphing data using Excel charts Chapter 24 Using 3D Maps Chapter 25 Using sparklines Chapter 26 Formatting spreadsheets for presentation Chapter 27 Printing Chapter 28 Collaborating in Excel Part V Appendixes Appendix A Excel functions Appendix B Excel functions with DAX or Power Query equivalents Appendix C Adding functionality to Excel with add-ins Index
£34.84
Microsoft Press,U.S. Microsoft Excel 2019 Pivot Table Data Crunching
Book SynopsisRenowned Excel experts Bill Jelen (MrExcel) and Michael Alexander help you crunch data from any source with Excel 2019 pivot tables. Use 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. By reading this book, you will: • Master easy, powerful ways to create, customize, change, and control pivot tables • Control all future pivot tables using new pivot table defaults • Transform huge data sets into clear summary reports • Instantly highlight your most profitable customers, products, or regions • Use Power Query to quickly import, clean, shape, and analyze disparate data sources • Build geographical pivot tables with 3D Map • Construct and share state-of-the-art dynamic dashboards • Revamp analyses on the fly by dragging and dropping fields • Build dynamic self-service reporting systems • Share your pivot tables with colleagues • Create data mashups using the full Power Pivot capabilities of Excel 2019 and Excel in Office 365 • Automate pivot tables with macros and VBA • Save time by adapting reports with GetPivotData • Discover today’s most useful pivot table tips and shortcuts Table of ContentsIntroduction Pivot Table Fundamentals Creating a Basic Pivot Table Customizing a Pivot Table Grouping, Sorting, and Filtering Pivot Data Performing Calculations in Pivot Tables Using Pivot Charts and Other Visualizations Analyzing Disparate Data Sources with Pivot Tables Sharing Dashboards with Power BI Using Cube Formulas with the Data Model or OLAP Data Unlocking Features with the Data Model and Power Pivot Analyzing Geographic Data with 3D Map Enhancing Pivot Table reports with Macros Using VBA to Create Pivot Tables Advanced Pivot Table Tips and Techniques Dr. Jekyll and Mr. GetPivotData
£25.49
Microsoft Press,U.S. Microsoft Excel 2016 Step by Step
Book SynopsisCurtis Frye is the author of more than 30 books, including Microsoft Excel 2013 Step by Step for Microsoft Press and Brilliant Excel VBA Programming for Pearson, UK. He has also created and recorded more than three dozen courses for lynda.com, including Excel for Mac 2016 Essential Training and Excel 2013: PivotTables in Depth. 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.Table of ContentsIntroduction xiii Who this book is for xiii The Step by Step approach xiii Download the practice files xiv Sidebar: Adapt exercise steps xviii Ebook edition xx Get support and give feedback xx Errata and support xx We want to hear from you xx Stay in touch xx Part 1: Create and format workbooks Chapter 1: Set up a workbook 3 Explore the editions of Excel 2016 4 Excel 2016 4 Excel Online 4 Excel Mobile Apps 5 Become familiar with new features in Excel 2016 6 Create workbooks 7 Modify workbooks 13 Modify worksheets 18 Merge and unmerge cells 23 Customize the Excel 2016 app window 26 Zoom in on a worksheet 26 Arrange multiple workbook windows 28 Add buttons to the Quick Access Toolbar 30 Customize the ribbon 33 Skills review 39 Practice tasks 40 Chapter 2: Work with data and Excel tables 43 Enter and revise data 44 Manage data by using Flash Fill 48 Move data within a workbook 51 Find and replace data 56 Correct and expand upon data 60 Define Excel tables 65 Skills review 69 Practice tasks 70 Chapter 3: Perform calculations on data 73 Name groups of data 74 Create formulas to calculate values 77 Sidebar: Operators and Precedence 88 Summarize data that meets specific conditions 90 Set iterative calculation options and enable or disable automatic calculation 96 Use array formulas 98 Find and correct errors in calculations 100 Skills review 106 Practice tasks 107 Chapter 4: Change workbook appearance 111 Format cells 112 Define styles 118 Apply workbook themes and Excel table styles 121 Make numbers easier to read 127 Change the appearance of data based on its value 130 Add images to worksheets 138 Skills review 142 Practice tasks 143 Part 2: Analyze and present dataChapter 5: Manage worksheet data 147 Limit data that appears on your screen 148 Manipulate worksheet data 153 Sidebar: Select list rows at random 154 Summarize data in worksheets that have hidden and filtered rows 155 Find unique values within a data set 161 Define valid sets of values for ranges of cells 163 Skills review 165 Practice tasks 166 Chapter 6: Reorder and summarize data 169 Sort worksheet data 170 Sort data by using custom lists 176 Organize data into levels 179 Look up information in a worksheet 184 Skills review 187 Practice tasks 188 Chapter 7: Combine data from multiple sources 191 Use workbooks as templates for other workbooks 192 Link to data in other worksheets and workbooks 197 Consolidate multiple sets of data into a single workbook 202 Skills review 205 Practice tasks 206 Chapter 8: Analyze alternative data sets 209 Examine data by using the Quick Analysis Lens 210 Define an alternative data set 212 Define multiple alternative data sets 216 Analyze data by using data tables 218 Vary your data to get a specific result by using Goal Seek 221 Find optimal solutions by using Solver 223 Analyze data by using descriptive statistics 229 Skills review 231 Practice tasks 232 Chapter 9: Create charts and graphics 237 Create charts 238 Create new types of charts 248 Customize chart appearance 252 Find trends in your data 260 Create dual-axis charts 263 Summarize your data by using sparklines 264 Create diagrams by using SmartArt 266 Create shapes and mathematical equations 271 Skills review 277 Practice tasks 278 Chapter 10: Create dynamic worksheets by using PivotTables 281 Analyze data dynamically by using PivotTables 282 Filter, show, and hide PivotTable data 290 Edit PivotTables 301 Format PivotTables 305 Create PivotTables from external data 309 Create dynamic charts by using PivotCharts 313 Skills review 316 Practice tasks 317 Part 3: Collaborate and share in Excel Chapter 11: Print worksheets and charts 323 Add headers and footers to printed pages 324 Prepare worksheets for printing 330 Fit your worksheet contents to the printed page 331 Change page breaks in a worksheet 334 Change the page printing order for worksheets 335 Print worksheets 337 Print parts of worksheets 339 Print charts 343 Skills review 345 Practice tasks 346 Chapter 12: Automate repetitive tasks by using macros 349 Enable and examine macros 350 Set macro security levels in Excel 2016 350 Examine macros 353 Create and modify macros 356 Run macros when you click a button 357 Run a macro when you open a workbook 361 Insert form controls into a worksheet 362 Skills review 369 Practice tasks 370 Chapter 13: Work with other Microsoft Office apps 373 Include Office documents in workbooks and other files 374 Link Office documents to Excel workbooks 375 Embed files in Excel and other Office apps 377 Create hyperlinks 379 Paste charts into documents 384 Skills review 385 Practice tasks 386 Chapter 14: Collaborate with colleagues 389 Share workbooks 390 Save workbooks for electronic distribution 394 Manage comments 395 Track and manage colleagues’ changes 398 Add protection to workbooks and worksheets 401 Finalize workbooks 408 Authenticate workbooks 410 Save workbooks for the web 412 Import and export XML data 414 Work with OneDrive and Excel Online 418 Skills review 424 Practice tasks 425 Part 4: Perform advanced analysis Chapter 15: Perform business intelligence analysis 431 Enable the Data Analysis add-ins 432 Define relationships between tables 434 Analyze data by using Power Pivot 438 View data by using timelines 442 Bring in external data by using Power Query 446 Skills review 451 Practice tasks 452 Chapter 16: Create forecasts and visualizations 455 Create Forecast Worksheets 456 Define and manage measures 461 Define and display Key Performance Indicators 464 Create 3D maps 468 Skills review 475 Practice tasks 476 Keyboard shortcuts 479 Glossary 89 Index 95 About the author 521
£22.09
O'Reilly Excel Cookbook
Book Synopsis
£42.39
O'Reilly Modern Data Analytics in Excel
Book Synopsis
£38.39
John Wiley & Sons Inc Using Excel for Business and Financial Modelling
Book SynopsisA hands-on guide to using Excel in the business context First published in 2012, Using Excel for Business and Financial Modelling contains step-by-step instructions of how to solve common business problems using financial models, including downloadable Excel templates, a list of shortcuts and tons of practical tips and techniques you can apply straight away. Whilst there are many hundreds of tools, features and functions in Excel, this book focuses on the topics most relevant to finance professionals. It covers these features in detail from a practical perspective, but also puts them in context by applying them to practical examples in the real world. Learn to create financial models to help make business decisions whilst applying modelling best practice methodology, tools and techniques. Provides the perfect mix of practice and theory Helps you become a DIY Excel modelling specialist Includes updates for Excel 2019/365 and Excel for Table of ContentsPreface xi Chapter 1 What is Financial Modelling? 1 What’s the Difference Between a Spreadsheet and a Financial Model? 3 Types and Purposes of Financial Models 5 Tool Selection 6 What Skills Do You Need to Be a Good Financial Modeller? 17 The “Ideal” Financial Modeller 23 Summary 27 Chapter 2 Building a Model 29 Model Design 29 The Golden Rules for Model Design 31 Design Issues 32 The Workbook Anatomy of a Model 33 Project Planning Your Model 36 Model Layout Flowcharting 37 Steps to Building a Model 39 Information Requests 47 Version-Control Documentation 49 Summary 50 Chapter 3 Best-Practice Principles of Modelling 51 Document Your Assumptions 51 Linking, Not Hardcoding 52 Enter Data Only Once 53 Avoid Bad Habits 53 Use Consistent Formulas 53 Format and Label Clearly 54 Methods and Tools of Assumptions Documentation 55 Linked Dynamic Text Assumptions Documentation 62 What Makes a Good Model? 65 Summary 67 Chapter 4 Financial Modelling Techniques 69 The Problem with Excel 69 Error Avoidance Strategies 71 How Long Should a Formula Be? 76 Linking to External Files 78 Building Error Checks 81 Circular References 85 Summary 90 Chapter 5 Using Excel in Financial Modelling 91 Formulas and Functions in Excel 91 Excel Versions 94 Handy Excel Shortcuts 100 Cell Referencing Best Practices 104 Named Ranges 107 Basic Excel Functions 110 Logical Functions 114 Nesting Logical Functions 117 Summary 125 Chapter 6 Functions for Financial Modelling 127 Aggregation Functions 127 LOOKUP Functions 139 Nesting Index and Match 150 OFFSET Function 153 Regression Analysis 158 Choose Function 164 Working with Dates 165 Financial Project Evaluation Functions 171 Loan Calculations 177 Summary 183 Chapter 7 Tools for Model Display 185 Basic Formatting 185 Custom Formatting 186 Conditional Formatting 191 Sparklines 195 Bulletproofing Your Model 199 Customising the Display Settings 203 Form Controls 210 Summary 226 Chapter 8 Tools for Financial Modelling 227 Hiding Sections of a Model 227 Grouping 233 Array Formulas 234 Goal Seeking 240 Structured Reference Tables 242 PivotTables 245 Macros 254 Summary 263 Chapter 9 Common Uses of Tools in Financial Modelling 265 Escalation Methods for Modelling 265 Understanding Nominal and Effective (Real) Rates 270 Calculating a Cumulative Sum (Running Totals) 274 How to Calculate a Payback Period 275 Weighted Average Cost of Capital (WACC) 278 Building a Tiering Table 282 Modelling Depreciation Methods 286 Break-Even Analysis 295 Summary 300 Chapter 10 Model Review 301 Rebuilding an Inherited Model 301 Improving Model Performance 312 Auditing a Financial Model 317 Summary 323 Appendix: QA Log 323 Chapter 11 Stress Testing, Scenarios, and Sensitivity Analysis in Financial Modelling 325 What are the Differences Between Scenario, Sensitivity, and What-If Analyses? 326 Overview of Scenario Analysis Tools and Methods 328 Advanced Conditional Formatting 337 Comparing Scenario Methods 340 Adding Probability to a Data Table 350 Summary 351 Chapter 12 Presenting Model Output 353 Preparing an Oral Presentation for Model Results 353 Preparing a Graphic or Written Presentation for Model Results 355 Chart Types 358 Working with Charts 367 Handy Charting Hints 374 Dynamic Named Ranges 376 Charting with Two Different Axes and Chart Types 382 Bubble Charts 384 Creating a Dynamic Chart 387 Waterfall Charts 391 Summary 395 About the Author 397 About the Website 399 Index 403
£56.70
Rheinwerk Verlag GmbH Excel
£48.02
Pearson Education (US) Even You Can Learn Statistics and Analytics
Book SynopsisDavid M. Levine and David F. Stephan are part of a writing team known for their series of business statistics textbooks that include Basic Business Statistics, Business Statistics: A First Course, and Statistics for Managers Using Microsoft Excel. 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. Levine is Professor Emeritus of Information Systems at Baruch College. He is nationally recognized innovator in business statistics education and is also the coauthor of Applied Statistics for Engineers and Scientists Using Microsoft Excel and Minitab. Levine is also the authorTable of ContentsIntroduction The Even You Can Learn Statistics and Analytics Owner's Manual. xiii Chapter 1 Fundamentals of Statistics. 1 1.1 The First Three Words of Statistics. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 1.2 The Fourth and Fifth Words. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4 1.3 The Branches of Statistics. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4 1.4 Sources of Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 1.5 Sampling Concepts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7 1.6 Sample Selection Methods. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8 Chapter 2 Presenting Data in Tables and Charts . 15 2.1 Presenting Categorical Variables. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15 2.2 Presenting Numerical Variables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23 2.3 “Bad” Charts. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 29 Chapter 3 Descriptive Statistics. 45 3.1 Measures of Central Tendency. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 45 3.2 Measures of Position. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 49 3.3 Measures of Variation. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 54 3.4 Shape of Distributions. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 59 Chapter 4 Probability. 75 4.1 Events. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 75 4.2 More Definitions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 76 4.3 Some Rules of Probability. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 78 4.4 Assigning Probabilities. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 81 Chapter 5 Probability Distributions. 87 5.1 Probability Distributions for Discrete Variables. . . . . . . . . . . . . . . . . . . . . . . . 87 5.2 The Binomial and Poisson Probability Distributions. . . . . . . . . . . . . . . . . . . . 93 5.3 Continuous Probability Distributions and the Normal Distribution . . . . . . . 100 5.4 The Normal Probability Plot. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 108 Chapter 6 Sampling Distributions and Confidence Intervals. 121 6.1 Foundational Concepts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 122 6.2 Sampling Error and Confidence Intervals. . . . . . . . . . . . . . . . . . . . . . . . . . . 125 6.3 Confidence Interval Estimate for the Mean Using the t Distribution (? Unknown). . . 128 6.4 Confidence Interval Estimation for Categorical Variables . . . . . . . . . . . . . . . 131 6.5 Confidence Interval Estimation When Normality Cannot Be Assumed. . . . . 134 Chapter 7 Fundamentals of Hypothesis Testing. 145 7.1 The Null and Alternative Hypotheses. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 145 7.2 Hypothesis Testing Issues. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 147 7.3 Decision-Making Risks. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 149 7.4 Performing Hypothesis Testing. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 150 7.5 Types of Hypothesis Tests. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 152 Chapter 8 Hypothesis Testing: Z and t Tests. 157 8.1 Test for the Difference Between Two Proportions . . . . . . . . . . . . . . . . . . . . . 157 8.2 Test for the Difference Between the Means of Two Independent Groups . . . . 163 8.3 The Paired t Test. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 168 Chapter 9 Hypothesis Testing: Chi-Square Tests and the One-Way Analysis of Variance (ANOVA). 183 9.1 Chi-Square Test for Two-Way Tables. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 183 9.2 One-Way Analysis of Variance (ANOVA): Testing for the Differences Among the Means of More Than Two Groups. . . . . . . . . . . . . . . 191 Chapter 10 Simple Linear Regression. 211 10.1 Basics of Regression Analysis . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 211 10.2 Developing a Simple Linear Regression Model. . . . . . . . . . . . . . . . . . . . . . 214 10.3 Measures of Variation. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 221 10.4 Inferences About the Slope. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 226 10.5 Common Mistakes When Using Regression Analysis . . . . . . . . . . . . . . . . . 229 Chapter 11 Multiple Regression. 243 11.1 The Multiple Regression Model . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 243 11.2 Coefficient of Multiple Determination . . . . . . . . . . . . . . . . . . . . . . . . . . . . 246 11.3 The Overall F Test . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 246 11.4 Residual Analysis for the Multiple Regression Model . . . . . . . . . . . . . . . . . 247 11.5 Inferences Concerning the Population Regression Coefficients. . . . . . . . . . 248 Chapter 12 Introduction to Analytics. 259 12.1 Basic Concepts. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 259 12.2 Descriptive Analytics. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 265 12.3 Typical Descriptive Analytics Visualizations. . . . . . . . . . . . . . . . . . . . . . . . 269 Chapter 13 Predictive Analytics. 279 13.1 Predictive Analytics Methods. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 279 13.2 More About Predictive Models. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 281 13.3 Tree Induction. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 284 13.4 Clustering . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 287 13.5 Association Analysis. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 290 Appendix A Microsoft Excel Operation and Configuration . 299 Appendix B Review of Arithmetic and Algebra. 301 Appendix C Statistical Tables. 311 Appendix D Spreadsheet Tips . 339 Appendix E Advanced Techniques. 343 Appendix F Documentation for Downloadable Files. 353 9780137654765, TOC, 4/25/2022
£23.39
Pearson Education The Definitive Guide to DAX
a huge range and FREE tracked UK delivery on ALL orders.
£38.39
Pearson Education (US) MOS Study Guide for Microsoft Excel Expert Exam
Book SynopsisPaul McFedries, a Microsoft Office expert and owner of the technical writing company Logophilia Limited, has authored nearly 100 books, including Microsoft Excel 2019 Formulas and Functions. Combined, his books have sold more than 4 million copies worldwide.Table of Contents Chapter 1 – Manage workbook options and settings Objective 1.1: Manage workbooks Objective 1.2: Prepare workbooks for collaboration Objective 1.3: Use and configure language options Chapter 2 – Manage and format data Objective 2.1: Fill cells based on existing data Objective 2.2: Format and validate data Objective 2.3: Apply advanced conditional formatting and filtering Chapter 3 – Create advanced formulas and macros Objective 3.1: Perform logical operations in formulas Objective 3.2: Look up data by using functions Objective 3.3: Apply advanced date and time functions Objective 3.4: Perform data analysis Objective 3.5: Troubleshoot formulas Objective 3.6: Create and modify simple macros Chapter 4 – Manage advanced charts and tables Objective 4.1: Create and modify advanced charts Objective 4.2: Create and modify PivotTables Objective 4.3: Create and modify PivotCharts
£18.04
Pearson Education (US) Bayesian Analysis with Excel and R
Book SynopsisConrad Carlberg 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 Business Analysis with Microsoft Excel, Fifth Edition, Statistical Analysis: Microsoft Excel 2016, Regression Analysis Microsoft Excel, and R for Microsoft Excel Users. Carlberg 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. In 1995 he started a small consulting business (www.conradcarlberg.com)Table of ContentsPrefaceChapter 1 Bayesian Analysis and R: An Overview Bayes Comes Back About Structuring Priors Watching the Jargon Priors, Likelihoods, and Posteriors The Prior The Likelihood Contrasting a Frequentist Analysis with a Bayesian The Frequentist Approach The Bayesian Approach SummaryChapter 2 Generating Posterior Distributions with the Binomial Distribution Understanding the Binomial Distribution Understanding Some Related Functions Working with R's Binomial Functions Using R's dbinom Function Using R's pbinom Function Using R's qbinom Function Using R's rbinom Function Grappling with the Math SummaryChapter 3 Understanding the Beta Distribution Establishing the Beta Distribution in Excel Comparing the Beta Distribution with the Binomial Distribution Decoding Excel's Help Documentation for BETA.DIST Replicating the Analysis in R Understanding dbeta Understanding pbeta Understanding qbeta About Confidence Intervals Applying qbeta to Confidence Intervals Applying BETA.INV to Confidence Intervals SummaryChapter 4 Grid Approximation and the Beta Distribution More on Grid Approximation Setting the Prior Using the Results of the Beta Function Tracking the Shape and Location of the Distribution Inventorying the Necessary Functions Looking Behind the Curtains Moving from the Underlying Formulas to the Functions Comparing Built-in Functions with Underlying Formulas Understanding Conjugate Priors SummaryChapter 5 Grid Approximation with Multiple Parameters Setting the Stage Global Options Local Variables Specifying the Order of Execution Normal Curves, Mu and Sigma Visualizing the Arrays Combining Mu and Sigma Putting the Data Together Calculating the Probabilities Folding in the Prior Inventorying the Results Viewing the Results from Different Perspectives SummaryChapter 6 Regression Using Bayesian Methods Regression a la Bayes Sample Regression Analysis Matrix Algebra Methods Understanding quap Continuing the Code A Full Example Designing the Multiple Regression Arranging a Bayesian Multiple Regression SummaryChapter 7 Handling Nominal Variables Using Dummy Coding Supplying Text Labels in Place of Codes Comparing Group Means SummaryChapter 8 MCMC Sampling Methods Quick Review of Bayesian Sampling Grid Approximation Quadratic Approximation MCMC Gets Up To Speed A Sample MCMC Analysis ulam's Output Validating the Results Getting Trace Plot Charts Summary and Concluding ThoughtsAppendix Installation Instructions for RStan and the rethinking Package on the Windows PlatformGlossary Downloadable Bonus Content Excel Worksheets Book: Statistical Analysis: Microsoft Excel 2016 (PDF) 9780137580989 TOC 10/24/2022
£34.19
O'Reilly Media Python for Excel
Book SynopsisWhile 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.
£39.74
In Easy Steps Limited Excel 2016 in Easy Steps
Book SynopsisExcel 2016 in easy steps will help you get to grips with the latest version of this popular spreadsheet application. Areas covered include: Creating, editing and manipulating worksheets Formulas, Functions and Pivot Tables Handy templates to give you a head start Macros for everyday tasks to save time Charts to get an overview of your data Linking workbooks for automatic updates Using the Excel Online app to share and collaborate on spreadsheets and workbooks Adding images and illustrations to your spreadsheet to impress your colleagues! Whether 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 in easy steps!
£10.44
Springer Nature Switzerland AG Excel 2019 in Applied Statistics for High School Students: A Guide to Solving Practical Problems
Book SynopsisThis textbook is a step-by-step guide for high school, community college, and undergraduate students who are taking a course in applied statistics and wish to learn how to use Excel to solve statistical problems. All of the statistics problems in this book come from the following fields of study: business, education, psychology, marketing, engineering and advertising. Students will learn how to perform key statistical tests in Excel without being overwhelmed by statistical theory. Each chapter briefly explains a topic and then demonstrates how to use Excel commands and formulas to solve specific statistics problems. The book offers guidance in using Excel in two different ways: (1) writing formulas (e.g., confidence interval about the mean, one-group t-test, two-group t-test, correlation) and (2) using Excel’s drop-down formula menus (e.g., simple linear regression, multiple correlations and multiple regression, and one-way ANOVA). Three practice problems are provided at the end of each chapter, along with their solutions in an appendix. An additional practice test allows readers to test their understanding of each chapter by attempting to solve a specific statistics problem using Excel; the solution to each of these problems is also given in an appendix. This book is a tool that can be used either by itself or along with any good statistics book.Table of ContentsPreface.- Acknowledgements.- 1 Sample Size, Mean, Standard Deviation, and Standard Error of the Mean.- 2 Random Number Generator.- 3 Confidence Interval About the Mean Using the TINV Function and Hypothesis Testing.- 4 One-Group t-Test for the Mean.- 5 Two-Group t-Test of the Difference of the Means for Independent Groups.- 6 Correlation and Simple Linear Regression.- 7 Multiple Correlation and Multiple Regression.- 8 One-Way Analysis of Variance (ANOVA).- Appendix A: Answers to End-of-Chapter Practice Problems.- Appendix B: Practice Test.- Appendix C: Answers to Practice Test.- Appendix D: Statistical Formulas.- Appendix E: t-table.- Index.
£999.99
BPB Publications Learning Power Query
Book SynopsisImport data from Excel, folders, and various external sources. Transform, filter, and reshape data effectively. Develop dynamic parameters, lists, and filters driven by queries. Construct and repurpose custom M functions for use across different files.
£32.39
Microsoft Press,U.S. Microsoft Excel 2019 VBA and Macros
Book SynopsisRenowned Excel experts Bill Jelen (MrExcel) and Tracy Syrstad explain how to build more powerful, reliable, and efficient Excel spreadsheets. Use 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. By reading this book, you will: Quickly master Excel macro development Work more efficiently with ranges, cells, and formulas Generate automated reports and quickly adapt them for new requirements Learn to automate pivot tables to summarize, analyze, explore, and present data Use custom dialog boxes to collect data from others using Excel Improve the reliability and resiliency of your macros Integrate data from the internet, Access databases, and other sources Automatically generate charts, visualizations, sparklines, and Word documents Create powerful solutions with classes, collections, and custom functions Solve sophisticated business analysis problems more rapidly About This Book For everyone who wants to get more done with Microsoft Excel in less time For business and financial professionals, entrepreneurs, students, and others who need to efficiently manage and analyze data Table of ContentsIntroduction Unleash the Power of Excel with VBA This Sounds Like BASIC, So Why Doesn't It Look Familiar? Referring to Ranges Looping and Flow Control R1C1-style Formulas Creating and manipulating Names in VBA Event Programming Arrays Creating Classes and Collections Userforms: An Introduction Data Mining with Advanced Filter Using VBA to Create Pivot Tables Excel Power Sample User-Defined Functions Creating Charts Data Visualizations and Conditional Formatting Dashboarding with Sparklines Reading from and Writing to the Web Text File Processing Automating Word Using Access as a Back End to Enhance Multiuser Access to Data Advanced Userform Techniques Windows Application Programming Interface (API) Handling Errors Customizing the Ribbon to Run Macros Creating Add-Ins An Introduction to Creating Office Add-ins What's New in Excel 2019 and What's Changed
£25.49
John Wiley & Sons Inc Modeling Structured Finance Cash Flows with
Book SynopsisA practical guide to building fully operational financial cash flow models for structured finance transactions Structured 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. Modeling Structured Finance Cash Flows with Microsoft Excel 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. Table of ContentsPreface xi Acknowledgments xiii About the Author xv Introduction 1 The Three Basic Elements of a Cash Flow Model 3 Inputs 3 Cash Flow Structure 4 Outputs 5 The Process of Building a Cash Flow Model 5 Plan and Design 5 Obtain All Necessary Information 6 Construct Basic Framework 6 Develop Advanced Structure 6 Validate Assumptions 6 Test Model 7 How This Book Is Designed 7 Chapter 1 Dates and Timing 9 Time Progression 9 Dates and Timing on the Inputs Sheet 10 Day-Count Systems: 30/360 versus Actual/360 versus Actual/ 365 11 Model Builder 1.1: Inputs Sheet—Dates and Timing 12 Dates and Timing on the Cash Flow Sheet 14 Model Builder 1.2: Cash Flow Sheet—Dates and Timing 15 Toolbox 18 Naming Cells and Ranges 18 Data Validation Lists 19 EDATE 21 Chapter 2 Asset Cash Flow Generation 23 Loan Level versus Representative Line Amortization 23 How Asset Generation Is Demonstrated in Model Builder 27 Asset Generation on the Inputs Sheet 27 Fixed Rate Amortization Inputs 28 Floating Rate Amortization Inputs 28 Model Builder 2.1: Inputs Sheet Asset Assumptions and the Vectors Sheet 29 Asset Generation on the Cash Flow Sheet 33 Model Builder 2.2: Notional Asset Amortization on the Cash Flow Sheet 33 TOOLBOX 40 OFFSET 40 MATCH 40 MOD 41 PMT 41 Chapter 3 Prepayments 43 How Prepayments Are Tracked 43 SMM: Single Monthly Mortality 44 CPR: Conditional Prepayment Rate 44 PSA: Public Securities Association 44 ABS: Absolute Prepayment Speed 45 Historical Prepayment Data Formats 46 Building Prepayment Curves 46 Prepayment Curves in Project Model Builder 47 The Effect of Prepayments on Structured Transactions 48 Model Builder 3.1: Historical Prepayment Analysis and Creating a Projected Prepayment Curve 48 Model Builder 3.2: Integrating Projected Prepayments in Asset Amortization 53 Toolbox 56 Weighted Averages Using SUMPRODUCT and SUM 56 Chapter 4 Delinquency, Default, and Loss Analysis 59 Delinquencies versus Defaults versus Loss 59 The Importance of Analyzing Delinquency 60 Model Builder 4.1: Building Historical Delinquency Curves 62 Deriving Historical Loss Curves 64 Model Builder 4.2: Building Historical and Projected Loss Curves 67 Analyzing Historical Loss Curves 69 Model Builder 4.2 Continued 69 Projecting Loss Curves 70 Model Builder 4.2 Continued 71 Integrating Loss Projections 73 The Effects of Seasoning and Default Timing 75 Model Builder 4.3: Integrating Defaults in Asset Amortization 76 Chapter 5 Recoveries 83 Model Builder 5.1: Historical Recovery Analysis 85 Projecting Recoveries in a Cash Flow Model 86 Model Builder 5.2: Integrating Recoveries into Project Model Builder 87 Final Points Regarding Recoveries 88 Chapter 6 Liabilities and the Cash Flow Waterfall 89 Priority of Payments and the Cash Flow Waterfall 89 The Movement of Cash for an Individual Liability 90 Types of Liabilities 91 Fees 91 Model Builder 6.1: Calculating Fees in the Waterfall 91 Interest 94 Model Builder 6.2: Calculating Interest in the Waterfall 95 Principal 100 Model Builder 6.3: Calculating Principal in the Waterfall 100 Understanding Basic Asset and Liability Interactions 105 Chapter 7 Advanced Liability Structures: Triggers, Interest Rate Swaps, and Reserve Accounts 107 Triggers and Their Affect on the Liability Structure 107 Model Builder 7.1: Incorporating Triggers 108 Swaps 113 Model Builder 7.2: Incorporating a Basic Interest Rate Swap 114 Final Notes on Swaps 117 Reserve Accounts 117 Model Builder 7.3: Incorporating a Cash-Funded Reserve Account 118 Conclusion of the Cash Flow Waterfall 122 Toolbox 123 AND and OR 123 Chapter 8 Analytics and Output Reporting 125 Internal Testing 125 Cash In versus Cash Out 125 Model Builder 8.1: Cash In versus Cash Out Test 126 Balances at Maturity 128 Model Builder 8.2: Balances at Maturity Tests 128 Asset Principal Check 129 Model Builder 8.3: Asset Principal Check Test 129 Performance Analytics 130 Monthly Yield 130 Model Builder 8.4: Calculating Monthly Yield 130 Calculating the Monthly Yield 132 Bond-Equivalent Yield 133 Model Builder 8.5: Calculating Bond-Equivalent Yield 133 Modified Duration 133 Model Builder 8.6: Calculating Modified Duration 134 Output Reporting 135 Model Builder 8.7: Creating the Output Report 136 The Importance of Testing and Output 140 Toolbox 140 Conditional Formatting 140 Goal Seek 141 Array Formulas 142 Chapter 9 Understanding the Model 145 The Complete Model in Review 145 Understanding the Effects of Increased Loss 147 Varying Principal Allocation Methodologies 150 Varying Prepayment Rates 151 Varying Loss Timing 152 Varying Recovery Rate and Lag 152 The Value of a Swap 153 Additional Testing 153 Chapter 10 Automation Using Visual Basic Applications (VBA) 155 Conventions of This Chapter 155 The Visual Basic Editor 156 The Menu Bar 156 The Project Explorer and the Properties Window 157 VBA Code 157 Simple Automation for Printing and Goal Seek 158 Model Builder 10.1: Automating Print Procedures 158 Model Builder 10.2: Automating Goal Seek to Optimize Advance Rates 161 Understanding Looping to Automate the Analytics Sheet 164 Model Builder 10.3: Automating Goal Seek to Perform Transaction Analytics 164 Automated Scenario Generation 167 Model Builder 10.4: Creating a Transaction Scenario Generator 167 Working with Macros in Excel 173 Chapter 11 Conclusion 175 The Investment Banker’s Perspective 175 The Investor’s Perspective 176 The Issuer’s Perspective 176 The Financial Guarantor’s Perspective 177 The Big Picture Perspective 177 Appendix: Using This Book with Excel 2007 179 About the CD-ROM 189 Index 193
£54.75
John Wiley & Sons Inc Advanced Excel Reporting for Management
Book SynopsisThe advanced tools accountants need to build automated, reliable, and scalable reports using Excel Learn 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 Advanced Excel Reporting for Management Accountants. Explore the structures that simplify the report creation process and make the reports more maintainable Learn techniques to cleanse data so that it is ready for use in Pivot Tables and formula-based reports Find out the tips and tricks that can make the creation process quicker and easier Discover all you need to know about Excel''s summing functions and how versatile they can be Table of ContentsPreface xiii Acknowledgments xv Introduction 1 Chapter 1 Management Accounting and Excel 3 Assumptions 3 The Goal of Reporting 5 Why Use Excel? 5 The Goal of This Book 6 Monthly Management Reports 7 Macro Policy 7 Chapter 2 Building Reporting Models 9 Needs Analysis 10 Scope Definition 10 Design 11 Construction 11 Testing 12 Operation 12 Maintenance 12 Time, Effort, and Cost 12 Practical Considerations 13 Chapter 3 Building Tips 15 Display Tips 16 Keyboard Shortcuts 26 Mouse Shortcuts 33 Keyboard and Mouse Shortcuts 42 General Tips 48 Chapter 4 Design and Structure 57 Structure = Flexibility 57 Modular Sheet Design 58 Standardised Report Layout 60 Table-Based Systems 62 Spreadsheet Best Practices 63 Chapter 5 Setting the Foundation 67 Terminology 68 Data Rules 68 Data Structures 69 Format as Table 70 Data Cleansing Techniques 74 External Data 80 Chapter 6 Pivot Tables (Do-It-Yourself Reporting) 85 The Pros and Cons of a Pivot Table 85 Creating a Pivot Table 88 PowerPivot 108 Chapter 7 Tools of the Trade: Summing Functions 111 Range Names 112 Using Cells and Ranges in Formulas 112 The Humble SUM Function 116 Advanced SUM and 3D Formulas 117 Subtotaling 120 The SUBTOTAL Function 121 The AGGREGATE Function 125 Function Wizard 127 Conditional Summing 127 The SUMIF Function 131 SUMIF Uses 135 Helper Cells 135 The SUMIFS Function 136 The SUMPRODUCT Function 138 Chapter 8 Accessories: Other Reporting Functions and Features 153 Helper Cells 153 Logic Functions 155 The IF Function 157 The AND and OR Functions 161 Lookup Functions 164 The VLOOKUP Function 164 The HLOOKUP Function 168 An Alternative to VLOOKUP 170 The INDEX and MATCH Functions 170 The MATCH Function 170 The INDEX Function 172 The INDEX-MATCH Combination 174 Error Handling Functions 175 The IFERROR Function 175 Handling Specific Errors 177 Text-Based Functions 180 The TEXT Function 181 LEFT and RIGHT Functions 183 The MID Function 184 Flexible Text Manipulations 185 The SEARCH Function 185 The LEN Function 187 Flexible Splitting 187 The SUBSTITUTE Function 188 Converting Text to Numbers 190 Date Functions 190 The DATE Function 191 Other Useful Functions 192 Array Formulas 201 Chapter 9 Range Names 209 Advantages 210 Disadvantages 210 Creating a Range Name 211 Using Range Names 213 Name Manager 216 Naming a Range 218 Creating Names Automatically 222 Name Intersections 227 Dynamic Range Names 228 Using Structure in Range Names 233 INDIRECT and Range Names 236 Listing Range Names 237 Chapter 10 Maintenance Issues 239 Maintenance Instructions 239 The Advantages of Using Tables 240 Common Issues 241 Rolling the Year 241 Working with Days 242 Simplifying the Interface by Using Controls 244 Chapter 11 Choosing the Right Format 255 Colour Blindness 255 Format Painter 256 Less Is More 256 Fonts 257 Clear and Start Again 257 The Format Cells Dialog Box 257 Styles 270 Conditional Formatting 272 Printing Issues 293 Chapter 12 Picture Perfect: Charting Techniques 299 Chart versus Graph 300 Chart Basics 300 Charts for Reports 302 Automating Charts 302 Mixing Chart Types 307 Dual-Axis Charts 308 Handling Missing Data 311 Labeling Highs and Lows 313 Trendlines and Moving Averages 315 Plotting the Variance 316 Dashboard Techniques 317 Text in a Chart 331 The Data Series Formula 332 Before and After Charts 333 Chapter 13 Quality Control: Report Validation 337 Identifying Errors 337 Validations 338 Error Tracking 340 Identifying New Codes 346 Conditional Formatting 347 Suggested Validation Structure 347 Reasonableness Checks 349 Chapter 14 Case Study One: Month and Year-to-Date Reporting 351 Scenario 351 Data Requirements 352 Processes 352 Structure 354 Design 354 Report Layout 355 The Creation Process 355 The Reports 363 Chapter 15 Case Study Two: 12-Month Reporting 379 Scenario 379 Data Requirements 380 Processes 381 Structure 381 Design 382 The Creation Process 382 The Reports 387 Chapter 16 Final Thoughts 407 Feedback 408 Last Words 408 About the Author 409 About the Companion Website 411 Index 413
£37.50
John Wiley & Sons Inc Reverse Engineering Deals on Wall Street with
Book SynopsisA serious source of information for those looking to reverse engineer business deals It'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. Reverse Engineering Deals on Wall Street: A Step-By-Step Guide 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. Appropriate 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 transferTable of ContentsPreface. Acknowledgments. About the Author. CHAPTER 1: Introduction. The Transaction. The Documents. The Process. How This Book Works. CHAPTER 2: Determining Dates and Setting Up Timing. Differences in Timing Approaches. A First Look at the Prospectus. Important Dates. Transforming Dates and Timing from Words to a Model. Model Builder 2.1: Reversing Dates and Timing. Conclusion of Dates and Timing. CHAPTER 3: Creating Asset Cash Flow from Prospectus Data. It’s All in the Prospectus Supplement. The Basics of Amortization. Performance and the Prospectus Supplement. Delinquency. Loss. Prepayment. Recovery. Creating Cash Flow. A Complex Implementation. Model Builder 3.1: Entering in the Raw Asset Information. Model Builder 3.2: Entering in the Default and Prepayment Assumptions. Model Builder 3.3: Interest Rates and Additional Asset Amortization Inputs. Model Builder 3.4: Introducing VBA and Moving Data In and Out of the Model. Model Builder 3.5: Loading Loan Performance Assumptions into VBA. Model Builder 3.6: Global Functions. Model Builder 3.7: Loan-Level Asset Amortization. CHAPTER 4: Setting Up Liability Assumptions, Paying Fees, and Distributing Interest. Identifying the Offered Securities. Model Builder 4.1: Transferring the Liability Information to a Consolidated Sheet. The Liability Waterfall: A System of Priority. Model Builder 4.2: Starting the Waterfall with Fees. Interest: No Financing Is Free. Model Builder 4.3: Continuing the Waterfall with Interest Paid to the Certificate Holders. More on Waterfalls and Wall Street’s Risk Parsing. Model Builder 4.4: Mezzanine Interest. Continuing the Waterfall: It Only Gets More Complicated. CHAPTER 5: Principal Repayment and the Shifting Nature of a Wall Street Deal. Model Builder 5.1: The Deal State and Senior Principal. Mezzanine Principal Returns. Model Builder 5.2: The Mezzanine Certificates’ Priority of Payments. Number Games or Risk Parsing? CHAPTER 6: Credit Enhancement Mechanisms to Mitigate Loss. Model Builder 6.1: Excess Spread, Overcollateralization, and Credit Enhancement. CHAPTER 7: Auditing the Model. Model Builder 7.1. CHAPTER 8: Conclusion of Example Transaction and Final Thoughts on Reverse Engineering. Mortgage Insurance and Servicer Advances. Reverse Engineering in the Current and Future Market. Appendix. Automatic Range Naming. About the CD-ROM. Index.
£56.25
John Wiley & Sons Inc Teach Yourself VISUALLY Excel 365
Book SynopsisExcel-erate your Excel 365 knowledge with the celebrated Teach Yourself VISUALLY series In Teach Yourself VISUALLY: Excel 365, veteran tech educator and writer Paul McFedries delivers a practical, step-by-step guide to using the latest version of the world's most popular spreadsheet app. The book is filled with easy two-page lessons containing large-size screenshots and walkthroughs demonstrating common and useful tasks in Excel 365. You'll learn how to present, analyze, visualize, and organize your data, as well as how to: Create and fill spreadsheets, charts, tables, and PivotTablesFilter and sort your data, use and create formulas, and organize your informationVisualize your data with a variety of effective charts, graphs, and moreA can't-miss handbook perfect for anyone looking for straightforward and easy-to-follow tutorials on basic and advanced Excel techniques, Teach Yourself VISUALLY: Excel 365 offers users of previous Excel versionsand complete Excel newbiesa clear roadmap toTable of ContentsChapter 1 Getting Started with Excel Getting to Know Excel 4 Start Excel on the Desktop 6 Navigate to Excel for the Web 7 Tour the Excel Window 8 Work with the Excel Ribbon 9 Chapter 2 Entering Data Learning the Layout of a Worksheet 12 Understanding the Types of Data You Can Use 13 Enter Text into a Cell 14 Enter a Number into a Cell 16 Enter a Date or Time into a Cell 18 Edit Cell Data 20 Delete Data from a Cell 22 Chapter 3 Working with Ranges Select a Range 26 Fill a Range with the Same Data 28 Fill a Range with a Series of Values 30 Flash Fill a Range 32 Move or Copy a Range 34 Insert a Row or Column 36 Insert a Cell or Range 38 Delete Data from a Range 40 Delete a Range 42 Hide a Row or Column 44 Freeze Rows or Columns 46 Merge Two or More Cells 48 Chapter 4 Working with Range Names Understanding the Benefits of Using Range Names 52 Define a Range Name 54 Using Worksheet Text to Define a Range Name 56 Navigate a Workbook Using Range Names 58 Change a Range Name 60 Delete a Range Name 62 Chapter 5 Formatting Excel Ranges Change the Font and Font Size 66 Apply Font Effects 68 Change the Font Color 70 Align Text Within a Cell 72 Center Text Across Multiple Columns 74 Rotate Text Within a Cell 76 Add a Background Color to a Range 78 Apply a Number Format 80 Change the Number of Decimal Places Displayed 82 Apply a Conditional Format to a Range 84 Apply a Style to a Range 86 Change the Column Width 88 Change the Row Height 90 Wrap Text Within a Cell 92 Add Borders to a Range 94 Copy Formatting from One Cell to Another 96 Chapter 6 Building Formulas Understanding Excel Formulas 100 Build a Formula 102 Understanding Excel Functions 104 Add a Function to a Formula 106 Add a Range of Numbers 108 Build an AutoSum Formula 110 Add a Range Name to a Formula 112 Reference Another Worksheet Range in a Formula 114 Move or Copy a Formula 116 Switch to Absolute Cell References 118 Troubleshoot Formula Errors 120 Chapter 7 Manipulating Worksheets Navigate a Worksheet 124 Rename a Worksheet 125 Create a New Worksheet 126 Move a Worksheet 128 Copy a Worksheet 130 Delete a Worksheet 132 Zoom In on or Out of a Worksheet 134 Split a Worksheet into Two Panes 136 Hide and Unhide a Worksheet 138 Chapter 8 Dealing with Workbooks Create a New Blank Workbook 142 Create a New Workbook from a Template 144 Save a Workbook 146 Open a Workbook 147 Find Text in a Workbook 148 Replace Text in a Workbook 150 Chapter 9 Formatting Workbooks Modify the Workbook Colors 154 Set the Workbook Fonts 156 Choose Workbook Effects 158 Apply a Workbook Theme 160 Add a Workbook Header 162 Add a Workbook Footer 164 Chapter 10 Importing Data into Excel Understanding External Data 168 Import Data from an Access Table 170 Import Data from a Word Table 172 Import Data from a Text File 174 Import Data from a Web Page 176 Import Data from an XML File 178 Refresh Imported Data 180 Separate Cell Text into Columns 182 Chapter 11 Working with Tables Understanding Tables 186 Get to Know Table Features 187 Convert a Range to a Table 188 Select Table Data 190 Insert a Table Row 192 Insert a Table Column 193 Delete a Table Row 194 Delete a Table Column 195 Add a Column Subtotal 196 Convert a Table to a Range 198 Apply a Table Style 199 Chapter 12 Analyzing with PivotTables Understanding PivotTables 202 Explore PivotTable Features 203 Build a PivotTable from an Excel Range or Table 204 Refresh PivotTable Data 206 Add Multiple Fields to the Row or Column Area 208 Add Multiple Fields to the Data Area 210 Move a Field to a Different Area 212 Group PivotTable Values 214 Apply a PivotTable Filter 216 Chapter 13 Analyzing Data Sort a Range or Table 220 Filter a Range or Table 222 Set Data Validation Rules 224 Create a Data Table 226 Summarize Data with Subtotals 228 Group Related Data 230 Analyze Data with Goal Seek 232 Highlight Cells That Meet Some Criteria 234 Highlight the Top or Bottom Values in a Range 236 Analyze Cell Values with Data Bars 238 Analyze Cell Values with Color Scales 240 Analyze Cell Values with Icon Sets 242 Chapter 14 Visualizing Data with Charts Examine Chart Elements 246 Understanding Chart Types 247 Create a Chart 248 Create a Recommended Chart 250 Add Chart Titles 252 Add Data Labels 253 Position the Chart Legend 254 Display Chart Gridlines 255 Display a Data Table 256 Change the Chart Layout and Style 257 Select a Different Chart Type 258 Change the Chart Source Data 260 Move or Resize a Chart 262 Chapter 15 Adding Worksheet Graphics Draw a Shape 266 Insert an Online Image 268 Insert a Photo from Your PC 270 Insert a SmartArt Graphic 272 Move or Resize a Graphic 274 Format a Picture 276 Chapter 16 Collaborating with Others Add a Comment to a Cell 280 Protect a Worksheet’s Data 282 Protect a Workbook’s Structure 284 Save a Workbook to Your OneDrive 286 Send a Workbook as an Email Attachment 288 Save Excel Data as a Web Page 290 Make a Workbook Compatible with Earlier Versions of Excel 292 Mark Up a Worksheet with Digital Ink 294 Collaborate on a Workbook Online 296 Index 298
£19.54
Holy Macro! Books MrExcel 23: The Greatest Excel Tips of All Time
Book SynopsisExcel tips to skyrocket white-collar productivity. 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.Table of Contents1 - 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 & 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 & 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 & 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 & 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
£26.31
Microsoft Press,U.S. Microsoft Excel 2019 Data Analysis and Business
Book SynopsisMaster 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.Table of Contents Chapter 1 Basic spreadsheet modeling Chapter 2 Range names Chapter 3 Lookup functions Chapter 4 The INDEX function Chapter 5 The MATCH function Chapter 6 Text functions Chapter 7 Dates and date functions Chapter 8 Evaluating investment by using net present value criteria Chapter 9 Internal rate of return Chapter 10 More Excel financial functions Chapter 11 Circular references Chapter 12 IF statements Chapter 13 Time and time functions Chapter 14 The Paste Special command Chapter 15 Three-dimensional formulas and hyperlinks Chapter 16 The auditing tool Chapter 17 Sensitivity analysis with data tables Chapter 18 The Goal Seek command Chapter 19 Using the Scenario Manager for sensitivity analysis Chapter 20 The COUNTIF, COUNTIFS, COUNT, COUNTA, and COUNTBLANK functions Chapter 21 The SUMIF, AVERAGEIF, SUMIFS, and AVERAGEIFS functions Chapter 22 The OFFSET function Chapter 23 The INDIRECT function Chapter 24 Conditional formatting Chapter 25 Sorting in Excel Chapter 26 Tables Chapter 27 Spin buttons, scroll bars, option buttons, check boxes, combo boxes, and group list boxes Chapter 28 The analytics revolution Chapter 29 An introduction to optimization with Excel Solver Chapter 30 Using Solver to determine the optimal product mix Chapter 31 Using Solver to schedule your workforce Chapter 32 Using Solver to solve transportation or distribution problems Chapter 33 Using Solver for capital budgeting Chapter 34 Using Solver for financial planning Chapter 35 Using Solver to rate sports teams Chapter 36 Warehouse location and the GRG Multistart and Evolutionary Solver engines Chapter 37 Penalties and the Evolutionary Solver Chapter 38 The traveling salesperson problem Chapter 39 Importing data from a text file or document Chapter 40 Validating data Chapter 41 Summarizing data by using histograms and Pareto charts Chapter 42 Summarizing data by using descriptive statistics Chapter 43 Using PivotTables and slicers to describe data Chapter 44 The Data Model Chapter 45 Power Pivot Chapter 46 Power View and 3D Maps Chapter 47 Sparklines Chapter 48 Summarizing data with database statistical functions Chapter 49 Filtering data and removing duplicates Chapter 50 Consolidating data Chapter 51 Creating subtotals Chapter 52 Charting tricks Chapter 53 Estimating straight-line relationships Chapter 54 Modeling exponential growth Chapter 55 The power curve Chapter 56 Using correlations to summarize relationships Chapter 57 Introduction to multiple regression Chapter 58 Incorporating qualitative factors into multiple regression Chapter 59 Modeling nonlinearities and interactions Chapter 60 Analysis of variance: One-way ANOVA Chapter 61 Randomized blocks and two-way ANOVA Chapter 62 Using moving averages to understand time series Chapter 63 Winters method Chapter 64 Ratio-to-moving-average forecast method Chapter 65 Forecasting in the presence of special events Chapter 66 An introduction to probability Chapter 67 An introduction to random variables Chap
£32.29
I30 Media Corporation Excel Basics In 30 Minutes: The beginner's guide to Microsoft Excel, Excel Online, and Google Sheets
£12.20
Microsoft Press,U.S. Microsoft Excel 2013 Building Data Models with
Book SynopsisAlberto Ferrari has 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.Table of Contents Introduction Chapter 1: Introduction to PowerPivot Chapter 2: Using the unique features of PowerPivot Chapter 3: Introducing DAX Chapter 4: Understanding data models Chapter 5: Publishing to SharePoint Chapter 6: Loading data Chapter 7: Understanding evaluation contexts Chapter 8: Understanding CALCULATE Chapter 9: Using hierarchies Chapter 10: Using Power View Chapter 11: Shaping the reports Chapter 12: Performing date calculations in DAX Chapter 13: Using advanced DAX Chapter 14: Using DAX as a query language Chapter 15: Automating operations using VBA Chapter 16: Comparing Excel and SQL Server Analysis Services About the Authors
£28.02
APress Up Up and Array
Book SynopsisUnderstand 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 dynTable of ContentsChapter 1: What’s An Array, Anyway? Chapter 2: Array Formula Basics Chapter 3: Dynamic Arrays -- Time for Some Heavy Lifting Chapter 4: The SEQUENCE Function: Made to Order Chapter 5: UNIQUE -- A Singular Function Chapter 6: SORT and SORTBY: The ABCs (and the CBAs) Chapter 7: The FILTER Function: Cutting the Data Down to Size Chapter 8: RANDARRAY: Unpredictably Useful Chapter 9: The Implicit Intersection Operator: The Function You'll Probably Never UseChapter 10: TEXTSPLIT, TEXTBEFORE, and TEXTAFTER: Putting Words in Their PlacesChapter 11: TOCOL and TOROW -- Straightening Out the DataChapter 12: WRAPCOLS and WRAPROWS: Giving Some Direction to the DataChapter 13: VSTACK and HSTACK: What They're AboutChapter 14: CHOOSECOLS and CHOOSEROWS: Less is MoreChapter 15: TAKE and DROP: Selecting and Rejecting the DataChapter 16: EXPAND: Bulking Up the Data
£37.99
Holy Macro! Books Ctrl+Shift+Enter Mastering Excel Array Formulas:
Book SynopsisDesigned with Excel gurus in mind, this handbook outlines how to create formulas that can be used to solve everyday problems with a series of data values that standard Excel formulas cannot or would be too arduous to attempt. Beginning with an introduction to array formulas, this manual examines topics such as how they differ from ordinary formulas, the benefits and drawbacks of their use, functions that can and cannot handle array calculations, and array constants and functions. Among the practical applications surveyed include how to extract data from tables and unique lists, how to get results that match any criteria, and how to utilize various methods for unique counts. This book contains 529 screen shots.
£24.26
Holy Macro! Books Master Your Data with Excel and Power BI:
Book SynopsisPower Query is the amazing new data cleansing tool in both Excel and Power BI Desktop. Do you find yourself performing the same data cleansing steps day after day? Power Query will make it faster to clean your data the first time. While Power Query is powerful, the interface is subtle—there are tools hiding in plain sight that are easy to miss. Go beyond the obvious and take Power Query to new levels with this book.
£26.31
Technics Publications LLC Turning Spreadsheets into Corporate Data
Book SynopsisFor 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.
£22.09
CiA Training Ltd OCR Level 1 ITQ - Unit 69 - Spreadsheet Software
Book Synopsis
£15.76
Mercury Learning & Information Microsoft Excel Functions and Formulas
Book SynopsisMicrosoft Excel Functions & 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.
£36.40
Sterling Publishers Pvt.Ltd Drag Drop Ms Excel 2010
Book Synopsis
£6.81
