Blog

October 7th, 2014

Office365_Oct07_AWhen it comes to integrating Microsoft Office into your company, you are faced with two main options: Either purchasing Microsoft Office 2013 or signing up for the cloud-based version, Office 365. With both of these options you do get access to the Office suite, but there is some confusion over what the main difference is between the two product offerings.

What is Microsoft Office 2013?

Microsoft Office 2013 is the latest version of Microsoft's popular Office suite. With apps like Word, PowerPoint, Excel, and more, it is mostly similar to all previous versions of Office. When you purchase this type of Office you receive a number of licenses allowing you to install this on up to five computers or devices - depending on the version (e.g., Home, Student, Professional) of Office that you get.

You can purchase these products outright, as you have done with previous versions of Office, but Microsoft is really pushing their subscription-based version of Office, what they call Office 365. When you subscribe to the Office 365 version of Microsoft 2013, you get the same software as you would if you purchased it outright, the only difference is you pay for it either monthly or yearly, instead of all at once.

What is Office 365 for business then?

Where it gets confusing for many is that in 2011 Microsoft launched a cloud-based version of Office for businesses also called Office 365. Despite the same name as the subscription-based version of Office 2013, this is a different product that is aimed at businesses.

Office 365 for businesses is a monthly (or yearly) per-user subscription service that offers businesses productivity software, enhanced communication apps like email and video conferencing; guaranteed security; and support for intranet and collaboration solution SharePoint.

With Office 365 for business, companies can sign up for a number of plans. Some of them, like Office 365 Small Business Premium and Office 365 Midsize Business, offer full versions of Office 2013 (including Word, Excel, PowerPoint, Lync, Outlook, Notes, Access, etc) that users can install on their computers or mobile devices. Other versions, like Office 365 Small Business, come with Office Web Apps which can be accessed via your browser.

Which is better for business?

Most businesses will benefit more from Office 365 because of the extra features and enhanced security. Not to mention the fact that the monthly per-user cost is usually lower when compared to licensing the same version of Office 2013 for each individual.

Some other benefits Office 365 for Business include:

  • All users are on the same version of Office: Because Office 365 for Business is based in the cloud and is managed via a central admin panel, you can ensure that all users have exactly the same version of Office, which in turn ensures that your files will be compatible.
  • Reduced licensing costs: If you were to purchase individual versions of Office 2013 for your employees, you could end up paying over USD $399 for the Professional version which can only be installed on one computer. Compare this with Office 365 Small Business Premium which costs USD $12.50 per user, per month and offers the same version of Office, along with more features.
  • Enhanced security and uptime: Microsoft guarantees that Office 365 software will be up and running 99.9% of the time, which means the programs you rely on will be available when you need them.
  • It's more mobile: With Office Web Apps and Office 2013 mobile apps you can take your work anywhere. Combine this with solutions like SharePoint which allow you to store documents in a central location, which makes it easier to access your files while out of the office. Beyond that, if you would like to use the Office mobile apps, you will need an Office 365 subscription.
If you are looking to integrate Office 365 into your organization, or would like to learn more, contact us today.
Published with permission from TechAdvisory.org. Source.

September 25th, 2014

WindowsPhone_Sep25_AThe app is arguably the most integral part of any smartphone operating system. It is apps that give our devices the functionality we all want, and the number of apps available is constantly growing. Because of the increase, we are also seeing a rise in malicious software that makes its way onto app stores like the Windows Phone Store. These can pose a security risk, but the question is, how you can spot malicious apps and report them.

To begin with, we should make clear that app store hosts like Microsoft do have strict security measures in place that strive to keep malicious software off of stores and therefore users' devices. That being said, there is always a chance that an industrious hacker can subvert these security controls and get their app onto the online stores. To counter this, here's four tips on how you can spot fake or malicious apps.

  • Look at the name - If you are looking at an app on the Windows Phone Store, always look at the name of the app. Some malicious software that has made its way onto the Store has had a spelling mistake in the name. If in doubt, do a quick search on the Internet for the app and the correct spelling. Should nothing turn up, it may be a good idea to avoid it.
  • Look at the publisher information - All apps for Windows Phones require that the developer/publisher includes information about the app and themselves. If you are looking to download what seems like a popular app, take a look at the listed producer or developer, and then search on the Internet for their site. If the developer of the app appears to be different, or there are differences in the spelling, it is best to avoid installing it.
  • Look at social media stats - On the Windows Phone Store, below the install information, are counters for social media likes and shares. If the app information states it is a popular app and yet there are no social shares, then this may indicate it is actually fake. You should therefore err on the side of caution.
  • Look at comments - Lastly, look at the comments/reviews of the app. The Windows Phone Store uses stars to provide a quick overview of how much people like each app, but if you read comments you can quickly get an idea of exactly what people say about specific apps. If you see words like Fake, Doesn't work, etc. then it is a good idea to skip installing it.
While it can help to be able to identify apps, you should also know how to report apps that you believe are malicious or fake. You can do so by:
  1. Opening the app's page on the Windows Phone Store.
  2. Scrolling down and clicking on Report concern to Microsoft.
  3. Selecting from a list of complaints. Note: Pick the one that is most appropriate to the issue, for example if it is a fake app then select Misleading app.
  4. Pressing Submit.
The plus side of the Windows Store is that Microsoft does usually act quickly to remove identified apps, so the actual chances of you downloading one are fairly low. But, it is always better to be safe than sorry. If you are looking to learn more about Windows Phones and how they can fit into your organization, contact us today.
Published with permission from TechAdvisory.org. Source.

September 24th, 2014

Windows_Sep22_AMany business users who have upgraded their systems to Windows 8, or 8.1, are quick to forsake the tile-based launch screen for the more familiar desktop mode. One of the reasons for this is because of the taskbar which is at the bottom of almost every version of Windows. This bar holds open and popular programs, allowing users to quickly access different programs. However, did you know that you can modify the properties related to the taskbar, in order to make it even more useful?

1. Add or remove programs from your taskbar

By default, there are usually two icons on your taskbar: Internet Explorer and File Explorer. When you open a program, the icon will pop up to the right of these icons and will remain there as long as the program is open. Close it however, and the icon will usually disappear.

If you use certain programs a lot, you can 'pin' the icon to your taskbar, making it easier to launch in the future. This can be done by first opening the program, then right-clicking on the icon and selecting Pin to Taskbar. You can unpin unused programs by right-clicking on the icon and selecting Unpin from Taskbar.

Alternatively, you can drag a program's icon onto the taskbar to add it. Just drag it from the folder or your desktop to where you would like it to be on the taskbar, and it should be added.

2. Locking the taskbar

If you have added the programs you use most, and would like to ensure that they stay on the taskbar, you can lock the bar to ensure that nothing can be added or deleted without first unlocking it. Locking will also ensure that the taskbar can't be accidentally moved.

Locking the taskbar is done by:

  1. Right-clicking on the taskbar.
  2. Selecting Lock the taskbar from the pop-up menu.
Note: When you install a new program, or would like to add/modify those on the taskbar you will need to unlock it first, which can be done by right-clicking on the taskbar and clicking Unlock Taskbar.

3. Hiding the taskbar

While the taskbar is useful, some users prefer that it isn't always showing at the bottom of the screen. You can actually enable hiding of the taskbar, so it will only show it when you hover your mouse over where it should be.

This can be done by:

  1. Right-clicking on an empty space on the taskbar.
  2. Selecting Properties. Note: Don't right-click on an app's icon, as it will open the properties related to the app, not the taskbar.
  3. Tick Auto-hide taskbar.
  4. Click Ok.

4. Move the location of the taskbar

If you have a large number of apps pinned to the taskbar, or don't like it's location at the bottom of the screen you can easily move it by either:
  1. Left-clicking on an empty area of the taskbar.
  2. Holding the mouse button down and moving the cursor to the side of the screen where you would like to move the bar to.
Or:
  1. Right-clicking on an empty area of the taskbar.
  2. Selecting Properties.
  3. Clicking on the drop-down box beside Taskbar location on screen:.
  4. Selecting the location.
If the bar does not move, be sure that it is not locked.

5. Preview open apps

One interesting feature of the taskbar is that it can offer a preview of your desktop from the tile-based screen. You can enable it by:
  1. Right-clicking on an empty area of the taskbar.
  2. Selecting Properties.
  3. Ticking Use Peek to preview the desktop when you move your mouse to the Show Desktop button at the end of the taskbar.

6. Pin apps to the taskbar from the metro (tile) screen

While the tile-based Start screen isn't the most popular with business users, it can be a good way to easily add programs to your taskbar. You can do so by:
  1. Scrolling through your tiles until you find the app you want to pin to the taskbar.
  2. Right-clicking on the app.
  3. Selecting Pin to taskbar from the menu bar that opens at the bottom of the screen.
If you are looking to learn more about using Windows in your office, contact us today to see how we can help.
Published with permission from TechAdvisory.org. Source.

Topic Windows
September 24th, 2014

SocialMedia_Sep22_AFor many small to medium businesses, social media has become an integral part of their overall business strategy. Most businesses have a presence on at least one platform, but one issue many business owners and managers struggle with is how they should be using social media effectively. To help, here is an overview of the three most common ways small to medium businesses use social media.

1. To be a resource for existing and potential clients

This approach is by far the most popular used by businesses of all sizes. The main idea here is that social media is used as essentially a two-way street where you can pass information about the company, products, and industry to your followers. In turn, they interact with the content and eventually start to turn to your profile and page when they are looking for information.

One of the best ways to be successful with this approach is to provide your followers with information about the company, facts, tips about your products and industry, and links to other relevant content.

By sharing content, users will generally interact with it more and begin to see your company as a reliable source of information. This often translates into enhanced brand awareness and potentially sales.

The downside with this approach however, is that it can be time consuming to constantly develop new content. Most companies eventually reach a point where what they produce and share is pretty much the same, and overall payoffs begin to decrease. One way around this is to work with professionals to come up with dynamic and different content.

2. To provide customer service/support

These days, when someone has a problem with a company's services or products, the first port of call for complaints is often social media, largely because it's the most convenient place to vent where you can get instant reactions.

It therefore makes sense to create support or customer service presence on these channels. Some companies have even taken to launching support-centric profiles, where customers can contact them about anything, from complaints to questions, and receive a personal answer. For many companies this is ideal because it eliminates the hassle of customers having to call a support line and dealing with automated machines.

This approach can prove useful for businesses because it often makes it easier to reach out to disgruntled customers and track overall brand satisfaction. The downside is that you will need someone monitoring services 24/7, and to respond in a timely manner which may be tough to do for many smaller businesses.

3. To sell something

There are an increasing number of businesses who have launched social media profiles with the intent of selling a product or service. The actual sales may not take place through social media but the information on these profiles and platforms channels potential customers to an online store or to contact a company directly. Social media's instantaneous nature makes for a tempting platform, especially when you tie in different advertising features and include content like coupons, and discounts.

While this hard sales line can be appealing to businesses, many users are seemingly put off of companies with profiles that only focus on selling via their platforms. The whole idea of social networking is that it is 'social'; this means real interactions with real people. Profiles dedicated only to trying to sell something will, more often than not, simply be ignored.

What's the ideal use?

One of the best approaches for small to medium businesses is to actually use a combined approach. Most people know that ultimately, businesses with a presence on social media are marketing something, but focusing solely on this could turn customers off.

A successful split that many experts have touted is the 70-20-10 rule. This rule states that you should make 70% of your content and profile focused on relevant information to your audience. 20% of content should be content from other people and 10% of content should be related to selling your products or services e.g., promotional.

If you want to use social media for support as well, it is a good idea to create a separate profile dedicated just to this end. If complaints are lodged or noticed using your main account, direct them towards the support account.

As always, if you are looking for help with your social media strategy, contact us today to see how we can help.

Published with permission from TechAdvisory.org. Source.

Topic Social Media
September 23rd, 2014

Office365_Sep22_AMicrosoft's Office 365 is one of the fastest growing productivity software suites, especially when it comes to small and medium business users. When launched a couple of years ago, the company commented that they see Office 365 as one of the best ways to help colleagues get their work done, collaborate, and connect with one another. In an effort to bring this all together, Microsoft has announced a new feature for Office 365 called Office Delve.

What is Office Delve?

The idea behind Office Delve is that it's a tool that helps business users get the most out of their data and information related to Office 365. According to Microsoft, Delve will allow you to:
  • Discover new information - Delve has been designed to show you information from different sources in Office 365 that you may find useful for what you are currently working on.
  • Discover what you need - Documents you have seen before, or have recently worked on, are highlighted and made easier for you to find, regardless of where they are stored. This makes it less taxing to find work you have been doing in the past, and continue from where you left off.
  • Discover new connections - Typing a name in Office 365 will allow you to see what a user is working on, their connections, and even connect with them to build relationships and share information.

How does it work?

In order to provide the information and data that users will likely find useful, Delve is powered by a tool Microsoft calls Office Graph. Graph maps the relationships between the various Office 365 users in your company, and the content/information related to them.

This 'map' is then used by Delve to provide users with what they need, when they need it. Content and information is displayed on a card-based screen, which can be found under the Delve tab in the main Office 365 launch screen.

Aside from content such as profile information, links to documents, or information, users can also see: Likes, views, comments, and tags, which brings a deeper social integration into Office 365.

Delve also orders content a number of different ways, including:

  • What you've recently worked on - Shows you content in card-form that you have recently opened or worked on.
  • Content that has been shared with you - Shows the content your colleagues have shared with you.
  • Content that has been presented to you - Shows content that colleagues have presented recently, or content that has been sent to you.
While this idea works great on the desktop, many Office 365 users access their systems from their mobile devices. Delve will also be available to mobile users. On your device you can browse the cards with files, swipe left or right on each card to view files, and even search for colleagues and view files they have shared with you and their recent activity.

When is Delve available?

Microsoft has noted that Delve is currently rolling out for businesses who have subscribed to the Office 365 Enterprise level plans (E1-E4) and have joined the first release program. Over the following months, it will roll out to all E1-E4 customers. In 2015, Microsoft has noted that they will introduce Delve to Business Essentials, Business Premium, Small Business, Small Business Premium and Mid Sized Business customers.

If you are looking to learn more about Delve, contact us today.

Published with permission from TechAdvisory.org. Source.

September 10th, 2014

Office_Sep08_AHave you ever been working with a list in Excel and had to combine more than two cells into a new cell? The seemingly easiest way to do this is to copy the contents from both cells and paste them into the new cell, then edit them for spacing. But, did you know that there is actually a formula called concatenate that you can use to combine contents and display this in new cells?

Using the concatenate formula to combine cells

If, for example, you have a spreadsheet with first names in column A, last names in column B, and want to combine them into column C to display the full name you can do so by:
  1. Clicking on cell C2 (or the row where the information you want to combine is)
  2. Typing =concatenate(
  3. Clicking on cell A2 and then adding a comma (,)
  4. Clicking on cell B2 and closing the formula with a closing bracket
  5. Hitting Enter
You should see the two cells are now combined in cell C2, with the formula for cell C2 reading:

=CONCATENATE(A2,B2).

The problem is, there will be no space inbetween the letters or numbers, so you will need to edit the formula to read:

=CONCATENATE(A2," ",B2)

The double quotations with a space in between them tells Excel to add a space to the cell in between the contents of A2 and B2.

If you have more than two columns you would like to combine, then simply add a comma after each cell. If for example you have three columns (A1, B1, and C1) you would enter the formula:

=CONCATENATE(A1 " ",B1 " ",C1) in column D1.

Combining two cells without concatenate

While concatenate works well, there is actually a shortcut that you can use which involves the ampersand '&':
  1. Click on cell C2 (or the row where the information you want to combine is)
  2. Type =
  3. Click on cell A2 and then type & in the formula.
  4. Click on B2 and hit Enter
You should see the contents of A2 and B2 combined together in C2. If you click on cell C2 and look at the formula, it should read: =A2&B2.

The only problem is, there won't be a space between the content. To add a space, you can edit the formula so that it reads:

=A2&" "&B2

Note the space between the two quotation marks. This tells Excel to add a space between the contents of A2 and B2.

Once you have the base formula on one cell, you can press the small box at the bottom of the cell and drag it down the row so that the other information can be quickly compiled. This makes it much easier than having to copy and paste the content individually. And, If you would like to learn more Excel tips, contact us today. We can save you valuable time and resources.

Published with permission from TechAdvisory.org. Source.

September 9th, 2014

Office365_Sep08_AWhen it comes to purchasing and implementing public cloud solutions, such as Microsoft's Office 365, business owners know that they are getting pretty much exactly the same product as every other business that uses the same solution. While this uniformity and consistency is positive, users often look for ways to customize the platform so that it relates more directly to a specific company. To enable this, Microsoft has recently announced new customization options for Office 365.

Coming soon to Office 365 (if not already): Themes

In early September, Microsoft announced that in the following weeks the company would be rolling out a couple of new options that will allow businesses to personalize the look of Office 365. In fact, there are not one, but two new personalization options available for Office 365 users with business subscriptions.

Option 1: Company-wide custom themes

The idea of establishing company brand is not a new concept to business owners, who realize that one of the factors to success is creating positive brand recognition amongst stakeholders, including employees. One of the best ways to achieve this is to include identifiable visuals and colors repeated in as many places as possible. Almost every company has colors that they use as part of their corporate image and brand identity.

To help cement your brand with your employees, you can now customize the theme of Office 365 so that the theme is applied to all users in your organization. When it comes to customizing your theme Microsoft has noted that you will be able to:

  • Pick the color scheme, which includes a base color and text/icon colors. Set the base as blue for example, and the menu bar across the top will be that color. Set the text as yellow and all icons/text in the menu bar will also be yellow.
  • Set the color of the Office 365 logo. You can pick up to three colors for the Office 365 logo.
  • Upload a custom logo. You can upload your company logo and have it applied to the top-left of all Office 365 menu bars.
  • Make the logo a clickable link. Once you set a logo, you can also make it clickable by adding a custom URL. When a user clicks the logo, they will be taken to the predefined URL.
If you would like to apply your company's brand to Office 365, and have it automatically applied to all users in the company, you will need to be the admin, or to log in as an administrator. Once you are logged on, click on Admin from the main Office 365 screen. Then, click on your company's hyperlink located at the top-right of the Admin screen (right below the menu bar) and select Custom theming.

In the screen that opens, you will be able to set your desired theme, and when you are finished simply hit Save and the theme should be applied.

Option 2: Personalized themes

While company users can set a theme related to their brand, individual users in the organization can also select their own theme from a list of 22 provided by Microsoft. Each theme changes:
  1. The top navigation bar color scheme
  2. Menu colors
  3. Background
  4. Office 365 logo colors
You can change the theme of Office 365 by logging into your account, pressing the Settings cog at the top-right of the screen and clicking Change theme. Once you have selected a theme you like, press Save and it should be applied immediately.

If you are looking to learn more about Office 365 and how you can get the most out of it, contact us today for a chat.

Published with permission from TechAdvisory.org. Source.

August 27th, 2014

socialmedia_Aug26_AHave you ever looked at images and visuals posted by businesses and users on Instagram? While many users take photos using their mobile devices, there are many images that simply look way too good to be taken with a phone camera, especially the ones without filters. Many business owners want to know how they too can take quality images like these too.

The truth behind some of Instagram's best images

Those awesome Instagram photos we see aren't always taken using mobile phones. Instead, many users use digital cameras which offer much better image quality. You can capture some amazing shots with a higher end DSLR cameras with multiple lenses.

If you have one of these cameras and are looking to create high-quality images for Instagram, or any other social media site, you may be slightly confused as to how to get the images onto the platform - especially since many of us use this via the mobile app. To make uploading a little easier, here is a brief guide detailing how to get images from your digital camera onto Instagram.

1. Transfer and process images

Once you have taken photos with your camera, you will need to get them off of your camera's memory and onto your computer's hard drive. Most camera's have apps that allow you to do this, so be sure to follow the instructions in the app that came with it.

When your images have been transferred to your computer, you are likely going to want to process them a little bit. This is especially true if you have a DSLR or other high-end point-and-shoot which takes RAW images. These can be quite large and are not compatible with Instagram.

Most images taken with a camera are quite large in size, so you are going to need to use an image editing program like Adobe Photoshop, or free tools like Pixlr to process them. What you are looking to do is to crop your images so that they are square.

If you are used to the advanced photo editing features, then do your edits before cropping. When you crop your images you should crop or resize them so that they are 640X640 pixels. This is the size of all images taken using Instagram's camera app.

Also, be sure to save the images as JPEGs, as this is the image format used by most smartphone cameras.

2. Save processed images in their own folder

It helps to create a folder somewhere on your hard drive (we recommend in the same folder where you save all of your other folders) that is specifically for images you want to post on Instagram.

When you have processed and edited the images to your liking, save the images here. Try using an easy to use file name like the date and a letter or note so you can easily tell which images are which, so you know which to use.

3. Move the images to your device

You can move images using the cloud or by manually transferring the images to your phone. If you decide to manually transfer your files, you will need to plug your device into your computer.

For users with iPhones, you can open iTunes and click on your device followed by Photos. Then select the box beside Sync photos from. Select the file you created in the step above and then Sync to transfer the images over.

For users with Android devices, plug your phone into the computer and drag the folder you created in the step above into the Photos folder of your Android device.

For Windows Phone users, plug your device into your computer and open My Computer on your desktop. You should see your device listed in the window that opens. Open the file system for your device and drag the image files you created above into the Photos folder of your phone.

If you choose to use the cloud to transfer your files, use the operating system's cloud (e.g., iCloud, Google Drive, or OneDrive) to upload the files. Just be sure to use the same account as the one on your phone.

4. Add images to Instagram

Once the photos are either on your device, or in the cloud, you can now upload them to Instagram. This can be done by:
  1. Opening the app and tapping on the camera icon.
  2. Tapping on the button in the bottom left of the screen.
  3. Selecting where the image is located on your device. E.g., the Gallery app if you placed the photos in your phone's hard drive, or the cloud service you used.
  4. Editing them as you see fit.
Once this is complete, you should be able to post your images as you usually do with any other Instagram image on your phone. Take the time to add filters, and hashtags as well as a good description before you post.

If you would like to learn more about using Instagram to share your images then get in touch and we will show you the advantages of the bigger picture.

Published with permission from TechAdvisory.org. Source.

Topic Social Media
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 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.