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.
Apple announced the new 16-Inch MacBook Pro today. This replaces the 15-Inch model. You can now choose between the MacBook Air, MacBook Pro 13-Inch and MacBook Pro 16-Inch. For most people the choice will be clear with the MacBook Air being the cheapest and lightest, the 16-inch MacBook Pro being large and expensive but much more powerful, and the 13-inch MacBook Pro filling lots of needs in between. Watch as I break down the differences between these models.
Instead of using music from a collection or jingles from iMovie you can easily create your own video soundtrack in GarageBand. It only takes a few minutes to combine a drum track with other loops and then export some music that you can drag and drop into iMovie or Final Cut Pro. Then your video will have unique royalty-free music that fits the content.
Here are some handy tips for using Pages on your Mac. You can make writing easier with paragraph spacing, showing word count, using text replacements and other things. You can adjust how your document looks with character styles, Emoji clipart and hyphenation. You can also copy and paste elements to avoid having to set properties over and over again. That and much more!
You can listen to regular worldwide and local radio stations using the Music app in macOS Catalina and iOS 13. Thanks to agreements with streaming radio services, you can find these stations by searching or askign Siri. At the moment the streams don't seem to require an Apple Music subscription.
Learn how to create an iMovie project, edit it, and export in less than 5 minutes with this complete tutorial. In this fast tutorial I take four clips, trim and arrange them, add titles, transisions, music and filters, and then export a finished project. Get up to speed on iMovie for Mac fast.
New iOS 13 iPhone Shortcuts automation are great, but you can't have most automations play without manually confirming first. However, you can have an automation triggered when you stop an alarm, which leads to some interesting uses. In these examples, we'll have a song or podcast start when you turn off your alarm. We'll also create a more complex shortcut to play a playlist matching the name of the day.
You don't have to settle for using Apple's images as your desktop background. You can use any photo from your library or image you can obtain as a desktop background. You can also make your own graphics in an image editing app or Keynote to use as a background. You can combine photos and graphics to make an ideal background.
While most iPhone users use the virtual on-screen keyboard to type all day long, many don't know about some important techniques that can make typing easier. Learn how to type punctuation easier, slide-to-type, use the one-handed keyboard, add more keyboards, search for emoji and access hidden characters.
When working in apps on documents you can choose to have one document open per window, or multiple documents in tabs in that same window. Windows can be floating, resizable objects on your desktop, or you can go into full screen mode to fill the screen with the window or split screen mode to share the screen with exactly two app windows. You can also combine windows, tabs, and screen modes to work in many different ways.
iOS 13 and iPadOS give us a new Messages app feature where we can send stickers based on our Memoji or Apple's Animoji characters. Old functionality lets you send a recording with animation and audio. But you can also send your own custom Memoji or Animoji stickers if you know a little hidden trick.
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.
iPadOS (iOS 13) refines multitasking so it works better than ever. You can bring up two apps at the same time with Split View, or float a window over a full screen all with Slide Over. You can pile up Slide Over windows and flip through them too. Apps can interact with each other through dragging and dropping. There is a lot of different ways to use multitasking so it is best to practice a little before you need it.
While working on your Mac, you can use your iPhone or iPad to take photos, scan documents and draw sketches. The result will end up as files on your Mac, being saved directly from the iOS device to your Mac. You can also insert these images directly into documents in some apps. You can also use this to create signatures in Preview.
If you like to switch between light and dark mode frequently, you can create a keyboard shortcut or Dock icon to do it with one fast action. By using a very simple workflow in Automator, with no scripting required, you can create either a Quick Action or a application for your Dock. The Quick Action can then be assigned to a keyboard shortcut.