Question: I am having problems with a file I printed to PDF. When I open it in Adobe Reader the font changes and is not readable. This has always worked before until I got a new computer with Windows 7.
Answer: I opened the file and the same thing happened for me, both in Adobe Reader and Adobe Acrobat. But I have Word 2013 and opened it and the fonts were readable. So in order to better troubleshoot the problem, I had to get more information about where the file was originally and how it was converted to PDF. Turns out it was from a database she accessed from the web and she printed it to a PDF. She explained she had problems in the past when using Firefox, but it would always work with Internet Explorer. So that was a clue that it might be a browser issue.
I have found Google Chrome a wonderful browser. It seems to correct odd problems like this, so she was quickly able to download and install Chrome, logged into her database and printed to a PDF …..successfully! Thank you again, Chrome!!
Question: Why is my Excel file so slow when opening?
Answer: I hear this problem occasionally and the typical problem is that there are many extra columns or rows included in the data range. Sometimes this is caused by typing something (even pressing the spacebar) in a cell far away from the data or from formatting cells outside the data range. The easiest way to tell is by pressing Ctrl End, which will take you to the last cell of the range. If this is the case, you can try several things
- Delete the extra rows and columns outside the range of data
- Clear any formatting outside the range of data
- Copy the range of data for each worksheet to a new file
Save the file with a different name (File > Save as) and close the file before reopening. You will see the size of the file has reduced considerably and will be much faster in opening.
Question: I am trying to create a report from Excel data that was exported from a web application that has date fields and values in which I can get an average of values for the various days of the week. How can I do that?
Answer: If your data contains a date field, you can display the day of the week using one of the date formatting styles, but a pivot table does not allow you to group by days of the week. However, you can create a new column for your your data which creates a text field from the date field - i.e. =text(A2, “dddd”). Then copy that formula down the column (shortcut to copy is double clicking on the dragging handle) and be sure to add a column heading. Then save your file before creating a pivot table. You can now add that field in the pivot table and you can change value field settings (in the values section) from sum to average.
Learn more about pivot tables and other time-saving Excel features by attending Kim’s Favorite Excel Tips session on 3/6/14 at 9 -10 a.m. in 2020 Bennett Hall. No registration is required.
Question: My PC stopped updating my iPad. Do you know if there is a setting I should check to correct this?
Answer: I don’t have an iPad, but before I had a chance to research the issue, he responded back and said he simply rebooted (shut off and on) his iPad and it corrected the syncing issue. I know I have had to shut down my iPhone occasionally if it didn’t seem to be acting correctly. When in doubt, shut it down and restart. Works a lot with computer desktops too!
Question: I am trying to convert a couple of ppt presentations over to a new assigned template for a national meeting. I can’t seem to figure out how to do this simply. I tried using the re-use slide options and also saving the template as a theme, but the slides don’t seem to convert.
Answer: How you were describing it should work, but the problem was you were on the title page when you saved the template as a theme, and for some odd reason the title page did not convert properly. When you tried saving the theme from a bullet text slide, the design saved properly. However, I think the easiest way to accomplish this is to open the template sample, and then use the Reuse Slide option from Home tab > New Slide. Then browse for your presentation and right click on one slide and select All Slides. All slides should be inserted into the template, taking on the template’s design. You may have to delete slides from the template you are not using and you may have to tweak the layout on the slides. We found on your presentation the title page needed to be applied separately because the original presentation may have had manual changes.
Question: Is there a way to print two different calendars on one sheet of paper?
Answer: Using Outlook’s printing options, you can only print one calendar at once. However, you can use the Snipping tool (available in Windows Vista, Windows 7 or later) if you have both calendars on your screen side by side, then from the Start menu of your computer, type “snip” to search for the Snipping program. It will allow you to drag across the part of the screen you desire, and paste into an email message, Word document or other applications. Then you can print out the calendars.
Another add-in tool you can download from Microsoft is the “Calendar Printing Assistant.” This program has a few more options for printing, including printing more than one calendar at once. You can download it from here.
Question: I need help with my Word Form. I was trying to use the tools on the developer tab but am having difficulty getting them to work.
Answer: Using Forms in Word can be tricky but very useful. I suggest using the Legacy Form tools, which are found on the Developer tab of the ribbon. Then to see the form work, you need to protect the document for “fill-in forms” I will be giving a hands-on Word Forms class on Thursday, Febr. 20 from 10-11:30 a.m. in our training room, 8011 WH. Register at www.unmc.edu/its/training.htm . There is more information about creating Word forms here.