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

  1. 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
  2. Use description names for columns and worksheets in a workbook
  3. Avoid working with complex formulas with many variables. Try to break them down into small managed results that you can use to build on
  4. Use built-in functions whenever you can instead of writing your own formulas
0
Would love your thoughts, please comment.x
()
x