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. Read More...

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. Read More...

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. Read More...

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. Read More...

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. Read More...