book

Office 365 All-in-One For Dummies

Name: Office 365 All-in-One For Dummies
ISBN: 9781119576242

by Peter Weverka, Timothy L. Warner

June 2019

Beginner to intermediate

800 pages

20h 7m

English

For Dummies

Read now

Unlock full access

Cover
Introduction
What Makes This Book DifferentFoolish AssumptionsConventions Used in This BookIcons Used in This BookBeyond the Book
Book 1: Common Office Tasks
Chapter 1: Office Nuts and Bolts
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”
Chapter 2: Wrestling with the Text
Manipulating the TextSpeaking, not Typing, the WordsChanging the Look of TextQuick Ways to Handle Case, or CapitalizationEntering Symbols and Foreign CharactersCreating Hyperlinks
Chapter 3: Speed Techniques Worth Knowing About
Undoing and Repeating CommandsZooming In, Zooming OutViewing a File through More than One WindowCorrecting Typos on the FlyEntering Text Quickly with the AutoCorrect Command
Book 2: Word 365
Chapter 1: Speed Techniques for Using Word
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
Chapter 2: Laying Out Text and Pages
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
Chapter 3: Word Styles
All about StylesApplying Styles to Text and ParagraphsCreating a New StyleModifying a StyleCreating and Managing Templates

Chapter 4: Constructing the Perfect Table
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
Chapter 5: Taking Advantage of the Proofing Tools
Correcting Your Spelling ErrorsCorrecting Grammatical ErrorsFinding and Replacing TextFinding the Right Word with the ThesaurusProofing Text Written in a Foreign LanguageTranslating Foreign Language Text
Chapter 6: Desktop Publishing with Word
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
Chapter 7: Getting Word’s Help with Office Chores
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
Chapter 8: Tools for Reports and Scholarly Papers
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
Book 3: Excel 365
Chapter 1: Up and Running with Excel
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
Chapter 2: Refining Your Worksheet
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
Chapter 3: Formulas and Functions for Crunching Numbers
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
Chapter 4: Making a Worksheet Easier to Read and Understand
Laying Out a WorksheetDecorating a Worksheet with Borders and ColorsGetting Ready to Print a Worksheet
Chapter 5: Advanced Techniques for Analyzing Data
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
Book 4: PowerPoint 365
Chapter 1: Getting Started in PowerPoint
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
Chapter 2: Fashioning a Look for Your Presentation
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
Chapter 3: Entering the Text
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
Chapter 4: Making Your Presentations Livelier
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
Chapter 5: Delivering a Presentation
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
Book 5: Outlook 365
Chapter 1: Outlook Basics
What Is Outlook, Anyway?Navigating the Outlook FoldersCategorizing ItemsSearching for Stray Folder ItemsDeleting Email Messages, Contacts, Tasks, and Other ItemsCleaning Out Your Folders
Chapter 2: Maintaining the Contacts Folder
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
Chapter 3: Handling Your Email
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)
Chapter 4: Managing Your Time and Schedule
Introducing the CalendarThe Different Kinds of ActivitiesSeeing Your ScheduleScheduling Appointments and EventsCanceling, Rescheduling, and Altering ActivitiesManaging Meetings with the Calendar
Chapter 5: Tasks, Reminders, and Notes
Tasks: Seeing What Needs to Get DoneReminders for Being Alerted to Activities and TasksMaking Notes to Yourself
Book 6: Access 365
Chapter 1: Introducing Access
What Is a Database, Anyway?Tables, Queries, Forms, and Other ObjectsCreating a Database FileFinding Your Way around the Navigation PaneDesigning a Database
Chapter 2: Building Your Database Tables
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
Chapter 3: Entering the Data
The Two Ways to Enter DataEntering the Data in Datasheet ViewEntering the Data in a FormFinding a Missing RecordFinding and Replacing Data
Chapter 4: Sorting, Querying, and Filtering for Data
Sorting Records in a Database TableFiltering to Find InformationQuerying: The BasicsSix Kinds of Queries
Chapter 5: Presenting Data in a Report
Creating a ReportOpening and Viewing ReportsTweaking a Report
Book 7: Publisher 365
Chapter 1: Introducing Publisher
“A Print Shop in a Can”Introducing FramesCreating a PublicationRedesigning a PublicationGetting a Better View of Your WorkUnderstanding and Using the Layout Guides
Chapter 2: Refining a Publication
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
Chapter 3: Putting on the Finishing Touches
Decorating the TextTechniques for Decorating PagesMaster Pages for Handling Page BackgroundsRunning the Design CheckerCommercially Printing a Publication
Book 8: Working with Charts and Graphics
Chapter 1: Creating a Chart
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
Chapter 2: Making a SmartArt Diagram
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
Chapter 3: Handling Graphics and Photos
All about Picture File FormatsInserting a Picture in an Office FileTouching Up a PictureCompressing Pictures to Save Disk Space
Chapter 4: Drawing and Manipulating Lines, Shapes, and Other Objects
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
Book 9: Office 365: One Step Beyond
Chapter 1: Customizing an Office Program
Customizing the RibbonCustomizing the Quick Access ToolbarCustomizing the Status BarChanging the Screen Background and Office ThemeCustomizing Keyboard Shortcuts in Word
Chapter 2: Ways of Distributing Your Work
Printing — the Old StandbyDistributing a File in PDF FormatSending Your File in an Email MessageSaving an Office File as a Web Page
Book 10: File Sharing and Collaborating
Chapter 1: Up and Running on OneDrive
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
Chapter 2: File Sharing and Collaborating
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
Chapter 3: Collaborating in SharePoint
Introducing Team SitesWorking with Document LibrariesDelving Deeper into Office 365
Chapter 4: Working Together in Teams
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
Index
About the Author
Advertisement Page
Connect with Dummies
End User License Agreement

Content preview from Office 365 All-in-One For Dummies

Chapter 2

Refining Your Worksheet

IN THIS CHAPTER

Changing worksheet data

Making notes and commenting on a worksheet

Copying and moving data

Hiding and protecting worksheets so that they can’t be altered

This chapter delves into the workaday world of worksheets (say that three times fast). It explains how to edit worksheet data and move quickly here and there in a worksheet. For the purposes of collaboration, you find out how to make notes and comments on worksheets. You also discover techniques for entering data quickly, selecting cells, and copying and moving data in cells. This chapter describes how to move, delete, and rename worksheets as well as protect them from being edited or altered.

Editing Worksheet Data

Not everyone enters data correctly the first time. To edit data you entered in a cell, do one of the following:

Double-click the cell. Doing so places the cursor squarely in the cell, where you can start deleting or entering numbers and text.
Click the cell and press F2. This technique also lands the cursor in the cell.
Click the cell you want to edit. With this ...

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

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

Publisher Resources

ISBN: 9781119576242Purchase book

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills

Office 365 All-in-One For Dummies

by Peter Weverka, Timothy L. Warner

Refining Your Worksheet

Editing Worksheet Data

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.