book

Office 2013 On Demand

by Steve Johnson

January 2013

Intermediate to advanced

768 pages

27h 23m

English

Que

Read now

Unlock full access

Perspection, Inc.AcknowledgmentsAbout the AuthorWe Want to Hear from You!
How This Book WorksWhat’s NewKeyboard ShortcutsStep-by-Step InstructionsReal World ExamplesWorkshopsMicrosoft Office SpecialistGet More on the Web
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
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
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
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
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

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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Microsoft Office 2013
About the MOS ProgramWhat Does This Logo Mean?Preparing for a MOS ExamTaking a MOS ExamGetting More Information

Content preview from Office 2013 On Demand

24. Expanding Office Functionality

What You’ll Do

View and Manage Add-ins

Load and Unload Add-ins

Enhance a Document with VBA

View the Visual Basic Editor

Set Developer Options

Understand How Macros Automate Your Work

Record or Create a Macro

Run and Control a Macro

Build a Macro

Add a Digital Signature to a Macro Project

Assign a Macro to a Toolbar or Ribbon

Save and Open a Workbook with Macros

Insert and Use ActiveX Controls

Set ActiveX Control Properties

Add VBA Code to an ActiveX Control

Play a Movie Using an ActiveX Control

Change the Document Information Panel

Introduction

An add-in extends the functionality of Microsoft Office programs. For example, Excel includes a variety of add-ins—including Analysis ToolPak, Analysis ToolPak VBA, ...