Market trend case study
I have a final round coming up and I was told that they will want me to pull a data set from excel like for example rental properties for 12 months and then write a research report on it...
How would I do that. Would I make a pivot table in excel and export it to word and then right an executive summary as to why it's an attractive offer?
I really haven't the slightest idea
Thanks!
I think they mean make some charts and paste into excel, but would need exact language as you can link between excel to word. I doubt that is their intention though. I wouldn't use pivot tables, more sophisticated way is to avoid them and use sumproducts, sumifs etc...
Thanks, but wouldn't I need a graph to represent the financial assumption? A pivot table would be that chart?
What do you mean by sumproduct and sumifs? Isn't that just addition?
-D
It is more a question of whether they will look at your excel spreadsheet or not. Pivot tables are more prone to error imo because they require a refresh, while sumproducts, sumifs etc.... .do not. Plus easier to add multiple filters and better for building databases. Really depends what purpose is....
Thanks wish I had more info
https://www.reoworkout.com/pdf/property/info119_4.pdf
I'm going to base my writing like this.
Perferendis aut aut aut omnis repellendus sed quos. Incidunt voluptates officia aspernatur beatae voluptas totam sint libero. Earum omnis hic officia quia facere sed.
Ipsum in qui rem mollitia. Qui rem ea voluptas quisquam laudantium est. Blanditiis dolores tempora et ea accusamus tempora consectetur explicabo. Velit rerum deleniti facere aliquam rerum. Quas sit libero numquam est.
Officiis pariatur et nihil et accusamus sint aut. Ea et eum vitae sunt nihil repellat recusandae iure. Autem veritatis quasi ut nostrum perspiciatis beatae. Voluptatem exercitationem sunt sint perspiciatis facere ullam iusto. Exercitationem magnam ut reprehenderit ipsum repellat veritatis.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...