^ Ytube
Get a job?
Hire an Indian to do it?
^ why ?
More productive at a quarter of the price.
The ExcelisFun channel on youtube (and Mr. Excel’s stuff) are both very good.
What does this mean? Are we talking about the VBA editor?
It just means color code your cells before you’re done. That way they’re easier to debug. Even better if you do it with a macro. In addition to being a cool way to do it, you can do it after the fact. and you can use the macro to help debugging others’ models - it shows when they’ve hard-coded something pretty quickly.
Hadn’t thought to do it with a macro. That’s an interesting approach.

hei.so:
CFAvsMBA:Black for formulas, blue for text inputs
What does this mean? Are we talking about the VBA editor?
It just means color code your cells before you’re done. That way they’re easier to debug. Even better if you do it with a macro. In addition to being a cool way to do it, you can do it after the fact. and you can use the macro to help debugging others’ models - it shows when they’ve hard-coded something pretty quickly.
So like conditional formatting?
Exactly.

iamthenight:
anyone can share where to learn all the impt excel stuff without paying an arm and leg for it??
thanks
The ExcelisFun channel on youtube (and Mr. Excel’s stuff) are both very good.
thanks prof