LahekA Robust Way to reference data in VBALearn how to make your VBA macros more reliable by using Excel tables for dynamic data referencing. No more broken macros !Sep 28Sep 28
LahekHow to Manage Inventory or Orders, Using Just a Scanner and Excel !Managing inventories or verifying product orders can be a real pain. But what if Excel and a simple Barcode scanner were enough? I will…Sep 22Sep 22
LahekExcel in printing Zebra labelsDo you have hundreds of products or boxes to label, and you struggle by printing the labels one by one on your Zebra printer ?Feb 19Feb 19
LahekSlicing Through PDFs: a Excel and Python SynergyImagine having to manually split hundreds of pages of a PDF. Twice a day. Every day. Without any tool to do it, and having to go back and…Feb 17Feb 17
LahekUnleashing PoweQuery : A (Very) Beginner’s Guide to Excel Data TransformationTransform and import data to Excel EASILY !Feb 16Feb 16