#CHANGE MAC SHORTCUTS FOR EXCEL HOW TO#
#CHANGE MAC SHORTCUTS FOR EXCEL DRIVERS#
#CHANGE MAC SHORTCUTS FOR EXCEL CODE#
#CHANGE MAC SHORTCUTS FOR EXCEL PC#

#CHANGE MAC SHORTCUTS FOR EXCEL HOW TO#

How to Automate the Color-Coding Process in Excel You can view examples of these standards in action below: We then use a grey background color for the other headers in a schedule вЂ“ sometimes display the years on top depending on the spacing. Headers: We use a blue background color, white text, and the вЂњFYвЂќ format for the top header with the Historical and Projected years.

Usually 1 decimal place for valuation multiples and percentages as well вЂ“ even if the financial figures in the model have 0 decimal places, as is the case here. We also usually use at least 1 decimal place, sometimes up to 2-3, to display the companyвЂ™s share count. Use 1 decimal, 0 decimals, or 2 decimal places for all the financial figures in your modelвЂ¦ exceptions apply for the Share Price and EPS figures, which almost always use 2 decimal places because of how share prices are displayed. Those are in the yellow input boxes!Дecimals: It doesnвЂ™t matter what you do as long as youвЂ™re consistent. Italics: We usually italicize percentages used for informational purposes вЂ“ so, the overall margins and revenue growth rates, but not the assumptions used to calculate them in the first place. Signs: On the IS and CFS, we often use (+) and (-) when it is meaningful to do so вЂ“ for example, if everything in a row is going to be positive or negative, and itвЂ™s easy to specify which is which.

We also indent percentages used for informational purposes such as the margin formulas. Indentation: We indent the individual rows within each category, and we use multiple indents for sub-categories. вЂњUnitsвЂќ: We like to use an extra column to display the units, especially in schedules that mix $ per Sq Ft and Sq Ft and other figures with actual $, to remove ambiguity. Sometimes itвЂ™s a bit ambiguous what a вЂњscheduleвЂќ is вЂ“ often, weвЂ™ll display these in the top and bottom rows of each major segment. For the input boxes, we prefer to center percentages, dates, text, and normal numbers, but we do not apply it to anything in the вЂњAccountingвЂќ format.Дollar or Other Currency Signs: Only display these in the top row and bottom row of schedules. In addition to the points above about color-coding, we follow these guidelines with other types of formatting:Д¬entering: We use the вЂњAccountingвЂќ format and variations of the вЂњPercentageвЂќ format for most numbers, so centering is not an issue there. Other Principles of Financial Model Formatting Here are a few other examples of cell colors based on their categories and contents:

#CHANGE MAC SHORTCUTS FOR EXCEL DRIVERS#

We use a yellow background and grey border for вЂњinput cellsвЂќ that are assumptions or drivers in the model, while we use a white background with no borders for historical financial data: If you follow these standards for color coding, your financial models should look like the examples below.

#CHANGE MAC SHORTCUTS FOR EXCEL CODE#

вЊ + F: Find How to Color Code in Excel: What Financial Models Should Look Like In the Mac version of Excel, you can use these shortcuts instead:ДЇ5 or Ctrl + G, Special, Constants: Select Constants (Drop the X if you want to highlight text constants)ДЇ5 or Ctrl + G, Special, Formulas: Select Formulas (Drop the X to highlight textual formulas) To find links to other files, search for вЂњ.xlsвЂќ using Ctrl + F, and change the font color to red for each instance.

To find direct links to other spreadsheets in the file, you can press Ctrl + F and search for the вЂњ!вЂќ character, which always indicates links to other sheets. You can then press Ctrl + 1 to change their font color to blue, or you can access the font color commands from the вЂњHomeвЂќ tab in the ribbon menu. To find and select these cells, you can use the following PC/Windows shortcuts:ДЇ5, Alt + S, O, X: Select Constants (Drop the X if you want to highlight text constants)ДЇ5, Alt + S, F, X: Select Formulas (Drop the X to highlight textual formulas)ДЇor example, if you press F5, Alt + S, O, X, that will highlight all constants on the spreadsheet. We use the following colors for different types of cells:

#CHANGE MAC SHORTCUTS FOR EXCEL PC#

We have some general guidelines for model formatting, but these are not like the laws of physics (gravity, momentum, speed of light, etc.) вЂ“ theyвЂ™re вЂњrules of thumbвЂќ rather than вЂњlaws of nature.вЂќ How to Color Code in Excel: Key PC and Mac Shortcuts This sample lesson from our Excel/VBA course covers how to color code in Excel and some of the key principles for formatting financial models.ДЎ1:02: Demonstration of Walmart Model FixesДЎ9:59: Exercise вЂ“ Summary Spreadsheet Fixes

Change mac shortcuts for excel