book

Office 2013: The Missing Manual

by Nancy Conner, Matthew MacDonald

June 2013

Beginner

1048 pages

32h 18m

English

O'Reilly Media, Inc.

Read now

Unlock full access

Office 2013: The Missing Manual
A Note Regarding Supplemental Files
The Missing Credits
About the AuthorsAbout the Creative TeamAcknowledgementsThe Missing Manual Series
Introduction
What Is Office 2013?Flavors of Office 2013Office 2013Office 365What’s New in Office 2013About This BookThe Very BasicsAbout→These→ArrowsAbout the Online ResourcesMissing CDRegistrationFeedbackErrataSafari® Books Online
1. Using Office
1. Using Office 2013’s Common Features
Opening an Office 2013 ProgramThe Start ScreenWorking with the RibbonUsing Ribbon-Based Keyboard ShortcutsGoing BackstageSaving a FileFinding and Opening a Saved FileClosing a File or ProgramCustomizing Office ApplicationsChanging the Look of OfficeCustomizing the Quick Access ToolbarCustomizing the RibbonCustomizing the Status Bar
2. Word
2. Basic Word Processing
First Things First: Word’s Start PageThe Word 2013 WindowCreating a New DocumentCreating a New Blank DocumentCreating a New Document from a TemplateCreating a New Document from an Existing DocumentTyping Some TextSaving a DocumentSaving a Document Using Your MouseSaving a Document Using Keyboard ShortcutsUsing the Save As PageClosing a DocumentOpening an Existing DocumentDifferent Ways to View Your WorkViewing a Document in the Navigation PaneZooming In and OutThe Zoom SliderThe Zoom Dialog BoxWorking with Multiple Windows
3. Editing and Formatting
Selecting and Moving TextFour Ways to Move TextOption 1: The Ctrl KeyOption 2: Right-ClickOption 3: Use the Home TabOption 4: Use the Clipboard PaneFinding and Replacing TextSearching with the Navigation PaneSetting Search OptionsSearching with the Find and Replace Dialog BoxReplacing TextText Formatting: Font, Size, and StyleThe Home Tab’s Control CenterCopy Formatting with Format PainterQuick Formatting with the Mini ToolbarStyles: Formatting PowerApplying Styles Using Style SetsCreating Your Own Style SetParagraph Formatting: Aligning, Indenting, SpacingAligning TextIndenting ParagraphsIndenting the First LineIndenting an Entire ParagraphCreating a Hanging IndentSpacing Within a ParagraphSpacing Between ParagraphsWorking with ListsCreating a ListFormatting ListsFormatting a Bulleted ListFormatting a Numbered ListFormatting a Multilevel ListFormatting a DocumentAdjusting Page SetupChanging Page Background SettingsAdding a WatermarkCustomizing a Watermark with TextCustomizing a Watermark with an ImageEditing or Deleting a WatermarkAdding Color to Page BackgroundsAdding Patterns to Page BackgroundsGiving Pages a BorderInserting Headers, Footers, and Page NumbersInserting a Header or FooterEditing a Header or FooterInserting the Date and Time into a Header or FooterInserting an Image into a Header or FooterRemoving a Header or FooterInserting Page NumbersFormatting Page NumbersRemoving Page Numbers
4. Tables, Graphics, and Charts
Creating a TableCreating a Table from ScratchInserting a TableInserting a Preformatted TableDrawing a TableCreating a Table from TextAdding Information to a TableEditing a TableSelecting Part or All of a TableUsing Your MouseUsing the RibbonInserting Rows and ColumnsMoving Rows and ColumnsMerging and Splitting CellsDeleting All or Part of a TableFormatting a TableSave Time with Ready-to-Use Table StylesApplying Shading and BordersShading a TableWorking with BordersDrawing BordersInserting ImagesInserting a Picture from Your ComputerInserting a Picture from the WebInserting a ScreenshotEditing an ImageChanging an Image’s SizeCropping an ImageRemoving a Picture’s BackgroundMoving and Rotating ImagesMoving an ImageRotating an ImageAdjusting an Image’s AppearanceUsing Picture StylesFormatting PicturesWrapping Text Around an ImageSearching for ImagesFun with Fonts and Art That’s SmartCreating WordArtEditing WordArt TextFormatting WordArt Using the Format Shape PaneShape OptionsText OptionsInserting SmartArt into Word DocumentsAdding Charts and Diagrams

5. Proofing and Research Tools
Checking Spelling and GrammarCatching Spelling MistakesFlagging Frequently Confused WordsChecking Spelling in an Entire DocumentWord’s Grammar CheckerGetting Things Right with AutoCorrectUndoing an AutoCorrect ChangeSetting AutoCorrect OptionsMaking an ExceptionAdding Custom CorrectionsDeleting an AutoCorrect CorrectionAutoFormatting in WordWord’s Built-in Research ToolsInstalling a DictionaryLooking Up a Word in the DictionaryUsing the ThesaurusTranslating TextGetting a Quick Translation with the Mini TranslatorUsing the Research Pane for TranslationsTranslating an Entire Document
6. Printing Documents
Getting Started with PrintingPreviewing a Document Before You Print ItPrinting a DocumentSelecting Print Options and SettingsChoosing a PrinterSpecifying SettingsSending a FaxCreating a Cover PageSending a FaxPrinting EnvelopesFormatting Envelope AddressesSelecting a Feed MethodAdding Electronic PostagePrinting LabelsMerging Names and Addresses with DocumentsStep 1: Select Document TypeStep 2: Select Starting DocumentStep 3: Select RecipientsStep 4: Write Your LetterStep 5: Preview Your LettersStep 6: Complete the MergeDo-It-Yourself Mail Merge with the Mailings Tab’s Buttons
7. Reports and Long Documents
Inserting Page BreaksBreaking a Document into SectionsKinds of Section BreaksInserting a Section BreakChanging the Orientation of a New SectionChanging the Page Numbering of a New SectionFootnotes and EndnotesInserting a FootnoteInserting an EndnoteEditing a NoteNavigating NotesChanging the Position of Footnotes or EndnotesConverting Footnotes to Endnotes (or Vice Versa)Changing Footnote or Endnote MarkersDeleting a NoteCitations and BibliographiesCreating and Inserting a CitationInserting an Existing CitationInserting a PlaceholderEditing a Citation or Its SourceDeleting a CitationDeleting a SourceBuilding a BibliographyUpdating a BibliographyHelping Readers Navigate Your DocumentInserting Bookmarks and Cross-ReferencesCreating a BookmarkJumping to a BookmarkDeleting a BookmarkCreating Cross-ReferencesCreating a Table of ContentsCreating an IndexMarking Index EntriesGenerating an IndexUpdating an IndexEditing Index EntriesDeleting an Index EntryDeleting an index
8. Customizing Documents with Themes, Templates, and Macros
Themes: The Way to Better DesignsChoosing a ThemeCustomizing a ThemeSaving a ThemeFinding a Saved ThemeSetting a Default ThemeTemplates: Reusable Document BlueprintsChoosing a TemplateCreating Your Own TemplateCreating a Template from ScratchCreating a Template from a DocumentCreating a Template from an Existing TemplateCustomizing a TemplateChanging an Existing Style within a TemplateCreating a New Style for a TemplateCopying a Style from One Template to AnotherDeleting a Style from a TemplateSaving Time with MacrosRecording a MacroRunning a MacroCopying a Macro Between TemplatesDeleting a Macro
9. Desktop and Web Publishing
Newsletters and BrochuresLaying Out Text in ColumnsFormatting ColumnsInserting a Text BoxImages and Text WrappingInserting an Image into a Document with ColumnsInserting an Image into a Document with Text BoxesWeb Page DesignSaving a Word Document as a Web PageCreating a Web Page from ScratchCreating Your Site’s Home PageStep 1: Set up a tableStep 2: Create a headerStep 3: Add a navigation barStep 4: Add a footerStep 5: Save the page as a templateStep 6: Adding text and imagesCreating More Pages for Your Site
10. Sharing and Collaborating on Documents
Sharing a DocumentEmailing a DocumentEmailing a Document as an AttachmentEmailing a Link to a DocumentPresent a Document over the InternetSaving a Document to SkyDriveGetting FeedbackInserting a CommentViewing CommentsEditing a CommentDeleting a CommentKeeping Track of RevisionsSelecting Which Changes to ViewAccepting or Rejecting ChangesSetting Track Changes OptionsComparing DocumentsCombining DocumentsProtecting Your DocumentsRemoving Hidden Data and Personal InformationRestricting Formatting and EditingRestricting PermissionsCoauthoring and Simultaneous Editing
3. Outlook
11. Getting Started with Outlook
Setting Up OutlookTaking a Quick Look AroundMailCalendarPeopleTasksNotesFoldersShortcutsCustomizing the Navigation BarComposing and Sending EmailSending an Email to More than One RecipientProofreading a MessageAttaching a File to an Email MessageInserting a Picture into an Email MessageAdding a SignatureCreating a SignatureEditing a SignatureChoosing a Signature to AddDeleting a SignatureAdding a Theme or StationerySetting a Message’s Priority and ConfidentialityMaking Sure They Got the MessageSetting a Delivery TimeDirecting Replies to Another AddressAdding Voting ButtonsWorking OfflineReceiving EmailReplying to or Forwarding an EmailOpening an AttachmentGetting NotifiedDeleting a MessageMarking a Message as UnreadFlagging a MessageFlagging a Message You’ve ReceivedFlagging an Outgoing MessageFinding Flagged MessagesOrganizing MessagesGrouping Messages into ConversationsOrganizing Messages into FoldersRouting Incoming MessagesTranslating a MessagePrinting a MessageFighting SpamWhat If It’s Not Spam?Setting Up a Safe Senders ListManaging Junk EmailSaving Time with Quick StepsApplying a Quick StepCustomizing a Quick StepCreating Your Own Quick StepDeleting a Quick StepManaging Multiple Email AccountsAdding Another Email AccountKeeping Accounts StraightChoosing Which Account to Send From
12. Outlook’s Address Book
Adding and Editing ContactsAdding ContactsCreating a New Contact from ScratchCreating a New Contact from an Email MessageImporting Email Addresses from Another ProgramExporting Contacts from OutlookExporting Contacts from a Different Email ProgramImporting Contacts from an Outlook Data FileImporting Contacts from a CSV FileViewing a ContactEditing a Contact’s InformationEditing All FieldsCreating a New FieldAdding DetailsEditing Business CardsDeleting a ContactFinding a ContactViewing ContactsSorting and Grouping ContactsSorting ContactsGrouping ContactsCustomizing a ViewSaving a ViewDeleting a ViewThe People PaneCommunicating with a ContactGathering Contacts into a GroupCreating a Contact GroupSending Email to a Contact GroupManaging a Contact GroupPrinting Your ContactsContacts and Social NetworkingAdding a Social Network to Outlook
13. Getting Organized with Folders
Finding Folders in the Navigation PaneCreating a New FolderFilling Up and Managing FoldersCopying a FolderMoving a FolderRenaming a FolderDeleting a FolderCategorizing ItemsAssigning a CategoryCreating a New CategoryViewing Items by CategoryClearing CategoriesRenaming a CategorySearching FoldersSearching the Current FolderRepeating a SearchSetting the Scope of Your SearchSpeeding Up Your Search with Keyboard ShortcutsRefining Your SearchDoing an Advanced SearchCreating a Search Folder for EmailChanging Search SettingsCleaning Out FoldersArchiving Old DataSetting Up AutoArchiveAdjusting AutoArchive Settings for a Specific FolderArchiving ManuallyCleaning up Your Mailbox
14. Getting Organized with Outlook’s Calendar, Tasks, and Notes
Your Schedule, Your CalendarCreating an Appointment or MeetingScheduling an AppointmentSetting Up a MeetingAccepting an Invitation to a MeetingAdding or Removing AttendeesKeeping Track of Who’s AttendingCanceling a MeetingEditing EventsTurning an Appointment into a MeetingMaking an Event RecurGetting RemindersDeleting an AppointmentViewing Your ScheduleTasksAdding a TaskCreating a TaskCreating a Recurring TaskAssigning a TaskAccepting a TaskManaging TasksEditing a TaskFlagging TasksMarking a Task as CompletedViewing TasksTaking Notes in OutlookAdding a NoteWorking with NotesViewing NotesIcon ViewNotes List ViewLast 7 Days View
4. Excel
15. Creating Your First Spreadsheet
Starting a WorkbookAdding Information to a WorksheetAdding Column TitlesAdding DataEditing DataEditing Cells with the Formula BarUsing the RibbonCollapsing the RibbonUsing the Ribbon with the KeyboardUsing the Status BarSaving FilesThe Excel File FormatSharing Your Spreadsheet with Older Versions of ExcelSaving Your Spreadsheet for Excel 2003Saving Your Spreadsheet As a PDFDisaster RecoveryAutoRecover SettingsOpening FilesOpening Files in Other FormatsProtected ViewWorking with Multiple Open SpreadsheetsAdding Different Types of DataHow Excel Identifies TextHow Excel Identifies NumbersHow Excel Identifies Dates and TimesRegional DatingPrintingHow to Print an Excel FilePage Layout View: A Better Print PreviewCreating Headers and FootersControlling PaginationPage BreaksScalingPage Break Preview: A Bird’s-Eye View of Your Worksheet
16. Moving Data
Selecting CellsMaking Continuous Range SelectionsMaking Noncontiguous SelectionsAutomatically Selecting Your DataMaking Selections with the KeyboardMoving Cells AroundA Simple Cut-and-Paste or Copy-and-PasteA Quicker Cut-and-Paste or Copy-and-PasteFancy Pasting TricksPaste SpecialCopying Multiple Items with the ClipboardAdding and Moving Columns or RowsInserting ColumnsInserting RowsInserting Copied or Cut CellsDeleting Columns and RowsWorksheets and WorkbooksAdding and Removing WorksheetsMoving Between WorksheetsHiding WorksheetsNaming and Rearranging WorksheetsMoving Worksheets from One Workbook to Another
17. Formatting Cells
Formatting Cell ValuesChanging the Cell Value FormatFormatting NumbersGeneralNumberCurrencyAccountingPercentageFractionScientificTextFormatting Dates and TimesSpecial Formats for Special NumbersFormatting Cell AppearanceAlignment and OrientationFonts and ColorSpecial CharactersBorders and Fills
18. Building Basic Formulas
Creating a Basic FormulaExcel’s Order of OperationsCell ReferencesHow Excel Formats Cells That Contain Cell ReferencesFunctionsUsing a Function in a FormulaUsing Cell References with a FunctionUsing Cell Ranges with a FunctionExcel Compatibility FunctionsFormula ErrorsLogical OperatorsFormula ShortcutsPoint-and-Click Formula CreationPoint-and-Click Formula EditingThe Formulas TabUsing the Insert Function ButtonCopying FormulasAbsolute Cell ReferencesPartially Fixed ReferencesReferring to Other Worksheets
19. Math and Statistical Functions
Rounding NumbersROUND(), ROUNDDOWN(), ROUNDUP(): Rounding NumbersManipulating TextCONCATENATE(): Joining Strings of Text TogetherLEFT(), MID(), and RIGHT(): Copying Portions of a Text StringTRIM() and CLEAN(): Removing Unwanted Spaces and Non-Printing CharactersSUBSTITUTE(): Replacing One Sequence of Characters with AnotherSolving Formula ErrorsStep-by-Step EvaluationTracing Precedents and DependentsError-Checking
20. Creating Basic Charts
Charting 101Embedded and Standalone ChartsAdding a Recommended ChartPicking from the Full Range of ChartsSelecting a ChartBasic Tasks with ChartsMoving and Resizing a ChartCreating a Standalone ChartEditing and Adding to Chart DataFiltering Chart DataChanging the Chart TypePrinting ChartsEmbedded ChartsStandalone ChartsPractical ChartingCharts with Multiple Series of NumbersControlling the Data Excel Plots on the X-AxisData That Uses a Date or Time ScaleNoncontiguous Chart RangesChanging the Order of Your Data SeriesChanging the Way Excel Plots Blank ValuesChart TypesColumnBarLinePieAreaChart Styles and LayoutsChart StylesChart ColorsChart LayoutsAdding Chart ElementsAdding TitlesAdding a LegendAdding Data Labels to a SeriesAdding Individual Data LabelsAdding a Data Table
5. PowerPoint
21. Creating a Presentation
Creating a New PresentationCreating a New Presentation from a TemplateChoosing a ThemeVarying a ThemeAdding Text to a SlideCreating a New SlideAdding ContentDeleting ContentSaving a PresentationOpening an Existing PresentationOpen a Recent Presentation from the Windows 8 Start ScreenOpen a Recent Presentation from the Windows 7 Start MenuOpen a Recent Presentation in PowerPointOpen Any Saved Presentation in PowerPointAdding NotesViewing a PresentationNormal ViewOutline ViewSlide Sorter ViewNotes Page ViewReading ViewSlide Show ViewZooming In and OutPrinting a Presentation
22. Editing Slides
Editing TextFormatting TextAdjusting Character SpacingPositioning TextFormatting a Text BoxCreating ListsLinking Text to a Web pageChecking Your SpellingTurning Text into WordArtEmbedding Other Files in SlidesEmbedding an Existing File in a SlideUpdating LinksCreating a New Embedded FileAdding Tables to SlidesInserting a TableInserting a Table When You Add a New SlideInserting a Table on an Existing SlideInsert a Table Using an Excel-Style SpreadsheetDrawing a TableAdding Information to a TableEditing a TableSelecting All or Part of a TableResizing a TableMoving a TableChanging a Table’s StyleAdding Images to SlidesCreating a Photo AlbumSetting Up a Photo AlbumEditing a Photo AlbumWorking with ShapesInserting a ShapeChanging a Shape’s Size or PositionAdding Text to a ShapeFormatting a ShapeWorking with SmartArtInserting SmartArtConverting Text to SmartArtAdding a ShapeReordering ShapesApplying a Different LayoutAdjusting a SmartArt Graphic’s StyleFormatting Shapes within a SmartArt GraphicRotating a SmartArt GraphicResizing a SmartArt GraphicWorking with Charts and DiagramsCreating a Chart or Diagram Using ExcelCreating a Diagram Using ShapesArranging Objects on a SlideAligning Objects Using the Arrange ButtonAligning Objects ManuallyOrdering ObjectsGrouping Objects
23. Editing a Presentation
Copying, Rearranging, and Deleting SlidesCopying a SlideDuplicating a SlideInserting a Slide from a Different PresentationRearranging Slides in a PresentationDeleting a SlideHiding SlidesHeaders and FootersTime-Stamping SlidesAdding a Footer to SlidesNumbering SlidesAdding a Header and Footer to Notes and HandoutsOrganizing Your Presentation with SectionsCreating a SectionNaming a SectionCollapsing and Expanding SectionsMoving a Section Within a PresentationHiding All Slides Within a SectionRemoving a Section from a PresentationNavigating with Links and Action ButtonsInserting a Hyperlink to Another SlideCreating a Table of Contents for Your PresentationLinking to a Hidden SlideInserting an Action ButtonOpening an Inserted FileSlide Masters: Powerful Slide BlueprintsChanging the Look of All Slides in Your PresentationChanging the Layout for a Particular Type of SlideCreating a New LayoutWorking with Masters for Handouts and NotesModifying the Handout MasterModifying the Notes MasterCollaborating with OthersAdding and Reading CommentsInserting a CommentReading CommentsEditing a CommentHiding CommentsDeleting CommentsComparing Versions of a Presentation
24. Adding Multimedia and Movement
Putting Media Clips in a PresentationAdding Video That’s Stored on Your ComputerAdding a Video from SkyDriveAdding Video from a WebsiteFinding and Adding Video via Bing or YouTubeAdding Sound That’s Stored on Your ComputerAdding Clip Art AudioRecording AudioPlaying Audio Throughout a SlideshowFormatting Video ClipsAdjust Brightness and ContrastAdd a Frame or BorderAdd EffectsCrop the PlayerFormatting Audio ClipsEditing Media ClipsUsing BookmarksTrimming a Media ClipFading in and Fading OutHide a Clip Until You Want it to PlayOther Media Clip SettingsAnimating ObjectsAnimating an ObjectChanging an AnimationAdjusting Effect OptionsAdding Sound to an AnimationDimming TextAnimating Paragraphs and WordsAdding More AnimationCreating a Motion PathTriggering an AnimationTiming AnimationsReordering AnimationsRemoving an AnimationUsing the Animation PaneAnimating ListsAdjusting Animation for Individual List ItemsGiving Sub-Items their Own AnimationAnimating a List as a Single Block of TextStacking ObjectsAnimating SmartArt GraphicsCreating Transitions Between SlidesAdding a TransitionTweaking Transition EffectsAdding Sound to a TransitionTiming Transitions
25. It’s Showtime! Giving a Presentation
Start, Navigate, End: Tips and ShortcutsStarting a SlideshowMoving From Slide to SlideEnding a SlideshowBefore the Show: Prep WorkAdding Narration to Your PresentationRecording a NarrationPlaying Back a Narrated SlideshowTurning Off NarrationCreating a Custom SlideshowCreating a HandoutSetting Up Your ShowFollowing your Notes in Presenter ViewAt the EventSettings to CheckLaunching a SlideshowDuring the ShowZooming inHiding or Showing the PointerMarking Up SlidesChanging Markup ColorErasing MarkupMaking the Mouse Pointer a Laser PointerMaking the Screen go BlankSwitching to Another Program (and Back)Ending the ShowOther Presentation OptionsPresenting a Slideshow OnlineEditing an Online PresentationCreating a Slideshow That Runs by ItselfCreating an Interactive SlideshowTurning Your Presentation into a VideoSharing Your PresentationPackaging Your Presentation on a CD or DVD
6. Access
26. Creating Your First Database
Understanding Access DatabasesStarting a DatabaseBuilding Your First TableCreating a Simple TableEditing a TableEdit ModeDatasheet Shortcut KeysCut, Copy, and PasteSaving DatabasesMaking BackupsSaving a Database with a Different NameSaving a Database in a Different FormatShrinking a DatabaseOpening DatabasesDesignating a Database as TrustedOpening More Than One Database at OnceOpening a Database Created in an Older Version of AccessThe Navigation PaneBrowsing Tables with the Navigation PaneManaging Database Objects
27. Building Smarter Tables
Understanding Data TypesDesign ViewOrganizing and Describing Your FieldsHow Updates Work in Design ViewAccess Data TypesShort TextText LengthLong TextFormatted TextNumberNumber SizeNumber FormattingCurrencyDate/TimeCustom Date FormatsYes/NoHyperlinkAttachmentAutoNumberUsing AutoNumbers Without Revealing the Size of your TableUsing Replication IDSCalculatedThe Primary KeyCreating Your Own Primary Key FieldSix Principles of Database Design1. Choose Good Field Names2. Break Down Your Information3. Include All the Details in One Place4. Avoid Duplicating Information5. Avoid Redundant Information6. Include an ID FieldBlocking Bad DataData Integrity BasicsPreventing Blank FieldsBlank Values and Empty TextSetting Default ValuesPreventing Duplicate Values with IndexesMultifield IndexesLookupsCreating a Simple Lookup with Fixed ValuesAdding New Values to Your Lookup List
28. Mastering the Datasheet: Sorting, Searching, and Filtering
Datasheet CustomizationFormatting the DatasheetRearranging ColumnsResizing Rows and ColumnsHiding ColumnsFreezing ColumnsDatasheet NavigationSortingSorting on Multiple FieldsFilteringQuick FiltersFilter by SelectionFilter by ConditionSearchingPrinting the DatasheetPrint PreviewMoving Around the Print PreviewChanging the Page LayoutFine-Tuning a Printout
29. Linking Tables with Relationships
Relationship BasicsRedundant Data vs. Related DataMatching Fields: The Relationship LinkLinking with the ID ColumnThe Parent-Child RelationshipUsing a RelationshipDefining a RelationshipEditing RelationshipsReferential IntegrityBlank Values for Unlinked RecordsCascading DeletesCascading UpdatesNavigating a RelationshipLookups with Related TablesMore Exotic RelationshipsOne-to-One RelationshipMany-to-Many RelationshipJunction TablesMulti-Value Fields
7. Other Office Tools
30. Publisher
Creating a New PublicationCreating a Publication from a TemplateCreating a Publication from ScratchViewing the PageEntering TextInserting an ImageAdding PagesNavigating PagesSaving a PublicationAdding TextEditing and Formatting TextAligning Text within a Text BoxFitting Text to a Text BoxAdjusting HyphenationWorking with Character SpacingFormatting TextAdding Some Style to Your TextInserting Your Business InformationFlowing Text from One Box to AnotherFlowing Text ManuallyConnecting Text Boxes to Autoflow TextFlowing Text Around an ObjectAdding Pictures, Shapes, and Other ObjectsFormatting ObjectsFormatting PicturesFormatting Shapes and WordArtStacking and Grouping ObjectsDesigning and Laying Out PagesSetting Up PagesChoosing a Color SchemeChoosing a Font SchemeUsing Layout GuidesSnapping an Object to a GuideReviewing Your DesignPrinting a PublicationPreparing a Publication for a Commercial Printer
31. OneNote
What Is OneNote?Getting Familiar with the OneNote WorkspaceCreating and Filling Up a NotebookAdding Notes to a PageTyping a NotePasting in a NoteDrawing a NoteInserting a Screen ClippingRecording Audio and Video NotesOrganizing a NotebookWorking with Sections and PagesMoving a SectionMerging SectionsMoving a PageChanging a Page’s LevelDeleting Notebooks, Sections, and PagesManaging Individual NotesWriting Quick NotesLinking a Note to its SourceTagging a NoteTagging your to-do ItemsCreating a Custom TagFinding Tagged NotesRemoving a TagFinding a NoteSearching a PageChanging the Scope of your SearchViewing Your NotebooksSharing NotesSharing a Notebook via a LinkSharing a Notebook with an Online MeetingFinding Changes Others Have MadeEmailing a PageUsing OneNote with Other Office ProgramsLinking Notes to Their SourceViewing Note LinksRemoving Links from Linked NotesTurning off Linked NotesGetting Office Files into OneNoteAttaching a File to a NoteInserting a Copy of a File into OneNote
32. SkyDrive and Office Web Apps
Introducing Office on the WebSetting Up Office Web AppsSigning in to SkyDriveWhat’s New in Office Web AppsCreating and Editing FilesSaving a Web App File in SkyDriveWorking with Folders in SkyDriveCreating a FolderViewing Folders and FilesFinding Folders and FilesViewing Files in a FolderRenaming a FolderDeleting a FolderManaging Files in SkyDriveOpening a FileUploading Files to SkyDrive from Your ComputerStarting Point: SkyDriveStarting Point: an Office ProgramDownloading Files from SkyDrive to Your ComputerMove, Rename, Delete: File Management TipsSharing Files and FoldersSharing in Office Web AppsSharing in Office Web AppsSharing on a Social NetworkSharing a File as a Web PageMaking a Shared Folder or File PrivateReal-Time CollaboratingDocs.com: Office Web Apps for FacebookAdding a DocCreating a Doc from ScratchCreating a Doc from a TemplateUploading a File from your ComputerViewing Your DocsEditing a DocSharing a DocViewing Friends’ Docs
Index
About the Authors
Copyright

Content preview from Office 2013: The Missing Manual

Chapter 20. Creating Basic Charts

As you become more skilled with Excel, you’ll realize that entering numbers, organizing your layout, and formatting cells aren’t the most important parts of spreadsheet creation. Instead, the real work lies in analyzing your data—in figuring out a way to tell the story that lies behind your numbers. And one of the best ways to do that is with Excel’s charting tools.

Charts depict data visually, so you can quickly spot trends. They’re a fabulous way to help you find the meaning hidden in large amounts of data. You can create many different types of charts in Excel, including pie charts that present polling results, line charts that plot rising or declining assets over time, and three-dimensional area charts that show relationships between environmental conditions in a scientific experiment.

Excel’s charting tools are enormously flexible: You can generate a simple chart with standard options with a couple of mouse clicks, or you can painstakingly customize every aspect of your chart’s appearance (including colors, scale, titles, and even 3-D perspective).

Note

All charts are not created equal. Depending on the chart type you use, the scale you choose, and the data you include, your chart may suggest different conclusions. The true chart artist knows how to craft a chart to emphasize the most important information. As you become more skilled with charts, you’ll acquire these instincts, too.

Charting 101

Excel provides a dizzying number of chart types, but ...

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: 9781449359416Errata Page

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design