Tuesday, September 30, 2014

Word: Tracking comments and changes

Need input from others about the content of a document?  Email the Word document to them as an attachment.  When they open it in Word, each person can use the tools on the Review tab to add comments and edit the text without changing the original document. 


Need more details?  Pick and choose the topic below that fits your needs.  All videos are less than three minutes long.

Thursday, September 25, 2014

Rolling out Office 2013 to office computers

Early in October, The IT Support Center will be upgrading all staff computers to Office 2013.

"The first thing you’ll see when you open Microsoft Office is a clean, new look. But the features you know and use are still there—along with some new ones that are huge time savers." (from microsoft.com) 

Check out the short videos: Office 2013 - What's New? Training
Or, stop by Aquinas 7 for a quick demo anytime between the Walk-in hours below.

Thursday        10/9     9:00 - noon
Friday            10/10   9:00 – noon; 1:00 - 3:00
Monday         10/13   noon – 3:00
Tuesday         10/14   9:00 – noon; 1:00 – 3:00
Wednesday   10/15   noon – 3:00
Thursday        10/16   9:00 – noon; 1:00 – 3:00
Friday            10/17   9:00 – noon; 1:00 – 3:00

Friday, September 19, 2014

Excel: Combining columns

Do you have first and last names in separate cells:

But you really want it in one cell like this:

Use the "Concatenate" function.  "Concatenate" means "to link together".
  1. Insert a new column (in my example I inserted a new column to the right of column B)
  2. Put your cursor in the first cell of the new column where you want the full name to go (in my example, it is C1)
  3. Type in the "concatenate" formula based on which cell the first and last names are located.  (In my example it is   =A1&" "&B1  because the first name is in A1 and the last name is in B1)
          Concatenate formula explained:
    •   =       every formula starts with an equal sign
    •   A1     you use the cell that contains the first name
    •   &      this is the concatenate symbol 
    •   " "    indicates a space (or you can put a comma or word between the quotes:  ","   "and")
    •   &      this is the concatenate symbol
    •   B1    you use the cell that contains the last name
Feel free to contact me if you have questions.  Johnna.Touma@msmc.edu

Excel: Printing on one page

Trying to print your spreadsheet on one page?  Already played around with "landscape" mode and resetting the margins and it still does not fit?  Try this: