Start learning with our library of video tutorials taught by experts. Get started

iBooks Author Essential Training

Performing calculations


From:

iBooks Author Essential Training

with Chris Mattia

Video: Performing calculations

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.
Expand all | Collapse all
  1. 4m 48s
    1. Welcome
      48s
    2. Using the exercise files
      4m 0s
  2. 53m 58s
    1. Installing iBooks Author
      1m 47s
    2. Installing iBooks on an iPad
      1m 9s
    3. Creating a new document
      3m 25s
    4. Understanding the interface
      4m 48s
    5. Creating a book cover
      9m 26s
    6. Adding an intro video
      1m 48s
    7. Creating chapters
      8m 2s
    8. Creating sections
      3m 52s
    9. Creating pages
      2m 15s
    10. Adding visual interest
      4m 54s
    11. Customizing the table of contents
      5m 44s
    12. Creating a glossary
      2m 57s
    13. Previewing your work on an iPad
      3m 51s
  3. 27m 22s
    1. Understanding templates
      3m 18s
    2. Creating a blank layout
      3m 42s
    3. Modifying existing layouts
      5m 13s
    4. Creating a custom layout
      3m 57s
    5. Defining placeholder media
      1m 1s
    6. Defining placeholder text
      50s
    7. Adding auto-updating text
      1m 18s
    8. Creating a photo collage layout
      3m 25s
    9. Sharing a custom template
      1m 55s
    10. Creating a portrait-only book
      2m 43s
  4. 19m 25s
    1. Dragging and dropping plain text
      3m 16s
    2. Inserting text from Pages
      6m 51s
    3. Inserting text from Microsoft Word
      7m 11s
    4. Creating linked text boxes
      2m 7s
  5. 52m 13s
    1. Understanding how to format text
      2m 5s
    2. Formatting text
      8m 6s
    3. Creating lists
      5m 29s
    4. Creating custom styles
      9m 34s
    5. Controlling tabs
      5m 54s
    6. More on text control
      12m 37s
    7. Embedding equations with LaTeX
      3m 53s
    8. Embedding equations with MathType
      4m 35s
  6. 29m 14s
    1. Understanding objects
      7m 33s
    2. Adding objects
      2m 26s
    3. Manipulating objects on a page
      3m 24s
    4. Layering objects together
      1m 36s
    5. Changing an object's appearance
      7m 15s
    6. Adding titles, labels, captions, and descriptions
      5m 25s
    7. Adding accessibility text to objects
      1m 35s
  7. 21m 45s
    1. Adding images
      5m 33s
    2. Removing parts of photos with Instant Alpha
      3m 54s
    3. Cropping and masking images
      4m 0s
    4. Controlling image settings
      3m 0s
    5. Spanning an image across two pages
      5m 18s
  8. 16m 12s
    1. Understanding shapes
      2m 29s
    2. Adding shapes
      2m 29s
    3. Editing shapes
      3m 24s
    4. Drawing shapes
      3m 31s
    5. Creating a custom shape mask
      4m 19s
  9. 25m 57s
    1. Understanding tables
      2m 22s
    2. Creating tables
      2m 9s
    3. Adding and importing data into tables
      3m 3s
    4. Formatting table cells and data
      8m 37s
    5. Performing calculations
      3m 57s
    6. Using conditional formatting
      2m 52s
    7. Sorting table data
      1m 15s
    8. Adding a custom table description
      1m 42s
  10. 22m 33s
    1. Understanding charts
      2m 30s
    2. Adding charts
      3m 59s
    3. Editing chart data
      3m 51s
    4. Formatting charts
      5m 24s
    5. Changing the chart type
      5m 48s
    6. Adding chart descriptions
      1m 1s
  11. 45m 53s
    1. Understanding widgets
      4m 18s
    2. Creating an image gallery
      5m 18s
    3. Adding a movie
      4m 4s
    4. Adding a Keynote presentation
      5m 32s
    5. Adding a 3D object
      4m 24s
    6. Adding an interactive image
      7m 54s
    7. Adding custom HTML
      7m 57s
    8. Creating a scrolling sidebar
      3m 45s
    9. Creating a popover effect
      2m 41s
  12. 17m 4s
    1. Understanding review questions
      2m 26s
    2. Adding a review section
      2m 27s
    3. Creating multiple-choice questions
      7m 16s
    4. Creating matching questions
      4m 55s
  13. 27m 1s
    1. Preflighting on an iPad
      6m 21s
    2. Exporting a book in iBooks format
      2m 26s
    3. Exporting a book as a PDF
      2m 33s
    4. Exporting a book as a text document
      1m 49s
    5. Emailing a book
      2m 24s
    6. Getting ready to publish to the iBookstore
      4m 44s
    7. Publishing to the iBookstore
      6m 44s
  14. 32s
    1. Goodbye
      32s

Watch this entire course now—plus get access to every course in the library. Each course includes high-quality videos taught by expert instructors.

Become a member
Please wait...
iBooks Author Essential Training
6h 3m Appropriate for all Jul 03, 2012 Updated Feb 18, 2013

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.

Topics include:
  • Installing iBooks Author
  • Creating a book cover
  • Creating pages, chapters, and sections
  • Adding visual interest
  • Creating a table of contents and a glossary
  • Working with templates and placeholders
  • Importing text from Pages or Microsoft Word
  • Formatting text
  • Adding objects such as titles, labels, and captions
  • Inserting images
  • Adding tables and charts
  • Working with widgets such as movies, 3D objects, and interactive images
  • Creating review sections with multiple choice and matching questions
  • Exporting a book as an iBook, PDF, or text document
  • Publishing to the iBookstore
Subjects:
Elearning Design Digital Publishing Ebooks Teacher Tools Education Educational Technology Higher Education
Software:
iBooks Author
Author:
Chris Mattia

Performing calculations

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.

Find answers to the most frequently asked questions about iBooks Author Essential Training.


Expand all | Collapse all
Please wait...
Q: This course was updated on 02/18/2013. What changed?
A: This update covers changes included with iBooks 2.0. We added movies to address portrait-only book templates, embedded equations, scrolling sidebar and popover widgets, and updated movies on publishing to the iBookstore.
Share a link to this course
Please wait... Please wait...
Upgrade to get access to exercise files.

Exercise files video

How to use exercise files.

Learn by watching, listening, and doing, Exercise files are the same files the author uses in the course, so you can download them and follow along Premium memberships include access to all exercise files in the library.
Upgrade now


Exercise files

Exercise files video

How to use exercise files.

For additional information on downloading and using exercise files, watch our instructional video or read the instructions in the FAQ.

This course includes free exercise files, so you can practice while you watch the course. To access all the exercise files in our library, become a Premium Member.

join now

Are you sure you want to mark all the videos in this course as unwatched?

This will not affect your course history, your reports, or your certificates of completion for this course.


Mark all as unwatched Cancel

Congratulations

You have completed iBooks Author Essential Training.

Return to your organization's learning portal to continue training, or close this page.


OK
Become a member to add this course to a playlist

Join today and get unlimited access to the entire library of video courses—and create as many playlists as you like.

Get started

Already a member?

Become a member to like this course.

Join today and get unlimited access to the entire library of video courses.

Get started

Already a member?

Exercise files

Learn by watching, listening, and doing! Exercise files are the same files the author uses in the course, so you can download them and follow along. Exercise files are available with all Premium memberships. Learn more

Get started

Already a Premium member?

Exercise files video

How to use exercise files.

Ask a question

Thanks for contacting us.
You’ll hear from our Customer Service team within 24 hours.

Please enter the text shown below:

The classic layout automatically defaults to the latest Flash Player.

To choose a different player, hold the cursor over your name at the top right of any lynda.com page and choose Site preferencesfrom the dropdown menu.

Continue to classic layout Stay on new layout
Welcome to the redesigned course page.

We’ve moved some things around, and now you can



Exercise files

Access exercise files from a button right under the course name.

Mark videos as unwatched

Remove icons showing you already watched videos if you want to start over.

Control your viewing experience

Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.

Interactive transcripts

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.

Thanks for signing up.

We’ll send you a confirmation email shortly.


Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

Keep up with news, tips, and latest courses with emails from lynda.com.

Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

   
submit Lightbox submit clicked