top of page

NEWS


Introduction to database connections in Excel for efficient risk control - Part 2
Part 2: Creating dynamic queries in Excel with VBA In the last article, we introduced how to use the EXCEL interface to connect EXCEL...

Introduction to database connections in Excel for efficient risk control - Part 1
Part 1: How to make automatic reports Introduction: Microsoft Excel and SQL database are the basic tools of data analysis. Regular tasks...
bottom of page