MacMost: Archives

You can track and chart stocks in Numbers on your Mac with the STOCKH function. You can get the close, high and low prices for a stock on different days and then use formulas and filters to build various charts. You can then easily change the stock symbol and dates to generate new charts.

There is a universal keyboard shortcut on the Mac that will allow you to find any menu bar command, easily trigger that command, and also navigate the entire menu bar. If you love keyboatd shortcuts, this one should be among your favorites.

Instead of using the default desktop background wallpaper, you can easily set it to something to fit your style. You can use custom colors, your own photos, create your own gradient wallpapers and much more.

Tabs are a useful alternative to using multiple Windows in just about any app or situation on your Mac. Here are some tips to get the most from using tabs in apps like Safari, Pages and even the Finder.

Learn some advanced techniques for measuring time and ranking rows to create filters. Find out how to build a system where you can choose a filter from a pop-up menu customized to your needs.

You can use Affinity Photo to make adjustments and apply filters to your photos directly from the Photos app. By using adjustment layers, you can test out different changes and play with settings to get the result you want.

It can be hard to type on an iPhone's small virtual keyboard. But with these tips and some practice you can significantly improve your typing and text editing speed.

Many of us are using Zoom on our Macs for meetings, classes or get-togethers. Zoom is a powerful video conferencing app with many useful hidden features. Learn how to test your audio before a meeting, use a video background, send reactions and nonverbal feedback and start breakout meetings.

It is easy to be confused by the different types of ports on Maca, especially then names like USB and Thunderbolt are sometimes uses interchangably. Learn the differences between these kinds of ports and how to avoid confusion when talking about them.

If you want to effectively filter email you need to do it on the server. Here is how to set up mail rules using iCloud and Gmail filters. If you use another email service, it is just a matter of finding out how to set them up with that service.

Basic text selection can be done with a quick click and drag. But you can use these advanced techniques to select by word, lines, rectangular areas or make non-contiguous multiple selections at the same time.

When you click on Recents in the Finder, you get a huge list of all of your files. This is the result of a search, and not a separate location for these files. Recents is useful for quick access to the files you were just working on, but shouldn't be used for deleting or organizing files. You can also search with Recents as a starting point for a more specific search. You can disable Recents in the sidebar or create your own version using a Saved Search.

Showing a Keynote presentation over Zoom can easily become a mess with the audience seeing your document window and other things on your screen. You can use Zoom's ability to share a window and Keynote's new ability to present in a window to simplify things. But the best way to present is to use Keynote Live and let Zoom handle the video and audio while Keynote Live shows the presentation. To get the discount on the course, use the coupon code "keynote863" before it expires on August 28, 2020. https://courses.macmost.com/courses/keynote/?cc=keynote863

You can use the brush selection tool in Affinity Photo to cut out a subject in a photo. With the subject on a separate layer, you can apply adjustments, filters and effects to just the subject or the background. You can also copy and paste the subject onto another background image.

You probably know that you can use Command+Space and then type the first few letters of an app’s name, then Return to launch it when it appears as the top hit. But you can also use the initials of multi-word app names. So qp for QuickTime Player, fm for Find My and mw for Microsoft Word. It even works with gb for GarageBand, recognizing the capital B in the name.

The cell format in Numbers determines how the value in the cell is displayed. You can set the number of decimal places, add thousands separators, control how negative numbers are displayed and more. You can also format dates and durations. With custom cell formats you can take complete control and even change the format based on the value of the cell.

Starting with macOS Catalina 10.15.4 you can use Accessibility to control your cursor with your head, and even click and drag with facial expressions. Even if you don't need this functionality, it can be useful as a temporary way to control your Mac is some situations, or just a way to give your hands a rest.

If you need the headings in your document to be automatically numbered, you can adapt the numbered lists styles and the ability to continue from the previous number to accomplish this. The result isn't ideal, but it can be a life-saver in long documents with many headings as the numbers will change automatically as you add and remove headings.

It seems to be impossible to search for files in the Mac Finder in two or more separate locations at the same time. But you can do it ina tricky way by editing the criteria of a Saved Search. While not quick, this does give you the ability and you can modify it later to search in the same locations for different things.

Learn how to create a Shortcut on your iPhone that you can activate with your voice to turn on Do Not Disturb. The Shortcut will then ask you for a number of miniutes and automatically turn off. You can also set it to activate silently as a Home screen icon.