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

• Use ReportLite External Library to Auto-insert Reports to Word Templates/li>

esProc Desktop and Excel Processing[c]

• esProc Desktop and Excel processing (2021)[c]
• Excel & Desktop Q&A[c]
• SPL COOKBOOK - Preface[c]

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