book

Office 2013 On Demand

Name: Office 2013 On Demand
Author: Steve Johnson
ISBN: 9780133352993

by Steve Johnson

January 2013

Intermediate to advanced

768 pages

27h 23m

English

Que

Read now

Unlock full access

Title Page
Copyright Page
Acknowledgments
Perspection, Inc.AcknowledgmentsAbout the AuthorWe Want to Hear from You!
Contents
Introduction
How This Book WorksWhat’s NewKeyboard ShortcutsStep-by-Step InstructionsReal World ExamplesWorkshopsMicrosoft Office SpecialistGet More on the Web
1. Getting Started with Office
IntroductionStarting an Office ProgramViewing an Office Program WindowUsing the RibbonChoosing CommandsWorking with the Ribbon and ToolbarsChoosing Dialog Box OptionsUsing the Status BarCreating a Blank Office DocumentCreating a Document Using a TemplateOpening an Existing Office DocumentConverting an Existing Office DocumentUsing Task and Window PanesArranging WindowsSwitching ViewsDocumenting PropertiesGetting Help While You WorkSaving an Office DocumentSaving an Office Document with Different FormatsSaving an Office Document to Online ServicesWorking with AccountsChecking CompatibilityChecking AccessibilityRecovering an Office DocumentClosing a Document and Exiting Office
2. Using Shared Office Tools
IntroductionEditing TextCopying and Moving TextFinding and Replacing TextCorrecting Text AutomaticallyInserting Information the Smart WayChecking SpellingChanging Proofing OptionsUsing Custom DictionariesInserting SymbolsFinding the Right WordsInserting Research MaterialTranslating Text to Another LanguageUsing Multiple LanguagesUndoing and Redoing an ActionZooming the View In and OutPreviewing a DocumentPrinting a DocumentWorking with Touch Screens
3. Adding Art to Office Documents
IntroductionLocating and Inserting an Online PictureInserting a PictureInserting a Picture Screen ShotAdding an Artistic Style to a PictureAdding a Quick Style to a PictureApplying a Shape to a PictureApplying a Border to a PictureApplying Picture EffectsModifying Picture SizeCompressing a PictureCorrecting a PictureRecoloring a PictureCropping and Rotating a PictureRemoving a Picture BackgroundCreating WordArt TextFormatting WordArt TextApplying WordArt Text EffectsModifying WordArt Text PositionCreating SmartArt GraphicsFormatting a SmartArt GraphicModifying a SmartArt GraphicAdding Pictures to a SmartArt GraphicCreating an Organization ChartInserting and Creating a ChartChanging a Chart Layout and StyleChanging Chart ElementsFormatting Line and Bar ChartsEditing Chart DataInserting Apps for Office Programs
4. Adding Shapes to Office Documents
IntroductionDrawing and Resizing ShapesAdding Text to a ShapeCreating and Editing FreeformsAdding a Quick Style to a ShapeAdding a Quick Style to Shape TextApplying Color FillsApplying Picture or Texture FillsApplying Gradient FillsApplying Shape EffectsAligning and Distributing ObjectsAligning Objects to Gridlines and GuidesChanging Stacking OrderRotating and Flipping ObjectsGrouping and Merging ObjectsSelecting Objects Using the Selection Pane
5. Formatting Office Documents
IntroductionFormatting TextChanging AlignmentUsing the Format PainterAdding Custom ColorsUnderstanding ThemesViewing and Applying a ThemeCreating Theme ColorsChoosing Theme FontsChoosing Theme EffectsCreating a Custom ThemeChoosing a Custom ThemeCreating a Template

6. Creating a Document with Word
IntroductionViewing the Word WindowOpening and Editing PDF DocumentsChanging Document ViewsReading a DocumentNavigating a DocumentSetting Up the PageSetting Up the Page MarginsCreating an OutlineSelecting TextChecking Spelling and GrammarInserting New Pages and SectionsAdding Headers and FootersInserting Page Numbers and the Date and TimeInserting or Embedding Online Video
7. Formatting a Document with Word
IntroductionFormatting Text for EmphasisFinding and Replacing FormattingChanging Paragraph AlignmentChanging Line SpacingDisplaying RulersSetting Paragraph TabsSetting Paragraph IndentsChanging Character SpacingApplying a Quick StyleChanging a Style SetCreating and Modifying StylesCreating Bulleted and Numbered ListsHiding Text
8. Enhancing a Document with Word
IntroductionAdding Desktop Publishing EffectsAdding a WatermarkAdding Page BackgroundsArranging Text in ColumnsArranging and Aligning an ObjectWrapping Text Around an ObjectWorking with Text BoxesInserting Building Blocks Using Quick PartsCreating a TableEntering Text in a TableModifying a TableAdjusting Table CellsFormatting a TableCalculating a Value in a TableAddressing Envelopes and LabelsCreating a Form LetterCreating LabelsInserting a Table of ContentsCreating an IndexCreating CaptionsCreating a Table of FiguresCreating Footnotes or EndnotesCreating a BookmarkInserting Cross ReferencesComparing and Merging DocumentsUsing Track ChangesAdding a Cover Page
9. Creating a Worksheet with Excel
IntroductionViewing the Excel WindowSelecting CellsMoving Around the WorkbookEntering Labels on a WorksheetEntering Values on a WorksheetEntering Content Quickly with AutoFillInserting Content with Flash FillEditing Cell ContentsClearing Cell ContentsInserting and Deleting Cell ContentsSelecting Rows, Columns, and Special RangesSelecting and Naming a WorksheetInserting and Deleting a WorksheetMoving and Copying a WorksheetHiding and Unhiding Worksheets and WorkbooksHiding and Unhiding a Column or RowInserting a Column or RowDeleting a Column or RowAdjusting Column Width and Row HeightSplitting a Worksheet into PanesFreezing and Unfreezing a Column or RowShowing and Hiding Workbook Elements
10. Building a Worksheet with Excel
IntroductionUnderstanding FormulasUnderstanding Cell ReferencingCreating a Simple FormulaCreating a Formula Using Formula AutoCompleteEditing a FormulaNaming Cells and RangesEntering Named Cells and RangesManaging NamesSimplifying a Formula with RangesCalculating Totals with AutoSumCalculating Totals with Quick AnalysisCorrecting FormulasAuditing a WorksheetCreating FunctionsCreating Functions Using the LibraryCalculating Multiple ResultsUsing Nested FunctionsUsing Text FunctionsUsing Lookup and Reference FunctionsSummarizing Data Using SubtotalsSummarizing Data Using FunctionsConverting Text to ColumnsCreating a TableFormatting a TableFormatting Table ElementsCreating Calculations in a TableRemoving Table Rows and ColumnsWorking with TablesSorting Data in a TableDisplaying Parts of a Table with AutoFilterUsing Slicers to Filter a TableCreating Groups and OutlinesAdding Data Validation to a WorksheetCreating a Drop-Down List
11. Designing a Worksheet with Excel
IntroductionFormatting NumbersApplying and Creating Cell StylesApplying Conditional FormattingApplying Specialized Conditional FormattingCreating Conditional FormattingManaging Conditional FormattingCreating Sparkline FormattingControlling Text FlowFormatting Tabs and BackgroundAdding Borders to CellsSetting Up the PageInserting Page BreaksAdjusting Page MarginsAdding Headers and FootersCustomizing Worksheet PrintingSetting the Print Area
12. Creating a Presentation with PowerPoint
IntroductionViewing the PowerPoint WindowBrowsing a PresentationUnderstanding PowerPoint ViewsCreating New and Consistent SlidesWorking with ObjectsEntering and Editing TextResizing Text While TypingChanging Text SpacingInserting and Developing an OutlineMoving and Indenting TextModifying a Bulleted and Numbered ListCreating Text ColumnsOrganizing Slides into SectionsRearranging SlidesUsing Slides from Other PresentationsMaking Your Presentation Look ConsistentControlling Slide Appearance with MastersControlling a Slide Layout with MastersModifying PlaceholdersControlling a Slide Background with MastersAdding a Background StyleInserting a TableModifying a TableAdding a Quick Style to a TableFormatting a TableCreating a Text Box
13. Delivering a Presentation with PowerPoint
IntroductionChanging Slide Setup OptionsAdding AnimationUsing Specialized AnimationsCoordinating Multiple AnimationsAdding Slide TimingsCreating Slide TransitionsInserting Videos and AudioEditing and Formatting Videos and AudioSetting Video and Audio Play OptionsRecording a NarrationSetting Up a Slide ShowCreating a Custom Slide ShowStarting a Slide ShowNavigating a Slide ShowAnnotating a Slide ShowDisplaying a Slide Show in Presenter ViewSaving a Presentation as a Slide ShowSaving a Presentation as a VideoPackaging a Presentation on CDPreparing HandoutsPreparing Speaker NotesAdding a Header and FooterInserting the Date and TimeInserting Slide NumbersPreviewing SlidesPrinting a Presentation
14. Creating a Database with Access
IntroductionCreating a Desktop DatabaseViewing the Access WindowChanging Database Display OptionsViewing Database ObjectsWorking with Database ObjectsPlanning TablesCreating a Table by Entering DataCreating an Application Part Using a TemplateCreating a Table Using SharePointWorking with a TableImporting Data into TablesWorking with a Table in Design ViewWorking with FieldsSpecifying Data Types and Field PropertiesChanging Field PropertiesCreating Input MasksCreating a Lookup FieldDefining Table RelationshipsEnsuring Referential IntegrityBacking Up and Repairing a DatabasePackaging and Sharing a Database
15. Managing and Presenting Data with Access
IntroductionSorting RecordsFiltering Out RecordsCreating Complex Filters Using FormsUnderstanding the Different Types of QueriesCreating a Query Using a WizardCreating a Query in Design ViewGetting Information with a QueryModifying a Query in Design ViewPerforming Calculations in QueriesSummarizing Values with a Crosstab QueryCreating a Parameter QueryFinding Duplicate FieldsCreating a FormWorking with a Form in Design ViewEntering and Editing Data in a FormModifying a FormCreating a ReportModifying a Report in Design ViewPerforming Calculations in ReportsFormatting a Form or ReportGrouping and Sorting in ReportsFormatting a DatasheetChanging the Page SetupPreviewing and Printing Information
16. Creating a Web App with Access
IntroductionCreating a Web AppAdding Tables and Data to a Web AppViewing and Editing Data in a Web AppCreating Views in a Web AppModifying a Web AppPackaging a Web App
17. Communicating with Outlook
IntroductionPreparing for OutlookUsing Outlook for the First TimeViewing the Outlook WindowUsing the To-Do BarUsing the Folder PaneViewing Items and FoldersCreating a ContactFinding ContactsSorting ContactsCreating and Addressing an E-Mail MessageFormatting Message TextAttaching a File or Item to a MessageUsing StationeryCreating a SignatureInserting Message ContentSending MessagesSetting Message Delivery OptionsReceiving and Reading MessagesFlagging MessagesCategorizing Messages By ColorDeleting MessagesReplying To and Forwarding a MessageFinding and Filtering MessagesOrganizing Messages in FoldersManaging Messages with RulesManaging Messages with Quick StepsUsing Search FoldersWorking with a Message ConversationReducing Junk MessagesArchiving MessagesCleaning Up MessagesSetting Outlook OptionsWorking with Outlook DataSending and Receiving Instant Messages
18. Managing Information with Outlook
IntroductionViewing the CalendarCustomizing the CalendarScheduling an Appointment and EventScheduling MeetingsParticipating in Online MeetingsResponding to Meeting RequestsUpdating and Canceling Meeting RequestsWorking with CalendarsViewing the Weather in CalendarsCreating and Updating TasksOrganizing TasksAssigning Tasks to OthersMonitoring Task ProgressManaging TasksOrganizing Items by CategoriesCustomizing How You View ItemsCreating and Modifying NotesPreviewing and Printing Items from OutlookConnecting to Social NetworksPublishing and Sharing CalendarsWorking with Site MailboxesAdding and Viewing RSS Feeds
19. Creating a Publication with Publisher
IntroductionViewing the Publisher WindowCreating a New PublicationCreating a Blank PublicationOpening an Existing PublicationChanging Your ViewWorking with PagesInserting and Editing TextInserting ContentControlling Pages Appearance with MastersApplying ColorChecking Your DesignSetting Up the PagePrinting a PublicationSaving for Photo PrintingSaving for Commercial Printing
20. Designing a Publication with Publisher
IntroductionSetting Up Layout GuidesViewing Elements and ToolsWorking with TextConnecting Text FramesCreating a Consistent LookCreating TablesWorking with Shapes and PicturesWrapping Text Around an ObjectLayering ObjectsGrouping Objects TogetherAligning with PrecisionRotating and Flipping Objects
21. Publishing Office Documents for the Web
IntroductionOpening a Web PagePreviewing a Web PageCreating a HyperlinkAdding Hyperlinks to Slide ObjectsFormatting a Cell HyperlinkChanging Web Page OptionsSaving a Web PagePublishing a Web PageSaving Slides as Web GraphicsCreating Refreshable Web QueriesGetting Data from Web QueriesGetting Documents from the Web
22. Protecting and Securing Office Documents
IntroductionInspecting DocumentsProtecting a WorksheetLocking or Unlocking Worksheet CellsAdding Security Encryption to a DocumentAdding Password Protection to a DocumentAdding a Digital SignatureAdding a Signature LineAvoiding Harmful AttacksUsing the Trust CenterSelecting Trusted Publishers and LocationsSetting Document Related Security OptionsSetting App Catalog Security OptionsSetting Add-in Security OptionsSetting ActiveX Security OptionsSetting Macro Security OptionsChanging Message Bar Security OptionsSetting Privacy OptionsSetting External Content Security OptionsWorking with Office Safe ModesMarking a Document as Read-Only
23. Reviewing and Sharing Office Documents
IntroductionSharing WorkbooksCreating and Reading a Cell CommentEditing and Deleting a Cell CommentAdding Comments to a PresentationTracking Workbook ChangesComparing and Merging PresentationsCreating and Linking NotesSending a Document Using E-MailSending a Document by Internet FaxSending a Document by Instant MessageCreating a PDF DocumentCreating a XPS DocumentExporting and Importing DataLinking and Embedding FilesConsolidating Data in ExcelLinking Data in ExcelGetting Text Data in ExcelConnecting to Data in ExcelGetting Query Data from a DatabaseGetting Data from AccessSharing with SkyDrive and SharePointSaving and Opening on SkyDrive and SharePointSyncing Documents on SharePointSharing a SkyDrive DocumentWorking Together with Online DocumentsPublishing Slides to an Online LibraryBroadcasting an Online PresentationGiving a Presentation at an Online MeetingPosting to an Online Blog
24. Expanding Office Functionality
IntroductionViewing and Managing Add-insLoading and Unloading Add-insEnhancing a Document with VBASetting Developer OptionsUnderstanding How Macros Automate Your WorkRecording a MacroCreating a MacroRunning a MacroControlling a MacroBuilding a MacroAdding a Digital Signature to a Macro ProjectAssigning a Macro to a Toolbar or RibbonSaving a Document with MacrosOpening a Document with MacrosInserting ActiveX ControlsUsing ActiveX ControlsSetting ActiveX Control PropertiesAdding VBA Code to an ActiveX ControlPlaying a Movie Using an ActiveX ControlChanging the Document Information Panel
25. Working with Other Office Tools
IntroductionWorking with OneNoteViewing the InfoPath Designer WindowWorking with InfoPath DesignerViewing the InfoPath Filler WindowWorking with InfoPath FillerCommunicating Online with LyncWorking with Office ToolsMaintaining and Repairing Office
New! Features
Microsoft Office 2013
Microsoft Office Specialist
About the MOS ProgramWhat Does This Logo Mean?Preparing for a MOS ExamTaking a MOS ExamGetting More Information
Index
Online Workshop

Overview

Need answers quickly? Office 2013 on Demand provides those answers in a visual step-by-step format. We will show you exactly what to do through lots of full color illustrations and easy-to-follow instructions.

Inside the Book

• Office: Organize information and add impact with online pictures and video, SmartArt diagrams, tables, and charts

• Word: Create great-looking documents using themes, templates, and video

• Excel: Use organizing, processing, and presenting tools to quickly create data tables and charts

• PowerPoint: Create powerful presentations faster using ready-made design templates and themes

• Access: Use full-featured templates and application parts to create desktop and web app databases.

• Outlook: Use tools for creating and managing your e-mail, calendar, contacts, and tasks

• Publisher: Use ready-made design templates to quickly create a brochure or a newsletter

• Office Web Apps: View and edit your Office documents in a browser

• Online Sharing: Save, open, and share Office documents on Skydrive and Office 365 SharePoint from all your devices

• Prepare for the Microsoft Office Specialist exam

Bonus Online Content

• Workshops and related files

• Keyboard shortcuts

Visit the author site: perspection.com

Includes

• Online Workshops that focus on real-world techniques

• MOS Exam Prep

• More than 700 of the most essential Office 2013 tasks

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

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills