Financial Applications category: 429 books

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

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

** O**n August 1, 2017, the popular cryptocurrency, Bitcoin split into two derivative currencies, Bitcoin Cash (BCH) and Bitcoin Classic (BTC). The origin of the split can be tracked back to 2010. During that time, as a spam control measure, a one megabyte per 10 minutes limit was introduced. The...

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

Filled with practical, step-by-step instructions and clear explanations for the most important and useful tasks. This is a practical, recipe-based book, taking the reader through the hands-on steps required to set up and use PowerPivot with as little fuss as possible. This is an introductory book on...

Excel Programming through VBA: A Complete Macro Driven Excel 2010 Application After completing this EBook you will have a complete, macro driven, Excel application. The original version is Excel 2010, but the code and functionality is designed to work on previous versions; in addition to the 2013...