Help me!!! I have to find stuff online and I either find WAY too much, or the WRONG stuff or not enough. Ugh.

• How to search properly and efficiently > Google
• How to search using Google written by someone not from Google > Google Guide
• How to search using Google (an online book) published by Google Chrome > 20 Things I learned about Browsers and the Web
• What is a Browser? (by Google) > What is a Browser?

 

Subscribe to the newsletter of OfficeUsers.org

Check out our BLOG.

Excel Linking:

• Linking data from worksheet to worksheet >>>Download PDF Here

Inserting Excel File into Word:

In Word, click on the document where you want to insert the worksheet. Go to the Insert menu and select Object. Choose Create from File and click the Browse button. Navigate to the workbook with the worksheet you want to insert. Click on the file, click Insert and click OK.

In Word 2007 or 2010, click on the document where you want to insert the worksheet. Go to the Insert tab and click Object in the Text group. Go to the Create from File tab and click the Browse button. Navigate to the workbook with the worksheet you want to insert. Click on the file, click Insert and click OK.

You may notice when you are inserting the worksheet that you have a couple of options. Selecting Link to File inserts the contents of the worksheet into your document and creates a hyperlinked shortcut to the worksheet. If you make changes to the worksheet, they will be reflected in the document as well, as long as you still have access to the worksheet.

If you choose Display as Icon, Word inserts a nice little icon instead of the entire worksheet. Simply click on it to open the worksheet.

You can insert worksheets into other Office files, such as a PowerPoint slide or Publisher publication, in the same manner.(taken from officeusers.org

Remember, if you plan to move the file to another location, like another computer, all files must be moved including the linked Excel file. The best thing you can do is to create a folder and store all related files in the same folder, then move this folder.

How to Use the Excel TREND function:

Using the Trend function to create a best fit line BETWEEN 2 sets of known data >>>Download Excel File Here

 Online Videos:

Go to YouTube and the ITSTraining channel now

 Charting References from Outside Sources:

Topic	Reference
Difference between Scatter and Line Charts	MS Office Online
Data Analysis & Graphs Checklist	Data Analysis
Creating Charts That Show Trends	Using a Scatter Plot to Show Trends
Scatter Plots	Stats Canada
Scatter Plots and LIne of Best Fit	Scatter Plots - Flash based
Scatter Plots Graphs	From About.com
Using Colour in Charting	Practical Rules for Using Color in Charts

Find out how to save the PowerPoint as the proper sized PDF to send to the professional printer. Download step-by-step instructions here.

Learn how to create a research poster using PowerPoint (video)

Word Thesis Preparation

Are you struggling to prepare a thesis containing page numbers on landscape and portrait pages in the same document? Here are some references that may help.

Word XP: Landscape Page Numbers in Portrait Position

How to put a portrait page number on a landscape page

---

 

HINTS: Working with a thesis that is almost complete, yet contains problem pages...

Problem 1: Table extending over sev eral pages, must be in landscape view with page numbering on portrait view.

Solution 1:

1. Split the table into logical sections
2. Select EACH section, one at a time, and cut.
3. Create and click in a blank portrait page in the desired document
4. Select Edit | paste special as a PDF. This can be rotated and resized without losing quality.
5. Page numbers will continue onto these pages as with previous. Insert page numbers as you normally would.

---

Problem 2: Same page number on several pages in the document.

Solution 2: Working backword from last page of repeating numbering, ensure that the selection "Same as Previous" on the footer edit screen is NOT selected. This will have to be done on each page where the page numbering was repeated.

---

Problem 3: Landscape pages in a portrait document must contain portrait page numbering.

Solution 3:

1. On the landscape pages, turn off page numbering.
2. Insert a textbox onto the side of the page where numbering should appear.
3. Move this text box into the correct position as necessary.
4. Change text direction.
5. Insert a page number into that text box (it should pick up the correct numbering from the previous page).
6. Ensure that Same asPrevious for footer is turned off or NOT selected.

---

Word Problem - A document contains text which will not remain with the other text on the page, and automatically starts a new page.

Solution1 - The reason text in the middle of a document suddenly breaks to a new page could be the result of a style which has been applied and requires a new page to start the style.

Steps to fix (easiest if you have the show non-printing characters turned on... ¶ ):

1. Select all text where the style has been applied (you will see black dots resembling bullets in the left margin indicating a style has been applied)
2. Under styles, choose Clear Formatting .
3. The page separation should disappear and the previously styled text should now appear on the same page as any other text.

 

---

 

---

 

---

 

Mac Office 2008 Specific References for Students:

Office 2008 for Macintosh: The Missing Manual - Google Books

Microsoft Office 2008 for Macintosh: Visual QuickStart Guide

Training Videos from Mactopia

Training Courses from Mactopia

Mac Office Help Desk

Office 2008 for the Mac Online Book

Video Jug hosts many informational videos on technology. This is an external website and we do NOT control the content, but you may find information here that you need, right now, like how to import video in iMovie, or how to buy the best computer for your needs.

http://www.qsrinternational.com/support_tutorials.aspx

• Getting Started with SAS
• Getting Started with SAS Enterprise Guide 4.2
• SAS Online Resources for Stats Education
• Free Online SAS Training

Course presentation. Download here

 

SPSS online tutorials:

http://www.spsstools.net/spss.htm

Our training materials (PowerPoint) download here

Information Technology Services - Student Computing Guide

Prepare

Your Responsibilities-This section outlines University policy on acceptable computer use, email policies and provides a link to the academic honesty website.
Your NSID - Your Network Services ID (NSID) username and password are your IT identity and key to U of S services and resources (e.g. computer labs, wireless network, e-mail account, etc.)
My IT Services (MITS) - MITS allows you to manage several aspects of your ITS-managed services. You can change your NSID password, set secret questions to reset your password if you forget it and manage various settings for your e-mail.
Anti-virus Software – Sophos - The U of S has negotiated a site license for Sophos anti-virus software. This software is available free of charge to you for as long as you are a student. You must have anti-virus software on your laptop in order to connect to the University network.
Training - Students have access to a variety of training options such as free online courses, instructor led courses, online tutorials and some fee for service courses.
Help - Help is available for your student computing needs at college IT desks, ITS Central Help Desk, Online Learning Library and online Support.

Connect

Buying a computer-Laptops4U provide competitive pricing and come configured with U of S wireless network and installed anti-virus software and Microsoft Office Software.
Computer LabsThere are numerous labs available on campus for students.  Find out where they are located and when they are available.
Library Laptop Loaning – Don’t own a laptop you can borrow one form the library for up to six hours.
Computers for students with disabilities- Adaptive technology equipment is available for students with visual impairments and learning disabilities.
Off –Campus AccessHigh-speed Internet service in Saskatoon at student pricing.
Wirelessconnect to e-mail, PAWS, shared folders, printers or the Web on your laptop or mobile device most places on Campus.
Public Access Kiosks- Use kiosks to quickly access PAWS, check your e-mail, or connect to any legitimate website. They are designed for convenience and short access.

Explore

Paws Campus Portal - PAWS (Personalized Access to Web Services) is your gateway to student services, records, and information customized to meet your needs.
Student E-mail – mail.usask.ca – All current students receive a mail.usask.ca e-mail account that can be accessed through Paws.
File Storage Service - Folder.usask.ca provides secure and backed-up file storage services to U of S students. You can access your files from home or on campus.
Printing - CPAS - Campus Print Administration Service (CPAS) account to print on a university printer.
Calendar - The PAWS Calendar is a web-based calendar provided free to U of S students. It enables you to access and manage your daily, weekly and monthly schedules and coordinate events with others at the U of S anywhere, anytime
Personal Webpage - All students receive space for individual webpages during their  academic career at the U of S.
Software Downloads - Software is available from a variety of locations for downloading. This software is free for registered students. Students also qualify for special discounted pricing on some commercial software through the Campus Computer store.
Computer & Printer Repair - ITS provides A+ Certified computer and printer repair work for U of S students, Instructors, researchers and employees as well as warranty repair on authorized manufactures to the general public

 Student Resources
      
The following colleges and departments have IT help information on their websites:

• Arts and Science
• Education
• Engineering
• Veterinary Medicine
• Department of Computer Science
• Edwards School of Business
• Students in colleges without a college IT help desk should contact the centralized ITS help desk closest to their area.
       
  Click on the link below to find out more information about each of the topics listed above.
  http://www.usask.ca/its/guides/student_guide/prepare/index.php
  

 

Information Technology Services
Information Technology Services (ITS) provides a variety of important services that are used daily by instructors, students, researchers and employees in all colleges, departments and administrative units. IT Support and IT4U are a part of ITS.
http://www.usask.ca/its/

IT4U
IT4U provides students with free computer training including workshops, drop-in sessions and online help for Mac or PC.
http://www.usask.ca/it4u/

Training Services
Training Services offers effective and up-to-date technology training solutions for the entire campus community. The instructor led courses include beginner to advanced courses in Microsoft Office Applications and Adobe Software Applications as well as courses on how to build a Wiki. Check out the link to see all of the upcoming classes offered.
http://training.usask.ca

IT Support
The ITS Help Desk provides both in-person and phone support for a variety of IT services including, but not limited to e-mail, Network Services ID (NSID), Wireless Network, PAWS,  Mailing Lists, Anti-virus software ,Printing and more.
http://www.usask.ca/its/guides/help_desk/  or email  help.desk@usask.ca

 ITS Online Library 
The Training Library (a channel in PAWS) uses lynda.com, a site that offers professionally produced Windows- and Macintosh-compatible QuickTime videos for those interested in self directed software training.
http://www.usask.ca/its/courses/whats_new/stutrainlib.html

iUSask
Got a new iPod Touch or iPhone? Try out the U of S iPod/iPhone App, a special tool that gives you access to class information, library catalogues, campus maps and more!
http://iusask.usask.ca/

Campus Computer Store
Hardware, software, phones and accessories the Campus Computer Store has it all.
http://ccs.usask.ca/

Library
A must have link for all students. It provides 24-hour access to all online library services including the Catalogue, databases, other library collections databases, student account information and more. This link can also be found as a tab in Paws.
http://library.usask.ca/

 University Learning Centre
The University Learning Centre offers students help in writing, mathematics and statistics, learning strategies, and support in selected introductory courses that are considered especially challenging. It is located on the 1st floor of the Murray Building.
http://www.usask.ca/ulc/

Study Skills Resources
Students often struggle to maintain their expected level of academic performance. To succeed at university, you need to become an independent learner by identifying important information, setting study goals, creating a study schedule, testing your knowledge and monitoring your progress. Information is available on our website to help with writing, reading, time management, exam writing and note taking skills.
http://students.usask.ca/askus/results.jsp

Assistive Technologies Program
The Assistive Technology Program (AT Program) is intended to provide students with disabilities access to a variety of enhanced technology needed to achieve academic success. Students registered with the DSS are able to receive services through the AT Program either on an ongoing, or on an as need basis.
http://students.usask.ca/disability/technology/

Drop In Sessions:
Time/Dates:    Tuesdays from 2:00-3:30pm
Location:        Assistive Technology Room, Room G19 Murray Library, Learning Commons
Students can come in during this time to get help and ask questions
about anything AT related.

Student Central
Provides information on every aspect of a student’s University experience. Consists of links for academic life, health and wellness, money matters, campus life, support and services and more.
http://students.usask.ca/studentcentral/

Student Union (USSU)
The Students’ Union represents student concerns to the University, city, provincial and federal governments.  All students are members and are entitled to the Student Union’s services. A few of those services include the health and dental plans, safewalk, student crew, U-Pass and the housing registry. Check out their link to see a complete list of links.
http://www.ussu.ca/

Student Employment and Career
This centre offers help in all areas necessary to prepare students for employment. Learn how to build a resume or CV, prepare for an interview, search and apply for jobs, internships or practical experience or just get career advice.
http://students.usask.ca/support/employment/

Student Enrolment Services Division (SESD)
(SESD) is an exciting new division at the University of Saskatchewan, combining the previous functions of the Office of the Registrar and Student Affairs & Services, SESD focuses on providing developmental and support services and programs to students and the University community. Go to this link for academic services, financial assistance and student support.
http://www.usask.ca/sesd/about/

Aboriginal Students' Centre (ASC)
The ASC supports Aboriginal students by providing programs and services designed to increase their retention and success rates at the U of S, using a holistic approach that promotes spiritual, physical, emotional and mental well being. The ASC can be a cultural meeting place, a helpful resource or just a place to share your university experience with other Aboriginal students.
http://students.usask.ca/aboriginal

Bookstore
It’s not just a source for books! You can get your stationary, art and lab supplies as well as clothing and gifts here. You can now buy your textbooks online. Use the Bookstore 101 link to learn how to find your books.
http://www.usask.ca/consumer_services/bookstore/

Used Textbook Buybacks
What do you do when you no longer need your textbooks? You sell then back for cash. It’s easier than consignment and you get your cash right away.  Check the dates for then next buyback.
http://www.usask.ca/consumer_services/bookstore/textbooks/buyback_search.php

Physical Activity Complex (PAC)
The PAC contains five classrooms, a lecture theatre and state-of-the-art laboratories, pool, rock climbing wall, racquetball and squash courts and of course a state-of-the-art gym. Check out this link to find out about all the programs offered.
http://kinesiology.usask.ca/academics/facility-information-about-the-pac/

Campus Recreation
Click on this link to find out about intramurals, Co-Rec leagues and events, book your courts or sign up for instructional courses like Kayaking or Belly dancing.
http://kinesiology.usask.ca/campus-recreation/

Campus Clubs
Are you interested in the arts or athletics? Perhaps you would like to join a language and linguistics club. Maybe you want to start your own study group on Campus – you can do this in Paws
http://students.usask.ca/campuslife/clubs/

Parking
Do you know where you can park for free during final exams? What about the parking lottery? Do you know where to pay for a ticket?
http://www.usask.ca/consumer_services/parking/

International and Exchange Student Office  (ISO)
The International Student Office (ISO) provides support to international students and their families through services, programs and activities. The ISO can help you improve your English, meet new people and help you with housing and banking matters. They can also advise you on work/study permits, health card issues and provide help for income taxes and/or GST claims.
http://www.students.usask.ca/international/during/iso/

Watch. Practice. Learn almost anything—for free. Over 2,100 educational videos. Lots of algebra, math and science videos.

Kahn University