25 Years of EXCEL-lence

On September 30, 2011, Microsoft Excel will celebrate 25 years. In this video, you'll see Nebraska-boy, Jeff Raikes, talking about his contribution and experience working with Excel.

PowerPoint for Mac 2011 at CES 2011

Removing the background from images (which can also be done in Word) has been a great feature in both the PC and Mac latest versions. Thank you for making it so easy!

Word for Mac 2011 at CES 2011

Reading view in Mac 2011 is so much better than in PC 2010/07. And don't even get me started on the layers. Come on Word for PC development staff, we want this, too!

Office for Mac 2011 at CES 2011

I've begun to play around with the new Office for Mac 2011 and written in the past that it's much closer to the PC version. But here is a great video that will help you get to know the new UI (user interface).

Microsoft Office: Open documents that Office wants to block

Old stuff ain’t safe. At least according to Microsoft. Therefore, when you try to open files in the 97-2003 file format (or earlier), Office 2010 will block editing (and macros) of these files until you decide they are safe. The problem arises when you upgrade, all your files are in the previous format and blocked from editing. You can easily click the Enable Editing button that appears in the yellow bar under the ribbon, but if you want to be proactive, you can change this setting.

In Word or Excel, go to the File tab, click Options, click Trust Center on the left, and then click the Trust Center Settings.. button. On the left, select File Block Settings, and remove the checkmarks from the older Office files that you want Office 2010 to open. There are additional settings for how to open at the bottom of the dialog box.

Microsoft Office mac2011

Finally here! And finally closer related to the Windows version. I can now offer training on either or without much of a fuss. Still not as seamless between the platforms as the Adobe products, but this new version is a huge step in the right direction.

If you're wondering, UNL's Microsoft license allows for UNL office to upgrade the Mac as well as the Windows versions for free. If your department is still using Mac Office 2008, it is worth your time to upgrade.

Access 2007: Print Access report summaries without redesigning the report

Your supervisor or director would like a printout of the summary data in all of the reports in your database for her end-of-fiscal year department report. You need to print out all 10 reports without the detail data, and you need to have it ready within the hour. Fortunately, you don't need to create new reports -- you can hide the detail section so the detailed data does not appear in the printout. Here's how...

1. In the Database window, click Reports under Objects.
2. Click the name of the report, and then click the Design button.
3. Right-click within a blank area of the Detail section.
4. Select Properties.
5. Under the Format tab, click in the Visible property box and select No.

When you print the reports, all sections but the detail sections will print. You can use the Visible property to hide any section of the report.