Archive for the ‘Help’ Category
Does exactly what it says on the tin; just the posts that relate to the above...
Do I need a mobile strategy?
Why mobile?
The way we use the web is changing. Gone are the days of a fixed PC where you went to ‘surf’ the web for an hour or so after you’d popped the kids to bed. Instead, we are now able to view the web almost whenever and wherever we want utilising a whole host of devices available to the modern web user; Android, BlackBerry, iPad, iPhone, Kindle, PlayBook… and so the list goes on.
Mobile usage stats
The stats below are taken from Boagworld, the blog of web strategist Paul Boag (March 2011), and from a post by David Hillis on CMS wire (Feb 2011).
- There are over 5 billion mobile phone subscribers throughout the world (73% of the population!) and of this figure, over 1 billion use smartphones
- Projections forecast that mobile internet usage will overtake desktop internet usage by 2014
- 50% of all local searches are executed on a mobile device
- On average, we spend 2.7 hours per day on our mobile devices
- More than 200 million Facebook users use Facebook for mobile and they are more active than desktop users
- 40% of all Twitter traffic is mobile (circa 60 million interactions per day)
- Over 200 million YouTube views occur on mobile devices every single day
- Over 10 billion iPhone Apps have been downloaded
- Mobile data consumption has risen 400% over the last 2 years
- The younger generation send an average of 3,400 text messages per month
Blimey! It’s pretty obvious that mobile internet usage is on the up and some leading industry figures report that it is growing ten times faster than the world wide web ever did!
To quote Paul Boag:
“The figure that grabs my attention the most (and should yours) is that the number of people accessing the web via mobile devices will surpass the number accessing via desktop users by 2014. That is only 3 years! Time to sort out your mobile strategy now.”
I like words, but show me pictures…
The infographic from Microsoft Tag below is a great representation of current mobile usage (early 2011) that illustrates why it commands respect and needs to be taken seriously by everyone and not just digital marketers.
Do these stats blow your mind, like they do mine?
Do you have a mobile strategy? Do you think you need one?
Let us know what you think below.
Mixd Excels
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.