| Ctrl + P | used to open the print dialogue window |
| Ctrl + N | creates a new workbook |
| Ctrl + S | saves the current workbook |
| Ctrl + C | copy contents of current select |
| Ctrl + V | paste data from the clipboard |
| SHIFT + F3 | displays the function insert dialog window |
| SHIFT + F11 | Creates a new worksheet |
| F2 | Check formula and cell range covered |
Best Practices when working with Microsoft Excel
- Save workbooks with backward compatibility in mind. If you are not using the latest features in higher versions of Excel, you should save your files in 2003 *.xls format for backwards compatibility
- Use description names for columns and worksheets in a workbook
- Avoid working with complex formulas with many variables. Try to break them down into small managed results that you can use to build on
- Use built-in functions whenever you can instead of writing your own formulas