Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

Is it possible to utilize MS excel for "Data-base" & "Analysis" as different models?

<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 &amp; see the updated snapshot in dynamic way.</p>    

user-image
Question ajoutée par Zeeshan Ahmad , Accountant , Tech Petroleum LLC
Date de publication: 2014/10/16
Mashhood Sadi CFA Microsoft MOS Excel BBA
par Mashhood Sadi CFA Microsoft MOS Excel BBA , financial analyst , Serco

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.

manseer muhammed ali
par manseer muhammed ali , Accountant General , Royal Lighting L.L.C & Royal Furnishing LLC

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.

Rinshad Jaleel
par Rinshad Jaleel , QC Engineer , Qualimations NDT Training & Services

yes

Zubair Jahangir
par Zubair Jahangir , Cost Accountant , Rotana Hotels

Agree with Mr. Mashhood Sadi.

By designing a workbook we can utilize MS Excel as a database

 

More Questions Like This