Jump to content
One on One Extensive Advanced Excel Training ×
Business Intelligence & Analytics for Digital Transformation
  • Excel Tutorials

Tutorial 3 - Entering Formula & introduction to cell referencing

Saurabh Jain


In this tutorial we will learn to write basic formulas and introduction to cell referencing

  • Relative referencing which is the default referencing
  • Absolute referencing
  • Mixed Referencing



Important points

4 type of referencing can be  cycle through f4 key -  when we are in edit mode of cell  - (use f2 to enter into edit mode) -    A1 , $a$1 , A$1, $A1 

Shortcut Ctrl + ~  (tilde which is just above 1 in windows)

pl download file



1 Comment

Recommended Comments

Add a comment...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Login to participate

    • Sign up / Login
    • Join the club
    • and then you are on the board
  • Create New...