Blog

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

VoIP_Aug18_AVoIP, or Voice over Internet Protocol, has become one of the main forms of voice communication used in businesses of all sizes. Because the system uses an Internet connection, many companies often experience decreased costs while being able to do more with than they could with their traditional phone line. While almost every business can benefit from VoIP, there are a few important issues businesses who are considering switching over should be aware of.

1. Faxing can be tough with VoIP

Fax machines were designed on an analog system and therefore may have trouble working with a digital system like VoIP. This is especially true for businesses who are using older fax machines. We aren't saying faxing is impossible, but you likely will not be able to simply plug your fax machine into a VoIP line and start sending/receiving faxes.

What you will most likely need is to install a few extra components such as an adapter that supports T38 protocols. The T38 protocol was developed specifically to change analog fax signals into a digital that can then be sent via VoIP.

Therefore, if you use fax machines in your office, you should be sure to ask potential providers if their systems support faxing, and if your machines will be supported, or if there are any extra components needed.

2. Credit and debit terminals may not be compatible

Many business owners who look to move to VoIP systems often forget to also look at how their payment systems work. If you are using older credit or debit terminals on a landline they may actually be dial-up based, which means they will not work with VoIP. While most businesses already use newer models that support ethernet connections, and therefore VoIP, some are still using older systems. If this is the case, then you will need to contact your terminal provider for an upgrade, or new IP-terminals.

3. Older alarm systems may not work

Businesses with physical storefronts likely have alarm systems in place. The problem with this is that many older systems rely on traditional phone lines in order to signal emergency services should the alarm go off. If you are planning to upgrade to VoIP, you should make sure that the alarm system you have is compatible, or can be connected to VoIP.

If this is not the case, you may need to upgrade to a more modern alarm system. We strongly recommend checking with both the alarm provider and your VoIP provider if your alarm systems will still work.

4. VoIP requires broadband connections

We have seen cases before where businesses have invested in a VoIP system only to find out they don't have a broadband connection that is strong enough to support VoIP effectively. In order for VoIP systems to function, you need to have a broadband connection with a fairly strong amount of bandwidth. This is especially important for businesses in rural areas where broadband speeds can be limited based on distance.

It can be tough to figure out if your broadband connection will support VoIP, but you can test the connection before you agree to purchase it. Asking a potential provider for help testing your line would be a good idea. Should your connection prove to be too slow, then you will need to contact your Internet Service Provider in order to upgrade your speed.

5. VoIP needs to be managed

Like every other tech system, you will need to manage your VoIP solution. This includes adding new lines, upgrading equipment, ensuring systems are compatible, etc. For many business owners this will require extra time they don't necessarily have. One of the best solutions we can recommend is a managed VoIP solution.

We offer VoIP solutions, so if you are looking to learn more about VoIP in your business, and would like to avoid the common mistakes made by others, contact us today to learn more about how our expertise can help.

Published with permission from TechAdvisory.org. Source.

Topic VoIP General
August 25th, 2014

Security_Aug18_AIt seems like nearly every week, and in some cases nearly every day, there is some security breach announced. The vast majority of these assaults tend to revolve around online user accounts, where password, account information, and even usernames are stolen. Over the years, there has been a general trend where the number of accounts breached or compromised is growing, and in early August news broke about possibly the biggest breach to date.

The latest big-scale breach

In early August, it emerged that a Russian hacker ring had amassed what is believed to be the biggest known collection of stolen account credentials. The numbers include around 1.2 billion username and password combinations, and over 500 million email addresses.

According to Hold Security, the company that uncovered these records, the information comes from around 420,000 sites. What is particularly interesting about this particular attack is that such a wide variety of sites were targeted when compared this with other attacks which tend to either attack large brand names or smaller related sites.

How did this happen?

Despite what many believe, this was not a one-time mass attack; all sites that were compromised were not attacked at the same time. Instead, the hacker ring - called the Cyber Vor - was likely working on amassing this data over months or longer. How they were able to amass this much information is through what's called a botnet.

Botnets are a group of computers infected by hackers. When the hackers establish a botnet, they attack computers with weak network security and try to infect them with malware that allows the hacker to control the computer. If successful, users won't even know their computer has been hacked and is being used by hackers.

Once this botnet is established, the hackers essentially tell the computers to try to contact websites to test the security. In this recent case, the computers were looking to see if the websites were vulnerable to a SQL injection. This is where hackers tell the computers in the botnet to look for fillable sections on sites like comment boxes, search boxes, etc. and input a certain code asking the website's database to list the stored information related to that box.

If the Web developer has restricted the characters allowed in the fillable text boxes, then the code likely would not have worked. The botnet would notice this, and then move onto the next site. However, if the code works, the botnet notes this and essentially alerts the hacker who can then go to work collecting the data.

So, is this serious and what can I do?

In short, this could be a fairly serious problem. While 420,000 sites may seem like a large number, keep in mind that the Internet is made up of billions of websites. This means that the chances of your website's data being breached by this ring are small. That being said, there is probably a good chance that one of the sites related to your website may have been breached.

So, it is a cause for concern. However, you can limit the chance of hackers gaining access to your information and a website's information.

1. Change all of your passwords

It seems like we say this about once a month, but this time you really should heed this warning. With 1.2 billion username and password combinations out there, there is a chance your user name for at least one account or site has been breached.

To be safe, change all of your passwords. This also includes passwords on your computer, mobile devices, and any online accounts - don't forget your website's back end, or hosting service. It is a pain to do, but this is essential if you want to ensure your data and your website is secure from this attack.

2. Make each password different

We can't stress this enough, so, while you are resetting your password you should aim to ensure that you use a different one for each account, site, and device. It will be tough to remember all of these passwords, so a manager like LastPass could help. Or, you could develop your own algorithm or saying that can be easily changed for each site. For example, the first letter of each word of a favorite saying, plus the first and last letter of the site/account, plus a number sequence could work.

3. Test your website for SQL injection

If you have a website, you are going to want to test all text boxes to see if they are secure against SQL injection. This can be tough to do by yourself, so it's best to contact a security expert like us who can help you execute these tests and then plug any holes should they be found.

4. Audit all of your online information

Finally, look at the information you have stored with your accounts. This includes names, addresses, postal/zip codes, credit card information, etc. You should only have the essential information stored and nothing else. Take for example websites like Amazon. While they are secure, many people have their credit card and billing information stored for easy shopping. If your account is hacked, there is a good chance hackers will be able to get hold of your card number.

5. Contact us for help

Finally, if you are unsure about the security of your accounts, business systems, and website, contact us today to see how our security experts can help ensure your vital data is safe and sound.
Published with permission from TechAdvisory.org. Source.

Topic Security
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 21st, 2014

BValue_Aug18_AIn many countries around the world, businesses are required to meet the needs of all employees. For able-bodied employees, one system will usually be able to meet needs, but disabled employees may have different requirements. Therefore, businesses should ensure that they develop an accessible technology plan.

What is accessible technology?

Accessible technology, also commonly referred to as assistive technology, is the idea of creating or implementing technology and systems that cater to employees with disabilities. While not every company will have or require accessible technology, it is required by many countries that businesses meet the needs of disabled employees.

To that end, it is a good idea to develop a plan on how to implement accessible technology. To help, here are five steps you could take:

1. Defining your strategy

The accessible technology strategy should be the first thing you develop as it will be the foundation of the overall plan. When looking at your strategy you should define how accessible technology fits into your overall organization plan and how it will fit with your existing strategies.

What you are looking to do is to figure out how this form of technology will fit with existing systems and increase overall operating effectiveness. From here, you can define the overall objectives, budget, and vision for the plan.

2. Identifying requirements

In this step, you should look closely at existing technology in the organization and the needs of your employees. Because each company is different and the needs of employees are different you should be careful to also identify the technology needs of your employees.

When looking at both the needs and existing systems you can work to come up with an overall set of requirements, along with a general priority. For example, will you need to modify existing computers or purchase new ones?

The key idea here is that you need to figure out exactly what you need.

3. Picking the new technology

Once you have identified what changes you need to implement, what new technology you will need, and your budget, you can then begin looking for the best solutions. The most effective way to do this is to work with it experts like us who can help you find and integrate the best technology and changes that will meet your adaptive technology needs.

4. Implementing and training

Once you have defined the changes, and new technology to integrate, you need to implement it. This may include altering physical devices and machines where necessary, and then testing the systems to make sure they are working properly.

It is also be a good idea to train your employees who will be using the systems, and the team who will be managing the systems.

5. Maintaining

As with all tech systems, it is important to realize that the solution you implement will not work forever, and will eventually require maintenance, updating, or even replacing. You should take steps to audit systems on a regular basis to ensure they are still meet the needs of your company and employees.

This can be a time consuming and potentially costly step, especially if you neglect it. We strongly recommend working with a company like ours, who can help manage your solution and ensure that updates and any necessary changes are implemented when they are needed, and that should needs change, systems are subsequently updated to meet the new requirements.

If you are looking to implement accessible technology in your business, contact us today to see how we can help.

Published with permission from TechAdvisory.org. Source.

August 19th, 2014

Facebook_Aug18_ASince its release, Facebook has gone from a college-only network to international site that connects millions of people. With more than half of adult users having more than 200 friends on average, our News Feeds have become a highly congested and constantly changing collage of stories and posts. Many of these posts are links to articles that we find interesting. While we would love to drop everything and read a particular link there are times when this isn't possible. To help, Facebook has introduced the new Save feature.

About the Save feature

The idea behind the Save feature is that it allows users to save longer-form content like articles posted on a News Feed. So, if someone has posted a link to an article on your favorite blog and you would like to read it later, you can now save it.

While this feature is similar to various apps like Pocket and Readability, which allow users to save content on the Web to read later, Facebook's version goes a little deeper. In a blog article announcing the feature, the company noted that the Save feature allows users to, "Save items like links, places, movies, TV and music."

Let's say you are at work, and during your break you quickly check Facebook. You come across a post where your friends have shared a link to a restaurant's Facebook Page. If you don't have time to visit the page right at that moment you can save it to view later.

While this feature will prove useful for many users, it is worth noting that when you save content, e.g., an article, you will need to have an Internet connection to access it in the future. Knowing Facebook however, they may integrate a feature like this in the future.

How to save content for later

Facebook has integrated this feature into all versions of Facebook, including the mobile app and browser-based versions. You can save content and links by:
  1. Scrolling through your News Feed until you find an article, link, Place, etc. that you would like to save for later.
  2. Clicking on the downward facing grey arrow at the top-right of the post.
  3. Selecting Save 'content name'. Note: The name will be based on the name of the link in the post.

Accessing your saved content

If you are looking at Facebook in your browser, then you should see a tab called Saved show up in the upper part (the area just below your profile image) of the left-hand vertical bar of the page. For users who access Facebook via the mobile app, press the three horizontal bars at the top-right of the app (located just below the magnifying glass) and you should see a section called Saved under Favorites.

When you click on Saved you should see a new screen open with the content you have saved. It will be divided into different types including:

  • All
  • Links
  • Places
  • Music
  • Books
You can interact with each item by either:
  • Tapping on it - This will open the page, link, or content.
  • Sliding it to the left - This will allow you to archive the content or press More to review, share or Like the content.
If you are looking to learn more about the Save feature, or Facebook in general and how it can be used effectively in your business, contact us today.
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

The amount of data both available to, and generated by, a company is increasing exponentially. While some smaller to medium businesses are coping fine with the growth, many are struggling with managing their data, let alone leveraging it to help make better decisions. If you find that your business isn't coping with data, one solution may be to implement a data warehouse.

What is a data warehouse?

A data warehouse is a system used by companies for data analysis and reporting. The main purpose of the data warehouse is to integrate, or bring together, data from a number of different sources into one centralized location. The vast majority of the data they store is current or historical data that is used to create reports or reveal trends.

Possibly the biggest benefit of a data warehouse is that it can pull data from different sources e.g., marketing, sales, finance, etc. and use this different data to formulate detailed reports on demand. Essentially, a data warehouse cuts down the time required to find and analyze important data.

While not every business will need one right this minute, a solid data warehouse could help make operations easier and more efficient, especially when compared with other data storage solutions. That being said, it can be tough to figure out if you actually need one. In order to help, we have come up with five signs that show your business is ready to implement a data warehouse.

1. Heavy reliance on spreadsheets

Regardless of business size, the spreadsheet is among the most important business tools out there. Used by pretty much every department in a company, they can be a great way of tracking data. The problem many business owners run across however is that spreadsheets can grow to immense sizes and can become unwieldy.

Combine this with the fact that each department has spreadsheets that you will likely need to pull data from in order to generate a report. If this is the case, you are creating manual reports, which can take a lot of your time.

If you are struggling to find the data you need because it is spread out across different sheets, in different departments, then it may be time to implement a data warehouse.

2. Data is overwhelming your spreadsheets

Spreadsheets are designed to operate with a set amount of data (rows and columns). Reach, or exceed this limit, and you will find that the file becomes sluggish or will downright prevent you adding more data.

While it can take a while to get to this point, companies will reach it if they keep adding to their data. At this point you will see a drop in productivity and overall effectiveness in how you use your data. Therefore, a data warehouse that can combine data from different sheets may be a great solution.

3. You spend too much time waiting

If you set out to develop a report, only to find out that you need to wait for colleagues to provide the information on their spreadsheets, or to analyze their data, you could find yourself waiting for a longer than expected time.

This makes you highly ineffective and can be downright frustrating, especially if employees are too busy or just can't provide the information needed. Implementing a data warehouse can help centralize data and make it available to all team members more effectively. This cuts down the time spent actually having to track it down and communicating with colleagues.

4. Discrepancies in data and reports

Have you noticed that when team leaders or members in different departments create reports that the data or findings are different from yours, or other reports? Not only is this frustrating, it is also time consuming to sort out and could lead to costly mistakes.

This can be amplified if some departments have data sources that they don't share with other teams, as this can throw doubt into the solidity of your data and other reports. If you have reached this point, and realize that there are discrepancies in your data, it may be time to look into a data warehouse which can help sort out problems while ensuring mistakes like duplicate data are eliminated.

5. Too much time spent generating reports

Ideally, we should be able to generate a report using existing data almost instantly, or with as few clicks as possible. If you find that when generating a report you have to keep going to different sources to check if the data is updated, or to keep manually updating other sources, you could quickly see the amount of time needed to develop a report grow.

Because data warehouses consolidate data, you only have to turn to one source for data. Combine with the fact that many data warehouses can be set up to automatically update if source data is updated or changed, and you can guarantee that the data you are using is always correct.

Looking to learn more about data warehouses, or about the different data solutions we offer? Contact us today.

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.

August 12th, 2014

Office365_Aug11_AEarlier this year, Microsoft introduced Office for the iPad. These apps are touch-optimized versions of the popular Office programs. They enable users to access, edit, share, and create various Office files. From Excel to Powerpoint and Word, the major apps are all represented, and are fully featured if you have Office 365. In an effort to enhance the functionality of Office on the iPad, Microsoft has recently released a number of updates specifically for Excel and PowerPoint. There are also some changes that affect all apps. Here is an overview of the new updates.

Excel updates

There are three major updates that have been introduced to the iPad version of Excel:
  • Increased pivot table interaction - These tables are among the most useful for business users working with data. With the new update you can now filter, sort, collapse, and expand details. You can now also refresh pivot tables whereby data is pulled from the workbook. Beyond this, you can also change the visual style and layout of the tables.
  • Flick to select large amounts of data - Working with large amounts of data, or spreadsheets with a large number of rows and columns can be tough on the touch screen. So, to make things easier, you can now select large amounts of data by flicking. For example, if you want to select all the rows in one column, you can simply tap on the selection handle of the top row and flick down to select the whole column.
  • Easier manipulation of data - While touch screens are great, and useful, there are times when working with spreadsheets using a keyboard is much better. In the latest update, Microsoft has added increased support for keyboards. This includes support of many familiar keyboard shortcuts, like CTRL+2 which allows users to switch between cell entry modes.

PowerPoint updates

As with Excel, there are three updates that have been introduced to the iPad version of PowerPoint:
  • Presenter View - Many people had taken to using their iPad to run presentations while connected to a projector. In the previous version, your iPad would just show what was actually on the screen, but now you can enable Presenter View. This view shows your slide notes on your iPad's screen, as well as the slides that are coming up next while your presentation runs via the projector.
  • Easier inclusion of visuals - With the new update, all embedded videos and sound recordings now play natively over your iPad; meaning they will play directly from a presentation. You can also add media directly to a presentation from your iPad's Camera Roll, which means you can record and add content all from your iPad.
  • Better annotation tools - There are a number of new annotation tools, including an improved pen and eraser which are designed to make annotations on the iPad's touch screen show up on presentations more easily.

Updates across all apps

Microsoft has been listening to the feedback from Pad app users, and has introduced the three most requested features that apply to all three main apps: Word, PowerPoint, and Excel.
  • Send the file as a PDF - PDFs are one of the most versatile document formats for businesses. Because most systems have software to open these document, it's great for users who don't use Office. Now, you can send the document you are working on as a PDF directly from your iPad. You can find this option under the Share menu.
  • Better image editing - With the update, you can now tap on an image in any Office app to either crop or resize it. If you make any edits, and find they aren't to your liking, there is also the ability to revert to the original image by pressing Reset.
  • Support for third-party fonts - Some businesses prefer to use fonts that aren't included in Office. Up until now, only Office supported fonts could be used on the iPad, but the recent update implements support for third-party fonts (fonts not made by Microsoft) installed on your iPad.
If you are looking to learn more about Office 365 and iPad apps, contact us today to see how we can help.
Published with permission from TechAdvisory.org. Source.