Blog

April 25th, 2013

iPad_April24_BUsing a tablet in the office or for business can help you be more productive or at the very least can make your job easier. One of the most popular tablets is the iPad, with many owners swearing that it has made them more productive. One common gripe however is that the keyboard isn't the best for efficiency. There are some features that help though.

Here's a tip on how you can improve typing on your iPad through the use of keyboard shortcuts.

What are they? Keyboard shortcuts are a built-in feature of iOS that allow you to type in a few letters and have your iPad input full sentences or words. This is similar to a Web browser's autocomplete feature which will fill in forms when you enter a few letters or even a word.

How it works Keyboard shortcuts require manual setup, you will have to set a phrase, sentence, word, etc. as well as the letters that will input the phrase. For example you can set the letters 'beml' to be a shortcut for your business email; when you type 'beml', your iPad will input your email address.

These shortcuts could be quite useful, especially if you find yourself continually entering the same word or sentence. This will make you more productive and, as long as you have the correct information, will ensure that there are no typos in important words or phrases. How to set it keyboard shortcuts Taking the business email example from above, here's how you can set keyboard shortcuts. Note: These instructions relate to iOS 6.1 (the latest version of the operating system.)

  1. Open the Settings app (gray box with three cogs).
  2. Select General followed by Keyboard.
  3. Scroll down and select Add New Shortcut.
  4. Enter the full word/phrase/sentence in the Phrase section. In this case you would enter your full email address.
  5. Enter the shortcut letters that will be related to the Phrase. In this case you would enter beml.
  6. Tap Save in the top-right of the window.
When entering shortcuts, it is a good idea to not use common letters or combinations that make up words. For example if you set a shortcut as 'mai', everytime you type 'mai', the phrase will be entered. To come up with a good shortcut, try using the first letter of the first word, a middle letter and the last. Or, you could enter three consonants or vowels in a row e.g., 'eee'.

How to edit keyboard shortcuts You may notice that when you navigate to the Keyboard section in the Settings app, there is a number of existing shortcuts. You can edit these by:

  1. Opening the Settings app (gray box with three cogs).
  2. Selecting General followed by Keyboard.
  3. Tapping Edit and selecting the shortcut to edit from the Shortcuts box.
  4. Editing the phrase and shortcut associated to it in the window that opens.
  5. Pressing Save in the top-right of the window.
The next time you need to enter a phrase that you have setup a shortcut for, try entering the shortcut. This should make typing on the iPad a bit more efficient and save you time.

If you are looking to learn more about the iPad, or how using one can help improve your productivity at work, please contact us today.

Published with permission from TechAdvisory.org. Source.

Topic iPad
April 24th, 2013

AndroidTablet_April24_BAs technology continues to invade every aspect of our lives, the number of devices we own keeps increasing. Having both a tablet and a smartphone is not uncommon for many business owners today. If you have an Android tablet, you likely can't connect to a mobile network, but did you know that there is a way you can get your tablet online when there is no Wi-Fi available? It's called tethering, and it can be extremely useful.

Here is an overview of tethering. It focuses on Android tablets, but this process be applied to almost any Android device.

What exactly is tethering? You've probably seen this term mentioned in marketing collateral or contracts from your mobile provider, or heard users talk about it. In the most basic sense, tethering is sharing one device's Internet or data connection with another. The most common type of tethering you will see is someone using their smartphone's data connection to surf the Internet on their computer or tablet.

When it comes to tethering on Android devices, there are three main options:

  • Portable Wi-Fi hotspot - Turns your device into a Wi-Fi router, allowing it to share its data connection with up to five other devices.
  • Bluetooth - Shares the device's data connection with one device over Bluetooth.
  • USB - Shares the device's data connection with one device, usually a computer.
A word of warning: As you share connections, the speed of the data will be diminished. Some devices are also data hungry, and if you have a set amount of data each month, you will likely use it up. If you go over the amount, you may be in for a bit of a shock when you see your next bill.

Can I tether on my tablet? Technically all Android tablets and devices can share their connection as long as they can connect to mobile data. The ability to tether actually hinges on the provider of the data connection - some allow it, others don't while some will apply extra charges. Before you try to tether any device, you should check with your device's data/mobile provider to ensure tethering is allowed. As a rule of thumb: If you are already paying for a data connection with a set amount of bandwidth (e.g., 2GB a month), tethering is likely ok.

Because many Android tablets don't have a mobile data connection, most users will likely share their smartphone's connection with their tablet. If you have a smartphone with a data plan, tethering will depend on your phone as the tablet just sees an Internet connection.

How do I share my data connection? If you have a smartphone with a data connection and would like to share it with your tablet, you have a couple of options:

For iPhone/iPad (with a data connection) users

  1. Open Settings on your phone.
  2. Tap on General followed by Network.
  3. Select Personal Hotspot followed by Wi-Fi Password.
  4. Set the Wi-Fi password and select Done.
  5. Slide the button beside Personal Hotspot from Off to On.
  6. On your Android device, open the Wi-Fi settings and look for the network with the iPhone's name. Tap on it and enter the password you set above. It should connect within a few seconds.
For Android users
  1. Open your phone's Settings app.
  2. Press More under Wireless & Networks (Android 4.2)
  3. Tap on Tethering & portable hotspot.
  4. Select Set up Wi-Fi hotspot and enter a network name under Network SSID.
  5. Enter a password under the Password section and press Save.
  6. Select Portable Wi-Fi hotspot and the device will create a wireless network.
  7. On your tablet, open the Wi-Fi settings and look for the name you have set in the Network SSID field above. By default it's Android AP.
It would be a good idea to use a password when setting up tethering to ensure that no one will be able to connect to your network without your permission.

If you are looking for more ways to get your Android tablet online or wondering how a tablet can help you, contact us today.

Published with permission from TechAdvisory.org. Source.

April 24th, 2013

Office_April24_BChange is inevitable. In some industries it happens slowly, while in others it happens at a blazing speed. The tech industry is one that never sits still; there is always something bigger, better, faster and newer being released. The problem many businesses have with this is that the changes are unaffordable, so they stay with the same software or systems for years. This can be an issue, especially when the developer of software stops supporting existing systems. Microsoft has announced that they will stop supporting some software that you may be using.

For businesses running Office 2003 or Microsoft XP SP3, you need to be aware that Microsoft has announced that they will stop supporting these products on April 8, 2014. This could have far reaching consequences for businesses that use these platforms.

What does this mean for my business? When a company like Microsoft says they will 'stop supporting' what they mean is that they will usually stop providing updates, paid support, security updates and maybe even online based support.

The biggest problem with a move like this hinges on security. If a hacker finds a security exploit on an older system that a developer has stopped supporting, your systems could be open to attack. Beyond that, if you have paid for support, you will no longer have it if the software stops working. These two reasons alone will eventually lead to higher IT costs.

When it comes to programs like Office and XP, there is another downside to this withdrawal of support: It is highly likely that future versions of the software will be incompatible with what you are running. This means you likely won't be able to open newer versions of Office documents, which could create problems especially if you have clients who use newer versions; you won't be able to read/edit the documents. What can we do? The easiest thing to do is to upgrade your software. This may be easier said than done, especially if you have a tighter budget. Luckily, you have more or less one year to upgrade, and in this modern age you have more than one way to update. Possibly the best is to work with an IT partner who can help develop a solution that will fit your business and budget.

If you're still using Office 2003 or XP SP3 in your office, contact us today to see how we can help.

Published with permission from TechAdvisory.org. Source.

April 24th, 2013

Office365_April24_BPresentations are an integral part of almost any role in business. While the information conveyed in these presentations varies, every presentation follows a general structure. This structure, or outline, can be time consuming to layout in Microsoft's PowerPoint. Did you know that there's an easier way to create these outlines using Microsoft Word?

Here's how to use Word to create a PowerPoint presentation.

How does this work?

The idea here is to use Word to establish the outline and basic text of a PowerPoint presentation. This outline can then be opened in PowerPoint and converted into slides. The way the program does this is through the use of heading styles in Word. Assigning a different heading style (we'll explain how below) will create the outline of your presentation. For example, Heading 1 will be the title of each slide, while Heading 2 becomes the text.

There are two ways you can create an outline. Here's both:

Using Outline view

  1. Open a new Word document.
  2. Click on View in the menu bar and select Outline.
  3. Type your outline - enter the title of each slide, hit Enter to create a new entry. You can also enter the text in the slide under each title.
  4. Select each line and hit either Promote or Demote (they look like the indent text buttons, and are located in the Outline menu bar).
  5. Click on File and Save As when you have finished the outline.
  6. Name the file and under the Format section select Rich Text Format (.rtf). You can also just save the document as a normal Word File, but saving as a .rtf file will ensure that PowerPoint can read the outline properly.

Using Heading styles

  1. Open a new Word document.
  2. Enter your outline. The best way to do this is to enter the slide title, hit enter and insert the body/bullet points. Don't leave empty spaces as these may be read as empty slides.
  3. Highlight the first title and look at the main ribbon for the Styles section. Press the down arrow beside the box that says body and select Heading 1.
  4. Highlight the related body text (if any) and press Heading 2. This should be just below the Heading 1 option above.
  5. Repeat for the rest of the slides.
  6. Click on File and Save As when you have finished the outline.
  7. Name the file and under the Format section select Rich Text Format (.rtf). You can also just save the document as a normal Word File, but saving as a .rtf file will ensure that PowerPoint can read the outline properly.

Creating the presentation

When you are ready to create the presentation you can:

  1. Open a new PowerPoint presentation.
  2. Create the title slide and in the navigation bar (left side of the window), click on it.
  3. Click on the gray arrow beside New Slide which is located in the Home bar, under the Slides section.
  4. Select Insert Slides from Outline.
  5. Locate the outline file you saved and double click on it.

The slides should automatically be created below the title slide. If you didn't apply any formatting to the text, it will likely show up in a slide on the left-hand side with no spacing. You will have to go in and edit it.

By creating an outline in Word first, you can cut down the time needed to format and edit slides in PowerPoint. Of course you will have to edit the slides and add color, themes, images, etc. But, this should help you create more professional presentations.

If you are looking for more tips on PowerPoint, Word or any of the other Office programs please contact us today.

 

Published with permission from TechAdvisory.org. Source.

April 19th, 2013

Security_April18_BBusiness owners and managers have many concerns they must address on a regular basis, or at least be aware of. Some of security concerns revolve around fraud, more specifically email fraud. While this isn't a new concept, email fraud and scam occurrences are on the rise, and it is vital to know how to spot them.

Here's five tips to help you spot email frauds or scams.

Look at the email address One of the easiest ways to spot a fraudulent email or scam is by looking at the email address of the sender. Many credit card application scams use third party email services like Gmail or Yahoo. Some scammers go so far as to set up accounts in the name of the company e.g., AMEX_121@gmail.com.

Sophisticated scammers will actually try to copy the legitimate company's email account - a practice called spoofing. They will usually have a few changes like a missing letter from the address, or an extra . added.

The easiest thing you can do is look for the sender's site on the Internet. For example: You get an email from AMEX OPEN (American Express's small business credit card) and notice that the sender's email address just doesn't look right. Go to Google and search for amex fraud. You'll likely find the fraud page which tells you exactly how the company sends emails. If the sender is a smaller company, most of these will have email contact addresses right on the site, take a look and compare the two. If they are different, the email is likely a scam.

Look at the sender's website If you think an email is fraudulent, try looking up the website associated with the sender. Should you be unable to find the site, it's likely a scam.

If you find a website, click through some pages to see if there is anything that looks out of place. For example a website selling a new financial service has pages with Coming Soon or you get errors when you try to load the page. If it looks fishy, it likely is - delete the email.

It would also be a good idea to go to archive.org's Wayback Machine, copy and paste the website's URL into the The Wayback Machine Search bar and hit Take me back. This will bring up previous versions of the website. If you see that the site in question was something completely different a few months to a year ago (e.g., it is a financial services page now, but six months ago it was a page selling prescription drugs), chances are high it's a fraud.

Call them Many scammers will put phone numbers into emails to make them look more legitimate. If you are unsure about whether this email is legitimate or not, why not try calling the number? Many scammers run more than one fraud operating at the same time and may answer the phone with another name, or not at all.

Similarly, if you call a local number of a supposedly small business and get routed directly to voicemail, it's likely fraud.

Look carefully at the body of the message The body of the email can also be a great way to suss out email scammers and potential fraud. Because many fraudulent emails originate outside of the major English speaking countries, there will often be language that just sounds different from the way people write in your area. One great example of this would be a line like 'We wish to sell you a great product.'

You should also look for spelling errors, grammar mistakes or inconsistencies. While some fraudulent emails will have minor spelling inconsistencies, others will spell common words wrong. If you see mistakes like 'our product are a great deals', this should raise a warning flag.

Spelling and grammar errors are a part of business communication, so don't expect a perfect email from all companies, especially if you see that the company is located overseas. It's the emails with mistakes supposedly coming from companies in your area that should really raise alarm.

The sender asks for money or passwords It's kind of an unwritten rule that when sending out emails you never ask for a person's credit card number or account passwords. Banks, large companies and many social networks will never ask you for passwords or account information, credit card numbers, pin codes, etc of any kind over email. If you notice that an email selling something asks for you to reply with a credit card details so you can make a purchase, it's best to delete the email as it's likely a fraud.

Email fraud is a big deal, and unfortunately it will likely become even more common in the near future. This means you should be able to spot potentially fraudulent emails. If you think an email is a scam, it's best to just delete it immediately. Don't respond or forward it to colleagues or employees. If you need to let people know, write another email that describes the suspected email but has no links. You can also forward a screenshot to your colleagues or friends to illustrate the scam.

Looking for more ways you can protect your company? Contact us today. We can work with you to develop a security system that will meet your needs.

Published with permission from TechAdvisory.org. Source.

Topic Security
April 11th, 2013

AndroidPhone_Apr10_BThere are a wide variety of reasons the smartphone has become an integral part of any business owner's daily life. One of the biggest is that these devices are functional, largely due in part to the multitude of apps available that can help make our lives just a little bit easier. If you have an Android phone, here's one app that could help you while making calls.

Call Notes is an app for Android that adds notes to the phone interface while you are making a call. When you receive a call the note, which you can attach to the caller's profile, is shown on the screen under their picture or the call icon. The note can be moved anywhere on the screen and edited during the call if you purchase the Pro version.

Why is this app useful? If you make business calls on your Android device and would like to have some information about the caller on hand, this app could be a good tool. The Pro version also allows users to add a company name and a title which can also help. Being able to create notes while in a call is also useful. For example If the caller says something, or you agree on something and you don't have any paper handy you can add a note.

How does it work? You can download either the free or Pro version from Google Play and install it on your phone. To add a note to a contact you:

  1. Open the app and select Edit Note.
  2. Scroll to the contact you would like to add a note to and tap on their name.
  3. Tap on the empty black area and your keyboard should pop up. Enter the note and press Save.
  4. The note should show up the next time you call/receive a call from that contact.
If you get the pro version, you can enable the editing of messages during a call by opening the app and selecting Settings followed by Buttons. Tap on Edit note button so that the box is ticked and you will be able to edit notes during the call.

Another interesting feature is you can add a button to the note that will enable you to easily access your phone's calendar during a call. This can be a great help, in that you can easily schedule a meeting while on the call. To add the calendar button to a call note: Open the app and press Settings. Tap on Buttons and select Calendar button from the menu that opens.

This is just one of the numerous functionality based apps that can be added to make your Android phone even more useful. What are your favorite business oriented apps? Let us know. And if you're looking for more information on how an Android device can be used to improve your job, contact us today.

Published with permission from TechAdvisory.org. Source.

April 10th, 2013

MobileGeneral_April10_BOne of the more popular devices these days is the tablet, it seems like almost everyone has one, or at least wants one. The problem is, there are so many to choose from that it can be a daunting task, especially when you're looking for one for your business. To help make the decision easier we will look at the three tablets that could be good for businesses.

Here's a five point comparison of the three most popular 10-inch tablets - Apple's iPad 4, Google's Nexus 10 and Microsoft's Surface Pro.

Price
  • Apple iPad - The iPad starts at USD$499 for the cheapest model and USD$929 for the top model. The major differences between the models is storage size and connectivity options.
  • Google Nexus 10 - The Nexus 10 starts at USD$399 for the base model and USD$499 for the top model. The only real difference between the two models is storage size.
  • Microsoft Surface Pro - The base model of the Surface Pro starts at USD$899 while the other model starts at USD$999.

The prices listed above are for just the device, the price you pay will be higher if you add peripherals like keyboard cases, screen protectors or extended warranty.

Storage

  • iPad - Comes with 16, 32, 64 or 128GB of storage.
  • Nexus 10 - Has either 16 or 32GB of storage.
  • Surface Pro - Offers 64 or 128GB of storage. The Pro also has a Micro SD card reader which can support up to 64GB of extra storage. There is also a USB port which you could connect an external hard drive to, allowing for nearly unlimited storage.

It's important to note that these storage numbers are provided by the manufacturer of the device, these numbers don't include the space the operating system and other pre-installed programs take up. For example the Surface Pro 64GB actually has 29GB of usable storage space. In comparison: The Nexus 10 32GB has about 29GB of usable space while the iPad 32GB has slightly over 27GB.

Internet Connectivity

  • iPad - There are two versions: Wi-Fi only and Wi-Fi/3g/LTE (Mobile data).
  • Nexus 10- Wi-Fi only.
  • Surface Pro - Wi-Fi only.

Being able to connect to the Internet either through a Wi-Fi or mobile data connection is important for many business users, especially if you are out of the office on a regular basis.

Battery life

  • iPad - Around 10 hours with normal use.
  • Nexus 10 - Around 8.5 hours with normal use.
  • Surface Pro - Around four hours.

The total battery life depends on what users do with the tablets. The numbers reflect what an average business user will get out of their tablet. As with almost any mobile device, it would be a good idea to keep a spare cord at the office and at home so you can charge it when you need to.

Apps

  • iPad - Apple's App Store has slightly over 800,000 apps, many with versions optimized for the iPad.
  • Nexus 10 - Google Play also has slightly over 800,000 apps available to download. The number of tablet-specific apps is far lower than the App Store however.
  • Surface Pro - The Surface Pro runs a full version of Windows 8, which means any Windows program that is compatible with Windows 8 will work on the Surface Pro.

Which is best for business?

When it comes to buying a tablet for work, you need to take into account what you will be using it for. Below are eight popular scenarios and which devices may be best suited for that task.

  1. Email only - If you are looking for a tablet to just check your email on, it would be a good idea to look at the Nexus 10. The main reason for this is twofold: First, you can install different virtual keyboards which make it easier for you to type messages. Second: There are more email apps that allow you to connect to multiple accounts.
  2. On a budget - The Nexus 10 is the cheapest 10-inch tablet, and would be the best option here.
  3. To replace a laptop - The Surface Pro, which costs the same as most mid-range laptops, is really more of a laptop with a touch screen, which makes it an ideal candidate to replace an existing laptop.
  4. To help with presentations - The Surface Pro is your best option here. Because you can install a full version of Office 2013 (with PowerPoint) on the device which is mostly portable, you shouldn't need anything else. Beyond that, there is a mini display port which allows you to connect to any monitor or projection screen (HDMI or VGA) with an adapter.
  5. Everyday use - If you plan to be doing a bit of everything, including personal use, most users will go with the iPad due to its ease of use and great platform.
  6. Google user - The Nexus 10 is built to be the 'Google' tablet; what Google deems to be the benchmark for other Android tablets. As such, any Google user will find this tablet to be the best choice, especially if you use Google Apps in the office.
  7. Apple user - If you use an iPhone or Apple computers in your office, the iPad would be the best device.
  8. Microsoft user - Windows users will likely benefit most from the Microsoft Surface.

If you're looking for a new tablet and would like help figuring out which will be best for your business needs please contact us today, we may be able to help.


Published with permission from TechAdvisory.org. Source.

April 10th, 2013

SocialMedia_April09_BOne of the most important tools of a modern marketing plan is social media. With the various platforms leveraged correctly, social media could be the best way to expand your brand and gain vital exposure. Pinterest, the newest major social network which all about sharing images, has recently had its layout overhauled and new features introduced. Businesses can really benefit from these enhancements.

Here's a brief overview of the new features introduced with Pinterest's recent layout changes.

How to get the new layout

Before you can use these features, it would be a good idea to upgrade to the new layout. While, like other social media services, this will be happening automatically over time. Unlike other platforms, the new layout is available for all users to switch to when they feel ready, however when you switch to the new layout, you will not be able to go back to the old one. Here's how you can switch:

  1. Log in to Pinterest.
  2. Hover your mouse over your profile/business name at the top-right of your profile.
  3. Click Switch to the New Look.
  4. Select Get it Now. Note: If you press this, you likely won't be able to switch back to the old layout.
  5. Press Okay from the Welcome to your new look! pop-up window.

When the new layout loads, you'll notice that the pins are bigger, the category button has been moved to the left side of the profile beside the Search bar. You'll also notice that the comment button has been moved from the pins, you can access it by clicking on the image. On top of cosmetic changes, two useful functions that businesses will find beneficial.

Discovery

Now, when you look at an individual pin (click on the image), you will notice a number of changes.

  • You can see all pins on the same board.
  • You'll also see pins from the same website. For example if you pin something from a restaurant, you'll now see similar pins from the same website.
  • Most importantly, you'll now be able to see what other people have pinned along with the same image.

This will make it easier for users to discover what other people are pinning. For your business this means potentially higher exposure. Think of this as something similar to the way Facebook works: If a person likes you, the chances of this like showing on their friend's profile, and that friend visiting your Page is higher. It's kind of like easy brand exposure.

Analytics

Arguably the most useful feature added recently is Pinterest Analytics, which allows you to see if your pins are being clicked on or shared, and the general success of your activities. This will go a long way in helping you determine the overall success of your Pinterest oriented efforts.

The main caveat with this is that your profile/business's website needs to be verified and connected with your profile. If you have an unofficial Pinterest account, you can change it to a business one by:

  1. Logging into your Pinterest account and going to business.pinterest.com.
  2. Pressing Convert your existing account and choose your type of business.
  3. Entering the relevant account information like the name of your business, address and website.
  4. Agreeing to the new Terms of Service.

If you would like to have a new username or account simply go to http://business.pinterest.com/ and press Join as a Business. You will be asked to set your account information, username, etc. You will need to verify your account which will involve you having to download a file and upload it to the server that hosts your website. We, or your web hoster can help you with that.

After your account is verified, you will notice that if you hover your mouse over your account name a drop-down list should pop up with Analytics being about half way down. Click on that to be taken to the section.

This section will display a bunch of graphs including:

  • The number of daily pins and pinners on your site.
  • The number of re-pins you have done.
  • How many times your content has been repinned.
  • The number of clicks and website visits.
  • The most clicked and repinned pins.
  • The number of times your pins have been seen.

Overall, Analytics is a useful tool that will give you a clear picture of what is working and what isn't. If you pinned a picture of a dog and noticed that it got zero pins while another got hundreds, it may be a good idea to create/look for more similar content.

If you are looking to integrate Pinterest into your business's social media strategy or would like or learn more about how to use the service, please contact us today.

 

Published with permission from TechAdvisory.org. Source.

Topic Social Media
April 9th, 2013

Office365_April09_BExcel is a common business tool that is used in an uncountable number of ways. Some spreadsheets are short, maybe one or two columns and 20 rows. Others can consist hundreds if not thousands of cells. When they get this big, it can be tough to quickly summarize or compare data. That's where the pivot table comes in, unfortunately it isn't perfect and may require a few modifications.

Here's four ways you can modify Excel 2013 for Office 365's pivot tables to meet your needs.

Make your tables look good

When you first create a new pivot table you may notice that the numbers aren't formatted properly, or the table didn't pull the format from the base spreadsheet. They may have too many decimal places, or are lacking currency figures. You can make edit this by:

  1. Selecting any of the numbers in the Value field.
  2. Clicking on the Analyze tab from the tabs above the table.
  3. Pressing on Field Settings in the Active Field group.

This will open the Field Settings panel and allow you to edit the whole Value field, which means that if you change numbers, location, etc, the formatting will stick. Pressing Number Format will bring up the Format Cell window where you can apply numbers, currencies, decimal places, etc. Pressing Ok will apply the formatting you have selected to the whole field.

You can also apply color schemes or styles by pressing the Design tab and selecting the theme that looks good to you. This will not usually change the layout, just the color and style.

Change the name of the table and fields

If you are going to be sending the table to clients or colleagues, you may want to change the name of the table and fields to something a little more user-friendly. You can change the names by:

  1. Clicking on the cell/name you would like to change.
  2. Pressing on the Analyze tab.
  3. Looking at the Active Field area of the Analyze tab and double clicking on the cell's name. You can also click on the box beside Pivot Table Name if you want to change the table's name.
  4. Entering a new name.

Add gridlines for easier viewing

If you need to separate the information in the cell, the easiest thing to do is to add gridlines. This can be done by:

  1. Clicking on a cell in the table
  2. Selecting the Design tab and choosing any style aside from the first one.
  3. Looking at the PivotTable Style Gallery and ticking the box that says Banded Rows.

Change blanks to 0s

There may be an issue where the data that's used to create the table leave blank spaces when they should be 0s. This isn't a big deal, but it would be a good idea to ensure that, for consistency, blank cells are represented as a 0, especially if other related cells are numbers. You can force Excel to fill blank cells with a 0 by:

  1. Right clicking on the table.
  2. Selecting Options followed by Layout & Format in the pop-up window.
  3. Entering 0 beside the box that says For empty cells show
  4. Pressing Ok.

Excel and the pivot table bring some excellent functionality to the spreadsheet, and having a properly formatted pivot table could go a long way in ensuring the information shown is easier to read. If you would like to learn more about how Excel or any of the other Office 365 programs can help, please contact us today.


Published with permission from TechAdvisory.org. Source.

April 4th, 2013

Hardware_May15_AComputers are complex machines. If you've ever looked inside one you know it's a confusing mess of wires and components. Like all machines, over time they will start to slow down and run slower than before. When this happens it can be troublesome for your productivity, and you may not be able to afford to purchase a new machine. Luckily, there are steps you can take to keep your machine running smoothly.

Below are four things you can do to keep your PC running smoothly.

1. Shutdown properly If you turn your computer off at the end of the day, or it freezes, it may be tempting to flick the off switch on the power bar, or press the power button until it turns off. This isn't ideal for your computer's health because when a computer is unexpectedly shut down, there could be damage to the operating system.

You may notice that when your computer crashes, it takes longer to reboot. This is because Windows is actually searching for, or trying to repair any damage that may have been done. There is a chance that powering down improperly could cause files to become corrupted which may make the system inoperable.

Therefore, you should follow proper shutdown procedures. If you need to shut down quickly, try pressing Control+Alt+Delete and selecting Shut Down from there.

2. Close unnecessary programs running in the background Some programs are written to be always running in the background. If you look in the bottom right of your screen, you should see programs running beside the clock. In truth, most of these likely don't need to be open. You should be able to right click on the icon and close them. This will save computing resources and make your computer run smoother.

A word of warning: It's best not to shut down the antivirus or security software as this will leave your computer open to attack. Also, don't shut down anything from NVIDIA or AMD as this is your video card software. Closing programs like this could cause your computer to crash.

3. Utilize Add/Remove on a regular basis Chances are high that you have installed a fairly high number of programs on your computer, some of which you may not use anymore. Those you don't use just take up valuable hard drive space, and should be removed on a regular basis. You can do this by:

  1. Clicking on Start or the Windows Orb.
  2. <li>Selecting Settings followed by Control Panel.</li>
    
    <li>Opening Add/Remove Programs.</li>
    

It may take a few minutes to scan your system for programs, but a window will open with all the programs you have installed. Click on those you don't use anymore and remove them. We strongly recommend that you do not go into different files and delete programs, this could damage your system.

4. Use a malware scanner and antivirus program This may sound like a no-brainer, but it is still worth mentioning that having an antivirus program and malware scanner is a good idea. Many viruses and other malware often hijack system resources causing the computer to run slower, or crash. A regular scan can go a long way in minimizing this, which means your computer will likely run better for longer.

If you are looking for ways to keep your older systems running at their optimal levels, please contact us today to see how we can help you.

Published with permission from TechAdvisory.org. Source.

Topic Security