Skip to Main Content

Archive for the 'Microsoft' Category

Looking for Group – edit the size of objects in PowerPoint

I’m trying to compare two pictures of the same area taken at two different times – but not being a great photographer, I was not standing in exactly the same spot both times, so I’m having to crop and zoom like crazy to get the before and after shots to match.

Let’s look at an example using two shots (one taken by Joe Ravi, CC-BY-SA 3.0; the other from http://www.metrodcpohtography.com) of the Jefferson Memorial in my home town, Washington, D.C. In this case I have both pictures in a PowerPoint slide, side by side:

Screenshot of two pictures of different sizes, side-by-side, of the Jefferson Memorial.Once I get them sized relatively, though, I might realize that I want them both to be bigger on the canvas. Fine, except if I’ve finally sized them both perfectly compared to each other, and I try to make one larger, I’ll have to make all of those minute adjustments all over again… or I would, if I didn’t make use of the group tool!

Read the rest of “Looking for Group — edit the size of objects in PowerPoint” »

Presentation Do’s and Don’ts

Clipart of man with a bright idea.Click here for a recording of IT Training’s “Creating an Effective Presentation” by Kim Murday and Denise Brown for the January IUWIT (IU Women in Information Technology) meeting.

In this talk, we covered things like:

  • Use of fonts, colors & backgrounds
  • When to use “bells & whistles”
  • How and when to use graphics, and where to find them
  • Other tips for presenters

For a PDF version of our PowerPoint slides, click HERE.

Do you remember a particular presentation that went really well . . . or really badly?

Share your stories in the comment section!

The End of an Era

It is a sad month for Microsoft Office users. Click here to find out why.

it2go – Episode 77 – Andy’s IT Training Career

On this week’s episode, we’re talking about Andy’s career with IT Training as we bid him a fond farewell.

it2go – The IT Training Podcast

Follow us on Twitter

Like Us on Facebook

Add us on iTunes

Need training for your class? Request it!

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.

 

Allowing Multiple Filters in Pivot Tables

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:

Jen

Word: Removing unneeded line break after a table

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:

  1. Open the document.
  2. If necessary, go to the Home tab on the ribbon.
  3. Turn on the formatting codes by clicking the Show/Hide Button. See Figure 1.

    Image showing the location of the Show/Hide button on the Home tab of Word.

    Figure 1

  4. Find and select the extra paragraph mark.
  5. To open the Font properties dialog box, click the dialog box launcher. See Figure 2.

    image showing location of the font dialog box launcher

    Figure 2

  6. In the Effect section of the Font dialog box, select the Hidden checkbox. See Figure 3.

    Image showing the Fonts dialog box with the Effects Hidden option location highlighted

    Figure 3

  7. Click OK to accept the changes.When you look at the page, it appears the extra space is still there.
  8. Turn off the formatting codes by clicking the Show/Hide button again.

You now should see the document without the extra page.

Multilanguage spelling checks can bee done

Image of the Language group in the ribbon of Microsoft Word.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” »

it2go – Episode 72 – Microsoft Surface Pro 2 Review

On this week’s episode, we’re looking at the new Microsoft Surface Pro 2. Hear all about how it works as a tablet, and how it works as a laptop.

it2go – The IT Training Podcast

Follow us on Twitter

Like Us on Facebook

Add us on iTunes

Can’t Uninstall Office 2013

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.

Get Training Tips via RSS Subscribe to Entries feed or Read Comments via RSS Subscribe to Comments feed.