Register now or log in to join your professional community.
<p>Excel would be useful for analysis , but we need data in summarizing form. We have to draw a format as Model for proper execution,where we just input the data & see the updated snapshot in dynamic way.</p>
Yes its possible if you design the whole workbook in such a way that there is a main sheet with all the variable that you can control and on the other sheet there is all the calculation going on which takes data from the main sheet.
Lastly this data would be presented on a third sheet which will be your dashboard sheet.
Microsoft Office Access and Microsoft Office Excel possess many similarities, which can make it difficult to decide which program you should use. For example, both programs can store large amounts of data, run powerful queries and analysis tools to slice and dice that data, and perform sophisticated calculations that return the data that you need.
yes
Agree with Mr. Mashhood Sadi.
By designing a workbook we can utilize MS Excel as a database
