Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
Now although iBooks Author is no replacement for your favorite spreadsheet program for doing your analysis, you can do some basic calculations with iBooks Author in your tables. In this case, we want our final column over here, the Complete Tour price to have a sum of all of the values from these other three columns. And to do that, we first need to select the table, click one time on the first cell, hold down the Shift key and click on the third cell in order to have all three of these cells selected.
We can then create a sum of these cells by simply going over to the Table Inspector and clicking on the Format tab. Down in the Function section, click the dropdown menu and choose Sum. The new sum value is automatically added to the next column for us. That's a great way to create a sum. Let's go ahead and press Command+Z on our keyboard to undo that. And let's look at another way we can accomplish the same thing. We can click one time on the cell to select it, and then we can simply hit the Equal sign on your keyboard.
This will tell iBooks Author that we want to begin entering a formula. You can then click one time on the first cell, click one time on the second cell, click one time on the third cell, and you will see that a formula is being created for us. Now if we look at the table, some new extra information is being added to our table as soon as we started creating a formula, and that is all of our columns are defined as letters, A, B, C, and so forth. All of our rows are being described as numbers, 1, 2, 3, 4, and so forth.
So each individual cell has a specific label on it, such as this cell being cell D3 and this cell being cell E3. And so the simple formula becomes =D2+E2+F2. To accept that formula, simply hit Enter or Return on your keyboard and the formula is calculated for you. With that format, you can create fairly complex formulas by individually selecting specific cells or using other values instead of simply adding them together.
Let's go ahead and select the cell, though, and delete it one more time, and I want to show you a third way to calculate a sum. This is my favorite way of doing it. It's nice and easy. We'll go ahead and hit the Equal sign so we enter into our Formula Editor one more time, and then we'll come over to Cell D2 and simply click and drag from left to right until we select all three cells from D, E, and F. The formula is automatically written for us of =SUM(D2:F2), meaning from Cell D2 to Cell F2 create a sum calculation.
Then simply hit Enter or Return on our keyboard to accept that value. Now, we could repeat that process over and over in these additional cells, but that could be kind of tedious and especially if we had a large table. So in order to make this easier, we'll go ahead and click one time on the first cell, and then on the lower right corner of the cell, you can see there is a very small icon. Go ahead and move your mouse onto that circle icon and your Mouse Pointer turns into a plus. Click and drag in the downward direction, and you'll automatically copy that formula from the first cell all the way down to the last cell.
Now, all of these values are being automatically calculated. So if we come over to say the Gift Package for one of these items, and we change it from $50 to $49.99 and hit Enter or Return and hit the Tab key on our keyboard, you'll see that the new Complete Tour price is automatically updated for us. I'm going to go ahead and reset that back to $50, hit the Tab key, and now my value is correctly calculated again.
Get unlimited access to all courses for just $25/month.Become a member
120 Video lessons · 57669 Viewers
119 Video lessons · 67212 Viewers
84 Video lessons · 16613 Viewers
125 Video lessons · 29508 Viewers
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.