Excel

3 posts

How To Use Excel for Seasonal Forecasting

If you have years worth of sales data, you can use that data, with the help of Excel, to predict upcoming trends and help you plan for your business. Forecasts can help you with important business decisions, such as managing staff and inventory, planning budgets, and predicting cash flow issues. […]

Seven Core Capabilities of IBM Planning Analytics, a Cloud-Based Budgeting & Planning Automation Solution

In today’s fast-paced business environment, organizations that don’t use data and analytics for planning are flying blind. In the past, data analysis has been cumbersome, time-consuming and resource-intensive (not to mention expensive), requiring analysts who not only analyzed the data, but also spent hours accumulating, entering and then rechecking the […]

How to Use MySQL and Microsoft PowerPivot Together

Overview This document shows how an Open Source Database like MySQL can be used with Microsoft’s popular Excel plugin PoweverPivot.  Many clients enjoy the familiarity of Excel and ease of use that PowerPivot brings but the clients do not want to married with any one particular vendor in their Business […]