When Apple released the first iPad, the business community knew, almost straight away, that it was the next step in the evolution of computing. Three versions later and the number of managers and business owners using their iPad for business purposes has done nothing but increase. While it’s great, it’s not perfect, and one thing the iPad could improve upon is its integration with printers.

Here’s how you can print from your iPad.

AirPrint AirPrint was introduced by Apple with the iOS 4.2 update. It allows apps on the iPad to wirelessly connect to a compatible printer. There are a large number of apps that support AirPrint, although there’s no official list. To find out if an app can print using AirPrint look at the app’s description in iTunes. There will be a note saying something along the lines of, “Wireless Printing supported” or “AirPrint supported.”

The only downside to AirPrint is that it will only work with a select few printers. A list of these can be found on the Apple website. For AirPrint to work, both your iPad and printer need to be connected to the same wireless network. If you meet the requirements, printing is quick and easy. Simply press the Action button (white square with an arrow) and select Print. The first time you do this, you’ll need to select the printer from the pop-up menu.

AirPrint enabler for Mac If you have a wireless printer that isn’t compatible with AirPrint, don’t rush out and buy a new one as there are apps like Printopia that can allow you to wirelessly print. To do so, you need to download an app onto your Mac which then allows it to share its connected printers with your iPad. When the app is installed, you should be able to find your wireless printer. The only downside to this app is it only works on Mac computers with OS X version 10.6 and later.

Print using a PC Don’t have a Mac? Don’t worry, you can still print using apps like PrintCentral. With this app you’ll be able to print directly to the vast majority of wireless printers, as long as they’re connected to the same network that your iPad is.

You can also print using a printer that’s connected to a computer. To do this, you’ll need to download and install the WePrint software onto your PC. Once this is done the software acts as a relay between the printer and your iPad, enabling you to print even if you’re not connected to the same network.

Being able to wirelessly print from your iPad helps make you and your business more efficient. If you’re working on the iPad during the commute, you can send it to the office printer and have it printed and ready for review for when you get to the office. This also makes you more efficient as you don’t need to log in to your computer, connect the iPad and transfer the information every time you want to print. You can just print it directly; saving you time.

If you’re looking to integrate the iPad into your business and would like to know more about how to do it, please contact us.

Social media has become an important part of any business's marketing strategy. By having an active presence on the main networks, you will likely see increased sales or at the very least an increase in brand recognition. So, while social media is an invaluable marketing tool, there are also other departments which could benefit from it.

Below are four non-marketing oriented uses of social media that businesses could benefit from.

Hiring LinkedIn is a social network dedicated to helping professionals and organizations connect and find jobs and new talent. Most social savvy companies will have a presence on this network and may even hire exclusively from here.

If you are looking for new employees, it wouldn't hurt to have a LinkedIn profile. To find the best talent, you need to forge and maintain connections (usually starting with people you know), and be somewhat active in groups and on message boards.

It's also important to not forget the other major networks when it comes to hiring. Tweeting a job opening on Twitter, or posting ads on Facebook could also help you find your next employee. Facebook can be particularly useful because you can pay to target ads (in this case, job openings) at specific demographics.

Internal communications Communication is an important part of business, and most people choose to communicate using email. You have probably seen emails with jokes, invitations to after work events, lunch orders, etc. sent to the whole company and also received the many replies that go with it. This can get very annoying, and also confusing.

Why not utilize social media for non-essential (aka. not related to work) communication. Set up a Facebook group where your employees can share content, invitations to lunch or after work gatherings, interesting stories, etc. That way you can limit email to more important, business-related aspects.

Using social media for internal communication is also beneficial for companies with younger workers. Most already see Facebook, Twitter, etc. as their main form of communication, some even feel more comfortable communicating over this medium as opposed to speaking out in meetings. Having a group portal or Facebook page could give less-empowered employees a way to voice their ideas, and maybe even improve on them with feedback from others.

Learning A common complaint of many business owners is that they have a tough time staying on top of ever-changing trends and what currently interests their customers. Using social media to connect with your customers can be a great way to learn not only hot trends but also about new ideas.

Customer service When it comes to social media, users will often complain publicly on their wall or through their tweets. This is bad for you, as the reach of this complaint can go a long way and make you look bad. Some companies have decided to confront this head on by having specific customer service accounts. If a customer complains, has an issue, or even compliments you, be active and respond using that account.

If done properly, over time, you will see more and more people reaching out to your customer service account through social media. This also gives you another way to please clients or turn around negative customer experiences.

Social media and the various platforms are not only great for marketing, but can be incredibly useful for other business functions. Do you have any other ways you use social media? Let us know. Or, if you would like to learn more about how it can help your company, then contact us today.

As Android tablets become more commonplace in the business environment, many managers are finding that they want to edit and view documents, presentations and spreadsheet files on the tablet. Many, if not all, managers use Microsoft Office as their main office suite which poses a problem, as there’s no official Microsoft Office app for the tablet.

Here are four apps that have stepped up as alternatives for Microsoft Office on your Android Tablet.

Kingsoft Office - FREE Kingsoft Office allows you to open and edit Word and Excel files. You can only view PowerPoint and PDF files though. This app will also allow you to create Word and Excel documents. There are three versions of the app on the Google Play store, an English only version, an international version with support for 13 languages and a simplified Chinese version called WPS. If you can read simplified Chinese, go for the WPS version, as it has a few extra features. If not, go for the normal version.

Quickoffice Pro HD - USD 14.99 This app is quick, hence the name. With it you can use your tablet to create, edit and share Microsoft Office documents, spreadsheets, presentations and PDF files. You can also access and upload documents to major cloud services like Dropbox and Google Drive. Beyond that, you can send files to other users via SMS, email, Bluetooth and social media. Note that there are two versions of this program on the Google Play store. The HD version is for tablets only.

Google Drive - FREE with 5GB storage Google Drive is Google’s cloud storage/collaboration tool. When it was released, Google Docs was rolled into this service. While this app can read Office documents, it does have problems with Office related formatting. If your company uses Google Apps, then Google Drive is the app you should be using. If you’re expecting a full featured document editor, it’s a better idea to look at the other options.

Documents To Go - FREE to USD 14.99 Documents To Go is a free app that allows you to view Word, Excel, PowerPoint, PDF and Google Doc/Drive files. If you download the Full Version, you can create and edit Office files and PDFs. You’ll also be able to download and save Google Drive documents. There are two features that set this app apart. The first is that you can sync files from and to your Windows PC, and the second is that it has a layout that’s simple to use.

These four apps each offer something different, and between them they should meet your needs. If you need help choosing one that’s a perfect fit for you, please get in touch with us.

Microsoft Word is probably the most widely installed program that’s not an operating system. It’s become so ingrained in computing culture that other word processing programs have a tough time competing, and have had to include the ability to read and edit Word documents. Of Word’s many features, keyboard shortcuts are among the most useful.

Here are 20 handy keyboard shortcuts for Word that can help improve your productivity, or make navigating easier.

General These shortcuts will do the same thing in all Microsoft programs.

• Ctrl + P: prints the document, spreadsheet or presentation. If you have more than one window open, the item you’re currently looking at will be printed.
• Ctrl + W: closes the window you have open.
• Ctrl + O: brings up the Open document window.
• F12: opens the Save As window.
• Ctrl + S: will save the document.
• Ctrl + C: copies what you’ve selected.
• Ctrl + X: cuts what you’ve selected.
• Ctrl + V: pastes what you’ve copied or cut.
• Ctrl + A: selects everything.

Word specific These shortcuts can be used in nearly any version of Word. Note: Ctrl may be Control on some keyboards.

• Ctrl + F: will allow you to search the document for a word or sentence. If you press Replace in the window that opens, you’ll be able to find and replace words.
• Ctrl + Up arrow: moves up one paragraph from where the cursor - black, blinking line - is.
• Ctrl + Down arrow: moves down one paragraph from where the cursor is.
• Ctrl + Page Up: switches to the top of the previous page.
• Ctrl + Page Down: switches to the top of the next page.
• Ctrl + Shift + E: turns on track changes which will show any changes made to the document, convenient for editing. Pressing it again will turn track changes off.
• Ctrl + Shift + C: will copy the format of the selected text.
• Ctrl + Shift + V: pastes the previously copied format. Note: you need to select text to apply the copied format to.
• Ctrl + B/I/U: applies bold, italic or underlined formatting to selected text. If no text is selected, the respective formatting will be enabled.
• Tab: will move to the next selection. If you have a list with numbers or bullets, pressing Tab will indent the number or bullet in once, and change it to a subheading under the previous point. i.e., 2. will be indented and changed to a. as a subheading under 1.
• Shift + Tab: moves back, or moves one indent back (to the right). For lists, this will move the point up the hierarchy i.e., a. will be moved back to 2.

These are some of the most useful keyboard shortcuts for Word. For a full list of shortcuts you can go to the Microsoft Help and How-to page. If you’re interested in learning more about Word’s features and how they can be implemented, please contact us.

If you’re like other managers you’ve sat through or given more presentations then you can remember. While presentations are an important part of business, many presenters fail to get their message across because of their slides. If you don’t have good slides, the probability of your presentation going well is pretty low.

Here are nine tips on how to prepare a good Microsoft PowerPoint presentation.

1. Choose a relevant layout. When you choose the layout or template for your slides, pick something that’s simple and non-distracting. If you’re presenting yearly earnings, a background of flowers probably isn’t the best choice. Under no circumstances should you put your company’s logo as a background, this can make slides incredibly distracting. Put it in the header or footer instead.
2. Colors. It’s important to pick a good colour scheme for your slides. The keyword here is, “contrast.” Pick colors that contrast and are easy on the eyes. A white background with black text is good, a red background with black text is bad. If you want to use your company’s colours and they don’t contrast well, pick one of your colors and another that’s a good contrast.
3. Images. Pictures and graphics capture our attention, text puts us to sleep. The general rule of thumb is to have more visuals than text. Don’t have images for the sake of images, instead pick ones that convey what you want to say. Many good presenters will have a slide with nothing but an attention grabbing image, and use it to talk about their main idea.
4. KISS your text. KISS stands for Keep It Stupidly Simple. Text should be kept to a minimum, at most five lines or bullet points per slide. The best presentations use only keywords or showcase the utmost important data and save explanations for the presentation.
5. Eliminate animations. It can be tempting to have text or images pop up every few seconds. Resist the temptation, as it’s incredibly hard to match your presentation speed with that of the animations. Having to speed up or wait for animation will make you look unprofessional.
6. Remain consistent. If there’s one key rule with presentations, it’s remain constant. This applies to everything in your presentation. Keep the font size, font, image type, colour scheme and layout the same throughout the presentation. If you put your logo in a header on one slide, it should be in the header on all the slides.
7. Audience. When developing a presentation you should always keep in mind who your audience is. If you’re presenting to a marketing firm, they probably don’t need to see more than one or two slides with financial information. Beyond that, be sure to prepare a version of the slides for your audience. Any explanations and extra information should be put in here as well.
8. Keep the file size down. If you’re presenting on another system or will be emailing the slides, it’s a good idea to ensure the file is as small as possible. The bigger it is, the slower it’ll load and the higher the chance it will stutter or crash.
9. Practice. Go over the slides ahead of time and be sure you know the content inside and out. Another benefit to practicing is you will often catch mistakes and knowledge gaps that you can fix before you present.

By following these tips, you should be well on your way to producing a good presentation that will captivate your audience and make you look like a star. If you have any other questions regarding PowerPoint, or any of Microsoft’s other products we are here to help, please contact us.

No matter what industry your business is in, managers and employees will at one time or another need to give a presentation. Presentations can at times scare many employees, causing undue stress and poorly created presentations that could cost a company a key contract.

It’s important that you, that as a manager, you ensure that your employees are creating PowerPoint presentations that are effective. Here are a few tips you can give to your employees to help them improve their presentations.

Simplify and minimize The best presentations are simple and minimal, often shifting focus from the presentation to the presenter. Minimal presentations follow the 6-6-6 rule. There should be no more than: 6 bullet points per slide, 6 words per bullet and 6 slides full of words in a row. Being visual creatures, you should encourage your employees to create slides with engaging and related visuals. A caveat: be sure that you have the rights to use the images.

A great rule taught in business schools across the country is: KISS (Keep It Simple, Stupid). Refrain from using confusing words, jargon, uncommon acronyms and irrelevant information. Keep it short, sweet, and to the point. Following these rules will help engage the audience and hold their attention for a longer period of time.

Be consistent “Consistency is key” - a saying often used but rarely followed in the creation of PowerPoint presentations. You should ensure that grammar and spelling are all consistent, and errors are minimal, if existent at all. Have another employee or manager review it for errors and inconsistencies.

For the slides, use the same background and font throughout. The easiest way to ensure this is by using a template. A word of warning: don’t use templates that are heavily animated because they can cause significant distractions, and don’t choose backgrounds that are similar in color to your font. The best slides have a light color for a background with a darker font for your text.

Summarize The goal of most presentations is to build interest and inform or update the audience. In fact, the majority of audiences just want a short summary so they can develop their own questions to ask after the presentation, or at a later meeting.

When creating the presentation, be sure to keep the audience in mind. If a presentation is being made to IT managers, chances are it does not need to have advanced financial spreadsheets. If you are presenting on a topic that has lots of graphs, extra information, or appendices, put the most important information in the presentation and the rest in a handout. This will keep the audience’s attention on the presenter, not the slides.

Practice, preview, review Practice makes perfect. In an ideal world there would be hours and hours to practice and tweak a presentation. Normally, that’s not true. Schedule at least a comparable amount of time the day before a presentation for a dry run. Always review the presentation with your team and ask them for feedback. This will help encourage employees to keep improving and developing themselves.

For more tips and tricks on giving presentations using Microsoft PowerPoint and other Microsoft products, please contact us.

Many business owners and managers use Microsoft’s spreadsheet program, Excel, on a daily basis. It has become the go-to program for basic book keeping, forecasting, scheduling, chart making, and much more. It’s safe to say we are comfortable with it, and some may even call themselves experts. For those who are less comfortable, there are a number of errors that can cause confusion. Read on to learn about the most common ones.

While most of us are comfortable with Excel, there are many times when we have had an error pop up that is more or less confusing. Let’s face it, when we see “!#%&” characters many of us are at a loss. Here are some of the most common errors you come across in Excel, what they mean, and how to fix them.

####### This is one of the most common errors, with the # sign filling the cell. This error means that you have entered data in the cell that is longer than the cell’s size. For example, 1234567890 will show up as ##### if that column is not wide enough to fit all those numbers. This error will also show up when you have formatted a negative number as a date.

To fix this error, simply re-size the column (A, B, C, etc.) by clicking the edge of the column and dragging to the right to make larger. Or check to see if you have a negative number that is formatted as a date, and if so format the cell as a negative number instead..

?Name# This error means you have have an error in the formula or range. For example, =counif(!6:B99, “Y”) In this case, “counif” should be “countif”. Also, the “!6” should be a column letter and 6 (i.e., B6).

To fix this error, click on the cell with the error, and look at the formula in the formula bar, usually located above the spreadsheet, and correct the formula like this: =COUNTIF(A6:B99, “Y”)

#REF! If you have a formula that refers to other cells in the spreadsheet, and then you change one of those cells to data that does not compute in your formula, you will get the #REF! error. For example, if your formula for C6 is: =SUM(A1:A5, B1:B5, C1:C5) and you delete B1, you will get #REF! in C6.

The easiest fix to this is to hit: CTRL+Z, or Undo under Edit. If you made the error a long time ago and Undo does not work, then make sure all cells referenced in the formal contain valid information.

Circular Reference You get this error when you have entered a formula that includes the cell where you have entered the formula. For example, the formula =SUM(A2:A5) is entered into A5. Excel is essentially telling you that it is chasing its own tail, and can’t catch it.

The easiest way to fix this error is to simply click on the original cell, and remove the reference to the cell that the formula is entered in.

The Little Green Triangle in the Cell If you see a little green triangle in the top left corner of a cell, Excel is telling you there is an error with the formula. This is useful if you aren’t sure about what the error means. If you click on the arrow, you will get an ! with Trace Error. Click this, and Excel will give you a drop-down menu with options.

What if I Can’t Find the Error? If you are having trouble locating the error, or do not want to spend time searching for the error in a long formula, click the Formula tab and the arrow beside Error Checking. You can click either Trace Error or Circular Reference and Excel will point out the error, or provide the cell name with the error. From there, select the cell and look at the formula or data entered to determine the problem.