Documents, Presentations, and Workbooks: Using Microsoft Office to Create Content that gets Noticed

Description

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(R), and Excel(R) 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(R) 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(R) samples-Visio 2010 is required for viewing

CONTENTS:

Introduction; Who Will Benefit Most from This Book; What You Can Expect from This Book; Companion Content; Support for This Book; Questions and Comments; We Want to Hear from You; Stay in Touch; Acknowledgments; Part I: Document Essentials; Chapter 1: Welcome to Office 2010 and Office for Mac 2011; 1.1 Redefining Documents for a Connected World; 1.2 Introducing What’s New and Improved for Your Documents in Office 2010 and Office for Mac 2011; 1.3 Understanding the Office Open XML File Formats; 1.4 Understanding How the Office Programs "Think”: Documents 101; 1.5 Putting It All Together; Chapter 2: Collaborating and Sharing When and Where You Choose; 2.1 Moving Your Documents into the Cloud; 2.2 Exploring Office Web Apps: What Can You Really Do with Them?; 2.3 Working Together Without Waiting Your Turn; 2.4 Going Mobile; Chapter 3: Understanding Electronic Documents; 3.1 Creating Documents for Electronic Sharing; 3.2 Understanding How Font Choices Can Impact What Recipients See; 3.3 Securing the Private Information in Your Documents; 3.4 Managing Hidden Data; Chapter 4: Planning Your Documents; 4.1 Using the Best Tool for the Task; 4.2 Design Considerations; 4.3 Content Planning; 4.4 Linking Notes for Better Document Planning; Chapter 5: Doing More with Less Work: Key Cross-Program Features; 5.1 Introducing Document Themes; 5.2 Customizing Themes; 5.3 Exploring the Advanced Picture Formatting Tools; 5.4 Sharing Content Across Programs; 5.5 Using Microsoft Office As Your Toolbox; Part II: Word; Chapter 6: Building Easy-to-Manage, Robust Documents; 6.1 Staying in Control: Be the Boss of Your Documents; 6.2 Bringing Yourself to the Document: Using Document Logic; 6.3 Monitoring the Health of Your Document; 6.4 Creating Any Document with These Six Tools; Chapter 7: Working with Text; 7.1 Introducing What’s New for Text Formatting in Word 2010 and Word 2011; 7.2 Introducing the OpenType Typography Tools; 7.3 Introducing Text Effects: The New Generation of WordArt; 7.4 Using Font and Paragraph Formatting As Layout Tools; Chapter 8: Styles; 8.1 Understanding the Style Environment Today; 8.2 Creating Effective Style Sets; 8.3 Mastering Lists; 8.4 Working with Table Styles; 8.5 Managing Styles; Chapter 9: Tables; 9.1 Getting Organized; 9.2 Creating Tables That Work; 9.3 Creating Page Layouts Using Tables; 9.4 Formatting Financial Tables; 9.5 Managing Tables from Other Sources; Chapter 10: Managing Graphics; 10.1 Introducing the New and Improved Graphics Tools in Word 2010 and Word 2011; 10.2 Using the Best Program for the Graphic Task; 10.3 Understanding Differences for Working with Pictures and Objects; 10.4 Simplifying Graphic Layout; 10.5 Working in Publishing Layout View in Word 2011; Chapter 11: Sections; 11.1 Determining Whether You Need a Section Break; 11.2 Keeping Sections Simple; 11.3 Using Headers and Footers; Chapter 12: Dynamic Content; 12.1 Working with Content Controls; 12.2 Understanding Document Protection Options for Content Controls; 12.3 Using Document Property Quick Parts; 12.4 Understanding Building Blocks: The Evolution of Documents; 12.5 Working with Fields; Part III: PowerPoint; Chapter 13: Creating Presentations: From Theme to Master to Slide; 13.1 Exploring What’s New for PowerPoint Presentations in Office 2010 and Office for Mac 2011; 13.2 Understanding the Themes - PowerPoint Connection; 13.3 Creating Documents That Live in PowerPoint; 13.4 Setting Up a Presentation; 13.5 Working with Masters and Layouts; 13.6 Managing Slides and Slide Elements; Chapter 14: Creating Professional Presentation Graphics; 14.1 Exploring What’s New for Presentation Graphics; 14.2 Determining When to Use Office Art; 14.3 Determining the Best Diagram for Your Content; 14.4 Making Smart Choices with SmartArt; 14.5 Using Drawing Tools to Their Fullest; 14.6 Editing Shapes; 14.7 Getting Your Graphic into Other Programs; 14.8 Getting Your Vector Graphics into Microsoft Office; Chapter 15: Creating Multimedia Presentations; 15.1 Embedding and Managing Media; 15.2 Formatting Videos; 15.3 Editing Video and Audio in PowerPoint 2010; Chapter 16: Putting on a Show; 16.1 Using Slide Transitions; 16.2 Working with Animations; 16.3 Using Animation and Transitions Effectively; 16.4 Setting Up and Delivering Your Show; Part IV: Excel; Chapter 17: Data-Based Documents: Formatting and Managing Worksheets; 17.1 Formatting Documents That Live in Excel; 17.2 Streamlining Worksheet Formatting; 17.3 Treating Your Workbooks Like the Documents They Are; Chapter 18: Working with Data; 18.1 Crunching Numbers in Excel 2010 and Excel for Mac 2011: What’s New; 18.2 Using Tables As a Dataaaaaa Tool; 18.3 Creating Formulas - Working with Functions; 18.4 Simplifying Data Organization; 18.5 Using External Data; Chapter 19: Data Visualization; 19.1 Exploring What’s New for Conditional Formatting; 19.2 Increasing Your Options with Conditional Formatting; 19.3 Creating Sparklines: Power in a Small Package; Chapter 20: Charts; 20.1 Exploring Chart Creation Essentials; 20.2 Formatting Fighter-Pilot-Cool Charts; 20.3 Timesaving Techniques for Adding or Editing Chart Data; 20.4 Creating Advanced Chart Types; Chapter 21: Powerful Reporting, Easier Than You Think: A PivotTable Primer; 21.1 Why Use a PivotTable?; 21.2 Creating a PivotTable; 21.3 Managing PivotTables; 21.4 Formatting PivotTables; 21.5 Slicing and Dicing Your Data: Introducing the PivotTable Slicer for Excel 2010; 21.6 Using PivotCharts; 21.7 Creating and Formatting a PivotTable: A Quick Reference; Part V: Templates, Automation, and Customization; Chapter 22: The Many Faces of Microsoft Office Templates; 22.1 Understanding Template Types; 22.2 Creating a Template File; 22.3 Considering Best Practices for Word Templates; 22.4 Considering Best Practices for PowerPoint Templates; 22.5 Considering Best Practices for Excel Templates; 22.6 Sharing Themes; 22.7 The Office 2010 and Office 2011 Automation Story; Chapter 23: VBA Primer; 23.1 Understanding When and Why to Use VBA; 23.2 Introducing the VBA Language and Code Structure; 23.3 Using the Visual Basic Editor; 23.4 Writing, Editing, and Sharing Simple Macros; 23.5 Working with VBA: Next Steps; Chapter 24: Office Open XML Essentials; 24.1 Introducing XML Basics for Reading Your Documents; 24.2 Getting to Know the Office Open XML Formats; 24.3 Editing and Managing Documents Through XML; 24.4 Working with the Office Open XML Formats: Next Steps;