Jump to content
Business Intelligence & Analytics for Digital Transformation
  • Excel Tutorials

Tutorial 3 - Entering Formula & introduction to cell referencing


Saurabh Jain

2,867 views

 Share

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

 

 

 Share

1 Comment


Recommended Comments

Guest
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...