book

Microsoft® Office 2013 QuickSteps, 3rd Edition

by Carole Matthews, Marty Matthews, Bobbi Sandberg

July 2013

Beginner

360 pages

13h

English

McGraw-Hill

Read now

Unlock full access

Cover
Title Page
Copyright Page
Contents at a Glance
Contents
About the Authors
Acknowledgments
Introduction
Conventions Used in This Book
Chapter 1: Stepping into Office
Open and Close an Office ProgramStart an Office Program in Windows 7Start an Office Program in Windows 8Close an Office ProgramOpen, Close, and Save an Office DocumentUsing TouchOpen a New Office DocumentLocate and Open an Existing DocumentUsing TemplatesUsing SkyDriveSave a Document for the First TimeSave a Document AutomaticallySave a Document as a Copy or as a TemplateClose an Office DocumentExplore an Office ProgramExplore an Office Program WindowUnderstanding the RibbonUse the MouseUse the Mini ToolbarUse Tabs and MenusUse Various ViewsPersonalize and Customize Office 2013 ProgramsWork with the Quick Access ToolbarShow or Hide ScreenTipsChange the Screen ColorAdd Identifying InformationSet General PreferencesUse AutoCorrectUse Common Office ToolsOpen HelpUse the ThesaurusTranslate a DocumentUse the Office ClipboardCheck SpellingMake Accessibility Changes

Chapter 2: Working with Documents in Word
Step into WordUse the Start Screen for WordCreate a New DocumentLocate and Open an Existing DocumentImport a DocumentUsing View ButtonsWrite a DocumentEnter TextDetermine Where Text Will AppearInsert Text or Type Over ItInsert Line or Page BreaksSelect TextCopy and Move TextDelete TextEnter Symbols and Special CharactersNavigate a DocumentMove Around in a DocumentFind and Replace TextUsing WildcardsUse Word Writing AidsUse Building BlocksCount Characters and WordsUse HighlightingAdd Hyphenation
Chapter 3: Formatting a Document
Format TextSurvey the Text-Formatting ToolsApply Character FormattingReset Font DefaultsChange Character Spacing and OpenType FeaturesChange CapitalizationCreate a Drop CapFormat a ParagraphSurvey the Paragraph-Formatting ToolsSet Paragraph AlignmentIndenting a ParagraphChange and Remove IndentsUse the Ruler for IndentsUnderstand Line and Paragraph SpacingSet Line SpacingUse Numbered and Bulleted ListsDefine New Multilevel ListsAdd Horizontal Lines, Borders, and ShadingFormat a PageTurn On Formatting MarksSet MarginsCopy FormattingUse the Page Setup Dialog Box to Format a PageUse Mirror Margins with the MenuDetermine Page OrientationSpecify Paper SizeTrack Inconsistent FormattingSet Vertical Alignment
Chapter 4: Customizing a Document
Use StylesUnderstanding Themes and StylesIdentify Text with a StyleApply Predefined Style Sets to a DocumentCreate a New StyleModify a StyleClear a Style from Text or a DocumentDelete/Restore a Style from the GalleryExamine Current StylesUse ThemesAssign a Theme to Your DocumentChange a ThemeCreate a Custom ThemeWork with DocumentsCreate Section BreaksCreate and Use ColumnsUse TabsAdd Headers and FootersAdd Footnotes and EndnotesCreate an IndexCreate a Table of ContentsHandling SubdocumentsCreate and Use Outlines
Chapter 5: Entering and Editing Data in Excel
Enter DataUnderstanding Data TypesEnter TextComplete an EntryEnter Numeric DataEnter DatesFormat NumbersUse TimesUnderstanding Excel Dates and TimesAdd Data QuicklyEdit DataEdit Cell DataRemove Cell ContentsSelect Cells and RangesCopy and Paste DataFind and Replace DataVerify SpellingModify Automatic CorrectionsEdit Workbooks in the Excel Web App
Chapter 6: Formatting a Worksheet in Excel
Work with Cells, Rows, and ColumnsAdjust Row HeightAdjust Column WidthHide and Unhide Rows and ColumnsAdd and Remove Rows, Columns, and CellsChange Cell BordersAdd a CommentFormat CommentsApply FormattingUnderstanding Excel FormattingApply ThemesCreate Custom ThemesSearch for ThemesUse Cell StylesChange FontsChange Alignment and OrientationAdd a BackgroundCopy FormattingArrange and Organize WorksheetsLock Rows and ColumnsSplit a WorksheetWork with WorksheetsView Worksheets from Multiple WorkbooksCompare Workbooks
Chapter 7: Using Formulas and Functions
Reference CellsUnderstanding Cell Referencing TypesChange Cell ReferencesChange to R1C1 ReferencesUse Cell Reference OperatorsName CellsGo to a Named CellUse the Name ManagerBuild FormulasCreate a FormulaEdit a FormulaUse FormulasMove FormulasCopy FormulasRecalculate FormulasUse External References in FormulasAdd a Symbolic FormulaUnderstanding the Trust CenterFormat ConditionallyUse FunctionsUse Functions QuicklyEnter a FunctionEnter a Sum in Columns or Rows QuicklyFind and Correct ErrorsCheck for ErrorsTrace Precedent and Dependent CellsWatch a CellEvaluate a Formula in Pieces
Chapter 8: Creating a Presentation in PowerPoint
Step into PowerPointUse the PowerPoint Start ScreenSee the PowerPoint ViewsUnderstanding PowerPoint TerminologyTake the PowerPoint TourUse PowerPoint Ribbon TabsUsing Menus and “Launchers” from the RibbonCreate a PresentationCreate a Presentation from Another PresentationCreate a Presentation Using a TemplateCreate a Presentation from ScratchComplete Your Look and ContentChoose a Slide LayoutApply Themes to SlidesAdd Content to a SlideOutline a PresentationCreate an OutlineUnderstanding the Outlining FeatureUse the Outlining CommandsPreview and Print the Outline
Chapter 9: Working with Slides
Navigate and Manipulate SlidesNavigate from Slide to SlideInsert a SlideDisplay Multiple Presentations at OnceDuplicate One or More SlidesMove or Copy SlidesReviewing the Paste OptionsCopy a Design Using BrowseUse ZoomUse a Keyboard with SlidesUsing Variants of ThemesChange the Look and Feel of SlidesChange a ThemeCreate a Custom ThemeCopy Attributes with the Format PainterWork with HyperlinksUse Footers on SlidesWork with TextUse a Text LayoutInsert a New Text BoxChanging Font AttributesChange Regular Text to WordArt StylesWork with Text BoxesUse ListsUse the Font Dialog BoxAlign TextMoving or Copying TextSpiff Up Your Presentation with SmartArtUse Transitions and AnimationsWork with TransitionsAdd Animations to Your Slides
Chapter 10: Polishing and Publishing Your Presentations
Work with Master SlidesEdit a Slide Master or Layout MasterPerform Additional Slide Master TasksUnderstand the Slide Master RibbonWork with the Notes MasterChange the Handout MasterWork with NotesDisplay the Notes PaneUnderstanding PowerPoint Images and IllustrationsPreview Speaker NotesUse Headers and Footers on Notes and HandoutsPrint Notes and HandoutsShare Your PresentationShare in a Variety of WaysExport Your PresentationPresent a Slide ShowSet Controls for Two MonitorsUnderstanding Equipment Setup for Presenting with Dual MonitorsChoosing a Presentation FormatSet Up Your Slide ShowUse a Presenter View Slide ShowStart the Slide ShowSet Up an Automated Slide ShowRecord Narrations and TimingsRehearse Your Timing
Chapter 11: Using Outlook
Set Up E-mailSet Up Your Outlook AccountUpgrade to OutlookExplore OutlookExplore the Outlook WindowChange ViewsUse the Navigation PaneReceive E-mailCheck for E-mailRead E-mailFilter Junk MailWrite MessagesCreate a MessageAddress a MessageAdd Carbon and Blind CopiesEdit a MessageAttach FilesIncluding HyperlinksSend MessagesReply to MessagesForward MessagesHandle E-mail MessagesFind a MessageArchiving MessagesDelete MessagesManage AttachmentsCreate Contacts in People ViewAdd a New ContactCreate a Contact GroupExplore the CalendarCreate an AppointmentCreate a New Task
Chapter 12: Printing, Using Mail Merge, and Working with Graphics
Print DocumentsSet a Default PrinterDefine How a Document Is PrintedPrint a DocumentMerge Lists with Letters and EnvelopesPerform a Mail Merge Using the WizardUse RulesMerge to EnvelopesMerge to LabelsWork with GraphicsAdd PicturesUsing the Picture Tools Format TabRemove Unwanted AreasAdd ShapesCreate a DiagramTake a ScreenshotModify GraphicsUnderstanding Graphic Positioning in Office ProgramsResize and Rotate Graphics PreciselyPosition GraphicsWork with GraphicsCombine Graphics by Grouping
Index

Content preview from Microsoft® Office 2013 QuickSteps, 3rd Edition

Acknowledgments

This book is a team effort of truly talented people. Among them are

Roger Stewart, sponsoring editor, believed in us enough to sell the series, and continues to stand behind us as we go through the fourth edition. Thanks, Roger!

Janet Walden and Nidhi Chopra, project editors, greased the wheels and straightened the track to make a very smooth production process. Thanks, Janet and Nidhi!

John Cronan, technical editor, made sure our text was accurate and complete. It is a better book because of his excellence. Thanks, John!

William McManus, copy editor, added greatly to the readability and understandability of the book with excellence and intelligence. Thanks, Bill!

Claire Splan, proofreader, found all those sneaky discrepancies ...

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

Microsoft® Excel® 2013 QuickSteps, 3rd Edition

Publisher Resources

ISBN: 9780071805872

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills

Microsoft® Office 2013 QuickSteps, 3rd Edition

by Carole Matthews, Marty Matthews, Bobbi Sandberg

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.