Complete Excel Tutorial

Excel is a very popular spreadsheet application developed by Microsoft. We have here a complete Excel tutorial for you including excel basics, excel shortcuts, excel formulas, excel vlookup, excel pivot table, excel charts and data analysis.

Excel Basics for Beginners

You can download MS Excel from Microsoft official website as trial or complete version.    Excel Download
To start using MS Excel search Excel and open Blank Workbook. You may also select New Microsoft Excel Worksheet after right-click.

Excel Interface

Excel workbook in divided into menu area called Data Ribbon, sheets with rows and column and status bar with view buttons and zoom control.

Image placeholder
Figure 1: Excel Workbook.
  • Data Ribbon is the entire collection of tabs and command groups. You can access data ribbon with Alt key.
  • Sheets are the data storage area with rows and columns. Maximum excel worksheet size can be 1,048,576 rows by 16,384 columns with upto 255 characters per column.
  • Status Bar is at the bottom of the excel sheet with zoom control and view controls.

Excel Shortcuts

  • Ctrl + N: Create a new workbook
  • Shift + F11: Insert a new worksheet
  • Ctrl + O: Open an existing workbook
  • Ctrl + W: Close a workbook
  • Ctrl + S: Save
  • F12: Save As

  • Alt: Go to data ribbon
  • Shift + Space: Select entire row
  • Ctrl + Space: Select entire column
  • Ctrl + F: Find
  • Ctrl + H: Replace

  • Ctrl + '-': Delete row or slected column
  • Ctrl + Shift + '+': Insert row or shift column
  • Ctrl + 9: Hide row
  • Ctrl + 0: Hide column

  • Ctrl + F1: Show or hide the ribbon
  • Ctrl + Tab: Switch between open workbooks
  • Arrow Keys: Move around the cells one by one
  • Ctrl + Arrow Keys: Move to the start or end of the data set

  • F7: Check spelling
  • F1: Open the Help pane
  • Alt + HOI: Format sheet by column width
  • Alt + F8:: Create, run, edit, or delete a macro
  • F4: Repeat the last command or action.
Share Post
Author: Ram Kumar

Ram has worked as a Software Developer for Amazon Development Center India. He has delivered training in over 50 Fortune 500 MNC's. He is regarded as one of the best Python & Django trainers in India.

Share your opinion: