Extract Quarter From Date In Excel
DEFINITION:- With The Help Of Month Function You Can Extracts The Quarter From A Given Date. The Result Will Be Between 1 To 4 Number.
EXAMPLE :- 1
EXAMPLE :- 2
Tag: excel help
Extract Month From Date
DEFINITION:- With The Help Of Month Function You Can Extracts The Month From A Given Date. The Result Will Be Between 1 To 12 Number.
EXAMPLE :- 1
EXAMPLE :- 2
How To Insert Shapes In Excel
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
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.
How To Insert Picture In Excel
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.
Insert Cells Rows Sheet In Excel
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...
Merge And Center In Excel
DEFINITION:- Merge And Center Command Is Used To Combine Multiple Cells Into A Single Cell.
Step 1- Select The Cells Which We Want To Merge Together Into One Cell.
Step 2- Click On Merge And Center And Check The Result In Below Image.
Orientation In Excel
Definition:- The Orientation Command Can Adjust The Text Vertical And Diagonally By Rotating The Cells Text Clockwise And Counter-Clockwise 90 Degrees.
Step 1- Select The Cell You Want To Format And Click On Orientation Button.
Step 2 – Select The Option In The Orientation Options As Per Your Requirement And Get The Result.
For Example:- Please Check The Image Below.
Conditional Formatting To Highlight Unique Values
How to use and apply the Conditional Formatting rules by using custom options please follow the step shown below and example in image and video.
NOTE:- Conditional Formatting Rules Always Work On The Base Of True & False Only.
Select The Range Of Your Data.
GO To Home Tab
Then Go To Conditional Formatting.
Then Click & Select New Rule.
One Dialog Box Will Get Pop-Up
Then Select Format Unique Or Duplicate In Second Last In Option List.
Once Its Done Select The Formatting Option According To Your Requirement As Shown In This Example.
Once It's Done Click Ok.
Then Use Filter With Color And You Wil Have All Unique Numbers.
That's It :)
Use Of Cells Range Object With Variable In Excel VBA
INTRODUCTION: Range Or Cells Is Used To Define The Start And End Point For A Particular Selection Of Cells. Examples "A1:A5" or "A1" Etc...
Open Excel File Click Alt + F11One Dialog Screen Will Get OpenClick Insert And Add ModuleCreate Sub ProcedureMake Sure The Procedure Name Start With String And Without Space.Write The Code In Between Sub And Sub End Click Run ButtonBy Clicking The Range Data Will Get Selected.Declare Variable - Dim RNG as Range / To Copy And Paste Data Use Dim Copyy= Range("A1:A6") / Dim Pastee As RangeNote We Cannot Use Excel By Default Keyword Like Copy - Paste - Cut As Variable.Range Is Object So We Will Need To Use Set Keyword To Apply Particular Range. For Select The Range Use Set RNG = Range("A1:A5").SelectTo Copy The Data Use Set Copyy= Range("A1:A5") To ...