O'Reilly logo

Excel 2010 Financials Cookbook by Andre Odnoha

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Creating a dashboard for financial functions while minimizing Excel

Many of the "beyond the grid" elements that can be added to Excel still require that the application of Excel to show to the user. This begins to diminish the customization of the application functions that you create. When presenting an end user with the application functions such as loan applications, timesheet creation, or transaction processing, hiding Excel will add a level of security and functionality that far surpasses windows overlapping the Excel program.

In this recipe, you will learn to create a dashboard for VBA financial functions that will remove the Excel application from view and function as a standalone secure application.

Getting ready

VBA is highly functional ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required