Thursday, 16 June 2016

[HM:258447] 20 Excel Keyboard Shortcuts that will Impress Your Boss

20 Excel Keyboard Shortcuts Cover2

Excel Keyboard Shortcuts

In this tutorial, I am sharing my top 20 Excel Keyboard shortcuts that can help you speed up your work and save a lot of time.

How to use interpret keyboard shortcuts: CONTROL + T would mean press the Control key and then press the T key. CONTROL T would mean hold the Control key and press the T key.

#1 Auto Sum

If you have numbers in a column/row, you can quickly get the sum by using this Excel keyboard shortcut.

ALT =

Excel Keyboard Shortcuts 1

#2 Paste as Values

When you copy and paste a cell or a range of cells, it also copies the value, the formula in it, and the formatting. If you only want to copy the values, use the following keyboard shortcut.

ALT + E + S + V + ENTER

Excel Keyboard Shortcuts 2

#3 Fill Down

This one would help you while entering data in Excel. Use it to copy the cell right above the active cell. Note that this would copy the contents, formulas and formatting as well.

CONTROL D

Excel Keyboard Shortcuts 3 - Fill Down

#4 Select Entire Row/Column

You use the following shortcuts to select an entire row or column that contains the active cell.

To select the entire row:

SHIFT SPACEBAR

Excel Keyboard Shortcuts 4a

To select the entire column:

CONTROL SPACEBAR

Excel Keyboard Shortcuts - 4b

For example, if cell B2 is selected, then Shift + Spacebar would select the second row and Control + Spacebar would select the second column.

#5 Delete Cells/Row/Column

To delete selected cells, rows, or columns, use the keyboard shortcut:

CONTROL –

Excel Keyboard Shortcuts - 5

This opens the Delete dialog box, where you can select from the following options:

Shift cells left.
Shift cells up.
Delete Entire Row.
Delete Entire Column.

#6 Applying Border

To quickly apply borders to the selected cells, use the keyboard shortcut:

ALT + H + B + A

Excel Keyboard Shortcuts - 6

Note that this applies the "All Border" format, which means that all the cells get the border format. If you want to apply the Outline border only use ALT + H + B + S.

#7 Inserting a Comment

If your work involves inserting a lot of comments in cells in Excel, you'll find this shortcut mighty useful.

To quickly insert a comment in a cell, use the keyboard shortcut:

SHIFT F2

This would insert the comment and place the cursor within the comment.

Excel Keyboard Shortcuts - 7

When you have entered the comment, press the Escape key to come out of the comment mode. The cell that contains the comment would show a red triangle at the top right.

If you already have a comment in a cell, this would open the comment and place the cursor within the comment.

#8 Insert Current Date and Time

This keyboard shortcut can be used to quickly insert time stamps in cells.

To insert current date, use the keyboard shortcut:

CONTROL ;

Excel Keyboard Shortcuts 8a

To insert current time, use the keyboard shortcut:

CONTROL SHIFT ;

Excel Keyboard Shortcuts 8b

#9 Navigate Through Worksheets

If you have a lot of worksheets in the workbook, it can drive you crazy to navigate through it.

Here is the keyboard shortcut that solves this problem.

To go to the previous worksheet:

CONTROL PAGEUP

Excel Keyboard Shortcuts 9b

To go to the next worksheet:

CONTROL PAGEDOWN

Excel Keyboard Shortcuts 9

Note that if you continue to hold the keys, it will keep on moving on to the previous/next worksheet.

#10 Apply Filter

While you can easily apply/remove filter with the filter Filter option in the ribbon (in the data tab), it still takes time and a couple of clicks.

Here is a keyboard shortcut that would instantly apply data filter (or remove filters if it's already applied):

CONTROL SHIFT L

Excel Keyboard Shortcuts 10

#11 Select Visible Cells Only

Let me first tell you why this is important.

Suppose you have a list in Excel and you hide a few rows. Now if you copy the entire list and paste it somewhere else, it will copy all the cells (including the ones that are hidden, as shown below):

Excel Keyboard Shortcuts 11a

Note that a few rows in the original data set are hidden, but when you copy paste it, even the hidden rows get copied.

If you don't want this to happen, you first need to select only those cells that are visible. To do this, select the entire list and use the keyboard shortcut:

ALT ;

Now when you copy it and paste it anywhere, you can be sure only the visible cells are getting copied.

Excel Keyboard Shortcuts 11b

#12 Freeze Top Row

If you work with a data set that is huge and spans across hundreds or thousands of rows and many columns, you'll face the issue of the header disappearing when you scroll down. This often wastes a lot of time as you have to scroll back to see what a data point means.

Freezing rows and columns is the way to go in such cases.

Here are the shortcuts for freezing rows/columns:

To freeze the top row:

ALT + W + F + R
Note that the top row gets fixed.

To freeze the first column:

ALT + W + F + C
Note that the left most column gets fixed.

If you want freeze both rows and column, select a cell above which you want to freeze rows (you can freeze more than one row), and to the left of which you want to freeze columns (could be one or more than one). For example, if you want to freeze top two rows and one column to the left, select cell B3.

Now use the shortcut:

ALT + W + F + F

#13 Opening Format Cells Dialogue Box

This one is my favorite. If you want to change the formatting of a cell or range of cells, select the cells and use the keyboard shortcut:

CONTROL 1

Excel Keyboard Shortcuts 13

It's a gateway to all the formatting you can do this Excel. It opens a dialog box where you have different tabs for different types of formatting.

#14 Start New Line in the Same Cell

Sometimes, you may want to show the text/data in two or more than two rows in the same cell in Excel. For example, you may want to enter the address in a cell, but want the house numbers, street, city, state in different lines in the same cell.

To do this, place the cursor where you want to insert the line and use the keyboard shortcut:

ALT ENTER

Excel Keyboard Shortcuts 14

#15 Switch to Next Workbook

If you're working with multiple workbooks, you may need to switch between these workbooks. A popular shortcut to do this is ALT + TAB

But this would cycle through all the open applications. For example, if you have multiple application open at the same time, such as a browser, powerpoint, word, excel, skype, vlc, and so on, ALT + TAB would cycle through all these applications.

Instead, activate a workbook and then use the following shortcut to switch between open workbooks only.

CONTROL TAB

What is a Pivot Table - How to Make it How to cook a delicious dynamic chart Excel: Creating A Thermometer Style Chart Excel: Creating A Database Table From A Summary Table Excel: Perform Two-Way Table Lookup Excel: Calculate The Number Of Days In A Month

#16 Insert Hyperlink

To insert a hyperlink in a cell, you need to open the Insert Hyperlink dialog box. The keyboard shortcut for this is:

CONTROL K

Excel Keyboard Shortcut 16

#17 Insert Bullet

If you want to insert bullets in Excel (in case you are creating a list), you can do that quickly by using a keyboard shortcut.

If you have a numeric keypad in your keyboard:

Select the cell in which you want to insert the bullet.
Either double click on the cell or press F2 – to get into edit mode.
Hold the ALT key, Press 7 or 9, leave the ALT key.
As soon as you leave the ALT key, a bullet would appear.

Excel Keyboard Shortcuts - 17

If you do not have a numeric Keyboard (like my laptop), activate the NumLock first and then repeat the above steps (or try with ALT + FUNCTION + 7/9)

#18 Converting Tabular Data into Excel Table

Excel Table is a must use feature if you work with tabular data.

To quickly convert tabular data into an Excel Table, select the data (or select any cell in the data set) and use the keyboard shortcut:

CONTROL T

Excel Keyboard Shortcuts - 18

This will open the Create Table dialog box. While it automatically picks the range that needs to be converted, and it most cases it is correct, it's a good practice to cross check this.

Click on OK (or press Enter).

#19 Spell Check

While most of the people work with data in Excel, if your work involves a bit of text as well, it's a good practice to run spell check before marking the work as final and sending across to your boss or client.

Unlike MS Word or PowerPoint, Excel would not show red lines below the words that are misspelled. However, if you run spell check, it will catch those errors.

To run spell check, simply hit the F7 key.

#20 Open the VB Editor Window

Working with VBA requires one to switch between the worksheet and the VB Editor.

To make a switch from Excel workbook to VB Editor, use the keyboard shortcut:

ALT F11

These are my top 20 Excel keyboard shortcuts. I am sure you have some of you own too.

Share it with me in the comments section.

Junaid Tahir
www.DailyTenMinutes.com

--
--
We are also on Face Book, Click on Like to jois us
FB Page: https://www.facebook.com/pages/Hyderabad-Masti/335077553211328
FB Group: https://www.facebook.com/groups/hydmasti/

https://groups.google.com/d/msg/hyd-masti/GO9LYiFoudM/TKqvCCq2EbMJ

---
You received this message because you are subscribed to the Google Groups "Hyderabad Masti" group.
To unsubscribe from this group and stop receiving emails from it, send an email to hyd-masti+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[HM:258446] How to Become More Compassionate

How to Become More Compassionate

Compassion brings both short and long-term happiness. Showing compassion not only allows you to feel better, but it helps those around you to feel better, too. Since we all want to be happy, showing compassion can be a common goal for everyone.

Cultivating compassion is a worthwhile goal. It's a significant part of being human and can make you more grateful for the many good things you already have in your life.

How can we be more compassionate?

1. Have good intentions. Each day, simply have the intention of being compassionate and showing compassion to everyone you encounter. Make it a part of your morning ritual to remind yourself to be compassionate.

Before you go to sleep at night, reflect on how you were compassionate or failed to show compassion that day. Remind yourself again to be compassionate the next day.

2. Focus on the similarities you share with others. Human brains are great at spotting differences. However, we have to make a conscious effort to spot the similarities.

When you find yourself feeling less than happy with someone, try to list as many things as you can that you share in common.

Remember that all humans are similar in the ways that matter. For example, we all need love, attention, happiness, affection, food, and shelter.

3. Be empathetic. With everything happening in our lives, it's easy to focus on ourselves and ignore the plight of others. Consider the similarities that others share with your loved ones. Now imagine your loved one is suffering.

If you can see another person as being similar to your loved one, it will become easy to be sensitive to their suffering.

Keep in mind that another person is someone else's loved one.

How would you want your loved one to be treated during a challenging time?

4. Be compassionate with yourself. You might have noticed that the least compassionate people are those that are the hardest on themselves. If you won't give yourself a break when you need it, you're less likely to do it for someone else.

Appreciate yourself and the challenges that you've experienced in your own life. You'll become more capable of doing the same for others, too.

Recognize that time you spend on yourself is time well spent. Refrain from viewing it as an act of selfishness. You're just as important as anyone else.

Let go of needing to be perfect. Nobody's perfect, so it's a game that can't be won. If you'll stop demanding perfection of yourself, you'll stop requiring others to be perfect, too.

5. Be fully present with others. The ultimate kindness is to be 100% present with someone. It's also a great time to practice being mindful. Be supportive and a good listener without thinking any stray thoughts.

It's not always easy to stay in the moment when someone is hurting, but you'll be a better person for it.

6. Remember the times that others have been kind to you. Perhaps you can do the same favor for someone else.

7. Remember the times that others have been unkind to you. Perhaps you can spare someone else from feeling the same pain.

Being compassionate is really a gift you give to yourself. When you're kinder to others, you learn to be kinder to yourself. You also encourage others to take an interest in your life and to direct compassion back in your direction.

The post How to Become More Compassionate appeared first on My Self Improvement Daily.

Junaid Tahir
www.DailyTenMinutes.com

Thursday, 9 June 2016

[HM:258445] 10 Situations Where You Could Avoid Being Judgmental

By Junaid Tahir
This is more or less part of our DNAs that we react to situations instantly without giving a second thought. At times, this is perfectly a normal phenomenon and the impact of our reactions is acceptable as long as it based on positive and realistic judgement. However, it is usually seen, that our reactions slash someone's emotions or causing psychological disturbance, especially if the person is sensitive. Here are some situations:

1. The Taxi drive might be an MBA. Don't underestimate his education level. He might have a reason to drive taxi.

2. The boy who mistakenly hit you in crowd might have leg surgery a week back. Don't misjudge his character.

3. The senior you made fun of because of the scars on his face might have fought for the country. Don't feel irritated because of his outlook.

4. The boy you made fun of because of crying, his mother might have died. Don't think that a male cannot cry.

5. The person who was issued a police ticket for parking in disabled parking area might actually have a disabled son/daughter. Don't conclude things quickly.

6. A not-so-tall person might have much higher ethics. Don't conclude things based on physical outlook.

7. A poor man may have cleaner heart than you. Don't have a discriminated feelings as he may be more closer to the Lord because of his deeds.

8. The rich person might have earned his wealth without any corruption. Don't put bad labels on successful people without knowing them very closely.

9. A rude person in market may have lost his car in an accident. Don't react based on an instant observation. Find out the real story or stay calm.

10. The fat person might be starving today. Don't Laugh on his obesity. Probably he is obese because of his genetics.

Good and bad reactions create strong ripples. Whatever you say or do is observed, absorbed and repeated by the people around you which in turns gets expanded in the society. Be mindful on what you say to others or what you share on social media or what you do in public. Each of your action is transforming the society in a good or bad way. So don't be judgmental and don't be reactive; it is not what we say, it is how we say.

Photo Credit 1 & 2 & 3

9 Rules for Staying Positive
How To Develop Analytical Skills
Do You Judge People Fairly?
Do You Treat People Fairly?

Junaid Tahir
www.DailyTenMinutes.com

Sunday, 5 June 2016

[HM:258444] Engaging With Social Media Can Drain Your Brain

The retweet is a major social currency of our time. Even if we generally aren't reading the stuff we're retweeting, it seems harmless enough to share whatever grabs a sliver of our interest.

But then again, maybe it's not so harmless. So argues a new study (link is external) by a research team from Cornell University and Beijing University. The researchers wondered if retweeting and otherwise sharing information online steals away mental resources that could aid in comprehending, recalling, and maybe even beneficially using the content.

Think of it as a reposting tax on your brain.

To test the theory, the researchers presented two groups of students with messages from Weibo, the Chinese equivalent of Twitter. After reading each message, one group had the option of either reposting it or going on to the next message. The other group wasn't able to repost and could only move on to the next message. Both groups were then given a test on how well they comprehended and recalled the content of the messages.

People in the repost group had twice as many wrong answers as the non-repost group and significantly worse comprehension of the content. The comprehension results were especially bad for the messages they reposted even if they could remember the topics.

In a follow-up experiment, two groups were again presented with Weibo messages and the same repost or no-repost conditions. Then both groups read an unrelated article from a science magazine and took a test on its content. The group that reposted messages performed significantly worse on the comprehension test than the read-only group.

So what's happening that would lead the reposters to perform worse than non-reposters in both experiments? The researchers think it comes down to "cognitive overload"—it's not the content but the decision to share it or not that drains mental resources.

"The sharing leads to cognitive overload, and that interferes with the subsequent task," said Qi Wang, professor of human development in the College of Human Ecology at Cornell University.

The additional mental drain might be small in each "to share or not to share" case, but cumulatively it's not so small. Consider how many times in any given day (or in any given hour of any day) we make these choices. That little tax adds up, and the new research suggests that it takes a toll on anything else we need our cognitive faculties to accomplish.

"In real life when students are surfing online and exchanging information and right after that they go to take a test, they may perform worse," added Wang.

I'm not sure if this result amounts to an endorsement for mindlessly sharing stuff (which presumably requires less thought), but it's interesting to consider how even tiny brain drains add up and draw away juice from other things. Something to think about —after you retweet this post.

David DiSalvo Neuronarrative psychologytoday. Photo Credit

Saturday, 4 June 2016

[HM:258443] The Sensor that Sniffs Disease in Your Breath

Image Source

Newly developed sensors made of metal oxide nanofibers are a cheap and non-invasive alternative to traditional diagnostic techniques.

Something Doesn't Smell Right

Scientists at the Korea Advanced Institute of Science and Technology (KAIST) are developing biosensors that can sniff out certain molecular signatures, a useful tool for medical diagnosis. Professor Il-Doo Kim, of the Department of Materials Science and Engineering at KAIST, has led the research, which may enable such technology to work with smartphones, smartwatches, and other commonly available devices.

The idea is to use small semiconductors made of metal oxide nanofibers as sensor arrays; these devices are designed for maximum "gas adsorption," which allows them to analyze "volatile organic compounds" (VOCs) exhaled in human breath. Detecting these chemical signatures will mean early diagnosis of certain diseases, a potentially life-saving advantage.

The sensor arrays register, for instance, the presence in VOCs of acetone, H2S, ammonia, and toluene, which would indicate the presence of diabetes, halitosis, kidney malfunction, and lung cancer.

Honestly, anyone whose breath smells like acetone, hydrogen sulfide, or ammonia should already be sending up some red flags; but the point is, the ultrasenstitive technology can detect even trace biomarkers.

And by analyzing gases that originate at the blood-lung tissue barrier, the technology provides an important window onto the health of a patient, and can be extended to sense a wide variety of diseases.

Source: futurism

Tuesday, 31 May 2016

Re: [HM:258442] Digest for hyd-masti@googlegroups.com - 1 update in 1 topic

Travel Time: "A small unspoiled hill town which gives you the feeling that you are the first man in the world to discover it"..

Travel Time: "A small unspoiled hill town which gives you the feeling ...

Travel Time

On Thursday, 26 May 2016 5:19 PM, "hyd-masti@googlegroups.com" <hyd-masti@googlegroups.com> wrote:

hyd-masti@googlegroups.com

Google Groups

Topic digest
View all topics

Most Positive Virtues for Great Life - 1 Update

Most Positive Virtues for Great Life

Junaid Tahir <mjunaidtahir@gmail.com>: May 26 09:29AM +0400

[image: Image result for virtues]

1. Have a firm handshake.
2. Look people in the eye.
3. Don't expect life to be fair.
4. Remember that 80 per cent of the success in any job is based on your
ability to deal with people.
5. If in a fight, hit first and hit hard.
6. Keep secrets.
7. Never give up on anybody. Miracles happen everyday.
8. Always accept an outstretched hand.
9. Be brave. Even if you're not, pretend to be. No one can tell the
difference.
10. Wave at the children on a school bus.
11. Avoid sarcastic remarks.
12. Choose your life's mate carefully. From this one decision will come 90
per cent of all your happiness or misery.
13. Make it a habit to do nice things for people who will never find out.
14. Lend only those books you never care to see again.
15. Never deprive someone of hope; it might be all that they have.
16. When playing games with children, let them win.
17. Give people a second chance, but not a third.
18. Be romantic.
19. Become the most positive and enthusiastic person you know.
20. Loosen up. Relax. Except for rare life-and-death matters, nothing is as
important as it first seems.
21. Don't allow the phone to interrupt important moments. It's there for
our convenience, not the caller's.
22. Be a good loser.
23. Be a good winner.
24. Think twice before burdening a friend with a secret.
25. When someone hugs you, let them be the first to let go.
26. Be modest. A lot was accomplished before you were born.
27. Keep it simple.
28. Beware of the person who has nothing to lose.
29. Don't burn bridges. You'll be surprised how many times you have to
cross the same river.
30. Live your life so that your epitaph could read, No Regrets
31. Be bold and courageous. When you look back on life, you'll regret the
things you didn't do more than the ones you did.
32. Never waste an opportunity to tell someone you love them.
33. Remember no one makes it alone. Have a grateful heart and be quick to
acknowledge those who helped you.
34. Take charge of your attitude. Don't let someone else choose it for you.
35. Visit friends and relatives when they are in hospital; you need only
stay a few minutes.
36. Begin each day with some of your favourite quotes. if you don't have,
find some.
37. Once in a while, take the scenic route.
38. Send a lot of cards. Sign them, 'Someone who thinks you're terrific.'
39. Answer the phone with enthusiasm and energy in your voice.
40. Keep a note pad and pencil on your bed-side table. Million-dollar ideas
sometimes strike at 3 a.m.
41. Show respect for everyone who works for a living, regardless of how
trivial their job.
42. Send your loved ones flowers. Think of a reason later.
43. Make someone's day by paying the toll for the person in the car behind
you.
44. Become someone's hero.
45. Marry only for love.
46. Count your blessings.
47. Compliment the meal when you're a guest in someone's home.

*Junaid Tahir *www.DailyTenMinutes.com
[image: Follow me on Twitter] <https://twitter.com/DailyTenMinutes> [image:
View my profile on LinkedIn] <http://www.linkedin.com/in/mjunaidtahir> [image:
Like my page on Facebook] <https://www.facebook.com/Dailytenminutes> [image:
Read my articles on my personal blog]
<http://www.dailytenminutes.com/p/junaids-work.html> [image: Subscribe to
my Feed] <http://feeds.feedburner.com/DailyTenMinutes> [image: Visit my
Google+ Page] <https://plus.google.com/s/dailytenminutes>

You received this digest because you're subscribed to updates for this group. You can change your settings on the group membership page.
To unsubscribe from this group and stop receiving emails from it send an email to hyd-masti+unsubscribe@googlegroups.com.

Sunday, 29 May 2016

[HM:258441] 70+ Ideas to Increase Sales of Your Company

1. Have a sale – You can offer a holiday or other discount to either the general public or your best customers. Just be careful not to offer too many; your customers might begin to wait for a sale instead of buying things at regular price.

2. Have a sale – You can offer a holiday or other discount to either the general public or your best customers. Just be careful not to offer too many; your customers might begin to wait for a sale instead of buying things at regular price.

3. Hold a contest – Offer to automatically enter your customers into a contest when they make a purchase. You could also offer your product as the price for one being held by other small businesses. Either way, make sure that the contest revolves around you and your product.

4. Give something away for free – Hand out samples of your product, promotional products branded with your logo, or other gifts at a key location. This lets people experience what you have to offer first-hand at a key location.

5. Frequent shopper cards – Offer customers a discount or free product after they've made a specific number of purchases. Give discounts to targeted groups – This could be a specific club or association, or simply a group of people who have attended a specific event.

6. Offer a trade-in – Reward customer loyalty by encouraging them to trade in their old product for a discount on something new.

5 Ways to Increase Project Management Maturity

7. Point-of-sale displays – Present your in-store products in an unusual way. Stack them in a huge pyramid, or use oddly shaped signs. If you have a window out front, create a wacky display using mannequins or other fun objects.

8. Offer free shipping – The word "free" is always attractive to customers, and free shipping is usually a reasonable discount. Offer easy payments or installment plans – These are simple ideas that attract customers by making your products more affordable.

9. Offer a group or referral discount – These are the sort of discounts that get people talking. Encourage customers to share a deal with others, and they'll do the promotional work for you.

10. Bundle products or services together – Package no-selling products with your more popular products. Giving a customer more for less both encourages them to buy and clears your idle inventory.

11. Upsell - Highlight your more expensive products. Give those products more attention in your store or on your website. Provide benefits and reasons why those products are better.

12. Cross-sell – Customers are more likely to buy from you again right after a purchase. This is a great opportunity to cross-sell a complementary product.

13. Create coupons – Coupons can be advertised in coupon books or mail packets, or on bulletin boards in high traffic areas. You can also add them to any marketing collateral that you distribute, such as brochures or sale sheets.

5 Ways towards Becoming Effective Project Manager

14. Offer upgrades – Let customers know when there is an opportunity to upgrade a product to make it better or add additional functions.

15. Sell replacement parts – Determine your product's lifecycle and find out when it tends to start getting worn out. Stay in contact with your customers to make it easier for them to get the product fixed.

16. Offer guarantees - A guarantee helps inspire confidence in buyers and highlights your integrity.

17. Easy return policy – Impulse buyers will be more likely to purchase items that they can easily return later if they choose.

18. Free trial – Offer a free trial of your product so that potential buyers can become more acquainted with it.

19. Business card coupon – Print the back of your business card so that it doubles as a coupon. This will encourage people you meet to purchase from you as well.

20. Use your car or truck – You can follow Nascar's lead by covering your vehicle withvinyl wrapping or magnetic signs that advertise your business.

21. Signs, banners and posters – Keep paper materials that promote sales, offers and promotions close at hand, and use them when opportunities present themselves. Place them in public places or get permission to display them in private businesses where people gather.

22. Business cards – Always carry business cards with you and give them to new acquaintances, close associates and anyone who might need to contact you. Give customers extra cards with the incentive of a free service or discount when they refer someone they know to your business.

23. Promotional products – Printed custom products such as drinkware or keychains can be given as gifts or used at a special event.

24. Brochures – Specialized brochures are a great place to feature a new product or service.

25. Postcards – Handwritten postcards are cheaper than letters, and are great for reaching out to prospects. Try sending these for anniversaries, birthdays or holidays.

5 Steps to Develop Your Personality

26. Newsletters – A newsletter allows you to communicate with prospects on a regular basis.

27. Direct mail – Catalogs, brochures, and other materials can be mailed directly to your prospects.

28. E-mail blasts- Create an eye-catching e-mail newsletter that piques people's curiosity and encourages them to subscribe.

29. Calendars- Create a promotional calendar featuring your products and other information about your company.

30. Visual spectacle – Place something eye-catching outside your storefront, like balloons or an "inflatable tube man."

31. Sidewalk chalk – Write a creative marketing message in places where people are likely to see it. Sidewalk chalk is especially popular on college campuses..

32. Alternate-reality game – An ARG is like an elaborate scavenger hunt that ties in with your product. It can take place either online or in real life. Participants might involve their friends and attract even more people to your brand.

33. Automatic e-mails – Try setting up your e-commerce website so that it automatically sends customers an e-mail when they abandon their shopping cart.

34. Create a commercial – Produce an ad to air on the radio, TV, cable, or even before a movie at your local theater.

35. Newspaper or magazine ad – Take out ad space in a periodical to appeal to a specialized audience.

36. Create a website - Even brick-and-mortar businesses can benefit from a professional website with a memorable URL.

37. Web banner ads – Buy banner advertising on websites that target your specific market. One popular idea is to include a trivia question in your ad and offer a discount or deal if the user gets it right.

38. Viral video – A funny or impressive Youtube video can rapidly attract a huge audience.

39. Video testimonials – Ask appreciative customers to tell their story on camera and incorporate these testimonials into your TV or Youtube campaign.

40. Jingle - Compose a catchy tune that's sure to get stuck in people's heads. Include it in your radio, TV, or Youtube advertising.

Saying Sorry to the Customer - Sample Formats

41. Quick response code – Add a QR code (similar to a barcode) to your printed material so that people can go directly to your website, add you as a contact, or take many other actions simply by snapping a photo. Outdoor advertising- Billboards and signs can direct people to your business from a unique location. This could include an ad at your local sports area. This prominent piece of advertising is both a billboard and a QR code. Source: gwire

42. Windshield pamphlets – Place eye-catching fliers or postcards under the windshield wipers of cars in a crowded parking lot.

43. Undercover marketing – You can artificially inspire "word of mouth" by hiring people to discuss your product in social areas such as coffee areas, famous hotel lobbys.

44. Use your voice mail – Your voice mail message is a great marketing opportunity to offer special discounts or mention new products. You can even hire a professional voiceover artist to record your message.

45. Customer testimonials – Collect these from satisfied customers and put them on your marketing materials.

46. Dancing mascot – Have someone dress up in a silly costume and wave a sign promoting your small business near a high-traffic street.

47. Social networking – Maintain a presence on Facebook, Twitter, or other internet social networks. Only join the ones that you'll have time to keep up with periodically.

48. Spotlight – Rent a big promotional searchlight for a few nights. These are very dramatic and can attract people from miles away.

The Right Way to Hold People Accountable

49. Bumper stickers – They're not just for your car. Bumper stickers can be placed in public spaces as a form of guerrilla marketing.

50. T-shirts – Create custom t-shirt with your company logo printed on them. Give them to your staff to wear, and they'll passively promote your company everywhere they go.

51. Say "thank you" – Follow up each purchase with a phone call, e-mail, or letter thanking the customer for their purchase.

52. Talk to the press – Reaching out to the media about your product (especially if it's of local interest or part of a popular movement) is a great idea.

53. Provide a tour – Offer a tour of your small business to local schools, and give the visiting students a souvenir. Many kids will discuss the tour with their parents, which is free advertising for you.

54. Produce a "how to" show – Book some airtime on local public access cable channels. You might still have to pay for the rental of some equipment, but public airtime is free. Be sure to promote the show in print or on your website, blog, or social media network.

6 Ways to Market Your Small Business for Less Than $100

55. Put on a demonstration – Demo your product for free at a related store or event.

56. Give back to the community- Volunteering or donating ensures that hundreds if not thousands of people will hear about your business. You can volunteer as part of a non-profit organization or offer your product or service to an event or fundraiser. Sponsoring or volunteering at a non-profit event both helps out your community and enhances your company's image.

57. Attend special events – Showing up to events that people invite you to can help to foster relationships and customer loyalty.

58. Sponsor an event - Support important events in your industry. Events where your clients or prospects go to learn, grow and socialize are excellent opportunities to promote your business.

59. Put on an in-house event – Hold an open house, business anniversary or product demo day. Invite your favorite customers and stage a visit by a local athlete, politician, news personality or sports mascot. Consider seeing if a non-profit or special interest group would like to hold an event in conjunction with your store.

60. Conduct a business forum – Put on a networking or educational event that will attract groups of potential customers.

61. Write a book or article – An informative publication about your specific area of expertise can help to cement your authority.

62. Write special reports, white pages, or an e-book – Electronic publications can be offered as an incentive to people who come to your website and provide their e-mail address.

63. Send out a press release – A press release is a great way to mark the occasion of new products, employees, or promotions. be sure to change up the formatting of each press release so that each one stands out. Always include employee quotes and images of what you are promoting; both are integral to any journalist picking up your press release.

64. Attend trade shows – Trade shows and other events are a great place to meet potential prospects.

65. After you receive a business card from someone, write any important details about them on the back as a reminder and reference point. Then follow up with that person later with a personalized message.

66. Create a blog – Use your company blog to provide interesting information and lead users to the rest of your site.

67. E-mail signature- Don't forget to put your website URL (and maybe a short tagline or message) in your e-mail signature. You'll promote your small business with every e-mail you send.

68. Submit articles to online magazines – Writing guest posts for blogs in your field is a great way to get your name out there.

69. Create a podcast or video podcast – Video and audio is a unique and compelling way to increase your web presence.

70. Comment on message boards and forums – Create posts on Internet forums related to your industry. Valuable comments can help attract appreciative prospects.

71. Host or attend an online event – Web seminars or conferences are a great opportunity to network.

72. Host a company gathering - A barbeque or group outing won't just make your employees happy. If they're permitted to bring friends or family, it may attract them to your business as well.

73. Holiday cards – Send your customers a promotional greeting card or e-card for the holidays.

74. Business partnerships – Form a bond with other small businesses in different industries. A mutually beneficial partnership lets you cross-promote and target the same market together.

75. Attend a "career day" – Volunteer to give a speech or presentation at a career day at an elementary, middle or high school.

76. Go green – Make your products or services eco-friendly. Advertise your environmentally safe practices, and people will respect you more for it.

77. Hire an ad agency or marketing firm – You may want to entrust your company's promotions to professionals outside of your own company. Be sure to do research and find a firm with the expertise you need

78. Offer free services to market leaders – Identify authoritative community leaders in your industry and offer them free products or services. They just might return the favor.

printwand

Junaid Tahir
www.DailyTenMinutes.com