Get up to speed on the revolutionary changes in Office for the Mac The 2011 version of the Microsoft Office productivity suite for the Mac sports major changes from what Mac users are accustomed to. This soup-to-nuts guide gets the Mac crowd up to date quickly and easily. Individual minibooks thoroughly cover the Project Gallery, Word, Excel, PowerPoint, Outlook (new for Mac), and the Project Center. You’ll learn how the new Office integrates with the Windows version, how to use and customize the new Ribbon interface, and much more. Office for Mac is the most popular office productivity suite for the Mac, used by 1.5 to 2 million people The new version includes new features such as the Ribbon interface, Outlook (which replaces Entourage), and greater integration with the Windows version Covers everything you’ll want to know about the Project Gallery, Word, Excel, PowerPoint, Outlook, and the Project Center With Office 2011 for Mac All-in-One For Dummies, you’ll be ready to use the newest version of Office like a pro.
Visual QuickStart Guides, designed in an attractive tutorial and reference format, are the quickest, easiest, and most thorough way to learn applications, tasks, and technologies. The Visual QuickStart Guides are a smart choice and guide the learner in a friendly and respectful tone. Visually presented with copious screenshots, the focused discussions by topic and tasks make learning a breeze and quickly take you to exactly what you want to learn. Microsoft Office 2011 for Macintosh: Visual QuickStart Guide, written by best-selling author Steve Schwartz, has been extensively rewritten to provide expanded coverage of the core Office applications: Word, Excel, PowerPoint, and Outlook, provides in-depth instructions on many of the new features and changes introduced in Office 2011, and offers a thorough introduction to the Office Web Apps. Coverage of each application is jam-packed with information and tips that not only explain HOW to perform a task, but WHY you need this procedure and WHEN it's best to use it. Table of Contents PART I: GETTING STARTED Chapter 1: Introducing Office 2011 Chapter 2: Office Basics Chapter 3: Working with Graphics PART II: MICROSOFT WORD Chapter 4: Introducing Word 2011 Chapter 5: Document Formatting Chapter 6: Text Formatting Chapter 7: Creating Tables Chapter 8: Working in Other Views Chapter 9: Other Word Features PART III: MICROSOFT EXCEL Chapter 10: Spreadsheet Essentials Chapter 11: Modifying Worksheets Chapter 12: Formulas and Functions Chapter 13: Working with Tables Chapter 14: Charts and Graphs Chapter 15: Database Techniques Chapter 16: Sharing Workbooks PART IV: MICROSOFT POWERPOINT Chapter 17: Creating a Presentation Chapter 18: Charts and Tables Chapter 19: Wrapping up a Presentation PART V: MICROSOFT OUTLOOK Chapter 20: Introducing Outlook Chapter 21: Email Chapter 22: Contacts Chapter 23: Calendar Chapter 24: Tasks Chapter 25: Notes Chapter 26: My Day Part VI: ADVANCED TOPICS Chapter 27: Combining Office Data Chapter 28: Office 2011 and the Internet Chapter 29: The Office Web Apps Index
Microsoft Excel 2011 for Mac OS X is a powerful application, but many of its most impressive features can be difficult to find. Learn Excel 2011 for Mac by Guy Hart-Davis is a practical, hands-on approach to learning all of the details of Excel 2011 in order to get work done efficiently on Mac OS X. From using formulas and functions to creating databases, from analyzing data to automating tasks, you'll learn everything you need to know to put this powerful application to use for a variety of tasks. What you’ll learn The secrets of the Excel for Mac interface! How to create effective workbooks and templates How to quickly format worksheets How to perform custom calculations and formulas What kind of creative and persuasive charts How to illustrate your worksheets with SmartArt, pictures, and more What business problem solving can be done with Excel How to analyze data with pivot tables How to automate tasks with Visual Basic for Applications (VBA) Who this book is for Beginning and intermediate users looking to get up to speed quickly with the Excel 2011 application and use it productively, both online and offline. Table of Contents Learning the Secrets of the Excel:Mac Interface Configuring Excel:Mac to Suit the Way You Work Creating Effective Workbooks and Templates Formatting Your Worksheets Quickly and Efficiently Performing Custom Calculations with Formulas Using Excel’s Built-In Functions Creating Clear and Persuasive Charts Using Data Bars, Color Scales, Icon Sets, and Sparklines Illustrating Your Worksheets with SmartArt, Pictures, and More Creating Databases Using Tables Solving Business Questions with What-If Analysis, Goal Seek, and Solver Analyzing Data with PivotTables Collaborating and Sharing with Macs and Windows Automating Tasks with Macros and VBA
What the book covers: The key features of Microsoft Office for the Mac including getting to know Microsoft Word, refining and editing documents with Word, using templates and other design elements, creating slide shows with PowerPoint, adding pizzazz to your slide shows, crunching numbers and data with Excel, enhancing and printing your Excel spreadsheets, getting to know Outlook, sending, receiving, and managing your e-mail, organizing contact information, scheduling your time, and more. Series features: Information presented in the straightforward but fun language that has defined the Dummies series for more than nineteen years.
Get up and running with Office on your iPad or Mac! Weverka walks you through every facet, from installing the software to working with the programs. You'll get tips for making the most of your iPad, and learn how to make great PowerPoint presentations, or share content and collaborate online.
Office 2013 For Dummies is the key to your brand new Office! Packed with straightforward, friendly instruction, this update to one of the bestselling Office books of all time gets you thoroughly up to speed and helps you learn how to take full advantage of the new features in Office 2013. After coverage of the fundamentals, you'll discover how to spice up your Word documents, edit Excel spreadsheets and create formulas, add pizazz to your PowerPoint presentation, and much more. Helps you harness the power of all five Office 2013 applications: Word, Excel, PowerPoint, Outlook, and Access Discusses typing and formatting text in Word and easy ways to dress up your documents with color, graphics, and more Demonstrates navigating and editing an Excel spreadsheet, creating formulas, and charting and analyzing Excel data Walks you through creating a PowerPoint presentation and adding some punch with color, sound, pictures, and videos Explores Outlook, including configuring e-mail, storing contacts, organizing tasks, scheduling your time, and setting appointments Delves into designing Access databases, including editing, modifying, searching, sorting, and querying; also covers viewing and printing reports, and more The fun and friendly approach of Office 2013 For Dummies makes doing Office work easy and efficient!
Office 2011 for Mac is easy to use, but to unleash its full power, you need to go beyond the basics. This entertaining guide not only gets you started with Word, Excel, PowerPoint, and the new Outlook for Mac, it also reveals useful lots of things you didn't know the software could do. Get crystal-clear explanations on the features you use most -- and plenty of power-user tips when you're ready for more. Take advantage of new tools. Navigate with the Ribbon, use SmartArt graphics, and work online with Office Web Apps. Create professional-looking documents. Use Word to craft beautiful reports, newsletters, brochures, and posters. Crunch numbers with ease. Assemble data, make calculations, and summarize the results with Excel. Stay organized. Set up Outlook to track your email, contacts, appointments, and tasks. Make eye-catching presentations. Build PowerPoint slideshows with video and audio clips, animations, and other features. Use the programs together. Discover how to be more productive and creative by drawing directly in Word documents, adding spreadsheets to your slides, and more.
Get the most out of your MacBook Your new MacBook is sleek and powerful, and this down-to-earth guide makes it easier than ever to navigate, personalize, and maximize what it can help you accomplish. From taking it out of the box and turning it on for the first time to file storage and security, to downloading apps and working with iCloud, MacBook For Dummies helps you discover—all in one place—everything your laptop can do. Ultra-light, ultra-fast, and ultra-powerful, the MacBook is the coolest laptop around, and longtime Mac guru Mark L. Chambers is just the guy you want showing you the ropes. Inside, he shows you how to navigate the Mac desktop, customize your settings, surf the web and set up email, hook into a network, transfer your important documents from another PC or Mac, and troubleshoot with ease. You'll also get the inside scoop on the fun stuff like FaceTime video calling, Messages, Reminders, photos, videos, music, the Mac App Store, and more. Explore the new OS X Be productive with Keynote and Pages Get creative with Photos and iMovie Find tips for maintenance and security Whether you're a PC convert or a seasoned Apple enthusiast, this book helps you get the most of your magnificent MacBook!
Learn to: Get a handle on soccer rules and regulations Grasp the basic moves and plays Improve dribbling, passing, and other skills Appreciate this popular pastime Learn the basics, improve your game knowledge, and reach your soccer playing goals Do you get a kick out of soccer? Whether you're a youth league player, a soccer parent, or a World Cup fan, here at last is the book you've been waiting for. Now updated with the latest history, stats, and rules of this popular sport, Soccer For Dummies is the ultimate guide to the greatest and most popular sport on the planet. Kick off — get a beginner's history of soccer, from its early days in China to the modern game that's showcased in stadiums and played on soccer fields all across the globe Get to the nitty-gritty — discover the rules of the game, what each player on the field is expected to do, the tactics they employ, and the skills they need to play The biggest sport in the world — explore everything about the professional game of soccer, from the biggest show on earth — the FIFA World Cup — to other international tournaments such as the European Championships, Copa America, and the CONCACAF Gold Cup For fans — find out what you can expect at a professional soccer game, as well as the lowdown on where you can find soccer on television, online, in newspapers, magazines, books, movies, and on DVDs Open the book and find: How soccer is played (and scored) Tips on coaching, how to keep fit, and how to play "the beautiful game" An in-depth look at women's soccer How club soccer is organized across the world Important international and club teams Fun soccer facts and interesting tidbits A look at the game's most fascinating players
The bestselling music guide - now updated and with a FREE DVD! Have you always wanted to learn to play guitar? Who wouldn't? Think of Jimi Hendrix wailing away on his Stratocaster. . . Chuck Berry duck-walking across the stage to "Johnny B. Goode". . .B.B. King making his "Lucille" cry the blues. No doubt about it—guitars are cool. Guitar For Dummies gives you everything a beginning or intermediate guitarist needs: from buying a guitar to tuning it, playing it, and caring for it, this book has it all—and you don't even need to know how to read music. Full of photo-illustrated exercises and songs you can play to practice the techniques discussed in each section, this step-by-step guitar guide will take you through the basics and beyond before you can say "Eric Clapton." Helps you choose the guitar and equipment that best fits your needs and budget Shows you how to build strength and dexterity while playing Teaches you to play in different styles, including rock, blues, folk, jazz, and classical Fully revised and updated, with an all-new interactive DVD packed with video and audio clips that help you learn, tune, and play along, Guitar For Dummies is the perfect introductory guide for any novice acoustic or electric guitar player. CD-ROM/DVD and other supplementary materials are not included as part of the e-book file, but are available for download after purchase.
The fun is just a tap away with the nifty NOOK Tablet! It's an e-reader, it's a tablet, and it's hot! The NOOK Tablet offers all the advantages of an Android-based tablet, and this small-trim book is packed with information about how to use it. Learn to set up your NOOK Tablet, navigate the touchscreen, download and read e-books, access the Internet, use all the cool Android apps that are included, and much more. Find out how to create your own e-books, share books with others, listen to music or watch streaming video on your NOOK Tablet, personalize your tablet, add accessories, and take advantage of all it offers. Explains the hybrid e-reader/tablet concept and shows how to navigate the NOOK Tablet touchscreen, connect wirelessly, install software updates, and use the built-in web browser Covers reading e-books and how to adjust lighting and fonts for your reading comfort Guides you through shopping for and downloading e-books, watching streaming video from Netflix, Hulu, and other sources, and creating a slideshow of photos from your digital camera Shows how to side-load video and music from your computer, listen to audiobooks, and interact with NOOK Tablet using the built-in microphone Tells how to personalize your NOOK Tablet, share e-books, and use all the built-in Android-based apps Just like the NOOK Tablet itself, NOOK Tablet For Dummies, Portable Edition is packed with everything you need to be NOOKing in no time!
The easy way to score high in Environmental Science Environmental science is a fascinating subject, but some students have a hard time grasping the interrelationships of the natural world and the role that humans play within the environment. Presented in a straightforward format, Environmental Science For Dummies gives you plain-English, easy-to-understand explanations of the concepts and material you'll encounter in your introductory-level course. Here, you get discussions of the earth's natural resources and the problems that arise when resources like air, water, and soil are contaminated by manmade pollutants. Sustainability is also examined, including the latest advancements in recycling and energy production technology. Environmental Science For Dummies is the most accessible book on the market for anyone who needs to get a handle on the topic, whether you're looking to supplement classroom learning or simply interested in learning more about our environment and the problems we face. Presents straightforward information on complex concepts Tracks to a typical introductory level Environmental Science course Serves as an excellent supplement to classroom learning If you're enrolled in an introductory Environmental Science course or studying for the AP Environmental Science exam, this hands-on, friendly guide has you covered.
Your friendly guide to trading the bond and bond fund market Bonds and bond funds are among the safest and most reliable investments you can make to ensure an ample and dependable retirement income—if you do it right! Bond Investing For Dummies helps you do just that, with clear explanations of everything you need to know to build a diversified bond portfolio that will be there when you need it no matter what happens in the stock market. This plain-English guide clearly explains the pros and cons of investing in bonds, how they differ from stocks, and the best (and worst!) ways to select and purchase bonds for your needs. You'll get up to speed on the different bond varieties and see how to get the best prices when you sell. Covers the ups and downs of today's market, which reinforces the importance of bonds in a portfolio Explains how a radical fall in interest rates make bond investing trickier than ever Explores the historic downgrade of U.S. Treasuries and its possible effects on government bonds If you're an investor looking for a resource that helps you understand, evaluate, and incorporate bonds into your portfolio, Bond Investing For Dummies has you covered.
Take a bite out of all your Mac has to offer with this bestselling guide So, you joined the cool kids club and bought a Mac. Kudos! Now, do you dare admit to your sophisticated Mac mates that you still need some help figuring out how it works? No worries, Macs For Dummies is here to help! In full color for the first time ever, the latest edition of this long-running bestseller takes the guesswork out of working with your new Mac, providing easy-to-follow, plain-English answers to every possible question in the book! Whether you're trying to figure out the basics of getting around the OS X interface, learning the ins and outs of turning your Mac into a sleek productivity tool, or anything in between, Mac For Dummies makes it fast and easy to navigate your way around your new Apple computer. You'll get the know-how to rocket into cyberspace, browse the Web, send messages, back up files to the Cloud, deal with security issues, get productive with leading Mac apps, and have fun with one-stop shopping for music, movies, and media. Navigate OS X El Capitan with confidence and ease Use your Mac to power your audio and video systems Add your Mac to your home network Troubleshoot common problems when your Mac starts misbehaving Fully updated to cover the latest hardware and software releases, Macs For Dummies offers everything you need to get your geek on—and make your Mac your minion.