6 esProc Desktop



Actually, you will never be able to master Python
What programming language should none professionals learn?

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
The very tool to liberate an Excelman from working overtime - ReportLite

SPL, a very tool for developing quantitative strategy model


How to quickly merge multiple Excel files
SPL Desktop Practice: How to Quickly Split an Excel into Multiple Excels

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
ReportLite Practice: Multi layered cross reports with complex formats
ReportLite Practice: zoned cross report involving multi-table association
ReportLite practice: cross report involving self-defined grouping interval

esProc Desktop and Excel Processing

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