Excel VBA
VBA Shortcuts: Format Numbers and Switch Signs
Two practical macros that speed up repetitive formatting tasks in Excel.
Excel • VBA • Python • SQL • Automation
Practical finance solutions
Learn practical Excel, VBA, Python and Oracle SQL techniques to simplify repetitive finance and accounting tasks and build efficient workflows
Latest tutorials
Built from real finance and accounting workflows
Showing all tutorials
Python in Excel
Compare Two Tables and Find Mismatches
Compare tables, identify missing records and reconcile data using pandas.
Oracle SQL
Select the Current Coupon with ROW_NUMBER()
Retrieve the latest coupon record for each instrument using the ROW_NUMBER() window function.
Oracle SQL
Calculate Repo PnL with Oracle SQL
Calculate repo profit and loss for a reporting period using the GREATEST and LEAST functions.
Workflows
See how individual tutorials connect into a complete process
Follow an end-to-end finance workflow across SQL, Power Query, VBA and reporting.
Finance workflow
Repo P&L Reconciliation
Build the process from the P&L calculation through GL reconciliation, Excel automation and reporting.
1 / 5published
01PublishedCalculate Repo P&LOracle SQL · GREATEST & LEASTOpen →
02Next tutorialReconcile P&L with the General LedgerOracle SQL · Analytical data vs. GL entriesComing soon
03PlannedLoad the Reconciliation into ExcelPower Query · Database connectionComing soon
04PlannedAutomate the RefreshExcel VBA · Repeatable workflowComing soon
05PlannedBuild the Reporting LayerPower BI · ODBC reportingComing soon
Downloads
Tutorial resources
Download sample files and code from every tutorial.
Python in Excel sample workbook
Source tables and reconciliation example from the Python tutorial.
Number Format shortcut
Toggle between Number and General formats.
Current Coupon SQL
Retrieve the current coupon for each instrument using the ROW_NUMBER() window function.
Repo PnL SQL
Calculate repo profit and loss for a reporting period using Oracle SQL GREATEST and LEAST functions.
Switch Sign shortcut
Switch the sign of visible numeric constant cells.
About glFlow
Practical solutions, not abstract examples
glFlow provides practical Excel, VBA, SQL, Python and automation tutorials built from real finance and accounting workflows. Every tutorial focuses on solving real business problems that can be applied immediately in daily work.