01-Basic operations

  1. Entering Data in a Cell

  2. Inserting a row

  3. Moving from different cell

  4. Control + X = CUT

  5. Control + V = Paste

  6. Moving a cell 

02-Interface or Splash Screen


  • This is the first screen that you see when you open Excel

  • You could open the blank workbook and start your excel work from here

  • Recent Items - See the recent items that you have worked

  • Options and other settings

03-Workbook Interface

  • QAT - Quick Access Toolbar - Helps you to add frequently used tools

  • Ribbon - Introduced from Office 2007 onwards, All the tools under different menu are visible here

  • Workbook - Rows and Columns for entering data, Main area where we work on Excel

  • Formula bar - To see and enter the formulas

  • Status Bar - helps you to see the statical data of your work

04-Quick Access Toolbar

Used for adding frequently used tools

  • Add or remove favorite tools from ribbon

  • Customize QAT

  • You can use Keyboard short cuts for QAT tools - Alt + Assigned number



Most of the tools are listed in Ribbon


  • Main Menus are subdivided 

  • Each submenu is grouped in excel

  • Menus can be minimized by double clicking on Main menu item