Posts By: Gary Rosenzweig

Learn the basics of using formulas to perform calculations in the Numbers spreadsheet app. You can perform basic arithmetic, copy and paste formulas to multiple rows, and use functions to get the sum of a column.

You can track things like cryptocurrencies, metals, commodities, market funds and other things in the macOS Stocks app and in Numbers. The trick is to realize that the values come from Yahoo Finance and to use the same symbols.

Perhaps the most creative tool in the Photos app is the ability to use Markup tools directly on photos. You can add text, shapes and draw. Here ate 10 creative ways to use Markup on your photos.

So here's a long rambling video on the subject. I want to find a way to present this material better (and in under 10 minutes). But the basics are: <ul> <li>Apple cables seem better than cheap cables, but that's only worth it some of the time.</li> <li>Apple adapters also seem better, but it is rarely worth it to spend the extra money.</li> <li>Apple power adapters are good, but too expensive and you should get cheaper third-party ones that are also smaller and have more features.</li> <li>Apple Keyboards and Mice are more expensive by far, but worth it.</li> <li>Trackpad is better than a mouse and nothing compares to Apple's Trackpad.</li></ul>What do you think? Let me know if you disagree and why.

If you have recently switched from Windows, you may be confused about some things on the Mac keyboard such as the Command key, Option key or Globe key. Learn about the modifier keys, and also what is meant by key names like brackets, backslash and tilde.

Notes has added a lot of new features over the past few years. Here are some tips to help you get the most from the Mac Notes app.

When you add a photo to an iMovie project, the photo will rarely fit right into the video frame but will instead be cropped, removing some of the top and bottom of the photo. Understand why that happens and learn how you can adjust the cropping or switch to make the whole image fit in the video with black bars to either side. Also learn about alternatives to black bars.

You can write in other languages besides you system default while in Pages and other apps. By setting things up correctly, you can have spell check use different languages and accept word variations on a paragraph-by-paragraph basis.

Had someone ask me about Gantt charts and it sent me down a rabbit hole, playing with ideas in Numbers. Here's what I came up with.

Dates, times and duration values behave differently in Numbers and other spreadsheet apps than other values. Learn what makes up time and duration values and how to use them in formulas and functions.

If you have a file you need to open often it could be worth it to set up a special quick way to access that file. Here are 10 suggestions for super fast access to one or more important files.

When you export from iMovie you get to choose from several quality and resolution settings. Here's how to make the right choice, a balance between quality and file size.

I did a video recently showing 3 ways to center a window. I missed one! Turns out that there is a hidden menu item Window, Arrange in Front. You have to hold down Option to see it. That can be used to center a single window or group windows in a neat way and center the group. <strong>Note:</strong> Only seems to work in apps where a window = a document. So in Reminders and Notes it doesn't work (actually does on a floating-window Note, just not the main window). Have to investigate more as to which apps do it and which don't.

If you find that auto-correct on your iPhone or iPad is getting words wrong or getting in the way when trying to type unusual words or uncommon spellings for names, there are a few things you can do. You can train it using the Predictive Text Bar over the keyboard. You can also use the Settings app to add corrections, new words and names as Text Replacements. Also learn how to turn off auto-correct entirely or reset the dictionary.

The Reminders app can be used for so much more than just quick to-do lists. Here are 20 ideas for different checklists that most people can use. You can also use the Notes app instead of Reminders.

You can use ScreenTime on your Mac to limit the amount of time you spend looking at apps or websites. While it is easy to override restrictions you place on yourself, these techniques can still be useful for those looking to manager their time better.

If you are looking to view or change the name of your Mac, it is important to note that this could mean different things. You can't change your Mac's model name, but you can change a name used in file sharing and in lists on your iCloud account. There is also the name of your local Mac user account, which can be changed although it is not recommended.

When you add images to a word processing document in Pages, you can choose to have it stay at the exact location on that page, or move with the text. A image can then be anchored to a space in the text, or set to Inline where it acts as a character in the text.

It is annoying that there is no way to jump from the Photos app to the Maps app. You can see a little map for each photo, but if you want to jump to the Maps app to explore more or get directions and such, you can't do it. So here are two ways to get around that. The first is to use Edit With and choose Preview. Then in Preview you have a button to jump to Maps. The second is to build a Shortcut in macOS Monterey. But the Photos app doesn't seem to want to send photos to Shortcuts via the Services menu. However, you can copy to clipboard to do it.

There is no simple built-in command to center a window on a Mac. But you can use other techniques. Learn how to combine two window movements to center a window, or use scripted Shortcuts, or a third party app.