Monday, December 7, 2009

Counting the number of values between upper and lower limit:

Problem:

Finding the number of values in List1 (Column A) that are larger than 20 and smaller than 50.

Solution:

Use the COUNTIF function as shown in the following formula:
=COUNTIF(A2:A7,"">20"")-COUNTIF(A2:A7,"">=50"")
Or use the SUMPRODUCT function as shown in the following formula:
=SUMPRODUCT((A2:A7>20)*(A2:A7<50))

Sunday, December 6, 2009

Push Items:

Push items are the products that receive maximum marketing and merchandising attention to increase their sales volume.

Wednesday, December 2, 2009

Use Copywriting principles for your presentations:

If you create presentations to sell or to persuade, deciding what you want to say, and in what order, is obviously extremely important. Copywriting is the best way to do so. Copywriting is usually defined as the art and science of writing to sell. From this process, copywriters have derived tried and true principles for effective selling and persuading.
The most common structure is called AIDA:
• Attention: Get attention.
• Interest: Keep interest
• Desire: Create desire
• Action: Spur action
Get attention
In traditional copywriting, you use the heading to get attention. In a presentation, the first words out of your mouth should get your audience's attention.
• Say or do something to get attention.
• Ask the audience a challenging question
• Display a striking, full-slide photo.
• Put a thought-provoking quote on a slide.
• Tell a meaningful story
Keep interest
You hold people's interest by:
• Making sure the content is relevant to your audience
• Providing information they don't know
• Using the Tell 'n' Show (SM) method to communicate visually
• Interacting with the audience, including eye contact, answering questions, and asking questions
Create desire
Create desire by showing the audience how they can benefit and what your points mean to them. Highly sensorial images also help. If you have customer testimonials, use them.
Spur action
At the end of your presentation, summarize what you've said and state your conclusion. Invite comments so that you have a chance to respond to any concerns. Finish by asking for the next step, whether it is signing a contract, approving a project, or setting up another meeting. Have the necessary materials (the contract, approval form, your calendar) so you can accomplish your goal.

Tuesday, December 1, 2009

Drag and Drop Calendar Rescheduling:

We don't have to open/edit a calendar entry in order to reschedule it. From a calendar view, you can drag and drop the entry to either a completely new date/time, or you can drag the start or end time to make the meeting longer or shorter.

Monday, November 30, 2009

Muda:

Muda is a Japanese word for waste; any activity that consumes resources but creates no value for the customer.

The following seven wastes identify and classify resources which are commonly wasted.
1. Overproduction
2. Unnecessary transportation
3. Inventory
4. Motion
5. Defects
6. Over-Processing
7. Waiting

Thursday, November 26, 2009

Package Pilferage:

Pilferage is the theft of part of the contents of a package. It may also include theft of the contents but leaving the package, perhaps resealed with bogus contents. Small packages can be pilfered from a larger package such as a shipping container. Broader aspects of theft may include taking the entire package, pallet load, truck load, shoplifting, etc.

Tuesday, November 24, 2009

Zombie Computer:

A zombie computer (often shortened as zombie) is a computer attached to the Internet that has been compromised by a hacker, a computer virus, or a trojan horse. Generally, a compromised machine is only one of many in a botnet, and will be used to perform malicious tasks of one sort or another under remote direction. Most owners of zombie computers are unaware that their system is being used in this way. Because the owner tends to be unaware, these computers are metaphorically compared to zombies.
Zombies have been used extensively to send e-mail spam; as of 2005, an estimated 50–80% of all spam worldwide was sent by zombie computers. This allows spammers to avoid detection and presumably reduces their bandwidth costs, since the owners of zombies pay for their own bandwidth. This spam also greatly furthers the spread of Trojan horses; as Trojans, they are not self-replicating. They rely on the movement of e-mails or spam to grow, whereas worms can spread by other means.