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

VBA

Various stuff

Defined names

Trouble shooting

Charting

Cell formatting

Formulas and functions

Forms

External Data

User Defined functions

Other Applications

Fun

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