book

Documents, Presentations, and Workbooks: Using Microsoft® Office to Create Content That Gets Noticed

Name: Documents, Presentations, and Workbooks: Using Microsoft® Office to Create Content That Gets Noticed
Author: Stephanie Krieger
ISBN: 9780735660083

by Stephanie Krieger

April 2011

Beginner

864 pages

27h 59m

English

Microsoft Press

Read now

Unlock full access

Documents, Presentations, and Workbooks: Using Microsoft® Office to Create Content That Gets Noticed
Dedication
Introduction
Who Will Benefit Most from This BookAdditional Resources for Reviewing the BasicsWhat You Can Expect from This Book
Companion Content
Support for This Book
Questions and CommentsWe Want to Hear from YouStay in Touch
Acknowledgments
I. Document Essentials
1. Welcome to Office 2010 and Office for Mac 2011
Redefining Documents for a Connected WorldIntroducing What’s New and Improved for Your Documents in Office 2010 and Office for Mac 2011Explore What’s New Across Both VersionsExplore Your EnvironmentDiscovering the Office 2010 InterfaceDiscovering the Office 2011 InterfaceExplore Key Exclusive Features in Office 2010Explore Key Exclusive Features in Office for Mac 2011Explore More New Word FeaturesExplore More New PowerPoint FeaturesExplore More New Excel FeaturesExplore What’s New and Improved Across Both VersionsUnderstanding the Office Open XML File FormatsUnderstand the File TypesChoose Your FormatIn Office 2010In Office 2010In Office 2011Understand File StructureUnderstanding How the Office Programs “Think”: Documents 101Benefit by Being LazyPut Less Work In = Get Better Results OutPlanning Your DocumentsUse Microsoft Office Effectively: Choose the Best Tools for the TaskWord: The OrganizerPowerPoint: The Efficiency ExpertExcel: The LogicianPutting It All Together
2. Collaborating and Sharing When and Where You Choose
Moving Your Documents into the CloudIntroducing SkyDriveIntroducing SharePoint 2010From an Office 2010 ProgramFrom an Office 2010 ProgramFrom an Office 2011 ProgramExploring Office Web Apps: What Can You Really Do with Them?Understanding the Benefits of Office Web AppsGetting Started with Office Web AppsEditing Documents in Word Web AppEditing Presentations in PowerPoint Web AppEditing Workbooks in Excel Web AppEditing Notebooks in OneNote Web AppWorking Together Without Waiting Your TurnGoing MobileIntroducing Office Mobile for Windows Phone 7Accessing Files for Use with Office MobileExploring What You Can Do with Office MobileIntroducing OneNote Mobile for iPhoneUnderstanding Office Web Apps Mobile: The Office Mobile Viewers
3. Understanding Electronic Documents
Creating Documents for Electronic SharingConsider the Importance of Document ConstructionMaking a Professional ImpressionEnsuring That What You Send Is What They SeeEnsuring Easy Editing OnlineUnderstanding How Font Choices Can Impact What Recipients SeeShare Files Without Concern About FontsSecuring the Private Information in Your DocumentsKnow the Simple Truth About Document Metadata and Hidden DataDefining MetadataDefining Hidden DataManaging Hidden DataUsing the Document InspectorUsing the Document InspectorKnowing What Data Is in Your DocumentsSaving to the PDF or XPS File FormatsIn the Office 2010 ProgramsIn the Office 2011 ProgramsUsing Options in Windows 7 to Manage Personal Information

4. Planning Your Documents
Using the Best Tool for the TaskUsing WordUsing PowerPointUsing ExcelUsing Programs TogetherDon’t Forget About OneNoteDesign ConsiderationsHow Will Your Document Be Delivered?Focusing On the ContentMaking the Right Statement About You and Your BusinessContent PlanningMaking Choices About ContentUsing Layout and Design to Organize Your ContentProgram-Specific Layout ConsiderationsLinking Notes for Better Document Planning
5. Doing More with Less Work: Key Cross-Program Features
Introducing Document ThemesUnderstanding the Importance of ThemesExploring Theme ElementsExplore Theme ColorsCan You Control the Tint and Shade Percentages in the Theme Colors Palette?Explore Theme FontsExplore Theme EffectsUnderstanding How Themes WorkCustomizing ThemesMixing and Matching to Create Your Own ThemeCreating a Complete Custom ThemeCreate Custom Theme ColorsCreate Custom Theme FontsShare Custom ThemesExploring the Advanced Picture Formatting ToolsAdjusting ImagesCropping ImagesUsing Picture Styles and EffectsReplacing and Managing ImagesSharing Content Across ProgramsUsing Microsoft Office As Your Toolbox
II. Word
6. Building Easy-to-Manage, Robust Documents
Staying in Control: Be the Boss of Your DocumentsExploring the Three Levels of Word FormattingFont FormattingParagraph FormattingSection FormattingUsing Reveal Formatting to Manage the Three Levels of FormattingWorking with Objects and StoriesThe Story Behind Word StoriesStories, Objects, and FormattingFinding the Simple Approach to Any TaskBringing Yourself to the Document: Using Document LogicWorking with Formatting MarksIn Word 2010In Word 2010In Word 2011Using Views EffectivelyMonitoring the Health of Your DocumentRecognizing Document CorruptionUsing Open And RepairCreating Any Document with These Six Tools
7. Working with Text
Introducing What’s New for Text Formatting in Word 2010 and Word 2011Introducing the OpenType Typography ToolsUnderstanding the Difference Between Feature and Feature SupportExploring the OpenType Typography Features Available in WordGet Connected with LigaturesGet Stylish with Stylistic SetsGet Analytical with Number Forms and Number SpacingGet the Details with Contextual Alternates and KerningIntroducing Text Effects: The New Generation of WordArtDifferentiating Between Text Effects and WordArtUsing Font and Paragraph Formatting As Layout ToolsUsing Character Spacing and Positioning to Adjust LayoutUsing Line and Paragraph Spacing to Simplify LayoutUsing Line and Page Break Options to Manage Layout
8. Styles
Understanding the Style Environment TodayExploring the Styles PaneCreating Effective Style SetsConsidering Built-In vs. Custom StylesBenefits of Using Character StylesMaking Effective Use of Base and Following StylesUsing Base StylesUsing Style for the Following ParagraphUnderstanding Linked StylesCreating Styles That Make User-Friendly DocumentsUsing Quick Style SetsMastering ListsUnderstanding ListsSimplifying Your Work with ListsUsing Key Best Practices to Create and Manage ListsDemystifying the Apparent Madness of ListsSharing Lists Between Documents and TemplatesWorking with Table StylesCreating Table StylesSetting a Default Table StyleManaging StylesUsing the Manage Styles Dialog BoxInspecting Your Styles
9. Tables
Getting OrganizedCreating Tables That WorkChoose Between Paragraph Formatting and Table FormattingParagraph Spacing vs. Row HeightParagraph Spacing vs. Cell MarginsHow Paragraph Spacing and Vertical Cell Alignment Are RelatedParagraph Indents vs. Cell MarginsParagraph Borders vs. Cell BordersParagraph Styles vs. Table StylesWhich Paragraph Formatting Option Is Best?Use Table Properties to Simplify Table SetupSetting Column and Table Widths As a Percentage of the WholeIndenting TablesSetting Cell OptionsSimplify Table Behavior with AutoFit OptionsCreating Page Layouts Using TablesCreate an Effective Host TableUnderstand Nested Tables vs. Text Wrap Around TablesManage Nested TablesFormatting Financial TablesDecimally Align Numbers and Currency SymbolsManaging Tables from Other SourcesConsiderations for Tables That Originate in ExcelConsiderations for Tables That Originate on the Web
10. Managing Graphics
Introducing the New and Improved Graphics Tools in Word 2010 and Word 2011Using the Best Program for the Graphic TaskUnderstanding Differences for Working with Pictures and ObjectsLinking and Embedding Objects Between Microsoft Office ProgramsConverting Embedded or Linked Objects to PicturesEditing Linked and Embedded ObjectsDetermining the Best Picture Type for Your GraphicSimplifying Graphic LayoutUsing the In Line With Text LayoutIn Word 2010In Word 2010In Word 2011Recognizing Graphic LayoutUsing Table Cells As Graphic PlaceholdersUsing Text Wrap When You MustWorking in Publishing Layout View in Word 2011Using the Features You Already KnowUsing Features Designed Just for Publishing Layout ViewSharing Publishing Layout View Documents Online and Across Platforms
11. Sections
Determining Whether You Need a Section BreakKnowing When to Use a Section BreakKnowing When Not to Use a Section BreakKeeping Sections SimpleUnderstanding How Section Formatting Is StoredUnderstanding Section Break TypesUsing Headers and FootersWorking with Page NumbersManaging the Different First Page and Different Odd & Even Pages Headers and FootersUnderstanding Link To PreviousSimplifying Book-Style Page LayoutCreating Watermarks
12. Dynamic Content
Working with Content ControlsTypes of Content ControlsUsing Content ControlsCreating Content ControlsFormatting Controls and Editing PropertiesEditing Control PropertiesWorking in Design ModeFormatting Placeholder and User-Edited Control ContentNesting ControlsUnderstanding Document Protection Options for Content ControlsGrouping Content ControlsUsing Restrict Editing OptionsUsing Document Property Quick PartsUnderstanding Building Blocks: The Evolution of DocumentsInserting Building Block EntriesCreating Your Own Building BlocksManaging Building BlocksWorking with FieldsUnderstanding Field ConstructionCreating FieldsCustomizing FieldsLISTNUM FieldsSTYLEREF FieldsEditing FieldsConverting Fields to Static ResultsNesting Fields
III. PowerPoint
13. Creating Presentations: From Theme to Master to Slide
Exploring What’s New for PowerPoint Presentations in Office 2010 and Office for Mac 2011Sharing More EasilySimplifying Slide EditingUnderstanding the Themes–PowerPoint ConnectionExploring the Evolution of PowerPoint Design TemplatesExamining Theme StructureCreating Documents That Live in PowerPointSetting Up a PresentationControl the Layout—Don’t Let It Control YouManaging Page SetupUnderstanding Slide ResolutionUnderstanding Screen Size vs. Slide SizeManaging Slide OrientationUnderstanding Headers and FootersWorking with Masters and LayoutsExploring the Master–Layout RelationshipManaging Masters and LayoutsCustomizing Slide MastersCustomizing and Creating Slide LayoutsCreating Effective Slides and LayoutsManaging Slides and Slide ElementsWorking with ChartsWorking with TextExploring Paragraph FormattingExploring Font FormattingWorking with PowerPoint TablesWorking with Embedded ObjectsManaging SlidesUsing Slide Sections to Organize PresentationsUsing the Compare And Merge Feature
14. Creating Professional Presentation Graphics
Exploring What’s New for Presentation GraphicsDetermining When to Use Office ArtDetermining the Best Diagram for Your ContentMaking Smart Choices with SmartArtCreating a SmartArt DiagramSelecting a Diagram LayoutUnderstanding and Using SmartArt Styles and FormattingEditing SmartArt Diagram ContentUsing Drawing Tools to Their FullestGetting It “Perfect” Is Easier than “Close Enough”Accessing and Managing ShapesUsing the Selection And Visibility Pane in Office 2010Using Dynamic Reordering in PowerPoint 2011Formatting Shapes EffectivelySizing and Positioning ObjectsOrganizing Content Precisely with the Arrange ToolsUsing Drawing GuidesEditing ShapesChanging ShapesEdit Points to Create Virtually AnythingGetting Your Graphic into Other ProgramsGetting Your Vector Graphics into Microsoft Office
15. Creating Multimedia Presentations
Embedding and Managing MediaInsert Video or Audio into Your PresentationIn PowerPoint 2010In PowerPoint 2010In PowerPoint 2011Work with Linked Media FilesInsert a Video from a Website in PowerPoint 2010Compress Media and Improve CompatibilityCompress Media in PowerPoint 2010Optimize Media Compatibility in PowerPoint 2010Compress Media and Improve Compatibility on Your OwnCreate a Video of Your PresentationCreate a Video Using External ToolsFormatting VideosAdjust and Format Video Right on the SlideCreate Better Slides Using Video Poster FrameEditing Video and Audio in PowerPoint 2010Trim Video and Audio FilesUse Bookmarks to Navigate or Choreograph Your Media
16. Putting on a Show
Using Slide TransitionsWorking with AnimationsIntroducing Animation Painter in PowerPoint 2010Understanding Bookmarks and TriggersUsing Animation and Transitions EffectivelySetting Up and Delivering Your ShowPresenting Your Show
IV. Excel
17. Data-Based Documents: Formatting and Managing Worksheets
Formatting Documents That Live in ExcelStreamlining Worksheet FormattingWorking with Themes in ExcelUsing Cell StylesFormatting Ranges As TablesIn Excel 2010In Excel 2010In Excel 2011Managing Page Layout EffectivelyEditing Headers and FootersTreating Your Workbooks Like the Documents They Are
18. Working with Data
Crunching Numbers in Excel 2010 and Excel for Mac 2011: What’s NewExcel 2010Excel 2011Using Tables As a Data ToolCreating Formulas—Working with FunctionsIf There’s Logic to It, Excel Functions Can Do ItNesting FormulasDefining Names and Using Structured ReferencesCreating and Using Defined NamesUsing Structured References to Table ContentManaging FormulasTracking Down Errors—Formula AuditingAvoiding Errors and Managing Data with Data ValidationSimplifying Data OrganizationUsing External Data
19. Data Visualization
Exploring What’s New for Conditional FormattingIncreasing Your Options with Conditional FormattingSetting Additional Data Visualization OptionsCustomizing Icon SetsData Bar Formatting EssentialsManaging the Rules in Your WorkbookCreating Sparklines: Power in a Small PackageUnderstanding Sparkline TypesAdding Sparklines to Your DataManaging SparklinesCustomizing SparklinesFormatting SparklinesCustomizing Axes
20. Charts
Exploring Chart Creation EssentialsFormatting Fighter-Pilot-Cool ChartsUsing Chart Quick StylesCustomizing Chart ElementsChart TextAxesGridlinesChart and Axis TitlesCombining Chart TypesUsing Secondary AxesAdding Drawing Objects to ChartsTimesaving Techniques for Adding or Editing Chart DataReorder Data Series and Set Data Display OptionsCreating Advanced Chart TypesCreating Bubble ChartsCreating Price/Volume Charts
21. Powerful Reporting, Easier Than You Think: A PivotTable Primer
Why Use a PivotTable?Creating a PivotTableSetting Up Your DataCreating the TableUnderstanding PivotTable Field AreasFilter PivotTable FieldsManaging PivotTablesWorking with Field SettingsRemove SubtotalsIn Excel 2010In Excel 2011Use the Field Settings Dialog BoxCreate Calculated FieldsModifying Table OptionsFormatting PivotTablesSlicing and Dicing Your Data: Introducing the PivotTable Slicer for Excel 2010Create a SlicerCreate a SlicerExploring Slicer EssentialsConnect Multiple PivotTables to a SlicerUsing PivotChartsCreating and Using a PivotChartManaging the Connection Between PivotTable and PivotChartCreating and Formatting a PivotTable: A Quick Reference
V. Templates, Automation, and Customization
22. The Many Faces of Microsoft Office Templates
Understanding Template TypesCreating a Template FileUse Content TemplatesUse Design TemplatesUse Form TemplatesUnderstand Feature-Specific TemplatesCreate Building BlocksCreate Quick Style SetsCreate Excel Chart TemplatesDifferentiate Between Automated Templates, Global Templates, and Add-InsSave a Global TemplateSave an Add-InLocate Template FoldersAccess User TemplatesAccess Built-in and Master TemplatesConsidering Best Practices for Word TemplatesConsidering Best Practices for PowerPoint TemplatesConsidering Best Practices for Excel TemplatesSharing ThemesThe Office 2010 and Office 2011 Automation Story
23. VBA Primer
Understanding When and Why to Use VBAIntroducing the VBA Language and Code StructureRecording MacrosReading VBA CodeUnderstanding Statements, Procedures, Modules, and ProjectsUsing the Visual Basic EditorIntroducing the Code WindowIntroducing Project ExplorerIntroducing the Properties WindowSetting Up Your WorkspaceWriting, Editing, and Sharing Simple MacrosCreating Modules and Starting ProceduresLearning the Language of Objects, Properties, and MethodsIntroducing Object ModelsUsing Auto ListsUnderstanding VariablesIntroducing Variable Data TypesDeclaring VariablesSharing Variables Throughout a ProjectUnderstanding Document Variables and Data Storage OptionsWorking with Object Model Member ArgumentsUsing ConstantsUnderstanding Collection ObjectsGrouping StatementsLooping CodeUsing For Each…Next and For…Next LoopsUsing Do LoopsUsing Conditional StructuresCreating If StatementsCreating Select Case StatementsUsing OperatorsIntroducing Message Boxes and Input BoxesUsing Message BoxesUsing Input BoxesRunning One Macro from AnotherSetting Macros to Conditionally Stop Executing CommandsRunning Macros and Compiling ProjectsCompiling ProjectsGetting HelpSaving and Sharing MacrosSharing ProjectsWorking with VBA: Next Steps
24. Office Open XML Essentials
Introducing XML Basics for Reading Your DocumentsReading a Markup LanguageUnderstanding Key TermsSelecting Your Tools for Editing Office Open XMLGetting to Know the Office Open XML FormatsBreaking In to Your DocumentUnderstanding the Office Open XML File StructureTaking a Closer Look at Key Document PartsBuilding a Basic Word Document from ScratchCreate the Folder StructureCreate the Main Document FileCreate the Content_Types FileCreate the .rels FileCompile and Open Your New DocumentAdd More Content Types, Document Parts, and RelationshipsFind and Fix ErrorsEditing and Managing Documents Through XMLUnderstanding Units of MeasureEditing Text and FormattingEdit Text and Settings in document.xmlAdd Formatting to Text in document.xmlEdit Styles in styles.xmlWorking with the Office Open XML Formats: Next Steps
Index
About the Author
Copyright

Overview

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

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.

Julian F.

Head of Cybersecurity

I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.

Addison B.

Field Engineer

I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.

Amir M.

Data Platform Tech Lead

I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.

Mark W.

Embedded Software Engineer

Publisher Resources

ISBN: 9780735660083Purchase book

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills