Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member

Performing calculations

From: iBooks Author Essential Training

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.

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.

Show transcript

This video is part of

Image for iBooks Author Essential Training
iBooks Author Essential Training

89 video lessons · 20150 viewers

Chris Mattia
Author

 
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

Start learning today

Get unlimited access to all courses for just $25/month.

Become a member
Sometimes @lynda teaches me how to use a program and sometimes Lynda.com changes my life forever. @JosefShutter
@lynda lynda.com is an absolute life saver when it comes to learning todays software. Definitely recommend it! #higherlearning @Michael_Caraway
@lynda The best thing online! Your database of courses is great! To the mark and very helpful. Thanks! @ru22more
Got to create something yesterday I never thought I could do. #thanks @lynda @Ngventurella
I really do love @lynda as a learning platform. Never stop learning and developing, it’s probably our greatest gift as a species! @soundslikedavid
@lynda just subscribed to lynda.com all I can say its brilliant join now trust me @ButchSamurai
@lynda is an awesome resource. The membership is priceless if you take advantage of it. @diabetic_techie
One of the best decision I made this year. Buy a 1yr subscription to @lynda @cybercaptive
guys lynda.com (@lynda) is the best. So far I’ve learned Java, principles of OO programming, and now learning about MS project @lucasmitchell
Signed back up to @lynda dot com. I’ve missed it!! Proper geeking out right now! #timetolearn #geek @JayGodbold
Share a link to this course

What are exercise files?

Exercise files are the same files the author uses in the course. Save time by downloading the author's files instead of setting up your own files, and learn by following along with the instructor.

Can I take this course without the exercise files?

Yes! If you decide you would like the exercise files later, you can upgrade to a premium account any time.

Become a member Download sample files See plans and pricing

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.


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.

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
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.

Are you sure you want to delete this note?

No

Your file was successfully uploaded.

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
Terms and conditions of use

We've updated our terms and conditions (now called terms of service).Go
Review and accept our updated terms of service.