Get the most from your Mac! The show features news, tips, tricks, techniques, tutorials and reviews geared toward the casual, home and business Apple user. Covers the Mac, iPad, iPhone and other Apple products.
View in HD at . There are some changes to the Photos app in Catalina, most notably how you browse your photos. Gone are the confusing Years, Collections and Moments views, replaced by the more understandable Years, Months and Days views. You can also see square thumbnails in the All Photos view, plus a few other improvements.
View in HD at . A new feature in macOS Catalina is the ability to track and restrict your app usage. You can use Screen Time for yourself, to attempt to limit your use, or as parent controls on a standard account on your Mac. You can also limit individual websites.
View in HD at . The Notes app gets a bunch of new features with Catalina, bringing it up-to-speed with Notes in iOS 13. You can do a lot more with Checklists now, share folders of Notes, and view your notes in a gallery. You can also search your Notes for objects in photos and words in scanned documents.
View in HD at . Improved security is a big new feature of macOS Catalina. Some features, like a read-only system volume, extra checks by Gatekeeper and the deprecation of kernal extensions will barely even be visible to the typical Mac user. Other features like new permission settings for apps and websites and Sign In With Apple will give us new security techniques that we can practice.
View in HD at . The iTunes app is gone. So how do you sync your iPhone, iPad or iPod? If you are still using a cable or Wi-Fi to sync your devices and not iCloud, you can still do it in macOS Catalina. That functionality has simply mostly moved to the Finder. You can sync music, movies, photos, books and other things this way. Ringtones is tricky, but you can still put custom ringtones on your iPhone. Even older iPods are supported by Catalina.
View in HD at . The new Reminders app adds a lot of new useful features. You can now set an icon and color for each list, place lists inside of folder, and view all of your lists in one long screen. You can also see which reminders items from all lists are due today or in the upcoming days. When creating a new reminder, you can easily add a due date, location, photo or URL.
View in HD at . While major new changes get all of the attention, here are 10 minor things that you may not have heard about, but could become your favorite new features in macOS Catalina. You can put Dark Mode on automatic, block email senders, use picture-in-picture with QuickTime Player, tint the color of your screen, and much more.
View in HD at . A new feature in iOS 13 and iPadOS is the ability to have Shortcuts trigger automatically, at a certain time of day, when you launch an app, change a setting or move to a new location. You can use this to make Shortcuts much more useful. Take a look at two quick examples. The first simply forces the Calendar to jump to the current day every time you open it. The second will display a special Reminders list when you turn on Do Not Disturb, but only if there is at least one item in that list.
View in HD at . When you buy a new Apple device, you can also purchase an extended warranty called AppleCare+. This not only covers the Mac, iPhone, iPad or other device for an extra year or two, but also adds accident protection and other benefits. With AppleCare+ you can replace a broken screen or other accident damage for a fee much less than the cost of an actual repair. You can also get additional theft or loss protection for iPhones. But is AppleCare+ worth the price?
View in HD at . With iOS 13 and iPadOS you can now swipe-type using the default standard keyboard. Apple calls it QuickPath and it can significantly speed up your typing on the tiny iPhone touch screen. You can also use it on the iPad, but you have to switch to the floating keyboard first.
View in HD at . A new release of Pages, version 8.2, includes a much-requested feature where you can set the default font for basic templates. This allows you to continue to use the Blank template in Pages, but with a font face and size set in preferences. The Body style will match your font and size, and other styles will use the font and a size of the appropriate scale to Body. Another new feature is a new View, Go To menu which is also in Keynote as Slide, Go To.
View in HD at . The new Markup tools in iPadOS look and work better than ever. You can use them to add lines, arrows, highlights, shapes, text and other things to your PDFs, images, screenshots and more. Learn how to access and use the new tools.
View in HD at . A new feature of the iPhone 11 and iPhone 11 Pro is the ability to take better photos at night and in low light using a combination of techniques. Multiple cameras and used and many images are taken over a period of time, and then pieced together to create a brighter image with much more detail than can be done with a regular photo. Moving objects are handled without trails or streaking.
View in HD at . The new version of Safari in iPadOS (iOS 13) is now a desktop browser rather than a mobile browser. This means sites should look and work like they do on a Mac, not an iPhone. With this comes new features such as a download manager, zoom buttons, per-site settings, and one new feature that even Safari for Mac is missing.
View in HD at . A new feature of iPadOS is the ability to control your iPad using a Bluetooth mouse. You can add a mouse as an assistive touch device in the accessibility settings and then you get a round cursor on the screen that you can mose with the mouse. You can click to simulate a tap at that location. You also get a menu that you can bring up to access things like Home and volume. There are a variety of ways to customize this feature.
View in HD at . iPadOS (AKA iOS 13) brings a ton of new features to your iPad and makes it behave more like a Mac. You can now switch between multiple slideover windows and have windows from the same app in a slideover. You can select, copy, paste and undo more easily when typing text. The Home screen can include both app icons and the Today widgets at the same time. You can swipe-type in a floating single-finger keyboard, add fonts, and use a column view and other new functions in the Files app.
View in HD at . A little-mentioned feature of iOS 13 and iPadOS is the ability to apply the same effects to videos as you can to photos. You can easily adjust light, colors, cropping, rotation and apply filters to entire videos, right in the Camera and Photos apps.
View in HD at . Whether you just got a new iPhone 11, or you updated your old iPhone to iOS 13, you should take a look at these 10 new features. Several are settings you should turn on, such as low data mode for cellular, silence unknown callers and one that removes old Safari tabs automatically. You can also use video filters, swipe typing, new text gestures, Dark Mode and more.
View in HD at . Apple Arcade is the new subscription service where you can download and play a collection of games on your iPad, iPhone, Apple TV and Mac. The service has a wide variety of games, from arcade to puzzle to strategy and more. Learn about the basics of the service and take a look at four games available today: Sayonara Wild Hearts, Mini Motorways, Sneaky Sasquatch and Red Reign. You can play using the touch screen on your device, keyboard on your Mac or a game controller on any device.
View in HD at . Quick Actions allow you to do thing with files in the Finder by just clicking on a single button. You can use some preset Quick Actions or build your own in Automator. In this video, we'll look at two examples. The first will create a backup archive of a file. The second will speak the contents of a text file.
View in HD at . When you save or open a file in an app on the Mac, you get a dialog box with several buttons. You can use keyboard shortcuts inside that dialog to cancel, perform the default action, and do other things. You can choose a location using the keyboard, either with a single shortcut or by specifying a path. You can also navigate to any of the buttons using the tab key and spacebar.
View in HD at . You can create multi-column documents in Pages in either word processing or page layout mode. Using multiple columns in word processing is just a matter of a single setting, but you can adjust the columns as you wish. You can even have sections that use different numbers of columns. Page layout documents use individual text boxes that can be linked to form versatile columns. There are many reasons to use columns, such as to create a newspaper-style layout, wrap text around images, or fit long lists on to few pages.
View in HD at . Experienced Mac users know how to unleash the power of macOS and apps by using a variety of basic techniques. Learn how to master a new app by exploring the menu. Interact with objects using context menus. Customize your toolbars to reveal hidden buttons.
View in HD at . If you need to encrypt some files so the only way to acess them would be with a password, you can use one of two methods. By using Disk Utility you can create read/write disk images that can be opened on any Mac. But if you need to send some files to another person, you may want to instead use the Terminal to create an encrypted ZIP achive that will work on Windows as well.
View in HD at . Apple announced new iPhone models today, plus a new Apple Watch, iPad and release dates for the upcoming Apple TV+ and Apple Arcade services. The new iPhone 11, iPhone 11 Pro and iPhone 11 Pro Max bring new cameras, new video capabilities, a new A13 processor, and new colors. The new Apple Watch Series 5 has an always-on display and new finishes. The new 7th generation iPad has a 10.2-inch display. The Apple Arcade service launches next week for $4.99/month. Apple TV+ launches on November 1 and is free if you recently bought an Apple device.
View in HD at . Over the course of the last 12 years, I've given a lot of advice to Mac users. Take a look at some of the best advice that still holds up after all these years. Do you shut down your Mac or sleep? Should you get anto-virus software? Should you stress about batteries or rumors or new Macs? Do you need a cleaning app?
View in HD at . You can now log on to your Apple Music account in a web browser, access your music library and playlists and play your music. This gives you another way to access Apple Music and is handy if you are using a non-Apple computer or have to be logged in to a work or school Apple ID.
View in HD at . If you are unhappy with an App Store purchase on your Mac, iPhone or iPad, you can request a refund from Apple. You can do so through the iTunes or Music app on your Mac, or through the Settings app on iOS. This works for music, video and books as well. You eventually end up at a special Apple site where you can request the refund. You can skip directly to this site if you know how. Apple doesn't always issue a refund and it helps to use this sparingly. You can also cancel subscriptions you no longer want.
View in HD at . Learn some quick and simple tricks you can use to enhance your next iMovie video project. You can adjust iMovie's backgrounds to make them unique or bring in your own. Add audio narration and adjust the fade in and out of any audio. Use cropping to zoom in and special effects like freeze frame and instant replay.
View in HD at . Your iPhone has some great features that can increase your safety. Three of them need to be set up in advance to be useful, and two of them you need to learn how to use before you need them. Learn about the Emergency SOS feature, Medical ID, two ways to share your location with trusted friends and how to drive safely without seeming unresponsive to people trying to get in touch with you.
View in HD at . The INDIRECT function allows you to look up the value of a cell based on a cell reference. So you can take stings like C2 and find the value of the cell C2. This allows you to construct cells references from other values to create powerful lookups that refer to cells in other tables or even sheets.
View in HD at . Apple will be holding a special event at its headquarters on September 10. They are expected to announce new iPhones, Apple Watches and perhaps some new iPads as well. We'll also hear about the official release dates for iOS 13 and macOS Catalina. Take a look at what the rumors and speculation predict.
View in HD at . A lot of Mac and iOS users don't know that you can search for objects in your photos even if you have never added titles or keywords to your Photos Library. The app will indentify various types of items and scenery in photos. You can combine these category searches with locations and other search terms.
View in HD at . Sidecar is a new feature that we will get when macOS Catalina and iOS 13 are released that lets you use your iPad as a second screen with your Mac. In addition to a basic screen, you also get some sidebar buttons and the Touch Bar along the bottom. You can use the Apple Penicl on the iPad's screen as a substitute for a mouse or trackpad, or to draw with precision into graphics apps.
View in HD at . The default text transitions in Keynote can be boring and look too familiar to those that see a lot of presentations. You can use some of the options and other creative features of Keynote to make your text transitions unique and interesting.
View in HD at . If you need to capture an entire web page as an image, it can be difficult to do so because macOS screenshots don't allow you to capture all of the contents of a scolling window. However, you can use many different techniques to get the entire contents of a web page. Safari has a hidden feature to do this, but sometimes it won't work on certain pages. You can buy third-party pro capture software that will let you take perfect screen grabs of entire pages. You can also use a feature of the free Firefox browser, though it sometimes doesn't work perfectly.
View in HD at . You see your Mac user account picture every time you log in to your Mac. You can customize this image easily in System Preferences with some default images, a photo, or any graphic you want. You can choose a photo and zoom in on one part of the image. You can create your own graphics or download an image to use.
View in HD at . Here are 21 udeful Mac tips for all levels. Incuded are tips for using the Finder, Safari, Mail, Calendar and more. Even expert Mac users may find something they didn't know or had forgotten.
View in HD at . The Apple Card is now available to anyone that wants to apply though the iOS Wallet app. The card has some innovative technology behind it, such as account access, information and support through the Wallet app, a deep connection to Apple Pay and a physical card that doesn't have a number or room for a signature. The Apple Card offers next-day cash back through Apple Pay Cash with the best deal being to use it in Apple Stores.
View in HD at . When macOS Catalina is released in the fall, it will come with a new TV app. This app takes over the movie and TV show purchasing and rental features from the old iTunes app. You will also use it to access your own video you store in your TV app library, such as ripped DVDs. An important aspect of the TV app will be giving Mac users access to the new Apple TV+ service coming later this year, as well as the ability to subscribe to channels such as HBO, Showtime and CBS through a subscription.
View in HD at . Most Mac users never take the time to customize their login screen. But there are several options there you will want to change to increase security or have the login screen better fit your needs. There is one very easy change that every user should make, to include a message on the login screen in case you lose your Mac and want to increase the chances that it will be returned to you.
View in HD at . One of the most powerful tools in Preview is the Smart Lasso. You can use that to quickly cut out part of an image to create a new one with a transparent background, or insert an object from one image into another. While Preview lacks a lot of the image editing tools found in more powerful apps, the Smart Lasso is probably easier to use than similar features in expensive apps.
View in HD at . You should be very careful when installing apps on your Mac and try to stick only to the Mac App Store or sites you fully trust. When you want to uninstall an app, you can usually do it through LaunchPad. However, for some apps you'll need to look for uninstall instructions at the developer's site. If needed, you can uninstall an app manually if you know where to look for its files.
View in HD at . iCloud email allows you to freely add some text to your regular email address to create unqiue addresses that you can use on an as-needed basis. So you can use a slightly different email address when you sign up for a service and easily identify if that service is sending you spam or seling your information. You can also use this to organize legitimate email by filtering into groups that use the same address. However, there are some downsides too.
View in HD at . If you want to trim some video from the beginning or end of a movie file, you don't need to use a video editing app. You can do it right in QuickTime Player. Trimming is lossless and can be done with precision. You can also cut sections out of the middle of your video and export a new copy. You can trim in the Photos app as well, though the original full-length video is always available if you wish to revert.
View in HD at . If you use the Find function in the Finder you can perform file searches that are much more complex than using Spotlight. You can add many pieces of criteria to the search other than a single search term. If you know how, you can use logic to combine search criteria and add very specific options. Then you can save your searches so you don't have to recreate them from scratch later.
View in HD at . A new feature in macOS Catalina will be the ability to share entire folders in iCloud Drive with others. Any files you place in the folder will be available to others that you specify, or anyone with a link of you wish. All with access to the folder can modify, add and delete files. This collaborative feature has been a part of other cloud soltuions for a while, so it is nice to finally have it as part of iCloud. You can also do this with iOS 13.
View in HD at . Many Mac users ignore the Go menu in the Finder, but there are some useful shortcuts there. You can access some of the most most used folders on your drive with this menu and see keyboard shortcuts for them. You can also access your Librray folder and Startup Disk through the Go menu if you know how. The Go to Folder function lets you move around by typing, which is preferred by many pro users.
View in HD at . With standard Mac apps like Pages, Numbers and Keynote, you can revert to a previously saved version of the file to retrieve text or items you may have deleted or changed. You can completely revert to the old version, or copy and paste some text from an old version. This also works with TextEdit and some third-party apps.
View in HD at . One of the biggest changes that will come with macOS Catalina is the replacement of the iTunes app. The new Music app will take over management of your existing iTunes music library and it has pretty much all of the functions that iTunes had. Preview what it looks like and see what the Mac Music app can do. Catalina will be released in the fall.
View in HD at . The color adjustment tools in Preview allow you to tint a photo, but without much control. By using this special technique, you can tint your photo any color you wish, and by any amount. You can also do this directly in the Photos app using the markup tools there. This is also a good way to fade a photo or to darken it without losing too much definition.
View in HD at . In addition to being able to capture a still image of your Mac's screen, you can easily record your screen to create a video using built-in functionality. The screen capture tool in macOS Mojave and beyond has a variety of options including being able to select an area of the screen, capture microphone audio, and review and edit the video before saving. You can also capture and send immediately in an email or share other ways.
View in HD at . While most Macs have trackpads, most users never bother to learn how to use some of the gestures available. You can see which ones you have available in System Preferences, along with videos that show you how to perform the gestures. Each has a keyboard shortcut you can use instead if you prefer.
View in HD at . Many of us have hundreds of app on our iPhone and iPad home screens. Keeping them organized can be a chore. But you can use techniques like app folders and searching by keyword to help. It is also a good idea to delete apps you rarely use, knowing you can download them again easily. When organizing apps, you can drag more than one at a time.
View in HD at . If you want to go beyond the title text feature in iMovie, you can create your own styled text in Keynote or any image editing tool and use the resulting image as an overlay. Then you can use picture-in-picture keyframes in iMovie to animate the text popping in from one side or scale as it moves. You can use this technique with any transparent image for a variety of effects.
View in HD at . There are two ways to highlight text in Pages on the Mac. The first has to do with editing and revisions, and is usually used when collaborating on a document with others. But you can also highlight text purely as a style, placing a solid color behind characters. To make things easier, you can create character styles for different text highlight colors and even assign keyboard shortcuts to them.
View in HD at . In addition to using the Emoji Viewer to type special characters, or holding a key to add accents, you can also learn some special keyboard combinations using the Keyboard Viewer. These allow you to type some symbols like degrees, pi, the Apple symbol and accent marks using standard keystrokes with the help of the Option and Shift keys. The Keyboard Viewer allows you to see exactly which key combinations match which characters. This is dependent on the type of keyboard you own.
View in HD at . If you are designing a Numbers spreadsheet to give to users that allows them to enter values then you may want to prevent them from entering values outside of a range. You can use conditional highlighting to change the color or style of a cell if the user enters a bad value. You can use a formula in another cell to indicate a bad value, plus instructions. You can also use sliders, steppers and pop-up menu cell formats to limit values.
View in HD at . Do you use the Shift, Command and Option keys on both sides of your keyboard? If not, you can reassign the ones you don't use to perform a more useful function like triggering Mission Control. You can also set the Caps Lock key to become another modifier key, the Esc key or turn it off completely to prevent accidental use.
View in HD at . The new image fill feature of text in Pages and Keynote allows you to create some beautiful graphics with very little effort. In this tutorial you'll learn how to create a retro-style postcard image using some of your photos. You can apply a single image fill to all of the text or a separate image for each letter. You can post these graphics online or use them in documents or videos.
View in HD at . You can customize your Finder sidebar to include the folders and locations you most often use. You can click on a sidebar item to go to that location, and also drag and drop items into those locations. You can customize the sidebar in Finder, Preferences, and also by dragging and dropping items into and around in the sidebar. Tags and Smart Folders can be used to make the sidebar even more useful.
View in HD at . If you are buying a used Mac there are many things you need to check out before you complete the purchase. You can run hardware diagnostics and check out battery and hard drive health. You should carefully inspect the screen, keyboard and other parts. It is also very important that you check for a firmware password and see if the Mac is connected to iCloud. The best place to buy is from Apple's refurbished store, but you can also find used Macs at some well-known resellers as well as eBay and CraigsList. Be very careful to avoid scams and protect yourself. Once you get your new old Mac, be sure to wipe it and start fresh.
View in HD at . It is fairly easy to compress a single file or multiple files and folders into a ZIP file archive on your Mac. You can also decompress any ZIP file by simply double-clicking it. This is useful for sending files online or to store files you no longer need. The Archive Utility is used invisibly for both commands, but you can run this app by itself and choose from more options when compressing or decompressing ZIP files.
View in HD at . Apple's new lineup of MacBooks simplifies your choices by removing the 12-inch MacBook and older MacBook Pro models. But you still have 8 base models of MacBook Pro and MacBook Air. Which one is the right one for you. But looking closely at the specifications and purchase options, there is really one one MacBook Air model and two 13-inch and two 15-inch models. For most people, it comes down to a low-end but light MacBook Air, a mid-range MacBook Pro 13-inch and a high end MacBook Pro 15-inch. Find out which models you should consider to match how you use your MacBook.
View in HD at . Instead of storing your videos in the Photos app with your pictures, consider storing them as files in a folder in the Finder. You can place this folder on your iCloud Drive, on your local drive only, or on an external drive. You can organize them using file names, subfolders, tags and comments. You can use the Gallery view to look through your videos almost as if they were in a special video management app.
View in HD at . Many people overuse the minimize button to get applications and windows out of the way. In most cases, it is more efficient to use the Hide command to simply hide the app. Hidden apps can be quickly and easy brough back and you won't clutter your Dock with minimized windows. Today using tabs in windows and autosave to easily quit and relaunch apps means you should rarely need the minimize button.
View in HD at . When you Mac's hard drive is almost full, you can investigate and figure out what is using the space by simply using the Finder. There is no need to buy a third-party app to manage your hard drive. You start at the top and view all of your folders, digging down to see what is using the most space. Then you'll need to make some decisions about what to remove from yoru drive, being care to only remove files you don't need.
View in HD at . Many MacBook, MacBook Pro and MacBook Air owners want to know how to properly use and maintain their batteries. But there is a lot of bad information online. Learn what to expect from your MacBook's battery, what you should and shouldn't do to prolong battery life, how to tell if there is a problem, how to get a replacement and how much it may cost.
View in HD at . If you have a cluttered Desktop, you may want to occasionally hide the icons. You can do this with third-party apps or Terminal commands. You can also write a very simple shell script in Automator and save it as an app. Then you can toggle the Desktop on or off with a simple click in the Dock.
View in HD at . You can set up bookmarks in a Pages word processing document and then create links in other text to jump to those bookmarks in PDF readers. With a new feature in Pages 8.1, you can also create links in page layout documents to jump from text to a specific page in the document.
View in HD at . The new version of Numbers makes things easier for those that use filters. You can also link text to other sheets in the same document and there is better performance and calculation precision. Numbers also gets the same text fill improvements as Pages and Keynote, as well as inline images and face recognition for image cropping.
View in HD at . The new versions of Pages, Numbers and Keynote allow you to fill text using a gradient or an image. You can use linear or radial gradients of two or more colors, change the angle and other options. You can fill with an image stretching that image to fit the text or tiling it across the text. You can also use a new feature to outline text with a line, choosing the line color, style and size.
View in HD at . You can use the Ken Burns cropping effect to zoom in to a portion of your video in iMovie. However, this cropping effect will continue over the entire length of your clip. To zoom in starting at a certain point and then to stay at the same zoom level for a while afterwards, you need to split the clip at the right places and use a trick to keep the video zoomed out at the end.
View in HD at . Catalina is the name for the next version of macOS. Learn about the new features, features that will be removed from macOS, and other commonly asked questions. With iTunes being broken up into three apps, what will happen to your music library, TV shows and iPhone syncing? Can you run iOS apps on Catalina? When will it come out and how much will it cost?
View in HD at . Apple has produced a lot of different Macs with odd and interesting designs since 1984. Take a look at some of the most interesting, coolest and weirdest vintage Macs from 1984-2002. While some were commercial failures, most containted innovations that we still see as features in Macs today. Included are the Macinotsh XL, the Mac Portable, the Twentieth Anniversary Mac, the G4 Cube, the Titanium PowerBook and more.
View in HD at . You can use the Mac Photos app adjustment tools to make a blue sky in your pictures deeper and bluer. You can adjust pure blue, or select a color in the sky to make fine adjustments. You can also limit the range of the changes to keep other parts of your photo the same.
View in HD at . AFter updating to macOS Catalina, old 32-bit apps will not longer work. If you have an old 32-bit app, then before updating, you should update your app or switch to a new one. Most apps have newer versions that professionals should consider buying. If you are using the app for casual purposes, then consider getting a modern alternative to apps like Microsoft Word or Adobe Photoshop. These will be cheaper or free, and will probably be much better than using an old outdated pro app. You can also keep an old Mac around to run 32-bit apps. Experts can partition their drive, use an external drive, or a virtual machine to run Mojave or earlier in some situations.
View in HD at . You can use more than one microphone or input device with GarageBand on your Mac. Instead of buying more hardware, you can configure your Audio MIDI Setup utility to create an aggregate device that treats each mic like a track in a single input. Then you can set up multiple tracks in GarageBand to use those tracks so each mic records to a different track.
View in HD at . You can add captions to your photos right in the Photos app if you use the built-in Markup extension. You can add text and provide contrast between the text and the image. You can also add speech bubbles, lines and other elements. You can also do this to image files using Preview.
View in HD at . Here are 50 shortcuts that will make it quicker and easier to navigate around web pages and tabs. Learn how to use your keyboard to move around on a page, find information, and jump to different pages and tabs. Also find out about ways to click on links with modifier keys to open them in different ways and how to drag tabs and downloads.
View in HD at . Mail rules in the Mail app on your Mac are robust and powerful but they no longer work well in a world where we get email on multiple devices. Instead, use iCloud email rules, or filters you can set on your email server. These rules will be applied on the server before the messages get to yoru devices, so they will work properly and consistently.
View in HD at . The new iPod Touch is a modest update, but it does mean continued support from Apple for the foreseeable future. In a world with more capable iPhones, what are some good reasons to desire an iPod Touch? It could be a nice complement to a work-provided phone, a pre-phone gadget for a child, or a dedicated streaming music device. It can even be a decent alternative to a point-and-shoot camera, though many will disagree.
View in HD at . It is fairly easy to use a SUMIF function to find a total for rows that meet a condition. But there is no easy way to get the total for rows inside a range of dates. By using extra hidden columns, you can easily mark rows depending on whether they are in a date range, and then use SUMIF to get the total. Getting the maximum value in that range is a little trickier, but can be done with an additional column and the MAX function.
View in HD at . If you want to set a custom chime on your Mac you can do so by setting a crontab with the Terminal. You can set it to chime any any interval you wish. It can play a system sound, custom sound, or speak the time in a number of voices. You can even have it only work between certain hours of the day.
View in HD at . Here are some useful tips for getting even more from your iCloud service. You can backup and sync photos from cameras using just your iPhone, create family Calendars and shared Notes, you can even add funds to your Apple account so you don't have to pay a few dollars every month.
View in HD at . A new feature added to Dropbox is the ability to set files or folders to be Online-only. The ideal use for this would seem to be archiving your old files to Dropbox instead of vulnerable local hard drives. While it works for that, the process is rather clunkly, forcing you to set and reset an archive folder to be Online-only and also minding your settings on all of your devices as you add files to Dropbox.