Blog

January 30th, 2012

There are times when you may want to capture what is currently being shown on your iPad's screen. That’s easy to do on an iPad.

Simply press the Home button and then the Sleep/Wake button simultaneously. When you hear a click, the screenshot has been taken. You can then go to the photos gallery to see all of your captured screenshots.

Published with permission from TechAdvisory.org. Source.

Topic Tech Tips
January 30th, 2012

The big difference between Android and the iOS is the fact that, on an Android device, you can play Flash videos. There are times however when this seeming advantage can be a disadvantage as Flash (such as Flash ads) can slow down your browsing experience or even crash your browser. There is a solution.

You can turn off Flash if you choose to. Simply go to your Browser's Settings by pressing on the Menu/Options button, then go to Advanced and change 'Enable plug-ins' setting from "Always on" to "On demand." Flash applications will now appear as an arrow that you must touch to start.

Published with permission from TechAdvisory.org. Source.

Topic Tech Tips
January 10th, 2012

If you own an Android phone, you can use it as a substitute for an external drive or a USB key. You can load files into your phone simply by plugging it in to a PC with a USB cable, then tapping on “Mount” when you are prompted by the system.

This mounts the internal storage of the device as an external drive relative to the PC, and you can easily drag and drop files or create folders on the device as you see fit. Of course, it is recommended you do this on the SDCard that likely came with the device, or one that you buy for your phone.

Published with permission from TechAdvisory.org. Source.

January 2nd, 2012

If you are using Windows Gadgets (or those small mini-applications that are embedded on your desktop that show interesting things like the latest news, weather updates, or sports scores), you may sometimes wish you can just quickly hide them to declutter your workspace.

In Windows 7, you can do just that. Simply right-click on the desktop, go to View, and then clear the check mark on Show desktop gadgets. This will hide the gadgets. If you want to bring them back, just restore the check mark again.

Published with permission from TechAdvisory.org. Source.

Topic Tech Tips
December 23rd, 2011

Have you ever sent an email and then immediately regretted sending it? If you are using Gmail as your mail client, you can do just that with an interesting but buried option in Gmail settings.

To enable this feature, go to Mail Settings in Gmail (upper right corner, under the gear icon). Navigate to the "Labs" tab. In the labs search box, look for "Undo Send" and choose Enable, then save. Now in Mail Settings you will see an option to "Undo Send: Send cancellation period: __ seconds." Enter the number of seconds that Gmail will allow you to change your mind in the future (try 10 seconds).

With this enabled, the next time you send an email, you’ll be able to “Cancel” it from being sent out, as long as it is within the time frame you specified.

Published with permission from TechAdvisory.org. Source.

Topic Tech Tips
December 15th, 2011

Do you prefer Bing over Google but like Google's sparse but fast loading page better? With this tip you can get the best of both worlds.

As users of Bing know, when you visit the home page of Bing, a page with a featured photo as the background is displayed by default, which increases the load time of the page. This can be distracting or annoyingespecially if you have a slow connection. Disable this photo from loading by simply bookmarking this URL (http://www.bing.com/?rb=0). The next time you visit Bing, the photo will not appear.

Published with permission from TechAdvisory.org. Source.

Topic Tech Tips
December 5th, 2011

Did you know that on iOS5 on the iPad, you can actually split the keyboard into two? This can be useful for typing with your thumbs if you are holding the iPad with both hands.

To do so, press and hold the keyboard icon on the on-screen keyboard. An option will appear, allowing you to split the keyboard into two. Alternatively you can drag the keyboard icon up across the screen until the keyboard splits up. Still another way is to simply put two fingers around the center of the keyboard and simultaneously drag them apart in a splitting motion.

Published with permission from TechAdvisory.org. Source.

Topic Tech Tips
November 25th, 2011

Security_May15_AHackers and other cyber criminals are an ever present danger on the Internet. This is a fact that we simply can't escape, and what's more, you can be pretty sure that we will see an increase in the number of attacks against sites as the internet continues to expand and be used by more and more people. One of the latest major sites to be hacked is LivingSocial, so if you have an account with this website, you may want to keep reading.

LivingSocial is a daily deals website that focuses on bringing bargains and original deals to users based on their geographical location. In late April, news broke that the website had suffered a massive cyber attack with 50 million accounts being compromised.

From the reports we have seen, the attack targeted accounts world-wide with only account holders in Thailand, Indonesia, South Korea and the Philippines being unaffected. An email sent out by Tim O'Shaughnessy, LivingSocial's CEO shortly after the incident said, "We recently experienced a cyber-attack on our computer systems that resulted in unauthorized access to some customer data from our servers. We are actively working with law enforcement to investigate this issue."

The company assured users that their credit card data had not been compromised, as they are kept in another database. Account passwords were also encrypted, which means they are harder to crack but not impossible.

What should you do? If you have a LivingSocial account, we recommend that you go and change your password immediately. This can be done by:

  1. Going to LivingSocial's forgot your password page.
  2. Entering the email address you used to sign up for the account with.
  3. Pressing Reset Password.
  4. Checking your email for an email from LivingSocial and following the instructions in the email.

It is advisable to pick a new password, one that is as different as possible from your old password and, as always, the longer, the better.

Is there anything I can to do protect my company? If you are a business owner who has websites that encourage customers to sign up for updates, accounts, etc. you may be wondering how you can keep your user's information secure from cyber attack. In truth, you can't keep your important information 100% secure, if a hacker is committed enough, they will be able to get the information they need or wreak the havoc they want to. But what you can do is to make it as hard as possible for cybercriminals to get your information. This could be as simple as using multiple databases to store different bits of information, or as complex as using the latest encryption methods and systems.

Each business is unique, and the best way to ensure your valuable data is secure is to work with an IT partner who takes the time to get to know your security needs and develop a solution that is as near to 100% secure as possible.

If you are worried about the security of your systems, contact us today. We may have the perfect solution that will meet your needs and budget.

Published with permission from TechAdvisory.org. Source.

Topic Tech Tips
November 18th, 2011

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.

Topic Tech Tips
November 11th, 2011

If you use an iPad, there is a switch conveniently located at the right side of the device which you can set to either lock the orientation of the screen or to mute the audio when you slide the switchdepending on your preference.

To set your preference, go to Settings > General, and under the "Use Side Switch" section, choose either "Lock Rotation" or "Mute."

Published with permission from TechAdvisory.org. Source.

Topic Tech Tips