Posts by: Guest 1

How to not auto-resize rows when using Underline
I really like the custom formatting that is used in the WST models and i'm adopting it for use throughout all of my models. The model templates all come with even row heights (size 12.00), even for rows that have underlines in them. However, if I were to hit ctrl + U to create the custom long-underl... Read More
Go to post added 11 years ago
Modeling ADR shares
Hello, I have a question in regards to conducting valuations for ADR listed companies. From my understanding, it looks like the models are conducted and valued at the local currency. In order to translate the valuation model into USD do we typically use the Temporal/Current Method for translation... Read More
Go to post added 11 years ago
Re: Macro error: compile error in hidden module: thiswork
I forgot another detail that may be able to help you.
After I select WSTShortCutKeyActivate,

A window pop with the following message:
Run-time error '1004':
Method 'OnKey' of Object '_Application' failed
Go to post added 11 years ago
Growth Vs %rev
In the income statement support, how do we know which items we want as % growth and % of revenue? Does it matter?
Go to post added 11 years ago
Excel Macros
How can I create an excel macro that uses the ctrl + shift + alt buttons, like you guys have in your wall st training macros? I cant figure out how to do more than just shift + ctrl shortcuts.
Go to post added 11 years ago
Re: att and t-mobile deal
Thanks a lot! Very helpful.
Go to post added 11 years ago
Re: Zoom in Excel
CRTL + J does not work for zooming in Excel. I am using Windows 7. Does this matter?
Go to post added 11 years ago
Custom fonts for Chart Y Axis.
Could someone walk me through the steps on how I can get my y axis labels in a chart to only have the dollar sign at the top marker and the rest aligned correctly but not with the dollar sign obviously. I have tried to do this as he is doing in video over and over again but it doesn't work.
Go to post added 11 years ago
Conditional Formatting
I have a project for which there are three distinct phases and each one needs a different color. It needs to be color coded across the entire row. There are multiple steps for each phase. Although the steps stay the same, we make iterations in which they change phase constantly. Can I use condit... Read More
Go to post added 11 years ago
Why do bankers use the paste enhanced picture for excl chart
It seems that pace enhanced pictures into ppt from excel for charts do not look nearly as clear as just pasting the actual chart in chart form. Why is the Paste enhanced picture the preferred format?
Go to post added 11 years ago