XLGL Toolbox #1

XLGL 4.0 Reports

XLGL 4.0 Preview

We just added a video preview of XLGL 4.0 on YouTube. The new version won’t be available for a while, but you can still let us know what you think. (Watch it on YouTube)

XLGL 3.3

We just released XLGL 3.3 with new material in the Getting Started guide and 3 new templates. There are other minor addition, but today I’ll focus on the new templates.

In the past couple of months, we have been getting more and more question on Excel PivotTables and Dashboards. Here are quick answers: Yes, XLGL works with PivotTables, and Yes, XLGL can produce amazing Dashboards.

Because dashboards are usually very personnalized, we never included any model/template for them. XLGL 3.3 changes that. We’ve included 2 new templates based on PivotTables and one complete company dashboard, featuring all sort of Excel tools that XLGL can work with: Shapes, Autofilters, Tables, PivotTables, Graphs, …

These templates can be found under the XLGL Ribbon/menu, and Templates. They were built specifically for Excel 2007, but can be used with previous version of Excel if you have the Microsoft Office Compatibility Pack (Available here). They just look better in Excel 2007.

Here are some snapshot:

We won’t be adding any new templates until XLGL 4.0. If you have any special request, make sure to let us know.

Pierre Alain

XLGL 3.2

Last week, we released version 3.2 of XLGL. If you have opt to receive notification on startup, XLGL will have told you so when opening Excel. If not, you can go to XLGL, Check for Updates.

As we’re deep into development for version 4.0, our biggest update ever (available next fall), we found that the following improvements would make a difference to a lot of people and decided to include them in the current version.

So, what’s new? Small improvement that will make, we hope, a big difference. The first thing you’ll notice, if you’re using Excel 2007, is the new Ribbon interface:

 

 You still have access to the XLGL menu under Add-ins, but we believe this integrated interface will serve everyone better.

The next thing you might already have noticed on the image above is the Templates button (also available in the regular menu). All reports that were previously online are now available directly from XLGL. Just click Templates, pick your report and click OK. Moreover, we’ve improve all the report for a common look and feel.

Finally, we’ve replaced the tutorial with a Getting Started Guide which covers more information and shows a greater diversity of what can be done, without going to far into technical details. We hope new users will appreciate this one.

Other than that, there are some more minor improvements, such as the Suggest button on the Ribbon to make a quick suggestion, and other minor fixes.

Let us know what you think. Anything else you like to see added quickly?

Pierre Alain