Waiting for PivotTable Auto Refresh got old, so I built a VBA tool that keeps them updated on my terms.

These reusable shortcuts handle pasting, navigation, cleanup, indexing, and timestamps from any standard Excel workbook.

Note TraceSpy will not evolve, instead, use WpfTraceSpy (see below). Update 2025/08/14: Added easy support for ETW logging and TraceSpy for Microsoft Logging Abstractions (ASP.NET Core, etc.) Update ...

Have you ever found yourself drowning in a sea of invoices, struggling to keep track of due dates, payments, and customer details? Managing invoices manually isn’t just tedious—it’s a recipe for ...

Programming languages are constantly evolving to address modern challenges, drive innovation, and meet industry demands. As 2025 approaches, the programming landscape can now see the full potential of ...

Outlook command line switches will help you automate a lot of actions and start the email client exactly as you need. We have created a comprehensive list with command line switches for Outlook that ...

Today’s best Excel courses offer hands-on experience with macros, VBA and more. Microsoft Excel is an indispensable spreadsheet tool used across many professions. Financial modelling, budgeting, data ...

Copilot in Excel introduces new finance-focused capabilities that help teams work to their standards, use trusted financial data, and stay in control of every change. GPT‑5.5 Instant is now available ...

Microsoft Excel is a powerful tool for data analysis, financial modeling, and general productivity tasks. Whether you’re a novice or an expert, there are always new tricks and techniques to learn that ...