Excel Shortcuts

Excel Shortcuts

Learn Excel Essential Skills with Smart Method. Learn the Basics of Excel in 30 Minutes. When You
Improve with Excel 2020 You Feel like a Computer Artist.Important Excel shortcuts 2020

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 a backward-compatible workbook. When you do not
need the new functionality of higher Excel models, save the
files for backward compatibility of 2003*.xls format.
2. Using column and worksheet overview titles in a workbook
3. Consider dealing with several variables in complicated
calculations. Attempt to split them into limited controlled
outcomes from which you can create
4. Whenever you can use built-in functions instead of writing
your own formulas

Microsoft Excel is a powerful spreadsheet program used for recording,
manipulating, storing, and customizing numerical data according to your
preferences.
The ribbon is used for running specific Excel functions.
With the menu options, you can customize several items, e.g., ribbon,
formula, test, save, etc.