Posts By: Gary Rosenzweig

If you don't have Numbers, you can use Pages to create simple spreadsheets. Just use the tables inside Pages to create small spreadsheets that can use formulas to perform calculations. You can even sort and use basic and conditional formatting.

With iDVD no longer available for new Mac users, it is important to find an alternative if you still wish to make DVDs. Roxio Toast 11 is a program that has been around for a long time and used by many Mac users to create DVDs. It has a simple but powerful interface for burning video DVDs. You can customize it and add slideshows and data too. https://macmost.com/j-toast

The new iTunes U app for iPad lets you subscribe to entire college courses. The courses can include video, audio, reading materials, apps, web links and other items. You can follow along with the course and take notes.

The new version of iBooks for iPad allows you to read advanced textbooks. These can include interactive images, 3D objects and even review quizzes. You can add your own notes and then review them as Flash cards.

Take a quick look at iBooks Author, the new tool from Apple that lets you create textbooks for the iPad. You can design and layout pages like in iWork Pages. You can also add special elements like photo galleries, quizzes, 3D objects and interactive images.

Two transitions in Keynote allow you to animate between similar slides. The Magic Move transition will animate the positions between objects from one slide to the next. This give you infinite variation and also allows you to create simple motion graphics for use in videos. The Anagram transition allows you to create an interesting build between two pieces of text.

Sometimes you need to place a watermark, like the word DRAFT or CONFIDENTIAL, behind text in a document. You can do this using text boxes that are made into background items and then set them to appear across all pages in the document.

You can use the COUNTIF function to count the number of times an item appears in a column. You can also use COUNTIFS to total the number of rows based on several conditions in several columns. The SUMIF and SUMIFS functions will give you the total of the rows in another column based on the same criteria.

Lion allows you to merge the contents of two folders as long as you choose to copy those files, and not move them. You can also place files of the same name in the same folder as long as you let the Finder automatically rename the new files.