Blog

September 2nd, 2014

Web_Sep02_AAt any given time there are a nearly countless number of technology related trends popping up. Many come and go, but one of the most important that many business owners are focusing on is the cloud. Owners and managers know they ought to be using “the cloud” but it can be confusing as to what exactly it is and the different types of services available. To help, here is an overview of three of the most common cloud service models used in small to medium businesses.

1. SaaS

SaaS, or software as a service, is a cloud service that revolves around, you guessed it, software. Easily the largest and most well known cloud-based service, SaaS uses the cloud to deliver software to users, which is then usually accessed via your Web browser. Unlike physical software that you install on your computer, SaaS solutions are hosted on a provider’s servers.

This means that the provider is responsible for software maintenance and updates, which translates to the fact that users will all be using the same version of software and get updates at the same time. As a business owner this means that actually managing the software on all of your computers is made not only easier, but more affordable. Combine this with the fact that companies like us can manage these solutions for you and you can see why SaaS is highly popular with many companies.

If you are looking for a new software solution, many major types of software now also have SaaS options including: Office document creation suites, accounting software, email, HR solutions, content management, customer relationship management, and more.

2. PaaS

PaaS, or platform as a service, is a cloud-based service that provides users with computing platforms. Most companies who utilize PaaS do so to either host or develop their own software solutions, or to provide support for software used by employees.

The main reason many companies integrate PaaS is because it drastically reduces the costs and complexity often associated with buying, developing, configuring, installing, and managing the hardware and software solutions that are necessary for the custom-built applications that many businesses rely on.

While PaaS is gaining in popularity with many small businesses, most won’t have a lot of first-hand interaction with this type of cloud, especially those who work with IT providers like us. Essentially, most providers will utilize PaaS in order to deliver custom applications and solutions to the end-user.

3. IaaS

IaaS, or infrastructure as a service, is essentially cloud-based computers and resources. The most popular and well known type of IaaS is the virtual machine which is a digital version of a computer or server that is accessed over an Internet connection. The infrastructure is physically kept off site, and usually managed by a provider, but you access and interact with it as if it is located on your computer or in your office.

In other words, if you are looking to virtualize your systems via the cloud, IaaS could be a good place to start as it allows you to move existing support systems into the cloud. Other solutions can then be migrated or introduced as needed.

While the cloud can offer a wide variety of benefits and solutions to companies, it can be a chore to choose the service which is best for your company’s needs. We highly recommend that if you are considering a cloud solution, you get in contact with us. We can help find the best solution for the needs of your business and to also manage it, thereby ensuring proper migration and implementation, leaving you to focus on running your business.

Contact us today to learn more.

Published with permission from TechAdvisory.org. Source.
Topic Web
September 2nd, 2014

GoogleApps_Sep02_AFor many Google Apps users Google Drive is among the most important and popular app. With a wide scope of features, including document creation, collaboration tools, and cloud-based storage, the app is highly useful for almost any business across any industry. However, like most similar systems, it can still be a challenge to find specific files or folders. One of the best ways to do this is by using the search bar at the top of the screen, but did you know that there are some search operators you can use to make finding your files even easier? Here are four.

Searching for files on Drive

Before we look into the different search operators you can use to find files on Drive, we should clarify that these operators are to employ in the search bar, which is located at the top of the Drive page. If you want to search for a file this works in the same way as the Google Search bar on google.com, only this bar focuses on Drive files, and anything related to Drive.

To use the operators listed below, simply click on the bar that says Search Drive and enter the operator along with the search term, or name of the file/item/keyword you are looking for. For best results you should put the operator before the keyword, however Google also allows users to insert it after the keyword.

1. title:

Sometimes when you are looking for a document, you want to search for the title only, but because of the way Drive’s search works, if you enter a keyword it will search for all files that contain that particular word. This means that if you are looking for a document based on its title, you will also see results for documents that contain that keyword too. By using the title: operator you can filter results so that only documents that contain the keyword in the title are displayed.

For example, if you are looking for a document that you know has the words “TPS report” in the title, you would enter: title: “tps report”. If you are looking for a title but know only a few keywords that aren’t next to each other, you can enter the keywords with quotations around each of the keywords. This will tell Drive to search for files that contain each of the separate keywords in the title.

2. type:

Chances are that with Drive you have created and stored more than just one type of file. Many of us use it to store multiple file types, which can make finding the file you are looking for more challenging.

If you know the type of document you are searching for, enter the operator type: followed by the file type (spreadsheet, document, pdf, presentation, drawing, image, and video) and then add keywords to direct Drive to only display these filtered, related results.

So, if you are looking for a presentation with the keywords “sales team” then you would enter: type:presentation “sales team”. Be sure that when you are looking for a file type, there is no space between the operator and the type of file you are searching for.

3. owner:

Drive is highly collaborative and files that you have access to may not be stored on My Drive, or even owned by you. If you are looking for files that you know are owned by other team members try using the owner: operator.

When using this, Drive will present files owned by the email address that you enter beside the operator, and which have been shared with you. If you are looking for a file that is shared with you/on your Drive that is owned by sally@company.com, then you would enter: owner:sally@company.com. You can add keywords before or after the operator (as long as they are separated by a space) to filter results down even further.

4. is:starred

One of the more useful Drive features for users who deal with a large number of files is the ability to star important ones. By simply clicking on Starred on the left-hand horizontal menu bar, you can view all of your starred files. The issue many run across however is that that list does grow over time, making it less useful in finding important files – which kind of defeats the purpose of the feature in the first place.

If this has happened to you, then you can easily search for starred files by entering: is:starred along with keywords in the search field. This will tell Drive to only search for files that contain the keywords and are starred.

These are just a few of the more useful search operators available to Drive users. Do you have one you can’t live without? Let us know! And, if you have any questions about Drive for your office, please contact us.

Published with permission from TechAdvisory.org. Source.
August 27th, 2014

office365_Aug26_AAs a manager or business owner the chances are good that you spend a fair amount of time editing or compiling documents your employees have created. Many of us use ever popular Microsoft Word to do this, especially when it comes to writing reports or other content. A common issue you may run across when editing is overtype. While this might be your preference, you may also inadvertently toggle it, so it helps to be aware of this function.

Word’s two editing styles

Every version of Word used in businesses these days has the same two editing styles or modes:

  1. Insert mode: This is the default editing mode where words are inserted where the blinking cursor is placed. All text that comes to the right of the cursor will be moved to the right with newly typed text coming before it.
  2. Overtype mode: This mode replaces text to the right of the blinking cursor. So when you type new text any existing text to the immediate right will be replaced with the new letters.

While the vast majority of users prefer to use insert mode, overtype mode can be useful when editing documents and replacing words, or rewording paragraphs and keeping track of what needs to be rewritten.

Turning overtype on and off

On some older versions of Word, and on some computers, overtype mode is already enabled, and simply hitting Insert on the numberpad of your keyboard will turn it on. You will know overtype is active by looking at the status bar at the bottom of your document. The words OVR should be visible in bold letters.

If you don’t see a status bar, try clicking on File > Preferences > View. Once in the View window, scroll down to the Windows section and tick Status Bar. Finally, press Ok and the bar should pop up at the bottom of the window.

Managing overtype

If you find that overtype cannot be activated, or have received a document where it is already activated and can’t figure out how to turn it off, you can manage overtype by:

  1. Right clicking on the status bar at the bottom of the document.
  2. Clicking on Overtype to add it to the status bar.
  3. Clicking on OVR in the status bar to turn it on or off.

You can also activate or deactivate overtype by:

  1. Clicking on File followed by Options.
  2. Selecting Advanced.
  3. Scrolling down to Editing options.
  4. Ticking or unticking Use overtype mode.

If you untick Use overtype mode you will disable the feature, meaning you won’t be able to hit Insert to switch between the two editing modes.

Looking to learn more about using Word in your office? Contact us today as we specialize in this area and have great tips, advice and solutions for you.

Published with permission from TechAdvisory.org. Source.
August 26th, 2014

androidphone_Aug26_AWhen you first get your hands on your Android smartphone, you’ll be asked about location services and whether you want to enable them. Google and your carrier will have its own location services that you’ll need to approve as well. But what you might not know is that there are actually a few other options for location services with Android which can affect your smartphone’s security. To that end, let’s take a look at how to change some of these Android settings.

Photos and GPS tagging

Your Android smartphone gives you the ability to attach GPS coordinates to the pictures you take, known as geo-locating or GPS tagging. This lets you arrange pictures in albums by locations, or lets Google+ stitch together stories of your trips. Geo-locating images in itself isn’t a bad thing, but you can get into trouble when you broadcast sensitive locations to the world. For instance, a picture of your expensive watch with a GPS tag of your house isn’t the best idea.

Four ways to control geo-locating photos:

  1. Go to your camera settings and you’ll find an on/off toggle.
  2. Simply go into Settings>Location and from there you can decide if you want the location saved along with your images.
  3. Download an EXIF editor and manually remove the location information from specific images.
  4. You can also turn off location services altogether by going to Settings>Location.

Discrete location settings

Apart from location settings in photos and GPS tagging, Android actually has three discrete location settings which allow you to set how accurately you want location reporting to be. You can find these at Settings>Location, Note that this affects your smartphone’s battery life immensely.

  • High accuracy: This uses the GPS radio in your phone to pinpoint its exact location from satellites while making use of nearby Wi-Fi and cellular networks too.
  • Battery saving: This mode only uses Wi-Fi networks and mobile networks to identify locations, and while it might not be as accurate it will help your phone last longer.
  • Device sensors only: This only uses the GPS radio to find you. It may take a little more time to find your location since it’s not using nearby Wi-Fi and mobile networks to get your general location first. This also uses more battery.

Having your location settings turned off will not only help keep your smartphone’s security intact, but also help strengthen your smartphone’s battery life. Interested in learning more about Android phones and their functions? We have solutions for you and your business.

Published with permission from TechAdvisory.org. Source.
August 22nd, 2014

Productivity_Aug18_AThese days many of us have integrated various apps and programs on our computers and mobile devices into our daily lives. The problem many of us face, however, is that apps and programs are all different and many don’t work all that well together, so we need to take time to transfer information or even share the same content. To make things easier, there is a great app called If This Then That (IFTTT), that could help make your devices just that much smarter.

What is If This Then That?

IFTTT is a Web and mobile app that was developed to connect different Web apps like Google Apps, DropBox, Facebook, Instagram, etc, together into one general system. In general, the service runs on conditional statements – or recipes – that fit the IFTTT statement.

The service is set up on a number of different conditional statements that make up what the developers of the app call a recipe. Each recipe is broken down into two different sections:

  • This - Also referred to as a trigger. Each trigger in a recipe is kind of like a requirement in that the set trigger has to happen for the recipe to start working.
  • That - That refers to an action that happens when a ‘this’ condition is triggered.

Once you have set up a number of recipes, the app runs in the background to check for triggers and then will automatically execute the action when it notices a trigger.

Examples of IFTTT recipes

There are a wide variety of recipes out there that you can create. For example, some of the more useful IFTTT recipes for businesses include:

  • If a photo is posted on the business Instagram account, then it is shared with Twitter and Facebook.
  • If a Square payment is processed, then this creates a line in a specific spreadsheet.
  • If a contact is added to a phone’s address book, then this information is placed on Evernote.
  • If an article is posted on a specific blog, then the post is shared on Twitter, Facebook, and Google+.
  • If an email is starred on Gmail, then a reminder is set on my phone to review starred emails.
  • If I enter the office, then my phone is muted.
  • If a client emails an attachment, then a copy is saved to DropBox.
  • If my device is in the office, then my office lights are turned on (if you have Phillips Hue bulbs).

There are a wide variety of supported apps that allow you to create recipes for nearly anything you can think of. The developers are constantly adding support for new channels (apps), including many from the Internet of Things.

How to sign up for this

Because you can access IFTTT from the Web and via an app on your mobile device, we recommend first thinking about how you are going to use it. If you are going to be using recipes for your mobile device, then we recommend downloading the app onto your device. Regardless of how you are going to use it, you can create an account by:

  1. Going to the IFTTT website (https://ifttt.com/)
  2. Clicking Join IFTTT.
  3. Setting a username and password and clicking Create account.

From there, you will be able to log in and start creating rules. If you do want to use your mobile device, you should then download the free app for your device – Windows Phone, Android, iPhone – and then log in using the account information you just created. When you first log in you should see a number of channels (apps) related to your system have been activated. This means you can now start creating recipes.

Creating recipes from your browser

  1. Go to the IFTTT website (https://ifttt.com/) and press Sign in.
  2. Press Create.
  3. Press This and select your trigger – try picking your app first, then click on it to get a list of actions.
  4. Press Create Trigger.
  5. Click That and select an action channel.
  6. Select Create Recipe.

You can also click Browse from the menu bar at the top to find and activate already created recipes.

Creating recipes from your mobile device

  1. Open the app.
  2. Press the mortar and pestle icon at the top-right.
  3. Press the + followed by the + besides If on the next screen.
  4. Select the app from the icons at the top of the screen, and select the related trigger.
  5. Tap the + beside Then and select an action or app.
  6. Press Finish to activate the new recipe.

If you are looking for a cool way to connect different apps, and even save yourself time, then this could be something worth looking into. And, if you are looking to learn more about how you can increase your productivity, contact us today to see how our systems can help.

Published with permission from TechAdvisory.org. Source.
Topic Productivity
August 19th, 2014

Google_Aug18_AEmail is one of the most important communication tools for almost every employee and business. The problem many of us face however is sorting the non-important from important emails, or even separating personal and work emails. One solution most major email providers offer, to allow people to separate email types, is the alias. Did you know that Gmail has an alias feature that could be helpful?

About the Gmail alias

When you first sign up for a Gmail or Google account you are asked to pick an email address or username. Your username becomes the first part of your email address, and is what you will likely give to most people. There are times however where you may not want to give out your email address, but are still required to e.g., signing up for a newsletter.

What many email providers have done is implement an alias feature that allows you to set up a separate email address that can be managed by your main account. When an email is sent to your alias address, it shows up in your main account’s Inbox. Google doesn’t offer this feature in the traditional sense, instead the company has opted for a slightly different take on aliases.

With Google, you can add a suffix to the main part of your email address to essentially create an alias. The way this works is you add ‘+alias’ to the main part of your email address. Any emails sent to this address will show up in your Inbox, but to the sender they are being sent to a different address.

Setting up an alias in Gmail

With Gmail you don’t have to create a completely different account, you can create an alias email address instead. Let’s say you are starting to sign up for an increasing number of email newsletters, what you can do is add a suffix like +newsletter to your email address, so it will look like: user.name+newsletter@gmail.com.

You can then use this email for when you are signing up for newsletters, and they will be sent to that address. The key here is that you can create as many +alias addresses as you want, and the emails sent to that address will show up in your Inbox.

Why use an alias?

At first thought this may seem like a bit of a non-feature, after all who really wants to create an alias like this? Well, the main reason this is a useful feature is because of Gmail’s Filters and Labels. You can use these two features to sort and automatically action emails sent to a specific email alias. When you combine the +alias feature with these, you have a pretty powerful way to manage your Inbox.

Here are a few examples of how people are using this feature:

1. For newsletters and other non-essential emails

We all get these emails and while they aren’t overly important they might contain useful information we want. The problem is that these emails can be annoying and always seem to be multiplying.

One solution is to use a +alias, like +news or +newsletters, when signing up for emails like this. Then, go into Gmail and create a filter that automatically labels all emails sent to the address with something like Updates, or even archive them. To be most effective, try setting the filter so that these emails automatically skip the Inbox, meaning you won’t get a notification when you have a new email.

2. For VIPs

If you have a number of clients who you work closely with, or you want to make sure you don’t miss anything from them, they why not set an alias like user.name+vip@gmail.com that you can then give to them.

From there, set up a filter in Gmail that automatically marks emails sent to this address as important and top priority. If you set it to automatically add a bright label as well, you increase the chances of seeing the email more quickly and will know it’s important right away.

3. For impromptu reminders

We have all been in a situation where we want to send ourselves a reminder to do something later. One thing we can do is to email an alias like user.name+reminder@gmail.com with the reminder.

In Gmail, set up a filter to automatically label every email sent to the above email address with a label like Reminder. These emails can also go right to the archives and skip the Inbox, but when you click the Reminder label, they will still show up. If you are diligent in deleting these emails, this could work as a great way to send yourself important reminders – especially because we already look at our email so much; it will be practically in front of us.

If you are looking to learn more about Gmail and how it can be used in your business, get in touch with us.

Published with permission from TechAdvisory.org. Source.
August 15th, 2014

Virtualization_Aug11_AVirtualization has become common place in small to medium size businesses. After all, the idea of moving physical systems to virtual ones that not only usually costs less but also allows owners to get rid of physical hardware, makes it an appealing option. While virtualization is popular, migrations are not always successful. Following are five of the more popular reasons why they can fail.

1. Migration is forced before it is ready

One of the biggest reasons virtualization fails is that it is pushed before the company is ready for it. For example, it could be that the IT team is forced to fast-track virtualization, resulting in staff being forced to drop all other tasks and focus on migration.

If you rush, the chances of failure and mistakes always rise. And when it comes to changing systems from physical to virtual, mistakes can be compounded, thus increasing overall migration time and costs.

To avoid this you should take the time to conduct research on solutions available, workloads, applications to the move, and your specific business needs. Once you are across this, you should also take the time to get to know your systems and test them before migration.

2. Trying to implement a management plan after virtualizing systems

Some companies decide to virtualize first, and then try to figure out how to manage systems after migration is complete. This will almost always result in inefficiencies and frustration as the pressure is on not just to learn how to manage but also how to use this solution.

In order to see a more successful virtualization, you should have a management plan in place before you migrate your systems. You should look at how virtual machines will be managed, who will be doing what, as well as what systems you are going to use, and more. One of the best times to develop an overall management plan is when you are in the testing phase, well before actual migration. This will give you an idea of how systems will work in reality and how you can manage them.

3. Virtualization without employee buy-in, or involving employees

We have seen companies implement a virtualization solution without having full buy-in from the employees who will be using and managing the system. What this results in is confusion, resentment, lost efficiency, and, in some extreme situations, sabotage.

In order to successfully introduce a virtualized solution, you should ensure that all employees who will be using the system are not only aware of it but are trained on how to use it and have been given a fair chance to air their opinions. If you can achieve employee buy-in, there is a better chance that the systems will be used more effectively, and employees will be more open to other solutions being implemented.

4. Assuming one solution that works for others will work for you

An easy mistake to make is to only consider solutions successfully implemented by other businesses. The fact is, every business is different, and you should be looking for a solution that meets your specific needs.

If you go with a ready-made solution, or one-size-fits-all solution, it will likely work to some extent. However, there is a good chance that it will not completely meet your needs. This will likely result in either lost efficiency or increased investment in order to get what you need.

We recommend looking for a provider who can meet your virtualization needs with tailor made solutions. This way you will get what you need straightaway and likely not need to invest more in the future.

5. Not managing your virtual solution after implementation

Unlike some tech solutions, virtualization is not really a ‘set it and forget it’ type of solution. You will need to manage it from the start if you want to be able to get the most out of your systems. This includes ensuring resources are being allocated properly; machines are created and shut down properly; apps and systems are updated; and more.

While virtualized solutions do require less management than their physical counterparts, they still require some management and you will need people to help you do that. One of the best solutions is to work with an IT partner like us who can help manage your systems and ensure that they are working efficiently.

In fact, we offer a wide variety of virtualization solutions. By working with us, we can help take some of the virtualization load off and allow you to focus on running your business. If you would like to learn more, contact us today to see how we can help.

Published with permission from TechAdvisory.org. Source.
August 14th, 2014

iPad_Aug11_AApple prides itself on producing products and systems that simply work. This has proven to be a successful concept, as is evident with the sheer number of Apple products out there. The iPad, for example, is arguably the most popular, and useful, tablet with many business owners and managers owning one. These devices rely on apps but a common issue is that we often have so many apps it can be difficult to see what we have installed. Here are three ways you can figure out what apps you have installed on your iPad.

1. Finding installed apps via Settings

While there is no set section of the iPad’s Settings that allows you to view installed apps, you can actually view installed apps by looking at the Usage section. This section tells users how much storage space installed apps are using, therefore giving you a list of installed apps.

You can access the Usage section of Settings by:

  1. Opening the Settings panel on your iPad.
  2. Tapping on General.
  3. Selecting Usage.

This will list the apps you have installed, organized by how much hard drive space they are using. What’s great about this method is that you can not only see the apps you have installed but also see if there are apps you aren’t using, or apps that are taking up valuable space. You can also select apps to learn more about how much memory they are using and even uninstall an app should you not need it anymore.

2. Finding installed apps via Spotlight

If you have iOS 7 on your iPad you can view all installed apps via the Spotlight feature. Spotlight allows you to search your iPad for files, folders, apps, and more, and can be accessed by swiping down from the top of the screen when looking at the Home screen.

You can see what apps you have installed using Spotlight by:

  1. Opening Spotlight by sliding down from the top of your iPad’s screen.
  2. Tapping on the blank spot beside the magnifying glass.
  3. Typing “.” (period/full stop) without the quotations.

You should see a list of your installed apps come up, though there is no apparent way they are organized. If you tap on an app name, it will open.

3. Finding installed apps via iTunes

The other way you can find out the apps you have installed is via iTunes. You can do this by:

  1. Plugging your iPad into your computer via the cord that came with the device.
  2. Opening iTunes, if it doesn’t open automatically when you connect it.
  3. Clicking on the device’s name under Devices.
  4. Selecting Apps.

You will be able to search for apps, or you should see a full list of installed apps. The great thing about this feature is that if you search for apps, you should see where they are on your device’s screen. From there you can move the apps around, or even delete them.

If you are looking to learn more about using the iPad, please contact us today to see how we can help.

Published with permission from TechAdvisory.org. Source.
Topic iPad
August 13th, 2014

AndroidTablet_Aug11_AGoogle’s mobile operating system Android has become one of the most popular systems installed on phones. While the system is feature heavy, many businesses are wary about the overall openness of the system. Earlier this year, Google announced the next version of Android – Android L – which will have a number of business-specific features called Android Work.

What exactly is Android Work?

Android Work is a program that is being developed by Google that will be introduced in the next version of Android – Android L. Because of the overall open and somewhat fragmented nature of Android, many businesses have been struggling to manage devices. In an effort to attract business customers, device manufactures have come up with their own business-centric suite of features that boost device security and manageability.

While there are a number of options out there, Samsung has had the most success with KNOX. This is essentially a secure version of Android that can be managed by businesses. With devices running KNOX, administrators can separate personal and work features, as well as manage and secure business apps and content on a user’s device.

The best way to think of this program is that it enables a completely separate business profile, that can be managed by a company, on a personal device. Users with a system like this will be able to separate work and personal apps, content, and data, but still be able to use the same device. This is what mobile experts refer to as containerization – business apps and data are essentially stored in a container that is kept within the overall Android system.

Google found this idea of being able to separate personal lives and work on the same device to be something worth investing in, and have subsequently developed Android Work based on the KNOX platform. This will allow all Android users, not just users with Samsung devices, to take advantage of this program.

When launched there will be a number of key business oriented features beyond just the KNOX support. Here are two of the most talked about.

Seamless transition between personal and work data

Containerization is usually referred to as creating a separate system on one device, kind of like having a work and personal profile on your computer. While this is great, it can be annoying to switch between profiles on your device. So, Google has decided to modify the way containers work, making them more seamless.

With Android Work, IT will be able to install and manage apps on a user’s device – they have to agree to this of course. Only, these apps will appear on the device beside personal apps and will be useable just like any other app. In the background however, the Android Work managed apps will sit in their own container. This container will apply heavy encryption to related data going in and out of the device, and restrict what users can do with the app (based on whatever rules the IT admin has set).

The key here is that while the apps and security are separate, the user will not notice any major difference and will be able to interact with both personal and business apps from the same profile. They will be able to tell the difference between work and personal apps as apps installed, managed or related to Android Work will have an identifying badge on the icon.

Easier deploying and managing of apps

With Android Work, IT admins or managers will be able to bulk purchase apps from the Google Play store and have them automatically installed on user’s devices. If you use separate apps, or have developed apps for use in-house, you will also be able to push these to devices.

Beyond that, there will be admin panels that can push updates to apps on all devices, or even bulk manage existing apps. While the user will see no real difference, the apps in the Work container are managed by the administrator, not the user.

Will Work be useful?

Many business owners have been asking this question over the past few months, and the answer really depends on how you use devices in the office. If you support BYOD (Bring Your Own Device), you will be able to easily manage the apps, data, and security of just the business related apps, while still allowing personal apps and data to be installed on the same device.

Companies who provide their employees with mobile phones or tablets will also find Android Work useful as it will enable easier management and enhanced security across a variety of Android devices.

When will Android Work be available?

As of now, Android Work is still in development, but Google has noted that it will be released as a feature of the next version of Android, which is slated to be released this fall.

If you are looking to learn more about Android Work, or how to manage Android devices, contact us today to see how we can help.

Published with permission from TechAdvisory.org. Source.
August 13th, 2014

Offie_Aug11_AMost business users are familiar with using work applications like Microsoft Excel. While Excel creates charts and tables to make information easier to read, there’s a function that most users tend to forget, or are unaware of – headers and footers. So let’s see what they are and how adding them to your spreadsheet can help make your data even easier to read.

What are headers and footers?

As with Word, Headers and footers are lines of text that print at the top (header) and bottom (footer) of each page in an Excel spreadsheet. They often contain descriptive text such as titles, dates, or page numbers displayed in page layout views and on printed pages.

Headers and footers are useful in providing quick information about your document or data in a predictable format and also help set out different parts of a document. Simply put, they make calculations, graphs, and pivot tables much easier to read and follow.

How to add and remove headers and footers:

  1. Select the spreadsheet for which you want to add headers or footers.
  2. On the Insert tab in the Text group, click Header & Footer; this displays the spreadsheet in page layout view.
  3. To add a header or footer, click on the left, right or center of the Header or Footer text box at the top or bottom of the spreadsheet page.
  4. You can now add a preset header or footer to your document, or create a custom header and footer.
  5. To start a new line in a header or footer text box, press ENTER; to include a single ampersand (&) in the text of a header or footer, use two ampersands. When you are done, click anywhere in the spreadsheet to close Header or Footer.
  6. Return to Normal page view by clicking on the View tab and Normal button.
  7. To remove the header or footer from a spreadsheet, select the View tab and click on Page Layout. Delete the information you want to remove.

The next time you need to repeat text on a page to make information more organized and easier to digest, you can simply do so with Excel’s header and footer feature. Looking to learn more about Microsoft Office and its features? Contact us today and see how we can help.

Published with permission from TechAdvisory.org. Source.