Definition :- With Countif Function We Can Count The Date Which Are Greater Than Or Less Than In A Given Range. It Is Very Much Useful When We Need To Calculate The Date Within The Criteria. For More Details Please Check Image And Video Provided In Below Section.
Definition :- Excel Date Function Generate Date From The Given Year, Month, And Day In A Particular Columns. It Is Vey Much Useful When You Need To Work Dynamically Upon Changing Of Years Months And Days in Excel Worksheet.
NOTE: We should format it to date as the excel return the date in serial numbers. FORMAT: Select The Cell Or Range > Right Click > Go To Number Tab On Top Heading. Select Date Instead Of General.
EXAMPLE :- 1
EXAMPLE :- 2
DEFINITION:- To Increase The Year Or Month Or Days In Date Function You Can Use The Date Function And Within Date Function The Month & Day Function. For More Details Please Check Example Shown In The Image & Video Below.
Definition:- Using The Screenshot Option You Can Quickly And Easily Add A Screenshot To Your Worksheet To Enhance Readability Or Capture Information Without Leaving The Program That You Are Working In. This Feature Is Available In Excel Above Version Of 2007.
Steps:-
Insert Tab > Screenshot.Choose Window Thumbnail In Available Windows Or Use Screen Clipping.Format And Crop Your Screenshot In Excel.You Can Also Take The Quick Snap Shot Of Other Open Application And Quick Add To Your Worksheets.
DEFINITION:- With Insert Command You Can Add A New Column, Row, Cells And Sheet In The Workbook With Using Insert Options.
Step:- Click On The Insert In The Home Tab One Dialog Box Will Appear And In That Dialog Box It Will Display The Following Option As Shown in Images. Lets
Learn About All The Options Of Insert.
1. Insert cells
With Insert You Can Insert A Cell In The Worksheet.Step 1 – Click On Home Tab > Insert > Insert Cells.
2. Insert Row
With Insert You Can Insert A Row In The Worksheet.Step 1 – Click On Home Tab > Insert > Insert Row.
3. Insert Column
With Insert You Can Insert A Column In The Worksheet.Step 1 – Click On Home Tab > Insert > Insert Column
4. Insert Sheet&nb...
Definition Decrease Decimal:- Decrease Decimal Button Can Decrease The Amount Of Decimal Places .Unnecessary Decimal Places In A Cell Or Database Can Be Removed With The Decrease Decimal Option.
Step 1- Select The Data You Want To Format And Click On The Decrease Decimal Button.
Step 2:- Every Time You Click On Decrease Decimal Button It Decreased The Amount Of Decimal Places.
Definition Increase Decimal:- Increase Decimal Button Can Increase The Amount Of Decimal Places .
Step 1- Select The Data You Want To Format And Click On The Increase Decimal Button
Step 2- Every Time You Click On Increase Decimal Button, Increased The Amount Of Decimal Places.
DEFINITION:-Wrap Text Is A Great Feature That Been Used To Adjust The Overline Text Into The Cell. Wrap Text Adjust The Text With A Break Line In A Cell. Please Follow The Step Shown Below And Example In Images.
Step 1 – Select The Cell And Click On Wrap Text Button.
Step 2- After Click on Wrap Text button, Please Check The Result Bellow.
Definition Increase Indent:- With The Increase Indent Command, You Can Add The Space Between The Border And The Data In A Cell. Every Time You Click On The Increase Indent Button, Excel Add A Little Space Between The Border And The Data In The Cell.
Step 1- Select The Cell That Contains The Text. And Click On The Increase Indent Button.
Step 2 - Every Time You Ever Click On The Increase Indent Button, Excel Add A Little Space Between The Border And The Data In The Cell.
Definition Decrease Indent:- With The Decrease Indent Command, You Can Remove The Space Between The Border And The Data In A Cell. Every Time You Click On The Decrease Indent Button, Excel Removes A Little Space Between The Border And The Data In The Cell.
Step 1- Select The Cell...
