Want to keep your heart healthy? Then you need to know the following.
- ► 2017 (358)
- ► 2016 (959)
- ► 2015 (1034)
- ► 2014 (969)
- ► 2013 (802)
- ► 2012 (882)
01/09 - 01/16
- 5 easy steps to keep your heart healthy
- How criminals use Facebook to commit crime
- Introduction to Excel Macros
- Fourteen Strategies to make better decision
- ways to keep your ego in check
- how to make better use of your time.
- How To Develop Motivation in Your Everyday Life
- Give it a thought
- Restrict duplicate data using Excel Validation
- ▼ 01/09 - 01/16 (9)
- ► 2010 (90)
- ► 2009 (58)
Want to keep your heart healthy? Then you need to know the following.
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 192.com 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)
The examples in this article were created with Excel 2000, but may be easily adapted to prior (or later) versions of Excel.
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:
- Select Tools, Macro, Record New Macro to display the Record Macro dialog box.
- 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.
- 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.
- Perform the actions necessary to complete the task. For this example, the actions are:
- 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.
- Select Format, Cells to display the Format Cells dialog box, click the Font tab and then:
- open the Color drop-down list and select the desired color;
- select Arial from the Font list;
- select Bold from the Font style list;
- select 12 from the Size list; and
- click the OK button.
- If the Stop Recording toolbar is visible, click its Stop Recording button; if the toolbar is not visible, select Tools, Macro, Stop Recording.
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
- Select Tools, Macro, Macros to display the Macro dialog box.
- Type in the name of the macro, and click the Create button.
- A code window will open in the Visual Basic Editor, with the first and last lines of the macro already typed in for you.
- Type in the balance of the macro and close the window captioned Microsoft Visual Basic.
|Sub RedCurrency() ' |
' Macro2 Macro
' Macro recorded 11/9/1999 by Tal Technologies, Inc.
Selection.Style = "Currency"
.Name = "Arial"
.FontStyle = "Bold"
.Size = 12
.Strikethrough = False
.Superscript = False
.Subscript = False
.OutlineFont = False
.Shadow = False
.Underline = xlUnderlineStyleNone
.ColorIndex = 3
- Select Tools, Macro, Macros to display the Macro dialog box.
- Select the name of the macro you wish to edit, and click the Edit button.
- A Visual Basic Editor window will open with macro's code in it.
- Make the desired corrections or modifications and close the Window captioned Microsoft Visual Basic.
The standard way to invoke a macro is via the Tools menu, as follows:
- Select Tool, Macro, Macros to display the Macro dialog box.
- Select the name of the macro you wish to invoke, and click the Run button.
- 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.
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:
- Select View, Toolbars, Forms to display the Forms toolbar.
- Click the Create Button button on the Forms toolbar.
- 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.
- In the Assign Macro dialog box, select the name of the macro to be invoked by the button, and then click the OK button.
- Type a descriptive name to appear on the button face.
- Click in the worksheet, but not on the command button, to de-select the command button.
- Click the "X" button at the upper right corner of the Forms toolbar to remove it from the screen.
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:
- 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.
- Select View, Toolbars, Customize to display the Customize dialog box.
- Click the Commands tab.
- In the Categories list select Macros.
- 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".
- Right-click the new custom button on the toolbar, and select Assign Macro to display the Assign Macro dialog box.
- 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.
- 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.
- Click the Close button in the Customize dialog box to close the dialog box.
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:
- Select Tools, Macro, Macros to display the Macro dialog box
- Select the name of the macro and click the Options button to display the Macro Options dialog box.
- Enter the shortcut key as indicated above, and click the OK button.
- Close the Macro dialog box by clicking either the close ("X") button on the title bar or the Cancel button.
- Involve colleagues who see the world differently from you.
- Fight the temptation to solve today's problem with yesterdays solution
- Solve problems with a win-win orientation
- Solicit information from individuals affected by the decision
- Make sure you are solving the right problem
- Consider as many solution as possible.
- Realize that even the best solution may open the door to new problems.
- If you are using hard data as the basis of your decision, verify the numbers.
- When you make a decision affecting others, share the reason behind the decision.
- Think in terms of satisfying, not optimization.
- Ask a lot of questions.
- Learn from prior decisions
- Ask for criticism.
- Recognize your personal decision making biases
Twelve ways to keep your ego in check
- Monitor the danger sign of a runaway ego
- Realize that your success depends on the efforts of others.
- Remove self-serving and egoistic expressions from your language.
- Stop talking and start listening.
- Study the best "balancing acts" you can find.
- Place your stature in context
- Identify the motive for self-aggrandizement.
- Learn to laugh at yourself
- When you've offended or embarrassed someone, apologize.
- Associate with many different kinds of people.
- Serve the downtrodden.
- Become a servant leader.
- Bring your daily priorities into sync with your values and beliefs.
- Find joy in the doing.
- Learn to speed read.
- Waste less time.
- Spend less time in crisis.
- Spend less time performing routine tasks.
- Spend more time strategically.
- Use a comprehensive calendar and priority management system.
- Spend more time with people and less time with things.
- Restore your energy.
- Improve your communication skills.
- Three times a day, ask yourself, "is this the best use of my time?"
- Take time to improve the quality of your life.
- Reserve one hour each day for yourself.
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: http://articleflix.com/index.php/motivation/how-to-develop-motivation-in-your-everyday-life-07062010.html?utm_source=feedburner&utm_medium=email&utm_campaign=Feed%3A+ArticleFlix+%28New+Article+From+ArticleFlix.com%29#ixzz1Aou1uxeG
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."
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.
To apply a validation rule that restricts input values to only unique values, do the following:
- Select A2:A8 (the cells you're applying the rule to).
- 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.
- Choose Custom from the Allow dropdown list.
- 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.
- Click the Error Alert tab and enter an error message.
- Click OK.
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.