Friday, December 26, 2014

Calculate Day of Year and Days Remaining in Excel

How to Calculate the day of the year and the days remaining in Excel

Day of the year:
=A1-DATE(YEAR(A1),1,0)


Friday, December 5, 2014

Report Scraped Content to Google - New Form!

If you find your work has been scraped, you can report it to google with Google's new Scraper Report form:

https://docs.google.com/forms/d/1Pw1KVOVRyr4a7ezj_6SHghnX1Y6bp1SOVmy60QjkF0Y/viewform

Creative Commons License This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License. This post has been scraped in violation of that license if you are reading this post on other than http://www.digital-qa.blogspot.com/.

Monday, November 24, 2014

How to Opt out of Facebook's Personalized Advertising

Opt out of Facebook's interest based advertising here: http://www.aboutads.info/choices/

From Facebook:
Giving you more control over ads
We've heard from some of you that it can be difficult to control the types of ads you see if you use multiple devices and browsers. In the past, if you opted out of certain kinds of advertising on your laptop, that choice may not have been applied for ads on your phone. We know that many people use more than one phone, tablet or browser to access Facebook, so it should be easy for you to make a single choice that applies across all of your devices.
That's why Facebook respects the choices you make about the ads you see, across every device. You can opt out of seeing ads on Facebook based on the apps and sites you use through the Digital Advertising Alliance. You can also opt out using controls on iOS and Android. When you tell us you don't want to see these types of ads, your decision automatically applies to every device you use to access Facebook. Also, we're now making ad preferences available in additional countries, beginning with Australia, Canada, France, Germany, Ireland and the UK.

Sunday, October 26, 2014

GoDaddy Support - Contact Info

Phone: (480) 505-8877
or click for System Alerts:
System Alerts | GoDaddy Support | GoDaddy Support

Creative Commons License
This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License. This post has been scraped in violation of that license if you are reading this post on other than http://www.digital-qa.blogspot.com/.

iPhone: Purchased items have not been transferred to iTunes

If you get this message, "There are purchased items on the iPhone... that have not been transferred to your iTunes library. You should transfer these items to your iTunes library before updating", do this to transfer those items. (Note some or all of those may simply be "free" apps.)

1) Before you can transfer the purchases you need to Authorise the computer (do this from the Store menu)

2) Once the computer is authorised, then you can transfer the purchases (File->Devices->Transfer...)

Source: Stephen Kellett on Apple Support: There are purchased items on the iPhone “... | Apple Support Communities

Sunday, October 19, 2014

How to Change Blogger Post URL

To change the URL for your blogger: Click on "Revert to draft" while in edit mode of the post, and you can now change the permalink.

More here: Changing blogger post URL – Change the permalink URL of published Post

What these mean:

Permalink: A permalink is the URL of your blog post. Blogger can either automatically generate a URL for you based on the content of your post, or you can customize the portion of the URL after the date. 


Title LinkLink your post title to a specific URL, or leave blank to link the title to your post.

Enclosure LinksEnclosure links help you make podcasts, MP3s, and other content in your posts playable in feeds like RSS and Atom.


Creative Commons License
This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License. This post has been scraped in violation of that license if you are reading this post on other than http://www.digital-qa.blogspot.com/.

How to Erase Data on a Hard Drive

Everyone needs to erase data on a hard drive at some point!

The File-by-File Method 
1. INDIVIDUAL FILES ELIMINATED, SOFTWARE REMAINS INTACT 
  • To completely destroy a file, use a data-shredding program such as Digital File Shredder from StompSoft ($30). It takes a conventional "erase" a step further by actually writing over the file.  
The Whole-Drive Method 
2. ENTIRE DRIVE IS PERMANENTLY ERASED, BUT STILL USABLE 
  • Completely reformatting your drive doesn't eliminate data.
  • Many of the best data-erasing programs come from the same companies that produce data-recovery software. DataEraser ($30), from Ontrack, completely overwrites the drive.
The Power Tool Method 
3. DATA IS GONE, HARD DRIVE IS TOAST 
  • Drilling four holes through the platters will ensure that they never spin properly again.
  • Better yet, unscrew and remove the top lid of the drive, and go at the platters with a sander or angle grinder. Scuff the surface of the platters until all the shine is gone.

Saturday, October 18, 2014

Restore and view archived items - Outlook

Keeping this here for safe-keeping!

Restore and view archived items in Outlook


All messages, contact information, calendars, and other data that you create in Microsoft Outlook are kept in your Personal Folders file (.pst) or if you use a Microsoft Exchange Server account, on your organization’s Exchange server. Outlook provides an archive function to purge your commonly used folders of older content that you don't need, but don't want to delete. You can have this done automatically with AutoArchive, or you can also archive manually as desired.
While the archived content no longer appears in folders that you commonly use, you can still access and retrieve those items if you want to restore that content.
What do you want to do?

>>Copy all archived items from a .pst file back into their original folders

  1. On the File menu, click Import and Export.
  2. Click Import from another program or file. Click Next.
  3. Click Personal Folder File (.pst). Click Next.
  4. In the File to import box, change the default file name in the path from backup.pst to the name of the archive file you're importing from. Click Next.
  5. Click the folder to import from. If you want, click Include subfolders.
  6. Specify how you want Outlook to handle duplicate items.
  7. Click Import items into the same folder in, and then click the folders with the same name as the folders you're importing from.
  8. Click Finish.

>>Copy all archived items from a .pst file into a new folder

  1. In Outlook, create a new folder to copy the archived items to.
  2. On the Go menu, click Folder List, and then in the Folder List, click the new folder.
  3. On the File menu, click Import and Export.
  4. Click Import from another program or file. Click Next.
  5. Click Personal Folder File (.pst). Click Next.
  6. In the File to import box, change the default file name in the path from backup.pst to the name of the archive file you're importing from. Click Next.
  7. Click the folder to import from. If you want, click Include subfolders.
  8. Specify how you want Outlook to handle duplicate items.
  9. Click Import items into the current folder.
  10. Click Finish.

>>Move individual items from a .pst file into their original folder or a new one


  1. On the Go menu, click the Folder List, click Archive Folders (or the name you used for the archive location).
  2. Click the folder containing the items you want to move.
  3. Select the items you want to move, and then drag them into their original folders in the Folder List.

Tuesday, October 14, 2014

Don't install iOS 8 - iPhone runs so slowly!!!

After installing iOS 8 it takes a long time for my iPhone to do just about anything. I had no problem with slowness before upgrading. It was instantaneous - from fast to slow. Don't do it. Unfortunately I can't roll back. Quite disappointed in #Apple. I have a 4S.

Creative Commons License This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License. This post has been scraped in violation of that license if you are reading this post on other than http://www.digital-qa.blogspot.com/.

Stop Walgreens App from Showing on Locked iPhone Screen

To stop the Walgreens app from showing on your locked screen, select the Passbook App and within here you can stop apps from showing on your locked screen.

Creative Commons License This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License. This post has been scraped in violation of that license if you are reading this post on other than http://www.digital-qa.blogspot.com/.

Saturday, October 4, 2014

How to Delete all Emails on your iPhone at Once

Mass Deleting Email on an Iphone - iO7 or iOS6


Basically it's this:
  • Click on Edit at the top right of the screen while in the email app
  • Check the first email item
  • Hold down the move button at the bottom of the screen, and at the same deselect the the email you just selected (yeah, you gotta use your other hand) and then let go of the move button
  • A new window appears and allows you to move all your email messages to trash!

Thursday, September 4, 2014

How to remove a name from an Outlook Distribution List (aka Contact Group)

Create and edit a Contact Group (formerly distribution lists) - Outlook
  • Start a new email message
  • Click "To"
  • In the drop-down list highlight the distribution list you want to change and then right-click on Properties.
  • You can add/remove names here (if you have rights to do so)

Tuesday, August 19, 2014

What to do after your bike has been stolen in the Bay Area

What to do after your bike has been stolen in the Bay Area

I've had 2 bikes stolen in San Francisco over 10 years. Bookmark this article in case you need to know what to do if your bike's been stolen.

Friday, July 18, 2014

Turn off Google Listening Search

Turn off (or on) Live Google Search here:
  1. Chrome Settings (far upper right - looks like 3 parallel horizontal lines)
  2. Settings
  3. Scroll down and select "Show advanced settings"
  4. Privacy:
















Creative Commons License This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License. This post has been scraped in violation of that license if you are reading this post on other than http://www.digital-qa.blogspot.com/.

Sunday, July 13, 2014

How to eat Salad out of a Jar

This works! You can eat the salad out of the jar:

At lunch, take the lettuce out, shake everything else up in the jar, and then re-add the lettuce.

My Tiny Little Life: Mason Jar Salads


2013-3-11-salad.jpg

Photo: http://www.thekitchn.com/no-more-soggy-salad-a-guide-to-the-perfect-salad-in-a-jar-186104

How to Make Bullets in iCloud Notes

Quite simply: Type an asterisk (*) and then tap the space bar

Thursday, July 3, 2014

Sony Vaio DVD Drive Stopped Working

So easy... this worked for me:

"...try Uninstalling the drive by right-clicking on it in Device Manager and choosing Uninstall. Re-booting your Vaio will reinstall the drivers."

More suggestions:

http://community.sony.co.uk/t5/pcs-accessories/if-you-have-dvd-cd-drive-problems-read-this-gt/td-p/24135

Sunday, June 29, 2014

Recover Deleted Outlook Task

To find a lost Task in Outlook 2010:
  1. In Mail view, select "Deleted Items" folder
  2. Go to "Recover" tab, then select "Recover Deleted Items" icon
  3. Here you'll see all your deleted mail, tasks, etc.
  4. Sort the most recently deleted items to the top by clicking on the "Deleted" header twice (sometimes I sort by Subject if I remember what I named it)
  5. Highlight the item you want to recover and click the "Recover Selected Item" icon in the top left corner
  6. Then, close the dialog box and go to your Deleted Items folder and drag the task to the task section (NOTE, in Outlook 2010 recovered items go to the Deleted Items folder - NOT back to the original location)

Creative Commons License This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License. This post has been scraped in violation of that license if you are reading this post on other than http://www.digital-qa.blogspot.com/.

Sunday, June 15, 2014

Have iPhone Screen Turn Off Faster

Go here to have your iPhone screen turn off faster (and save battery juice!):
  • Settings
  • General
  • Auto-Lock
  • 3 minutes (or whichever you choose)
This is also known as "auto-sleep".

And while you're at it, turn these off too (more battery juice save):
  • Settings
  • Background App Refresh (and slide all off)

Friday, June 13, 2014

Blackberry: Set an out-of-office Reply

To perform this task, your BlackBerry® device must be associated with an email account that uses a BlackBerry® Enterprise Server that supports this feature.

  1. In a message list, press the Menu key.
  2. Click Options.
  3. Click Email Settings.
  4. If necessary, change the Message Services field.
  5. Change the Use Out Of Office Reply field to Yes.
  6. In the text box that appears, type a reply.
  7. If you use IBM® Lotus Notes®, in the Until field, set the date on which the out-of-office reply should turn off.
  8. Press the Menu key.
  9. Click Save.

Saturday, June 7, 2014

How to see your iPhone calendar in a continuous list view

This was not intuitive!

How to see your iPhone calendar in a continuous list view:
  • Just click on any single date (best if you pick today's date so the list is on or around today then say sometime back in 2013)
  • Voila - you are now in list view
Creative Commons License This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License. This post has been scraped in violation of that license if you are reading this post on other than http://www.digital-qa.blogspot.com/.

Remove Bing as Default Search Engine

Somehow Bing became my default search engine in Internet Explorer. To make Google your default search engine do this:
  1. Go to www.google.com. If Google is not your search engine, it will ask you (at the top of the web page) if you would like to make Google your default search engine, select 'Yes'.
  2. Next I would do the following steps (although you don't have to):
    1. Open internet explorer
    2. Click on tools
    3. Select internet options
    4. In general tab, and under search tab, click on settings
    5. Click on search providers
    6. You should see Google selected as the default if you did step #1 above.
    7. Highlight the bing search engine and then select remove
    8. Click on close and then ok
    9. Restart explorer
And if you're on IE 10.0:

Select the Gear icon, then Manage Add-Ons, then Search Providers. From there, you should be able to select Google as your default service.

Creative Commons License This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License. This post has been scraped in violation of that license if you are reading this post on other than http://www.digital-qa.blogspot.com/.

Sunday, May 4, 2014

Snagit: Add Fill Color to a Text Box

Here's how to add color to a text box - this is not easy to find!

  • Double-click to highlight the text within the text box
  • Press the Ctrl button
  • Click on any color in the screen shot, and that color becomes the background of the text box!


Creative Commons License This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License. This post has been scraped in violation of that license if you are reading this post on other than http://www.digital-qa.blogspot.com/.

Saturday, April 19, 2014

How to show Photos on your TV through the USB Drive

How to show a slideshow of photos on your TV through the USB Drive:



















Source: Digital Still Camera | i-Manual online | EX71

Saturday, March 29, 2014

How to Turn off the iPad

To turn off the iPad, it's just like turning off the iPhone:
Hold the button on the top right-hand corner of the iPad for a few seconds until a red slider appears. Slide to power off.
Creative Commons License This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License. This post has been scraped in violation of that license if you are reading this post on other than http://www.digital-qa.blogspot.com/.

Sunday, March 23, 2014

My Favorite DVD Ripper: Handbrake

How to rip a DVD to a computer - three easy methods - PC Advisor

Open source video transcoder

www.handbrake.fr

Creative Commons License
This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License. This post has been scraped in violation of that license if you are reading this post on other than http://www.digital-qa.blogspot.com/.



Friday, March 21, 2014

GoDaddy website Not Found

In order for your site to resolve you will need to update your domain's A Record to point to the IP address for your Website Builder account.

To View Your Website Builder Account's IP Address

  1. Log in to your Account Manager
  1. Click Website Builder
  1. Next to the Website Builder account you want to use, click Launch
Your IP address displays in the IP Address field.

Please use the following information to link your domain to the IP address you've been provided (this will be placed in the Points to field as indicated in Step 6 below).

To Edit an @ A (Host) Record 

  1. Log in to your Account Manager. 
  1. Click the Products tab under your name. 
  1. Click the Launch button on the DOMAINS bar. This will open your Domain Manager. 
  1. From the DNS pull down menu, select DNS Manager, and then click Edit Zone for the domain name you want to update. 
  1. In the A (Host) section, click the A record you want to edit. 
  1. Edit any of the following fields: 
    • Host@ Leave as default 
    • Points to — Enter the IP address your domain name uses for this host record. 
    • TTL — Leave as default 
  1. Click Save Zone File, and then click OK
Changes to the settings of a domain take an average of 48 hours to become effective because of the number of networks involved, and because these networks are controlled by several different agencies. Additionally, it may take up to 48 hours for the old DNS information to expire and be removed from any servers that have stored (cached) information about your domain.

This applies to all domains with any Registrar, not just Us. Please allow for this update when planning web sites or configuring the DNS of a domain. Please contact us (
support@godaddy.com48 hours from the requested change if the problem has not resolved itself and we will be happy to investigate the issue further.



Creative Commons License This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License. This post has been scraped in violation of that license if you are reading this post on other than http://www.digital-qa.blogspot.com/.

Thursday, March 20, 2014

Transfer Music from Nano to Computer - No Software Needed

No software needed. This is a a free and easy way to transfer music from your iPod Nano to your computer:

1. Connect your iPod Nano to your computer. If prompted to sync with the iTunes library, select "Cancel." If syncs automatically, close iTunes.
2. Click the "Start" button on your desktop and click "My Computer."
3. Double-click "My iPod," and if there is a folder named "iPod Control" double-click it and select "MUSIC."
(If there is not, click the "Tools" menu at the top of the window and select "Folder Options">"View" and check "Show hidden files and folders", and then click "OK." The "iPod Control" folder will now be visible.)
Note the music titles will look strange (e.g. GLOV) but when they transfer the full titles and other metdata will display correctly.
4. Open a folder on your computer where you want to save the music files.
5. Drag and drop the music files from the iPod's "MUSIC" folder into this folder. The files will transfer to the selected folder and be saved to your computer's hard drive.
6. If you want to upload into iTunes. Open iTunes. Click File, Add folder to library, and then select this folder you just created.

Follow-up: I also found this wonderful application:
http://www.macroplant.com/iexplorer/features/transfer-music-and-playlists-to-itunes/



Creative Commons License This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License. This post has been scraped in violation of that license if you are reading this post on other than http://www.digital-qa.blogspot.com/.

Monday, February 10, 2014

Turn off or Change iPhone VIP email Alert Sound

Found that here:
  1. Settings
  2. Notification Center
  3. Mail
  4. VIP (at bottom)
  5. Alert sound (I selected None)

Creative Commons License This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License. This post has been scraped in violation of that license if you are reading this post on other than http://www.digital-qa.blogspot.com/.

Saturday, January 25, 2014

Scanned Documents are too Light!

Here's how to fix that:

  • Search your hard drive for: HP Scan
  • Open and select "Document to File" (PDF)
  • Adjust resolution. 600 dpi should work but you can increase all the way up to 1200 dpi. (Mine initiated at 200 dpi, way too light)


Creative Commons License This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License. This post has been scraped in violation of that license if you are reading this post on other than http://www.digital-qa.blogspot.com/.

Saturday, January 18, 2014

Stop Google Search from Opening in New Tab

Go to the Google Search Settings page:
and uncheck the box:

Where results open


Open each selected result in a new browser window.

Stop Google Search from Opening in New Tab

Go to the Google Search Settings page:
and uncheck the box:

Where results open


Open each selected result in a new browser window.

Thursday, January 16, 2014

Yahoo Mail doesn't work in Chrome Browser

If you can't see your Yahoo mail in your Chrome browser, update Chrome by downloading the latest version here: https://www.google.com/intl/en/chrome/browser/

Creative Commons License
This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License. This post has been scraped in violation of that license if you are reading this post on other than http://www.digital-qa.blogspot.com/.



Tuesday, January 7, 2014

How to Turn off United Airlines Phonecall Alerts

You can change or turn off the pre-flight alerts (phonecalls or texts) for United Airlines here:

United Airlines - Flight Status Notification Subscription

Under the Phone section, you'll also want to select Edit and be sure the phone choices are correct for how you would like to receive reminders.

I have mine set to "Notify me of my flight status and gate information" "1 hour in advance", via text.

Creative Commons License This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License. This post has been scraped in violation of that license if you are reading this post on other than http://www.digital-qa.blogspot.com/.

Related Posts Plugin for WordPress, Blogger...