Category: MS Office

Stop Confusing Power Query with VBA/Macros

Microsoft has been working hard on implementing query and data connection tools in its MS Office products. Now as a result we have a more mature data access tools in shape of Power Query. It is now more easy to connect to various database files outside the workbook in different formats. If you are working […]

MS Office Technology

Saber Apps: Excel Files Merger System

Excel Files Merger System (EFMS) is a free to use application which is designed to merge xls and xlsx files into SQL database and export as csv. This application intends to make it easy to collect and summarize data in excel files. Although there are options like macros and power query but we found them […]

MS Office Saber Apps Technology