Blog

April 5th, 2014

iPad_March02_AMicrosoft Office has long been not only one of the most popular office productivity suites but also one of the most requested business apps for iPad users. Ever since the release of the iPad business users have been clamouring for a tablet version of Office. Well, Microsoft has been listening and has recently released a tablet optimized version of Office for the iPad.

Wait isn't that Microsoft Office Mobile?

Earlier last year Microsoft introduced Office Mobile for Office 365 subscribers. With this app users could access, create, and edit Office documents on a mobile device. The only issue with this app is that it is optimized for smaller screens e.g., the iPhone. While it is possible to use it on your iPad, optimized apps specifically for the iPad have until now been lacking.

In late March this year, Microsoft finally released iPad specific versions of Word, PowerPoint, Excel, and OneNote. Anyone with an iPad Mini, iPad 2,4, and Air can download the apps for free from the App Store and view any related Office documents on their device.

How Office for iPad works

The best way to think of these apps is that they are simply touch versions of the popular Office programs that have been developed specifically for the iPad. Here's four things you should know about the apps:
  • They're free - Currently the Word, Excel PowerPoint, and OneNote apps are available to download for free from iTunes. It is highly likely that more apps will be coming soon.
  • The program links closely with your OneDrive account - OneDrive was SkyDrive until Mid February when Microsoft renamed their cloud storage service, thus allowing you to create documents on the desktop version of Office and then save them to your OneDrive and work on them on your iPad.
  • Document formatting is supported - The iPad versions of the apps have the same formatting features as the desktop versions. Any formatting changes you make to documents on the desktop version can also be made on the iPad.
  • Excel has a unique number pad - Many iPad users don't have a keyboard, and the numbers on the stock iPad keyboard require a number of button hits to reach. To increase usability, Excel on iPad has a special numerical keyboard.

Two caveats

We noted above that the apps are available for free. While this is correct, you will only be able to open and view documents. If you want to edit you will need an Office 365 subscription. The following Office 365 plans will allow you to open, edit, and save documents:
  • Office 365 Home
  • Office 365 Small Business Premium
  • Office 365 Midsize Business
  • Office 365 Enterprise E3 and E4
  • Office Education A3 and A4
  • Office 365 ProPlus
  • Office 365 University
  • Office 365 trial subscriptions
While the vast majority of features found on desktop apps can also be found on the iPad versions, there is one missing - for now: Printing. At this time, printing documents directly from the app is not supported. Microsoft notes that they are working on this and that this function will be introduced in a future update. For now however, your best option is to save files to OneDrive and then open these on your desktop and print from there.

Getting the apps set up on your iPad

If you have an Office 365 subscription getting the apps setup may be a little confusing. Here's how you can do it:
  1. Download the apps from the App Store. (Make sure you have enough free space on your device). You can find the apps by opening iTunes and searching for: Office for iPad. Note: You will need to download each app separately.
  2. Open the app and you should be asked to log in using your Microsoft account. If your business uses Office 365, or if you have an Office 365 account, enter your username and password as you usually do to access the Web and your email.
If you choose to log in using a free account to begin with, you can upgrade to an Office 365 account from the app. This can be achieved by opening the app, and clicking Activate which should be located at the bottom left of the main menu. You can then follow the app's steps to purchase an Office 365 subscription through iTunes. Alternatively, you can go to the Office 365 website and subscribe through here. Once you open the app, after your account has been updated, you should be able to access, edit, save, and share documents.

Should I get this app?

Office 365 is one of the most popular versions of Office for small to medium businesses, and many users are wondering if they should download the app to their iPad. The answer to that is that it depends on whether you want to use your iPad for work or not.

Generally speaking, business owners who have an iPad and Office 365 subscription will benefit from downloading this app. The main reason is because it offers another way to connect with the office and potentially increase productivity, especially when you are away from your desk, through greater flexibility.

If you don't have an Office 365 subscription but use Office in your business, the iPad versions of Word, Excel, and PowerPoint could be useful, especially if you only need to view documents. That being said, you might want to consider updating to Office 365 in order to gain full access.

Contact us today to learn more about the different plans available for your business.

Published with permission from TechAdvisory.org. Source.

Topic iPad
April 5th, 2014

Security_March31_AMalicious software (more commonly known as malware) can be found on almost any system, most often being downloaded and installed on computers. It can cause a myriad of annoyances, like unwanted pop-ups and system freezing, and some forms can even gain unauthorized access to your PC, stealing personal information. It's therefore essential that malware is prevented. Malware on work computers can disrupt a company’s operations and may put the security of data in jeopardy.

Signs of a malware infection

Before proceeding with the steps on how to respond to malware infections, we first need to learn about the signs and symptoms of a malware infection. These include:
  • Several pop-ups appear even when not browsing the Web.
  • Unusual slowness of the computer and Internet connection.
  • System hangs or freezes.
  • Corrupted programs.
  • Antivirus is disabled.
  • E-mails sent to or from your account which you did not send.
  • High network activity, even when not using large programs or accessing huge data.
  • Redirected access to some sites.

How to respond to a malware infection

In case you experience any of these symptoms, the first thing to do is to ensure that your antivirus and antispyware program is updated. This is to make sure that they detect the latest known threats on their database. You should then run scans to see if an infection is detected. If it is, the programs usually have a way to remove the infection. You then need to follow the steps the program recommends.

If this doesn't work, disconnect the infected computer from the network to prevent the spread of the malware. Furthermore, avoid accessing the Web and using vital information such as bank account and credit card information. Let the technical department or your IT partner handle the concern since they are trained in determining and eradicating system malware infections.

Once the problem has been pinpointed, a tech specialist will go through the process of eliminating the infection. This includes backing up data on the computer and restoring the system to its original state. Depending on the extent of the infection, the computer may need to be wiped clean, or reformatted before restoring backed-up files.

After the whole process, the computer must be tested to ensure that the infection has been totally removed. Moreover, further investigation and studies must also be done to determine where the problem started, as well as to create a strategy as to how to prevent this from happening in the future.

How to prevent a malware attack

Prevention is better than a cure and this definitely applies to malware infections. It’s best to arm yourself with knowledge on how to avoid malware attacks and prevent your systems from being infected.
  1. Ensure that security protection is always updated and that you run system scans on a regular basis.
  2. Avoid downloading attachments or clicking links from unknown sites or senders.
  3. Enable firewall protection.
Malware can hugely affect business operations and the security of private information. One of the best ways to prevent this is to work with an IT partner, like us, who can help recommend and install protection systems. You might want to think about getting help in managing these solutions too, to ensure that your systems are secure at all times.

If you have questions or concerns with regards to malware prevention and resolution, feel free to call us. Our support team is always ready to help.

Published with permission from TechAdvisory.org. Source.

Topic Security
April 4th, 2014

iPhone_March31_AThe Calendar application is one of the built-in features that comes installed on every iOS device, including the iPhone and iPad. It has the important basic functions that you need in a calendar, including adding events and the ability to share events. Syncing with other calendars is also possible. By default, Calendar is set to begin each week on Sunday, but this can actually be modified if needs be.

Why change the day your week starts on your calendar?

If you go into Calendar and note that your regional setting is set to United States, for example, you may notice that the day of the week starts on a Sunday. This is true even with other regional settings. While it is technically correct that Sunday is the beginning of the week, you may still want to change the day so that your week starts based on your native calendar or even when your work week begins.

Often people see Monday as the start of the week because it is usually the start of the working week. You might find it more convenient if this is also reflected in your calendar setup. Moreover, your calendar might appear more organized if your weekends are next to each other. With the default setting, Sunday and Saturday are on the left and right side, with the work week in between.

How to change the beginning of your work week

There are two ways to change the day that your week starts on Calendar. One method is changing the country in the regional setting and the other one is by changing your Calendar's date setting. However, take note that changing the regional setting will also affect other features in your device such as the time format and the number that appears on your screen when someone calls. If you don’t want to take any chances, it’s best to follow the calendar setting method.

Here’s how to change the day your week starts on your calendar setting:

  1. Tap the Settings icon on your device.
  2. Scroll to Mail, Contacts and Calendars then tap on it.
  3. Go to Calendars and select Start Week On.
  4. Tap your preferred option and Calendar will make that the start of your week.
If you would like to be a little different, you can change your regional settings by:
  1. Going to Settings.
  2. Choosing General.
  3. Selecting International.
  4. Tapping Regional Format.
  5. Selecting the country or region of your choice
As mentioned, this may affect other features on your device, including the time and the way phone numbers are displayed. If you work with colleagues or clients from other regions, this might not be an issue for you.

If you have any questions about your devices and how you can use it in your business then get in touch. Our friendly and knowledgeable support team are happy to assist you.

Published with permission from TechAdvisory.org. Source.

Topic iPhone
April 3rd, 2014

Productivity_Mar31_APresentations are an integral part of any business, regardless of size. There is a good chance that you will have to give at least one presentation in your career, with many people giving so many they lose count. Many small businesses are starting to hire remote workers or carry out business over large distances, which forces them to create presentations online. However, with this type of presentation it can be especially hard to attract and keep an audience's attention.

If you are creating an online presentation to a remote audience there are a number of factors you should keep in mind if you want to grab your audience's attention and keep them following and paying attention. Here are five of the most important tips:

1. Make it visual

For the most part, visual presentations have a higher chance of success - that is, the message being grasped by the audience. This is especially true for online and remote presentations, largely because when more people are on a computer, partaking in a presentation, they will often be multi-tasking.

If you have a ton of text there is a good chance you will lose your audience within the first couple of slides. Instead aim for a presentation that is heavy on graphics and visually appealing. Using bright or contrasting colors will draw the eye and will increase the time you have your audience's attention.

If your presentation is about a product create picture slides with a minimal amount of text; let the product speak for itself. For presentations involving graphs and charts, include these graphics and a couple of key points. The rest you can fill in with spoken narrative.

2. Focus on the audience

Online presentations and those using meeting software should be audience-friendly. This means making it easy for them to join and partake in the presentation by sharing slides, and also asking if anyone has any points to add or even expand upon with an interactive presentation element.

While presenting, there will be slides and points that are more important than others. To highlight this you can 'sign-post' the salient points. Make these visually larger if they are text, and pause to point this out with the script by telling your audience: "This is the most important point"; essentially demanding they pay attention.

Finally, try to limit technical glitches. This can be the quickest way to lose engagement if your Internet cuts out or the computer crashes. Try to present at a time when you know connection will be strong and stable and have a backup in place in case something goes wrong.

3. Adapt to different audiences

Every person in the audience will have different expectations of your presentation. Some will want just the facts, while others might be looking to be convinced by an opinion or argument expressed in the presentation. You should take the time to get to know your audience and what they expect and then develop the presentation around this idea.

If you do your homework and know a bit about your audience, you can take steps to connect with them early in the presentation, if not before, and drive engagement.

4. Create, edit, practice, edit, practice, edit, practice, present

It may sound a bit redundant to edit and practice multiple times, but it really will help when leading an online presentation. First you should create your presentation, then edit it. You are looking to keep your slides as short as possible - no more than four points and two minutes spent talking for each slide.

Really the first edit should be about content, grammar and spelling. Once this is done, practice presenting as you would on the actual presentation day. Start with a blank desktop screen, log into the software/site you will be using, load the presentation, share it, and then actually present. Time yourself and note any issues.

Next, go back and edit the presentation some more, making sure you aren't spending too much time on one slide or that each of the slides does not have too many confusing points, etc. Keep practicing and editing until you are not only comfortable, but know the content inside and out.

You could also try recording your voice. This will allow you to hear where you need to work on inflection and overall style. If you find that you are tuning yourself out when you listen to the presentation, you may want to practice some more and try to inject some extra interest, whether through humor or engaging facts and ideas. This is really vital is you won't have that face-to-face contact with a physical presentation where you are present. If you sound engaging, the audience are more likely to connect with you.

5. Develop your own style

No one likes a dull presentation where you just talk about what's on the slides. Try to give your presentation a narrative arc and structure. Where possible include personal experiences or even tell a relevant joke from time to time. If you are passionate and show that you are trying to connect your audience will likely not click away from the presentation or drift off to other work or simply to surf the Internet and Facebook.

If you are looking to learn more about presentations and how to use software for expert presentations, or even how to conduct your next remote presentation, contact us today to see how we can help.

Published with permission from TechAdvisory.org. Source.

Topic Productivity
April 3rd, 2014

BusinessValue_Mar31_AThe website is one of the most important marketing and branding tools a small business can utilize. Potential and even current customers visit business websites looking for information and will often judge whether they will purchase from this point. That means that your site needs to be designed properly. In order to achieve this it pays to be aware of the common mistakes businesses make when designing their corporate website.

The business value of a business website is that it creates a solid online presence and boosts your brand image and market reach. Even if your business is not Internet based, a website can be used to create a certain impression and ultimately contribute to your bottom line. The key is to make sure you create the best impression. Here are six of the most common mistakes businesses make with website design:

Mistake 1: Building for the sake of building

Websites are important and some businesses believe that they should have a website, so they go ahead and simply build one. You should first take steps to define your target market - who is it that you want and expect to visit your website.

Once you have a defined target market you can then take time to build your site for your market. For example, if the majority of your target market uses mobile devices to browse the Web you should take steps to design your site so that it is viewable on mobile devices.

You should also determine what you want visitors to do on your site. Some companies want them to click through to another site, while others want them to sign up. By defining how you want your visitors to interact you can then develop your content and design around this.

Mistake 2: Designing a website that is too busy

It can be tempting to put all of your information on one page or even have a ton of images and videos. The truth is, this can be distracting largely because once someone lands on your page, they won't know how to get around, find the information they want, or even to know what they should do next.

Busy or flashy websites with lots of animations or large amounts of text also usually don't scale all that well. So, when someone looks at your site on a mobile device they will likely find it too hard to navigate and leave, which is counter to what you are trying to achieve.

Instead, aim for a website that is simple and clean. Important information should be quick to find and read and it should be clear who you are, what you have to say, and what you want the visitor to do.

Mistake 3: Lacking call to actions

Most business related websites have a goal as to what they want visitors to do. Maybe it's download an app, call the company, or even sign make a purchase online. It is essential that you lead visitors toward what you want them to do in the most clear and concise way. The best way to do this is through a call to action. These are usually buttons at the bottom of sections or pages that motivate the user to click and follow the instructions on what to do next, be that sign up to something or get in touch.

The best calls to action stand out from the content, drawing the reader's eye and hopefully inspiring them to click. They should also be clearly written, simple, and direct. e.g., 'Call us today!' or 'Download now!'

Mistake 4: Misguided content

It may seem worthwhile to write in-depth content about your products or services but this isn't always the case. People skim read the basics on the Web and it's different than other mediums.

What you should do is condense down your content so that it only states the most important information. Tell the reader what your product or service does and provide a few of the most important benefits. What you are looking to do is develop enough interest so that visitors to your site will click on the call to action and connect with you.

If you have the time and profits, creating a more visual site where you showcase the products or show how you can help in a short video may lead to higher engagement and possibly higher customer conversions. Take a look at the popular software and service sites like Dropbox, Microsoft, and Google. The content is highly visible and simple, yet provides just enough information so the user knows what the service is and what they are expected to do.

Mistake 5: Static content

It can be tempting to invest the time to write a great website, get the content online then just leave it sitting there. The Internet changes and what might have been regarded as great website design and content a couple of years ago may not be seen in the same light today.

It is advisable to periodically update your site's design and content to reflect current trends; making it more modern. Another related aspect of your content is that you need to ensure that your content is up-to-date. If you are hosting a contest and put the information on your site, you should make sure to take it off of your site, or update it when the date passes. It looks a little unprofessional to have content that is still talking about 2012 or even 2013.

Mistake 6: Doing it yourself

The vast majority of small business owners and managers don't have in-depth Web design skills, yet are determined to build their company's website themselves. This can lead to unexpected problems or a website that doesn't meet your needs. We strongly recommend that you work with a qualified designer who can help ensure that your website is designed and built to high standards.

If you are looking to boost your website's design contact us today. We can help!

Published with permission from TechAdvisory.org. Source.

April 2nd, 2014

Facebook_March31_AWith Facebook change is the rule not the exception. However, changes can be a challenge for business users to keep track of. One of the most common features that is changed or updated, is the algorithm that determines what content is shown on a user's News Feed. With many of the recent feature changes many business owners are commenting that it feels like they are being shoehorned into buy ads in order to reach their audience. While ads can be beneficial, one way to get your content in front of users is by improving your newsfeed performance.

There are many ways you can improve your News Feed performance and the best is to improve the reach of your content. Before we get into how you can do this, we should first describe what your Facebook reach is. Basically, your reach on Facebook is the number of unique users who see the content you post and your updates. When it comes to reach there are four actions you can take to influence it:

  1. Posting content on your own Page - This is commonly referred to as organic reach by Facebook.
  2. Facebook users interacting with your content - When users interact with the content on your Page e.g., commenting or sharing, this is shown in their News Feed, an act which Facebook calls viral reach.
  3. Sending users to view your content - This could be as simple as putting a link to your content on an email, or even on your website asking people to visit your Page. This is a form of organic reach.
  4. Paying to get content in front of people - This is using Facebook's ad services and paying to target your content to specific audiences, thereby increasing the chance they see and interact with it. This is commonly referred to as paid reach.
By combining these four actions together, you can get a picture of your overall reach. By increasing the reach of each post through the above actions you stand a higher chance of getting your content in front of other people. The more people who see your updates the higher the chance of interaction with your company on Facebook or through other mediums, including avenues of sales.

The question is: How can a company do this? Here are seven of the most effective ways to improve your News Feed and its performance.

1. Develop a strategy

The key to posts being shared is that they need to be useful and interesting to your audience. Take a look at your Page's Insights (Open your Page's Admin panel and click on Insights) to see what content has been popular with your followers. From there develop a content strategy that covers what content to produce, when it should be produced, and when it should be shared.

Take a look at the most popular posts and see when they were interacted with most. This will give you a good idea of when your followers are most active and likely to interact with your content - thus increasing reach and overall effectiveness of your posts.

2. Know your audience

This will take time and research, but you should be able to paint a pretty solid picture as to who your audience is. If you can define a few personalities or even target individuals, you can better come up with content your audience will be more willing to interact with, or be more receptive to should you promote it.

3. Let people interact with your Page

Some companies have allowed users to post content on their News Feed or even tag companies, having the post show up on the company's News Feed, only for the content to be trolling or negative. This can potentially harm your company brand and reputation.

While there is a chance of this happening, the benefits of allowing your fans and followers to mention you in their posts far outweighs the potential negative outcomes of a few. This is because when a user mentions or tags you in a post on their News Feed, their friends are more likely to see it too. In other words, this can be a massive contributor to your overall viral reach.

4. Be active after you post your content

Don't just post content onto your Page and leave it. If people are interacting with it by commenting then you should make an effort to reply to the comments. This shows that you are interested and responsive, and willing to communicate and create a dialogue.

Mentioning the poster using @username when you comment will highlight the name and post your comment on their News Feed, thereby increasing the number of people who view your original content and encouraging the commenter to return to your Page.

5. Don't be afraid to repost

If you have had successful posts in the past, don't be afraid to reintroduce them. You could try updating the content a bit if need be and reposting it. This will increase the chance of other users seeing content they may have missed and interacting with it. Just be sure to comment somewhere that this content is a repost. You could comment that it was popular in the past and you think it is still relevant to today.

Be sure not to recycle too often however, as this can be viewed as lazy and turn users off. Aim for one to two posts every couple of months.

6. Integrate successful posts with other aspects of your online presence

While there is a good chance that your posts will be seen on Facebook, try boosting this by sharing your most popular content on other mediums. For example, paste the link into your email signature asking people to check it out, or add a list of your most popular posts to newsletters. This will encourage more people to visit the content and even interact with it.

In order to tell what is working, use the information on your Page's Insight panel.

7. Don't be afraid to be innovative

If you hit on a strategy that works, that's great! But, you should not be afraid to try new ideas. If, for example, you see that captions on photo posts are becoming popular with your audience give one a try to see how it works. The key here is to be resourceful and always on the lookout for new ideas.

Looking to get more out of Facebook? Contact us today to see how we can help.

Published with permission from TechAdvisory.org. Source.

March 29th, 2014

iPad_March24_AOne of the biggest, and arguably most useful, hardware trends is touch. It seems like almost every piece of new tech, from computers to tablets, and even to fridges or car navigation, comes with touch screens. The main way to interact with the majority of these devices is through the gesture, and if you have an iPad there are a number of important gestures you should know about.

Every new iPad, and many of the older ones, run the latest version of iOS - Apple's mobile operating system. For those running iOS 7, gestures are the main way you interact with your device. While it may look weird to people who don't use them, waving your hands around, spreading your fingers, and even pinching are normal to you!

One of the greatest plus points about gestures is that when used properly, they make it simpler to interact with your device; speeding up your overall productivity. So, if you are looking to increase productivity while using your device, you should know and practice different gestures. Here are six of the most important:

1. Swipe one finger from the top

If you place your finger on the top bezel (above the viewable area of the screen) and swipe down onto the screen you will open, or slide down, the notifications center. From here you can action notifications. When you are finished slide up from the bottom of the screen to close the notifications.

2. Swipe one finger from the bottom

If you place your finger on the bezel (below the viewable area of the screen) and swipe up onto the screen you should bring up the Control Center where you can control the important settings on your iPad. To close simply swipe down.

3. Swipe one finger down

Place your finger anywhere on the viewable area of the screen and swipe down. This will open up the Search bar where you can search for almost anything on your iPad, including apps, emails, music, and more. To close this bar, simply tap the home button, or tap anywhere on the screen other than where the keyboard or search bar are.

4. Swipe four fingers up

If you place four fingers anywhere on the screen you will bring up thumbnails that represent the apps that you have open. If you swipe up on a thumbnail, you will close the app.

5. Swipe four fingers left or right

With apps open, you can place four fingers on the screen and swipe to the left or right. This will switch to other open apps. You can swipe the opposite direction with your fingers to go back to another app, if you sweep to the left again, you should bring up a list of recently used apps.

6. Grab with five fingers

If you are in an app and want to quickly get to the homescreen place all five fingers on the screen and pinch them together. This will shrink the app into your home screen. You can open it again by swiping four fingers up and selecting it.

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

Published with permission from TechAdvisory.org. Source.

Topic iPad
March 28th, 2014

BI_March24_ABusiness Intelligence, or BI, refers to the processes and systems involved in the collection of business information for analysis to determine the past and current status of your company. It serves to give a better insight into what is about to transpire. Many companies from different industries use BI tools in their business, but the question is how can different departments use them?

There are various BI tools available nowadays that support small to large companies. You can find Business Intelligence tools that fit your company’s size, needs and budget. These applications can be used in different areas of the business:

Marketing Department

A marketing department is responsible for promoting a company’s products, services and brand to increase public awareness. With successful marketing, a business can attract potential clients that can be possibly turned into creating sales revenue. The company can use BI to determine which campaigns are successful or not, as the case may be. Through this, investments can be focused on those campaigns that work whilst avoiding those that have previously failed.

Sales Department

Sales managers and supervisors can also use BI to analyze successful deals, as well as those that they have lost, to see what strategies have worked. The system can also help determine which sales teams hit or exceed set goals in order to analyze what they are doing right. Moreover, this helps determine which products or services are most saleable so these can be pushed further to attain more goals.

Finance Department

BI software makes analyzing, reporting, and managing financial data more convenient. Those who are involved in the process can easily access the information they need through the system. Analysis is easier as the data is organized and accurate. Money in and money out can also be tracked with greater efficiency.

Moreover, these tools often come with features that allow users to create scenarios and determine the possible results from there. This is extremely helpful in deciding on the best action to take as the tool gives you a view of the probable outcome. The success rate is higher if forecasting using a BI tool.

Inventory

Business Intelligence also plays a vital role in inventory tracking of products, items or supplies. For instance, companies in the retail industry can track the movement of products or items from the suppliers to the warehouse and on to their delivery to clients. Any problems encountered in the process can be quickly identified so they can be fixed in time.

Items in demand can also be pinpointed, as well as low stock and overstocks. Items that are low in stock can be ordered immediately, especially if they are in demand, to ensure that the needs of clients are met. This also lets you avoid overstocking, which can be a waste of money when investment is better used for fast moving items.

These are just some of the ways businesses can use BI in their operations. If you have further questions about the topic, do not hesitate to give us a call. We’ll be more than happy to assist you.

Published with permission from TechAdvisory.org. Source.

March 27th, 2014

Office_Mar24_AMicrosoft Outlook is an application included in the Microsoft Office Suite. While it’s most commonly used to access different email accounts e.g., personal and business, it also has other features, including calendar, contacts, and tasks. It also comes with a search folder that lets you instantly find messages that fall under certain criteria.

Outlook is one of the most popular email platforms allowing you to read emails from almost any account. The inbox is where the majority of your interaction with Outlook is, but the problem is that many users receive so many emails that it can be overwhelmed quickly. This makes it more difficult to find important emails, or separate the spam/less important emails.

One way to deal with this is by creating a customized search folder for important emails. This makes searching for vital messages easier as they are saved in a separate folder.

Default and predefined search folders in Outlook

There are three default search folders in Outlook and you can see them under “search folders” in the mail navigation pane on the left side of the window. These default search folders are categorized mail, large mail and unread mail. Categorized mail contains messages that are categorized by color.

The large mail folder is a search folder that includes messages that are over 100 KB in size. Unread mail, as the term suggests, contains emails that have not yet been read.

Predefined search folders are also available. These are existing search folders that you can add to the search menu, below the other folders. Some of these require that you enter specific criteria, while others do not. For instance, “mail flagged for follow up” does not require any criteria, while “mail with specific words” asks you to enter certain words that the message must contain to be included in the folder.

Adding predefined search folders can be done by following the steps below:

  1. Click File.
  2. Select New and choose Search Folder. The New Search Folder window will appear.
  3. Click on any of the predefined search folders.
  4. Select the option you want if asked for a specific criterion.
  5. Click OK.

Create a new search folder in Outlook

It’s also possible to create your very own search folder. You get to set not only the criteria, but its name as well. This makes it convenient to easily access important messages as you don’t have to browse through the inbox or various folders in your mailbox.

Here’s how to create a new search folder in Outlook:

  1. Right click on Search Folders in the mail navigation pane and click New Search Folder. You may also press ctrl+shift+p on your keyboard to make the window appear.
  2. Click Create a Custom Search Field followed by Choose.
  3. Enter the name of the new folder in the name field.
  4. Click Criteria and set your preferences to further personalize the folder and click OK.
  5. Click Browse and select folders to add in your customized search folder, then click OK.
  6. Select OK on the new search folder window and the new folder you created will be added under your search folders.
Messages in search folders will still remain in the original folders where they are saved. Even if you view the messages and delete the search folder, the messages will still be accessible in their default folder. However, if you select and delete a message in a search folder, it will be completely removed, even from its original folder.

If you have any concerns or feedback with regards Outlook search folders, feel free to get in touch and we’ll help you in every way that we can.

Published with permission from TechAdvisory.org. Source.

March 27th, 2014

Office365_Mar24_AExcel is one of the applications included in Microsoft Office, Microsoft's suite of office productivity software. Microsoft Office applications can run on almost every system businesses use, including Windows and Mac. Excel is specifically used for creating spreadsheets, basic databases, analyzing data, and even simplifying management. Many spreadsheets can be a challenge to navigate. One way to make your spreadsheets easier to get around is to name the cells.

Like other spreadsheet applications, Microsoft Excel documents are based on cells that can be arranged into rows and columns. It is within these cells that data is entered when creating a worksheet for various functions including data management and computations, etc. Each cell in the spreadsheet has a corresponding name, which is identified by its column letter and row number.

For instance, the cell under column A that belongs to row 1 has the default name A1. You will see this in the name box, which is located on the upper left side of the spreadsheet, next to the formula bar. This name can actually be changed however.

Why name cells in Excel

As mentioned, the default name for each cell in an Excel spreadsheet is based on the relevant column and row. One of the reasons why you may want to change this name is to make it easier to find what you are looking for, especially when there’s a lot of information in a particular spreadsheet. For instance, if you name a particular cell 'Total', searching for this word is much faster than scrolling through the spreadsheet to find the correct cell or trying to remember its specific column and row.

This is also the case when creating formulas for computations. Instead of using the cells’ column letter and row number, it’s more convenient to use a name that you can easily understand. For example, naming one cell 'GrossIncome' and the other one 'Deductions' makes it easier for you to compute net income by subtracting Deductions from GrossIncome for the result.

Another benefit of naming cells is that it is easier for other users to understand. If you are sharing the spreadsheet or workbook with other colleagues or business associates, using cell names that are easy for everyone to identify reduces potential confusion.

How to name cells in Excel

Naming cells in Excel can be done in two ways. The first is by changing the name directly on the name box and the other one is by defining names under the Formulas menu. The difference is that when naming a cell through the define name feature of the menu you can select its specific scope.

This determines where the specific name will be recognized as having the same value, such as in the entire workbook or in a specific spreadsheet only. Changing the name in the name box will automatically determine the workbook as its scope rather than the whole spreadsheet.

Changing a cell name in the name box:

  1. Select the cell that you want to name.
  2. Go to the name box and type the name you prefer.
  3. Hit enter on your keyboard.

Defining a cell name:

  1. Select the cell that you wish to name.
  2. Click the Formulas menu.
  3. Choose Define Name.
  4. Type the name of the cell in the new window that pops up.
  5. Select the Scope.
  6. Click OK.
Remember that a cell name should not contain any spaces. The uppercase and lowercase letters R and C are also not available as cell names, since they represent column and row. Furthermore, aside from letters, the first character of a cell name can also be a backslash or an underscore. The rest can be a combination of letters, underscores, periods and numbers, which can be up to 255 characters.

If you have further questions about changing the cell name in Excel, please don’t hesitate to give us a call.

Published with permission from TechAdvisory.org. Source.