A series of Visual Basic Applications (VBA) methods I wrote, mostly for Excel, to increase the speed and accuracy in working with data, charts and databases.

Have you ever found yourself staring at a sprawling Excel workbook, wondering if you’re using the right tool for the job? Between Power Query, Power Pivot, and VBA, it’s easy to feel like you’re ...

Have you ever wished Excel could do more than crunch numbers and organize data? Imagine generating polished PDFs or sending out personalized emails—directly from your spreadsheet—without needing to ...

Create a report using charts: Select Insert > Recommended Charts, then choose the one you want to add to the report sheet. Create a report with pivot tables: Select Insert > PivotTable. Select the ...

An Excel timer is one that will sit within a cell and count down the seconds as they tick by. Excel doesn't have this kind of feature available in the program's standard set of tools, so to get the ...

Microsoft Excel is arguably the greatest spreadsheet application from Redmond, and there’s a good reason so many number crunchers use it for all of their number crunching needs. While using Microsoft ...

Implementing a drop-down list in Excel is a quick and efficient way to choose predefined data. In the process, you’re able to save time compared to manually entering such data into a given spreadsheet ...

Q. I often use watermarks in Microsoft Word to indicate that the document is a “Draft” or “Confidential.” However, the options to create a watermark are not in Microsoft Excel. I want to indicate that ...

Many users have reported encountering the Class not registered VBA error when running a macro in Excel. This could be due to missing DLL files, corrupt system files ...

Pivot tables are powerful tools which help transform data into meaningful insights. They can help you understand patterns and trends, make accurate forecasts, and improve your decision-making skills.

You can create a release to package software, along with release notes and links to binary files, for other people to use. Learn more about releases in our docs.