Excel • VBA • Python • SQL • Automation

Practical automation for finance professionals.

Excel, VBA, Python and SQL tutorials that save you time, reduce errors and help you work smarter.

▶ Watch on YouTube ⬇ Downloads

Latest tutorials

Solutions built around real work.

Excel VBA

VBA Shortcuts: Format Numbers and Switch Signs

Two practical macros that speed up repetitive formatting tasks in Excel.

▶ Watch tutorial ⬇ Download files

Python in Excel

Compare Two Tables and Find Mismatches

Compare tables, identify missing records and reconcile data using pandas.

▶ Watch tutorial ⬇ Download workbook

Tools for smarter finance workflows.

▣

Excel Automation

Faster, cleaner and more reliable workbook processes.

◇

VBA Macros

Reusable shortcuts and practical workflow automation.

●

Python in Excel

Reconciliation, comparison and data analysis with pandas.

▤

SQL & Oracle

Queries designed around accounting and reporting needs.

Downloads

Files used in the tutorials.

Download the workbooks and VBA modules directly from glflow.org.

XLSX

Python in Excel sample workbook

Source tables and reconciliation example from the Python tutorial.

Download

BAS

Number Format shortcut

Toggle between Number and General formats.

Download

BAS

Switch Sign shortcut

Switch the sign of visible numeric constant cells.

Download

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.