Archive for the ‘Help’ Category

Does exactly what it says on the tin; just the posts that relate to the above...

A little birdie told me: Tweeting your way to success

Thursday, April 9th, 2009

Twitter is still taking the world by storm; one tweet at a time. And if you haven’t heard of it yet, it’s time to head to twitter.com and sign up. Twitter is for more than techno geeks. Twitter is for your ski chalet, your car hire company, your clients and your 10-year old cousin. Twitter is a tool that savvy businesses are using to increase business and recognition.

Tweeple are tweeting
Businesses are discovering a huge marketing vehicle in Twitter. The advantages appear to be obvious:
1. Instant. Your followers know what’s happening, when it happens.
2. Free. Who doesn’t like free advertising?
3. Trendy. Tweeting is the new ‘in’ and it isn’t going to fizzle out anytime soon.
4. Far-reaching. Your country cottage rental business needs a wide following. Twitter not only spans the globe. It covers it.

So who is using Twitter to boost their brand?
Umm. Everyone. Starbucks has been on there forever. Dell and Apple employees virtually live on Twitter. Certain airlines keep it casual with tweets like, “Airplanes can’t type so Sophie is responding / chatting with you!” And, of course, celebrities can get there 100,000+ followers to jump at a bland tweet like: “Retweet of the week: http://www.streetchildren.org.uk… a fine cause I reckon…”.

Using Twitter to promote business
Because of its instantaneous nature, Twitter is perfect for announcing promotions. Just remember these three rules: keep it short, keep it casual and keep it real time. Here’s what it may sound like: “Ski Chalet giving away 3 free weekends to 3 random tweeple here (include hyperlink)”. A tweet like this should encourage a mad rush toward your website; perfect. Or, you could try this: “Ski Chalet just posted amazing new pics” and again, include your website. All these extra site visitors mean you stand a chance of picking up new business. For a promotional discount tweet try something like, “25% discount on selected ski holidays now runs until the end of the month”.

Twips for tweets
To make Twitter work, you should know how to use it. Like learning a new language, you need to immerse yourself, and start practicing. Here are some tips:
1. It’s not a billboard. It’s a conversation. Don’t just post promotions; listen to others. Be interactive. Ask questions. Offer help.
2. Tweet tactfully. Hundreds of daily tweets or inane updates won’t impress anyone. Tweet with decorum; like a real conversation.
3. Don’t become absent. If you take a prolonged hiatus or quit, you’ll lose your following. Keep it up!
4. Make use of the Twitter applications to get the most from your tweeting.

Dip your toe in (or should that be talon) and tweet away my feathered friends… see what happens. Surely it can’t harm.

Mixd Excels

Tuesday, February 24th, 2009

As an organisation, Mixd is always keen to help others… and today is no exception. Based on the results of important scientific research (Bob closely watching Phil this morning and chuckling), this could save you from days of stress and sleepless nights of worry.

So here it is, the simple process of merging 2 (two) columns of data into 1 (one) using the Microsoft product ‘Excel’. Step one can be omitted as you see fit, but can be fun.

Step One
Watch colleague pull own hair out for up to 90 minutes (longer than this is just not on), trying to work out how to do it.

Step Two
Assuming the data to be merged sits in columns A and B, select column C and choose Insert > Column to insert a new (blank) column C.

Step Three
Assuming that data starts in row 2 (allowing for your headings), whack one of the following formulae into cell C2.

To hyphenate the merged data
=A2&”-”&B2

To merge with a space between the data
=A2&” “&B2

Step Four
Copy the formula as far down column C as needed (by dragging the bottom right corner of the C2 cell).

Step Five (the magic bit!)
Next, select the entire column C; choose Edit > Copy; then Edit > Paste Special; then Values and OK. This pastes the cell contents (not the formulae) back into column C.

Step Six
You can now simply delete columns A and B; easy.

Please send thank you cards to the usual address.

Mixd accepts no liability if this doesn’t work for you; apologies.