Financial Modeling
Ask your modeling questions here! Feel free to copy/paste specific sections from filings as appropriate.
Questions/Discussions
Sort by Date ▼ / Top Rated
Register for free or log in at the top right of this page to join the discussion
we are constantly setting up models and running different case scenarios based on variable inputs we create in our models. Often times we need to summarize these cases onto one table and because the models are complex and we change more than one variable at a time it sometimes means cutting and pasting the result--this however usually creates a fixed summary table of the results---and that's a problem because there is always a change that needs to be made to at least one of the cases and now we have a fixed summary table. I was thinking that a pivot table might be helpful but then again it may not flow with all the variable input changes we make---because I am a little rusty on pivot tables but I recall they only work with fix data. So I was looking at your Advance Excel for Data Analysis and Macros class and thinking this could help---or perhaps anther class you teach might better address this problem---or maybe there is no easy way to address this problem. Are there any classes you are instructing right now that would address this issue? Read More