Viewers: in countries Watching now:
In this course, author and educator Chris Mattia demonstrates how to use the Apple iBooks Author application to create and publish your own ebook, without extensive design or publishing experience.
Follow along with Chris as he assembles, refines, and publishes a dynamic and engaging ebook for distribution on the iPad using the iBooks app. The course demonstrates the process of adding all of the components of a dynamic ebook, including engaging text, images, audio, video, 3D models, and dynamic web content. It also shows how to customize the iBooks Author interface and leverage built-in templates to produce a beautifully designed and polished ebook. The course wraps up with a review of the iBookstore publishing process.
- 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 on 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 drop down 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'll 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 as A, B, C, and so forth. All of our rows are being described as numbers, one, two, three, four and so forth.
So each individual cell has a specific label on it. And so the simple formula becomes equals D2 plus E2 plus 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 equals SUM parentheses D2 colon 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 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 in the lower right hand corner of the cell you can see there's 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 dollars to 49.99 and hit Enter or Return and hit the Tab key on our keyboard, you'll see the new Complete Tour Price is automatically updated for us. I'm gonna go ahead and reset that back to 50 dollars, hit the Tab key, and now my value is correctly calculated again.
Find answers to the most frequently asked questions about iBooks Author Essential Training .
Here are the FAQs that matched your search "" :
Sorry, there are no matches for your search "" —to search again, type in another word or phrase and click search.
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.