Spreadsheets category: 384 books

         This is today’s most complete guide to regression analysis with Microsoft® Excel for any business analytics or research task. Drawing on 25 years of advanced statistical experience, Microsoft MVP Conrad Carlberg shows how to use Excel’s regression-related worksheet functions...

  Accurate, practical Excel predictive analysis: powerful smoothing techniques for serious data crunchers!   In More Predictive Analytics, Microsoft Excel® MVP Conrad Carlberg shows how to use intuitive smoothing techniques to make remarkably accurate predictions. You won’t...

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

Microsoft Excel is a fantastic tool for both business and personal use. And one of the most powerful uses of Excel for individuals is in tracking your finances. This guide will walk you through how to create an Excel workbook that will allow you to track your monthly expenses, your cash and...

Charts are a fantastic way to visualize your data. They add a level to your analysis that just isn’t possible with data tables and number-crunching. Plus, they’re great for presentations where you need to show someone else what you’re talking about. And they’re easy to learn...

It’s not enough to enter information into Excel. If you really want to work effectively with your data, you need to format it. That could mean anything from adding borders so that your document looks good when it prints to adding fill color in the header row of a table to simply formatting...

Knowing how to print documents that you’ve created in Excel is an essential skill. Think how many pieces of paper have been wasted over the years because someone didn’t know how to format an Excel document for printing. Or how many people have had to sit there and hold a second page with...

As soon as you self-publish, you're running a small business. (At least most of us are.) Which means you need to start thinking about things like advertising costs and whether or not you're making a profit from your efforts. That's where Excel comes in handy. Using the analysis tools it provides,...

Microsoft Excel is an amazing tool. Once you've mastered the basics, it's time to learn a few tips and tricks to take things to the next level. In this guide you'll learn how to create pivot tables, chart your data, apply conditional formatting, and many other more advanced tools for getting the most...

From the author of “The Excel Answer Book” comes the fastest and easiest method to Master the Most Useful LOOKUPS and LOGICAL Formulas in Microsoft Excel Let's face it. Using Microsoft Excel as glorified typewriter isn't it's intented purpose. To make Excel a truly useful tool you need...

From the author of “The Excel Answer Book” comes the fastest and easiest method to Master the Most Useful Financial Formulas in Microsoft ExcelLet's face it. Using Microsoft Excel as glorified typewriter isn't it's intented purpose.To make Excel a truly useful tool you need...

Prepare for Microsoft Exam 70-778–and help demonstrate your real-world mastery of Power BI data analysis and visualization. Designed for experienced BI professionals and data analysts ready to advance their status, Exam Ref focuses on the critical thinking and decision-making acumen needed for success...

A step-by-step tutorial with focused examples that builds progressively from basic to advanced topics and helps you create business intelligence reports and dashboards quickly and efficiently using the PowerPivot add-in.This book is ideal for data analysts, reporting and MIS professionals, business analysts,...

Microsoft Excel and Access are two most important software in MS Office package. Microsoft Excel is used for spreadsheet analysis and Access is used for some relational database data operation. These two software are mandatory to help any of your office needs. This Two in One Excel and Access 2016...