Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 06-14-2010, 04:09 AM
Kimberly Kimberly is offline Financial Data Organization Windows 7 Financial Data Organization Office 2010 (Version 14.0)
Expert
 
Join Date: May 2010
Posts: 517
Kimberly is on a distinguished road
Default

In general, it is much better to place all of the data in a single range on a single worksheet when you can (whenever the structure is the same.)

I don't know what calculations you are doing, or what Data1, Data2, etc are, but by placing the data on a single sheet, you can easily take advantage of features like filtering and pivot tables. And of course, simple division is a bit easier too.

I don't know what Data1 Data2 Data3 are, and they are probably fine, but since I don't know what they are, I will mention that it is easy to fall into using for column labels what should be data in a column. For example, if I sold vegetables on the side of the highway, I would want a field for Item and another for Quantity. Not a field for Corn and a different field for Beans, etc. Again, I dont knowyour data and I really doubt you need to change this, but I thought I should mention it.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Financial Data Organization Federal financial rounding? markg2 Excel 6 05-26-2010 09:54 AM
Organization chart glendot Word 0 02-23-2010 08:15 AM
Formatting financial ratios jtrobinson Word 0 01-19-2010 06:46 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:56 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft