It is a sad month for Microsoft Office users. Click here to find out why.
Archive for the 'Microsoft' Category
It can be hard to teach effectively if your students don’t have the basic technology skills they need.
Did you know that IT Training can provide workshops specifically for your class? All you need to do is ask. Most of our workshops are available for special request, which means we can teach your class (or any group of 10 or more IU faculty/staff/students) either in our classroom, online, or in another location that will accommodate your group. How much does it cost? Nothing!
Just go to http://ittraining.iu.edu/request/ at least 3 weeks ahead of time, and start by choosing your desired workshop from the drop-down list. Options include Microsoft Office tools like Word, Excel, PowerPoint and Access; Adobe software like Photoshop, InDesign and Dreamweaver; Web skills like page design and HTML/CSS; and much, much more. We can even help your students create ePortfolios in Oncourse, or get them oriented to our new learning management system, Canvas.
If your class or group needs a training workshop, request it and we’ll offer it just for you.
While working on metrics for our web site, I discovered that by default you are only allowed to apply one filter per field when using a Pivot Table. So if you try to apply a second filter, the first filter will be removed. In good news, you can change the PivotTable Options and allow more than one filter to be applied to the same field.
Here is a video I found that shows specifically how to do this:
Found a really great tip the other day over at Penn State. Unfortunately the page is now giving me a 404 error, so I’m reproducing the tip here.
Have you ever added a table to a the end of Word document and ended with an extra page that you couldn’t get rid of? The problem is that when you add a table at the end of a Word document, Word automatically adds paragraph mark after a table.
Most of time this paragraph doesn’t cause a problem, but sometimes there isn’t room for the paragraph at the end of the document and you end up with an extra blank page.
To get rid of the extra page:
- Open the document.
- If necessary, go to the Home tab on the ribbon.
- Turn on the formatting codes by clicking the Show/Hide Button. See Figure 1.
- Find and select the extra paragraph mark.
- To open the Font properties dialog box, click the dialog box launcher. See Figure 2.
- In the Effect section of the Font dialog box, select the Hidden checkbox. See Figure 3.
- Click OK to accept the changes.When you look at the page, it appears the extra space is still there.
- Turn off the formatting codes by clicking the Show/Hide button again.
You now should see the document without the extra page.
As a sometime language teacher, the ability to spell and grammar check my work in Microsoft Word is critical. But if you’re unlucky enough to be typing in the non-default language on your computer, particularly when the tool to automatically detect language is (a) turned off or (b) just not getting it, such as when you are writing a paper in one language but citing a work in another, you may end up fighting constant multi-colored squiggles, or Word’s usually “helpful” auto-correct features. This can significantly slow you down as you constantly fight with the program.
The key, then, is knowing how to help Word figure out which spell check dictionary it should be using at any given point in your text. Thankfully, it’s not terribly hard. Read the rest of “Multilanguage spelling checks can bee done” »
IT Training will be teaching Microsoft Office 2013 workshops this fall, and we are anxious to begin telling the IU community about the new features that are available in this version of the popular suite. If you are planning on taking some of our free workshops or webinars, you might want to download and install the software from IUware. Remember, Indiana University faculty, staff, and students may download most of the software available from IUware for free.
If you decide to download and install Office 2013, I would encourage you to download the 32-bit package, even if you are planning on running it on a 64-bit system. Earlier in the summer I installed the 64-bit suite on a laptop running Windows 7, and I was very unhappy with the results. Every time I tried to use Outlook, Word, or PowerPoint, the application would freeze and/or crash. After discussing this issue with the Support team here at IU, and reading multiple forums and Microsoft Help articles, I uninstalled the 64-bit version and installed the 32-bit version instead. After that, I didn’t have any problems.
I have left out an important part of the story. When I first tried to uninstall Office 2013, I was unable to do so. While in the Control Panel, I selected Microsoft Office 2013, clicked on the Uninstall link at the top of the window, and waited. Nothing happened. I tried again. Nothing happened. I probably even tried a third and fourth time before I realized that this was simply not going to work.
After a little digging, I found the solution on this Microsoft Support page:
http://support.microsoft.com/kb/2739501. I downloaded the Fix it tool that they provided, and then I was able to uninstall Office 2013 from the Control Panel just as I normally would.
Hopefully this article will save you some time if you decide that you want to uninstall the package.