top of page

NEWS

Introduction to database connections in Excel for efficient risk control - Part 3
Part 3: Database connections in Excel – Tricks with Oracle In the article “Introduction to database connections in Excel for efficient...


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