Learn IT

Color categories in Shared Calendar

Question: I take care of my boss’ Outlook calendar and have Editor rights to it.  Recently, I wanted to add some additional Color Categories for some her many different types of appointments. I find that I am only able to add additional colors to my own calendar. When I attempt the same steps while in her calendar the “New”, “Rename”, and “Delete” options are grayed out. Is there a way for me as Editor of her calendar to add, rename or delete color categories from her calendar? Answer:… Continue Reading

Archiving Outlook Mail

Question: How can I archive my e-mail? Answer:   The archive feature is not enabled at UNMC, but you can simply drag your emails to a folder on your network folders, and then delete from your email to save space. You can’t drag folders to your network folders but you can create the folders and drag the emails to them. You can select several emails by using shift or ctrl keys. If you have Adobe Acrobat X or later, you can save your email folders and messages… Continue Reading

Word Table of Contents

Question:  What is the best way to do a table of contents for an existing Word document? Answer: The easiest way is to use heading styles for the topics you want in your document and then go to where you want to place your TOC and from references tab click Table of Contents and select a style and it will create one based on the heading styles. Super easy. There are also three step-by-step courses at Microsoft that are good too. http://office.microsoft.com/en-us/training/word-2007-training-courses-HA010215566.aspx and scroll down to… Continue Reading

Slow Excel files

Question: Why is my Excel file so slow when opening? Answer: I hear this problem occasionally and the typical problem is that there are many extra columns or rows included in the data range. Sometimes this is caused by typing something (even pressing the spacebar) in a cell far away from the data or from formatting cells outside the data range. The easiest way to tell is by pressing Ctrl End, which will take you to the last cell of the range. If this is the… Continue Reading

Grouping by days of the week in a pivot table

Question: I am trying to create a report from Excel data that was exported from a web application that has date fields and values in which I can get an average of values for the various days of the week. How can I do that? Answer:  If your data contains a date field, you can display the day of the week using one of the date formatting styles, but a pivot table does not allow you to group by days of the week. However, you… Continue Reading