Log into Atomic Learning and under Excel 2010 click on Section G Workbook Views and Page Setup.

Select the worksheet(s) you want to print.

On the Page Layout tab, in the Sheet Options group, select the Print check box under Gridlines.

This prints the faint gridlines and not the bold table lines.

1) In Word, Do a Find->Replace to change all the line breaks to $$$$

• Find: ^p
• Replace with: $$$$
• Click ‘Replace All’

2) Select your table and copy it to Excel

3) In Excel, do a Find-Replace to change all the $$$$ back to line breaks

• Find: $$$$
• Replace with: (control-j)
• Click ‘Replace All’

Save your Excel chart as a .pdf file.  Then it will hold onto the printing when sent to the BizHub.

Applies To: Students

Word 2007 and Word 2010

1. Start Word, and then open a new blank document.
2. Go to Word Options
   • In Word 2007, click the Office Button, and then click Word Options.
   • In Word 2010, click File, and then click Options.
3. On the Advanced tab, go to the General section.
4. Click to select the Confirm file format conversion on open check box, and then click OK.
5. On the Mailings tab, click Start Mail Merge, and then select Step By Step Mail Merge Wizard.
6. In the Mail Merge task pane, select the type of document that you want to work on, and then click Next.
7. Under Select starting document, select the starting document that you want to use, and then click Next.
8. Under Select recipients, click Use an existing list, and then click Browse.
9. In the Select Data Source dialog box, locate the folder that contains the Excel workbook that you want to use as your data source, select the workbook, and then click Open.
10. In the Confirm Data Source dialog box, click to select the Show all check box. Click MS Excel Worksheets via DDE (*.xls), and then click OK.
11. In the Microsoft Excel dialog box, under Named or cell range, select the cell range or worksheet that contains the data that you want to use, and then click OK.
    NOTE: Your data now appears in the Mail Merge Recipients dialog box with the same formatting that appears in the Excel worksheet.

Atomic Learning is the licensed provider for online tutorials at W&L. Tutorial topics include: Excel 2010 and 2011, Word 2010 and 2011, Windows 8, iMovie, SharePoint 2010, the Adobe Creative Suite including InDesign, Acrobat and Photoshop and many more.

Go to http://go.wlu.edu/LEARN and sign in with your network username and password to access all tutorials.

This resource is open to all current students, staff and faculty.

Applies To: Faculty, Staff, Students

Log into Atomic Learning and under PowerPoint 2010 Advanced click on Section E Adding Audio.

On the Blackberry, when in Messages:

1.       Click on the Options button (to the left of the ball).

2.       Choose Options from the menu.

3.       Choose Email Reconciliation

4.       Settings should read: 

a.       Delete On:  Prompt (or Mailbox)

b.      Wireless  Reconcile: On

c.       On Conflicts: Mailbox Wins

·         More Web browsers supported (listed below)

·         Conversation view: Conversation view lets you see all messages in a thread, including messages not in the current folder

·         Right-click: More actions have been added to the right-click menus in OWA

·         Messages: Forward an E-mail as an attachment

·         Favorites: Favorites makes it easier to access the folders you use the most

·         For a more complete listing, see the Microsoft article here: OWA 2010 New Features

Delete After Send. By default, your faxes will not be automatically deleted from the Main fax list regardless of their status. However, you can specify to Always delete a fax or to delete it On Success only.

Note: When you type the first letter of a name in the To, CC, and BCC boxes, AutoComplete begins to suggest possible matches based on the names of whom you have sent an item to before.

To share an E-mail folder, in the Navigation Pane, click Mail.

· Right-click Mailbox - your name, and then click on Properties.

· On the Permissions Tab, click Add.

· Select the person that you want to give permissions to, and then click Add.

· Select the person's name in the list, and then for Permission Level, select Reviewer.

· Click OK.

· Right-click the folder you want to give the other person permissions to view, and then click  Sharing.

· Click Add.

· Select the other person you want to give permissions to, and then under Add Users, click Add

· Select the person's name in the list, and then for Permission Level, select Reviewer.

Note If you want the person to be able to change items, select Editor.

To share a folder that is not directly beneath Mailbox - user name, like the Inbox, Contacts, Calendar, Notes, or Journal folders, you must do the following on each folder that is higher in the folder tree.

· Right-click the folder, and then click Sharing.

· Click Add.

· Select the other user you want to give permissions to, and then under Add Users, click Add.

· Select the user's name in the list, and then for Permission Level, select None.

· The top folder, Mailbox - Your Name, must be shared to share any folder beneath it.

· The Inbox folder must be shared to share any of the folders beneath it, such as the Prospective clients folder. You can set the Inbox folder permissions to None to prevent others from viewing the contents.

· The Prospective clients folder should have at least Reviewer permissions for other people to view the contents.

To Move Ahead or Back in Your Message:

To skip forward to the next message introduction press * 2

To skip back to the previous message introduction press * 7 2

To replay the entire message press * 7 3

To replay the previous eight seconds of the message press * 7 8

To move ahead eight seconds into the message press * 9 8

Applies To: Faculty, Staff, Students

1.Find the folder you want to move (in the Resources area of the course)

2.      From the Actions menu choose Move.

3.      Click on the “Show other sites” link in the bottom gray bar.

4.      Choose “Paste moved items” from the Action dropdown menu next to the folder where you’d to move the items.

5.      You can also click on the plus sign next to a folder to drill down into that folder and choose a folder within that folder.

Applies To: Faculty, Students

• Press 1 to record and send an answer to the message sender OR
• Press 70 to call the person who sent you the message OR
• Press 9 to forward the message to another extension OR
• Press # to continue to the next message

Applies To: Faculty, Staff

For this example, I'll go from a Windows machine to Apple, but the process should work in reverse, as well.

If you want to make this easy, you'll need to move all your music into the iTunes folder. There's an easy way to do this: In iTunes go the Advanced menu and choose Consolidate library.

Any music not already in the iTunes folder will not be deleted. You'll just have two copies. One inside the iTunes folder and one outside.

Now quit iTunes and go to My Documents, then My Music, and you should see the iTunes folder. Now you need a place to put that folder. It could be an external drive, a network drive, USB or the fasts is to use a jump drive. Whatever you use just needs to be big enough to hold all your data. Right click on the folder and choose Properties to find out how big it is.

Drag the iTunes folder and copy it to wherever you're temporarily storing it.

Then connect the storage device to the new computer. In this case a Mac.

                1. Install and launch iTunes. If iTunes asks to find your music say "no."

                2. Quit iTunes.

                3. Go to your Music folder.

                4. Move the existing iTunes folder to the trash.

                5. Copy the old iTunes folder off your storage device and put it where the old folder was.

                6. Open iTunes again.

                You should see your familiar library with ratings, play counts, etc.

Atomic Learning is the licensed provider for online tutorials at W&L. Tutorial topics include: Outlook 2010, Excel 2010 and 2011, Word 2010 and 2011, Windows 8, iMovie, SharePoint 2010, the Adobe Creative Suite including InDesign, Acrobat and Photoshop and many more.

Go to http://go.wlu.edu/LEARN and sign in with your network username and password to access all tutorials.

This resource is open to all current students, staff and faculty.

Applies To: Faculty, Staff, Students

Atomic Learning is the licensed provider for online tutorials at W&L. Tutorial topics include: SharePoint 2010, Excel 2010 and 2011, Word 2010 and 2011, Windows 8, iMovie, the Adobe Creative Suite including InDesign, Acrobat and Photoshop and many more.

Go to http://go.wlu.edu/LEARN and sign in with your network username and password to access all tutorials.

This resource is open to all current students, staff and faculty.

Applies To: Faculty, Staff, Students

Your view of the Reports Home page depends on the level of access that has been provided to you.

You may see:

• Report Filters
• Datasources (DatatelProduction)
• Tags
• Reports (All those you have created or those that have been shared with you)

Applies To: Faculty, Staff

1. Begin typing the name you wish to remove from the AutoComplete list.

2. Select the unwanted name by using the UP ARROW or DOWN ARROW key.

3. Press DELETE.

Note: When you type the first letter of a name in the To, CC, and BCC boxes, AutoComplete begins to suggest possible matches based on names of whom you have sent an item to before.

Log into Atomic Learning and under PowerPoint 2010 Advanced click on Section G Animation Effects and Transitions.

• From the File tab, under Info, select Cleanup Tools, then Mailbox Cleanup...
• Click the View Mailbox Size... button.
• Select the Server Data tab of the Folder Size window

• Since 1,000,000 KB = 1 GB, for example if it is displaying 683,462 KB that converts to .68 GB.
  
  Note:
  
  Be sure to look at the Server tab, not the Local tab. The size of your folders listed on Local do not count towards your email storage quota, since these files are being stored on your 'local' hard drive.

If you did in error it should be in your trash and then you just drag and drop it back into contacts.

If some time has passed follow these steps from Microsoft

1. With Outlook 2010 open click the File Ribbon tab then click the Options button. 
2. Click Customize Ribbon
3. On the right-hand side add a New Group under the Folder main tab. You can rename it after it is created.
4. Change the “Choose commands from:” to All Commands. Scroll down and select the “Recover Deleted Items…” option then click the “Add > >” button to add this option to your newly created custom group OK.
5. You will now see your new group and the Recover Deleted Items icon in the Folder tab on all folders.
6. If you were to click the button you will see that you have access to any purged/shift-deleted items from that folder.
7. If you use the recover option you will see that your item has now been returned.

In the Sakai site:

1. Go to Gradebook

2. All grades (it's in the light gray bar near the top of the screen)

3. Export Gradebook (a button to the right of the screen)

Applies To: Faculty

Menu options that are grayed out are not available, and there are many possible reasons why. Items in the list might not be selected, the browser you are using might mean that option is not available (Internet Explorer from a PC is the browser that will provide you the most functionality), you might not have permissions in the site, or the site administrator may have disallowed various options.

Applies To: Faculty, Staff

(For a more complete listing, please visit this site: http://support.microsoft.com/kb/2572191)

In Internet Explorer:

1. Go to File, then Print Preview

2. The fifth icon from the left is "Turn off Headers and Footers" Click it.

3. Print.  The headers and footers should be gone.

In Firefox:

1. To to File, then Print Preview

2. Click Page Setup.

3. Click the Margins and Headers/Footers tab.

4. Use the drop down menu to choose how you want the headers or footers to appear, if you want to remove them use the -blank- option.

5. Close and Print.

1. In Outlook, click on File > Options > Mail.
2. Click on Signatures.
3. Click the New button.
4. Type a name for your signature and click on OK.
5. In Choose Default Signature:
6. Select e-mail signature.
7. Select if you want your signature added to New messages.
8. Select if you want your signature added to Replies/Forwards.
9. In Edit Signature, you have serveral options:  Type your signature, insert a picture, insert your business card, or add an hyperlink.
10. Click on OK to return to your Mail.

Applies To: Faculty, Staff

1. Open the distribution list (double-click on the list.)

2. Click on Forward Group.

3. Choose As an Outlook Contact.

4. Send the email to the recipient.

For the recipient:

1. Open the email.

2. Click on the email attachment and drag it to the Contacts button on the left side of the Outlook window. Now when you look at your contacts, you should see the distribution list.

Applies To: Faculty, Staff

Apple has great tutorials on their site.  Please click here to find out more about iWeb.

1.     If that is the folder you want, you can move it or copy it to the new location by going to the Resources section, check the checkbox next to the folder name, and choose Copy or Move from the Actions menu.

2.     After you’ve clicked on Copy or Move, you need to select the “Show Other Sites” link at the bottom of the screen.

3.     Browse to the site where you’d like to copy or move your folder.  Click the checkbox next to the folder where you want the links folder to go (Probably the top level Resources folder) and select Paste Copied Items from the Actions Menu.

See the screen shots in the Resources Document

Applies To: Faculty, Staff

First select the entire document by clicking Control A.

Then click Control/Shift/F9 and it will remove all links.

Save the document.

Go to http://www.microsoft.com/en-us/download/details.aspx?id=18275 and download the appropriate plug in for your PC or contact the ITS Information Desk at extension 4357 and ask for someone to help you install it.

Applies To: Faculty, Staff

http://office2010.microsoft.com/en-us/sharepoint-server-help/take-sharepoint-server-2010-training-at-your-desk-HA101859255.aspx

Microsoft offers several free online tutorials for SharePoint 2010.

https://www.atomiclearning.com/login/wlu

By searching for Sharepoint, after logging into the Atomic Learning site, you can access tutorials broken down by topic.

Applies To: Faculty, Staff

If Check-Out and Check-In are enforced on a document library, the "Edit in Browser" feature will not be available. You'll have to open the file in Word, or Excel, depending on the type of file, in order to edit it.

Applies To: Faculty, Staff

Office 2010 applications
    Click the File tab, and then click Option.
    Click Add-Ins on the left side of the dialog box.
    Do one of the following:
        If PDFMOutlook or Acrobat PDFMaker Office COM Add-in is not listed, choose COM Add-Ins from the Manage pop-up menu and click Go.
        If PDFMOutlook or Acrobat PDFMaker Office COM Add-in is listed under Disabled Application Add-ins, select Disabled Items from the Manage pop-up menu and click Go.

    Select PDFMOutlook or Acrobat PDFMaker Office COM Add-in and click OK.
    Restart the Office application.

If your computer crashes or the Office 2010 application you are using fails click on "File" > "Options" > " Save" and look for the "Auto Recovery file location". Copy that location and paste in into your Run window (Start > Run in XP Start > Search files and folders in Windows 7).  You can also browse to this location.

If you do not find your document use Search to search for any file that was created during the timeframe you worked on your document. While you work on a document temporary files are created and by opening these files ( .tmp files) with word or wordpad you may find your document.  

Please follow the detailed and illustrated instructions in the Related Resources.

Applies To: Faculty, Staff

The arrow next to the blue question mark in the top right should be pointing up. 

If it is pointing down you click it to change the direction and view.

Applies To: Faculty, Staff

• Click on the name of the document library.
• In the ribbon at the top of the page, choose "Library" under "Library Tools"
• Select Library Settings (right side of ribbon)
• Select "Versioning Settings"
• Scroll to the bottom of the page. Under "Require Check Out", select "No"
• Click "OK"

Applies To: Faculty, Staff

To make a personal contacts folder into an address book that is visible when viewing address books, complete the steps below:

1. In the Navigation Pane, click Contacts.
2. Under My Contacts, right-click the Contacts folder you want to view in the address book, and then click Properties on the shortcut menu.
3. Click the Outlook Address Book tab, and make sure that the Show this folder as an e-mail address book check box is selected. If the check box is unavailable, you need to add the Outlook Address Book to your profile (see instructions below).
4. Click OK.

Now when you open a new message, click the To button, and open the dropdown list of address books, this address book will be listed.

Create a distribution list by copying names from an Excel chart or received e-mail message.   
  
1.If using Excel copy the column.
2.In the message that you want to copy the names from, select the names in the To or Cc box. 
3.Right-click your selection, and then click Copy on the shortcut menu.
4.In Contacts on the Home ribbon New - Click New Contact Group and Name it.
5.On the Contact Group ribbon Members - Click Add Members and select from Outlook Contacts.
6.At the bottom of the Select Members dialog box, in the Members box, right-click and then click Paste on the shortcut menu. 

Note   A member does not need to be in your Address Book in order to be added to the distribution list. The member's name and e-mail address will be included when you copy and paste from the original e-mail message.

7.Click OK.
8.Click Save & Close.

In Outlook 2007,  Click File > Options: Other (tab) and check the little box that indicates it will delete messages on Exit.

In Outlook 2010/2013, Click File > Options > Advanced and under "Outlook Start & Exit" check "Empty Deleted Items Folder When Exiting Outlook".

Applies To: Staff

Open Word 2010, click on Mailings tab on the Ribbon:

1.Click on Envelopes
2.Click on Options
3.Under Delivery Address, click on Font
4.Choose desired Font, i.e. Calibri, Regular, Size 12
5.Click on Set As Default and select Yes (Do you want to change the default envelope address font to Calibri, 12pt?)

Then, click on Font under Return Address
Repeat steps 3 to 5.
click on OK, then click on Close.
Save the document.

If the default goes back to +Headings.
Show hidden files then edit the Normal.dot template in
Documents and Settings\user\Application Data\Microsoft\Templates\normal.dot and save. 



 

You can move or copy multiple files all at once:

1.      Go to the Resources area of the course with the files that you want to move or copy.

2.      To the left of each folder and file is a checkbox. Check the checkbox for every file you want to move.

3.      Look at the top of the list, just above the top gray bar. You should see 3 links: Copy, Remove and Move.

4.      Click on the Move or Copy link.

5.      Click on the Show Other Sites link.

6.      Select the appropriate folder from the list.

Applies To: Faculty, Students

Applies To: Faculty, Staff

Fix: 

     • When in the Contact Folder open the distribution list so that you can see the members.
     • Click on Update Now in the tool bar
     • Click Save & Close

To check that all members will be sent to, create a new message and place the distribution list in the To field, then expand the distribution list and check that all names are listed.

With PowerPoint 2010, when you have the QuickTime player installed on your computer, you can insert an Apple QuickTime movie (.mov, .mp4) file.

The PowerPoint 2010 64-bit version is not compatible with 32-bit versions of QuickTime or Flash. You must install a 64-bit version of QuickTime or Flash, or a 32-bit version of PowerPoint 2010.

To embed or link to a QuickTime video from your PowerPoint presentation, see Embed a video in your presentation.

Applies To: Faculty, Staff

Go to Box.com and create a personal account using a personal email address, such as a gmail or yahoo account. in your W&L Box.com account, add that account as a collaborator on the files you'd like to move. Log into the personal account and download the files that you need to that account.

Applies To: Faculty, Staff