Back

1. Buy the book from MrExcel.com

2. View your order

3. Click Downloads on the right side

4. Download VLAQ.epub to your computer. Remember the file location for step 7

5. Open iTunes

6. From the iTunes File menu, choose Add File to Library

7. Browse to the VLAQ.epub location from step 4. Choose VLAQ.epub. The file will now appears in the Books entry in the top left corner of iTunes

8. Connect your iPad to the computer. Wait until the iPad appears in the left navigation area. Click on the iPad in the left navigation.

9. Look across the top of iTunes. Choose the Books category from the top navigation menu

10. If it is not set, choose to sync books to the iPad. Choose VLOOKUP Awesome Quick.

11. Click Apply or Sync in the lower right corner

12. After the sync is complete, disconnect the iPad

13. On the iPad, open the Bookshelf application. VLOOKUP Awesome Quick should appear on the bookshelf. Tap this book.

14. Slide your finger across the screen to turn pages in the book.

15. When you come to an audio clip, click the play button to listen to the audio.

16. When you come to a video clip, click the poster for the video. For the first few seconds of the video, you can enlarge the video to full screen. After viewing the video in full screen mode, tap the video once, and a “Done” button will appear. Click Done to return to the book.

17. While reading the book, tap the center of the page once. A scrubber will appear at the bottom. Drag the scrubber right or left to quickly scroll through pages.  Also, the Table of Contents icon will appear at the top left. Click this icon to jump to any topic.

Notes About the VLOOKUP Awesome Quick book

• Will it play on my Kindle?
  No

• Will it play on my Kindle Fire?
  Currently, the Fire does not support video. If it does in the future, we will mark the shopping cart page.

• Will it play on my Nook?
  The book might work on some later versions of the Nook. If you have a Nook and want to test it for us, write to Scott@MrExcel.com.

• I have an eBook reader like Calibre or Sigil on my computer. Can I read the book?
  Sigil will promptly delete the videos from the book. You can read the remaining text.

• I Want to Read the Book, I Don’t Care About the Videos. Is there a PDF version of the book that I can download?
  Sure – buy the book and in the download center, you can choose to download the PDF of the book. The video and audio will not work.

Why did I decide to offer an enhanced e-Book?

The iPad is a perfect way to showcase the future of eBooks. The screenshots are full color. You have the ability to embed audio and video in the book. It is somewhat difficult to describe certain steps in text or in static pictures. Including a video will allow you to see how an action is completed.

Why a Book About VLOOKUP?

As I do my live seminars, I realize that VLOOKUP is in the top three topics that people ask about. Either they are completely new to VLOOKUP and they are trying to figure out how it works in plain English, or their VLOOKUPs are not working reliably. This eBook has something for all levels. People who have never done a VLOOKUP learn quickly how to do a VLOOKUP in the first chapter. People who use VLOOKUP but are having trouble will learn how to troubleshoot the VLOOKUPs (as the book explains, it is all about the frequency of the #N/A errors and if they increase in frequency as you move down the table). People who are comfortable with VLOOKUP but occasionally have problems such as finding the last match, the total of the matches, or the previous match will learn something from the back chapters of the book.

Product Details
ePub: 134 Pages (iPad Portrait)

Includes:

• 5 audio clips

• 8 videos

• 160 full-color screenshots

Publisher: Holy Macro! Books
Electronic ISBN: 978-1-61547-409-7 ePub
Electronic Price: $9.99 USD

• Buy the E-Book version (Accompanied by PDF, Media-Free Version)