CurricUNET is in production for the course approval process. All course data from 10/22/09 is loaded into the system. Information processed between 10/22/09 and 1/11/10 will be updated. Faculty can access this information using the link above and their user id.
The paperwork involved in developing new courses and reviewing existing courses has been a cumbersome task for all involved from faculty members to administrators to committee members. Small changes often required retyping entire documents, and the approval process often took months of waiting as various parties signed off. That is over.
The first and easiest method of formatting a financial model is to use a consistent color scheme to annotate different types of cells and data. Here is a recommended color scheme that is quite commonly known amongst financial analysts FP&A Analyst Become an FP&A Analyst at a corporation.
Excel has a valuable feature known as conditional formatting. This lets the user set rules or thresholds for certain cells. If these rules are met or the thresholds are triggered, Excel will format the cells in a certain way that the user has set. This becomes useful for pointing out certain pieces of data within the model.
Financial model color formatting can also be used to shade certain cells for different effects. In the screenshot below you will notice that the Long-Term Debt schedule uses three different levels of color formatting:
Thank you for reading this guide to financial model color formatting.