Posts By: Gary Rosenzweig

The Lookup function in Numbers allows you to get a value from one table based on a piece of information. In this example you'll learn how to look up a number from column B based on the text in column A in order to calculate the cost of a project.

Aliases are shortcuts to folders and files that you can place anywhere in the Finder, on the desktop or in the Dock. You can use Aliases to have quick access to folders and files, while leaving those folders and files in their original locations. You can create folders full of aliases for even better access to items on the Desktop or in the Dock.

You can record the screen of your device using iOS 11 to create a video. Previously you could only do this by connecting your iPhone or iPad to a Mac. This can be handy for capturing epic gameplay or simply documenting a problem in an app. The video is saved to your Photos library.

While Safari is the default browser and the one most people use on their Macs, you can also easily use Chrome or Firefox. The advantage to those is being able to use the same browser on non-Apple devices, and for Chrome being able to use Google's cloud systems instead of Apple's. Both are free and easy to install, and may come in handy in situations where Safari doesn't work.

You can use the App Switcher to quickly and easily switch between running apps. It is a keyboard shortcut, but not as simple to use as just pressing the keys. You can use it to see which apps are running and pick which one to bring to the front, all without lifting your fingers off of the keyboard. You can also use it to quit apps.

You can create calendars in the Photos app that use your photos as the pictures. You can customize each month to include one or more photos, plus captions. You can also specify the items to be included on each date by using your own calendars. When done, you can order the calendars from Apple or print them yourself.

Stumbled upon dict:// links which open the Dictionary app right to a specific word. Doesn't work too well from Safari, but can be made to work as hyperlinks in documents. This could be potentially useful as a teaching aid.

Many Mac news sites and blogs are reporting about a way that someone can gain access to your Mac without your password. However, the danger is usually overstated as someone needs physical access to your Mac to use the exploit. In this video I'll show you the problem and also a simple way to prevent it. However, Apple will probably have a fix for this in the next few days or even hours.

It is fairly simple to take a screen shot in iOS 11 on the iPhone or iPad, if you know the combination of buttons you need to press. With iOS 11, you can mark up or crop the screen shot and share it before saving it to your Photos library. Or, you can share it and skip saving a copy.

If you want to have several images in Pages or Keynote match in size exactly, but the original images are different size ratios, you can use resizing and masking to make them all exactly the same. You can also use this to make rectangular images square or some other dimensions.

The cursor is the visual representation of the point on your Mac's screen where you are about to perform an action. It is typically an arrow, but can change to a special line when over text. The text cursor is a second cursor that is a blinking line indicating the position where you are typing in a text area. You can increate the cursor size in System Preferences.

Today's iPhones can record up to 4K video resolution and the new Apple TV can play back 4K movies. What is the difference between 4K and 1080 HD? How about older standards like 720 HD and SD video? Learn the difference and how it can affect video quality. Learn how to set your video recording resolution on your iPhone.

You can easily block a phone number or Apple ID from calling your iPhone or sending you messages. Once you block a number, you can review the list and unblock any that may have been mistakes.

If you use the Activity Monitor app to check your CPU, memory, energy or disk use, you can hide the main app window and use the Dock icon to keep track of use. You can have the icon show CPU, disk or network usage in a little graph that updates continuously.

One feature of Apple Music is the ability to start a new streaming station with a song, album or artist. Apple Music will then attempt to play songs that are similar. You can further customize the station by indicating if you like the song choices.