Using Autofill In Numbers (#989)

Using Autofill In Numbers (#989)

http://macmost.com/e-989 Numbers can automatically fill in cells for you if you want to repeat a value, or create a sequence. You can use Autofill to add a set of sequential numbers or dates to cells. You can also have the cells follow a pattern. If you are using tables properly, formulas included in cells will…

Searching For Files With the Finder (#987)

Searching For Files With the Finder (#987)

http://macmost.com/e-987 You can use the Finder’s search function to find files by content or name. You can further narrow the field by adding more search criteria, like file type and date. You can also save searches as Smart Folders that will automatically update to show you the latest results for specific criteria as the files…

Using the IF Function In Numbers (#984)

Using the IF Function In Numbers (#984)

http://macmost.com/e-984 Learn how to use the IF function to perform calculations in Numbers. IF is an important function to learn if you want to graduate to creating more advanced spreadsheets. You can use it to test a value in one cell and return two different values depending on the results of that test. Also learn…

Editing Audio In iMovie (#981)

Editing Audio In iMovie (#981)

http://macmost.com/e-981 Learn how to edit audio in iMovie. You can change the volume of the audio in your clips, as well as apply filters. You can add additional audio, such as sound effects and music. You can layer audio by combining several pieces of sound. Youtube

How To Force Quit Apps (#980)

How To Force Quit Apps (#980)

http://macmost.com/e-980 Sometimes an app will stop working properly and you need to force it to quit. You can do this one of many ways in Mac OS X. If one of the standard methods does not work, you can always resort to using the Activity Monitor. And if all else fails, you can use the…

Interactive Charts In Numbers (#979)

Interactive Charts In Numbers (#979)

http://macmost.com/e-979 Numbers lets you create charts that have an extra dimension. You can move through columns of data using a slider or buttons, with the chart changing to reflect the data in each column. This can be useful for showing changes over time. Youtube

iMovie Semi-Transparent Overlays (#976)

iMovie Semi-Transparent Overlays (#976)

http://macmost.com/e-976 You can use semi-transparent images in iMovie as cutaways and picture-in-picture sources. This allows you to bring in almost any graphic element. You can use arrows and circles on your videos, for instance. You’ll need to create the image in an editor like Photoshop or Pixelmator, and same it as a 32-bit PNG file.…

Wrapping Text Around Images In Pages (#973)

Wrapping Text Around Images In Pages (#973)

http://macmost.com/e-973 Learn how to wrap text around complex images in Pages. You can make your text wrap around non-square images using a variety of techniques. You can use an alpha-channeled semi-transparent image, use an image with a solid-color background, or set the wrapping of the image manually using a custom shape. Youtube