Advanced+Excel+Tips

While doing my homework, I was confused about a few of the steps. So, I decided to go to Google to try and find answers. I did find what I was looking for, and even found a ton of valuable information that I was not looking for. on the Microsoft support website ([]) there is a full description of many tips and tricks that are undiscovered by many excel users. Some of the information is on


 * How to exclude duplicate items from a list:**
 * 1) choose "Advanced Filter"from the Data menu
 * 2) click "Copy To" under "Action"
 * 3) in the "List Range" box type in an absolute reference to the cells to which you are referring
 * 4) click "Unique records only" and then "OK"
 * Changing cell contents from text to number values:**
 * 1) select the range containing the values
 * 2) click "Text to Columns" on the data menu
 * 3) click "Next" until you are at step 3 of the wizard
 * 4) click "General" under "Column Data Format", then click "Finish"


 * How to enter the time and date into a cell without typing it out:**
 * 1) pressing "CTRL+" and then "Enter" will enter the current date
 * 2) pressing the same combination again in the same cell will enter the current time

This website is a great resource that can be used by anybody who wants to simplify the use of Excel.