Kish Guides: Tutoring Services: Microsoft Office Resources

Microsoft OneDrive Resources

Microsoft OneDrive for work or school
If you ever wondered what OneDrive is, this Microsoft Support page is for you. It goes over the OneDrive application and explains what it is, how it is used to store files, how it can sync to your computer, and goes over the differences between the work or school version and the home version.
Use OneDrive on Android
If you have an Android device and want to access your Kish files from your phone, visit this Microsoft Support page to learn more about the Android app.
Use OneDrive on iOS
If you have an iOS device and want to access your Kish files from your phone, visit this Microsoft Support page to learn more about the iOS app.

Upload files to OneDrive
This page shows you how to upload files to OneDrive on their web browser or desktop app.

Create files in OneDrive
This video from Microsoft will explain how to create files and folders in OneDrive.

Share OneDrive files and folders
This Microsoft Support page goes over how to share files and folders on OneDrive. It also explains the levels of access and editing settings you can set when you share your files.
Share Files in OneDrive for Android
If you have the OneDrive for Android app, this page will show you how to share files from your mobile device.
Share Files in OneDrive for iOS
If you have an iOS device, this page will show you how to use the OneDrive app to share files.

Levels of Access on OneDrive

Anyone

This is the default option and it gives access to anyone with the link, including those outside of Kish.

People in Kishwaukee College

If you choose this option, only accounts with @kish.edu email addresses can access the file.

People with Existing Access

This is used when you want to share the link with someone who already has access to the file.

People you Choose

Only specific people who choose to share the file with can access it. You can only share with people in the Kish network or those who have a Microsoft account.

Editing Options on OneDrive

Can Edit

Anyone with the link can make changes to the file if you choose this option. This is best when you are collaborating with others.

Can Review

Anyone with the link can suggest changes, but will not make any changes directly on the document.

Can View

Anyone with the link can view the file, but they cannot make or suggest any changes to it.

Microsoft Word Resources

Microsoft Word
In this video from Microsoft, they go over the uses of Word and some of the commonly used tools.
Creating a Document in Word
This video goes over how to create a new document in Microsoft Word.
Immersive Reader in Word
Immersive Reader allows you to adjust how you view a document to make it more comfortable and easier for you to read. This page shows you how to access this feature on a desktop, Mac, web browser, and an ipad.
Listen to Word Documents
This Microsoft page goes over different tools that can be used to listen to your Word documents. It also explains how to access these features on desktop, Mac, web browser, and iOS versions of Word.

Add and Edit Text in Word
This video created by Microsoft goes over how to add or change text in a Word document. It also shows you how to edit the format of the text in the document.
Find and Replace Text in Word
This video from Microsoft is helpful for when you need to find specific text and replace it with new text or formatting. This page shows you how to access this feature on Windows, Mac, and web browser versions of Word.

Line Spacing
Review the materials on this page to learn how to change the line spacing in Microsoft Word
Inserting Pictures
This Microsoft page will show you how to insert pictures into your document as well as edit the size and placement of the picture.
Wrapping Text Around Images
Watch this video to learn how to wrap text around an image in your Word document.
Inserting Tables.
Watch the video to learn 3 different ways to insert a table in a Word document and how to format a table.
Inserting Footnotes
If you need to add footnotes or endnotes to your document, watch this video that shows you how.
Writing Equations or Formulas
If you are in a course, and you need to write equations or formulas in a Word document, view this video from Microsoft to learn how.

Sharing a Document
When you need to share a document with someone, follow the steps provided on this Microsoft support page. You can also find more information about sharing files in the OneDrive Resources section of this page.
Collaborating in a Document
Watch this video to learn about collaborating in Microsoft Word documents.
Commenting in a Document
If you ever want to leave yourself, or someone else, a comment on a Word document, review the information on this page. It will explain how to comment in the browser-version, Mac-version, and desktop-version of Microsoft Word.
Tracking Changes in a Document
To learn how to suggest edits to a document without making any changes, review the materials on this page about how to track changes.

Microsoft Excel Resources

Beginner's Guide to Excel
Learn the basics of using Microsoft Excel, including the anatomy of a spreadsheet, how to enter data, how to make your data look good so it's easier to read and use, and more. This tutorial was made using Excel 2016, but is applicable to older versions of Excel and newer versions too.

Intermediate Excel Skills, Tips, and Tricks
Learn many of the intermediate skills, tips, and tricks that you'll need in order to be able to use Excel effectively. In this intermediate video, you'll learn some advanced formatting tools such as conditional formatting, how to save time by using the Autofill Handle, the basics of formulas and functions, sorting and filtering, and a few random useful tips such as Freeze Panes.

Introduction to Pivot Tables, Charts, and Dashboards in Excel (Part 1)
In this video series you will learn how to create an interactive dashboard using Pivot Tables and Pivot Charts. Works with Excel 2003, 2007, 2010, 2013 for Windows & Excel 2011 for Mac. The videos cover the basics of formatting your source data and creating your first Pivot Table as well. You will also get to see an add-in named PivotPal that makes it easier to work with some aspects of Pivot Tables.
Introduction to Pivot Tables, Charts, and Dashboards in Excel (Part 2)
This is part 2 in the series on an introduction to pivot tables and dashboards. This video explains some of the different pivot table calculation types. Learn how to calculate the average, count, sum, and percentage of total, as well as how to update your pivot table with more data, and also how to refresh your pivot tables. This video contains a lot of Excel tips, like how to quickly make a duplicate copy of a sheet, how to select the visible cells only, and a lot of useful keyboard shortcuts, as well as how to filter your source data and build a pivot table from your source data sheet using the PivotPal add-in.

Excelisfun YouTube Channel
A YouTube channel with over 3,700 videos on Excel and Power BI from a business analytics professor at Highline College and author of Excel and Power BI books. The videos will help you with data analysis, financial calculations, and model building.