Krieger S. Documents, Presentations, and Workbooks: Using Microsoft Office to Create Content That Gets Noticed

Microsoft Press, 2011. - 864 p. - ISBN: 073565199XThis how-to guide provides constructive expert advice and best practices for creating professional-looking documents, presentations, and spreadsheets in Microsoft Word, PowerPoint, Excel, and Office 2010 or Office for Mac 2011 to help you work smarter, more efficiently, and spend more on getting your work done. less time! At your service plan and design presentations and reports, the best ways to use templates and themes in Word, PowerPoint and Excel. Learn how to use tables and styles to make complex documents more presentable, creating a lasting impression with professional-quality graphics and media.Get expert techniques and best practices for creating rofessional-looking documents, slide presentations, and spreadsheets – and apply these skills with Microsoft Word, PowerPoint, and Excel in Office 2010 or Office for Mac 2011. This practical guide provides constructive advice and timesaving tips to help you produce compelling content that delivers. You'll work smarter, not harder! Plan and design presentations and reports that get your message across Determine the best ways to use templates and themes in Word, PowerPoint, and Excel. Learn how to use tables and styles to make complex documents more presentable. Make a lasting impression with professional-quality graphics and media Use proven tips and shortcuts to get more from slide masters and layouts Design PivotTables for more effective data analysis and reporting Customize your content with Microsoft Visual Basic for Applications (VBA).Getting Started.
Discovering Office Common Features.
Opening Office Programs.
Exploring the Backstage View.
Working with Files.
Previewing with Live Preview.
Customizing Applications.Word.
Getting Started with Word.
Exploring the Word Window.
Moving Around the Screen.
Editing Text.
Moving and Copying Text.
Using Undo and Repeat.
Displaying Non-Printing Symbols.Making a Word Document Look Good.
Selecting Text Attributes.
Formatting Paragraphs.
Copying Formatting.
Working with Lists.
Working with Themes.
Using Quick Styles.
Managing Word Pages.
Creating Page Breaks.
Using Section Breaks.
Managing Page Layouts.
Viewing a Document.
Adding Headers and Footers.Working with Columns and Tables.
Using Columns.
Working with Tables.
Adding an Excel Table to a Word Document.Using Word for Mail Merge.
Generating a Single Envelope.
Creating Labels.
Using Mail Merge.Discovering Word Tools.
Employing Tools for Quality.
Applying Tools for Speed.
Creating Footnotes and Endnotes.
Working with Outlines.
Keeping Documents Secure.
Printing and Publishing.Excel.
Creating a Basic Worksheet.
Exploring the Excel Window.
Entering Excel Data.
Learning Selection Techniques.
Editing a Worksheet.
Working with Range Names.
Using Data Validation.Working with Formulas and Functions.
Working with Formulas.
Using Excel Functions.
Troubleshooting Errors.Making Your Worksheet Look Good.
Changing Cell Formats.
Working with Alignment and Spacing.
Adding Borders and Shading.
Discovering Formatting Shortcuts.
Conditional Formatting.Managing Large Amounts of Data.
Working with Multiple Worksheets.
Managing Worksheet Views.
Sorting Data.
Filtering Data.Setting Security and Printing Options.
Keeping Workbooks Secure.
Checking for Errors.
Using Find and Replace.
Adjusting Page Layout.
Working with Headers and Footers.
Printing Your Worksheet.Generating Excel Charts.
Creating a Basic Chart.
Inserting a Chart.
Changing the Chart Options.
Working with Sparklines.
PowerPoint.
Creating a PowerPoint Presentation.
Starting with the PowerPoint Basics.
Adding New Slides.
Adding Slide Objects.
Working with Outlines.Editing Your Presentation.
Changing Views.
Modifying Slide Layouts.
Adding Multimedia and WordArt to Your Presentation.
Managing Objects.Formatting Your Presentation.
Changing Views.
Changing Theme Options.
Working with Slide Masters.
Creating Speaker Notes.
Finishing Your Presentation.Presenting Your Presentation.
Adding Transitions and Animations.
Running Your Presentation.Access.
Creating an Access Database.
Understanding Database Terms.
Exploring Access.
Creating a New Database.
Working with Records.Modifying an Access Database.
Designing Table Appearance.
Modifying Table Structure.
Modifying a Form.
Part VI Outlook.Communicating with Outllook E-Mail.
Looking at the Outlook Window.
Working with E-Mail.
Working with E-Mail Attachments.Working with Outlook Contacts.
Exploring Your Contacts Folder.
Printing Contact Information.Using the Outlook Calendar.
Exploring the Calendar.
Working in the Calendar Folder.Tracking Tasks with Outlook.
Working with Tasks.
Exploring To-Do’s.
Creating Notes.
Using the To-Do Bar.Creating a Predesigned Publisher
Publication.
Selecting a Publication Template.
Viewing the Publisher Window.
Customizing Your Publication. Presenting View Options.
Working with Text.
Working with Graphics.Designing Your Own Publication.
Starting Your Publication.
Working with Frames.
Working with Text.
Working with Pages.
Preparing for Printing.