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:

• https://flevy.com/browse/filetype/Excel

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.