Page 183 - MS Office 365 for Dummies 3rd Ed (2019)

FIGURE 12-5:
An Excel workbook in Reading View in Excel Online.
Editing Mode and Reading View
There may be times when you do not need to edit a workbook. For example, you might want to just view the latest spreadsheet report or show a colleague a set of data. Excel Online contains two different modes. When you are editing the work- book you are using Editing Mode. When you want to read the workbook, you can simply click it in SharePoint to open it and view it. This is called Reading View, which looks very similar to a workbook that is printed on paper. A workbook in Reading View is shown in Figure 12-5.
Using Advanced Features
In addition to the basic features that you will use in Excel Online, there are also some advanced features. In particular, you can work with formulas and functions, manipulate data, and even coauthor spreadsheets in real time in the cloud.
Adding functions
One of the primary reasons for the popularity of Excel as a data analysis tool is the seemingly endless supply of functions. A function is a bit of logic that performs some calculation or manipulates data in a certain way. For example, you may want a cell to display the addition of two other cells. You can use a simple plus (+) sign to accomplish this addition. Going farther, however, you might want a cell to dis- play the current time. You can use a function, such as Now (), which would display the current time. The power of this function lies in the fact that Excel updates the time each time it recalculates the spreadsheet.
CHAPTER12 GettingintoDatawithExcelOnlineandPowerBI 167