book

Microsoft® Office 2010 Plain & Simple

Name: Microsoft® Office 2010 Plain & Simple
Author: Katherine Murray
ISBN: 9780735647404

by Katherine Murray

June 2010

Beginner

384 pages

12h 19m

English

Microsoft Press

Read now

Unlock full access

Acknowledgments
1. About This Book
No Computerspeak!Useful Tasks …… And the Easiest Way to Do ThemA Quick OverviewWhat’s New in Office 2010?A Few AssumptionsA Final Word (or Two)
2. Working in Office 2010
What’s What in Office 2010?Microsoft Office 2010 ProgramsUsing the RibbonExplore the RibbonSet the Ribbon DisplayUsing Galleries and ListsExplore the GalleriesDisplay Lists and Choose CommandsUse the ToolsUsing Shortcut Menus and Dialog BoxesUse the Shortcut MenusWorking with Dialog BoxesUsing Only the KeyboardBrowse the Ribbon with Your KeyboardUse Keyboard ShortcutsMoving and Copying ContentCut or Copy InformationPaste Information Using Paste with Live PreviewCopy and Paste Multiple ItemsWorking with Backstage ViewFinding File and Program InformationPrinting a FileGetting HelpBrowse for HelpSearch for HelpSaving Your WorkSave the FileOffice’s File FormatsOther File Formats for Office Programs
3. Common Tasks in Office
Working with Old DocumentsConvert the DocumentInserting PicturesInsert a PictureDisplay a Specific File TypeChanging the Size of a PictureCrop ItSize ItEditing a PictureApply Artistic EffectsChange Contrast and ColorRotate ItEnhancing Your PicturesAdd Picture Styles and EffectsMaking Your Pictures PopRemove the Picture BackgroundAdding Clip ArtFind and Insert Clip ArtInserting ScreenshotsAdd a ScreenshotAdding ShapesDraw a ShapeFormatting a ShapeFormat the ShapeInserting the Date and TimeInsert the Date and/or TimeCreating Stylized TextCreate a WordArt ObjectFine-Tune the ResultInserting a SmartArt DiagramCreate a DiagramModify the DiagramTranslating Your TextChoose a Translation LanguageUse the Mini TranslatorResearching a SubjectDo Some Research
4. Viewing and Editing Text in Word
What’s Where in Word 2010?Creating a New DocumentStart Word and Enter Some TextComposing Different Types of DocumentsStart the DocumentWord’s ViewsPrint Layout ViewFull Screen Reading ViewWeb Layout ViewOutline ViewDraft ViewPrint PreviewReading a DocumentReadEditing TextSelect and Modify TextDiscovering the Many Ways to Work with TextNavigating Your DocumentUsing the Navigation PaneSearch and Find ObjectsReplacing TextReplace TextCorrecting Your Spelling and GrammarCorrect a Spelling ErrorCorrect a Contextual Spelling ErrorCorrect the GrammarAutomatically Correct Your MisspellingsCorrecting Text AutomaticallyAdd EntriesAdding Page NumbersInsert Page NumbersCo-Authoring in Word 2010Co-Authoring a DocumentConnecting with a Co-AuthorMarking and Reviewing Changes in a DocumentReview a DocumentReview ChangesComparing Documents Side by SideView the Documents
5. Formatting in Word
Controlling the Look: Themes, Styles, and FontsChoosing a Theme for Your DocumentChoose a ThemeFormatting Text with StylesApply a Quick Paragraph StyleApply Character Formatting StylesChoosing Styles from the Styles WindowView Your StylesChanging Character FontsChange the FontChange the Font SizeApplying Stylistic SetsSetting Paragraph AlignmentSet the AlignmentAdjusting Paragraph Line SpacingSet the Line Spacing Within a ParagraphSetting Spacing Between ParagraphsSet the Line Spacing Between ParagraphsIndenting a ParagraphIndent the ParagraphFormatting with TabsSet Your TabsAdding Emphasis and Special FormattingFormat the TextCopying Your FormattingCopy the FormattingCreating a Bulleted or Numbered ListCreate the ListFormatting a ListChange the FormatCreating a Table from ScratchCreate the TableUsing a Predesigned TableChoose a TableCreating a Table from TextConvert the TextAdding or Deleting Rows and ColumnsAdd a Row or Column to the TableDelete a Row or Column from the TableFormatting a TableFormat the TableImproving the Layout with HyphenationSet Automatic HyphenationLaying Out the PageSet Up a Standard PageCreating Special Page SetupsSet Up a Two-Sided DocumentSet Up a Bound DocumentCreating Headers and FootersCreate a Header and a FooterChanging Page Orientation Within a DocumentCreate a New SectionChange the Page OrientationFlowing Text into ColumnsChange the Number of ColumnsCreating SectionsStart a New SectionChange the Header and FooterWrapping Text Around a GraphicControl Text WrappingSorting Your InformationSort a TableSort a ListReorganizing a DocumentView a Document’s Outline
6. Working with Special Content in Word
Numbering Headings and LinesNumber the HeadingsNumber the LinesInserting a Cover PageInsert the Cover PageInserting Information with Additional ActionsContact a ColleagueInserting an EquationInsert the EquationAdding a Sidebar or a Pull QuoteInsert a Predesigned Text BoxInserting a WatermarkCreate the WatermarkCreating Footnotes and EndnotesInsert the Footnote or EndnoteChange the Reference MarkInserting a CitationAdd Existing CitationsInsert a CitationCreating a Table of ContentsSet the Outline TextPrinting an EnvelopeAdd the AddressPrinting a Mailing LabelPrint the LabelMail Merge: The Power and the PainIt’s More than LettersSetting Conditional ContentCreating a Form LetterSet Up Your LetterSpecify the Data to Be MergedFinalizing Your DocumentPrepare Your Document
7. Working in Excel
What’s Where in Excel?Excel 2010 BasicsUsing a Predefined WorkbookOpen and Use a TemplateChoosing a Theme for Your WorksheetApply a ThemeEntering the DataEnter Your DataEditing the DataReplace the DataEdit the Existing DataFormatting CellsFormat Some CellsSelecting Cells in the WorksheetFormatting NumbersFormat Some NumbersMoving, Copying, and Pasting DataMove DataCopy or Cut DataCopy and Paste Data to Adjacent CellsAdding and Deleting Columns and RowsAdd a ColumnAdd a RowDelete a Column or a RowDelete Some or All Content of CellsHiding Columns and RowsHide Columns or RowsReveal Hidden Columns or RowsCreating a Data SeriesCreate a SeriesFormatting Cell DimensionsSet the Column WidthSet the Row HeightAdjust the Height or Width to Fit the ContentOrganizing Your WorksheetsName Your WorksheetsChange Their OrderInsert a WorksheetDelete a WorksheetPreparing for PrintingSet Page DimensionsSet the Header and FooterPrinting a WorksheetSpecify the Print AreaRepeat Row and Column TitlesCheck the Layout and Print the WorksheetAdding and Viewing CommentsCreate a CommentReview the CommentsWorking with the Excel Web AppUse the Excel Web App
8. Analyzing and Presenting Data in Excel
Applying Conditional Formatting to CellsHighlight Specific CellsAdd Data BarsApply Icon SetsCustomizing Conditional FormattingCreate a RuleCell References, Formulas, and FunctionsA Little More About Cell ReferencesAdding SparklinesCreate SparklinesEdit SparklinesIntroducing FormulasUnderstanding FunctionsDoing the MathCalculate a ValueCalculate the Value of CellsSumming the DataSum the NumbersMaking Calculations with FunctionsFind a FunctionAdd ArgumentsCreating a Series of CalculationsCreate the SeriesTroubleshooting FormulasCheck for Formula ErrorsCreating a TableCreate a TableUse the TableSorting the DataConduct an Alphabetic or a Numeric SortFiltering the DataFilter the DataSeparating Data into ColumnsSeparate the DataCreating SubtotalsCreate the SubtotalsSummarizing the Data with a PivotTableCreate the PivotTableUse the PivotTableAdding SlicersCreate a SlicerReviewing the DataFreeze the Columns and/or RowsView Multiple SectionsThe Anatomy of a ChartCharting Your DataCreate a ChartComplete the LayoutFormatting a ChartChange the Chart StyleChange the ThemeFormat an ElementCustomizing a ChartChange a Data-Series Chart
9. Creating a PowerPoint Presentation
What’s Where in PowerPoint?Ways to View Your PresentationCreating a PresentationChoose a TemplateSet Up the PresentationSet the Page BackgroundFormat the BackgroundEntering ContentAdd Your ContentFormatting a SlideFormat the ContentEditing a PresentationChange the Content of the SlidesChange the Order of the SlidesAdding Headers and FootersAdd the FooterReusing SlidesReuse a SlideModifying the Default LayoutModify the LayoutCreate a New LayoutInserting a TableCreate the TableTurning Text into SmartArtCreate the GraphicApplying WordArt Styles to TextConvert the TextAnimating Items on a SlideAnimate a Slide ElementUse the Animation PainterSet the Animation TriggerCustomizing Your AnimationCustomize the AnimationAdding an Action to a SlideAssign an ActionAdding and Editing VideoInsert a Video from a FileEdit Video Clips in PowerPointApply Video StylesAdding Sound to Your SlidesInsert a SoundSetting Slide TransitionsSet the TransitionsCreating a Photo AlbumCreate the Album

10. Presenting a PowerPoint Slide Show
Exploring Your Presentation OptionsPreparing for the Perils of PresentationRecording a NarrationNarrate Your PresentationTiming a PresentationTime the PresentationAdding Speaker NotesCreate the NotesSet Up and Print the NotesCustomizing the PresentationSet Up the ShowReviewing a PresentationReview the PresentationCreating Different Versions of a Slide ShowCreate a Custom Slide ShowPrinting HandoutsCreate the HandoutsRunning a Slide ShowRun the PresentationUsing Ink While You PresentSharing a PresentationSave the Show to SharePointPublishing Your SlidesAdd Slides to a Slide LibraryPackaging Your PresentationPackage Your PresentationCreating Pictures of Your SlidesCreate the PicturesSaving Your Presentation as a VideoCreate a VideoBroadcasting Your PresentationBroadcast a PresentationChanging Slide-Show SettingsChange the Settings
11. Working with Messages in Outlook
What’s Where in Outlook Messages?A Look at the New Message WindowOverview of the Message Window Insert TabSending E-mailAddress an E-mail MessageType Your Message Subject and TextReceiving and Reading E-mailLocate New MessagesOpen MessagesReplying to and Forwarding a MessageReply to an E-mail MessageForward an E-mail MessageStaying in Touch with Outlook Social ConnectorAdding a Site to Outlook Social ConnectorViewing Social ContactsSending or Receiving a FileAttach a FileOpen an AttachmentFormatting E-mail MessagesUse a Rich Text or HTML Message FormatAdd Formatting to a MessageManaging Messages with Quick StepsUse a Quick Step to Reply to and Delete a MessageCreate a New Quick StepMove Messages Between FoldersSigning Your E-mailCreate a SignatureReading RSS ItemsAdd an RSS FeedRead RSS FeedsSetting Up E-mail AccountsAdd an E-mail Account
12. Organizing with Outlook
A Quick Look at Outlook’s Organizing AbilitiesCalendarContactsSetting an AppointmentAdd an Appointment to the CalendarAdd Appointment DetailKeeping Track of Your ScheduleUse the Calendar ViewUse Schedule ViewUse the To-Do BarSharing CalendarsShare Your CalendarShare Your Available TimesViewing Your Group’s ScheduleCreate a New GroupView and Manage a Group ScheduleScheduling a MeetingCreate a Meeting in a Block of TimeSpecify a Meeting Date and Time ManuallyManaging Your ContactsUse E-mail Message InformationUse the Contact WindowKeeping Track of Your TasksCreate a Task QuicklySet the Task Name and Due DateOpen the Task Item WindowAssigning TasksAssign a TaskTacking Up NotesAdd a NoteCreating and E-mailing Contact Business CardsCreate a Contact Business CardE-mail a Contact Business Card
13. Creating a Publication in Publisher
Exploring the New Look of Publisher 2010Understanding Publisher ObjectsStarting with a TemplateUse a TemplateCreating a Publication from ScratchStart the PublicationSet Up the Look of the PublicationAdding TextAdd TextFlowing Text Among Text BoxesFlow the TextTweaking Your TextImprove the Look of the TextAdd Text EffectsChoose a Ligature Style and a Stylistic SetInserting and Modifying a PictureInsert a PictureModify the PictureAdding a TableInsert the TableRepeating Objects on Every PageAdd the Repeating ObjectsAdding Building BlocksInsert a Building BlockArranging Objects on the PageSet Up Your GuidesPosition an Object at an Exact LocationStacking and Grouping ObjectsArrange and Group the ObjectsFlowing Text Around an ObjectSet the Text WrappingReusing ContentCreate Your Own Page PartInserting Your Contact InformationAdd Your Business InformationChecking Your PublicationCheck the DesignSending a Publication as E-mailE-mail Your PublicationPrinting Your PublicationThe Final Step: Print It!
14. Organize and Share Information in OneNote 2010
What’s Where in OneNote?Exploring the OneNote WindowOneNote Basics: Gathering Your ThoughtsCreating a OneNote NotebookCreate a New NotebookAdding and Working with SectionsStart a New SectionCreate a Section GroupInserting and Working with Notes PagesCreate a Page Based on a TemplateSet a Default TemplateCreate a Blank PageInking in OneNoteUsing Ink and Draw ToolAdding a ShapeAdding Audio NotesRecord AudioPlaying Your Audio NoteGrabbing Web ClippingsClip Web ContentSharing Notes in Word and PowerPointUse Linked Notes in WordWork with Linked Notes in PowerPointSaving Outlook Data to OneNoteShare a Message with OneNoteWorking with Side Notes and Unfiled NotesCreate a Side NoteView and Merge Unfiled Notes
15. Working in Access
What’s Where in Access?Exploring the Access WindowTaking a Look at Datasheet ViewReviewing Report ViewDatabases: A Simple ApproachWays to Store DataBasic Database ConceptsAccess 2010 and Relational TablesCreating a Database from a TemplateCreate a Database from a TemplateWorking with a TemplateUsing an Existing DatabaseOpen a Recently Used Database FileOpen an Existing Database FileAdding a Data TableCreate a New TableAdding and Changing Fields and RecordsRename FieldsSet the Data Type and FormatAdd and Remove Fields and RecordsAdding Data to a TableSelect DataDelete DataUndoing OperationsCopy and Paste DataImporting DataCopy a Table from Another DatabaseExporting DataExport Table DataDefining Table RelationshipsDefine a RelationshipCreating a FormCreate a Simple FormCreate a Navigation FormCreating a Report from the DataStep Through the Report WizardFormatting ReportsFormat a Report Using ThemesAdd Conditional Formatting to a ReportQuerying Information from Your Data TablesCreate a Detailed QueryAnalyzing Data with a PivotChartStep Through the PivotChart WizardChange a PivotChart Chart Type
16. Customizing and Securing Office
Customizing the RibbonCreate and Rename a New TabRename and Add Tools to the GroupCustomizing the Quick Access ToolbarAdd or Remove Items Common to the Quick Access ToolbarControl the CustomizationCustomizing the Work AreaShow or Hide Items on the Status BarChange the Window’s Color SchemeChange What’s ShownCustomizing Your EditingAdjust Program OptionsChanging Your User InformationChange Your Name and AddressCustomizing the Spelling and Grammar CheckersSpecify What’s to Be CheckedCustomizing Your Spelling DictionariesAdd a DictionaryChanging the Location and Type of Saved FilesChange the File Locations and FormatsUnderstanding Security in Office 2010Working with the Trust CenterChanging File ValidationSet File TypesChoosing What’s Displayed in Protected ViewSet Protected View SettingsPassword Protecting a FileAdd a PasswordLimiting File ChangesSet File PermissionsRecovering Unsaved Versions of a FileRecover Unsaved FilesSetting AutoRecover OptionsChoose AutoRecover OptionsSigning a Document or Workbook with a Digital SignatureSet Up the SignatureSign the DocumentSetting Macros, Add-Ins, and ActiveX ControlsModify the SettingsChecking File CompatibilityRun the Check
Index
About the Author
Copyright

Overview

Get the fast facts that make learning Office 2010 plain and simple! This colorful, no-nonsense guide uses easy-to-follow steps and screenshots, and clear, concise language to show the simplest ways to get things done with Microsoft Word, Excel, Outlook, PowerPoint, Access, Publisher, and OneNote.

Here's WHAT You'll Learn

Create documents, Web pages, and other publications

Organize your e-mail, calendar, contacts and tasks

Build spreadsheets to analyze and visualize data

Set up a simple database

Capture notes with ink, voice or text

Here's HOW You'll Learn It

Jump in wherever you need answers

Easy-to-follow STEPS and SCREENSHOTS show exactly what to do

Handy TIPS teach new techniques and shortcuts

Quick TRY THIS! Exercises help you apply what you learn right away

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: 9780735647404Purchase book

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills