Projects

Merge 3 data files: Forecast, Actuals and Backlog from 3 IT systems. Color where needed. Add subtotals.

Create PivotTable for each product group so product compatibility can be determined.

Process PowerBI world wide forecast Quarterly data so a PivotTable with slicers is created automatically. Easy 'slicing data'.

From customer nr to other nr showing a year qty forecast (VLOOKUP tables).

Format a backlog workbook for easy reading.

Simulate Secured business, Extrapolated business and Best case business (SEB methodology).

Load and compare data files and color differences.

Load a file and mark what was changed.

Extract email addresses from polluted data.

Fill out a customer form and create PDF.

Show business trending Year Over Year from massive data.

Calculate Late Delivery penalty (out of SLA).

Clean an SAP export file into a human friendly workbook.

Action Tracker renumbering. Extra task, no issue. Numbering still OK.

Cut and rename files. Read files based on a nr in file name.

Mailing Excel VBA controlling Outlook email application (HTML formatted with a embedded link)

Set PC is Boost Mode or ECO mode (as an electric car)