Question: Do you have any handouts or learning resources for OneNote?
Answer: I recently stumbled upon a really great resource at Microsoft, 15 minute video blogs every Tuesday around 11:15 a.m. – our time. November 12 featured OneNote for the Holiday. It is a very nice, quick overview on how to use OneNote, and it includes other links to OneNote resources.
Using OneNote for holiday planning is a fun way to learn the application, and then you can feel more comfortable using it for work projects. Not only that, you can save your notebook “in the cloud” so that you can use it or share it with others from home computers, tablets or smartphones! I have used OneNote to keep track of holiday card lists, gift lists, recipes, decorating, vacation planning, gardening, and of course, work projects! You must not, however, keep work notebooks in the cloud if you have sensitive information. But you can save OneNote notebooks on secure network drives to share with others. OneNote also integrates well with other Microsoft applications, especially Outlook.
Be sure to check out Microsoft’s list of 15 minute video blogs.
Question: I have started using Office 2013 and noticed many differences between Office 2013 and Office 2010, particularly with Outlook and Calendar. Are you aware of any summaries describing the differences?
Answer: The differences don’t seem to be extensive, but there are some changes. In particular, you now have the ability to save directly to the cloud (although Office 365 has limited features compared to 2013). There are some really nice new features with Excel such as flash fill and quick analysis too. This handout provides some excellent video tutorials on the new features and “how tos” of Office 2013. The videos range from very short 1-2 minute clips to longer clips. We are also scheduling some video tutorial sessions in November and December on the new features. See the schedule of sessions here.
Question: I have an Excel file I filtered and then copied “visible cells only” to a new worksheet, so that I could maintain formulas. However, the smaller file size increases to an enormous file size, making it very slow for working with and impossible to email. What is causing this?
Answer: It appears that when you copy visible cells to a new worksheet that it pasted in the blank columns and rows also. You can tell this by noticing the scroll box along the vertical scroll bar remains at the top while scrolling down. You can also click in cell A1 and press Ctrl+Shift+End to go to the last cell of the active worksheet.
Select and delete the columns to the right of your data, and select and delete the rows below your data, and then save your file and close. You should notice the file size decreases to about what it was before. I still am at a loss as to why this happens, but have run into similar questions from users recently about data ranges including blank rows and columns. Here is a link which also includes an add-in you can download to remove excess rows and columns also. http://support.microsoft.com/kb/244435
Question: Do you know how to margin release in Word?
Answer: I’m not sure exactly what your goal is, but if you want to extend your text appear to the left of your margin, you can select the text and go into the paragraph dialog box (slanted arrow in the paragraph category on the Home tab or Page Layout tab and click the down arrow on the Left Indent, making it a negative - indent (such as -.5 which would mean outdented 1/2 inch)
If you want to place text to the left of the margin, like a script, you may want to use a table format.
You can also create a text box and place the text box to the left of the margin. Here are a few other suggestions for placing text outside the margin – http://wordfaqs.mvps.org/MarginalText.htm
Question: I created contact groups some time ago with around 100 names each, since Outlook won’t allow personal group with 300 names (1A, 1B, 1C) I keep the master list in Excel but it has been quite a long time since I updated the groups, and I can’t remember how I can get them updated.
Answer: The easiest way to do this is to have your Excel list open, along with your Outlook contacts.
- Open the first group 1A, and remove the names (use Ctrl or Shift keys to select more than one at a time).
- In Excel, click and drag the list of email addresses that you plan to include in 1A, and copy (Ctrl C).
- Go to your Outlook group and select Add members …from Address Book, and then in the Members field at the bottom of the window, paste (Ctrl V) and click okay. It may appear that the list doesn’t match, because Outlook will probably sort by email address.
- Continue this for the remaining groups you need to set up.