MacMost: Archives

You don't need to use formulas at all if you want to get totals, averages, counts and other summary information from your data. Just create a pivot table. Quick and easy.

With Pages, Numbers and Keynote you have to option to switch from a Single File type to a Package. What are the advantages and disadvantages to each and when should you consider a package instead of the default Single File?

If you need to create a quick and simple sign or poster using your Mac, look no further than the Pages app that comes with it.

Pie charts are one of the quickest and easiest ways to add a visual element to your Pages document.

By default you won't see the total size of a folder on your Mac. But you can use many quick methods to calculate and display the total size of the contents of a folder.

If you have a large Numbers table and regularly search and filter it, you may want to use a formula and a filter to enable quick and easy searches instead. You can search by text, match values exactly, or search by date range.

You can buy a cheap Bluetooth gamepad, connect it to your Mac, and use apps like Keyboard Maestro to control things in the system and the apps you use every day.

Voice Control dictation on your Mac is very powerful. But with that power comes a huge set of commands you need to learn. Take your first steps by just learning 5 basic command sets and build from there.

Here are 10 tips and tricks to help you beyond Finder basics. Learn how to use Column and List views, the Go To Folder command, do boolean searches, Batch Rename and more.

If your Mac Calendar is cluttered, here are some techniques you can use to clean it up or at least make it easier to see the events that are important.

If the date and time of a photo in your Photos library is wrong, you can change it by adjusting the time zone or just changing the date or time itself. You can do this for multiple photos at the same time. You can also set or change the GPS location of a photo.

When you see those square QR codes in restaurants, stores and around town, are they safe to use? They are just easy ways to get to web pages, so the risks are essentially the same as any link.

Learn how to set up Focus modes, highlight PDFs, add your classes to your calendar and more.

The Info Window in the Mac Finder is a great tool, but the Inspector gives you basically the same thing but with some advantages.

The Dock is much more than a way to launch apps. But learning to use Dock Menus you can jump right to a specific window, reopen a recent document, use special commands and much more.

You can use the Shortcuts app to have your iPhone respond automatically to messages. You can choose one or more recipients and when they text you they will get a response back even if your iPhone is locked. You can customize by specifying text to look for in the original message and adding things like your location in the response.

If you customize the styles in a Pages, Numbers or Keynote document you can create a template from that document to easily reuse those styles again. You can also copy and paste styles from one document to another.

There is no built-in basic function to sort a list in Pages. But you can do it without leaving Pages by using a temporary table. You can also use Apple Intelligence to sort a list, often with more complex options.

Learn how to use soma basic Numbers skills to build a habit tracker. You can track habits each day, see when you have made your goal, see your best streak, and even view charts with the data.

You can save as a PDF from almost any app on your Mac through the Print dialog. But you can also use Open in Preview to create a temporary PDF and instantly view it in Preview. This has several advantages over Save As PDF.