One side printing from Excel (and many other programs)

It has been noted that printing documents one-sided is not working as you might expect it to and Microsoft Excel produces so really interesting results when the issue occurs.  The problem stems from the fact that the printers properties override the application (in this case Excel) properties.  Instead of using Excel’s properties to choose one-sided as shown here:

Use the printer’s properties by choosing it here

and then choose One-sided and OK in the dialogue that opens, shown here

Notice that when you return to Excel, the printer has changed the Excel print dialogue to say one-sided AND now it will actually print one-sided.

Share

Eppley Email Migration

On Tuesday, February 23rd, 2016, all Eppley faculty, staff and student Outlook email accounts are scheduled to be moved from the UNMC premises to a cloud hosted by Microsoft. The migration is scheduled to start at 1:00 am and complete by 4:00 am.  It should be complete when you come in to work on, February 23rd.  

On Your Desktop:
With the email move to cloud, you will no longer use https://owa.unmc.edu  to access email from off-campus. You will be able to access email by going to http://365.unmc.edu 

On Your Mobile Device:
You will need to delete your current profile (email setup) and set it up again with new information. The information and instructions on how to set up your UNMC Outlook Email on your mobile device can be found at à [Instruction for Mobile] [Video]. 

Off Campus Email access
With the email move to cloud, you will no longer use https://secure.unmc.edu/unmc  to access email from off-campus. There is no need for VPN.  You will be able to access email by going to http://365.unmc.edu  

With the move you will

1)      Receive 28 GB of email storage (an increase from the current 2 GB)
2)      Be able to add more than 2 mobile devices (up to 100 devices)
3)      Be able to access email from Office 365

More helpful information:

a.       http://365.unmc.edu
b.       http://www.unmc.edu/its/tutorials/email-office365.html
c.       http://www.unmc.edu/its/services/email/mobile-access.html
d.       https://www.youtube.com/watch?v=jx49JqVwTWU – Video
e.       http://www.unmc.edu/its/

We also have this printable PDF available with the basics if you would like one.  Thanks

Share

PowerPoint and Display Sizes

265176_f520

For some other considerations re screen choices you can visit RichterScale’s article here.

In order to make your slides fit the device you are presenting on and eliminate letterboxing issues like the ones shown here, you need to change the ratio of height to width on the slides to an appropriate value.  Changing this setting before putting a presentation together would save labor obviously but it isn’t always possible to know ahead of time where a presentation is going to be used.

Widescreen devices are typically 16:9 including most newer TV’s and projectors.  1080p (1920×1080) is a popular size and simple math tells us that it is a 6:9 format

1920 / 16 * 9 = 1080

Other devices, such as older projectors and televisions are still in the older 4:3 ratio.  Many 21″ monitors and most tube type televisions fall into this category.  1600×1200 is popular resolution

1600 / 4 * 3 = 1200

In PowerPoint, you should change your slides to be the proper ratio.  How to do this depends on the version.  In PowerPoint 2013, click the Design tab, slide sizeand over to the right, select Slide Size and you will see the ratio choices.  In older versions, this is found under File, Page Setup instead.   For more tips on using the latest Microsoft office apps, see the guides here.  Help with preparing slides for publication?  See the blog entry here.

Share

Office 365 on your personally owned Devices

Not all apps are available to run on all devices, but here are all the components of Office 365:

office 365 components

office 365 components

For a nice colorful PDF explaining the basics of Office 365 for iPhone and iPad , look here

For campus specific instructions for how to get Office 365 on your personally owned devices of all kinds, go here

Files that prevent Microsoft Office updates (and others) on the Mac

When an update to Microsoft Office isn’t completing because files are in use, you are asked to close those files.  Common examples are the Microsoft Database Daemon & SyncServicesAgent.

When this happens, you can find the running processes by going to your desktop and from the top bar choose Go, then the Utilities folder, then start Activity Monitor.

In the list of programs that are shown, find the file you were asked to close and double-click to open it. Screen Shot 2014-09-10 at 8.18.23 AM

Then Choose Quit in that window and then Force Quit in the next windows that opens to stop the processScreen Shot 2014-09-10 at 8.19.31 AM

 

 

 

Then return to your update and try again.

Share

Remove previous versions of Office

All versions of Office older than 2007 should be removed and replaced with a more up to date version of Office as soon as possible.  As previous versions of Office have reached their software End-of-Life, they are no longer updated and become an increasing security threat.

Links from Microsoft on removing the various version of Office

How to uninstall or remove Microsoft Office 2007

How to uninstall or remove Microsoft Office 2010 suites

How to uninstall or remove Microsoft Office 2003 suites

How to uninstall or remove Microsoft Office for Mac 2011

How to uninstall or remove Microsoft Office for Mac 2008

 

Share

Getting files ready for publication.

It’s a time honored ritual of pain and confusion…  Oops, no, that was eating in the cafeteria in grade school.  The topic at hand today is getting images ready for publication.  Most publishers have requirements for the images you submit for publication.  Many of these figures originate in PowerPoint (unfortunately) and that requires some manipulation to meet the publisher requirements.

To have explicit control of your output from PowerPoint, I recommend printing the slide to a PDF.  A PDF generally preserves the quality of your work and packages it nicely in a nearly universal format.

pdf tiff settings

Once, it’s in a PDF, you can use acrobat to turn it into a number of other formats.  I hear you saying, but PowerPoint already allows me to save it in a bunch of formats.  While that’s true, it doesn’t allow you to control all the variables that make the output acceptable for publication and acrobat does.  The default resolution when you make a TIF from in PowerPoint is 96 dpi for example.

In acrobat, you can choose File, Save As, Image, TIFF to make a TIFF file, but it doesn’t stop there.  Once you’ve made that choice, there is a button nearby that says Settings.  When you click on settings, you get choices similar to the ones shown on the left.  Notice that the bottom two choices are exactly what the publisher is requesting?  Generally, leave the rest of the options alone unless you know all about file compression and color space.  It’s almost impossible to change the color management and have it work anyway unless you know the details of the press being used and have the matching icc profile.  And that would only work if your monitor was color calibrated, etcetera, etcetera.  So set the bottom two items, choose OK and then Save on the next screen with the name of your choice.  Now you have an acceptable image file for publication.

 

Share

Pasting graphics into a new message – PDF seminar announcements

So…how do I get the seminar announcement into an email without it looking like garbage?  One note I need to make here is that there are some features of OWA that aren’t supported by all browsers.  Internet explorer works perfectly for every advanced function I’ve attempted and although it isn’t the browser I use for normal daily use, it is the one I can say for certain will work.

Open your seminar announcement PDF you made already and choose File, Save As,

Under save as Type, Choose PNG ( a good lossless format)

 

 

 

 

 

 

 

Pop open your new message in the OWA and then drag the PNG file you made right into the message body.  It will appear (HUGE), now click on it and you will have sizing options.  Medium is nice for a nice readable poster.  You can see the embedded results below.  It should work the same for you.

 

 

 

 

 

 

 

Share