Excel Books

  • AQJQW
    • £36.00
    • RRP £45.00
    • Save £9.00Save 20.00%
    The complete guide to Excel 2016, from Mr. Spreadsheet himself Whether you are just starting out or an Excel novice, the Excel 2016 Bible is your comprehensive, go-to guide for all your Excel 2016 needs. Whether you use Excel at work or at home, you will be guided through the powerful new features and capabilities by expert author and Excel Guru John Walkenbach to take full advantage of what the updated version offers. Learn to incorporate templates, implement formulas, create pivot tables, analyze data, and much more. Navigate this powerful tool for business, home management, technical work, and much more with the only resource you need, Excel 2016 Bible. * Create functional spreadsheets that work * Master formulas, formatting, pivot tables, and more * Get acquainted with Excel 2016's new features and tools * Customize downloadable templates and worksheets Whether you need a walkthrough tutorial or an easy-to-navigate desk reference, the Excel 2016 Bible has you covered with complete coverage and clear expert guidance.
  • AGEAA
    • £31.99
    • RRP £39.99
    • Save £8.00Save 20.00%
    Excel at Excel with the help of this bestselling spreadsheet guide John Walkenbach's name is synonymous with excellence in computer books that decipher the complexities of Microsoft Excel. Known as "Mr. Spreadsheet," Walkenbach shows you how to maximize the power of Excel 2013 while bringing you up to speed on the latest features. This perennial bestseller is fully updated to cover all the new features of Excel 2013, including how to navigate the user interface, take advantage of various file formats, master formulas, analyze data with PivotTables, and more. Whether you're an Excel beginner who is looking to get more savvy or an advanced user looking to become a power user, this latest edition provides you with comprehensive coverage as well as helpful tips, tricks, and techniques that you won't find anywhere else. Shares the invaluable insight of Excel guru and bestselling author "Mr. Spreadsheet" John Walkenbach as he guides you through every aspect of Excel 2013 Provides essential coverage of all the newest features of Excel 2013 Presents material in a clear, concise, logical format that is ideal for all levels of Excel experience Features a website that includes downloadable templates and worksheets from the book Chart your path to fantastic formulas and stellar spreadsheets with Excel 2013 Bible !
  • BAVMI
    • £31.99
    • RRP £39.99
    • Save £8.00Save 20.00%
    Helping 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. This expert book offers the perfect solution. Written by data analysis expert Wayne L. Winston, this practical resource shows you how to tap a simple and cost-effective tool, Microsoft Excel, to solve specific business problems using powerful analytic techniques and achieve optimum results. Practical exercises in each chapter help you apply and reinforce techniques as you learn. * Shows you how to perform sophisticated business analyses using the cost-effective and widely available Microsoft Excel instead of expensive, proprietary analytical tools * Reveals how to target and retain profitable customers and avoid high-risk customers * Helps you forecast sales and improve response rates for marketing campaigns * Explores how to optimize price points for products and services, optimize store layouts, and improve online advertising * Covers social media, viral marketing, and how to exploit both effectively Improve your marketing results with Microsoft Excel and the invaluable techniques and ideas in Marketing Analytics: Data-Driven Techniques with Microsoft Excel.
  • BBWYY
    • £31.99
    • RRP £39.99
    • Save £8.00Save 20.00%
    Learn to maintain and update scorecards and dashboards with Excel Balanced Scorecards and operational dashboards measure organizational performance and Microsoft Excel is the tool used worldwide to create these scorecards and dashboards. This book covers time-proven step-by-step processes on how to guide executive teams and managers in creating scorecards and dashboards. It then shows Excel developers how to create those scorecards and dashboards. This is the only book that converts theory into practice. The author addresses the people and processes you need to identify strategy and operational metrics and then implement them in dashboards in three versions of Excel. You'll learn how balanced scorecards help organizations translate strategy into action and the ways that performance dashboards enable managers monitor operations. * Covers Excel 2010 back to Excel 2003 * Shows how to develop consensus on strategy and operational plans with the executive teams * Details steps in creating tactical action plans * Gives step-by-step guidance in creating the most powerful management dashboards * Puts over ten years of experience in one book Balanced Scorecards & Operational Dashboards with Microsoft Excel, Second Edition is the ultimate resource for enhancing your strategic and operational performance.
  • BKXJN
    • £31.99
    • RRP £39.99
    • Save £8.00Save 20.00%
    Investors recognize that technology is a powerful tool for obtaining and interpreting financial data that could give them the one thing everyone on Wall Street wants: an edge. Yet, many don't realize that you don't need to be a programmer to access behind-the-scenes financial information from Bloomberg, IHS Markit, or other systems found at most banks and investment firms. This practical guide teaches analysts a useful subset of Excel skills that will enable them to access and interpret financial information-without any prior programming experience. This book will show analysts, step-by-step, how to quickly produce professional reports that combine their views with Bloomberg or Markit data including historical financials, comparative analysis, and relative value. For portfolio managers, this book demonstrates how to create professional summary reports that contain a high-level view of a portfolio's performance, growth, risk-adjusted return, and composition. If you are a programmer, this book also contains a parallel path that covers the same topics using C#. Topics include: Access additional data that isn't visible on Bloomberg screens Create tables containing corporate data that makes it possible to compare multiple companies, bonds, or loans side-by- side Build one-page analytic ("Tear Sheet") reports for individual companies that incorporates important financials, custom notes, relative value comparison of the company to its peers, and price trends with research analyst targets Build two-page portfolio summary report that contains a high-level view of the portfolio's performance, growth, risk-adjusted return, and composition Explore daily prices and facility information for most of the tradable corporate bond and loan market Determine the relationship between two securities (or index) using correlation and regression Compare each security's performance to a cohort made of up of securities with similar risk and return characteristics Measure portfolio risk-adjusted return by calculating variance, standard deviation, and Sharpe ratio Use Markit data to identify meaningful trends in prices, new issue spreads, and refinancings
  • ABIJR
    • £26.19
    • RRP £32.99
    • Save £6.80Save 20.0000000000000005684341886080801486968994140625%
    Demonstrate your expertise with Microsoft Office 2010! This all-in-one guide is designed to help you practice and prepare for the four core Microsoft Office Specialist (MOS) exams. With the MOS 2010 Study Guide, you get full, objective-by-objective coverage for: * Exam 77-881: Microsoft Word 2010 * Exam 77-882: Microsoft Excel 2010 * Exam 77-883: Microsoft PowerPoint 2010 * Exam 77-884: Microsoft Outlook 2010 Use the book's easy-to-follow procedures and illustrations to review the essential skills measured by the MOS exams. And you can apply what you've learned hands-on-using the downloadable files for all the book's practice tasks.
  • ARGFF
    • £27.19
    • RRP £33.99
    • Save £6.80Save 20.00%
    Maximize your Excel experience with VBA Excel 2016 Power Programming with VBA is fully updated to cover all the latest tools and tricks of Excel 2016. Encompassing an analysis of Excel application development and a complete introduction to Visual Basic for Applications (VBA), this comprehensive book presents all of the techniques you need to develop both large and small Excel applications. Over 800 pages of tips, tricks, and best practices shed light on key topics, such as the Excel interface, file formats, enhanced interactivity with other Office applications, and improved collaboration features. In addition to the procedures, tips, and ideas that will expand your capabilities, this resource provides you with access to over 100 online example Excel workbooks and the Power Utility Pak, found on the Mr. Spreadsheet website. Understanding how to leverage VBA to improve your Excel programming skills can enhance the quality of deliverables that you produce and can help you take your career to the next level. * Explore fully updated content that offers comprehensive coverage through over 900 pages of tips, tricks, and techniques * Leverage templates and worksheets that put your new knowledge in action, and reinforce the skills introduced in the text * Access online resources, including the Power Utility Pak, that supplement the content * Improve your capabilities regarding Excel programming with VBA, unlocking more of your potential in the office Excel 2016 Power Programming with VBA is a fundamental resource for intermediate to advanced users who want to polish their skills regarding spreadsheet applications using VBA.
  • ARATZ
    • £27.19
    • RRP £33.99
    • Save £6.80Save 20.00%
    Leverage the full power of Excel formulas Excel 2016 Formulas is fully updated to cover all of the tips, tricks, and techniques you need to maximize the power of Excel 2016 through the use of formulas. This comprehensive book explains how to create financial formulas, release the power of array formulas, develop custom worksheet functions with VBA, debug formulas, and much more. Whether you're a beginner, a power user, or somewhere in between this is your essential go-to for the latest on Excel formulas. When conducting simple math or building highly complicated spreadsheets that require formulas up to the task, leveraging the right formula can heighten the accuracy and efficiency of your work, and can improve the speed with which you compile and analyze data. Understanding which formulas to use and knowing how to create a formula when you need to are essential. * Access tips, tricks, and techniques that have been fully updated to reflect the latest capabilities of Microsoft Excel * Create and use formulas that have the power to transform your Excel experience * Leverage supplemental material online, including sample files, templates, and worksheets from the book
  • AOPMN
    • £25.29
    • RRP £31.99
    • Save £6.70Save 19.999999999999998721023075631819665431976318359375%
    Accurate, practical Excel predictive analysis: powerful smoothing techniques for serious data crunchers! In More Predictive Analytics, Microsoft Excel(R) MVP Conrad Carlberg shows how to use intuitive smoothing techniques to make remarkably accurate predictions. You won't have to write a line of code--all you need is Excel and this all-new, crystal-clear tutorial. Carlberg goes beyond his highly-praised Predictive Analytics, introducing proven methods for creating more specific, actionable forecasts. You'll learn how to predict what customers will spend on a given product next year...project how many patients your hospital will admit next quarter...tease out the effects of seasonality (or patterns that recur over a day, year, or any other period)...distinguish real trends from mere "noise." Drawing on more than 20 years of experience, Carlberg helps you master powerful techniques such as autocorrelation, differencing, Holt-Winters, backcasting, polynomial regression, exponential smoothing, and multiplicative modeling. Step by step, you'll learn how to make the most of built-in Excel tools to gain far deeper insights from your data. To help you get better results faster, Carlberg provides downloadable Excel workbooks you can easily adapt for your own projects. If you're ready to make better forecasts for better decision-making, you're ready for More Predictive Analytics. *Discover when and how to use smoothing instead of regression*Test your data for trends and seasonality*Compare sets of observations with the autocorrelation function*Analyze trended time series with Excel's Solver and Analysis ToolPak*Use Holt's linear exponential smoothing to forecast the next level and trend, and extend forecasts further into the future*Initialize your forecasts with a solid baseline*Improve your initial forecasts with backcasting and optimization*Fully reflect simple or complex seasonal patterns in your forecasts*Account for sudden, unexpected changes in trends, from fads to new viral infections*Use range names to control complex forecasting models more easily*Compare additive and multiplicative models, and use the right model for each task Conrad Carlberg is a nationally recognized expert on quantitative analysis, data analysis, and management with applications such as 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. Since 1995, he has consulted for companies seeking to guide their business decisions by means of analytics. He has written 11 books about quantitative analysis with Excel, including Predictive Analytics: Microsoft(R) Excel and Statistical Analysis: Microsoft(R) Excel.
  • APGRL
    • £25.39
    • RRP £31.99
    • Save £6.60Save 20.000000000000000994759830064140260219573974609375%
    Book + Content Update Program Master core Excel 2016 tools for building powerful, reliable spreadsheets with Excel 2016 Formulas and Functions. Excel expert Paul McFedries shows how to use Excel 2016's 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 In addition, this book is part of Que's exciting Content Update Program. As Microsoft updates features of Excel 2016, sections of this book will be updated or new sections will be added to match the updates to the software. The updates will be delivered to you via a FREE Web Edition of this book, which can be accessed with any Internet connection. To learn more, visit
  • AGHCN
    • £25.49
    • RRP £31.99
    • Save £6.50Save 20.000000000000001278976924368180334568023681640625%
    Your guide to quickly turn data into results. NOTE: This book is based on Office Customer Preview; its content and publication date will be updated for final Office 2013 software. Transform your skills, data, and business - and create your own BI solutions using software you already know and love: Microsoft Excel. Two business intelligence (BI) experts take you inside PowerPivot functionality for Excel(R) 2013, with a focus on real world scenarios, problem-solving, and data modeling. You'll learn how to quickly turn mass quantities of data into meaningful information and on-the-job results - no programming required! Understand the differences between PowerPivot for Self Service BI and SQL Server Analysis Services for Corporate BI Extend your existing data-analysis skills to create your own BI solutions Quickly manipulate large data sets, often in millions of rows Perform simple-to-sophisticated calculations and what-if analysis Create complex reporting systems with data modeling and Data Analysis Expressions Share your results effortlessly across your organization using Microsoft SharePoint(R)
  • AVLRT
    • £25.49
    • RRP £31.99
    • Save £6.50Save 20.000000000000001278976924368180334568023681640625%
    To get the right insights from your data, you need to model it right. From Power BI to Power Pivot for Excel, Microsoft offers extremely powerful and accessible tools for modeling data. Now, for the first time, there's a complete guide to building exceptionally effective models using Microsoft's tools. World-renowned Microsoft data analytics experts Marco Russo and Alberto Ferrari introduce all the data modeling theory you'll need, and show how to apply it in the context of Microsoft's current and evolving products. Step by step, you'll learn how to transform simple tables into full analytical models of immense power. You'll master data modeling through a collection of realistic scenarios of increasing sophistication. For each, the authors start with a simple "naive" model that can't provide robust solutions. Next, they guide you to update and improve the model, so it can deliver the knowledge and insights you really need.
  • AQIMB
    • £25.49
    • RRP £31.99
    • Save £6.50Save 20.000000000000001278976924368180334568023681640625%
    MASTER CORE EXCEL 2016 TOOLS FOR BUILDING POWERFUL, RELIABLE SPREADSHEETS! Use this guide to automate virtually any routine 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, so you can act on it...capture data from anywhere, and use it anywhere...automate Excel 2016's best new features. You'll find simple, step-by-step instructions, real-world case studies, and 50 workbooks packed with bonus examples, macros, and solutions-straight from MrExcel! * Get started fast with Excel macro development * Work efficiently with ranges, cells, and formulas * Build super-fast applications with arrays * Automate Excel's new pivot table enhancements * Collect user data with custom dialogs * Make your macros more reliable and resilient * Pull data from the Internet with web queries * Use advanced classes, collections, and custom functions * Build sophisticated business analysis solutions * Read and write to Access or SQL Server databases * Control other Office programs, and Windows itself * Write code that also works on older Excel versions * Start writing Office Store-style Excel Apps About MrExcel Library Every book in the MrExcel Library pinpoints a specific set of crucial Excel tasks and presents focused skills and examples for performing them rapidly and effectively. Selected by Bill Jelen, Microsoft Excel MVP and mastermind behind the leading Excel solutions website MrExcel.com, these books will * Dramatically increase your productivity-saving you 50 hours a year or more * Present proven, creative strategies for solving real-world problems * Show you how to get great results, no matter how much data you have * Help you avoid critical mistakes that even experienced users make This book is part of Que's Content Update Program. As Microsoft updates features of Excel, sections of this book will be updated or new sections will be added to match the updates to the software. See inside for details.
  • AQEMC
    • £25.49
    • RRP £31.99
    • Save £6.50Save 20.000000000000001278976924368180334568023681640625%
    CRUNCH ANY DATA, FROM ANY SOURCE, QUICKLY AND EASILY, WITH EXCEL 2016 PIVOT TABLES! Use Excel 2016 pivot tables and pivot charts to produce powerful, dynamic reports in minutes instead of hours...understand exactly what's going on in your business...take control, and stay in control! Even if you've never created a pivot table before, this book will help you leverage all their amazing flexibility and analytical power. *Create, customize, and change your pivot tables and pivot charts*Transform gigantic data sets into crystal-clear summary reports*Summarize and analyze data even faster with new Excel 2016 recommended pivot tables*Instantly highlight your most (and least) profitable customers, products, or regions*Quickly filter pivot tables using slicers*Use dynamic dashboards using Power View to see exactly where your business stands right now*Revamp analyses on the fly by simply dragging and dropping fields*Build dynamic self-service reporting systems your entire team can use*Use PowerPivot or the Data Model to create pivot tables from multiple data sources and worksheets*Work with and analyze OLAP data, and much more About MrExcel Library: Every book in the MrExcel Library pinpoints a specific set of crucial Excel tasks and presents focused skills and examples for performing them rapidly and effectively. Selected by Bill Jelen, Microsoft Excel MVP and mastermind behind the leading Excel solutions website MrExcel.com, these books will *Dramatically increase your productivity-saving you 50 hours a year or more*Present proven, creative strategies for solving real-world problems *Show you how to get great results, no matter how much data you have*Help you avoid critical mistakes that even experienced users make
  • BFVRJ
    • £25.49
    • RRP £31.99
    • Save £6.50Save 20.000000000000001278976924368180334568023681640625%
    Experience learning made easy-and quickly teach yourself how to organize, analyze, and present data with Excel 2010. With STEP BY STEP, you set the pace-building and practicing the skills you need, just when you need them! Topics include creating formulas, calculating values, and analyzing data; presenting information visually with graphics, charts, and diagrams; building PivotTable dynamic views; using the new Excel Web App; reusing information from databases and other documents; creating macros to automate repetitive tasks and simplify your work; and other core topics.
  • BFYZD
    • £25.49
    • RRP £31.99
    • Save £6.50Save 20.000000000000001278976924368180334568023681640625%
    Experience learning made easy-and quickly teach yourself how to organize, analyze, and present data with Excel 2010. With STEP BY STEP, you set the pace-building and practicing the skills you need, just when you need them! Topics include creating formulas, calculating values, and analyzing data; presenting information visually with graphics, charts, and diagrams; building PivotTable dynamic views; using the new Excel Web App; reusing information from databases and other documents; creating macros to automate repetitive tasks and simplify your work; and other core topics.
  • AGKIV
    • £25.59
    • RRP £31.99
    • Save £6.40Save 20.00%
    Maximize your Excel 2013 experience using VBA application development The new Excel 2013 boasts updated features, enhanced power, and new capabilities. Naturally, that means John Walkenbach returns with a new edition of his bestselling VBA Programming book and covers all the methods and tools you need to know in order to program with Excel. With this comprehensive guide, "Mr. Spreadsheet" shows you how to maximize your Excel experience using professional spreadsheet application development tips from his own personal bookshelf. Featuring a complete introduction to Visual Basic for Applications and fully updated for the latest features of Excel 2013, this essential reference includes an analysis of Excel application development and is packed with procedures, tips, and ideas for expanding Excel's capabilities with VBA. Offers an analysis of Excel application development and a complete introduction to VBA Features invaluable advice from "Mr. Spreadsheet" himself, bestselling author John Walkenbach, who demonstrates all the techniques you need to create Excel applications, both large and small Covers navigating the Excel interface, formatting worksheets, interacting with other Office applications, working with collaboration tools, and using sample workbooks and John Walkenbach's award-winning Power Utility Pak to help enhance your Excel skills Provides tips, tricks, and techniques for expanding Excel's capabilities with VBA that you wont find anywhere else Excel 2013 Power Programming with VBA is packed with procedures, tips, and ideas for achieving Excel excellence with VBA.
  • AFUBH
    • £25.59
    • RRP £31.99
    • Save £6.40Save 20.00%
    Pivot Table Data Crunching: Microsoft(r) Excel(r) 2013 CRUNCH ANY DATA, FROM ANY SOURCE, QUICKLY AND EASILY, WITH EXCEL 2013 PIVOT TABLES! Use Excel 2013 pivot tables and pivot charts to produce powerful, dynamic reports in minutes instead of hours...understand exactly what's going on in your business...take control, and stay in control! Even if you've never created a pivot table before, this book will help you leverage all their amazing flexibility and analytical power. In just the first seven chapters, you learn how to generate complex pivot reports complete with drill-down capabilities and accompanying charts. Then, you go even further, discovering how to build a comprehensive, dynamic pivot table reporting system for any business task or function. Learning advanced pivot table and pivot chart techniques for Excel 2013 or the newest Office 365 has never been easier. You'll find simple, step-by-step instructions, real-world case studies, even complete, easy recipes for solving your most common business analysis problems. * Create, customize, and change your pivot tables and pivot charts * Transform gigantic data sets into crystal-clear summary reports * Summarize and analyze data even faster with new Excel 2013 recommended pivot tables * Instantly highlight your most (and least) profitable customers, products, or regions * Quickly filter pivot tables using slicers * Use dynamic dashboards using Power View to see exactly where your business stands right now * Revamp analyses on the fly by simply dragging and dropping fields * Build dynamic self-service reporting systems your entire team can use * Use PowerPivot or the Data Model to create pivot tables from multiple data sources and worksheets * Work with and analyze OLAP data, and much more About MrExcel Library: Every book in the MrExcel Library pinpoints a specific set of crucial Excel tasks and presents focused skills and examples for performing them rapidly and effectively. Selected by Bill Jelen, Microsoft Excel MVP and mastermind behind the leading Excel solutions website MrExcel.com, these books will * Dramatically increase your productivity-saving you 50 hours a year or more * Present proven, creative strategies for solving real-world problems * Show you how to get great results, no matter how much data you have * Help you avoid critical mistakes that even experienced users make CATEGORY: Spreadsheets COVERS: Microsoft Office Excel 2013
  • AQHDJ
    • £25.59
    • RRP £31.99
    • Save £6.40Save 20.00%
    Excel 2016 In Depth Full Color: Figures and code appear as they do in Excel 2016 Beyond the Basics...Beneath the Surface...In Depth Do more in less time! Experienced with Excel? Don't let Excel 2016 make you feel like a beginner again! This new full-color edition of the bestselling book has been completely overhauled. Gone is unnecessary and rarely used content; emphasis is on the most-used and new aspects of Excel 2016. The result is a focused book where every topic is relevant and worth learning. Excel 2016 In Depth is the fastest, smartest way to master Excel 2016's full power and updated interface. You'll discover how to leverage Excel's new tools for charting, business analysis, data visualization, forecasting, and more. * Quickly clean your data with Excel 2016's powerful Get & Transform tools * Discover Excel 2016's newest charts: waterfall, histogram, Pareto, sunburst, TreeMap, and Box and Whisker * Use Forecast Sheets to forecast the future, including seasonal adjustments * Pivot data on maps with 3D Maps, and animate your maps over time * Create formulas, charts, subtotals, and pivot tables faster than ever * Create amazing PowerPivot data mashups that integrate information from anywhere * Automate repetitive functions using Excel macros * Solve real-world business intelligence analysis problems * Use PowerPivot Data Model to create pivot tables from multiple data sets without VLOOKUP * Share workbooks on the Web and social networks * Leverage Excel to create highly interactive web pages and online surveys * Quickly apply attractive, consistent formats This book is part of Que's Content Update Program. As Microsoft updates features of Excel, sections of this book will be updated or new sections will be added to match the updates to the software. See inside for details.
  • AUQVB
    • £19.99
    • RRP £24.99
    • Save £5.00Save 20.00%
    Learn all of Excel's statistical tools Test your hypotheses and draw conclusions Use Excel to give meaning to your data Use Excel to interpret stats Statistical analysis with Excel is incredibly useful and this book shows you that it can be easy, too! You'll discover how to use Excel's perfectly designed tools to analyze and understand data, predict trends, make decisions, and more. Tackle the technical aspects of Excel and start using them to interpret your data! Inside...* Covers Excel 2016 for Windows(R) & Mac(R) users * Check out new Excel stuff * Make sense of worksheets * Create shortcuts * Tool around with analysis * Use Quick Statistics * Graph your data * Work with probability * Handle random variables
  • AQDFC
    • £19.99
    • RRP £24.99
    • Save £5.00Save 20.00%
    Take your data analysis and Excel programming skills to new heights In order to take Excel to the next level, you need to understand and implement the power of Visual Basic for Applications (VBA). This 4th edition of Excel VBA Programming For Dummies introduces you to a wide array of new Excel options, beginning with the most important tools and operations for the Visual Basic Editor. Inside, you'll get the lowdown on the essential elements and concepts for programming with Excel, discover techniques for handling errors and exterminating bugs, working with range objects, controlling program flow, and much more. With the release of Microsoft Office 2016, Excel will see changes in its operating system, and this fun, hands-on guide will make it easier than ever to harness the power of Visual Basic for Applications and create custom applications and macros on the world's most popular spreadsheet tool. Packed with friendly advice on the easiest ways to develop custom dialog boxes, toolbars, and menus, you'll be creating Excel applications custom-fit to your unique needs in no time at all! * Provides step-by-step instructions for creating VBA macros to maximize productivity * Helps to increase efficiency by demonstrating how to customize your applications so they look and work the way you want * Fully updated for Excel 2016 * All sample programs, VBA code, and worksheets are available at dummies.com If you're a beginning to intermediate VBA programmer looking to get up to speed on creating customized solutions with Excel applications, Excel VBA Programming For Dummies, 4th Edition makes it easier.
  • BBZZE
    • £19.99
    • RRP £24.99
    • Save £5.00Save 20.00%
    The comprehensive reference, now completely up-to-date for Excel 2013! As the standard for spreadsheet applications, Excel is used worldwide - but it's not always user-friendly. However, in the hands of veteran bestselling author Greg Harvey, Excel gets a whole lot easier to understand! This handy all-in-one guide covers all the essentials, the new features, how to analyze data with Excel, and much more. The featured minibooks address Excel basics, worksheet design, formulas and functions, worksheet collaboration and review, charts and graphics, data management, data analysis, and Excel and VBA. * Covers the changes in the newest version as well as familiar tasks, such as creating and editing worksheets, setting up formulas, and performing statistical functions * Walks you through the new analysis tools that help make it easier to visualize data with the click of a mouse * Details new ways to explore your data more intuitively and then analyze and display your results with a single click Whether you're an Excel newbie or a veteran user to wants to get familiar with the latest version, Excel 2013 All-in-One For Dummies has everything you need to know.
  • AUQWA
    • £17.59
    • RRP £21.99
    • Save £4.40Save 20.00%
    Choose, manage, and present data Select the right forecasting method for your business Use moving averages and predict seasonal sales Create sales forecasts you can trust You don't need magic, luck, or an advanced math degree to develop reliable sales forecasts; you just need Excel and this book! This guide explains how forecasting works and how to use the tools built into Excel. You'll learn how to choose your data, set up tables, chart your baseline, to create both basic and advanced forecasts you can really use. Inside...* Prevent common issues * Why baselines matter * How to organize your data * Tips on setting up tables * Working with pivot charts * How to forecast seasonal sales revenue * Forecasting with regression
  • AQYNM
    • £17.59
    • RRP £21.99
    • Save £4.40Save 20.00%
    Make the most of your data using the power of Excel When you think of data, do you think of endless rows and columns in spreadsheets? Excel Dashboards and Reports For Dummies, 3rd Edition shows you how to make the most of your data and puts an end to mind-numbing spreadsheets by exploring new ways to conceptualize and present key information. There's often a gap between handling data and synthesizing it into meaningful reports, and this approachable text bridges this gap with quick and accessible information that answers key questions, like how to meaningfully capture data trends, how to show relationships in data, and when it's better to show variances than actual data values. As a leading spreadsheet application, Microsoft Excel is the go-to data software. This tool allows you to use dashboard reports that leverage gauges, maps, charts, sliders, and other visual elements to present complex data in a manner that's easy to understand. Using Excel dashboards effectively can improve your professional capabilities by leaps and bounds. * Analyze and report on large amounts of data in a meaningful way * Look at data from different perspectives, and better visualize the information you're presenting by quickly slicing data on the fly * Automate redundant reporting and analysis functions, making your data analysis and reporting routine more efficient * Create visualizations, dashboards, and what-if analyses that are as visually appealing as they are substantial Excel Dashboards and Reports For Dummies, 3rd Edition is a fantastic resource if you're looking to spice up your reporting!