Get expert techniques and best practices for creating professional-looking documents, slide presentations, and workbooks. And apply these skills as you work with Microsoft Word, PowerPoint, and Excel in Office 2010 or Office for Mac 2011. This hands-on guide provides constructive advice and advanced, timesaving tips to help you produce compelling content that delivers—in print or on screen. Work smarter—and create content with impact! Create your own custom Office themes and templates Use tables and styles to help organize and present content in complex Word documents Leave a lasting impression with professional-quality graphics and multimedia Work with PowerPoint masters and layouts more effectively Design Excel PivotTables for better data analysis and reporting Automate and customize documents with Microsoft Visual Basic for Applications (VBA) and Open XML Formats Boost document collaboration and sharing with Office Web Apps Your companion web content includes: All the book’s sample files for Word, PowerPoint, and Excel Files containing Microsoft Visio samples—Visio 2010 is required for viewing

Hands-on IC3 prep, with expert instruction and loads of tools IC3: Internet and Computing Core Certification Global Standard 4 Study Guide is the ideal all-in-one resource for those preparing to take the exam for the internationally-recognized IT computing fundamentals credential. Designed to help candidates pinpoint weak areas while there's still time to brush up, this book provides one hundred percent coverage of the exam objectives for all three modules of the IC3-GS4 exam. Readers will find clear, concise information, hands-on examples, and self-paced exercises that demonstrate how to perform critical tasks. This useful guide includes access to a robust set of learning tools, including chapter review questions, a practice test environment, electronic flashcards, and author videos that explain complex topics. The certification consists of three separate exams: Computing Fundamentals, Key Applications, and Living Online. Candidates are given fifty minutes to answer forty-five questions, so rapid recall and deep understanding are critical to success. IC3: Internet and Computing Core Certification Global Standard 4 Study Guide provides expert instruction on everything candidates need to know, including hardware, software, networking, and more. Review operating system basics and common application features Understand troubleshooting and safe computing Learn basic word processing, spreadsheet, presentation, and database activities Study networking concepts, digital communication, and research fluency The exam includes both multiple choice and performance-based questions, and this guide provides plenty of both so candidates can get comfortable with both material and format. More than just a memorization tool, this book helps exam candidates understand the material on a fundamental level, giving them a greater chance of success than just going it alone. For the IC3 candidate who's serious about certification, IC3: Internet and Computing Core Certification Global Standard 4 Study Guide is the complete, hands-on exam prep guide.

Master word processing, spreadsheets, and presentations ahead of the IC3 exam IC3: Internet and Computing Core Certification Key Applications Study Guide is your ideal study guide when you want to focus on the Key Applications exam module in preparation for the IC3. This book covers common features and functions, word processing, spreadsheets, and presentations, all presented in a clear, concise style. Hands-on examples and self-paced exercises show you how to perform critical tasks needed to pass the exam, and the companion website offers a diverse set of study tools including the Sybex test engine, a preassessment test, hundreds of practice questions, videos, and access to over one hundred electronic flashcards. Test your skills and solidify your understanding of Key Applications for the IC3. Master the functions common to all programs, and the most common features Review the basics of word processing, with formatting and automation Understand spreadsheets, and how to manipulate data with formulas Brush up on the creation and formatting of simple presentations When you are serious about certification, IC3 provides the practice that inspires self-confidence.

Targets how to effectively and efficiently use data, text, and graphics from one Office application in another Office application. Features less emphasis on macros and programming and more focus on enhancements. Improved content and topical selection compared to previous editions.

Conquer Microsoft Office—from the inside out! Dive into the Microsoft Office application suite—and really put its productivity tools and services to work for you! This supremely well-organized reference packs hundreds of timesaving solutions, tips, and workarounds—all you need to make the most of Office's most powerful tools for productivity and decision-making. Renowned Office expert Joe Habraken offers a complete tour of Microsoft Office, with cutting-edge techniques and shortcuts for Word, Excel, PowerPoint, Outlook, Publisher, the 365 Online apps, and more. Discover how experts tackle today's key tasks—and challenge yourself to new levels of mastery. Create amazing content faster with Office's new features, tools, and shortcuts. Share, collaborate with, and secure Office files in the cloud. Organize, edit, and format complex documents with Microsoft Word. Build tables of contents, captions, indexes, and footnotes that automatically update. Efficiently enter and manage data in Excel workbooks, and format it for easy understanding. Build flexible, reliable Excel workbooks with formulas and functions—including XLOOKUP and other enhancements. Integrate data from external sources, including stock and currency data, and Wolfram curated knowledge. Transform data into insight with Pivot Tables and Excel charts — including new recommended charts and the Quick Analysis gallery. Quickly create presentations with PowerPoint themes, Reuse Slides, and Libraries. Build more impactful slides with advanced formatting, SmartArt, animation, transitions, media, and free stock images. Use PowerPoint tools to present more effectively—in person or online via Microsoft Teams. Systematically improve email productivity and security with Outlook. Manage appointments and tasks and quickly plan meetings.

The latest edition of one of the bestselling Microsoft Office books of all time! Spend less time figuring out Word, Excel, PowerPoint, Outlook, and Access and more time working on actual projects with this new edition of Office 2010 For Dummies. Filled with straightforward, friendly instruction, this book gets you thoroughly up to speed, and it actually makes doing Office work fun! First learn all the basics, then how to add more bells and whistles, including how to spice up your Word documents, edit Excel spreadsheets and create formulas, add sound to your PowerPoint presentation, and much more. Helps you harness the power of Microsoft Office 2010 and all of its new functionality; the book covers Word, Excel, PowerPoint, Outlook, and Access Explains and instructs in the straightforward, friendly, For Dummies style that makes instruction more accessible and skill-building easier Covers typing and formatting text in Word and spicing up your documents Shows you how to navigate and edit an Excel spreadsheet, create formulas, and chart and analyze Excel data Demonstrates how to create a PowerPoint presentation and add color, sound, and pictures 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 Be ready to take full advantage of Microsoft Office 2010 with this fun and easy guide.

The Microsoft Official Academic Courseware (MOAC) Office 2010 Series is the only Official Academic Course Material. The new and enhanced MOAC/ Microsoft Office 2010 System features Enhanced Wiley Desktop Editions as well as many other enhanced features designed to re-enforce workforce skills. The addition of animated tutorials in the Enhanced Wiley Desktop Editions and WileyPLUS courses, textbooks include additional materials on different skill levels to help users keep pace. WileyPLUS and an automatic Office assignment grader provides immediate feedback on every assignment, to help users practice and hone skills at their own pace. MOAC/ Microsoft Office 2010 System is built from the ground-up around the MOS® certification objectives- making it a great way to learn all the workforce-oriented tasks required for certification. The Test Bank now offers greater flexibility and provides more than 75 questions and 3 projects per lesson, as well as automated grading via OfficeGrader. Furthermore, the latest edition's use of color in screen captures allows users to follow on screen much easier, as screen captures will look the exact same as the application. Additional projects throughout the book helps users comprehend how a task is applied on the job. OfficeGrader functionality added to WileyPLUS provides immediate feedback on all homework, assignments, and projects and additional animated tutorials on key Office tasks provides additional help on difficult topics.