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

Grouping transaction details in a statement of accounts

Normalizing data does not only involve modifying formats, it all also involves changing how the data is displayed on the screen. In financial reports, the data comprising the account total is extremely important; however, it may not always be beneficial to display all of the underlying information. You could remove the underlying transactions, but that would require a secondary sheet to view this data.

In this recipe, you will learn how to group data to display a summary line while hiding individual transactions; however, the transactions will remain as part of the original file and will be available for viewing at any time.

Getting ready

Before starting, it is important to layout the transaction ...

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