book

Office 365 All-in-One For Dummies

by Peter Weverka, Timothy L. Warner

June 2019

Beginner to intermediate

800 pages

20h 7m

English

For Dummies

Read now

Unlock full access

What Makes This Book DifferentFoolish AssumptionsConventions Used in This BookIcons Used in This BookBeyond the Book
Introducing Office 365Finding Your Way around the Office InterfaceSaving Your FilesNavigating the Save As and Open WindowsOpening and Closing FilesReading and Recording File PropertiesLocking a File with a PasswordTrusting (or not Trusting) Microsoft with Your “Content”
Manipulating the TextSpeaking, not Typing, the WordsChanging the Look of TextQuick Ways to Handle Case, or CapitalizationEntering Symbols and Foreign CharactersCreating Hyperlinks
Undoing and Repeating CommandsZooming In, Zooming OutViewing a File through More than One WindowCorrecting Typos on the FlyEntering Text Quickly with the AutoCorrect Command
Introducing the Word ScreenCreating a New DocumentGetting a Better Look at Your DocumentsSelecting Text in Speedy WaysMoving around Quickly in DocumentsInserting a Whole File into a DocumentGetting Word to Read ItEntering Information Quickly in a Computerized Form
Paragraphs and FormattingInserting a Section Break for Formatting PurposesBreaking a LineStarting a New PageSetting Up and Changing the MarginsIndenting Paragraphs and First LinesNumbering the PagesPutting Headers and Footers on PagesAdjusting the Space between LinesAdjusting the Space between ParagraphsCreating Numbered and Bulleted ListsWorking with TabsHyphenating Text
All about StylesApplying Styles to Text and ParagraphsCreating a New StyleModifying a StyleCreating and Managing Templates

Talking Table JargonCreating a TableEntering the Text and NumbersSelecting Different Parts of a TableLaying Out Your TableAligning Text in Columns and RowsMerging and Splitting CellsRepeating Header Rows on Subsequent PagesFormatting Your TableUsing Math Formulas in TablesNeat Table Tricks
Correcting Your Spelling ErrorsCorrecting Grammatical ErrorsFinding and Replacing TextFinding the Right Word with the ThesaurusProofing Text Written in a Foreign LanguageTranslating Foreign Language Text
Experimenting with ThemesSprucing Up Your PagesMaking Use of Charts, Diagrams, Shapes, and PhotosWorking with the Drawing CanvasPositioning and Wrapping Objects Relative to the Page and TextWorking with Text BoxesDropping in a Drop CapWatermarking for the Elegant EffectPutting Newspaper-Style Columns in a DocumentLandscape DocumentsPrinting on Different Size PaperShowing Online Video in a Document
Highlighting Parts of a DocumentCommenting on a DocumentTracking Changes to DocumentsPrinting an Address on an EnvelopePrinting a Single Address Label (or a Page of the Same Label)Churning Out Letters, Envelopes, and Labels for Mass Mailings
Alphabetizing a ListOutlines for Organizing Your WorkCollapsing and Expanding Parts of a DocumentGenerating a Table of ContentsIndexing a DocumentPutting Cross-References in a DocumentPutting Footnotes and Endnotes in DocumentsCompiling a Bibliography
Creating a New Excel WorkbookGetting Acquainted with ExcelEntering Data in a WorksheetQuickly Entering Lists and Serial Data with the AutoFill CommandFormatting Numbers, Dates, and Time ValuesEstablishing Data-Validation Rules
Editing Worksheet DataMoving around in a WorksheetGetting a Better Look at the WorksheetNotes for Documenting Your WorksheetComments for Collaborating with Others on a WorkbookSelecting Cells in a WorksheetDeleting, Copying, and Moving DataHandling the Worksheets in a WorkbookKeeping Others from Tampering with Worksheets
How Formulas WorkThe Basics of Entering a FormulaSpeed Techniques for Entering FormulasCopying Formulas from Cell to CellDetecting and Correcting Errors in FormulasWorking with FunctionsA Look at Some Very Useful Functions
Laying Out a WorksheetDecorating a Worksheet with Borders and ColorsGetting Ready to Print a Worksheet
Seeing What the Sparklines SayConditional Formats for Calling Attention to DataManaging Information in ListsForecasting with the Goal Seek CommandPerforming What-If Analyses with Data TablesAnalyzing Data with PivotTables
Getting Acquainted with PowerPointA Brief Geography LessonA Whirlwind Tour of PowerPointCreating a New PresentationAdvice for Building Persuasive PresentationsCreating New Slides for Your PresentationGetting a Better View of Your WorkHiding and Displaying the Slides Pane and Notes PaneSelecting, Moving, and Deleting SlidesPutting Together a Photo AlbumHidden Slides for All Contingencies
Looking at Themes and Slide BackgroundsChoosing a Theme for Your PresentationCreating Slide Backgrounds on Your OwnChanging the Background of a Single or Handful of SlidesChoosing the Slide SizeUsing Master Slides and Master Styles for a Consistent Design
Entering TextFun with Text Boxes and Text Box ShapesControlling How Text Fits in Text Frames and Text BoxesPositioning Text in Frames and Text BoxesHandling Bulleted and Numbered ListsPutting Footers (and Headers) on Slides
Suggestions for Enlivening Your PresentationPresenting Information in a TableExploring Transitions and AnimationsMaking Audio Part of Your PresentationPlaying Video on SlidesRecording a Voice Narration for Slides
All about NotesRehearsing and Timing Your PresentationShowing Your PresentationTricks for Making Presentations a Little LivelierDelivering a Presentation When You Can’t Be There in Person
What Is Outlook, Anyway?Navigating the Outlook FoldersCategorizing ItemsSearching for Stray Folder ItemsDeleting Email Messages, Contacts, Tasks, and Other ItemsCleaning Out Your Folders
Maintaining a Happy and Healthy Contacts FolderContact Groups for Sending Messages to GroupsFinding a Contact in the Contacts FolderLinking Duplicate ContactsSharing Contacts with CoworkersPrinting the Contacts Folder
Setting Up an Email AccountAddressing and Sending Email MessagesSending Files and PhotosReceiving Email MessagesReading Your Email in the Inbox WindowHandling Files That Were Sent to YouTechniques for Organizing Email MessagesAll about Email FoldersYes, You Can Prevent Junk Mail (Sort of)
Introducing the CalendarThe Different Kinds of ActivitiesSeeing Your ScheduleScheduling Appointments and EventsCanceling, Rescheduling, and Altering ActivitiesManaging Meetings with the Calendar
Tasks: Seeing What Needs to Get DoneReminders for Being Alerted to Activities and TasksMaking Notes to Yourself
What Is a Database, Anyway?Tables, Queries, Forms, and Other ObjectsCreating a Database FileFinding Your Way around the Navigation PaneDesigning a Database
Creating a Database TableOpening and Viewing TablesEntering and Altering Table FieldsField Properties for Making Sure That Data Entries Are AccurateIndexing for Faster Sorts, Searches, and QueriesEstablishing Relationships among Database Tables
The Two Ways to Enter DataEntering the Data in Datasheet ViewEntering the Data in a FormFinding a Missing RecordFinding and Replacing Data
Sorting Records in a Database TableFiltering to Find InformationQuerying: The BasicsSix Kinds of Queries
Creating a ReportOpening and Viewing ReportsTweaking a Report
“A Print Shop in a Can”Introducing FramesCreating a PublicationRedesigning a PublicationGetting a Better View of Your WorkUnderstanding and Using the Layout Guides
Entering Text on the PagesMaking Text Fit in Text FramesFormatting TextMaking Text Wrap around a Frame or GraphicReplacing the Placeholder PicturesInserting Frames on the PagesMaking Frames OverlapInserting, Removing, and Moving Pages
Decorating the TextTechniques for Decorating PagesMaster Pages for Handling Page BackgroundsRunning the Design CheckerCommercially Printing a Publication
The Basics: Creating a ChartChoosing the Right ChartProviding the Raw Data for Your ChartPositioning Your Chart in a Workbook, Page, or SlideChanging a Chart’s AppearanceSaving a Chart as a Template So That You Can Use It AgainChart Tricks for the Daring and HeroicTroubleshooting a Chart
The Basics: Creating SmartArt DiagramsCreating the Initial DiagramChanging the Size and Position of a DiagramLaying Out the Diagram ShapesHandling the Text on Diagram ShapesChanging a Diagram’s DirectionChoosing a Look for Your DiagramChanging the Appearance of Diagram ShapesCreating a Diagram from Scratch
All about Picture File FormatsInserting a Picture in an Office FileTouching Up a PictureCompressing Pictures to Save Disk Space
The Basics: Making Lines, Arrows, and ShapesHandling Lines, Arrows, and ConnectorsHandling Rectangles, Ovals, Stars, and Other ShapesDrawing by FreehandDecorating Your Work with IconsInserting a 3-D ModelWordArt for Embellishing Letters and WordsManipulating Lines, Shapes, Art, Text Boxes, and Other ObjectsChanging an Object’s Size and ShapeChanging an Object’s Color, Outline Color, and TransparencyMoving and Positioning Objects
Customizing the RibbonCustomizing the Quick Access ToolbarCustomizing the Status BarChanging the Screen Background and Office ThemeCustomizing Keyboard Shortcuts in Word
Printing — the Old StandbyDistributing a File in PDF FormatSending Your File in an Email MessageSaving an Office File as a Web Page
Signing in to OneDriveExploring the OneDrive WindowManaging Your OneDrive FoldersUploading Files to a Folder on OneDriveSaving a File from Office 365 to OneDriveOpening a File from OneDriveDownloading Files from OneDrive to Your Computer
Sharing Files: The Big PictureSharing Your Files and Folders with OthersSeeing Files and Folders Others Shared with YouInvestigating and Managing How Files and Folders Are Shared
Introducing Team SitesWorking with Document LibrariesDelving Deeper into Office 365
Introducing Microsoft Teams and ChannelsSetting Your StatusAll about ConversationsChatting Privately with a ColleagueFiltering and SearchingChoosing Notification SettingsSharing and Editing Files with CoworkersHolding Meetings with Coworkers

Overview

The deepest reference on Microsoft’s productivity service

Office 365 offers the same productivity power as past versions of Microsoft Office along with tools designed to boost collaboration in the workplace and instant access to the latest Office updates without buying a whole new software package. It’s an ideal solution for both the office and home use.

The author of the bestselling Office All-in-One For Dummies shares his advice on how to navigate the nuts and bolts of getting things done with Office 365. Look inside for step-by-step instructions on Excel, Outlook, Word, PowerPoint, Access, and OneNote along with a dive into the cloud services that come with Office 365.

Access Office 365
Make sense of common Office tasks
Use Excel, Word, outlook, PowerPoint and more
Take advantage of 365 online services

If you’re a home or business user interested in having a complete reference on the suite, this book has you covered.

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.

Start your free trial

Office 365 All-in-One For Dummies, 2nd Edition

Publisher Resources

ISBN: 9781119576242Purchase book

Office 365 All-in-One For Dummies

by Peter Weverka, Timothy L. Warner

Overview

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.

You might also like