7 Excel habits of highly successful FP&A Analyst
7 Excel habits of highly successful FP&A Analyst
Use check-sum
Your reputation is built over years and ruined in seconds.
Separate inputs from outputs
If you mix cells that contain data copied from somewhere else with cells that have formulas, mistakes are bound to happen.
Use Index/Match or X-lookup instead of V-lookup
Avoid complicated formula
Rely on macros only when necessary
Frequently save under a new name
Document assumption