- Table View
- List View
Take a Stand!: Classroom Activities That Explore Philosophical Arguments That Matter to Teens
by Sharon KayeTake a Stand! (grades 9–12) helps teens develop critical thinking skills by examining debates on issues directly relevant to their lives (that you won't find in most classroom materials). Each chapter:Covers an important topic relating to electronics, sex, mental health, and relationships.Presents a question for debate, such as "Should kids choose their own religion?" and "Is it possible to love more than one person?"Shows how each issue might arise in an ordinary teen conversation.Presents and explores two or more opposed answers to philosophical debates.Encourages high school students to develop their own positions while learning to appreciate other perspectives.Throughout the book, the chapter contributors—all current or recent teens themselves—highlight key definitions, quote compelling sources, and diagram the central arguments. Each chapter includes discussion questions to guide arguments, as well as helpful sidebars and illustrations to increase comprehension. Perfect for inspiring classroom discussion of topics that matter to today's teens.
Take Back Your Back: Everything You Need to Know to Effectively Reverse and Manage Back Pain
by Beth B. Murinson“Primary outcomes from this book, such as . . . better decisions about treatment . . . will undoubtedly be followed by better clinical outcomes for patients.” —Rollin M. Gallagher, Deputy National Program Director for Pain ManagementAlthough back pain is common, the fix isn’t. Take Back Your Back shows you how to diagnose and manage your particular back pain and alerts you to red flags and often-misdiagnosed issues that may worsen your condition.—Do you have non-radiating pain on one side of the spine? Your issue may be Muscle Injury, and you need to control inflammation.—Does your pain shoot down the leg? You may have a Slipped Disc that requires physical therapy and possibly surgery.—Does your pain worsen with sitting and ease off with walking? You may have Sciatic Nerve Compression and need special stretching exercises.Leading back pain expert Beth Murinson, M.D., director of pain education at Johns Hopkins School of Medicine, brings together the latest science on back pain diagnosis and treatment from medications and surgical procedures to traditional physical therapy to alternative modalities such as acupuncture, meditation, and water and inversion therapies that are showing promise.For each condition and procedure, you’ll learn what to expect in the hospital or the doctor’s office, what self-therapy solutions you can do on your own, and when to seek out intervention. Detailed illustrations and easy-to-understand descriptions help you select the best treatment options to improve your unique type of back pain and live a back-healthy life.
The Take-Control Diet: A Life Plan for Thinking People
by Ian SmithFrom the bestselling author of ShredThe Take-Control Diet aims to make you the expert on your body.Dr. Ian Smith delivers the final word on dieting for the fad-weary reader who wants the truth about permanent weight loss. The Take-Control Diet explains the real science of how your body manages energy, why crash diets and trendy programs sabotage your chances of success, and how you can get off the yo-yo ride forever.Dr. Smith offers a diet and exercise program that allows you to eat without feeling deprived, or adopting an entirely specialized diet, and that helps you use both anaerobic and aerobic exercise for maximum weight loss results. He explains how to calculate your own individual food-and-exercise equation in order to lose the ideal amount of weight per week. The Take-Control Diet equips you with the facts so that you can approach your health and fitness goals psychologically fortified for the task. Understanding common myths about dieting will give you the knowledge you need to resolve your weight issues for good. Did you know that, contrary to the recommendations of many popular diets, eating too much protein could seriously damage your health? That it is impossible to convert fat to muscle? That starving yourself slows your metabolism and causes your body to store energy as fat? That no foods appreciably increase your metabolism? That chronic, yo-yo dieting makes weight loss increasingly difficult?Dr. Smith explains the causes of overweight, the health concerns of dieting, how metabolism and genetics factor in to weight control, and what you can do to work with, rather than against, your body&’s processes. Many diets dictate a program that might work—if it works at all—only as long as you can adhere to radical and unnatural habits. The Take-Control Diet, instead, equips you to design your own eating and exercise plan—one that accommodates your preferences, your daily routine, and your particular weight loss hurdles. Losing weight will not only help you look your best but also reduce your risk of heart disease, diabetes, and cancer—in addition to improving your overall energy level and ability to fight illness. Dr. Smith offers a plan, based on extensive research and his personal work with patients, that respects your intelligence and empowers you to win the battle with overweight. The Take-Control Diet is one hundred percent free of unrealistic promises, poor science, and far-fetched gimmicks—and one hundred percent yours for life.
Take Control of 1Password
by Joe KissellEasily create and enter secure passwords on all your devices!Wrangling your web passwords can be easy and secure, thanks to 1Password, the popular password manager from AgileBits. In this book, Joe Kissell brings years of real-world 1Password experience into play to explain not only how to create, edit, and enter web login data easily, but also how to autofill contact and credit card info when shopping online, audit your passwords and generate better ones, handle two-factor authentication (2FA), and sync and share passwords in various ways--including a hosted 1Password account (individual, family, or team), iCloud or Dropbox.The book focuses on 1Password 7 for Mac and Windows, but it also provides details and directions for the iOS and Android versions of 1Password. It briefly covers 1Password X, a chrome extension that brings 1Password to Chrome OS and Linux.Topics include:Meet 1Password: Set your master password, explore the various 1Password components, and decide on your ideal usage strategy.Master logins: In 1Password, a typical login contains a set of credentials used to sign in to a website. Find out how to create logins, sort them, search them, tag them, and more. You'll also find help with editing logins--for example, changing a password or adding further details.Understand password security: Get guidance on what makes for a good password, and read Joe's important Password Dos and Don'ts. A special topic covers how to perform a security audit in order to improve poor passwords quickly.Go beyond web logins: A primary point of 1Password is to speed up web logins, but 1Password can also store and autofill contact information (for more than one identity, even), along with credit card information. You'll also find advice on storing passwords for password-protected files and encrypted disk images, plus ideas for keeping track of confidential files, software licenses, scans of important cards or documents, and more.Sync your passwords: Discover which 1Password syncing solution is right for you: a hosted 1Password account, Dropbox, iCloud, a manually synced folder, or even device-to-device Wi-Fi sync.Share your passwords: Learn to store passwords in shared vaults within a family or team hosted account.You'll also discover the answers to key questions, including:What are my options for licensing 1Password?What are the differences between vaults in 1Password accounts and standalone vaults?Should I keep using my web browser's autofill feature?What about iCloud Keychain? Should I use that too?What can I do quickly to get better password security?How can I find and update weak passwords I created long ago?What should I do about security questions, like the name of my pet?How can 1Password provide a time-based one-time password (TOTP)? How do I use 1Password logins from utilities like LaunchBar?
Take Control of 1Password (3.0)
by Joe KissellEasily create and enter secure passwords on all your devices! Wrangling your web passwords can be easy and secure, thanks to 1Password, the popular password manager from AgileBits. In this book, Joe Kissell brings years of real-world 1Password experience into play to explain not only how to create, edit, and enter web login data easily, but also how to autofill contact and credit card info when shopping online, audit your passwords and generate better ones, handle two-factor authentication (2FA), and sync and share passwords in various ways--including a hosted 1Password account (individual, family, or team), iCloud or Dropbox.While reading Take Control of 1Password on my iPad I was furiously highlighting passages and following along with 1Password open on my Mac. [The book] showed me how some of my passwords were weak or duplicates. I immediately changed those passwords to unique and secure ones.--Elisa Pacelli, in her MyMac book review (2nd Edition).The book focuses on 1Password 6 for the Mac, but it also provides details and directions for the iOS, Windows, and Android versions of 1Password. It briefly covers 1Password X, a chrome extension that brings 1Password to Chrome OS and Linux. Topics include: Meet 1Password: Set your master password, explore the various 1Password components, and decide on your ideal usage strategy. Master logins: In 1Password, a typical login contains a set of credentials used to sign in to a website. Find out how to create logins, sort them, search them, tag them, and more. You'll also find help with editing logins--for example, changing a password or adding further details. Understand password security: Get guidance on what makes for a good password, and read Joe's important Password Dos and Don'ts. A special topic covers how to perform a security audit in order to improve poor passwords quickly. Go beyond web logins: A primary point of 1Password is to speed up web logins, but 1Password can also store and autofill contact information (for more than one identity, even), along with credit card information. You'll also find advice on storing passwords for password-protected files and encrypted disk images, plus ideas for keeping track of confidential files, software licenses, scans of important cards or documents, and more.Sync your passwords: Discover which 1Password syncing solution is right for you: a hosted 1Password account, Dropbox, iCloud, a manually synced folder, or even device-to-device Wi-Fi sync.Share your passwords: Learn to store passwords in shared vaults within a family or team hosted account.You'll also discover the answers to key questions, including: What are my options for licensing 1Password? What are the differences between vaults in 1Password accounts and standalone vaults? Should I keep using my web browser's autofill feature? What about iCloud Keychain? Should I use that too? What can I do quickly to get better password security? How can I find and update weak passwords I created long ago?What should I do about security questions, like the name of my pet? How can 1Password provide a time-based one-time password (TOTP)? How do I use 1Password logins from utilities like LaunchBar?
Take Control of 1Password, Second Edition
by Joe KissellEasily create and enter secure passwords on all your devices!Remembering and entering Web passwords can be easy and secure, thanks to 1Password, the popular password manager from AgileBits. In this book, Joe Kissell brings years of real-world 1Password experience into play to explain not only how to create, edit, and enter Web login data easily, but also how to autofill contact and credit card info when shopping online, audit your passwords and generate better ones, and sync and share your passwords using a variety of techniques--including 1Password for Teams. Joe focuses on 1Password 6 for the Mac, but he also provides details and directions for the iOS, Windows, and Android versions of 1Password.Meet 1Password: Set your master passcode, explore the various 1Password components, and decide on your ideal usage strategy."While reading Take Control of 1Password on my iPad I was furiously highlighting passages and following along with 1Password open on my Mac. [The book] showed me how some of my passwords were weak or duplicates. I immediately changed those passwords to unique and secure ones. "--Elisa Pacelli, in her MyMac book review.Master logins: In 1Password, a typical login contains a set of credentials used to sign in to a Web site. Find out how to create logins, sort them, search them, tag them, and more. You'll especially find help with editing logins. For example, if you change a site's password from dragon7 to eatsevendragonsforlunchatyahoo, you'll want to incorporate that into its login. Or, use 1Password's password generator to create highly secure random passwords, like dGx7Crve3WucELF#s.Understand password security: Get guidance on what makes for a good password, and read Joe's important Password Dos and Don'ts. A special topic covers how to perform a security audit in order to improve poor passwords quickly.Go beyond Web logins: A primary point of 1Password is to speed up Web logins, but 1Password can also store and autofill contact information (for more than one identity, even), along with credit card information. You'll also find advice on storing passwords for password-protected files and encrypted disk images, plus ideas for keeping track of confidential files, scans of important cards or documents, and more.Sync your passwords: Discover which 1Password syncing solution is right for you: Dropbox, iCloud, or a Finder folder, as well as a device-to-device Wi-Fi sync.Share your passwords: Learn how 1Password integrates with the 1Password for Teams online service for sharing passwords within groups, such as your family or company work group.You'll also discover the answers to key questions, including:Should I use my Web browser's autofill feature?What about iCloud Keychain? Should I use that too?What can I do quickly to get better password security?Should I buy 1Password from AgileBits or the Mac App Store?How can I find and update weak passwords I created long ago?What's the best way to work with the password generator?What should I do about security questions, like the name of my pet?How can 1Password provide a time-based one-time password (TOTP)? How can I access my 1Password data on another person's computer?How do I initiate 1Password logins from utilities like LaunchBar?
Take Control of Apple Mail
by Joe KissellMaster Mail in Yosemite and iOS 8!Email is a necessary evil in today's world, but you can work more effectively in Apple Mail with the hard-won advice in this book, written by email expert Joe Kissell. You'll learn how to make Mail serve your needs with essential setup, usage, and troubleshooting instructions, whether you use Gmail, iCloud, Exchange, IMAP, or POP -- or more than one -- in both 10.10 Yosemite on your Mac and iOS 8 on your iPad, iPhone, or iPod touch.Joe explains core concepts like special IMAP mailboxes and email archiving, reveals Mail's hidden interface elements, helps with common tasks like addressing and adding attachments, and offers tips on customizing Mail to your preferences. You'll also learn how to find that message in the haystack, figure out how digital signatures and encryption work in Mail, and uncover solutions to numerous common problems. Perhaps most important, Joe shares his strategy for avoiding email overload; the article where he first introduced it won American Business Media's Neal Award for Best How-To Article.Mavericks and iOS 7? After you download this ebook, you can follow its Ebook Extras link to download the first edition, which focuses on Mavericks and iOS 7.Using the fully linked table of contents, Quick Start page, or other hot links in the ebook, you'll quickly find the essential information that's most important to you, including:Key changes in Mail for Yosemite and iOS 8The whys and hows of sending attachments with Mail DropHow to sign, annotate, and otherwise modify outgoing attachments (such as permission forms or contracts) within MailSetting Mail's Junk Mail filter correctly and other tips for defeating spamUnderstanding special mailboxes like Sent, Drafts, and JunkUsing notifications to manage incoming messagesTurning on the much-loved classic window arrangementUsing search tokens AND understanding Boolean searchesTaking charge of email organization with rules and other measures14 things everyone should know about iOS MailDeciding whether you should encrypt your email, plus detailed, real-world steps for signing and encrypting emailFixing problems: receiving, sending, logging in, bad mailboxes, and moreManaging Mail's new "Automatically detect and maintain account settings" checkbox -- especially if it's causing a connection problem
Take Control of Apple Mail
by Joe KissellMaster Mail in Mavericks and iOS 7! Email is essential for everything from work to shopping to keeping in touch with family. Could you get anything done without it? In this book, email expert Joe Kissell helps you make sure Apple Mail won't leave you in the lurch, providing essential setup, usage, and troubleshooting advice, whether you use Gmail, iCloud, Exchange, or IMAP -- or more than one -- in both OS X 10.9 Mavericks on your Mac and iOS 7 on your iPad, iPhone, or iPod touch.Along the way, Joe explains core concepts like special IMAP mailboxes and email archiving, reveals Mail's hidden interface elements, and offers tips on customizing Mail to your preferences (including the best power-user plugins for Mail on the Mac). You'll also learn how to find that message in the haystack, figure out how digital signatures and encryption work in Mail, and uncover solutions to numerous common problems. Perhaps most important, Joe shares his strategy for avoiding email overload; the article where he first introduced it won American Business Media's Neal Award for Best How-To Article.Using the fully linked table of contents, Quick Start page, or other hot links in the ebook, you'll quickly find the essential information that's most important to you, including: * Key changes in Mail for Mavericks * Interesting new features in Mail for iOS 7 * Setting Mail's Junk Mail filter correctly and other tips for defeating spam * Understanding special mailboxes like Sent, Drafts, and Junk * Addressing email to multiple recipients -- and to smart groups * Using notifications to manage incoming messages * Turning on the much-loved classic window arrangement * Customizing the Mail sidebar, toolbar, message header interface, and more * Using search tokens AND understanding Boolean searches * Joe's suggested smart mailboxes * Taking charge of email organization with rules and other measures * Keeping attachments problem-free * 12 things you should know about iOS Mail * Fixing problems: receiving, sending, logging in, bad mailboxes, and more * Mail plugins that will improve your Mail experience * How to decide if you should encrypt your email * Detailed, real-world steps for signing and encrypting email
Take Control of Apple Mail
by Joe KissellMaster Mail in High Sierra and iOS 11!You can work more effectively in Apple Mail with expert advice from Joe Kissell. You'll learn how to make Mail serve your needs with essential setup, usage, and troubleshooting instructions, whether you use Gmail, iCloud, Exchange, IMAP, or POP--or more than one account--on your Mac running 10.13 High Sierra (or 10.12 Sierra), or on your iPad, iPhone, or iPod touch running iOS 11.Joe explains core concepts like special IMAP mailboxes and email archiving, reveals Mail's hidden interface elements and gestures, and helps with common tasks like addressing and adding attachments. He also offers tips on customizing Mail, including a nifty chapter on how simple plugins and special automation can dramatically improve the way you use Mail. Joe also covers finding that message in the haystack with Mail's natural language search, improving the messages you send, how digital signatures and encryption work in Mail, and--perhaps most important--an award-winning strategy for avoiding email overload.Note: You may have heard about a new encryption issue called EFAIL that can affect Apple Mail. This issue was discovered too late to cover it in the book, but we have an article with complete details here: What You Need to Know About the EFAIL Vulnerability.You'll quickly find the information that's most important to you, including:Key changes in Mail for High Sierra (and Sierra) and iOS 11Getting through your email faster with gesturesUsing advanced search techniques to find filed messagesUsing plugins to significantly enhance how you use MailThe whys and hows of sending attachmentsUsing markup features to embellish, and even sign, outgoing attachmentsDefeating spam with the Junk Mail filter--and what to do if you need more firepowerUnderstanding special mailboxes like Sent, Drafts, and JunkUsing notifications to stay apprised of incoming messagesTaking charge of email organization with rules and other measuresBacking up and restoring emailImporting email from other apps, older versions of Mail, or another MacDeciding whether you should encrypt your email, along with detailed, real-world steps for signing and encrypting messagesTaking Mail to the next level with AppleScript and Automator18 things everyone should know about Mail in iOS 11Fixing problems: receiving, sending, logging in, bad mailboxes, and more
Take Control of Apple TV
by Josh CentersEverything you need to know about the Apple TV!The Apple TV may be the smallest component of a home entertainment system, but its size is in stark contrast to the vast quantity of content that it can bring to life through your television. With it, you can consider cutting the cord to your cable company -- and ditching that expensive monthly bill! And with the advice in Take Control of Apple TV, you can go far beyond watching movies and TV shows to make the Apple TV into the hub of your stereo system, display gorgeous slideshows of your photos, and play iPhone and iPad games on the big screen. Written by TidBITS managing editor Josh Centers, the ebook walks new owners through setup, and then dives into explaining how to best control the Apple TV with the included remote, Apple's Remote app, or another TV remote. You'll learn to customize the icon grid on the main screen, enable parental controls, and make your screen saver look awesome. Josh also covers uses of AirPlay, the Apple technology that lets you beam audio and video from an iPhone, iPad, or Mac to the Apple TV, and lets the Apple TV send audio to compatible speakers anywhere in your home.When it comes to content, you'll tour the Apple TV's built-in video apps -- iTunes Store, Netflix, Hulu, HBO Go, PBS, YouTube, and more -- plus get ideas for which are likely to offer what you want to watch. But you're not restricted to commercial video -- Josh explains how you can best view home movies and any DVDs or Blu-ray discs you own, listen to your music or iTunes Radio, use Home Sharing to display your photos via the Apple TV, and discover iOS games designed for playing via the Apple TV. If you're feeling geeky, you can read about how to make Plex bring in even more video content, including free access to Comedy Central's The Daily Show and The Colbert Report.Finally, the Apple TV isn't just about entertainment. Thanks to AirPlay, it makes a great device for giving presentations from a Mac, iPhone, or iPad using Keynote; it's the perfect accompaniment for a road warrior heading into unfamiliar conference rooms. Josh gives you all the details, including a list of what you'll need to handle any hardware you may encounter.In Take Control of Apple TV you'll read about:* The one-button press for jumping immediately to the main menu * Hiding unwanted Apple TV apps that clutter your main screen * Must-know video navigation tricks (also in the free Apple TV Cheat Sheet) * Enabling subtitles for foreign-language films or for the deaf or hard of hearing * Which is better, Netflix or Hulu? * Navigating with audio VoiceOver * Playing music from the Apple TV on every speaker in the house * The obscure way to transfer photos from a computer to the Apple TV * Two ways to show home movies on your TV screen * Using your TV screen as a second monitor for your Mac * Essential items to pack if you'll be giving a presentation via an Apple TV * What you can do with Conference Room Display mode * Improving AirPlay performance when playing games * Setting up an Elgato EyeTV HD to record live TV for the Apple TV
Take Control of Audio Hijack
by Kirk McelhearnFind sound advice for recording anything on your Mac!Learn how to use Rogue Amoeba's Audio Hijack 3 to capture and enhance any audio playing on a Mac. Audio expert Kirk McElhearn provides instructions for setting up common scenarios -- recording audio playing in Safari, capturing Skype and FaceTime calls, digitizing your old LPs, extracting audio from concert DVDs, and working with mics and mixers, among much else. Kirk also helps you edit recordings in Rogue Amoeba's Fission audio editor.You'll learn how to pipe sound through Audio Hijack to enhance its quality without recording. For example, by boosting the volume or tweaking the bass -- movies on Netflix never sounded better!You'll also discover special features such as reusable sessions, recording to more than one file (and format) at once, scheduling recordings, time shifting during live playback, effects like ducking and panning, adding automatic metadata before recording, and more.The Fission chapter has directions for trimming, cropping, adding, replacing, splitting, and fading audio. It also explains how to turn an audio file into a ringtone and -- podcasters and educators take note! -- how to make a chapterized AAC file.This book was created in collaboration with Rogue Amoeba, who worked with us to make this book more accurate, more detailed, and just plain better.As far as recording goes, you'll find help with:Recording literally any audio played on your Mac.Setting up reusable sessions with Audio Hijack's Audio Grid interface.Scheduling when your Mac should record something automatically.Recording from a mic. Or two mics. Or a mixer. Or a food processor.Capturing a chat from Skype, FaceTime, and other voice-over-IP apps.Checking volume levels before you record.Ducking one audio source when a second source kicks in.Digitizing an LP or cassette, while reducing hiss and noise.Breaking a digitized album into separate songs.Recording to multiple files and formats.Finding your recordings in Audio Hijack and the Finder.If you're interested in enhancing your aural experience, you'll find help with:Enhancing audio while you listen to it. For example, your little laptop's speakers might not provide enough oomph for an action thriller's soundtrack, but with Audio Hijack you can boost that sound and enjoy the flick.Piping audio around your house while you listen in creative ways: Rdio might not be able to use AirPlay to send music to your AirPort Express, but Audio Hijack can.Time shifting live audio while you listen. If you've ever used a TiVo, you know what this means: You're listening to a live stream, but you can't pay attention continuously. Even though it's live, you want to pause and resume, or go back a few seconds or jump ahead (if there's anything to jump ahead to).Lastly, you'll learn how to use Fission to polish your recordings. You can:Trim unwanted bits.Insert one audio file into another.Fade in or out from silence.Adjust a recording's volume.Create a ringtone or alert noise. Make a chapterized AAC file.Batch convert nearly any audio file to MP3, AAC, Apple Lossless, FLAC, AIFF, or WAV format.
Take Control of Automating Your Mac
by Joe KissellWork faster, increase your efficiency, and have more fun with automation!Looking for ways to work smarter and faster with your Mac? In this updated and expanded edition of his popular guide to Mac automation, Joe Kissell shows how anyone, at any level of experience, can save time and effort, and avoid unnecessary errors, by using automation techniques that range from the simplest keyboard shortcut to the most complicated script.In this book, Joe teaches you how to automate routine tasks in a wide variety of ways. You can begin by making the most of productivity features such as Siri, Spotlight (for launching apps), and text replacement--and then move on to the more sophisticated automation tools built into macOS, such as Automator, AppleScript, services, and shell scripts.In addition, Joe gives extensive information about third-party automation apps that can make a huge difference to your work efficiency, such as Keyboard Maestro, TextExpander, OmniGraffle, and many more. As an extra bonus, the book includes coupons for discounts on 11 automation apps, adding up to more than $100 in savings!Whether you're new to automation, you just need a refresher, or you're experienced with automation but want to go deeper, this book can teach you the skills you need to automate with ease. Take back your time, work more efficiently, and have more fun with your Mac, with Take Control of Automating Your Mac, Second Edition!With this book, you'll learn how to:Get started with the built-in macOS automation tools, including Automator, AppleScript, and the command lineTake full advantage of input devices to save clicksAutomate text expansion for faster, more consistent typingControl the Finder with a launcher and by organizing files with HazelSupercharge your clipboard to remember and reformat previous copiesWrite macros in Microsoft Office and Nisus Writer ProCreate rules to file email automatically in Apple Mail and OutlookLog in to Web sites faster with a password managerAutomate cloud services with IFTTT and ZapierSet up automatic backup and syncingUse Omni Automation for JavaScript-based automation tasksControl nearly anything on your Mac with Keyboard MaestroBONUS: We've included discounts totalling over $100 on 11 of the key apps Joe covers: 10% to 30% off on Keyboard Maestro, LaunchBar, Hazel, Nisus Writer Pro, OmniGraffle, Script Debugger, TextExpander, TextSoap, TypeIt4Me, Typinator, and UI Browser--look for coupons at the end of the book!
Take Control of Calendar and Reminders
by Scholle McfarlandManage your schedule more effectively using Calendar and Reminders!In the days before personal computers and mobile devices, we had to rely on paper calendars and to-do lists to help us organize our time and activities. Now, we have powerful tools, like Apple's Calendar and Reminders, that are much more responsive to our needs. Put an event on your schedule, invite others to join, or set yourself an alarm (or more than one). Or, keep a list of to-do items, add to it and view it on all your Apple devices, and share your list with family or friends.In this book, veteran Mac journalist and editor Scholle McFarland will guide you through getting to know these incredibly helpful apps, including lesser-known (but handy) features. For example, did you know that in Calendar you can set an alert for when you need to leave for an event, based on the travel time calculated using the location you entered for the event? Or that Reminders can prompt you to do something not only at a certain time, but also once you've reached a specific destination, like the grocery store?If you've never taken the opportunity to explore Calendar and Reminders, this book will show you how to make them an important part of your daily routine. If you've already been using Calendar and Reminders, you'll learn how to use them more effectively, troubleshoot common problems, and delve deeper into their capabilities.Whip your schedule into shape and tame your to-do lists with Take Control of Calendar and Reminders!Let Scholle walk you through how to get the best out of Calendar and Reminders, including how to:Customize Calendar to your liking, from setting time zones, to color coding specific calendarsCreate events, making them repeat at regular intervals or on certain datesSet up notifications and alerts, so you never miss an eventInvite people to events, or share your calendar with themCreate, manage, and share lists in RemindersSet alarms in Reminders at a certain time or a certain placeUse Siri to save time when creating events or remindersEasily check events and reminders on your Mac, iPhone, or Apple WatchTroubleshoot common problems in Calendar and RemindersShare calendars and reminders using iCloud Family Sharing
Take Control of DEVONthink 3
by Joe KissellManage all your information with the powerful tools in DEVONthink 3With the information-management app DEVONthink 3, you no longer have to swim in a sea of web bookmarks, email receipts, RSS feeds, scanned memos, and downloaded bank statements. DEVONthink stores your digital documents and clippings, helps you scan and store paper documents, and serves as home base for organizing and viewing all your information. But mastering all that power can take effort, and this book--created in partnership with DEVONtechnologies--has the real-world advice you need to understand how DEVONthink can bring order to your information.You'll also learn how to extend your DEVONthink experience beyond your main Mac with detailed coverage of the many ways you can sync DEVONthink databases to other Macs and to iOS devices using the DEVONthink To Go iOS app.After covering essential DEVONthink vocabulary and concepts, including the completely reworked user interface of DEVONthink 3, Joe helps you start using DEVONthink effectively. You'll learn how to:Decide how many databases you need and set them upDetermine whether to input or index dataConfigure where incoming data will goImport data from many different appsImport data from a scanner, including OCR optionsUse grouping and tagging to organize dataAdd and work with DEVONthink 3's expanded metadata capabilitiesUse simple (and sophisticated) techniques for searchingCreate smart groups that automatically gather newly imported dataUse smart rules and AppleScript to automate countless activities within DEVONthinkCreate documents in plain text, HTML, Markdown, and moreEdit documents in DEVONthink (or externally)Find the best way to sync DEVONthink data with other devicesWork with reminders, smart templates, and other sophisticated toolsConvert documents between formatsEffectively use the DEVONthink To Go iOS appShare DEVONthink documents with other peopleExport documents from DEVONthinkBack up and maintain healthy databasesQuestions answered in the book include:What is DEVONthink good for, and what should be left to other apps?What kinds of data can I import? (Short answer: Nearly everything!)How can I display my data in a way that works well for me?When I import documents from different sources, where do they end up, and why?Is it better to sort imported documents right away, or leave them for later?Should I group my data, tag it, or both?What are duplicates and replicants, and how can I tell them apart?Which types of data can be created or edited within DEVONthink?How do I make my DEVONthink database accessible via the web using DEVONthink Server?How do I move documents out of DEVONthink using the Share feature?How do I use DEVONthink To Go on my iOS device?Plus, we now plan to update this free book approximately four times per year for the foreseeable future to cover ongoing changes in DEVONthink and add new tips and advice!
Take Control of FileVault
by Joe KissellProtect your Mac's data in the event of theft with Apple's FileVault!If your Mac were stolen, would you worry about the thief seeing your email, photos, financial data, and other sensitive information? OS X's built-in FileVault encryption technology ensures that your Mac's contents are safe from prying eyes, but if you're hesitant to entrust your data to an algorithm before you understand how FileVault works, this book will dispel any misconceptions, answer your questions, and get you running FileVault with confidence.Security expert Joe Kissell begins by demystifying FileVault in a quick FAQ that explains, among other things, how it is that you can work with your startup drive normally even though all the data on it is encrypted. After the FAQ, Joe provides detailed steps for activating and using FileVault on both your startup volume and external drives. He also explains how FileVault interacts with your backups and how to use Find My Mac (because, remember, the point of FileVault is to protect your data in the event of theft) once you've turned on FileVault.Additional topics include making and using encrypted disk images, third-party software that can encrypt just a single file or folder, and accessing special FileVault features from the command line.FileVault facts and features that you'll master include:Essential tips for protecting external drives with FileVaultPros and cons of encrypting the backup of a FileVault-encrypted driveImportant steps for safeguarding encrypted drives from motivated thievesWhether your data is safe when your Mac is sleepingWhether your data is safe from other logged-in users on the same MacPros and cons of letting Apple store your recovery keyHow to avoid panicking if you forget your FileVault passwordFileVault and Disk Utility features found only on the command lineThis book covers FileVault 2, which was introduced in 10.7 Lion and is far better than, and completely different from, the original version of FileVault (now called Legacy FileVault). Everything in this book works with 10.9 Mavericks. A few minor things have changed over the years, but anyone with 10.7 Lion or 10.8 Mountain Lion should also find the book useful. It appears that 10.10 Yosemite, slated for release later this year, will change very little about FileVault.
Take Control of High Sierra
by Scholle McfarlandHead off into High Sierra with confidence!Looking for a high-quality, in-depth guide to High Sierra? Look no further than Take Control of High Sierra by former Macworld editor Scholle McFarland! An expanded version of Scholle's popular Crash Course on macOS (previously for Sierra and El Capitan), Take Control of High Sierra covers all the changes Apple has made in High Sierra, and how best to adapt them to your own needs.You'll learn great details about High Sierra, like how it's now possible to take live photos of a FaceTime conversation, type instead of talk to Siri, and easily share files through iCloud. You'll also learn about the big changes Apple has made behind the scenes in High Sierra, including rolling out a new file system, improved video support, and support for VR. In addition, Scholle explains what has changed in Apple apps, including Safari, Mail, and Photos.You'll also discover lots of helpful tips on using High Sierra, including how to:Find files, tweak System Preferences, and control apps (like iTunes) with SiriUse Spotlight to find files and facts from all kinds of sourcesCreate tabs in a variety of Apple and third-party apps (not just Safari)Open Mission Control view to easily see all of your windows at onceNavigate Notification Center, including the new Now Playing widget in High SierraUpdate your Safari preferences for specific sites and preventing advertisers from tracking your searchesCreate, sync, and organize your Notes, and use new High Sierra features to Pin a Note and Add a Table in NotesUse Universal Clipboard to copy and paste between MacsShare files instantly between Macs, iPhones, and iPads with AirDropUse iCloud Drive to collaborate with other usersSet up separate user accounts to allow multiple people to use the same Mac
Take Control of iBooks
by Sharon ZardettoIndulge your inner bibliophile with Apple's iBooks ebook reader!You know how to read a book, but do you know how to read and manage an entire library in iBooks, Apple's ebook-reading app for OS X Mavericks and iOS 7? On its surface, iBooks appears simple, but the more you add to your library, the more your questions will pile up. Get answers, plus learn about ebook-reading features that are not immediately obvious. If you need advice on collecting and reading ebooks in the Mavericks version of iBooks, want to know how iBooks stores and syncs your ebooks, or want to become more adept with iBooks on an iPad, iPhone, or iPod touch, this ebook is for you.Whether you're catching up on your favorite authors, poring over textbooks, or perusing work-related documents, self-described readaholic and Mac expert Sharon Zardetto teaches you the ABCs of iBooks. Sharon helps you optimize your onscreen reading environment, use the navigational controls (which differ depending on which type of ebook you're reading!), manage bookmarks, highlight important passages, make notes, and more. You'll also learn about auto-downloading and re-downloading purchases from Apple's iBooks Store, and where to find ebooks outside the iBooks Store.As you turn the virtual pages of Take Control of iBooks you'll read about:Ebook file formats: Here at Take Control, we often hear from people who aren't sure about the differences among the major ebook file formats--PDF, EPUB, Mobipocket, and Multi-Touch. If you're struggling with these basics (the difference between a hardback and a paperback is easier to understand), Sharon sets you straight, and helps you understand how the format of an ebook affects its behavior and features in iBooks.Mavericks mysteries: Discover what iBooks on your Mavericks Mac does with any ebooks that were previously in iTunes, where your library is located, and how to add EPUB, PDF, and Multi-Touch ebooks to iBooks. Synchronizing details: Find directions for syncing your Books library among your Apple devices. In addition to keeping copies of your ebooks on all your devices, you can sync your custom collection names and your position within any given book, as well as your bookmarks, highlights, and notes.Book acquisition: Whether you buy from Apple's iBooks Store, buy from a third party that sells ebooks in EPUB or PDF format (such as Take Control!), or make your own titles (such as with Apple's free iBooks Author--see Take Control of iBooks Author for help), you'll find out how to populate iBooks with your ebooks.Collection management: If you don't have time to "shelve" your ebooks, don't worry, because Sharon teaches techniques for taking advantage of iBooks' built-in organization and search function. But, the persnickety arrangers among us will learn how to further organize an iBooks library.Control your reading environment: Just as you may read best in the real world with the right lighting (and a bowl of grapes on hand, with a cat at your feet), you can also optimize your onscreen setup. You'll find tips for adjusting the font and type size, changing the page color, reading full-screen on the Mac, and even how to best "turn" the page.Enjoy the "e" in ebook: All those tiny electrons running around in your device can do more than display text on a screen. Sharon describes how to highlight passages, make in-book notes, insert virtual bookmarks, look up a selection in the dictionary (or on the Web--great for looking up a historical character or event that's mentioned in passing!) and more. A special chapter, "Explore Multi-Touch Books," guest-written by ebook expert Michael E. Cohen, helps you fully understand what's so special about Apple's Multi-Touch format and makes sure you can enjoy the special features, such as Study Cards, available in those ebooks.
Take Control of iOS 11
by Josh CentersDiscover what's new in iOS 11!Take a spin through the newest features of iOS 11 with Take Control of iOS 11 by TidBITS Managing Editor Josh Centers. Whether you use an iPad, iPhone, or iPod touch, you'll find lots to explore in this book, from major changes to Control Center, to new Instant Markup features, to the Files app, which offers access to files stored in iCloud and on your device. Learn how iOS 11 is a game-changer for the iPad, with new multi-tasking capabilities that take it one step closer to being a peer to the Mac.Other aspects of iOS that have seen changes in this new version are: the Lock Screen, Control Center, the Home Screen, Files, Siri, Keyboard, HomeKit, the App Store, the Camera, Maps, Messages, Photos, Notes, and Settings. As you dive into the details, Josh also shows you how to customize iOS 11 to fit your needs, helping you decide which settings and apps would be most useful to you.If you need a refresher on everything that iOS can do, you'll also find that in this book. Josh provides extensive guidance about the ins and outs of using iOS, including how to:Manage the Lock Screen, Home Screen, and Control CenterSearch with SpotlightSwitch between apps and use Handoff to transfer your work Use Siri effectivelyMaster Keyboard tasks (typing, dictation, emojis, autofill)Use Share SheetsMake use of iCloud servicesOptimize the App StoreTurn on Family SharingMake the most of special iPad features like drag and dropTake photos and organize themManage MessagesMake calls and use FaceTime and VoicemailSearch in SafariUse Maps, Find My iPhone, and Find My FriendsOrganize your Wallet and use Apple PayControl your home with HomeKit and SiriLearn about privacy settingsManage data usage and battery life
Take Control of iOS 12
by Josh CentersLearn how to make the most of iOS 12!Although iOS 12 focuses largely on performance and usability improvements, it also contains dozens of useful new features. In Take Control of iOS 12, TidBITS Managing Editor Josh Centers takes you through all the new stuff--including some powerful but obscure capabilities you may never notice on your own. You'll learn about Screen Time (to help you monitor and address screen addiction); updated notifications; improvements to Siri, Camera, Messages, and Photos; new password management tools; and a long list of other changes--as well as the new Shortcuts app, which provides new and improved automation features to iOS. Anyone with a compatible iPhone, iPad, or iPod touch will benefit from Josh's in-depth explanations.But the book also goes far beyond the new features, providing an extensive guide to getting the most out of iOS 12. For example, you'll learn how to:Make sense of the Lock screen, Home screen, and Control Center--and customize them to meet your needsSearch with SpotlightSwitch between apps and use Handoff to transfer your work Use Siri effectively, and even create your own custom Siri shortcutsBecome a whiz at using the various keyboards and editing controls built into iOS 12Use Share Sheets (for more than just sharing)Make the most of special iPad features like Instant Note, multitasking, and drag & dropNavigate the App StoreUnderstand the ins and outs of Family SharingManage your data--both locally on your device and in the cloudUse Screen Time to make better choices about when and how you use your deviceTake photos and videos, apply camera effects, and organize your mediaSend and receive messages in any of numerous ways with the Messages appMake calls and use FaceTime and VoicemailSurf the web with SafariUse Maps, Find My iPhone, and Find My FriendsOrganize your Wallet and use Apple PayInstall, delete, create, and use shortcuts in the Shortcuts appProtect your privacyMake the most of numerous iOS accessibility featuresImprove your battery life
Take Control of Keynote
by Joe KissellGive better presentations with this handy guide covering Keynote for the Mac!Need to give a presentation, but worried about how you'll do? Steve Jobs relied on Keynote for his famous keynote presentations, and while using Keynote won't guarantee Jobs-level success, Joe Kissell's advice in Take Control of Keynote will get you closer.Drawing on years of speaking experience, Joe suggests you start by figuring out what you want to say -- and he explains exactly how to accomplish this task, even though you won't do it in Keynote. He then helps you work in Keynote with the right theme, and explains how to create slides by filling in placeholders, adding objects (images, movies, sounds, tables, and charts), and inserting and styling text. You'll also learn how to add build effects to slides and transitions between slides, as well as how to make self-playing presentations designed for kiosks, and presentations with recorded narration or a soundtrack.Finally, Joe offers real-world advice about delivering presentations, including tips on what to bring, making presenter notes and customizing the presenter display, setting up your display, and controlling your presentation."As someone whose life (and income) is doing training presentations, this ebook is the most useful I have ever bought. I know Keynote well and have used it since its first release; however, Joe's ebook has both challenged me to think about the way I structure my presentations and has taught me stuff about Keynote I didn't know." -Michael Durrant, Psychologist ... mental health & corporate trainer (Sydney, Australia)You'll learn how to use the features that go into making a great slide deck:Making master slides with carefully positioned placeholdersAdjusting the slide orderViewing more than one slide at onceUsing all the fancy layout features to position objects on a slideApplying cool visual effects to photos, such as masking and Instant AlphaSorting out builds gone wild with the Build Order paletteHiding particular slides from an audience without deleting themTaking control of text boxes and Keynote's many text styling optionsCreating a presentation that requires clicks in specific places to advanceCommenting on slides while collaborating on your presentationAdditional advice helps you prep for a successful delivery and avoid technical glitches:What to consider in advance, with respect to the screen(s) you'll be usingPracticing the mechanics of delivering from KeynoteViewing presenter notes while you speakPlaying a sound or movie from a slide during your presentationEvaluating the many options for remote control instead of a mouse or trackpadPacking your bag with the right set of cables and gadgetsSetting up once you're at the speaking venueYou'll find even more assistance with answers to questions like:Should I store my presentation on iCloud Drive?What are my options if I want to print my presentation?What's the best way to turn my slide deck into a PDF?The bulk of the book documents Keynote for the Mac, but an appendix explains what's similar and different about Keynote for iOS and Keynote for iCloud.
Take Control of Lightroom CC
by Jeff CarlsonImport, manage and edit your photos expertly with Lightroom CC!As more and more of us access and edit photos on many different devices--laptops, desktops, tablets, and phones--we increasingly expect a seamless experience, with our images and edits showing up on all our devices, immediately. To accommodate this shift, Adobe has released a new version of its Lightroom application, Lightroom CC, that is specifically designed for cloud interaction. Lightroom CC is streamlined and simplified, meant to appeal to those who want to do more than the basics with their photos, but who are intimidated by Lightroom Classic CC and Photoshop.In Take Control of Lightroom CC, photography expert Jeff Carlson gives a thorough, but accessible, guide to the new Lightroom CC. He explains where it fits in the Lightroom ecosystem, then moves on to detail how to import, manage, and professionally edit your photos using Lightroom CC. For those who want to keep using Lightroom Classic CC, he also looks at how the two programs can work together.With this book, you'll:Get the big picture: See how Lightroom CC and Lightroom Classic (as well as Lightroom Mobile and Lightroom for Web) work together Build your photo library: Learn how to import photos from cameras, memory cards, and locations on your hard disk; automatically add mobile photos; and sync photos, taking advantage of Lightroom CC's cloud-focused features. Organize your photos: Organize your photo library with rating and tagging, find photos using Adobe Sensei, manage your storage options, and back up your library.Edit your photos: Get a handle on essential editing basics (like working in the Edit panel); use crop, straighten, rotate and flip to re-orient photos; adjust lighting, color, and appearance; and apply presets.Share your photos: Post images directly to your friends online in Facebook, export them to disk in order to share them elsewhere, or make an entire album public for people to view and, optionally, to download.Work with Lightroom Classic CC: Learn how to migrate a Classic catalog, or discover how to run both programs together.
Take Control of Mac Basics (1.1)
by Tonya EngstMaster essential Mac facts, concepts, and skills!When we learn a new language, it's helpful to start with the basics, such as vocabulary and grammar. If we were to dive in without knowing these things, we'd have a hard time becoming fluent. In the same way, Take Control of Mac Basics is a primer for your Mac, giving you the basic facts and concepts you need, then moving on to explain how to put them to use in order to become "fluent" in macOS. But Take Control of Mac Basics is also meant for anyone--whether beginner, intermediate, or beyond--who wants to fill in any missing gaps in their knowledge of the Mac. Providing a carefully arranged and cross-referenced guide to the Mac, Take Control of Mac Basics brings together dozens of essential Mac topics in one place. Drawing on her years of experience as the former editor in chief of Take Control, author Tonya Engst presents a wealth of information in an easy-to-use format.After you read this book, you'll be able to:Get Your Bearings: Find out the names of the interface elements on your Mac screen and learn what you can do with them, including the menu bar, Apple menu, application menu, Siri, Spotlight, Notification Center, Finder, Finder windows, Dock, and Desktop. You'll also be introduced to each built-in app and utility on your Mac, and get expert advice on how to locate, install, and update additional apps.Use the Finder: Become confident with using the folders available to you on your Mac and with filing your files in both default and custom folders that work well for you. You'll find lots of tips for working on the Desktop, customizing the views in your windows, resizing windows, and understanding Mac paths.Manage Customization: Discover the many ways you can make your Mac work better for you, including making it easier to see, less of a power hog, more beautiful to look at, and easier to share with a child by creating separate accounts. Also learn how a wide variety of settings in System Preferences can improve the way you carry out essential tasks, such as copy/paste between your Mac and your iPhone, speaking through headphones on a FaceTime or Skype call, and viewing recent text messages or upcoming calendar events.Run Apps Effectively: Understand the best methods for getting in and out of apps, having apps launch on their own, quitting apps, dealing with frozen apps, opening new files, saving files, and more.Master Essential Tasks: Build your expertise with core Mac tasks and technologies including printing, copy and paste, keyboard shortcuts, connecting to a Wi-Fi network (in certain cases even if you don't know the password), Universal Clipboard, Mission Control, AirPlay, Sleep, Shut Down, what to do if you need to enter a Unix command in Terminal, how to think about backups, and more.This book is based on macOS 10.13 High Sierra, which Apple released in 2017. This book is compatible with earlier versions of macOS, but the newer the version, the more it will match what the book presents.Take Control of Mac Basics is based on an older book called Read Me First: A Take Control Crash Course, which contained information about core Mac skills useful to Take Control readers. Take Control of Mac Basics expands greatly on that idea, adding invaluable content that is pertinent to anyone interested in other Take Control titles.
Take Control of Mojave
by Scholle McFarlandLearn all the ins and outs of macOS 10.14 Mojave!Mojave brings new features and user interface options to macOS. Whether you're new to the Mac or a seasoned pro, you'll find tons of useful information in Take Control of Mojave, an in-depth guide by former Macworld editor Scholle McFarland. The book covers not only the many changes in Mojave, but also the fundamentals of getting around, customizing your experience, and solving problems.Among the many topics Scholle covers are new Finder features such as Dark Mode, stacks, and Gallery view; system-wide tools like Quick Actions (which let you perform common functions without opening an app), Mojave's enhanced screenshot features, and new capabilities built into Siri; revisions to Apple apps such as the App Store, Mail, and Safari; and features that span macOS and iOS platforms, such as Continuity Camera (using your iPhone's camera to insert a picture on your Mac) and updates to the Dock.You’ll also discover lots of helpful tips on using Mojave, including how to:Change the overall appearance of your Mac's display, modify the accent color, and use the new dynamic desktop imagesUse Stacks to keep the files on your desktop tidy and organized—effortlesslyChange the Dock's new way of showing recent apps if you don't like itPreview graphics and other files with Gallery view, and get more information about them in the Preview paneUse Quick Actions (in the Preview pane, Quick Look, contextual menus, and elsewhere) to modify documents directly, without finding and launching an appMake your own custom Quick ActionsUse Mojave's enhanced security and privacy features to keep yourself and your data safe and avoid unwanted trackingCapture your Mac's screen (as a photo or movie) in any of numerous ways, without needing an extra appUse Siri to find files, modify system preferences, find your Apple devices, perform specific tasks in apps, get answers to questions, and much moreMake Safari more friendly by selectively blocking pop-ups, showing favicons, and avoiding potentially harmful extensionsUse your iPhone to take a picture and insert it in a document on your Mac in one stepNavigate the updated App StoreUse the new Home, News, Stocks, and Voice Memos appsShare iCloud data and purchases within a familySolve common problems
Take Control of Notes
by Josh CentersUnlock the potential of Apple's Notes app! Apple's Notes has come a long way since it was first introduced with the iPhone as a simple note-taking app, but many users are still unaware of its expanded capabilities. Now available on Macs, iOS devices, and on the web at iCloud.com, Notes has become a surprisingly powerful tool for writing, sketching, organizing, and sharing information of all kinds. In Take Control of Notes, TidBITS Managing Editor Josh Centers provides a quick but thorough guide to this deceptively simple app, showing you how to master its many tools--and avoid or work around its limitations. Among many other things, you'll learn how to: Choose where to stores notes (iCloud, IMAP, or a device) and whether or how they sync Import notes from other apps and services Apply and modify character-level and paragraph-level formatting in a note Make lists (including checklists and lists with multiple levels of indentation) Work with tables in notes Encrypt notes with a password Add photos, videos, audio, maps, and other content to your notes Scan printed documents into Notes and save them as PDF attachments Draw and sketch using your finger or an Apple Pencil Share notes with other users Organize your notes into folders and search their contents
Take Control of Numbers
by Sharon ZardettoGet serious with Numbers, Apple's powerful spreadsheet for the Mac!Apple's Numbers has become a grown-up spreadsheet (and it's free on every Mac sold since October 2013!), but many of us still haven't learned even the basics, much less been able to take advantage of its surprisingly deep collection of features.With the advice in this 330-page ebook, you'll learn to input, calculate, sort, filter, format, and chart your data with ease, as author Sharon Zardetto guides you through the basics all the way to power-user features like conditional highlighting, custom data formats, and star ratings. Richly illustrated with hundreds of annotated screenshots, the ebook also includes a hands-on example spreadsheet you can use to try what you're learning, plus a special tutorial chapter that helps you put it all together. Of course, you can also treat the book as a reference, using the Quick Start to focus on a topic of interest.The book covers Numbers 3.5, which works on any Mac running OS X 10.10 Yosemite.You'll learn how to...Handle the basics:Input data into a table.Choose the best chart type for your data.Add, modify, and position shapes, such as arrows, comments, and text boxes.Import/export from Excel, text, CSV, and older versions of Numbers.Set up page numbers and other header/footer information for printing.See what you want to see:Know what to expect when you sort by column.Hide and show columns.Merge and unmerge cells.Create rules that filter data to display only specific rows.Set up and view interactive charts.Make formulas:Work fluidly in the formula editor to create formulas.Make formulas from the tear-off tokens on the Quick Calc bar.Nimbly use various types of cell references in formulas.Understand how to use IF, TRUE, and FALSE in formulas.Take charge of logical operators (AND, OR, NOT) in formulas.Concatenate and break apart text.Strip extra spaces out of data.Find medians, modes, ranks, percentiles, and more.Create clever formulas that can:Calculate a sales discount based on whether a total is over or under a certain amount.Sort seemingly unsortable data, such as items described as Poor, Good, or Excellent.Take a column of cells, with each cell containing a full name, and move all the last names into a different column.Apply formatting:Add and remove grid lines and cell borders.Work with a cell's background fill.Format a chart so it looks fabulous.Set up conditional highlighting that appears only when data meets certain criteria.Ensure accurate data entry with cell formats like sliders, menus, and checkboxes.Use and create templates.Format faster with character, paragraph, list, shape, and table styles.