...

6 esProc Desktop

 

Understanding

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

Practice

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

esProc Desktop and Excel Processing

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

 
 •  583 View  •