Blog Archive

5 easy steps to keep your heart healthy

Get your heart pumped!

Want to keep your heart healthy? Then you need to know the following.
Holly Andersen, director of education and outreach at the Ronald O. Perelman Heart Institute of NewYork-Presbyterian Hospital has offered some easy steps to improve heart health and overall well-being throughout the year.

Step 1: Know your numbers. Your blood pressure, cholesterol and triglyceride levels are the most important numbers you will need to know before you begin on the path to good heart health.

How criminals use Facebook to commit crime


London, Dec 20 (ANI): Think giving out basic personal information on

Facebook is harmless? You might need to rethink, as a reformed burglar has

given details on how a criminal can use your user account as a tool for

committing a crime.


"The information people give out on Facebook, when linked up with other

information freely available on the internet, is an absolute -goldmine for

criminals," the Daily Mail quoted Michael Fraser, a reformed burglar who

presents the BBC's 'Beat The Burglar' programme, as saying.


"One year, you might have a party and give out your address. A while

later, you might tell everyone that it is your 30th birthday.


"So, if you've accepted me as a friend of a friend, I know your name, your

address and your birth date.


"From that, I can go to and on there I can find out what you do

for a living, how much your home is worth - and whether you're likely to

be worth burgling.


"I might have already made up my mind because you've posted party

-pictures on Facebook and I can see what kind of valuables you have in the

house - and which rooms they're in. Then you go and tell your Facebook

friends how much you're looking forward to going on holiday next Tuesday.


"I can go on to Google Street View and see actual photographs of your

home. I can see if you have a burglar alarm, or whether there are any

bushes in the garden to hide in. And I can see all the alleyways I can

escape down. And, of course, I know you won't be at home.


"Burglars only burgle homes if they think they can get away with it. All

of this information is likely to leave them feeling much more confident

that they can," added Fraser.


Co-operative Insurance company revealed that 36 per cent of users

regularly make use of them to broadcast their whereabouts when they are

away from home.


"Once you accept a stranger into your Facebook account, they can begin

what we call social -engineering - -delicately asking questions to build

up information about you,' said Jason Hart, -senior vice -president of

-CRYPTOCard Network Security.


"And that can cause havoc. Let's say they got your email address, then

they could go to your email account pretending to be you and saying you

have -forgotten your password.


"The account will then ask a security question - something like your

favourite food or your first pet. Over the following weeks and months, it

isn't hard for them to work -conversations round to subjects like that on



"Once they have that secret -information, the email account will let them

in. And once they are in there, they can find lots of sensitive

information, such as your Amazon and eBay account history.


"They can then go to those sites pretending to be you and saying you have

lost your passwords, and guess what happens then?


"Those sites send the passwords to your email account - the one that they

have already conned their way into.


"Crooks who do this usually use the credit card details you have stored

there to buy online gift vouchers that can be traded on the internet. It

is a form of instant -currency.


"Even worse, if you have a PayPal account and have credit in it, your

so-called friend could clean it out.


"Effectively, they have become an electronic version of you, they can

change all your passwords and begin stealing from you.


"The message is simple: you wouldn't invite a perfect stranger into your

house simply because they knocked on your door and said they wanted a look

around. So why do it on Facebook?," Hart added. (ANI)

Introduction to Excel Macros

Macros offer a powerful and flexible way to extend the features of MS Excel. They allow the automation of formatting, charting and other often-used spreadsheet tasks. Perhaps more significantly, macros also enable the user to seamlessly integrate an Excel workbook with another application, such as WinWedge. This article provides an overview of creating, editing, saving and invoking macros.
At its simplest, a macro is just a recording of the keystrokes and mouse actions involved in performing a particular task. At any time after the macro is created, the task can be automatically performed by invoking the macro, which essentially plays back the recording. More advanced macros can display custom forms (with command buttons, text boxes, drop-down lists, etc.) and interact with other applications; these macros typically involve the writing and editing of Visual Basic for Applications (VBA) program code.
The examples in this article were created with Excel 2000, but may be easily adapted to prior (or later) versions of Excel.
Creating Macros
A Simple Macro
If you frequently need to format individual cells in a particular way (for example, currency style in red Arial bold 12-point font), a simple recorded macro will do the trick. Use the following steps to create it:
  1. Select Tools, Macro, Record New Macro to display the Record Macro dialog box.
  2. In the Record Macro dialog box, type a descriptive Macro name (such as "RedCurrency"). By default, the macro will be stored and available only in the current workbook; if appropriate, open the Store macro in drop-down list and select either New Workbook (to store and use the macro only in a new empty workbook) or Personal Macro Workbook (to make the macro available in all workbooks). If desired, edit the text in Description. When done, click the OK button to begin recording.
  3. The word "Recording" will appear on the status bar at the bottom of the Excel window to remind you that all keystrokes and mouse actions are now being recorded. Depending on how your system is configured, a Stop Recording toolbar may also appear in the window. If you make a mistake, simply correct it as you normally would and continue; both the mistake and its correction will become part of the macro, and may be edited out later if desired.
  4. Perform the actions necessary to complete the task. For this example, the actions are:
    1. Select Format, Cells to display the Format Cells dialog box, click the Number tab, select Currency in the Category list, and click the OK button; as an alternative, you may simply click the $ button on the Formatting toolbar.
    2. Select Format, Cells to display the Format Cells dialog box, click the Font tab and then:
      1. open the Color drop-down list and select the desired color;
      2. select Arial from the Font list;
      3. select Bold from the Font style list;
      4. select 12 from the Size list; and
      5. click the OK button.
  5. If the Stop Recording toolbar is visible, click its Stop Recording button; if the toolbar is not visible, select Tools, Macro, Stop Recording.
A VBA Macro
Some macros, especially those designed to interact with another application, must be created using the Visual Basic Editor. For example, the GetSWData macro shown below increments a row pointer, retrieves a single field of data from the Software Wedge, and places it in column A of the indicated row in Sheet1 of the current workbook. Text following an apostrophe is a comment, and does not affect the operation of the macro.
Sub GetSWData()
  'preserve current row pointer value between macro calls
  Static RowPointer As Long
  'increment row pointer (initialized to 0 on first call)
  RowPointer = RowPointer + 1
  'establish DDE link to WinWedge on Com1
  ChannelNum = DDEInitiate("WinWedge", "Com1")
  'retrieve Field(1) from WinWedge into variant array F1
  F1 = DDERequest(ChannelNum, "Field(1)")
  'convert variant to string
  WedgeData$ = F1(1)
  'write data to first column in current row
  Sheets("Sheet1").Cells(RowPointer, 1).Value = WedgeData$
  'close the DDE link
  DDETerminate ChannelNum
End Sub
To create this macro, do the following:
  1. Select Tools, Macro, Macros to display the Macro dialog box.
  2. Type in the name of the macro, and click the Create button.
  3. A code window will open in the Visual Basic Editor, with the first and last lines of the macro already typed in for you.
  4. Type in the balance of the macro and close the window captioned Microsoft Visual Basic.
Editing Macros
Regardless of whether a macro was created by recording or through the Visual Basic Editor, it is stored as VBA code. For example, the simple recorded macro described above might be stored as follows:
Sub RedCurrency() '
  ' Macro2 Macro
  ' Macro recorded 11/9/1999 by Tal Technologies, Inc.

  Selection.Style = "Currency"
  With Selection.Font
    .Name = "Arial"
    .FontStyle = "Bold"
    .Size = 12
    .Strikethrough = False
    .Superscript = False
    .Subscript = False
    .OutlineFont = False
    .Shadow = False
    .Underline = xlUnderlineStyleNone
    .ColorIndex = 3
  End With
End Sub
If you need to correct or modify a macro, you always use the Visual Basic Editor. The procedure is:
  1. Select Tools, Macro, Macros to display the Macro dialog box.
  2. Select the name of the macro you wish to edit, and click the Edit button.
  3. A Visual Basic Editor window will open with macro's code in it.
  4. Make the desired corrections or modifications and close the Window captioned Microsoft Visual Basic.
Saving Macros
Macros are saved as part of the workbook in which they were created. If you attempt to exit from Excel without saving any macros you created or modified, you will see a warning dialog box giving you the option to save the affected workbook. You can avoid seeing this warning by saving your work in either Excel or the Visual Basic Editor.
Invoking Macros
Tools Menu
The standard way to invoke a macro is via the Tools menu, as follows:
  1. Select Tool, Macro, Macros to display the Macro dialog box.
  2. Select the name of the macro you wish to invoke, and click the Run button.
  3. The macro will run immediately. For example, if you invoked the RedCurrency macro above, the formatting of the current cell would immediately change to red Arial bold 12-point font.
Worksheet Button
A more convenient way to invoke a macro is via a command button on the worksheet itself. While you can install a command button from either the Controls Toolbox toolbar or the Forms toolbar, you should generally use only the Forms toolbar. When a macro is invoked from a command button installed from the Controls Toolbox toolbar, the button itself retains the focus, and this may interfere with the correct operation of the macro. When a macro is invoked from a command button installed from the Forms toolbar, the button does not retain the focus and the macro executes normally. To create a command button on a worksheet, do the following:
  1. Select View, Toolbars, Forms to display the Forms toolbar.
  2. Click the Create Button button on the Forms toolbar.
  3. button.jpg (12789 bytes)
  4. Drag the mouse pointer on the worksheet to indicate the location and shape of the command button you wish to create. When you release the mouse button, the command button will appear, along with an Assign Macro dialog box.
  5. In the Assign Macro dialog box, select the name of the macro to be invoked by the button, and then click the OK button.
  6. Type a descriptive name to appear on the button face.
  7. Click in the worksheet, but not on the command button, to de-select the command button.
  8. Click the "X" button at the upper right corner of the Forms toolbar to remove it from the screen.
The macro will now execute immediately whenever the command button is clicked.
Custom Toolbar Button
You can also use a custom button on any of the toolbars to invoke a macro. To create a custom button on a toolbar, do the following:
  1. If the toolbar you wish to add the custom button to is not visible, select View, Toolbars and then click the name of that toolbar to display it.
  2. Select View, Toolbars, Customize to display the Customize dialog box.
  3. Click the Commands tab.
  4. In the Categories list select Macros.
  5. Drag the Custom Button icon from the Commands list and drop it at the desired position on the toolbar. During the drag, a small square box will appear just below and to the right of the mouse pointer. The box will contain a "+" when the mouse pointer is at a location where the custom button may dropped; otherwise it will contain an "x".
  6. Right-click the new custom button on the toolbar, and select Assign Macro to display the Assign Macro dialog box.
  7. In the Assign Macro dialog box, select the name of the macro to be invoked when the custom button is clicked, and click the OK button.
  8. If you want to change the button image, right-click the new custom button on the toolbar, and select Change Button Image and then click the image you want to use.
  9. Click the Close button in the Customize dialog box to close the dialog box.
The macro will now execute immediately whenever the custom toolbar button is clicked.
Shortcut Key
You can also invoke a macro by simply pressing its assigned shortcut key (sometimes known as a "hot key"). If you are recording a new macro, you can assign a shortcut key to it while the Record Macro dialog box is displayed. Simply click the Shortcut key text box and either type a letter key (to produce a Ctrl shortcut key) or type a letter key while holding down the Shift key (to produce a Ctrl-Shift shortcut key).
After a macro has been created, you can assign or change its shortcut key by doing the following:
  1. Select Tools, Macro, Macros to display the Macro dialog box
  2. Select the name of the macro and click the Options button to display the Macro Options dialog box.
  3. Enter the shortcut key as indicated above, and click the OK button.
  4. Close the Macro dialog box by clicking either the close ("X") button on the title bar or the Cancel button.
The macro will now execute immediately whenever the shortcut key is pressed. Remember to hold down the Ctrl key (for Ctrl shortcut keys) or both the Ctrl and Shift keys (for Ctrl-Shift shortcut keys) while you press the letter key.

Fourteen Strategies to make better decision

  1. Involve colleagues who see the world differently from you.
  2. Fight the temptation to solve today's problem with yesterdays solution
  3. Solve problems with a win-win orientation
  4. Solicit information from individuals affected by the decision
  5. Make sure you are solving the right problem
  6. Consider as many solution as possible.
  7. Realize that even the best solution may open the door to new problems.
  8. If you are using hard data as the basis of your decision, verify the numbers.
  9. When you make a decision affecting others, share the reason behind the decision.
  10. Think in terms of satisfying, not optimization.
  11. Ask a lot of questions.
  12. Learn from prior decisions
  13. Ask for criticism.
  14. Recognize your personal decision making biases

ways to keep your ego in check


Twelve ways to keep your ego in check           

  1. Monitor the danger sign of a runaway ego
  2. Realize that your success depends on the efforts of others.
  3. Remove self-serving and egoistic expressions from your language.
  4. Stop talking and start listening.
  5. Study the best "balancing acts" you can find.
  6. Place your stature in context
  7. Identify the motive for self-aggrandizement.
  8. Learn to laugh at yourself
  9. When you've offended or embarrassed someone, apologize.
  10. Associate with many different kinds of people.
  11. Serve the downtrodden.
  12. Become a servant leader.


how to make better use of your time.

  1. Bring your daily priorities into sync with your values and beliefs.
  2. Find joy in the doing.
  3. Learn to speed read.
  4. Waste less time.
  5. Spend less time in crisis.
  6. Spend less time performing routine tasks.
  7. Spend more time strategically.
  8. Use a comprehensive calendar and priority management system.
  9. Spend more time with people and less time with things.
  10. Restore your energy.
  11. Improve your communication skills.
  12. Three times a day, ask yourself, "is this the best use of my time?"
  13. Take time to improve the quality of your life.
  14. Reserve one hour each day for yourself.


How To Develop Motivation in Your Everyday Life

How To Develop Motivation in Your Everyday Life

How To Develop Motivation in Your Everyday Life
Personal development, maximizing your potential, goals setting, motivating yourself for the better – these are some of the inter-related things that you need to work on as an individual

Here, we will set our sights on the many ways that you can develop motivation in life.

The Importance of Finding Out what Motivates You

Ryan Whiteside is a Guest Blogger for PickTheBrain. To learn more about personal development and how to set goals visit the Ultimate Guide To Personal Development

Read more:

Give it a thought

Don't just have career or academic goals. Set goals to give you a balanced, successful life. I use the word balanced before successful. Balanced means ensuring your health, relationships, mental peace are all in good order.

There is no point of getting a promotion on the day of your breakup. There is no fun in driving a car if your back hurts. Shopping is not enjoyable if your mind is full of tensions.

"Life is one of those races in nursery school where you have to run with a marble in a spoon kept in your mouth. If the marble falls, there is no point coming first. Same is with life where health and relationships are the marble. Your striving is only worth it if there is harmony in your life. Else, you may achieve the success, but this spark, this feeling of being excited and alive, will start to die. .......

One thing about nurturing the spark - don't take life seriously. Life is not meant to be taken seriously, as we are really temporary here. We are like a pre-paid card with limited validity. If we are lucky, we may last another 50 years. And 50 years is just 2,500 weekends. Do we really need to get so worked up? .......

It's ok, bunk a few classes, scoring low in couple of papers, goof up a few interviews, take leave from work, fall in love, little fights with your spouse. We are people, not programmed devices........."

"Don't be serious, just try to be sincere."


Restrict duplicate data using Excel Validation

Excel sheets accept duplicate values of course, but that doesn't mean you'll always want to allow them. There are times when you'll not want to repeat a value. Instead of entering a new row (or record), you'll want the user to update existing data. You can train users, but that doesn't mean they'll comply. They'll try to, but specific rules are easy to forget, especially if updates are infrequent. The easiest way to protect a sheet from duplicate values is to apply a validation rule. If a user tries to enter a duplicate value, the appropriate validation rule will reject the input value and (usually) provide helpful information as to what the user should do next.

For example, let's suppose users track hours worked using the sheet shown below. You want each worked date (column A) entered just once—there's no signing in and out for lunch or other activities. (This setup would be too restrictive for most situations, but it sets up the technique nicely.) Realistically, a user could easily see that they're re-entering an existing date, but in a sheet with a lot of data, that wouldn't be the case. At any rate, there's nothing to stop the user from entering the same date twice.

To apply a validation rule that restricts input values to only unique values, do the following:
  1. Select A2:A8 (the cells you're applying the rule to).
  2. Choose Validation from the Data menu and click the Settings tab. In Excel 2007/2010, click the Data tab and choose Data Validation from the Data Validation dropdown in the Data Tools group.
  3. Choose Custom from the Allow dropdown list.
  4. The Custom option requires a formula that returns True or False. In the Formula field, enter the following expression: =COUNTIF($A$2:$A$8,A2)=1.
  5. Click the Error Alert tab and enter an error message.
  6. Click OK.
Once you set the rule in place, users must enter unique date values in A2:A8. As you can see below, Excel rejects a duplicate date value, displays a simple explanation, and tells the user what to do next—click Retry and enter a unique date.

This particular validation formula accepts any value, it just won't accept a duplicate value. The cell format is set to Date, which restricts entry to date values. You can use this formula to restrict any type of data, not just date values.
Get IT tips, news, and reviews delivered directly to your inbox by subscribing to TechRepublic's free newsletters.