Excel Course online Archives

Dec112020 by excelhelp13No Comments

Goto Special In Excel

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

Dec112020 by excelhelp13No Comments

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

Dec112020 by excelhelp13No Comments

Go To Method In Excel

Home Menu, Menu Bar

Definition:- Go To Feature Is Use To Move The Cell Cursor To A New Cell In The Worksheet. You Can Also Use This Feature To Select A Range Of Cells. There Are Three Ways To Access “Go To” Press The F5Press Ctrl+GHome Tab – Find & Select – Choose “Go To…” To Move The Cell Cursor To A Particular Cell, Enter The Cell Address In The “Reference” Text Box And Click Ok. You Can Also Select A Range Of Cells By Taking These Steps: Select The First Cell Of The Range.Type The Cell Address Of The Last Cell In The Range In The “Reference” Text Box.Hold Down The Shift Key As You Click Ok Or Press Enter To Close The Go To Dialog Box.

Dec112020 by excelhelp13No Comments

Countif And Date Function In Excel

Date And Time, FORMULAS

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.

Dec112020 by excelhelp13No Comments

Date Function In Excel

Date And Time, FORMULAS

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

Dec112020 by excelhelp13No Comments

Get Month Name From Date In Excel

Date And Time, FORMULAS

Definition :- To Extract Or To Get The Month Name From A Particular Date We Need To Use In Built Text Function In Excel. To Know More About It Please Check The Image And Video Provided Below.

Dec102020 by excelhelp13No Comments

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

Dec102020 by excelhelp13No Comments

ScreenShot In Excel

Insert Menu, Menu Bar

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.

Dec102020 by excelhelp13No Comments

How To Insert Picture In Excel

Insert Menu, Menu Bar

Steps: Go To Insert Tab > Click On The Pictures. (Its In The Illustrations Group.)In The Insert Picture Dialog Box, Locate The Picture That You Want.Click On The Insert Button. Re-Size The Picture/Image.Place The Picture In The Cell.

Dec102020 by excelhelp13No Comments

SmartArt In Excel

Insert Menu, Menu Bar

Definition:- The Smart Art Graphics Option Is Used To Make The Information Look More Visually Good. Using These Tools From Excel, You Will Be Able To Create Great Smart Arts That Can Be Used For A Variety Of Purpose. Lets Learn How To Insert Smart Art Into A Worksheet And Customize It After Inserting It. Steps:- Insert Tab > In The Illustrations Group > Click Smart Art.In The Smart Art Graphic Dialog Box, Click The Type And Layout That You Want. 3. Enter Your Text By Doing One Of The Following: Click [Text] In The Text Pane, And Then Type Your Text.Copy Text From Another Location Or Program, Click [Text] In The Text Pane, And Then Paste Your Text. 4. Change The Colors Of An Entire Smart Art Graphic You Can Apply Color Variations That Are Derived Fr...