Category Archives: How to

What do do if you fail to save before you close PowerPoint

What happens when you say “No” to your “Save” reminder when you close a program like PowerPoint to quickly?

Well, as it happened to me today, I can tell you, I felt SICK! and a bit light headed. You might have lost hours of work, or that last great diagram you painstakingly drew by hand.

Well, there is still a small chance that your lovely auto-save has a version from a few minutes ago and has not deleted it yet.

So, before you let rip with a barage of expletives in-front of your colleagues try this final go.

Step 1

On the top ribbon, choose “File”, then select “Options”

Pptx Recovery - Step 1

Step 2

Down the left hand side find the 3rd option called “Save” and select

Pptx Recovery - Step 2&3

Step 3

Find the label “AutoRecover file location:”. It will contain a file path, something most like this –> C:UsersAppDataRoamingMicrosoftPowerPoint

Step 4

Copy this out, paste into the top of Windows Explorer and you will find a mish-match of non-deleted versions of your work.

Step 5

Look at the files for a similar file name. Likely the first part the same, followed by lots of numbers. Check the timestamp and if it is in the previous 10 minutes you may be able to stop crying and carry on with your day!

Hope it helps.

Note: I am on Windows 7 and PowerPoint 2010.

How to change url behind the logo in WordPress

If you are running a blog alongside the main site or using wordpress to run in a subdomain you may want to update the standard logo click from returning a usage to the blog homepage to another location.

If you have a regular WordPress setup you can hack this together quite quickly.

Don’t forget to copy the contents to somewhere safe just in case you have a keyboard slip!

Follow these simple steps:-

  • In “Appearance”, choose “Editor”
  • From the right hand-side find the file called “header.php”
  • Use control+F [cmd+F for you pesky Mac users] to find
    <a href="'; bloginfo('url'); echo '/">
  • change it to
    <a href="HTTP://WWW.EXAMPLE.COM/">
    • However, if you update your theme you may loose your personal hacks/updates. If you clever and need to make many alterations, you should look into Child Themes, but that is for another day. Hope that helps a little.

How to put an embed code box in your post

If you need to use an embed code section on your site to get this effect. This is example embed code from a live example infographic we recently put lived.


To embed our infographic/image/assets to your wordpress blog or site, simply just cut and paste the code below:


You need to use a few different tags and attributes including

  • textarea to get the box
  • cols and rows for the width and height of the textarea
  • onclick for how to select all the text
  • And the usual stuff for the image source and links

Your code will look something like this:

<textarea id="copytext" cols="60" rows="5" onclick="SelectAll('copytext'); pageTracker._trackEvent(['Infographics', 'copy_share', 'embed_code']);">
<a href="http://example.com"><img src="http://images.example.com/infographic_lq.jpg" alt="Alt text" width="490px" height="4605px" border="0"></a>
<p>Made by My Company with credits and maybe a link.</p>
</textarea>

Hope that helps. We all learn through doing!

How to use the Google WMT crawl data – once you fix the date format!

The crawl data that you can download from Google’s Webmaster Central Tool would be much more useful IF you could arrange the data by date. You can’t pivot or sort data if the data is [first of all] in American date format, and 2ndly some is in date format, some in text format and some just throws an error.

So, how do you cleanse this data?

Step 1 – download your crawl data

Click on the “Download” option inside in Google’s webmaster tools interface

Step 2 – Open excel and import your data as “From Text”

Here is the advice from the Excel help file

Importing text files
You can use Excel to import data from a text file into a worksheet. (On the Data tab, in the Get External Data group, click From Text.) The Text Import Wizard examines the text file that you are importing and helps you ensure that the data is imported in the way that you want.

There are two ways to import data from a text file by using Excel: You can open the text file in Excel (which does not make a connection to the text file), or you can import the text file as an external data range (which does make a connection to the text file).

There are two commonly used text file formats:
Delimited text files (.txt), in which the TAB character (ASCII character code 009) usually separates each field of text.
Comma-separated values (CSV) text files (.csv), in which the comma character (,) usually separates each field of text.

You can also change the separator character that is used in both delimited and .csv text files. This may be necessary to make sure that the import or export operation works the way that you want it to.

You will be importing a .csv

Step 3 – Use the Text Import wizard

Use the Text Import Wizard. I have never had to make any changes on the first step.

On step 2 of 3, you should choose COMMA and not Tab.

Here is the important bit. On step 3 of 3 you can choose what is the format for the import. So, in the “Data Preview” pane, scroll to the right. Select the Date column and choose your preferred date format (see arrow).

Excel's Text Import Wizard - choosing data type

Excel's Text Import Wizard - choosing data type

Click Finish. Select the location you want your new table.

You would think that you would now be finished! No, Google also give us 2 date format

3/01/12
03/01/2012

Standarding the year format

I am sure that there must be an easier way than this, please share if you know. You can’t just format cells to date. So, insert some new columns to the right of the date column.

  1. Hightlight the Date column. Select “Text to Columns” on the “Data” tab
  2. In the wizard, choose to seperate by “other”, enter a slash “/”.
  3. Now use the good old fashioned “Find and replace”. Replace “12” with “2012”, then find all the accidentally created “202012” and replace with “2012”. And repeat if you still have 2011 data in there
  4. Then just Concatenate the 3 columns back together using this formula structure (assume in columns 1,2 and 3 and use the text insert of a slash inbetween quotation marks)
  5. =CONCATENATE(a1,”/”,a2,”/”,a3)

  6. Double click on the bottom right hand corner of the cell to copy all the way down
  7. Copy the resultant column, “Paste Special” next to it as “Values only”
  8. Delete the rest of the working columns

You are now ready to actually use your own data. Google please help us!

However, there are still bad data and formats in the data. So, I always prefer server side tools.

How to screenshot on an android phone

The other day I accidentally managed to take a screenshot on my Samsung Galaxy (orginal). So, I thought I would share that information here as I couldnt find this previously when I was searched.

If it makes a difference I am running –> Model: GT-19000. Firmware:2.3.3

How to take a screenshot on a Samsung Galaxy mobile phone

  1. Press the “back-up” button similataneously with the “home” button
  2. Wait. There is a second delay
  3. You will see a short, and quick confirmation message saying that the image is in your gallery
  4. Go to your gallery and you will find your screengrabs in a new folder it creates called “Screen capture”. It may take 5 secs for the folder to appear the first time. So be patient!

In-case you don’t know what the home and backup buttons are – here is a handy reminder.

Screenshot function on Android Samsung Galaxy

Screenshot function on Android Samsung Galaxy

As simple as that.

I am sure that other manufacturers or hardware behave differently. But anyway, that’s my experience.

How does the internet work (simple version)

One of my roles as I see it is to demystify SEO, web and internet & marketing technologies. So, I will try to do this one justice too.

First of all, lets define the internet. According to Wikipedia:

The Internet is a global system of interconnected computer networks that use the standard Internet protocol suite (TCP/IP) to serve billions of users worldwide.

So, that is quote full of jargon. This is basically the infrastructure that connects our computers, servers and any other device that uses data. And to use the words correctly the Web is mainly about the sites you use, HTML etc etc.

The geeky bit (simple version)

  • Your computer connects to your router (aka modem) either via a cable or your wifi
  • Your router via your phone line connects to the internet via your internet service provider (ISP)
  • Your browser (e.g. chrome, firefox, safari) requests a web page via its URL
  • Web sites work on the http protocol and then the servers name. e.g. http, and then www.adrianland.co.uk
  • Your browser on your computer via your ISP uses a Domain Name Server (DNS), like a list of all website names registered. The DNS returns the websites real name which is in IP address. IP addresses are in IPv4 format are in a set of 4 numbers separated by a point e.g.192.168.100.100
  • So, your request is now at the right server now. The server hears your request for a URL, sends the information back in small pieces “packets” via the quickest route and your computer puts it back together and compiles the pages inside your browser. That is what you see in your browser and reading this page

Hope that makes sense! And inside that you may want to know what server response codes.

Most of this all happens in less than a blink of an eye – clever hey.