Use Data Validation to check for Duplicate Entries

If you are setting up a spreadsheet for someone else to enter data this is a neat trick. You can use the Data Validation and the CountIF feature to check for duplicate entries and then not allow the user to enter the duplicate data.

To read more, please  click here.

VBA - Ebooks

Want to Learn VBA?

I've had a couple of people asking about VBA lately and wanted to tell you about a site that contacted me. They are a UK site called Best STL and they do training.  They are currently offering 2 excellent Ebooks on VBA for free.
Check them out when you have a chance.  I am hoping to get a CPE course on VBA out sometime next year but in the meantime you might find this information very helpful.

http://www.microsofttraining.net/vba-training-manuals.php

Refreshing Pivot Tables

Quick Tip for Refreshing Pivot Tables

Alt+F5 will refresh all the Pivot Tables on the sheet.
CTRL +ALT+F5 will refresh all Pivot Tables in the workbook.

Ebooks Now on Amazon

Just wanted to let you know that we have started putting some of our Excel Ebooks on Amazon. I have had some people who are not CPAs and who do not need CPE ask that we do that.

So, far we have 2  Excel Ebooks out there:

 Comprehensive Look at VLookup and othe Lookup Functions
Excel Time Value of Money Functions

Setting up Ringtones for a Contact on your Iphone

Setting Up Different Ringtones on IPhone

You can  set up different ringtones, text tones and even different vibrations for specific people on your Iphone. This can be very useful if you want to be able to identify certain calls but you cannot immediately access your phone.

Here are the steps.

Tap the Contacts icon on the Home screen.
Select the person you want to assign a specific ringtone.
 Once you have their  page open, click on Edit ( in the top right hand corner). 
Scroll down to Ringtone; it should be set to “Default”. Click the arrow (chevron) to the right of  “Default” and select a new sound. 
When you select a new sound it will play it for you so that you can hear what it sounds like. If you don’t like it then try another one ringtone. That's it... 

This is very useful if you have kids  and you may also find it useful if you have a bothersome boss or employee :)