Log In
Or create an account ->
Imperial Library
Home
About
News
Upload
Forum
Help
Login/SignUp
Index
Cover
Table of Contents
Introduction
What Makes This Book Different
Foolish Assumptions
Conventions Used in This Book
Icons Used in This Book
Beyond the Book
Book 1: Common Office Tasks
Chapter 1: Office Nuts and Bolts
Introducing Office 365
Finding Your Way around the Office Interface
Saving Your Files
Navigating the Save As and Open Windows
Opening and Closing Files
Reading and Recording File Properties
Locking a File with a Password
Trusting (or not Trusting) Microsoft with Your “Content”
Chapter 2: Wrestling with the Text
Manipulating the Text
Speaking, not Typing, the Words
Changing the Look of Text
Quick Ways to Handle Case, or Capitalization
Entering Symbols and Foreign Characters
Creating Hyperlinks
Chapter 3: Speed Techniques Worth Knowing About
Undoing and Repeating Commands
Zooming In, Zooming Out
Viewing a File through More than One Window
Correcting Typos on the Fly
Entering Text Quickly with the AutoCorrect Command
Book 2: Word 365
Chapter 1: Speed Techniques for Using Word
Introducing the Word Screen
Creating a New Document
Getting a Better Look at Your Documents
Selecting Text in Speedy Ways
Moving around Quickly in Documents
Inserting a Whole File into a Document
Getting Word to Read It
Entering Information Quickly in a Computerized Form
Chapter 2: Laying Out Text and Pages
Paragraphs and Formatting
Inserting a Section Break for Formatting Purposes
Breaking a Line
Starting a New Page
Setting Up and Changing the Margins
Indenting Paragraphs and First Lines
Numbering the Pages
Putting Headers and Footers on Pages
Adjusting the Space between Lines
Adjusting the Space between Paragraphs
Creating Numbered and Bulleted Lists
Working with Tabs
Hyphenating Text
Chapter 3: Word Styles
All about Styles
Applying Styles to Text and Paragraphs
Creating a New Style
Modifying a Style
Creating and Managing Templates
Chapter 4: Constructing the Perfect Table
Talking Table Jargon
Creating a Table
Entering the Text and Numbers
Selecting Different Parts of a Table
Laying Out Your Table
Aligning Text in Columns and Rows
Merging and Splitting Cells
Repeating Header Rows on Subsequent Pages
Formatting Your Table
Using Math Formulas in Tables
Neat Table Tricks
Chapter 5: Taking Advantage of the Proofing Tools
Correcting Your Spelling Errors
Correcting Grammatical Errors
Finding and Replacing Text
Finding the Right Word with the Thesaurus
Proofing Text Written in a Foreign Language
Translating Foreign Language Text
Chapter 6: Desktop Publishing with Word
Experimenting with Themes
Sprucing Up Your Pages
Making Use of Charts, Diagrams, Shapes, and Photos
Working with the Drawing Canvas
Positioning and Wrapping Objects Relative to the Page and Text
Working with Text Boxes
Dropping in a Drop Cap
Watermarking for the Elegant Effect
Putting Newspaper-Style Columns in a Document
Landscape Documents
Printing on Different Size Paper
Showing Online Video in a Document
Chapter 7: Getting Word’s Help with Office Chores
Highlighting Parts of a Document
Commenting on a Document
Tracking Changes to Documents
Printing an Address on an Envelope
Printing 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 List
Outlines for Organizing Your Work
Collapsing and Expanding Parts of a Document
Generating a Table of Contents
Indexing a Document
Putting Cross-References in a Document
Putting Footnotes and Endnotes in Documents
Compiling a Bibliography
Book 3: Excel 365
Chapter 1: Up and Running with Excel
Creating a New Excel Workbook
Getting Acquainted with Excel
Entering Data in a Worksheet
Quickly Entering Lists and Serial Data with the AutoFill Command
Formatting Numbers, Dates, and Time Values
Establishing Data-Validation Rules
Chapter 2: Refining Your Worksheet
Editing Worksheet Data
Moving around in a Worksheet
Getting a Better Look at the Worksheet
Notes for Documenting Your Worksheet
Comments for Collaborating with Others on a Workbook
Selecting Cells in a Worksheet
Deleting, Copying, and Moving Data
Handling the Worksheets in a Workbook
Keeping Others from Tampering with Worksheets
Chapter 3: Formulas and Functions for Crunching Numbers
How Formulas Work
The Basics of Entering a Formula
Speed Techniques for Entering Formulas
Copying Formulas from Cell to Cell
Detecting and Correcting Errors in Formulas
Working with Functions
A Look at Some Very Useful Functions
Chapter 4: Making a Worksheet Easier to Read and Understand
Laying Out a Worksheet
Decorating a Worksheet with Borders and Colors
Getting Ready to Print a Worksheet
Chapter 5: Advanced Techniques for Analyzing Data
Seeing What the Sparklines Say
Conditional Formats for Calling Attention to Data
Managing Information in Lists
Forecasting with the Goal Seek Command
Performing What-If Analyses with Data Tables
Analyzing Data with PivotTables
Book 4: PowerPoint 365
Chapter 1: Getting Started in PowerPoint
Getting Acquainted with PowerPoint
A Brief Geography Lesson
A Whirlwind Tour of PowerPoint
Creating a New Presentation
Advice for Building Persuasive Presentations
Creating New Slides for Your Presentation
Getting a Better View of Your Work
Hiding and Displaying the Slides Pane and Notes Pane
Selecting, Moving, and Deleting Slides
Putting Together a Photo Album
Hidden Slides for All Contingencies
Chapter 2: Fashioning a Look for Your Presentation
Looking at Themes and Slide Backgrounds
Choosing a Theme for Your Presentation
Creating Slide Backgrounds on Your Own
Changing the Background of a Single or Handful of Slides
Choosing the Slide Size
Using Master Slides and Master Styles for a Consistent Design
Chapter 3: Entering the Text
Entering Text
Fun with Text Boxes and Text Box Shapes
Controlling How Text Fits in Text Frames and Text Boxes
Positioning Text in Frames and Text Boxes
Handling Bulleted and Numbered Lists
Putting Footers (and Headers) on Slides
Chapter 4: Making Your Presentations Livelier
Suggestions for Enlivening Your Presentation
Presenting Information in a Table
Exploring Transitions and Animations
Making Audio Part of Your Presentation
Playing Video on Slides
Recording a Voice Narration for Slides
Chapter 5: Delivering a Presentation
All about Notes
Rehearsing and Timing Your Presentation
Showing Your Presentation
Tricks for Making Presentations a Little Livelier
Delivering 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 Folders
Categorizing Items
Searching for Stray Folder Items
Deleting Email Messages, Contacts, Tasks, and Other Items
Cleaning Out Your Folders
Chapter 2: Maintaining the Contacts Folder
Maintaining a Happy and Healthy Contacts Folder
Contact Groups for Sending Messages to Groups
Finding a Contact in the Contacts Folder
Linking Duplicate Contacts
Sharing Contacts with Coworkers
Printing the Contacts Folder
Chapter 3: Handling Your Email
Setting Up an Email Account
Addressing and Sending Email Messages
Sending Files and Photos
Receiving Email Messages
Reading Your Email in the Inbox Window
Handling Files That Were Sent to You
Techniques for Organizing Email Messages
All about Email Folders
Yes, You Can Prevent Junk Mail (Sort of)
Chapter 4: Managing Your Time and Schedule
Introducing the Calendar
The Different Kinds of Activities
Seeing Your Schedule
Scheduling Appointments and Events
Canceling, Rescheduling, and Altering Activities
Managing Meetings with the Calendar
Chapter 5: Tasks, Reminders, and Notes
Tasks: Seeing What Needs to Get Done
Reminders for Being Alerted to Activities and Tasks
Making Notes to Yourself
Book 6: Access 365
Chapter 1: Introducing Access
What Is a Database, Anyway?
Tables, Queries, Forms, and Other Objects
Creating a Database File
Finding Your Way around the Navigation Pane
Designing a Database
Chapter 2: Building Your Database Tables
Creating a Database Table
Opening and Viewing Tables
Entering and Altering Table Fields
Field Properties for Making Sure That Data Entries Are Accurate
Indexing for Faster Sorts, Searches, and Queries
Establishing Relationships among Database Tables
Chapter 3: Entering the Data
The Two Ways to Enter Data
Entering the Data in Datasheet View
Entering the Data in a Form
Finding a Missing Record
Finding and Replacing Data
Chapter 4: Sorting, Querying, and Filtering for Data
Sorting Records in a Database Table
Filtering to Find Information
Querying: The Basics
Six Kinds of Queries
Chapter 5: Presenting Data in a Report
Creating a Report
Opening and Viewing Reports
Tweaking a Report
Book 7: Publisher 365
Chapter 1: Introducing Publisher
“A Print Shop in a Can”
Introducing Frames
Creating a Publication
Redesigning a Publication
Getting a Better View of Your Work
Understanding and Using the Layout Guides
Chapter 2: Refining a Publication
Entering Text on the Pages
Making Text Fit in Text Frames
Formatting Text
Making Text Wrap around a Frame or Graphic
Replacing the Placeholder Pictures
Inserting Frames on the Pages
Making Frames Overlap
Inserting, Removing, and Moving Pages
Chapter 3: Putting on the Finishing Touches
Decorating the Text
Techniques for Decorating Pages
Master Pages for Handling Page Backgrounds
Running the Design Checker
Commercially Printing a Publication
Book 8: Working with Charts and Graphics
Chapter 1: Creating a Chart
The Basics: Creating a Chart
Choosing the Right Chart
Providing the Raw Data for Your Chart
Positioning Your Chart in a Workbook, Page, or Slide
Changing a Chart’s Appearance
Saving a Chart as a Template So That You Can Use It Again
Chart Tricks for the Daring and Heroic
Troubleshooting a Chart
Chapter 2: Making a SmartArt Diagram
The Basics: Creating SmartArt Diagrams
Creating the Initial Diagram
Changing the Size and Position of a Diagram
Laying Out the Diagram Shapes
Handling the Text on Diagram Shapes
Changing a Diagram’s Direction
Choosing a Look for Your Diagram
Changing the Appearance of Diagram Shapes
Creating a Diagram from Scratch
Chapter 3: Handling Graphics and Photos
All about Picture File Formats
Inserting a Picture in an Office File
Touching Up a Picture
Compressing Pictures to Save Disk Space
Chapter 4: Drawing and Manipulating Lines, Shapes, and Other Objects
The Basics: Making Lines, Arrows, and Shapes
Handling Lines, Arrows, and Connectors
Handling Rectangles, Ovals, Stars, and Other Shapes
Drawing by Freehand
Decorating Your Work with Icons
Inserting a 3-D Model
WordArt for Embellishing Letters and Words
Manipulating Lines, Shapes, Art, Text Boxes, and Other Objects
Changing an Object’s Size and Shape
Changing an Object’s Color, Outline Color, and Transparency
Moving and Positioning Objects
Book 9: Office 365: One Step Beyond
Chapter 1: Customizing an Office Program
Customizing the Ribbon
Customizing the Quick Access Toolbar
Customizing the Status Bar
Changing the Screen Background and Office Theme
Customizing Keyboard Shortcuts in Word
Chapter 2: Ways of Distributing Your Work
Printing — the Old Standby
Distributing a File in PDF Format
Sending Your File in an Email Message
Saving an Office File as a Web Page
Book 10: File Sharing and Collaborating
Chapter 1: Up and Running on OneDrive
Signing in to OneDrive
Exploring the OneDrive Window
Managing Your OneDrive Folders
Uploading Files to a Folder on OneDrive
Saving a File from Office 365 to OneDrive
Opening a File from OneDrive
Downloading Files from OneDrive to Your Computer
Chapter 2: File Sharing and Collaborating
Sharing Files: The Big Picture
Sharing Your Files and Folders with Others
Seeing Files and Folders Others Shared with You
Investigating and Managing How Files and Folders Are Shared
Chapter 3: Collaborating in SharePoint
Introducing Team Sites
Working with Document Libraries
Delving Deeper into Office 365
Chapter 4: Working Together in Teams
Introducing Microsoft Teams and Channels
Setting Your Status
All about Conversations
Chatting Privately with a Colleague
Filtering and Searching
Choosing Notification Settings
Sharing and Editing Files with Coworkers
Holding Meetings with Coworkers
Index
About the Author
Advertisement Page
Connect with Dummies
End User License Agreement
← Prev
Back
Next →
← Prev
Back
Next →