Noob Excel Question
I'm on a make-shift Corp Dev team at a Tech company with no real transactions experience (go figure lol).
Building out a customer forecasting model for a target on Google Sheets. I'll be download as a .XLS and building Data Tables for Sensitivities on the sheet and exporting the values into Google Sheets. (any better way to do this for people who have used sheets?)
Question(s):
I have my model built out with all my assumptions / inputs in the top rows, say rows 1-20, and the actual monthly forecast below it. It looks like shit, especially with all the frozen pains for the line items.
-
If I move all my assumptions / inputs to a separate sheet before exporting, will I still be able to do the Data tables? From what I understand, the assumptions / inputs need to be on the same sheet as the formula that's driving the data table
-
Can I build the data tables independtly on a seperate sheet?
-
Is there a better way to do this given my Google Sheets constraint? I can't have this on an excel sheet because our CEO / CFO / CorpDev prefer to be able to work on things together.
Sorry doesnt really answer your question but what shit company are you working for that they don’t provide you with Excel
why the fuck are you on sheets
I have an answer to #2...
No, at least not the standard way. You would have to use self-ref IF functions, and they are not too difficult to implement.
Sheets can't do anything Excel can - try again
Odio dolorum corrupti voluptatem et qui voluptatem. Iste rerum natus incidunt blanditiis quaerat perferendis. Illum corporis non maxime enim in rerum nihil. Quaerat reprehenderit eius accusamus est recusandae repellendus.
Eligendi dicta aliquid provident in quae dolorem animi. Omnis error quia iusto consequuntur modi sit. Atque deserunt ipsam veniam similique quos est voluptas.
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...