book

Microsoft Office Professional 2013

by Mark Dodge Beth Melton Echo Swinford, Andrew Couch, Eric Legault, Ben M. Schorr, and Ciprian Adrian Rusen

May 2013

Beginner

1216 pages

28h 43m

English

Microsoft Press

Read now

Unlock full access

Who this book is forHow this book is organizedDownload the practice filesYour companion ebookGetting support and giving feedbackErrataWe want to hear from youStay in touch
Exploring the Office environmentWorking with Office filesRecovering unsaved files and versionsCustomizing the user interfaceCustomizing the Office environmentCustomizing the Quick Access toolbarCustomizing the status barCustomizing the ribbonChoosing the right application for the task at handKey points
Identifying new shared features in Office Professional 2013Applying Office themesInserting graphics, videos, charts, and diagramsInserting chartsSearching for online templatesPresenting Office documents onlineInserting online videoKey points
Defining the term cloud serviceSigning in and managing your Office accountConnecting cloud services to your Office accountSaving files on SharePoint Online and SkyDriveSharing files with others from SharePoint Online or SkyDriveOpening files from the cloudSyncing files with SkyDrive for offline useSyncing with SkyDrive ProSyncing with SkyDrive for a Microsoft accountGetting started with co-authoringKey points
Getting comfortable with Office on a tabletLooking at unsupported featuresUsing touch modeSelecting content with touchWorking with ink in OfficeKey points
Exploring the Word 2013 user interfaceModifying your document viewChanging other view optionsDiscovering what’s new in Word 2013Key points

Navigating a document by scrolling and using keyboard shortcutsSearching and navigating a document by using the Navigation paneCollapsing and expanding document contentWorking with documents in the new Read ModeExploring research tools in Read ModeKey points
Moving the cursor by using keyboard shortcutsSelecting text by using the keyboard and mouseSelecting text by using the keyboardSelecting text by using the mouseUsing other selection methodsUsing formatting marks during document compositionInserting symbols, international characters, and other special charactersInserting special charactersUsing AutoCorrectComposing documents faster by using building blocksKey points
Formatting documents more efficientlySetting default document formatting for your documentsSetting section formattingUsing styles for paragraph and character formatsExploring other paragraph formatsExploring other character formatsChanging caseManaging pagination through formattingKey points
Formatting simple lists by using bullets and numberingCreating tabbed listsInserting tablesEnhancing tablesKey points
Correcting proofing errorsInspecting documents before publishingMarking documents as finalCreating PDF files in WordConverting PDF files for editingPrinting documentsKey points
Getting started working with PowerPoint 2013Exploring the PowerPoint 2013 toolsDiscovering the new features in PowerPoint 2013Key points
Creating a new presentation based on a theme or templateApplying a theme to an existing presentationCustomizing your file with colors, fonts, and effectsTheme fontsTheme colorsApplying theme effects to your presentationApplying background styles to your presentationFormatting placeholders on the slide masterAdding graphics to the slide master and layoutsCreating a custom slide layoutChanging your presentation from a 16:9 to a 4:3 formatKey points
Choosing a slide layout and adding text in placeholdersAdding manual text boxesAdding and formatting a tableInserting and formatting chartsCreating and formatting SmartArt diagramsReusing slides and keeping their source formattingKey points
Adding and formatting shapesApplying enhanced fills and effectsCreating your own shapesInserting, cropping, and formatting picturesKey points
Adding animation to text and shapesEditing video and applying transitionsInserting and playing online videoSaving your presentation as a videoKey points
Adding and renaming sectionsInserting commentsPrinting slides and notesFinalizing your presentationDelivering a presentationPracticing with Presenter viewKey points
Starting Excel 2013Identifying what’s new in Excel 2013Using the new features in ExcelOther enhancements, improvements, and feature upgradesKey points
Entering and organizing dataChanging column widthsUsing formatting to alter the appearance of dataExtending a series with AutoFillIntroducing Flash FillSelecting and naming cell rangesUsing column headers to define namesMoving around in the worksheetMoving and adjusting cellsMoving and copying rows and columnsCopying one or more cells to manyKey points
Creating, editing, and copying formulasUsing functionsUsing the AutoSum button and built-in functionInserting functionsUsing relative, fixed, and mixed cell referencesUsing names in formulas and validating cell entriesLooking at useful functionsHandy math and trig functionsHandy logical functionsHandy text functionsHandy date and time functionsHandy lookup and reference functionsHandy financial functionsWorking with text in ExcelCombining text from multiple cells into one stringRemoving extra spacesCopying cells containing formulas and pasting only their resulting valuesChanging the case of textRestricting cell entriesKey points
Exploring a built-in templatePerforming what-if analysesManaging multiple what-if modelsUsing the Quick Analysis toolsFormatting conditionallyAnalyzing data from another sourceFiltering data with tablesFilter menu commandsAdding data to tablesSorting dataCreating a custom sort listCreating a PivotTableKey points
Applying number formattingFormatting with stylesCreating custom themesFormatting in cellsWorking with custom number formatsWorking with percentage formatsWorking with fraction formatsWorking with date formatsProtecting worksheetsSetting view optionsStoring formats in templatesKey points
Inserting rows and columnsInserting and deleting cellsWorking with panes and page layout optionsPrinting row and column labels on every pageAdjusting page breaksCreating a multisheet workbookManipulating sheetsSummarizing a multisheet workbookWorking with sheet referencesManaging multiple workbooksKey points
Creating and modifying a chartAdding a slicer to a PivotChartManipulating chart elementsAdding a timeline to a chartManipulating objectsCreating and sharing graphicsUsing graphics elsewhereKey points
Setting up an email account in OutlookNavigating the Outlook interfaceDiscovering what’s new in Outlook 2013Key points
Creating and sending messagesAddressing messagesSaving and sending messagesAttaching files to messagesViewing messages and message attachmentsConfiguring Reading pane behaviorViewing Reading pane contentMarking messages as readSingle-key readingThe People paneResponding to messagesInline repliesKey points
Scheduling and changing appointmentsUsing Quick Entry mode to create date-specific eventsCreating recurring appointments and using appointment featuresCreating appointments from messagesConfiguring a Quick Step to create an appointment from an email messageScheduling and changing meetingsUpdating and canceling meetingsResponding to meeting requestsDisplaying different views of a calendarViewsArrangementsUsing the Date NavigatorCalendar item peeksKey points
Creating tasks from scratchSetting task optionsCreating tasks from Outlook itemsUpdating tasksRemoving tasks and items from task listsManaging task assignmentsReclaiming an assigned taskDealing with tasks other people assign to youKey points
Viewing contactsUsing the People HubViewing Contact CardsUsing contact viewsUsing the People peekCreating contactsUsing inline editingManaging linked contactsConfiguring a social network accountViewing social network updatesKey points
Flagging and reviewing important messagesApplying a message flagCategorizing a messageCreating a high-priority Quick StepReviewing high-priority messagesUsing the Calendar peek to plan your schedulePlanning ahead with the Weather barOrganizing your mail with Folder FavoritesRearranging key foldersSearching for related messagesFinding messages from a specific senderConducting quick searchesUsing Search Folders to view today’s mailCreating items quicklyCreating contextual appointments, contacts, and tasks from email messagesKey points
Getting started with OneNote 2013Exploring the OneNote interfaceIdentifying new and improved features in OneNote 2013Key points
Creating a notebookCreating and organizing sectionsSection groupsCreating and organizing pagesCreating subpagesAdding and organizing notesInserting imagesWorking with ink and shapesCustom pensShapesErasing ink or shapesInserting spaceArranging shapesRecovering deleted sections or pagesKey points
Using tagsCreating and customizing tagsUsing styles to format your notesConnecting OneNote to OutlookSending email messages to OneNoteConnecting appointments to OneNoteAnnotating contactsConnecting OneNote tasks to OutlookUsing hyperlinks to tie your notes togetherCreating custom hyperlinks to other pagesCreating and organizing tablesUsing the Insert Table featureSearching your notes to find information quicklyChanging your search scopeKey points
Creating a new notebook on SkyDriveMoving a notebook to SkyDriveStopping sharing in SkyDriveUsing a file server to share notesStopping sharing on a file serverSharing notes via SharePointSharing notes with others during a meetingSending notes via emailExporting to other formatsKey points
Syncing your notes by using SkyDriveAccessing your notes in a web browserUsing OneNote on your phone or tabletUsing OneNote on an iPhone or iPadUsing OneNote Mobile for AndroidUsing OneNote Mobile on a Windows PhoneUsing OneNote with a Windows 8 tabletKey points
Finding tagsRecording audioUsing Quick NotesUsing screen clippingUsing linked notesSearching your imagesInserting a spreadsheetUsing the Napkin Math featureFormatting with templatesKey points
Starting Access 2013Looking at the desktop database windowExploring the Web App windowDisplaying results in a browserDiscovering what’s new in Access 2013Key points
Creating a desktop databaseManaging trust locations and macro securityImporting and exporting dataImporting from another Access databaseExporting data from an Access databaseNavigating the user interfaceWorking with the tabsWorking with data in a datasheetSorting a datasheetFiltering a datasheetAdjusting the presentation of a datasheetWorking with a subdatasheetCopying and pasting from a datasheetChanging between tab pages and overlapping windowsConfiguring Access optionsLinking Access to external dataLinking to data in ExcelCompacting, repairing, and encrypting a databaseEncrypting with a passwordKey points
Creating tables for your dataCreating a table in Datasheet viewChoosing a field data typeAdding validation and calculated fields to your tablesAdding a table validation ruleAdding a calculated fieldIndexing a tableLinking tables together with relationshipsCreating a manual relationshipCreating a select queryCreating a query by selecting specific fieldsJoining multiple tables in a queryWorking with query criteriaFiltering and sorting a fieldAdding multiple criteria to a queryAdding parameters to queriesWorking with totals and crosstab queriesCrosstabulating dataKey points
Creating a continuous formWorking with a form in Layout viewCreating a datasheet with conditional formattingCreating a single record formCreating a single record form by using the Split Form templateCreating a parent/child formCreating a parent/child pop-up form by using the Form WizardTying your forms together with a navigation formCreating a single record reportCreating a tabular report with groupingCreating a continuous report with conditional formattingCreating a parent/child reportKey points
Signing in to Office 365Creating a blank Web AppOpening an existing Web AppImporting data from a spreadsheetImporting data from an Access desktop databaseNavigating a Web App with the table selectorNavigating a Web App with the Navigation paneLaunching a Web AppOpening a database in Access from Team SiteWorking with viewsWorking with a Datasheet viewWorking with a List Details viewAdding a new blank tableCreating a lookupCreating a summary viewCreating a Web App from a templateKey points
Exploring the Publisher 2013 user interfaceDiscovering what’s new in Publisher 2013Key points
Using templates to create publicationsAdding elements into your publicationsAdding business information to publicationsCustomizing the page design of a publicationCustomizing text font, color, and styleWorking with WordArt, text effects, and stylistic setsUsing picture placeholders and captionsImporting, swapping, and formatting picturesWorking with rulers, guides, baselines, and other toolsImporting Word documents into PublisherKey points
Saving your publicationsSharing publications via emailPrinting your publicationsSaving for photo printing or commercial printingExporting publications to PDF or XPS formatKey points