• how-to,  ipados,  mac os x,  numbers

    Adding Videos to Apple Numbers Spreadsheets

    Numbers is the spreadsheet application in Apple's iWork productivity suite. With the recent release of Numbers 10.1 for macOS, you are now able to embed and playback YouTube and Vimeo videos directly in Numbers spreadsheets.

    As a longtime user of Apple Keynote and Microsoft PowerPoint, I understand why presenters would want to add a video to their slide decks, but videos in a spreadsheet, that seems a little weird. So, naturally, I had to try it.

    Apple's website shows beautifully crafted works of art cleverly disguised as spreadsheets. As and IT professional, my spreadsheets are usually uninspiring lists of things hastily thrown together so that I can quickly move on to the next thing that needs my attention.

    YouTube video embedded in a Numbers spreadsheet

    In my sample Numbers spreadsheet, I have a very simple high-level task list for deploying some computers and joining them to a domain. To provide instructions for redeeming an Apple gift card code, I embedded a YouTube video from the Apple Support channel. Using videos as a way to help illustrate how to perform a task is just one practical example of why one might want to embed a video in a spreadsheet.

    To embed a video in your Numbers document:

    1. Find the web video you want to embed and copy the videoURL
    2. Select the Numbers sheet where the video will be embedded
    3. Click/Tap the Media Add > Web Video
    4. Paste the video URL and click Insert
    5. Reposition and resize the video as needed

    There are a few problems that you will need to be aware of if you are going to use videos in your spreadsheet for professional purposes. The first is that you will have to click (macOS) or tap (iOS/iPadOS) the play button twice to get the video to play. The first click loads up the video, which is pretty quick, and the second begins playback. The second is that your video will not be playable in full screen. Depending on your use case, that could be a deal breaker. Your mileage will vary depending on your project's needs.

    To learn more about how to add embedded videos to your Numbers spreadsheets, there are detailed directions on Apple.com.

  • apple,  ipad,  iphone,  iwork,  keynote,  mac,  mac os x,  numbers,  pages,  yosemite

    Apple Releases Yosemite Public Beta 2, iTunes 12 Beta, and iWork Updates

    This past Thursday was pretty busy for Apple.  Continuing toward the presumed late October launch of Mac OS X 10.10 Yosemite, the Fruit company released the second public beta of Yosemite alongside a new iTunes 12 beta.

    Yosemite Public Beta 2 and iTunes 12 Beta

    The Yosemite and iTunes betas brings the changes that have recently been released to Apple's registered (and paying) application developers to the free public test drive of the next version of Mac OS.  The software, as is all other Apple software at this point, is shipped as a software update from the Mac App Store.  The installation process took about 30 minutes on my mid-2009 MacBook Pro.  The new version of iTunes was a relatively quick install.

    Taking a quick look around after installing Yosemite, there didn't appear to be all that much changed from Public Beta 1.  Many of the changes at this point will be internal meaning that applications have most, if not all of their features and are going to become more stable.  I did notice that my external USB hard disk had a new flattened icon that I like better than the original orange icon.

    The iTunes 12 beta has a new, cleaner look to it.  I'm still on the fence as to whether or not I like the older interface with the sidebar or the new interface.  Knowing myself, I think it's just a reaction to having to learn where things are or a new way of doing them.  I'm pretty sure I'm just being a cranky old man about the UI enhancements in iTunes.

    iWork App Updates

    In addition to the new beta software, Apple also rolled out new versions of their iWork applications for the Mac, iPhone, and iPad.  I didn't notice any outward appearance changes to Pages, Numbers, and Keynote.  According to the update description, Apple only stated that the new apps "contain stability improvements and bug fixes."

    Head over to the Mac App Store and the iOS App Store to download and install the free updates now.

  • apple,  ios 7,  keynote,  numbers,  pages,  safari

    iWork for iOS Apps and Safari for OS X Get Version Bumps

    As is usually the case, Apple can't just rollout one software update, it has to make it a party!

    Alongside the iOS 7.1.1 update that was released shortly after 1:00pm eastern this afternoon, Apple also upgraded Pages, Numbers, and Keynote for iOS and the Safari 7.0.3 maintenance update.

    The Safari 7.0.3 update tweaks stored credit card information, address/search bar and other minor fixes.
    Use the iOS 7 and Mac OS X Software Update features to download and install the updates.