RaqForum 25 No.
1,420 View  • 
     ...

5 esProc Desktop

 

Actually, Python is far beyond you
What programming language should none professionals learn?

The very tool to liberate an Excelman from working overtime - SPL
The very tool to liberate an Excelman from working overtime - ReportLite

Looking for the Best Excel Add-ins

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
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

Desktop Practice: Subject on merging Excel files
Desktop Practice: Subject on Splitting Excel File
Series on Solving Excel Puzzles Using SPL: Data Filtering Issues
Series on Solving Excel Puzzles Using SPL: Association & Comparison

 
 •  1,420 View  •