Saturday, November 23

Tag: excel tutorial

Goto Special In Excel

Goto Special In Excel

Home Menu, Menu Bar
DEFINITION:- The Go To Special Function In Excel Allows You To Quickly Select All Cells That Meet Certain Criteria, Such As Cells Containing: Comments, Constants, Formulas (Numbers, Text, Logical, Errors), Blank Cells, Objects Etc. Blank Will Select The Blank Cell Only.Current Region Will Select From The Active Cell To Last Row. makes Sure You Don't Have A Blank Cell Otherwise It Will Consider Above The Blank Row As Last Row.Current Array Will Select The Active Range Belongs To.Object Will Select Any Object Available In A Range. Ex:- ShapesLast Cell Will Select The Last Used Cell In A Worksheet. Even If You Delete The Data From Cell.Visible Cells Will Select Only Visible Cell If Any Filter Is Applied Or Even Any Row Or Columns Are Available.Conditional Formatting Will Select The Forma...
Find Last Day Of Month From Date

Find Last Day Of Month From Date

Date And Time, FORMULAS
Definition :- To Find The Last Day Of Month From A Given Date We Need To Apply A Function Called EOMONTH(). TO Find The Current Month Last Day Use EOMONT(Date Or Cell Reference, 0)TO Find The Next Month Last Day Use EOMONT(Date Or Cell Reference, 1)TO Find The Previous Month Last Day Use EOMONT(Date Or Cell Reference, -1)TEXT() Function Is Used To Get The Desired Output Like Only Date = "dd" , Month = "mm" Or " Date + Month = dd:mm" etc...
Count Networks Days Between Dates

Count Networks Days Between Dates

Date And Time, FORMULAS
Definition :- There Is A Function Called Networkdays In Excel That Help To Find Out The Number Of Working Days Between Two Given Date Range. It Required Parameter Is Start Date And End Date. For More Info Please Check In Image And Video Below. Validation :- Make Sure That You Must Have Input Valid Start Date & End Date In The Function. Other Wise It Will Give You #Num Error.Make Sure You Have Added Date In Proper Format According To Your PC Settings. Make Sure That You Have Proper Format Date When You Give A Direct Cell Reference As Shown In Image.In Image And Video # Example Are Provided Please Have A Look.
How To Use Find And Replace In Excel

How To Use Find And Replace In Excel

Home Menu, Menu Bar
FIND : Click CTRL + F One Find And Replace Dialog Box Will PopupSelect Database Or Range Or Directly Type The Text Or Number To Find Out OR Follow The Below Step For Another Method.Click The Home TabGo To The Editing Group Command Tab.Click On Find & Select ButtonA Dropdown Menu Will Appear. Click On Find. Steps :- In The Dialog Box Input The Text Or Number In “Find What” To Find The Data Within The Worksheet Or Database For And Then - Click “Find Next” MULTIPLE SEARCH : If You Want To Find Out How Many Times A Particular Word Or Phrase Has Been Used Or Found In Your Database Or Worksheet , Click “Find All” In The Dialog Box Will Populate The Match Row Where The Query Data Is Available. FIND & REPLACE : Select Database Or RangeClick The Home Tab...
How To Insert Shapes In Excel

How To Insert Shapes In Excel

Insert Menu, Menu Bar
DEFINITION:- You Can Add Shapes, Such As Boxes, Circles, Arrows Etc.. To Your Worksheet As Shown In Image Below. Steps:- On The Insert Tab, Click Shapes.Click The Shape You Want To Insert And Then Click Anywhere In The Workspace In The Worksheet And Then Drag The Shape To The Exact Place .There Are Lots Of Shapes Available In Excel And It Also Useful To Assign A Sub Procedure (Macro) By Creating A Beautify Button Type Object.
How To Insert Online Picture In Excel

How To Insert Online Picture In Excel

Insert Menu, Menu Bar
DEFINITION:- Online Picture Option Is Use To Download An Images Or Pictures Into Your Excel Worksheet From Other Sources. Steps:- Insert Tab > Click On The Online Pictures. (Its In The Illustrations Group.)In The Online Picture Dialog Box, Locate The Picture That You Want.Click On Insert • Bing Image Search - Bing (Default) To Use The Bing Search Engine To Locate Images On The Web Of A Particular Type That You Want To Add To Your Worksheet• One Drive Personal- One Drive To Locate Saved Images On Your Sky Drive To Add To Your Excel Worksheet Online Pictures Dialog Box Displays A Scrollable List Of Thumbnails Of The Photos Or Line Art That You Can Insert Into Your Current Worksheet.
Insert Cells Rows Sheet In Excel

Insert Cells Rows Sheet In Excel

Home Menu, Menu Bar
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...
Wrap Text In Excel

Wrap Text In Excel

Home Menu, Menu Bar
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.