MacMost: Video Podcast

Learn how to use conditional highlighting to make cells in your tables stand out. Your can search for a number of different criteria and then change the color or styling of cells depending on the match. You can even have multiple conditions and give them priority. You can also use other cells and formulas as input for the conditions.

iMovie includes a variety of useful titles that you can use in between clips or on top of them. Some of the titles allow you to change the font style and other elements. Sometimes the creative use of spacing, extra lines and justification can let you customize them further. You can also use your own images for completely customized titles.

You can use Preview to easily merge two PDF files, or bring pages from one into the other. You can also create new documents from pages selected from another PDF. You can even bring images into PDFs as new pages.

When you create a basic table in Numbers, it is important to use Headers and Footers properly. Headers allow you to define the contents of rows and columns, and you will see these labels appear in formulas and charts. Footer rows allow you to perform functions like SUM and AVERAGE on an entire column, with the formula adjusting to the content in between the header and the footer.

Learn how to use Keynote to create a simple presentation that includes text and images. You can choose from a variety of templates, and then add slides from that template. You can populate the slides with your own information and then play back the presentation.

When you have a video or photo that does not fit into your iMovie video project exactly, you most crop it one way or another. You can decide to cut off portions of the image so it fills the frame, or you can show more of the image, but have black bars in the space not covered. You can adjust the cropping to best fit your needs.

You can use paragraph and character styles to manage the attributes of your text in a Pages document. You can use the built-in styles, or create your own. When you change some text, you can create a new style and then use it throughout your document. You can then update the text that uses that style in one place.

You can use Finder tags to help you organize your files. You can create as many tags as you need, and then assign multiple tags to the same file. You can use them on local files as well as iCloud files. Searches for tags will reveal files across all locations and iCloud apps.

Learn the basics of iMovie. See how to import video clips and then combine them into a larger video. Find out how to export that video to a file, or put it in iTunes Theater.

Check out the new features of Mac OS X Mavericks. There are two major new apps that come with the operating system, plus overhauls to Calendar, Notes and Contacts. You also get new features in Safari and better support for multiple screens.

Apple announced new products including the iPad Air, which replaces the iPad. They released Mac OS X Mavericks and make it a free upgrade. They also released new versions of Pages, Numbers, Keynote, iPhoto, GarageBand and iMovie. New hardware includes cheaper MacBook Pros and an update on the Mac Pro.

With the fast processor in the iPhone 5s, you can take 120 FPS video and slow down a portion of that video for an interesting effect. Learn how to use this feature, and how it really works.

There are several ways you can incorporate sounds and music into your Keynote presentations. You can add a background soundtrack that will play over the entire presentation. You can also add a sound for a single frame. If you set up this sound correctly, you can control the sound in the frame as well.

Learn to use the new Photos app in iOS 7 to find your photos. In addition to the Albums view that was available before, you also have a Photos view that lets you dig into your pictures by year, collection and moments. You can also bring up a map showing the the photos in any sub-division.

The Unarchiver is a free utility that will help you if you need to decompress files of different archive types that are not supported by Mac's built-in Archive Utility. You can decompress old SIT archives and odd download archives like RAR.

Learn several ways to deal with troublesome large iPhoto libraries. Make sure when you delete photos that they still aren't taking up space in your library. Learn how to rebuild your iPhoto library. See how you can split up your library into multiple parts. Also find out how to remove videos from your library to make it smaller.

Calculating percentages in Numbers is just a matter of dividing two numbers. But you can use cell formatting to display the result as a percentage instead of a decimal fraction. You can also use functions to calculate percentages from lists of numbers or lists of items.

Take a look at ten small but useful features of iOS 7. Learn how to easily remove email and messages, see time stamps on messages, get to calendar list view, use your iPhone as a level, make audio-only FaceTime calls and more.

There are three ways to tracks your app usage in iOS 7. You can see how much storage space each app is using. You can see which apps are using location services, and which ones are using it at this very moment, possibly using your battery more than you would like. You can also see how much cellular data each app is using and deny apps access to data when you are away from a wifi connection.

You can use AppleScript to create scripts that control Numbers and Pages. This is similar to how Microsoft Office users use macros to control Word and Excel. In either case, you need some level of programming skill to be able to write scripts. If you can do it, this can be a very powerful way to enhance Numbers and Pages, adding functionality that isn't possible otherwise.