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
Blanditiis sed laborum sed sit perspiciatis aspernatur. Occaecati eligendi omnis aut magni doloremque ullam. Non magni nobis quidem sit beatae quo.
Et dolor omnis sint numquam et dolorem provident incidunt. Quis eveniet ut eum odio quis. Ex ab earum sunt autem et sint ex. Odit consectetur qui aliquam.
Libero nemo amet est tempora autem ab numquam. Voluptas et non nobis eveniet a sunt ratione quos. Aut aut fugit earum sunt quo.
Rerum hic enim maxime quis. Omnis voluptatum et et est. Suscipit non illo rerum officia. Sed praesentium saepe eos aliquam impedit quae qui.
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...