Learn IT

Question of the week of 9/12/11 – Remove duplicate values in Excel

Question: Is there a way to remove duplicate values from a long list of names in Excel? Answer: Yes, select your range and from the Data tab, click Remove Duplicates. A popup will allow you to select which fields to select for your duplicate values. You can unselect all fields, and selecting just a couple of fields will break down your list more than if you have many fields included. Be careful, as this will delete your data, so you may want to save the results with the… Continue Reading

Question of the week of 8/22/11 – disabling bulleted lists from renumbering after deleting sections

Question: I have a document which has a numbered outline. I would like to delete a section of the outline without having the rest of the outline renumbered. How can I do that? Answer: I thought it was a matter of unchecking autoreplace  for bullets/numbering and lists options in your Word Options. However, after disabling many other options, the rest of the outline updated when a section was deleted.  The only workaround I found is to let the list renumber and then go to the place where you want… Continue Reading

Question of the week of 7/11/11: Quick fill in Access

Question: I my database I would like to fill multiple cells with the same info. In Excel there is that lovely function where you highlight all the cells you want to fill the same info and do a fill right or fill down select and it’s like magic. I am not finding the easy way to do this in Access but there has to be one. Answer: That feature is not really available in Access, although you can create autonumber fields that will automatically add… Continue Reading

Question of the week of 1/11/10 – Emailing an Access table

Question: How can I email an Access table to someone without emailing the entire database? Answer: The only way to email a table is to export it in another format, such as an Excel spreadsheet, word table or PDF document, or you can copy and paste the table into an email message. In Access 2003, select the desired table and click Tools > Office Links > Analyze it with Excel (or Publish it with Microsoft Word). To save in PDF format in Access 2003, you… Continue Reading

Question of the week of 7/20/09 – Pie Charts in PowerPoint 2007

Question: I have a presentation in 2003 format which I am modifying in PowerPoint 2007. I have added a chart but it keeps asking to convert and when I do the chart no longer looks good. I can’t save it in 2007 format either. How do I fix this? Also, can I resize data labels so that long text won’t wrap improperly? Answer: When you open a 97-2003 presentation in PowerPoint 2007, it keeps it in compatibility format, even though new charts use the 2007… Continue Reading