Spreadsheets category: 384 books

Excel 2013 On Demand is built from the ground up for today's beginning-to-intermediate-level Exceluser. Like every book in the On Demand Series, it teaches visually, using an easy, friendly, full-color format designed to "show you how," instead of "telling you how." But that's...

Data Analysis and Visualisation Tools This book covers some really exciting ways to work with Excel. It’s for anyone who wants to acquire a solid foundation of how to use charts and pivots, with suggestions on how to build on that knowledge. There are many ways to analyse data; the focus...

This is the eBook of the printed book and may not include any media, website access codes, or print supplements that may come packaged with the bound book. *** *** Master business modeling and analysis techniques with Microsoft Excel 2016, and transform data into bottom-line results....

Covering a variety of Excel simulations, from gambling to genetics, this introduction is for people interested in modeling future events, without the cost of an expensive textbook. The simulations covered offer a fun alternative to the usual Excel topics and include situations such as roulette, password cracking, sex determination, population growth, and traffic patterns, among many others.

Gain Deeper Insights, Make Smarter Decisions, and Earn More Profits It’s time to put the full power of Excel quantitative analysis behind your management decisions! Business analysis expert Conrad Carlberg shows you how to use Excel to perform core financial tasks all managers and...

With examples from the world of science, this reference teaches scientists how to create graphs, analyze statistics and regressions, and plot and organize scientific data. Scientists can learn the tips and techniques of Excel—and tailor them specifically to their experiments, designs, and research....

The first characteristic of this book is the skipping of difficult theories, starting directly with typical examples, and the working out of the answers clearly by computer software. The aim is to help readers to be able to solve basic statistical problems in various Common Experimental Designs as...

Containing 277 business case studies that illustrate nearly every aspect of Excel, this book presents real-life business problems and works them through to their solutions. In addition to exemplary solutions, each case analysis considers alternate approaches and gotchas, and includes a summary of...

This book is a single reference that’s indispensable for Excel beginners, intermediate users, power users, and would-be power users everywhere Fully updated for the new release, this latest edition provides comprehensive, soup-to-nuts coverage, delivering over 900 pages of Excel tips, tricks, and...

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...

The 54 essential tips that all Excel users need to know. MrExcel LIVe provides users with a concise book that can be absorbed in under an hour. Includes a section with keyboard shortcuts. Anyone who uses Excel will be able to turn to any page and pick up tips that will save them hours of work.

Conquer Microsoft Excel 2019–from the inside out! Dive into Microsoft Excel 2019–and really put your spreadsheet expertise to work. This supremely organized reference packs hundreds of timesaving solutions, tips, and workarounds–all you need to make the most of Excel’s most powerful...

This book completely and thoroughly covers every trick known about Subtotals in Excel. You will learn: How to get your data ready for subtotals, Adding Subtotals, Showing only the Subtotals, Sorting Subtotals, Formatting Subtotals, Subtotal Tricks, Subtotal Troubleshooting, Using the SUBTOTAL function...

These are the 125 essential tips that all Excel users need to know. MrExcel LX provides users with a concise book that can be absorbed in under two hours. Includes a section with keyboard shortcuts. Anyone who uses Excel will be able to turn to any page and pick up tips that will save them hours of work.