EXCEL =SUM(10,10,5)

Excel was released to the world 25 years ago today. Geek out to the history...

Microsoft Word: Document Clean-up

I was recently assisting someone in the clean-up of a rather large document. After setting a style for the document text to have a first line indent, we needed to get rid of the tab character used to originally create this indent. You know I’m all about the shortcuts, so here’s how we did it.

Set a first line indent for the document text

1. While the cursor is in the first paragraph of text, grab the top part of the left margin boundary marker on the ruler bar and move it to the desired location.
2. [You can also click the dialog box launcher of the Paragraph group and change the Indentation, Special: to First line and By: (any amount).] 
3. In the Styles group on the Home tab, right-click the Normal style and select Update Normal to Match Selection.

Remove all tab characters

1. In the Editing group of the Home tab, click Replace.
   If you see the More >> button, click it to view more options. 
2. Be sure your cursor is in the Find what: field. Click the Special button at the bottom and select Tab Character. You will see ^t in the field to represent the tab. 
3. Leave the Replace with: field empty. This will replace all tab characters with nothing, thus deleting them. 
4. Click the Replace All button.

You’re done!

Microsoft Excel: Highlight all cells referenced by a formula

When helping a client, I often look at worksheets I am totally unfamilar with. This makes it hard for me to know what’s going on to easily find the problem. To help me understand how cells and formulas are interrealted, I will highlight all the cells referenced by a formula.

To do this, select a cell with a formula and press Ctrl+[ (open-square-bracket). Excel highlights all the cells referenced by the formula. Use Enter and/or Tab (Shift+Enter and/or Shift+Tab to shift into reverse) to move among the selected cells.

But what if you want to do the reverse, and see the formulas that reference the a cell? You guessed it, select the cell, and press Ctrl+] (close-square-bracket).

No Handouts from PowerPoint

PowerPoint is for presentations. Let me say that again and you disect what I’m saying: PowerPoint is for presentations, not handouts. A copy of miniture slides with tiny little lines next to each one is NOT a handout; regardless what PowerPoint says.

Handouts are to be more indepth and expand on what the presentation is. For this, you should be creating handouts in a program such as Word. “But, I want the visual and I’m too lazy to copy and paste everything from PowerPoint to Word,” you say. Quit your whining and use the Create Handouts option in PowerPoint.

With your presentation open, go to the File tab, click Save & Send, then click Create Handouts and click the Create Handouts button. (In 2007, click the Microsoft Office Button, point to Publish, and then click Create Handouts in Microsoft Office Word.) All that is left is to select your layout and click OK.

Small pictures of your slides will be included with your text. I suggest you delete slides that are not visually important to the text, such as where text is duplicated. Slides can be resized to make charts and images more readable. Slide titles will format as a Heading 1 style. Text on the slides will be formatted as Heading 2, 3, etc. You will have to add the body text to make the information useful and understandable.

Interesting New Blog

At UNL, I work with an amazing bunch of students with the Student Technology Assistance Program (STAP). It's a group of students doing real work while they learn. There is also a group that teaches other students computer programs. They have recently decided to begin a blog with tips, reviews and other interesting technology related news stories from a college student point of view. I'm really excited to see what they've already done and look forward to future posts. Please check out the Innovations blog and see what they're about. You'll be glad you did.

Clippy is My (Ribbon) Hero

It's a fact. I'm a Ribbon Hero. I took the test to prove it, too. If you don't know what I'm talking about, you should check out Ribbon Hero 2 from Microsoft. It's an add-in that will watch what you do and you earn points as you work. You can also launch the game-based learning and it will open the Microsoft programs (OneNote, Excel, PowerPoint and Word) where you perform the tasks asked of you. Best of all, it's the return of Clippy. If you think he got a bad rap back in 1997-2003, he is back to redeem himself. You start by helping him with his resume.

It's really kind of fun and a great example of game-based learning. If you don't know how to perform a task, you can ask for a hint to help you. If you are a "power-user" you'll find this easy. Too easy. If you are a casual user and want to explore a little more of what you might not know, this is definitely for you.

I'd recommend Ribbon Hero 2 for anyone who needs to brush up on their skills because it does have varying levels from beginning to advanced and covers a variety of tasks. You also can pick and choose your tasks and still progress through the levels so everyone can have a sense of accomplishment. For example, I'm not a OneNote user, so I chose the tasks for Word, Excel and PowerPoint and was able to work through the levels. When I was done, I was able to go back and tackle the tasks I skipped in those programs, too. I look forward to learning more about OneNote and taking on those challenges as well.

Have fun, and let me know if you're a Ribbon Hero like Clippy and me!

Microsoft Access: Web Browser Control

I love how on websites you can click to view a map. Somehow the address fields are set to map to a mapping program, such as Google Maps or Mapquest, and you’ll see a map to your destination. You can now replicate this on your Access forms using the Web Browser Control.

First, go to your favorite map site (I found deciphering Map Quest was easier), type in your address (you'll delete this later) and locate it on the map. Copy the URL.

1. On the Form Layout Tools|Design ribbon, in the Controls group, select the Web Browser Control, and then click to place it on the form. Access opens the Insert Hyperlink dialog box.
   
2. Paste the URL of the web page into the Address: field of the Insert Hyperlink dialog box, and then press TAB on the keyboard to move to the next field. Access clears the Address: field and separates the URL into the appropriate fields.
   
3. To set the control so that its URL changes based on the data that is displayed on your form, you must replace the appropriate URL components with expressions that refer to the appropriate controls on the form. Here's where having your address helps you locate the correct areas for your fields.
1. Click the path or parameter that you want to replace, and then click the Build button.
2. In the Expression Builder, double-click the control that contains the data you want.
3. Click OK to close the Expression Builder.
4. Click OK.