Excel VBA Logistics Control Tower
Can we build an Excel file that will show us the #of containers that are at risk for demurrage and […]
Read more →I love building Excel projects!
What are Excel projects?
I’m glad you asked, from my perspective an Excel project is taking Excel’s capabilities to the max. Using VBA , pivot tables , pivot charts and other tricks I built Excel files for customers’ needs.
These Excels pull data from many different sources into one sheet. Names and definitions are combined under one to allow accurate analysis. The next steps are to use formulas to accurately analyse the data and build pivot tables and charts or value based tables for distribution.
I will post examples of projects that were completed and used to the users satisfaction.
Can we build an Excel file that will show us the #of containers that are at risk for demurrage and […]
Read more →