Office 365: Project
Tutorial for Office 365 and it's applications. This tutorial will walk you through Excel Online. Office 365 contains access to multiple applications that can be useful to you. To learn more about other applications simply click one of the links below or watch the webinar at http://connect.extension.iastate.edu/p4p2z87qsp2/
Applications on Office 365:
- Excel Online
To login to Office 365 go to http://office365.iastate.edu. Login with your Net-ID and password. Once you do so you will have access to all of the applications discussed. Click the Menu Icon to the left of the title. Locate the Excel Icon.
Introduction
This is the Excel Home screen that allows you to either open a new template or open a recent document. For this example we will create from scratch. Select New Blank Workbook.
Once you click you will be directed to a New Book. Similar to previous Excel programs the interface looks very familiar. For this example we will touch briefly on some of the functions.
To add a Title click in the top bar on the word that says Book. Make sure to name all of your documents, type Introduction.
Functions
We will be creating a chart in order to learn basic functions such as Copying Cells. First type your title in Cell 1. After which create two more titles in consecutive order. Select both cells. Then to copy this order, click on the bottom right square and drag. Stop once you are satisfied with the number of cells.
Auto Sum
To continue type titles on the horizontal cells, and begin to see your chart taking place.
Add any numbers into the chart in order to learn how to use Auto Sum. This option allows for the addition of simple formulas without any memory on your part.
Simply select the cell of the total, and click Auto Sum. This then adds a formula which totals all of the row. Again you can Copy Formulas just as you copied cells. Select the cells and drag down.
Again you can Copy Formulas just as you copied cells. Select the cells and drag down.
Sort
To learn about the Sort function we create a random list of numbers in the same column. Once you are satisfied with the list, select the entire column by clicking the title of the column.
Next navigate back up to the Editing panel, and find the Sort function. Click this option.
When you select Sort, you will see that you have the option between Ascending or Descending order. Choose one. Your list has now been sorted.
Formulas
Formulas are also vital in Excel Online. Simple formulas are accepted to make computation easy. In Excel you can use basic math to create formulas to compute for you. To see how this works we are going to make a table and then insert a simple multiplication formula to do the math for us.
Create a similar table. Select the cell titled Total and begin to type your formula. "=C12*C13" Thus the total will come from those specific cells, even if they change.
You can even manipulate cells that have formulas within them just by clicking. Click Total left and type "=" then click the cells. Clicking each cell is more efficient than typing each formula out.
Save Online
The benefit of using Office 365 Online is that everything is saved to the Cloud, or in this case OneDrive. All documents can be found by clicking the icon to access OneDrive. There is no Save icon, because you do not have to Save. Everything online is being saved automatically. If you want to download the document open it and select File, then Save As. This gives you the option to Save a Copy or Download to your computer.