There are numerous ways a business can build a brand and ultimately grow. One of the most popular tools to help with this is social media, of which there are numerous services. The newest social media service is Pinterest which is dedicated to the sharing of images. Pinterest has recently been updated with a new layout and features that businesses with profiles will benefit from.

Here's a brief overview of the new features introduced with Pinterest's recent layout changes.

How to get the new layout

Before you can use these features, it would be a good idea to upgrade to the new layout. While, like other social media services, this will be happening automatically over time. Unlike other platforms, the new layout is available for all users to switch to when they feel ready, however when you switch to the new layout, you will not be able to go back to the old one. Here's how you can switch:

1. Log in to Pinterest.
2. Hover your mouse over your profile/business name at the top-right of your profile.
3. Click Switch to the New Look.
4. Select Get it Now. Note: If you press this, you likely won't be able to switch back to the old layout.
5. Press Okay from the Welcome to your new look! pop-up window.

When the new layout loads, you'll notice that the pins are bigger, the category button has been moved to the left side of the profile beside the Search bar. You'll also notice that the comment button has been moved from the pins, you can access it by clicking on the image. On top of cosmetic changes, two useful functions that businesses will find beneficial.

Discovery

Now, when you look at an individual pin (click on the image), you will notice a number of changes.

• You can see all pins on the same board.
• You'll also see pins from the same website. For example if you pin something from a restaurant, you'll now see similar pins from the same website.
• Most importantly, you'll now be able to see what other people have pinned along with the same image.

This will make it easier for users to discover what other people are pinning. For your business this means potentially higher exposure. Think of this as something similar to the way Facebook works: If a person likes you, the chances of this like showing on their friend's profile, and that friend visiting your Page is higher. It's kind of like easy brand exposure.

Analytics

Arguably the most useful feature added recently is Pinterest Analytics, which allows you to see if your pins are being clicked on or shared, and the general success of your activities. This will go a long way in helping you determine the overall success of your Pinterest oriented efforts.

The main caveat with this is that your profile/business's website needs to be verified and connected with your profile. If you have an unofficial Pinterest account, you can change it to a business one by:

1. Logging into your Pinterest account and going to business.pinterest.com.
2. Pressing Convert your existing account and choose your type of business.
3. Entering the relevant account information like the name of your business, address and website.
4. Agreeing to the new Terms of Service.

If you would like to have a new username or account simply go to http://business.pinterest.com/ and press Join as a Business. You will be asked to set your account information, username, etc. You will need to verify your account which will involve you having to download a file and upload it to the server that hosts your website. We, or your web hoster can help you with that.

After your account is verified, you will notice that if you hover your mouse over your account name a drop-down list should pop up with Analytics being about half way down. Click on that to be taken to the section.

This section will display a bunch of graphs including:

• The number of daily pins and pinners on your site.
• The number of re-pins you have done.
• How many times your content has been repinned.
• The number of clicks and website visits.
• The most clicked and repinned pins.
• The number of times your pins have been seen.

Overall, Analytics is a useful tool that will give you a clear picture of what is working and what isn't. If you pinned a picture of a dog and noticed that it got zero pins while another got hundreds, it may be a good idea to create/look for more similar content.

If you are looking to integrate Pinterest into your business's social media strategy or would like or learn more about how to use the service, please contact us today.

 

Customers expect that you have a phone number, which usually means a big investment into an often inefficient system that is limited and run by various phone companies. There is an alternative however: Voice over Internet Protocol (VoIP). VoIP has become popular amongst companies, and could be a viable alternative to existing systems.

The question many business owners ask is: Can it bring any benefits to my business? In short, yes, it can. Here are five benefits of VoIP.

1. Automation Most VoIP systems can be easily configured to route calls to numbers without the need of an expensive switchboard. This means that you could route calls to your mobile phone when you are out of the office.

Any good phone system offers callers the ability to leave messages. Some VoIP systems can take voicemail messages and turn them into emails, which makes it easier for you to track and reply to these messages.

2. Larger appearance Solid VoIP systems allow you to have different numbers that can route into one branch. For example, if you have a presence in four states, you can set a local number in each state and when users call, they are automatically routed to your office.

By having a local presence, many customers will think your business is bigger than it really is, and may be more trusting. Similarly, you can also assign numbers to different 'departments' that get routed to one phone. This is a great way of making your company seem bigger and more reliable.

3. Features With most traditional phone services, you have to pay extra for features like all display, extra numbers, call monitoring, etc. VoIP systems often include these features and more at little to no extra cost.

4. Savings As VoIP uses your Internet connection, calls are not geographically routed which means that a phone call that would normally be considered long distance, isn't on VoIP. This translates to lower phone bills. These systems don't require complex infrastructure and wiring that traditional phone systems do. Existing phones can be easily integrated into VoIP systems with a small piece of hardware, meaning you won't need to invest in new hardware.

5. It's scalable It is easy to add numbers and phones to any VoIP system. This means that when you hire new employees, you can quickly (often in as little as three minutes) and easily assign them a number and a phone at little to no cost. This means that as you grow, the system grows with you.

If you are looking to update your current phone system or save money, please contact us today. We may have the VoIP solution that fits your business needs.

Myths have always been a part of human culture, and can be found in nearly every aspect of life, including the computer. One of the larger computer-based myths revolves around malware, more specifically the virus. Many users are familiar with the concept but have a tough time distinguishing between what is true and what isn't. Are you one of them?

Here are five common myths about viruses that confuse people, and the truths associated with them. Before we delve deeper it would be a good idea to explain what a virus is.

A virus is a computer program that infects a computer and can generally copy itself and infect other computers. Most viruses aim to cause havoc by either deleting important files or rendering a computer inoperable. Most viruses have to be installed by the user, and usually come hidden as programs, browser plugins, etc.

You may hear the term malware used interchangeably with virus. Malware is short for malicious software and is more of an umbrella term that covers any software that aims to cause harm. A virus is simply a type of malware.

Myth 1: Error messages = virus A common thought many have when their computer shows an error message is that they must have a virus. In truth, bugs in the software, a faulty hard drive, memory or even issues with your virus scanner are more likely the cause. The same goes with if your computer crashes, it likely could be because of something other than a virus.

When you do see error messages, or your computer crashes while trying to run a program or open a file, you should scan for viruses, just to rule it out.

Myth 2: Computers can infect themselves It's not uncommon to have clients bring their computers to a techie exclaiming that a virus has magically appeared on the system all by itself. Despite what some may believe, viruses cannot infect computers by themselves. Users have to physically open an infected program, or visit a site that hosts the virus and download it.

To minimize the chance of being infected you should steer clear of any adult oriented sites - they are often loaded with viruses, torrent sites, etc. A good rule of thumb is: If the site has illegal or 'adult' content, it likely has viruses that can and will infect your system if visited, or files downloaded from there.

Myth 3: Only PCs can get viruses If you read the news, you likely know that many of the big viruses and malware infect mostly systems running Windows. This has led users to believe that other systems like Apple's OS X are virus free.

The truth of the matter is: All systems could be infected by a virus, it's just that the vast majority of them are written to target Windows machines. This is because most computers run Windows. That being said, there is an increasing number of threats to OS X and Linux, as these systems are becoming more popular. If this trend keeps up, we will see an exponential rise in the number of viruses infecting these systems.

Myth 4: If I reinstall Windows and copy all my old files over, I'll be ok Some believe that if their system has been infected, they can simply copy their files onto a hard drive, or backup solution, reinstall Windows and then copy their files back and the virus will be gone.

To be honest, wiping your hard drive and reinstalling Windows will normally get rid of any viruses. However, if the virus is in the files you backed up, your computer will be infected when you move the files back and open them. The key here is that if your system is infected, you need to scan the files and remove the virus before you put them back onto your system.

Myth 5: Firewalls protect networks from viruses Windows comes with a firewall built into the OS, and many users have been somewhat misled as to what it actually does, and that firewalls can protect from viruses. That's actually a half truth. Firewalls are actually for network traffic, their main job is to keep networks and computers connected to the network secure; they don't scan for viruses.

Where they could help is if a virus is sending data to a computer outside of your network. In theory, a firewall will pick up this traffic and alert you to it, or stop the flow of data outright. Some of the bigger viruses actually turn off the firewall, rendering your whole network open to malware attacks.

What can I do? There are many things you can do to minimize the chances of infection. The most important is to install a virus scanner on all of your systems, keep it up to date and run it regularly. But a defensive strategy like this isn't enough, you need to be proactive by:

• Not installing programs from sources you don't know or trust
• Being weary of any program that asks you for your password
• Not installing any browser add-ons or plugins suggested by websites. Instead, download them from the browser's app store, or the developer's website.

If you are worried about the security of your systems and network, call us today. Our team of security experts can work with you to provide a plan that will meet your needs.

Think back to the last time you received an important email, only to be confused or unsure of what exactly the sender wanted. Emails like these have become near commonplace, and can negatively influence our productivity. There are a number of things you can do to mitigate this however, the most important revolves around writing good emails.

Here's six tips that can help ensure that the emails you send get your message across. By writing quality emails, you could see your productivity increase as you will have more time to do your work instead of clarifying sloppy emails.

1. Have a clear decision or action 99% of the emails you send are to ask someone to take an action, make a decision, reply etc. So, before you write any email pause for a minute and ask yourself: Why am I writing this and what do I want the recipient to do with this email?

If you can't provide a clear answer to these two questions, you may want to try contacting the recipient through another medium, or take some time to think and come up with an answer.

2. Write it backwards Once you know why you are writing your email, the actual writing becomes a lot easier. Because you will most likely be asking the recipient to do something, why not start with the request. Simply write down, in clear English, what you want done.

It's important to be as clear and direct as possible to avoid any confusion and potential follow up emails that will distract you. Once you have stated what you want, then you can provide justification to your request, or background information.

The reason this works is because many business owners/managers/employees are busy, they don't have time to read a whole report's worth of information that ends with a request. Most of the time they will just skip to the end anyways, so why not put the most important part - the action that you want them to take - at the beginning.

3. Use lists Many poorly written emails aren't actually poorly written. They are just formatted in an inefficient manner. In most English classes, students are taught to develop their ideas or arguments through logical paragraphs, while having only one point to each paragraph. Pause for a minute and think: If you get an email asking you to make a decision on what product to buy with five paragraphs each talking about a benefit or reason, would you actually read the whole email? Chances are the answer is no.

To be more efficient, break your ideas/reasons/arguments into a list. You can usually summarize the majority of main ideas of each paragraph into a single sentence. This makes them easier for you and the recipient to read.

4. KISS We don't mean you should kiss your monitor. In this context, KISS stands for Keep It Simple and Straightforward. You shouldn't have long essays or arguments with lots of padding. Get to the point immediately and provide the essential information.

If you find yourself writing an essay or long report, email is not the medium you should be using. Instead put your thoughts into a word document that you attach to the email. In the email itself put a brief overview along with the most important points and tell your recipient to check the attachment for more information.

5. Have a relevant subject line The subject of your email is like the title of a report or news article. Without a solid subject, the chances of your email being opened and read are low. It would be a good idea to write your whole email first, then the subject.

A good subject line can A) Interest the recipient enough to get them to open it and B) Provide enough insight so the reader can infer what you want. If you look over a subject line of an email you are about to send and see that it doesn't make sense or reference the email itself, it would be a good idea to re-write it.

6. Proofread everything This may make sense now, but we are all guilty of writing an email and pressing send without reading the content over. Once you hit send, the damage is done, you won't be able to get the email back. That's why it's a good idea to read over your email after you finish.

You should look for any obvious spelling and grammar errors along with ensuring that the content makes sense. If you think it's ok, then you can probably go ahead and send it. If you are the least bit hesitant, walk away from it for a few minutes then come back and read over it again. You will likely be able to see a couple of changes.

There are many options at your disposal that allow you to enhance your and your company's productivity. Contact us today to see how our systems can help.

Most small to medium businesses operate on razor-thin margins, with managers and owners on the lookout for ways to minimize costs in hopes of maximizing the bottom line. There are many ways to cut costs, and one area to look at could be your technology. As you likely know, technology isn't cheap, but there is always a way to keep expenses down.

Here are five ways you can reduce IT spending.

Backup everything If your business is like most other small to medium companies, the majority of your important files are located on one server or maybe a couple of computers. Technology doesn't last forever and the machine where you have your data stored on will eventually stop working.

When it does, you will have to replace it, and your files that were on it could be lost. The cost to recover them will be high. To minimize this risk, you should invest in a solid backup platform that runs on a regular basis.

Yes, this will cost money now, but would you rather have a copy of your systems and data from Yesterday which can be easily implemented when you have a problem, or would you like to pay to maybe recover year's worth of data? Backups will save you costs in the long-run, not to mention the stress they will help you avoid.

Have a strict anti virus policy The idea that your employees won't download programs or browser extensions simply because you tell them not to is like telling a child not to eat candy; they are still going to do it. By simply having computers and devices accessing the Internet through your network, you are at risk. If your systems are hacked or infected, you can face lost data, high recovery costs or worse.

How do you minimize the chance of malware infections and the risk of being hacked? Antivirus software and security solutions installed on every computer that can be run from one machine are your answer. This makes it easier for you or your IT partner to ensure all of your systems' antivirus software is up to date and scanning when it should be. This will minimize the chance of infection and keep costs down.

Document everything As your company grows, you will start to use more technology. Over time, it will need to be replaced, and you likely won't be able to afford replacing all your systems at once. This means that you will have to track down the systems, software, etc. that need to be replaced; which will take time and cost you money.

If you take steps to document all of your systems, computers, software, etc.; where it's located; when it was implemented; who is in charge of it, etc., you will be able to track things down quickly when needed, thus managing your systems better. This time saving measure will cut your costs.

Look into a CRM/ERP/HRM solution There are so many software solutions out there that can help you plan and run your operations. If you've been tracking employee data or planning using a simple spreadsheet, you could be getting more out of a tailored solution.

Solutions like Enterprise Resource Planning (ERP), Customer Relationship Management (CRM) or even Human Resources Management (HRM) can help you spot hidden costs or even plan more efficiently, which will reduce costs well into the future.

Look for fixed-price solutions A major problem with all technology related systems is that predicting costs is nearly impossible. You simply don't know when/if an important piece of hardware will fail. This becomes even harder if you don't have expertise in tech.

One of the best ways to save money on IT costs is to outsource. Almost every IT provider offers flat-rate services that cover your systems and can ensure you maximize your IT investment. This makes budgeting for IT easier, as you know what your monthly costs will be. You can then focus on your business, and over time will see a decrease in IT costs.

If you are looking to cut your IT expenses, why not contact us. We may have a solution that will ease the budget burden.

Imagine getting off a plane after a long trip home from an eventful conference. You reach for your trusty iPhone, press the power button hoping to see the comforting glow of your near constant companion, but all you get is a black screen. Your iPhone won't turn on. Do you know what to do if this happens to you?

Here are four things you can try when your iPhone won't turn on.

1. Charge it with a wall charger One of the main reasons your iPhone won't start is because its battery is dead. Before you deem the battery 'dead', you should check if the phone is on. Press and hold the power button for up to five seconds. Chances are, the phone has just gone to sleep. If this is the case, you should see the unlock screen pop-up after a few seconds.

If it doesn't pop up, your phone is likely dead. All you have to do is plug it in, preferably to a wall charger. Your phone should turn on automatically after a few minutes (up to five). If it doesn't, let it charge for around 15 minutes before trying to turn it on. If it does turn on, it would be a good idea to let it fully charge.

2. It's charged but still won't turn on Like all operating systems, the one on the iPhone will crash from time to time. If it does crash, you shouldn't lose any data unless you were in the middle of downloading or uploading files. These will have to be started again.

If pressing the power button doesn't turn the phone on, you should still plug it in and let it charge for 15 minutes. Then conduct what's called a hard reset:

1. Unplug your device.
2. Press the Home and Power buttons for 10-20 seconds until you see the Apple logo.
3. Let the device run for a minute or so and you should be able to use it again.

It would be a good idea to not do this while the phone is connected to your computer.Your computer may recognize your phone's hard drive and start automatically syncing through iTunes. Doing a hard reset when the device is syncing may result in losing information.

3. A hard reset won't work Another good thing to consider at this stage is switching cords. Chances are someone next to you has another iPhone cable. Borrow it and try the first two steps again. These cables aren't the most damage resistant thing in the world and have been known to wear out or fray at weak points rendering them useless. If you were trying to charge your phone through a wall charger, try again but this time connect it to your computer - make sure it's on.

4. It's truly dead If after trying different cables and charging methods, hard resetting and charging for a couple of hours your device still won't turn on, you have one option left. Go to an Apple store, or reseller. They may be able to get your iPhone working, or at the very least will to confirm the problem.

Sometimes the phones display a USB cord with an arrow pointing to the iTunes icon. This is your iPhone's way of telling you that something has gone wrong with the software and it needs to be plugged into your computer and connected to iTunes. If you see this, you will likely have to reset your phone which means you will lose everything stored on the hard drive. If you have been backing up your phone, however, your data loss will be minimal.

Has your iPhone stopped working? Are you unsure if your backup solutions are enough to keep all of your files safe? Contact us today as we may be able to help.

When it comes to technology, trends are abound. It seems that nearly every month there's some new trend introduced that businesses absolutely must adopt. One trend that has proven to be beneficial to many businesses is virtualization. One of the more popular virtualizations is of the desktop, which enables users to access it from nearly anywhere. VMware, a company well-known for its virtualization services, has released a new product that makes it easy to view your desktop on your mobile device.

In mid-March, VMware announced Unity Touch, an app that allows users to view, open, run and manage Windows files and applications on their Android and iOS devices.

What exactly is Unity Touch This app takes your existing Windows desktop and makes it more manageable and easier to use on mobile devices. This feature is part of the Horizon View offering from VMware which allows administrators to virtualize the desktop environment, and users to access their desktop from anywhere.

Unity Touch takes Horizon View desktops and makes them easier to use on a touchscreen device. When it's introduced, you will be able to log in to your desktop and access your files and applications.

How does Unity Touch improve desktop access on mobile devices? One of the most important parts of the Windows environment is the Start menu. It's what the majority of users use to access their files and run applications. On mobile devices that connect to a virtual desktop, space is limited, so having a full start menu just doesn't cut it. This app essentially makes the Start menu an 'app drawer' on the left-hand side of your screen - think of any screen where you can select apps on your mobile device.

There's a little tab, located in the middle part of the left-hand side of the screen that you can press to bring up a list of files and apps that you can scroll through. This list also functions as a kind of launch center where you can switch between open programs, close them or even manage files.

Will my business find it useful? If you travel lots, or have to be away from your computer and don't want to carry a laptop with you, this could be a solution for you. You do need to have a VMware Horizon View Desktop version 5.2, the Horizon View Client 2.0 installed on your mobile device, as well as an Android, iPad or iPhone.

If you are interested in accessing your desktop from a mobile device, contact us today. We can work with you to develop a solution.

What exactly is data? Many define it as a set of values that belong to a set of items. Essentially, data is all around us, and we use it on a daily basis. Data, by itself is largely useless - think of the last time you saw a spreadsheet without any labels. But through the use of tools that help us analyze, interpret and manipulate data, we are able to turn it into something useful: Information. The question is, what are the useful data analysis tools?

Here's a brief overview of five data analysis tools that you could use in your business.

BigML

One of the more common uses of data is to help a business manager make predictions. We all know predictions are among the hardest things to do. Enterprises hire staff and invest in systems solely with the aim of making predictions. If you're a small business, you likely don't need expensive software that is hard to use.

Enter BigML. How it works is you define and upload a set of data and format it. BigML will then take that data, help you to create a prediction model which you then can apply 'what-if' variables to and have it generate predictions. The site runs on credits; you pay for a set amount of credits and each part of the process - dataset, model and prediction - is worth a certain amount of credits. Prices start at around USD$6.50 for credits, which gives you 10MB of data, 5MB worth of models and 10K predictions based on this data.

Wolfram|Alpha's Facebook Reports

WolframAlpha is a search engine that collects data and uses algorithms to interpret it. One feature of this site is that you can develop reports, one of the more useful being Facebook Reports. You can access the report feature by clicking here. Alternatively, you can go to the WolframAlpha website and search for Facebook.

This report provides users with a glimpse into their Facebook Page's information. It provides you with information on who are the most active posters, how many shares/likes, etc. you get and other useful information in easy to read charts and graphs. The key here is that the report can show you how customers access your Page and where they come from. You could use this information to see what posts users liked and didn't like, and provide more engaging content.

The basic version of the report is free. More advanced controls and data analysis is available for USD$4.99 a month.

Many Eyes

Many Eyes is a data analysis and visualization tool developed by IBM Research. If you already have data sets then you can upload them to the website and use one of the many different visualization tools to create charts, graphs, etc.

A cool feature of this site is that it has the ability to analyze written documents. Say for example you are writing new content for your website, you can copy and paste the content and get a visual representation of the words you use, how you connect words, etc. If you have a set of keywords you would like to use for SEO and search purposes, you can manually compare them with the visualization. If you notice that an important keyword is missing, or not represented enough, you can go through and re-write the copy a bit.

Best of all, it's free.

Tableau Public

If you have an idea about Business Intelligence, or have worked with data on a regular basis and have sets that are structured, Tableau Public is probably the most powerful free analysis tool available for small businesses.

While powerful, it isn't the most user-friendly of options. To get the most out of this program you are going to need to know the basics behind data analysis. If you feel comfortable with the basics, you'll be creating dashboards, charts, interactive graphs, maps, etc. that look great and can be embedded on your blog or website. Oh yes, did we mention it's free?

Excel

Big data is all the rage these days, it's hard not to hear techies and data specialists talk about it. While it is an important part of many large businesses' data analysis practices, the truth is many small businesses don't need big data just yet. If you have simple data you need to analyze e.g., how many hours have your five employees worked this month? Why not stick with simple spreadsheets like Excel or Google Spreadsheet.

As long as you have data entered in a logical way, you can easily create graphs and charts that can help you visualize and analyze your data.

If you would like help establishing a system that can help you track and analyze your data, please contact us today, we may have a solution that works for you.

Tablets are highly portable and powerful mobile devices that have caught the attention of many business owners and managers. The most popular tablet has to be the iPad, which is seen nearly everywhere these days. One of the reasons it's so popular is that you can connect to 3G networks and be connected wherever you go. One problem is the networks vary in terms of coverage, so how can you tell which is best?

Here's two ways you can figure out the areas covered by various wireless providers so you can get the most out of your data connection on your iPad.

Within the USA If you live in the US, you can install an app called Coverage. This app is a map of the United States that shows the network coverage of the major network providers - AT&T, Verizon, Sprint and T-Mobile.

When you install and open the app, you will be presented with a map and a panel where you can search for cities or your current location. You can also select which networks to show. The map covers all of the US including Hawaii, Alaska, US Virgin Islands and Puerto Rico, which makes it ideal for business users who travel throughout the US.

Because this app doesn't require an Internet connection, the data isn't 100% accurate, but from tests, it looks to be accurate enough for most users. USD$2.99 from iTunes.

Rest of the world If you aren't in the US, don't worry. Check out OpenSignal, a website that keeps an up-to-date map of wireless coverage around the world. You can search for 2G, 3G and 4G signal strength using an address or by selecting a country and city.

The map displays what OpenSignal calls a heat map - it's the signal strength in the area you are looking at. It will also show the NetworkRank based on the strongest signal of the providers. For example, select Sydney as your city and Australia as your country, and zoom into the North Sydney. You'll see that the map is covered in a haze that goes from blue to red. Blue indicates weak signal strength, while red represents strong. You'll also notice that Telstra Mobile is the strongest provider in this area.

This site can help you pinpoint which carrier to go with, based on your local area. It is also a good way to see if your provider has signal where you may be travelling.

A word of warning If you do have a data plan for your iPad, and plan to be traveling outside of your current location, it would be a good idea to consult the map or OpenSignal before you leave. There has been many stories of iPad users leaving their data plan on while traveling out of state or country, and receiving shockingly high mobile bills.

This is because if you leave your iPad connected to Data, it will connect to any compatible network e.g., AT&T users in the US will automatically connect to Rogers Wireless if they go to Canada. This is commonly referred to as roaming, and many networks charge extra for this. When traveling, it may be a good idea to just turn off your iPad's data connection.

You can turn your data connection off by:

1. Opening your iPad's Settings app by pressing the icon with the gears.
2. Tapping on Cellular Data which will be located on the right-hand menu bar.
3. Sliding the bar beside Cellular Data to Off.

If you are looking to integrate the iPad into your business, and would like help setting it up, please contact us today.

Think back to the last PowerPoint presentation you saw. Did it have charts, graphs or other figures obviously from Excel spreadsheets? Were they good? It's not uncommon to see presentations with weak graphs, which can lead to the audience losing attention. While it may seem hard to get a good-looking graph into PowerPoint, it actually isn't.

Here's how you can take data from spreadsheets in Excel and turn it into graphs and charts in PowerPoint.

Before you start

Before you can transfer data from Excel, you should take a look at the spreadsheet. If you have a ton of data and only want to take a certain chunk to make your graph, it would be best to copy and paste it into a new Excel workbook. This way, you can get the data from Excel to PowerPoint easily and turn into a graph or chart.

The key idea here is that you don't want to do a data-dump - putting every single number, most of which could be useless - into a slide. You want to take only the most relevant information from the spreadsheet. It's easiest to do this on a slide-by-slide basis, after you have setup the presentation outline. Copy the information only pertaining to that one slide. If you're not sure whether it will be useful or not, it likely isn't, so don't take it.

Create the graph/chart

Once you have only the data you are going to need for the chart, you can switch over to PowerPoint and go to the slide where you will put the chart. This can be done by:

1. Clicking on the slide's body field - where you enter the main text of the slide, below the title.
2. Selecting the Insert tab from the top of the screen and clicking on Insert Chart. Note: This will only work if the slide's layout supports Content. To change the layout of the slide, right-click on it and select Layout, then pick one that says Content.
3. Choosing the type of graph that's relevant to your data from the window that pops up and pressing OK.
4. Deleting the information in the dummy Excel spreadsheet that comes up by left-clicking and dragging over the content. It will be highlighted and pressing Delete will get rid of it.
5. Copying and pasting the information from the Excel spreadsheet you setup earlier into the window in PowerPoint. Be sure to click on A1 before you paste it.
6. Renaming the chart by double-clicking on the title above the cells.

You can click back to the slide to look at the chart. Often times the data will be opposite. For example, the date will show on the X axis, when it should be on the Y. If you click on the chart, and select Switch Row/Column in the ribbon above the slide, you will be able to re-arrange the information.

Time to format

It's highly unlikely that the graph you placed into the slide is formatted the way you want, or even optimized for your audience. Here are four tips to help you format it so it not only looks good, but can be seen when you give your presentation.

1. Don't get too flashy - Yes, there are a large number and variety of charts available. No, they are not all good for presentations. It's best to pick a simple layout - stick with the classics: Pie, Bar and Line. Don't pick 3-D charts as they are hard to read and can confuse the audience. Also pick colors that can be seen. For example, light green, yellow, grey, etc. can hardly be seen on most projectors.
2. Use big text - It may look big enough on your screen, but you can be sure it isn't going to be big enough for your audience. Use the biggest font size possible, and limit any explanation text.
3. Remove Gridlines - But Gridlines make it easier to determine amounts don't they? Yes, on reports. But this isn't a report, it's a presentation, so it's ok to be general. Gridlines will just confuse your audience, and make graphs look cramped. Remove them by clicking on any grid line in the middle of the graph, and pressing Delete on your keyboard.
4. Test it - Before you give the presentation, it would be a good idea to test the presentation on a screen that is similar to the size you will be presenting on. If that's not possible, get a colleague to look over it. They will likely be able to point some changes out - if need be.

Having attractive graphs in your presentations can go a long way in keeping your audience engaged, and it could increase the chances of your message sinking in. If you would like to learn more about how you can leverage PowerPoint or any of Microsoft's other programs in your office, please contact us today.