Python in Excel
Compare Two Tables and Find Mismatches
Use pandas grouping, outer merge and the merge indicator to identify matching, missing and extra records.
Excel • VBA • Python • SQL • Automation
Practical automation for finance professionals.
Clear, hands-on tutorials that help accountants and finance teams compare data, automate repetitive work and build more reliable workflows.
Latest tutorials
Solutions built around real work.
Excel VBA
Format Numbers and Switch Signs Faster
Practical keyboard shortcuts for repetitive formatting tasks, including filtered and visible cells.
Topics
Tools that support better finance workflows.
Excel & VBA
Shortcuts, reusable macros and practical workbook automation.
Python in Excel
Data comparison, reconciliation and analysis with pandas.
SQL
Queries designed for accounting, reporting and financial data.
Automation
Repeatable workflows using Power Query, ODBC and scheduling.
Downloads
Files used in the tutorials.
Download the workbooks and VBA modules directly from glflow.org.
Python in Excel sample workbook
Source tables and reconciliation example from the Python tutorial.
Number Format shortcut
VBA module for toggling between Number and General formats.
Switch Sign shortcut
VBA module for switching the sign of visible numeric constant cells.
About glFlow
Practical solutions, not abstract examples.
glFlow shares focused Excel, VBA, SQL, Python and automation tutorials designed around real accounting and finance workflows. The goal is simple: reduce manual work, improve control and make technical solutions easier to apply.