Being able to retrieve a list of all DAX measures in a PowerPivot Data Model can be a time-saving and helpful technique for data analysts and business intelligence professionals.

This tutorial explains clearly the Double Exponential Smoothing forecasting method.

The second tutorial explains clearly the Simple Exponential Smoothing forecasting

This Forecasting Bootcamp aims at providing clearly explained tutorials for the fundamentals of Forecasting. In the first lesson, we talk about the Moving Averages and the Weighted Moving Averages method. We use the Solver in Excel to optimize the accuracy (MAE - Mean Squared Error).

A step-by-step tutorial in Excel SOLVER with a solution for a Transportation optimization problem. Scenario: delivery from 2 warehouses to 5 customers with 2 constraints. Objective: minimize the transportation cost.

A step-by-step tutorial in Excel Regression (Data Analysis tool pack)

Before sending an Excel Workbook to someone, it is a

When refreshing a table you can get an overlapping Pivot

Solving real business problems with VBA.

Easy to understand analogy Excel - Pandas.