Receive our FREE PowerPoint Toolkit

The Flevy PowerPoint Toolkit contains over 50+ slides worth of diagrams, shapes, charts, tables, and icons for you to use in your business presentations.

Flevy is the marketplace for premium business documents.
Buy and sell PowerPoint templates, business frameworks, presentation templates, and more.

Excel is an incredibly useful and powerful tool. To greatly extends its functionality, all we need is just some VBA programming. Below, we have 3 such examples of useful tools built in Excel.

Gantt Chart Generator
This tool allows you to automatically create and format extensive project plans in Gantt Chart format.

Org Chart Generator
This tools allows you to dynamically create very detailed, complex organization charts using in Excel.

Automatic Copy/Paste for Microsoft PowerPoint
This tool allows you to automatically update hundreds of Microsoft PowerPoint slides, charts and tables from Excel in minutes. This tool is incredibly useful for managing large PowerPoint presentations that require frequent updates and formatting changes.

For more examples of sophisticated Excel tools and spreadsheets, have a look here:

I’ve always felt the easiest way to learn VBA programming for Excel is by testing and experimenting with the code of others.  The three Excel documents above are great ones to start with.

Tagged with:

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>