For example, in Excel 2007 you can use conditional formatting to set the background color of a cell or use a colored bar (called a data bar) — the length corresponds to the cell’s value.

To help you with this, we've created a cheat sheet of some of the most useful Microsoft Excel power user keyboard shortcuts for those using the program on a Windows computer.

Select cells E3:L16. Go to Data, click the dropdown arrow next to What-if Analysis within the Forecast group, and choose Data Table. The Data Table window will open, asking for inputs into Row input ...