Basics of MS Excel

  • Microsoft Excel is a spreadsheet program that is used to store, sort and efficiently crunch numbers.

Basic of Excel:

Minimize the Ribbon:
  • Right click any where on the ribbon, and then click "Collapse the Ribbon" (Ctrl + F1).



Customize the Ribbon:
  • Right click any where on the ribbon, and then click "Customize the Ribbon".


  • Click "New Tab".
  • Add the command you like.
  • Click "OK".


Create a New Workbook:
  • Go to "File", click "New" and click "Blank Sheet".


Rename a Worksheet:
  • Right click on the sheet tab of "Sheet 1".
  • Choose "Rename".



Insert a Worksheet:
  • Right click on "+" symbol.



Delete a Worksheet:
  • Right click on sheet & click on "Delete".


Format Cells:
  • Enter the value into cell.
  • Right click on that cell and click "Format Cell" (Ctrl + 1).



Find & Select:
  • Select "Find & Select" and click "Find".



Print:
  • Go to "File" and click "Print".



Video:


My notes images: