Excel Tips & Tricks - Make your work lot easier

Microsoft excel have it's own world and it's not easy to know all the detail of this world, but tricks and trips help you to become a pro of this world.

If you just start learning Microsoft excel then you must start with basic first instead of go to the vast formula's. If you understand the logic's then you can easily make your own formula's as per your requirement.

In this post we will discuss about the Excel tips & tricks, which will make your work lot easier.

Excel Tips & Tricks

Excel Tip #1 Format Painter

Format printer is one of the most useful thing that you will need most of the time. Format painter just copy and paste the formatting from one section to another.

For example-: If you want to do a specific formatting (Font, Cell Color, Bold, Border, etc.) in the range D1: D5 you can copy that formatting to range E1: E5 with a click.

Excel Tip # 2 Count Character and Word

If you want to count the character of than just use the formula = len(Cell number)

example-: If you want to count the character of word excel which is written on cell A1 then just use the formula =len(A1) and you will get the count of the character i.e. 5

But, count the word is not an easy task as there is no  no specific function to count words. however, combination of formula will do that task

here is the formula to count the word -:=LEN(A1)-LEN(SUBSTITUTE(A1,” “,””))+1

how to use this formula

example-: If you want to count the word "My name is ABC" which is written on cell A1 then just use the formula =LEN(A1)-LEN(SUBSTITUTE(A1,” “,””))+1 and you will get the count of the word i.e. 4

Excel Tip # 3 Calculate Age

This formula will work like age calculator, you have to just enter your Date of Birth and excel will automatically calculate your age.

Age Calculation Formula -: =”Your age is “& DATEDIF(DOB,Today(),”y”) &” Year(s), “& DATEDIF(DOB,TODAY(),”ym”)& ” MONTH(s) & “& DATEDIF(DOB,TODAY(),”md”)& ” Day(s).”

Replace “DOB” with your actual date of birth.

Some Excel Shortkeys

• Select the required data and Alt + E + S [Paste Special shortcut] 
• To freeze panes: Alt + W + F + F 
• To Clear data: Alt + H + E + A 
• Shift between sheets: Ctrl + PgUp/Pg Dn 
• Border: Alt + H + B + A
• 6. Alt + N + N for line graph