6 esProc Desktop



A correct method for complete novice to self-study of programming
How do beginners learn SQL quickly?
A laymen’s roadmap for data analysis and processing technology

The very tool to liberate an Excelman from working overtime - SPL
What programming language should business people learn?

Python Is Not Built for Business People


How to quickly merge multiple Excel files
Batch summary of multiple Excel spreadsheet data – done in 1 minute
How to merge Excel Sheets horizontally
How to automatically extract eligible rows in Excel
Excel Advanced Group and Summary Method
Set operations of data between Excel columns (intersection, union, difference)
Set operations of Excel inter row data (intersection, union, difference)
SPL XLL Practice: Almighty Text Splitting in Excel
How to do Excel table association – You are out if you know only VLOOKUP
SPL XLL Practice: Excel Interval Association

ReportLite Practice: Generating reports with the same format using different data multiple times

esProc Desktop and Excel Processing

esProc Desktop and Excel processing (2021)
Excel & Desktop Data Processing Q&A