Pricing Analysis in Excel: Make A Price Corridor in Three Simple Steps
This article describes a step-by-step introduction to price corridor analysis with Excel. You will learn the meaning of a price corridor and how to create a price corridor in Excel from a list of sales transactions in your ERP system. Let us…
Predictive Sales Analytics in Excel? Yes, you could!
How to do predictive analysis in Excel: One Useful Example of Predictive Sales Analytics & Predictive Modeling in Excel One of the critical tasks of a sales manager is to timely identify which opportunities have better chances of closing and…
Forecasting Individual Customer Lifetime Value: Why You Should Not Use External Data
There are two types of historical data to use for predictive analytics and sales forecasting: internal and external data. How to know which one to choose? Making a forecast always requires planning under conditions of uncertainty. Successful sales…
Market Basket Analysis in Excel – Example for Cross-Selling in B2B
One Useful Example of Predictive Sales Analytics Using Excel Cross-selling is the practice of selling an additional product or service to an existing customer. Indeed, B2B companies define cross-selling in general and cross-selling…