The IF function is how to test values in spreadsheets. You can use it to simply test a value and show different results. But the key to making complex spreadsheets to learning more about the IF function. You can pass through values when a condition is met, combine conditions with AND and OR functions, and nest IF functions for more than two possible results.
While we all use our iPhone cameras to take pictures all the time, there is a lot of functionality hidden in the Camera app that many people don't know about. You can take long exposure photos, use a grid and level, get in the shot with a timer, take vertical panos and more.
Apple TV launches on November 1 with a variety of movies and shows, including four new primary series. Find out what the shows See, The Morning Show, For All Mankind, and Dickinson are about. Also learn about what shows will be quickly following later this year and next year, including Amazing Stories, Foundation and Time Bandits.
A quick search in the Finder will show you the largest files on your Mac or in a specific location on your Mac. But you may be better off using a special system utility that will show you large files and other items taking up a lot of space. Once you locate large files you can delete the or archive them to an external drive to free up space on your Mac's hard drive.
A new feature in iOS 13 allows you to send a name and photo to someone you are messaging with, and they can choose to use that to create a new contact. You can use a photo, your initials, take a new picture, an Apple Animoji or your own Memoji for this image.
Learn some useful everyday tips, tricks and techniques to make it easier to manage your files and folders in the macOS Catalina Finder. See how you can use things like Undo, Copy and Paste, the Path Bar, keyboard shortcuts and more to navigate around in the Finder and work with your files.
With the Books app taking over audiobooks in macOS Catalina, a lot of Mac users are upset that it doesn't handle large collections very well. You have no option to store your audiobooks on an external drive. However, you can still keep a large audiobook collection by managing the files yourself outside of Books, and only brining in the books you wish to listen to at the moment. Audible users may find it better to simply use the Auible iPhone app instead.