University of Nebraska Kearney

UNK
Random UNK images
Information Technology Services
related links
     

                                                        Archive of Tech Tips 

    Our goal is to have informative and educational advice and tips on technology located here in one spot for you.  Each week we send out a new tech tip.  Those tech tips are then consolidated here in our Tech Tip archive section. 

    We have conveniently divided the Tech Tips into different sections, by clicking on one of these links below, you will find informative articles related to that topic.

    We are always interested in your questions or your tech tips.  If you have a question, suggestion, or a tech tip to share, please contact us at training@unk.edu
    To be able to view the tutorials on our website, you will need to download the latest version of Adobe Reader and Quicktime.  Both applications are free for both the PC and MAC computer.   Download Adobe Acrobat   Download QuickTime 

    Breadcrumb:  Top > Microsoft Office (30)

    Category: ( What's This?) Click here to navigate one level up.

    Articles: ( What's This?)
    • Any Year Personal Calendar

      The Microsoft Office any year calendar can easily be personalized by replacing the photos with your favorite photos. It can be used year after year, as it contains a macro that enables you to change the year as well as the start of the week day from Sunday to Monday.
    • Create a hyperlink to a specific location in your Word document

      To link to a location in the same document, you must bookmark the hyperlink location and then add the link.
    • Remove skipped lines from your Word

      When authoring in Microsoft Word, the default template automatically skips a line between paragraphs - which is visually pleasing and does make it easier to read. But what if you're authoring in Word for another destination, such as a blog or social media site? When you cut and paste your text into your publishing tool, you may end up with a mess.

    • Change the scale of a chart axis value

      By default, Microsoft Excel determines the minimum and maximum values for the (y) axis in a chart. You can, however, customize the scale to better meet your needs.

    • 5-minutes Makeovers for Your Report With Office 2010

       From good to great in under 5 minutes, use Word 2010 programs to transform any reports and grab your audience's attention. 

    • How to insert a check box that can be checked electronically in Word

      To include a check box that can be checked electronically within your word document, you must first ensure that the Developer tab is displayed.  And then insert the check box.  For instructions click on this link.  

    • OneNote 2010

      Microsoft OneNote 2010 is a digital notebook that provides a single place where you can gather all of your notes and information, with the added benefits of powerful search capabilities to find what you are looking for quickly, plus easy-to-use shared notebooks so you can manage information overload and work together with others more effectively.

    • Do I use Access or Excel to manage my data?

      Microsoft Office Access and Microsoft Office Excel possess many similarities, which can make it difficult to decide which program you should use. For example, both programs can store large amounts of data, run powerful queries and analysis tools to slice and dice that data.

      However, each program has clear advantages — depending on the type of data that you are managing and what you want to do with that data. For example, if it is your goal to maintain data integrity in a format that can be accessed by multiple users, Access is your best choice, whereas Excel is better suited for complex numerical data analyzes.

    • Recover Earlier Versions of a File in Office 2010

      Microsoft Office 2010 can recover your file if you close your file without saving it or if you decide to return to an earlier version of the file you are working on. 

    • Use sparklines to show data trends

      New in Microsoft Excel 2010, a sparkline is a tiny chart in a worksheet cell that provides a visual representation of data. Use sparklines to show trends in a series of values, such as seasonal increases or decreases, economic cycles, or to highlight maximum and minimum values.

    • How to Customize the “Ribbon” in Office 2010

      Office 2010 allows the user to personalize their Ribbon! Users may create custom tabs and custom groups to contain their frequently used commands.

    • Remove Picture Background with PowerPoint 2010

       You can accent or highlight the subject of a picture by removing the background or distracting details.  PowerPoint 2010 allows you to do this with ease with its advanced picture editing option.

    • How to Password Protect Sensitive Microsoft Office Files

      Microsoft Office allows you to protect your files by adding a password to them.  When you password protect a document, no one can open the document unless they have the password.
      IMPORTANT:
      1. This technique does not have any recovery.  If you forget your password, you will lose your file.
      2. Do not include the password in the same email as the file you are sending.  If the email is intercepted the person intercepting it will have both the  document and the password, defeating the purpose of password protecting the document in the first place. 

       

    • Protecting your Excel Worksheet

      To prevent a user from accidentally or deliberately changing, moving, or deleting important data from an Excel worksheet or workbook, you may want to protect your data to prevent it from being changed. You can also specify a password that users must use to enter or modify information on the worksheet. Click here to learn how to protect your worksheet in Excel.

       

    • Convert PDF documents to Word FREE

      Have you ever needed to edit a PDF document?  If so you’ve probably come to the realization that it isn’t all that easy.  It also isn’t free.  Adobe Acrobat 9 Pro retails for $449 on Adobe’s website.  This program allows you to make simple edits, or export to Microsoft Word format for more extensive work.  That gets the job done, but it certainly isn’t free.  That’s why I’m going to show you a website that coverts those PDF files for free.  Oh, and did I mention it’s literally as easy as 123?

    • Why did the line spacing change in Word 2007?

      Why did the line spacing change in Word 2007?

    • Excel: Combine contents of multiple cells

      Have you ever wanted in Excel to combine a First Name cell with a Last Name cell?

    • Guides to the 2007 Office System

        Interactive Guides:  2003 to 2007 Command Reference Guide Have you started using Office 2007?  Have you struggled finding some of your favorite commands that you used in Office 2003 in the new Office 2007?   On the Microsoft website link below, you will find interactive guides to help you quickly learn where

    • Insert Text from File in Office 2007

         To insert text from another document into the document that you are working on in Word 2007 1.  Click where you want to insert the text into your document.   2.  On the Insert File, in the Text Group, click on the Insert Object icon    3.  Click  "Text from File"   4.  In the Insert File dialog

    • Single-space the lines in a document

      Single-space the lines in a document using Microsoft Office 2007 You may have noticed while working in the new Office 2007 that the default spacing looks like a double-space.  Actually, the default document spacing for any blank document is 1.15, with slightly more space between paragraphs. You can

    • Office 2007 Compatibility for Mac

          Office 2007 Compatibility for Mac - Microsoft Office 2008 and/or iWork08 and MacBook Care Guide Take good care of your computer and it will take care of you. Office 2008 for Mac will be released soon after January 2008.  PC users are excited about their transition from Office 2003 to Office 2007

    • Saving PDF Files

        Saving PDF Files on your PC or Mac Click  Saving Files as PDF's  for the podcast.  Note you will need QuickTime to view this podcast. If you want to download the ThinkTechnology Tips podcasts, go to http://www.unk.edu/itunes_U.  Go to the News and Events category and click on I.T. Services

    • Office 2007-The Ribbon

    • Office 2007-PowerPoint Notes for Presentation

        Office 2007 Tips - PowerPoint Presentation Notes Have you ever been frustrated when you go to print out your notes for your PowerPoint presentation and each slide with your notes takes an entire sheet of paper?  I sure have!  In PowerPoint 2007 you now have the option to send your PowerPoint

    • Office 2007 - File Compatibility

      Office 2007 Tips - File Compatibility Office 2007 is the latest release of Microsoft’s productivity suite for Windows including Word 2007, Excel 2007, PowerPoint 2007, and Outlook 2007. Exchanging files between previous releases of Microsoft Office and the 2007 Microsoft Office Release. Microsoft has added

    • Converting Office 2007 files to Office 2003

            Converting Office 2007 files to Office 2003 Office 2007 is the latest release of Microsoft’s productivity suite for Windows including Word 2007, Excel 2007, PowerPoint 2007, and Outlook 2007.      

    • Office 2007 - What's on the Ribbon?

          Office 2007 Tips - The Ribbon ClickEpisode 1, Fall 2007for the podcast.  Note you will need QuickTime to view this podcast. If you want to download the ThinkTechnology Tips podcasts, go tohttp://www.unk.edu/itunes_U.  Go to the News and Events category and click on I.T. Services TechTips. Office 2007 is

    • Save Options in Office 2007

          Office 2007 Tips Save Options in Office 2007 Q: I’ve upgraded to Office 2007. How can I ensure that others will be able open the files I create? A: You can manually change your default Save options to always save to the older file formats. To do so, follow these steps: Open Word, Excel, or PowerPoint

    • Office 2007 file extensions

        Office 2007 Tips Office 2007 is the latest release of Microsoft’s productivity suite for Windows including Word 2007, Excel 2007, PowerPoint 2007, and Outlook 2007. A major change in the Office Suite is the format in which files are saved. Earlier versions of Office applications save documents with the

    • Optimize your Pictures in PowerPoint

        Save room on your hard disk and reduce download time by using Compress Pictures, a feature on the Picture toolbar in PowerPoint. The Picture toolbar gives you options for reducing image resolution; applying compression with no loss to quality; and discarding unwanted information, such as the cropped parts of an