Excel – Separating positive and negative numbers:

Problem:

One column contains mixed values of positive and negative numbers, needs to be
Separated into two columns, in the first column positive values in second column negative values.
Finally, add a formula to return running balance along the cells in a third column.

Solution:

Steps 1 - Into cell B2 enter the formula:

=IF($A2>=0,$A2,"") and then copy the formula down to all cells in the range of data of column A.

Steps 2 - Into cell C2 enter the formula: =IF($B2="",$A2,"") and again copy the formula down.

Steps 3 - Into cell D2 enter the formula: =SUM(A2:B2).

Step 4 - Into cell D3 enter the formula:=D2+SUM(A3:A3) and copy the formula down the remainder of the range.

Drag and Drop files:

Instead of using the "File-Attach..." menu or the "Attach" toolbar icon and then navigating to a file in the "Create Attachment" dialog box, it is much easier to just drag and drop the file right from the desktop directly into the body of the document.

Adjust the size of the Lotus Notes window so that we can see both the desktop and the Notes document. Simply click on the file, keep the mouse button pressed, drag over to the document, and release the mouse button. Tada.... the file is copied into Notes.

But that's only the start of this tip. In the example above we had to adjust the size of the windows so we could easily see where we were dragging and dropping. We don't have to do that. Try this... First start a new document in Lotus Notes. Next, select the file from your desktop, keep the mouse button pressed, and drag the file to the Window's taskbar button for Lotus Notes. Don't release the mouse button yet, pause over the taskbar button for a second, and Lotus Notes will pop up into the foreground.


Now (still holding down the mouse button) drag the selected file to the Notes document you want to drop it into, then release the mouse button. If the document you want is already showing on the screen you are all set. If not, you can even switch back and forth between Notes tabs while dragging.

You can use this technique when working with Document Libraries, TeamRooms, mail, calendar, or anywhere else you want to attach files to a rich text field. Remember though, one of the key attributes of Lotus Notes is that you don't have to send around attachments via email. Instead store them in a central repository/library and then send users links to the document instead.

Using Feedback as a Tool:

As a project manager it is important to be able to give and receive feedback effectively. Feedback is best given on a one to one basis soon after the event that triggers its need. Here are some tips that can help:
Giving Feedback
• Feedback is always more powerful when asked for.
• Think about when and where you give feedback.
• Think carefully about what you want to say and how to say it.
• Feedback is as much about stating the positives as it is about stating the negatives.
• Be specific about the behaviors you are commenting on.
• Take responsibility for your feedback; say "I feel," "I noticed."
• Make your comments clearly and don't get emotional.
• Use analogies and examples to illustrate your points.
• Be aware of the other person's body language.
• Allow an opportunity for discussion and actively listen.
• Make sure you understand whether the feedback has been accepted or rejected.
• Look together for a solution or for a way of making things better.
Receiving Feedback
• Don't be afraid to ask for feedback.
• Listen carefully to the feedback.
• Don't leap to your own defense.
• Check your understanding and ask questions to clarify any grey areas.
• Ask for specific examples of good and bad behaviors.
• Allow yourself time to take in the feedback.
• Say which points you agree with and those you don't and why.
• Look together for a solution or for a way of making things better.
• Thank the other person for their time and effort in giving you the feedback.
Feedback is a powerful tool often underutilized. It can be used to motivate people, help with a person’s development, uncover risks and issues and solve problems. Frequent, honest and relevant feedback helps to foster an environment of open communications. Start now, there's no time like the present.

Retrieving the value of first non-blank cell in the list:

Problem:

Retrieving the value of the first non-blank cell in Range1(A2:A7).

Solution:
Use the INDEX and MATCH functions as shown in the following Array formula:
{=INDEX(A2:A7,MATCH(TRUE,A2:A7<>"""",0))}

Visual Merchandising:

Visual merchandising is the art of implementing effective design ideas to increase store traffic and sales volume.

Copy Data from Lotus Notes to Spreadsheet:

Since spreadsheets are designed for number crunching and chart creation, let's look at how using "Copy Selected as Table" can help you easily transfer data from Notes documents into a spreadsheet.

Select the documents we want to transfer, right click, and choose "Copy Selected as Table"



Next open the spreadsheet (Lotus 1-2-3, OpenOffice Calc, Excel, etc.), place the cursor in the cell where we want the data to start, and "paste".




The data from Notes view is now in a spreadsheet. We may have to format the rows and columns a bit to look exactly as we want.

WikiLeaks:

WikiLeaks is an international new media non-profit organization that publishes submissions of otherwise unavailable documents from anonymous news sources and news leaks. Its website, launched in 2006, is run by The Sunshine Press. Within a year of its launch, the site claimed its database had grown to more than 1.2 million documents. The organization has described itself as having been founded by Chinese dissidents, as well as journalists, mathematicians, and start-up company technologists from the United States, Taiwan, Europe, Australia, and South Africa.

WikiLeaks was originally launched as a user-editable wiki site, but has progressively moved towards a more traditional publication model, and no longer accepts either user comments or edits. The site is available on multiple servers and different domain names following a number of denial-of-service attacks and its severance from different Domain Name System (DNS) providers.

WikiLeaks has no official headquarters. The expenses per year are about €200,000, mainly for servers and bureaucracy, but would reach €600,000 if work currently done by volunteers were paid for. WikiLeaks does not pay for lawyers, as hundreds of thousands of dollars in legal support have been donated by media organizations such as the Associated Press, Los Angeles Times, and the National Newspaper Publishers Association. Its only revenue stream is donations, but WikiLeaks is planning to add an auction model to sell early access to documents.