Thursday, October 13, 2016

Happiness Quotes!

Received in mail from a friend and want to add it in my blog, Credit got to writer.

Happiness is a mental or emotional state of well-being characterized by positive or pleasant emotions ranging from contentment to intense joy.


  • “People are just as happy as they make up their minds to be.”
  • “I'm choosing happiness over suffering, I know I am. I'm making space for the unknown future to fill up my life with yet-to-come surprises.”
  • “Happiness is not the absence of problems, it's the ability to deal with them.”
  • We become more successful when we are happier and more positive.
  • The grand essentials to happiness in this life are something to do, something to love, and something to hope for.
  • Only one thing has to change for us to know happiness in our lives:  where we focus our attention.
  • We learn the inner secret of happiness when we learn to direct our inner drives,  our interest and our attention to something outside ourselves.
  • Now and then it's good to pause in our pursuit of happiness and just be happy.
  • Happiness belongs to the self-sufficient.
  • Happiness is the meaning and the purpose of life, the whole aim and end of human existence.
  • Tell me what you feel in your room when the full moon is shining upon you  and your lamp is dying out, and I will tell you how old you are, and I shall know if you are happy.
  • Happiness is living by inner purpose, not by outer pressures.
  • Every gift from a friend is a wish for your happiness.
  • It’s a helluva start, being able to recognize what makes you happy.
  • The secret of happiness is not in doing what one likes, but in liking what one does.
  • There are short-cuts to happiness, and dancing is one of them.
  • The art of being happy lies in the power of extracting happiness from common things.
  • While we are focusing on fear, worry, or hate, it is not possible for us to be experiencing happiness, enthusiasm or love.
  • Happiness is good health and a bad memory.
  • To be happy, drop the words 'if only' and substitute instead the words 'next time'.
  • It is only possible to live happily ever after on a day to day basis.
  • Growth itself has the germ of happiness.
  • Delight in mediation and solitude. Compose yourself, be happy. You are a seeker.
  • Happiness comes when your work and words are of benefit to yourself and others.
  • May everyone be happy and safe, and may their hearts be filled with joy.
  • To enjoy good health, to bring true happiness to one’s family, to bring peace to all, one must first discipline and control one’s own mind. If a man can control his mind  he can find the way to Enlightenment, and all wisdom and virtue will naturally come to him.

Friday, October 7, 2016

Create User Define Function and Macro as an Add-in


We work lot in excel and manage our work with functions and macros. I am here creating the process that will save your time and effort to re-create again and again the same functions or macros.

Here we are going to create Add-in that will automatically load when you open your excel, and the function will be available all the time. So let's start.

Step 1: Quickly create an empty add-in for excel


  1. Open excel and Save a blank workbook as a Excel Add-In (*.xlam) in your Add-In folder (%UserProfile%\AppData\Roaming\Microsoft\AddIns)
  2. I named it PersonalAddIn.xlam (Save it with any name you like)
  3. Click Office button.
  4. Click "Excel options" button.
  5. Click "Add-Ins" tab.
  6. Select "Excel Add-ins" from manage dropdown list and click GO
  7. Click "Browse" button
  8. Select the (.xlam) file that you just saved in step 1
  9. Click OK (Make sure you enable)



Step 2: Add custom functions and macros to your personal add-in

  1. Go to the Developer Tab on the ribbon.
  2. Click "View Code"
  3. Click on the project panel you see VBAProject (*.xlam)
  4. Click Insert Menu --> Module
  5. Copy and paste custom functions and macros to code window.


That's it... we are done.

Step 3: Use your user define function

  1. Go to the cell
  2. Click "Insert Function" in formula bar
  3. Select category "User Defined"
  4. Select your custom function
  5. Click OK


Step 4: Use your user define Macro

  1. Go to "Developer" tab
  2. Click "Macros" button
  3. Select/Type the macro name
  4. Click "Run"


Hope this will help you in you daily work, In case of any query you can write to me. Thanks for reading.

Wednesday, October 5, 2016

Windows Registry Tips

A small tweak which disables processing of autorun.inf to protect your PC from usb autorun viruses.

Windows Registry Tips

Remove Language Bar from Taskbar
[-HKEY_CLASSES_ROOT\CLSID\{540D8A8B-1C3F-4E32-8132-530F6A502090}]
@="Language bar"
"MenuTextPUI"="@%SystemRoot%\\System32\\msutb.dll,-325"


Allow Internet Explorer 7+ to open direct links to swf files (XP/Vista/7)
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Internet Explorer\Main\FeatureControl\FEATURE_BLOCK_LMZ_SCRIPT]
"iexplore.exe"=dword:00000000


Disable the Turn off computer button on the Welcome screen (XP/Vista/7)
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Policies\System]
"shutdownwithoutlogon"=dword:00000000

Disable USB Autorun to Save PC from USB Viruses (XP/Vista/7)
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\IniFileMapping\Autorun.inf]
@="@SYS:DoesNotExist"

Disable Writing to USB Drives (XP/Vista/7)
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\StorageDevicePolicies]
"WriteProtect"=dword:00000001

Enable Writing to USB Drives (XP/Vista/7)
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\StorageDevicePolicies]
"WriteProtect"=dword:00000000

Note: Modifying the registry can cause serious problems that may require you to reinstall your operating system. Use the information provided at your own risk.

Monday, September 19, 2016

What is a 404 error page mean?

In 1992 Tim Berners-Lee defined all the HTTP (Hypertext Transfer Protocol) codes based on the FTP (File Transfer Protocol) status codes. If you break it down, 

  • The first '4' indicates the error is a client error
  • Second the '0' indicates a general syntax error
  • Final '4' refers to the specific error code in the '4xx' group of error codes.

List of HTTP status Code

So, in brief you can say that, the 404 or Not Found error message is a Hypertext Transfer Protocol (HTTP) standard response code, in computer network communications, to indicate that the client was able to communicate with a given server, but the server could not find what was requested. The web site hosting server will typically generate a "404 Not Found" web page when a user attempts to follow a broken or dead link; hence the 404 error is one of the most recognizable errors encountered on the World Wide Web.

Friday, September 2, 2016

Thoughts

  • THE ONLY TIME SUCCESS COMES BEFORE WORK IS IN THE DICTIONARY
  • YOU MISS 100% OF THE SHOTS YOU DON'T TAKE
  • A MAN WITHOUT PLANS FOR HIS FUTURE WILL ALWAYS RETURNS TO HIS PAST
  • GREAT THINGS ALWAYS FALL JUST OUTSIDE YOUR COMFORT ZONE
  • SEEK RESPECT NOT ATTENTION, IT LASTS LONGER
  • GREAT THINGS DON'T EVER COME FROM COMFORT ZONES
  • DECIDE WHERE YOU WANT TO BE AND DON'T STOP UNTIL YOU GET THERE
  • ONLY A KING CAN ATTRACT A QUEEN AND ONLY A QUEEN CAN KEEP A KING FOCUSED
  • YOU CAN EITHER BE THE MAN OR YOU CAN WORK FOR THE MAN
  • I LOVE TO SHOP BUT I'M NOT BUYING YOUR BULLSHIT
  • NO ALARM CLOCK NEEDED, MY PASSION WAKES ME UP
  • THERE'S NO ELEVATOR TO SUCCESS, YOU HAVE TO TAKE THE STAIRS
  • GRIND WHILE THEY SLEEP LEARN WHILE THEY PARTY LIVE LIKE THEY DREAM
  • DON'T LIVE THE SAME YEAR 75 TIMES AND CALL IT A LIFE


Monday, August 8, 2016

5 Great Visual Studio Keyboard Shortcuts

Following are five of my favorite keyboard shortcuts in Microsoft Visual Studio.

1)Move Code Alt+Up/Down

This keyboard shortcut is new in Visual Studio 2013. If you put the cursor on a line of code and use the Alt+Up Arrow keys, the line of code you've selected moves up. If you use the Alt+Down Arrow keys, the line of code selected moves down.

2)Create Collapsible Region Ctrl+M+H/Ctrl+M+U

Chances are you've noticed the "+" and "-" symbols in the margins that let you collapse and expand your classes and functions. Did you know you can create your own collapsible regions? If you select a section of code and then use the key sequence Ctrl+M+H, you turn that region into a collapsible/expandable region. The key sequence Ctrl+M+U will remove the collapsible region. It doesn't delete the code, it just removes the icon that lets you expand and collapse.

3)Comment Code Block Ctrl+K+C/Ctrl+K+U

Whether it's because you're trying to track down a "but," or experimenting with code change, from time to time you'll want to comment and uncomment blocks of code. If you select a block of code and use the key sequence Ctrl+K+C, you'll comment out the section of code. Ctrl+K+U will uncomment the code.

4)Peek Definition Alt+F12

When you're going through your code and you want to examine the code in the method you're calling, many programmers will use the F12 key or the pop-up menu option Go To Definition. Go To Definition will navigate to the called method; however, many times you don't need to navigate to the code. Sometimes, you just want a quick look at the method. If you've installed Visual Studio 2013, there's a new keyboard shortcut -- Alt+F12 -- that will give you a preview of the method being called inline. You can use the Esc key to close the preview.

5)Navigate Forward/Backward Ctrl+–/Ctrl+Shift+–

When you have multiple files open at the same time, you might want a way to quickly move back and forth between two or three different locations in your code. If you've moved from one location to another you can use the keyboard sequence <Ctrl>+– to move to the previous location and then you can return using Ctrl+Shift+–.

Wednesday, June 29, 2016

Create XML using EXCEL

Many a time I have got question about how to create XML with excel, So I decided to add this into my blog. Hope this will help the readers.

step 1:
Create one schema file (A template that we will use to generate the xml).
Eg. (Save following lines in dataSchema.xml file)

















Step 2:
Open your excel file containing the data.
CountryID CountryName
1 India
2 Pak
3 Srilanka
4 China
5 Koria


Step 3:
Go to the Developer TAB, if it is not on the top then you need to enable it from (File > Option )

Step 4:
Click "Source" under XML.
It will open XML source panel, having two buttons at the bottom. Click "XML Maps...".

Step 5:
Click "Add" to the XML Maps window.

Step 6:
Select "dataSchema.xml" file that we created in Step 1
Click OK twice

Step 7:
In XML Source you can now see the TREE VIEW of your columns.

Step 8:
Drag and Drop each column to the first row of your data.

Step 9.
Click "Export" button in Developers > XML tab.

Step 10:
You can now save this file as XML and that's it. Done.




Tuesday, June 7, 2016

Which programing languages are useful for hacking

Important Programming languages for Hackers

Many of our readers often send us queries about which programming language they should learn. Some want to know quick fix hacking solutions. Almost all tech gadgets are built with coding. Every App, game or site that you use is programmed in a particular computer language. You need to know that hacking is not a click-of-a-button job but a serialized and compartmentalized vocation which uses different programming languages for different uses.

Most of the websites out there will give you list of most popular programming languages in the world. We at Techworm try to make it more easy for budding security researchers and hackers by breaking up the programming languages used by hackers.

Hacking is usually meant to break a code. There are three sections of hacking ― Web Hacking, Exploit Writing & Reverse Engineering and each of it requires different programming language

1. Web Hacking

Since most of the tech is build around world wide web, it is important to learn web hacking to be a good hacker. Let’s say you are interested in hacking web apps and/or websites then you will need to learn web coding. Websites use mostly HTML, PHP and JavaScript so it is important to learn these three.

HTML:

One of the easiest and widely used static markup web language present in each and every website you see in your browser. It’s recommended to learn HTML because it helps understanding web actions, response, and logic.

JavaScript:

JS is a client-side web programming mostly used in web sites for better user interface and quick response. If you are interested in a hacking career you need to learn JavaScript because it helps to understand client-side mechanism which is essential for finding client-side flaws.

PHP:

A dynamic server-side language which is responsible for managing web-apps and database. PHP is considered one of the most essential language because it controls everything on site and server, like a captain of a ship. It is advised to learn PHP nicely.

SQL:

SQL is responsible for storing and managing sensitive and confidential data such as user credentials, bank and personal information about the website visitors. Black hat hackers mostly target SQL database and steal information which is later sold on underground dark web forum. If you want to be good security researcher, you should learn SQL so that you can find flaws in a website and report them.

2. Exploit Writing

After web hacking, another most important feature of hacking is exploits. You can crack a particular software by writing a exploit. But to write a exploit you need to learn either Python or Ruby.

Python:

It is said that a security researcher or hacker should know Python because it the core language for creating exploits and tools. Security experts and even pro hackers suggest that master Python is the best way to learn hacking. Python offers wider flexibility and you can create exploits only if you are good in Python.

Ruby:

Ruby is a simple yet complicated object-oriented language. Ruby is very useful when it comes to exploit writing. It is used for meterpreter scripting by hackers. The most famous hacker tool, Metasploit framework is programmed in Ruby. Though Ruby may not be as versatile as Python, knowledge of Ruby is must in understanding exploits.

3. Reverse Engineering

Reverse engineering, the process of taking a software program’s binary code and recreating it so as to trace it back to the original source code. If you know reverse engineering you can find flaws and bugs easily. If you want to learn reverse engineering you need to know C, C++ and Java. The process of converting the code written in high level language into a low level language without changing the original program is known as reverse engineering.

Do you think any other programming language is essential for wannabe hackers and security researchers? if yes then please comment below.


Reference

Saturday, May 28, 2016

USE FULL ABBREVIATIONS


1)GOOGLE: global organization of oriented group language of earth.. 
2)YAHOO: yet another hierarchical officious oracle..
3)WINDOW: Wide interactive network development for office work solution
4)COMPUTER: Communication oriented machine purposely utilized technical educational research a scholarly article.
5)VIRUS: virtually infected reputed utilized software
6)UMTS: universal mobile telecommunication system
7)AMOLED: active matrix organic emitting diode. 
8)OLED: organic light emitting diode.
9)IMEI: international mobile equipment identity. 
10)ESN: electronic serial number. 
11)UPS: uninterruptiblepower supply. 
12)HDMI: high definition multimedia interface. 
13)VPN: virtual private network. 
14)APN: access point name. 
15)SIM: subscriber identity module. 
16)LED: light emitting diode.
17)DLNA: digital line network access. 
18)RAM: random access memory. 
19)ROM: read only memory. 
20)VGA: video graphic array. 
21)QVGA: quarter video graphic array. 
22)WVGA: wide video graphic array. 
23)WXGA: wide extended graphic array. 
24)USB: universal service bus. 
25)WLAN: wireless local area network. 
26)PPI: pixel per inch. 
27)LCD: liquid crystal display. 
28)HSDPA: high speed downlink packet access. 
29)HSUPA: high speed upload packet access. 
30)HSPA: high speed packet access. 
31)GPRS: general packet radio service 
32)EDGE: enhancement data rate for global evolution. 
33)NFC: near field communication. 
34)OTG: on-the-go 
35)S-LCD: super clear liquid display.
36)O.S: operating system. 
37)SNS: social networking sites 
38)H.S: HOTSPOT 
39)P.O.I: point of interest 
40)GPS: global position system 
41)DVD: digital video disc 
42)DTP: desk top publishing. 
43)DNSE: digital natural sound engine. 
44)OVI: Ohio video intranet. 
45)CDMA: code division multiple access. 
46)WCDMA: wide-band code division multiple access. 
47)GSM: global system for mobile communication.
48)WI-FI: wireless fidelity 
49)DIVX: digital internet video access. 
50)APK: authenticated public key. 
51)J2ME: java 2 micro edition 
52)SIS: symbian installation source. 
53)DELL: digital electronic link library. 
54)ACER: acquisition collaboration experimentation reflection. 
55)RSS: really simple syndication 
56)TFT: thin film transistor 
57)AMR: adaptive multi rate 
58)MPEG: moving pictures experts group 
59)IVRS: interactive voice response system.
60)HP: Hewlett-Packard

Thursday, May 19, 2016

Retrieving data from SQL Server using RecordSet object in VBScript

Option Explicit

Dim Conn ' Connection Variable
Dim rs ' Recordset Variable
Dim sqlQuery
Dim serverName
Dim field


'Declare the SQL statement that will query the database
sqlQuery = "SELECT UserName FROM dbo.UserList WHERE ID = '9'"


'Create an instance of the ADO connection and recordset objects

Set Conn = CreateObject("ADODB.Connection")
Set rs = CreateObject("ADODB.Recordset")


'Open the connection to the database
Conn.Open "DSN=getUser;UID=user1;PWD=password;Database=dbUserList"


'Open the recordset object executing the SQL statement and return records 
rs.Open sqlQuery,Conn


'Check if any record exist in table 
If rs.EOF Then 
wscript.echo "No Record Found"
wscript.quite
Else 

Do While NOT rs.Eof   
field = rs("UserName")
if field <> "" then
  wscript.echo field
end if
rs.MoveNext     
Loop

End If


'Close Connection and Recordset
rs.Close
Set rs=nothing
Conn.Close
Set Conn=nothing

VBScript Prompt a User for Input


It was been ask by one of my friend that how to get input from user in VBScript. I though by adding this to blog, that will help other.

getStringValue = InputBox("Please enter some value :","Window Title")

You can also use this in condition also in this.

If getStringValue="" then

 Wscript.Quite

else

  Wscript.Echo getStringValue

End if

Wednesday, May 18, 2016

VBScript to update Access Database


Save following line to .VBS file


Const adOpenStatic = 3
Const adLockOptimistic = 3

Set objConnection = CreateObject("ADODB.Connection")
Set objRecordSet = CreateObject("ADODB.Recordset")

objConnection.Open _
    "Provider = Microsoft.Jet.OLEDB.4.0;; Data Source = C:\Temp\Local.mdb"

objRecordSet.Open "Update Set = ", _
        objConnection, adOpenStatic, adLockOptimistic

OR

objRecordSet.Open "Insert into Values(,,...)", _
        objConnection, adOpenStatic, adLockOptimistic




Execute script Via Command Line

  1. Hold your windows key and press “R” to open the command prompt
  2. type: “%windir%\SysWoW64\wscript.exe
  3. Press OK

Thursday, May 12, 2016

Twisty or Collapse or expand parts of a document

When you’re working on a long, complicated document, you can collapse everything except the part you want to focus on. Or, if you think you might be overloading your readers with too much information, you can display summaries and leave it to your readers to open the summary and read the details if they want.

The ability to collapse and expand content in your document is based on its outline level. You can quickly add an outline level and make part of your document collapsible by adding a heading using Word's built-in styles.


After applying the heading style, you’ll see a small triangle when you move your cursor over the heading. Click the triangle to collapse the body text and subheadings below it.


TIP:  If you’re working on a touch device, tap to place your cursor in the heading to see the triangle.
Click the triangle again to expand that part of the document.
To collapse or expand all the headings in your document, right-click the heading and click Expand/Collapse > Expand All Headings or Collapse All Headings.


When you close and reopen a document, the headings will be expanded by default. If you want the document to open with the headings collapsed, follow these steps.

1) Place your cursor in the heading.
2) On the Home tab, click the arrow in the Paragraph group.


3) In the Paragraph dialog box, click the checkbox next to Collapsed by default.


4) Click OK.

Contents are reference from Site

Tuesday, May 3, 2016

The Best Excel Shortcuts You Need to Know

Almost everyone uses Excel in some form or fashion in the modern workforce, but many of us may be wasting a little too much time trying to format those pesky spreadsheets. In order to help you work a little bit faster, or maybe more efficiently. Find below best Excel shortcuts that you need to know!

  • F2 : Edit selected cell
  • F9 : Calculates all worksheets
  • F11 : New chart
  • ALT : Access the ribbon for formulas
  • ALT + = : Automatically SUM() selected
  • ALT + Enter : Start a new line in the same cell
  • ALT + o-c-a : Auto size columns
  • PG + UP/PG+DOWN : Go to next/previous worksheet
  • CTRL + ` : Display Formulas
  • CTRL + Backspace : Show active cell
  • CTRL + Shift + # : Change Date format with day, month and year.
  • CTRL + K : To insert Hyperlink.
  • CTRL+ Shift + $ : Applies the currency format to the selected cells.
  • CTRL + Shift + & : Applies border to cells
  • CTRL + B : Bold
  • CTRL + I : Italics
  • CTRL + U : Underline
  • CTRL + Shift + ~ : General style number
  • CTRL + Shift + $ : Currency style number
  • CTRL + Shift + % : Percentage style Number
  • CTRL + Shift + ^  : Scientific notation style
  • CTRL + Shift + # :  Date style
  • CTRL + Shift + @ : Time Style
  • CTRL + Shift +! : Number Style
  • CTRL + F12 : Open
  • CTRL + Spacebar : Select the entire column
  • CTRL + [ : Select all cells directly referenced by formulas in the selection
  • CTRL + A : Select All
  • CTRL + Shift + J : List Constants
  • CTRL + D : Copy equation down
  • CTRL + F : Find
  • CTRL + H : Find&Replace
  • CTRL + Right arrow : Move right
  • CTRL + Left arrow : Move left
  • CTRL + Up arrow : Move up
  • CTRL + Down arrow : Move down
  • CTRL + Enter : Same data in multiple cells
  • Shift + Spacebar : Select the entire row
  • Shift + F3 : Find Previous

Monday, May 2, 2016

Visual Studio Keyboard Shortcuts


To format document in visual studio
Ctrl + K, D

To comment selected code
Ctrl + K, C

To uncomment selected code
Ctrl + K, U

Show intellisense
Ctrl + Space

Covert selected text to UPPERCASE
Ctrl + Shift + U

Covert selected text to LOWERCASE
Ctrl + U

Toggle Full Screen
Alt + Shift + Enter

Build Project
Shift + F6

Build Solution
Ctrl + Shift + B OR F6

Attach the debugger to a process
Ctrl + Alt + P

Expand or Collapse current element
Ctrl + M, M

Collapse all
Ctrl + M, O

Toggle all Outlining
Ctrl + M, L 

Thursday, April 28, 2016

Get FileName list form a Folder in EXCEL

The code below retrieves the file in this directory and creates a list of their names and paths:

Sub GetFileNameList()

Dim objFSO As Object
Dim objFolder As Object
Dim objFile As Object
Dim i As Integer

'Create an instance of the FileSystemObject
Set objFSO = CreateObject("Scripting.FileSystemObject")

'Get the folder object
Set objFolder = objFSO.GetFolder("C:\TMP")

i = 1
'loops through each file in the directory and prints their names and path

For Each objFile In objFolder.Files

    'print file name
    Cells(i + 1, 1) = objFile.Name

    'print file path
    Cells(i + 1, 2) = objFile.path
    i = i + 1

Next objFile

End Sub

Friday, April 8, 2016

Get alternating row colors, using conditional formatting in Excel

I got a questing about how to set alternative color in excel sheet when not using table.

Steps:
1) Select the rows you want alternate color
2) go to Conditional Formatting and create New Rule
3) Select "Use a Formula to determine which cells to format" from rule type
4) Put "=(MOD(ROW(), 2)=0)" without quotes in the formula values
5) Click Format button, and apply format required and that's all..

Wednesday, April 6, 2016

How to Test a Database Connection String using NotePad

Create and Configure a Universal Data Link (.udl) File with Notepad.

I just came across a way to test a data provider’s connection string (like a SQL Server database) with the help of a plain text file using Notepad.  To investigate and test out if your connection string works, you’re going to want to create a UDL file. 

To do this, follow these steps:
1.Open up Notepad and create an empty text file, then click File -> click Save -> and save it with the File name: TestConnection.udl to your desktop.
2.Go to your desktop and double-click on the TestConnection.udl file you just created and the Data Link Properties box will popup.
3.Select the Provider tab and Find the provider that you want to connect with and click Next >>
4.Now from the Connection tab, select or enter your source/ server name  then enter information to log on to server -> and select the database on the server. 
5.Click Test Connection and click OK to save the file.

Note: If errors occur during testing of your connection string, you will get a popup box with the error message.

Once, you've successfully tested your connection string, now go and compare the details of your TestConnection.udl with your (website) project connection string to see if they are similar.



Wednesday, March 16, 2016

'Positives in Negatives'


 
A young woman was sitting at her dining table, worried about taxes to be paid, house-work to be done and to top it all, her extended family was coming over for festival lunch the next day. She was not feeling very thankful at that time. 

As she turned her gaze sideways, she noticed her young daughter scribbling furiously into her notebook. 

“My teacher asked us to write a paragraph on “Negative Thanks giving” for homework today.” 
said the daughter.

“She asked us to write down things that we are thankful for, things that make us feel not so good in the beginning, but turn out to be good after all.” 

With curiosity, the mother peeked into the book. This is what her daughter wrote: 

“I’m thankful for Final Exams, because that means school is almost over. 

I’m thankful for bad-tasting medicine, because it helps me feel better. 

I’m thankful for waking up to alarm clocks, because it means I’m still alive.” 

It then dawned on the mother, that she had a lot of things to be thankful for! 

She thought again… 

She had to pay taxes but that meant she was fortunate to be employed. 

She had house-work to do but that meant she had a shelter to live in. 

She had to cook for her many family members for lunch but that meant she had a family with whom she could celebrate. 

Moral:
We generally complain about the negative things in life but we fail to look at the positive side of it. 

What is the positive in your negatives? Look at the better part of life today and make ur everyday a great day. 

Be happy and blessed always.


By :- Anonymous

Thursday, March 10, 2016

Count the number of spaces of text string in Excel


Simple to calculate the number of spaces of text string in EXCEL with following formula:

=LEN(A1) - LEN(Substiture(A1," ",""))

Above formula will count all the spaces in the text.


Count the number of leading spaces of text string with formula

=FIND(LEFT(TRIM(A2),1),A2)-1

Wednesday, March 2, 2016

10 Steps to Dealing With The Negative People in Your Life

Following contents were received in one of my email from friends, all credits goes to the person who wrote wonderful thing. Read the steps and move away negativity. 


We sensitive folks feel things deeply. Especially the negative energy of other people around us. When it’s good, that’s great no problem! But when it is confused, disjointed, cruel, or anything dark, heavy or negative in any way, this has the potential to tip us in a direction we don’t want to go. We have the weight of the world on our shoulders.


"If you don't like something, change it. If you can't change it, change the way you think about it."
You may be in daily interaction with negative people, be they friends, family members, a romantic partner or colleague. You love them, you care about them, you can't just cut them out of your life, but they are negative and their negativity is eating away at you. What can you do?

The best way of dealing with life's challenges is to take a good look at ourselves and take responsibility for what we think, feel and do.

Never give your power away by blaming others for what you have or don't have, what you feel or don't feel. Once you do so, you'll become a victim of circumstance, and instead of using your time and energy to beat life's challenges, you'll sink to a dark and miserable place.

Here are 10 smart, positive and effective ways of dealing with the negativity of the people close to you:

1. Give up the need to complain

Make sure you are taking responsibility for your feelings and mood. Don't go complaining that other people's negativity is affecting you, because it will only create more negativity. Take responsibility for your thoughts and feelings and see what you can do to make yourself feel better and change the existing situation.
"Whoever has limited knowledge of human nature and seeks happiness by changing everything but his own attitude, will waste his life in futile efforts."
Samuel Johnson.

2. Similarity Attracts

Good brings about good, bad brings about bad, and if we want to or not, we pull into our lives events, situations and people that reflect our internal state. Ask yourself: "How am I feeling? Am I happy, excited, thankful and calm? Or am I anxious, frustrated and judgmental?"
You may find that you radiate misery to the environment and that part of the negative energy surrounding you is in fact a reflection of yourself.

3. Don't believe everything you think

This is definitely one of the hardest things to learn. Look closely at the negative people in your life. What is it about them that gets you going? What affects you so much? Is what they are doing really that bad or is your brain playing games with you?
Remember, the brain is configured to look for trouble, and it focuses on other's negative qualities. It'll be very hard to get it to see the positive side of things, but it doesn't mean it's not there.

4. Focus

Ask yourself: "Am I ready to find the good in these people? Am I able to see their good qualities?" Let the answers come naturally, make sure you are being honest with yourself.
If you feel like you're insistent and won't change the way you are looking at people and situations, don't give yoursef a hard time. This takes time and patience, and when you are ready, you'll make this step. Remember, we all have good in us.
"It's so hard when I NEED to do it and so easy when I WANT to do it." -Annie Gottlier.

5. Don't make their problems YOUR problems

For their sake and yours, make sure you are not adopting their problems and becoming negative about them yourself. If you want to cure negativity, sliding down right along with the negative person won't help, it will just make it worse by validating their thought and behavioral patterns. Rather, focus on solutions, not problems. Offer that and nothing else.

6. Taking ownership

Instead of being a victim and judge, blame and pass criticism, you need to take full responsibility for your thoughts and feelings, and take a different approach.
"Everything that annoys us in others can lead us to a better understanding of ourselves."
Carl Jung.
Don't waste your time obsessing and thinking: "They are ruining my energy, making me miserable, their negative energy is infecting my own..." Instead, say to yourselves: "How can I use this for my advantage? Is there something I'm doing wrong? How can I improve the situation and increase my positive energy to be stronger than their negative energy? What do I learn from all of this?"

7. Come with your own positive energy

Focusing on negative energy cannot create positive energy, and the other way around is also true. Focus on making yourself happy enough that you have great positive energy, and you will see the negativity cringing away from it.
Remember, energy is contagious!
How to put up positive energy? Focus on the things you like about the negative people, focus on things you love about yourselves, life and the world around you. Think of loved ones, of things that make you happy. That way, you will increase the positive energy exponentially.
If you incur negative energy by thinking about bad things, the opposite is also true, and you'll be able to hopefully 'wake up' your fellow workers. You can't focus on them both at the same time, so choose - happiness or misery.

8. Be part of the change you'd like to see

The world is no more than a reflection of who we are, deep inside. Try to go for a feeling of well-being, to live a positive life, a merry life, that has love, trust, and the pursuit of happiness. We cannot change others, but only ourselves. This is the only way to change the world.
Think of it this way: When you are happy, the world seems happy, and the sky is open and blue. When you are sad, the world seems sad as well, and the sky is grey and uncaring, leaving you alone to deal with your pain.
Flow with life events, don't resist them, live in harmony and be the change you wish to see in the world.
"Never underestimate your power to change yourself. Never overestimate your power to change others." - Wayne W. Dyer.

9. Awareness and acceptance

Work on understanding life's inevitable duality - accept the negative with the good. Don't harp on people's negativity, don't judge or fight them. Let them be, look and accept. Remember, your world is no more real than a reflection of who you are, deep inside. Don't try to bring everyone into your own world, accept theirs as no less real than yours, and their point of view as no less valid.
The hardest part of acceptance is accepting that, sometimes, some people cannot be changed. Their negativity is something they will defend to the last drop. Not because it gives them pleasure, but because they think it is a natural part of themselves. Even though it's never too late to try and change that point of view, some never will. It is up to you to either accept their negativity and react accordingly, or take your distance from them. This is especially hard when it is someone we love.
"Knowing your own darkness is the best method for dealing with the darkness of others."
Carl Jung.

10. Move forward

Dealing with negativity and trying your best to disspell it can be exhusting, and at some point you have to move on with your life in a positive way. Find a path that allows you to go on with your life without the negativity of others, but also without the regret that leaving a loved one or friend behind may cause you.

Make your feelings known to them, make them understand they are hard to be around, and slowly decrease your contact. If they want you to stay in their lives, they will be forced to at least pretend to be less negative, and pretending is the first step to actually becoming less negative. The more we act a certain way, the more we believe in it.

Tuesday, March 1, 2016

Turn Off Autorun or Autoplay on Windows system



Mostly Virus easily spreading using removable media such as CD, USB, etc. Some people maybe still didn't know how to turn off autorun or autoplay in Windows.

Step-by-Step about How to Turn Off Autorun/Autoplay on Windows:

1. Open Run Tasks (Click here to view the shortcut to launch Run)

2. Type : gpedit.msc (case insensitive)

3. Click Computer Configuration –> Administrative Templates –> Windows Components –> Autoplay Policies –> Double click the Turn off Autoplay at the right side window. 

4. There are 3 configurations available : 
Not Configured
Enabled
Disabled

5. Choose Enabled then click apply.

Monday, January 25, 2016

10 Signs Someone Is Smarter Than You



Here are the signs of smart people:


1. They don't talk as much as you do, because they know they got smart by listening.

2. They know lots of things other than what they're specialized in. Theirs is the gift of a broad mind, constantly fed with the stimulant of being interested in what everyone else is doing.

3. They juggle home, work and personal interests with dexterity and never fall back on the tired old refrain about "work life balance". And when they're juggling, they somehow manage to seem 100% engaged with what they're doing, on all fronts simultaneously, even though you know they're taking appropriate steps behind the scenes to make sure their lives are perfectly, serenely balanced.

4. They probably do social media. Not always, but probably. It is not only another chance to listen, but one they use to ensure they can feed their brains with things they otherwise won't have come across.

5. Even when things go very badly wrong, they'll be smiling. Smart people never get ruffled because their smart brains present them with alternatives faster than the bad stuff can happen.

6. They know they are usually the smartest person in the room, but they don't spend their time dwelling on that. Instead, they take it as a personal challenge to see if they can make everyone else the smartest person in the room too.

7. If they are managers, they will make every effort to get people smarter, more connected and more popular than them in their teams. They're not threatened because they know that smartness is synergistic. They also make sure that their smart people get to look smarter than them for the same reason.

8. They have hidden skills that never get rolled out until they're needed. They don't have any need to show their full capabilities for reasons of proving they're better than others.

9. They may or may not have expensive educations. You'd never know just by being with them unless you had their CV in front of you.

10. They never, ever, under any circumstances, make you look stupid, even though it would be easy to do so. They've learned through bitter experience that the only thing that happens when you make someone look bad is you look bad yourself.

Now you should know who the smart people are. If you want to be the smart one, let me give you this extra advice from Steve Jobs "Stay hungry. Stay foolish."

Monday, January 18, 2016

How To Repair A Corrupted SD Card or USB Flash Drive

How To Repair A Corrupted SD Card or USB Flash Drive


Steps are as follow:
1) Go to command prompt using "RUN" window
2) Type "DiskPart" on the prompt (This will change command prompt to "DISKPART>"
3) list disk (This will show all storage disk list
4) Make your USD drive selected using "Select Disk 1" command (Note: disk 0 is your primary hard drive)
5) Type "Clean" to cleaning the disk
6) After cleaning you need to create a primary partition, Type "Create Partition Primary"
7) Activate newly created partition, Type "Active"
8) Type "Select Partition 1" to get this partition format
9) Type "Format fs=fat32".

That's it, you are done now. Once disk is fully formatted you are ready to use your USB/SD card.

Wednesday, January 13, 2016

17 Body Language Mistakes We All Make


In several famous studies it was found that 7% of communication is verbal, 38% is vocal (sounds) and 55% is NON-VERBAL.

That means that most of the signals we send to those we talk to involve no words, no sound, just our body language. Studies show that most of us commit these little errors every day without being aware of them. So if you want to better protect your thoughts and avoid offense, check out these 17 common mistakes we all make with our daily body language.

1. Smiling only with our mouths

I love smiling, and it's great to see one, no doubt. But when the smile isn't naturally occurring, when you only smile with your mouth but don't let the rest of the face participate - you create a silly impression at best and appear phony at worst. If you feel the need to smile, remember to smile with your entire face and truly mean it.

2. Looking up or around you

When your eyes start to wander in the middle of a conversation, especially going up, this sends the message that you are not listening, not interested or not focused. When people are talking to you, look right at them.

3. Fiddling with objects around you.

When we're tense we tend to fiddle with stuff in our hands - roll, tear or play with an object (this includes personal grooming or removing cat hair from your shirt). You may be surprised to hear this, but body language experts agree that this doesn't show nerves, it looks you are not agreeing with what the other person is saying.

4. Crossing your arms and legs

Crossing your arms and/or legs is a comfortable position, and when we're tense we often feel a strong urge to do so because it makes us feel more protected. However, the other side of this coin is that the person in front of you feels as if you are closing yourselves off to the conversation and to them emotionally.

5. Fidgeting

Restless legs, changing postures every minute, drumming with your fingers or moving your head from side to side - may just indicate you find your chair uncomfortable or perhaps you need to go to the bathroom. But for the person in front of you, the feeling is of nervous ticks that may distract them from what they were saying, or make them feel you aren't really listening.

6. Not looking the other person in the eyes

This is one of the staples of inter-personal communication: Avoiding eye contact, say body language experts, is the first step to bad communication. If you meet someone and they almost never look you in the eyes, you probably felt quite uncomfortable during the conversation. That said, eyeballing someone isn't good either, as it can seem aggressive. Keep eye contact for a few seconds at a time, then look away, and return to eye contact when the other person is talking to you.

7. Keeping our hands on our hips

Many of us place our hands on the hips, with elbows facing outwards, so in an subconscious way we feel the need to 'enlarge' ourselves and leave more room for our personal space. This is a defensive position but one that can be interpeted as threatening to the other person. So unless you are going for intimidation, leave the hands relaxed and placed on the thighs or the sides of the body.

8. Keeping our head low

Lowering your head sends a message of shyness, surrender and even shame. Without even noticing, it places you on a lower status than the person you are talking to. So remember to lift your head and look at the other person directly.

9. Nodding too much

When we listen to another and want to show him we agree without interrupting him, we nod. So far so good. The problem is that too much nodding can show you as submissive, as if you are trying to please the other person too much. If you feel you're nodding too much, try to catch yourselves doing it and deliberately switch to some verbal cues "yes" or "I agree".

10. Doodling on a piece of paper

Sometimes, during a meeting, you need to write some things down, and that's fine. But while you're not writing something important, don't doodle. Keep that for another time. Why? Because that lack of focus is transmitted to the other person, telling them they are wasting their time with you, and of course - it prevents eye contact.

11. Rolling our eyes

Sure, this gesture can be comical around friends and family, but we might be so used to it we do it in an official meeting, which can cause very bad results. Doing this amongst strangers shows not only that you do not agree with what they are saying, but may also convey a lack of respect. It summons the image of a sullen teenager who is just waiting to be left alone. In short - it is rude, and you'd be best avoiding it.

 12. 'Melting' into our chair

The antidote to a stressful meeting is not lounging or melting into your chair or sofa (lowered shoulders, putting your elbows on the table, leaning back with spread legs etc.) This kind of posture may transmit a lack of caring to the other side, and that you're not really interested in having a conversation at the moment. Sit straight but not rigid, and if you are standing - stand firm.

13. Playing with our hair

Playing with your hair is very common in flirtation, so its perfect for a romantic date. However, if we're talking about a business meeting or any other stressful event, keep your hands away from your hair. Playing with your hair may be interpeted as being nervous, rolling or even chewing the hair may be signs of a lack of maturity.

14. Pinching our nose while closing our eyes

This movement is what experts see as if you saying to the other person that you are not happy with them and have a negative view of their actions. If you have a headache or sinus pain, you may be doing it without noticing. But try to explain why you are doing it to avoid giving the wrong impression.

15. Touching our nose too often

If you feel an itch, by all means, scratch that nose. But often touching the nose may, subconsciously, send the message you are either lying or hiding something. There's even a medical explanation for it: When our blood pressure rises ( when we lie), our nose tissue and cells create histamine, which causes an itch. Your partner may not know this, but subconsciously they can feel the connection between nose touching and lying.

16. Standing with our body pointing at the exit

This is true in any culture. If you want to show your conversation partner respect and interest, you must face them. If you are turning, even with only half your body, towards the door or any other exit in the room, the message is sent that you cannot wait to finish this conversation so you can leave and do other things. If you notice this, correct yourselves and face your partner once again.

17. Cross our hands behind our back

In movies and television shows, we see this kind of stance as connected to learned types or grizzled army men. In reality, standing with your hands behind your back transmits anger, disagreement with what is being said and even a hint of threat or violence. So please, leave this pose to the actors.

Saturday, January 9, 2016

Photoshop Effect and it's Shortcuts

Photoshop EffectMac ShortcutWindows Shortcut
New layer via cutCmd+Shift+JCtrl+Shift+J
Increase or decrease size of selected text by 10ptsCmd+Option+Shift->/<Ctrl+Alt+Shift+>/<
SelectingCmd+Shift+DCtrl+Shift+D
Hue or SaturationCmd+UCtrl+U
Select all layersCmd+Opt+ACtrl+Alt+A
Flatten layersCmd+Alt+Shift+ECtrl+Alt+Shift+E
Free TransformCmd+TCmd+T
FillShift+F5Shift+F5
Content Aware MoveShift+JShift+J
Black and white dialog boxShift+Cmd+Alt+BShift+Ctrl+Alt+B
Zoom inCmd+plus(+)Ctrl+plus(+)
Select bottom layerOpt+Comma(,)Alt+Comma(,)
Blending modesShift+plus(+) or minus(-)Shift+plus(+) or minus(-)
RenderOpt+Shift+Cmd+ROpt+Shift+Ctrl+R
Deselect all but the intersected areaShift+Opt+dragShift+Alt+drag
Increase or decrease kerning or trackingOption+Right/Left ArrowAlt+Right/Left Arrow
Invert selectionCmd+Shift+ICtrl+Shift+I
New layer via copyCmd+JCtrl+J
Select a colour from an imageOpt+Brush ToolAlt+Brush Tool
First or last brush</></>
Show or Hide selection on selected typeCtrl+HCtrl+H
Copy multiple layersShift+Cmd+CShift+Ctrl+C
Close & go to bridgeCmd+Shift+WCtrl+Shift+W
Change image sizeCmd+Opt+iCtrl+Alt+i
Deselect from the selection areaOpt+dragAlt+drag
Toggle airbrush optionShift+Alt+PShift+Alt+P
Deselect the entire imageCmd+DCtrl+D
Create clipping maskCmd+Opt+GCtrl+Alt+G
Auto ToneShift+Cmd+LShift+Ctrl+L
Saving and closingCmd+Shift+Opt+SCtrl+Shift+Alt+S
Show or Hide PolygonsOpt+Cmd+XOpt+Ctrl+X
Color BalanceCmd+BCtrl+B
Reveal AllOpt+Shift+Cmd+XOpt+Shift+Ctrl+X
Move a selectionSpacebar+Marquee ToolSpacebar+Marquee Tool
Zoom outCmd+Minus(-)Ctrl+Minus(-)
ViewingCmd+Opt+0Ctrl+Alt+0
Align text left or center or rightCmd-Shift-L/C/RCtrl+Shift+L/C/R
Previous or next brush,/.,/.
Lens correctionShift+Cmd+RShift+Ctrl+R
Select individual channelsCmd+3(red),4(green),5(blue)Ctrl+3(red),4(green),5(blue)
Send layer backCmd+[Ctrl+[
Bring layer to top of stackCmd+Shift+]Ctrl+Shift+]
Text in PhotoshopCmd+Shift+>/<Ctrl+Shift+>/<
Increase or decrease brush size]/[]/[
Send layer to bottom of stackCmd+Shift+[Ctrl+Shift+[
DesaturateCmd+Shift+UCtrl+Shift+U
Bring layer forwardCmd+]Ctrl+]
Fit on screenCmd+0Ctrl+0
Camera Raw FilterShift+Cmd+AShift+Ctrl+A
CurvesCmd+MCtrl+M
Merge visible LayersCmd+Shift+ECtrl+Shift+E
Content aware scaleCmd+Shift+Opt+CCtrl+Shift+Alt+C
Increase or decrease brush hardness}/{}/{
Select top layerOpt+Period(.)Alt+Period(.)
Find the sizing handlesCmd+T, Cmd+0Ctrl+T, then Ctrl+0
Adaptive Wide AngleOpt+Shift+Cmd+AOpt+Shift+Ctrl+A