Excel Articles

This page lists all articles currently available on this site (articles that fall under various categories will be listed at each one).

Tips and tricks

On my Excel tips page I collect numerous tips and tricks about Excel and VBA.

Office Script


Various stuff

Defined names

Trouble shooting


Cell formatting

Formulas and functions


External Data

User Defined functions

Other Applications


Third party articles

As a special thanks to the people from spreadsheetdaddy.com (for helping me optimize my website for SEO) two links to their great content:

Creating a Gantt chart in Excel

Best Gantt chart software for project management