How to Compress a Powerpoint file

More often than not I see people making a big Powerpoint presentation full of images they save it and its huge. 99% of the time the following fix can shrink your powerpoint file drastically and its also very simple to do.

1. In Powerpoint, select an image (it doesnt matter which) and then click the Picture format tools (on the toolbar).
2. Click Compress Picture
3. when the box comes up untick the "Apply only to this Picture" section and press ok, then save the image. you should now notice your powerpoint is significantly smaller. 

 For exmaple I did this to one the other day and shrunk it from 60mb to 4mb.

There are other options out there that will help with compression such as PPTminimizer however they usualy cost money!

How to Trouble shoot

If you have a problem and you need help you need to know exactly what to ask and what to look for.

so what you need to do is make a note of what happened, when it happened, what you were doing and any error messages. e.g.

"I was browsing the web and an error came up saying Adobe plugin has crashed and It restarted my browser"
is a million times more helpful than "my computers broken"

if you have an error number e.g. "program crashed error code 123456" you know what to look for, if it has a code it more than likely means its a known problem and there is a solution you can then search for that or pass it on to whoever is helping you fix your problem.

So remember just gather as much information as you can especially if someone is supporting you remotely (on the web over the phone etc) because they cant physically see your machine it's a lot harder to diagnose and fix the problems!

Happy Hunting
Dan!

Making a Backup Schedule

So you want to backup your companies data, and before now you've never thought about a proper backup routine?

Well there's a few things you need to work out;

• What are you backing up?
• How are you planning to do it?
• What are you backing up too?
• How long will it take?
• When are you going to do it?
• How often are you going to do it?
• Where are you going to store your backups?

What are you backing up?

Pretty simple question eh? well no not really. of cause you want all your important files backed up, your documents, work etc. but do you want to backup the system state of your servers? if your server died would it be easy for you to set it up again. and how long can you go without it. if you only have a small company you might simply want to backup the actual data rather than the server itself. It's important to workout how long you can go without a resource, the damage/costs incurred without that resource and how long it will take you to replace, repair or rebuild it.

How are you planning to do it? 

How do you plan to back it up, are you going to do it manually? run a script or invest in some software? This really all depends on what you are backing up and how much. If you want to backup a machine in its entirety then the best option would be to buy some backup software, but if you just want to backup some data you could run a script to copy it. Backup software is arguably more efficient and robust but it depends on the scope of your project, again its all about working out what you need to backup and hoe long you can go without it.

What are you backing up too?

If you know how much Data you plan to backup and how much you want to spend on a solution then this bit should be pretty easy for you. The simplest way to do a backup is to copy data to a device that you can then take away and store off site usually one or more Tapes. A tape drive itself and its associated software and media can cost anywhere from several hundreds to several thousands of pounds. a cheaper option that I've seen in place is to use high capacity flash drives or even external usb drives, but whatever you choose make sure you leave room for more data, if you want to backup 500gb, don't get something that only holds that, because over time you are going to get more data and thus use more space so leave room for growth.

How long will it take?

Assuming you know how much data you have, and how fast the backup media is you should be able to work it out but remember as in anything else things can often take longer than they seem. if files are locked or in use it can take a lot longer.

When are you going to do it?

The best time to backup your data is during periods of low activity, which usually means the evenings. you can usually avoid pesky problems like files being locked and doing it after everyone's gone means the chance of people complaining about performance issues is negligible.

How often are you going to do it?

What ever solution you choose its important to keep your backups regular, do you need to do them once a day? once a week? well this is something for you to workout. how often is your data accessed and whats the chances of data being permanently lost in between backups.

Where are you going to store your backups?

This is by far one of the most important choices you will make, you need to work out where to store your backup media. For example if you keep them in your office drawer and there's a fire you've more than likely lost not only your server but your backups too. the best practice is to keep your backups in a secure offsite location. whether that means keeping weekly tapes on site (again in a secure location like a fire proof safe) and having monthly and yearly tapes held off site that's up to you. If you don't want to buy an offsite safe or don't have anywhere to put it, there are some services that will collect, securely transport and store your backup media for you.

Other useful thoughts

Even if you have a Backup in place now, or know what you are going to do, remember to teach someone else how to do it, document it and keep that off site too. If you are the only one who knows how to restore the data and you are unavailable (injured, on Holiday, whatever) then you might as well not bother to do one in the first place!

Any thoughts questions of feedback would be great

Dan!

Open a 2007 or 2010 office file in Office 2003

This is quite a common problem with a very easy fix.

so someones sent you a document be it Excel, Word, PowerPoint, etc that's been made in a newer version of office and uses a different file type. what you need to do is download the Office Compatibility pack from Microsoft, after installing it and restarting any office applications you will be able to open the new file types (docx, xlsx, pptx,etc)

It is available direct from Microsoft Here

Jobs a good un!
Dan

I've forgotten my Wireless key

So you've forgotten what your wireless key is?

well its not so hard to get it back or reset it!

Firstly we need to check something, nowadays a lot of Wireless routers have a sticker on the side with the default wireless key, and sometimes the Routers logon details too!

So if you do have a key on the side of your router try that, if it doesn't work well not to worry following this post will help you reset it.

Now I want you to look at your router again we need to see who makes it and what model it is (note if its from BT it will more than likely be a home hub)

so for example you might have a Netgear 123456 (no thats not a real model no) from Sky Broadband.

Now I can't give you a list of all the default user names and passwords for every router but here's some of the most common ones, if yours isnt on the list google "Make, model, provider default username and password" e.g. Netgear 123456 Sky broadband default user name and password, if you know the login details skip this step!

Sky

Username:  admin

Password : sky

BT

Consult bt customer help( Here)  but its usually ;

Username : admin

Password : admin

Virgin Media

Virgin have gone through a few of them, so heres a couple:

Username: admin

Password: changeme

Username: admin

Password: pasword

Username: virgin

Password: password

TalkTalk

Username: admin

Password admin

So now we have your default login info we need to get onto the router, we need a computer that's already got access to your network which you should hopefully already have, if not plug a network cable from your router into your computer.

Now that that's done, I want you to do the following;

Press the startmenu button on your task bar, if you have windows Vista or 7 type run in the search box and when it finds it press ok.

If you have windows xp Press the Start menu and then click run.

now type cmd and press enter

the command prompt should now appear (pictured below)

type ipconfig and press enter you should get something similar to this:

now write down the Default gateway (in my example 132.147.160.7) this is the IP address of your router, load a web brower and in the address bar enter the IP address and press enter (note don't put www. or http:// or anything else just the number)

You should now be on the login page for your router.

so lets try out those default login details hopefully they should get you onto the router, if not we are going to have to reset it.

To reset your router usually there is somewhere on the back of the router a tiny hole marked reset, you will need a pin or an unfolded paper clip, push that into the whole to get to the hidden button, hold it down for at least 5 seconds and release it, this will reset your router to its defaults, from there try again to login to the router and you should be fine.

Now that you are onto the router you need to find out what your wireless key is and while we are here why don't we change your logon details to something a bit more secure.

Every router has a different interface so your going to have to find the settings but they are probably something like :

Wifi key

Wireless Router setup, Wireless, Security ( then note down the key in there)

Username and Password

Configuration, security, admin password (then change it to something you will remember).

Now all that's left to do is log off and put your wireless key in.

Jobs a good un!

Dan