Learn Microsoft Office 2019
Linda Foulkes更新时间：2021-06-24 17:21:46
最新章节：Leave a review - let other readers know what you think封面
Title Page
Copyright and Credits
Learn Microsoft Office 2019
Dedication
About Packt
Why subscribe?
Contributors
About the author
About the reviewers
Packt is searching for authors like you
Preface
Who this book is for
What this book covers
To get the most out of this book
Download the example code files
Code in Action
Download the color images
Conventions used
Get in touch
Reviews
Section 1: Word
Exploring the Interface and Formatting Elements
Technical requirements
An overview of the interface features
The title bar
The QAT
Using tabs and groups
Using shortcut keys to access the ribbon
Accessing the rulers
Minimizing the ribbon
Adding items to the status bar
Using the help facility
Creating documents
Setting the printing options
Changing the page margins
Changing the page orientation
Changing the paper size
Changing the print options
Setting the collate and page options
Printing background colors and images
Setting pages to print
Inserting page breaks
Formatting text styles and paragraphs
Basic text formatting
Changing the font colors
Adding text effects
Removing text formatting
Changing the casing of text
Copying multiple formats
Formatting using font attributes
Changing the text alignment options
Applying a drop cap
Inserting special characters and symbols
Indenting paragraphs
Setting spacing before or after a paragraph
Adjusting the line spacing
Creating a new style
Modifying a style
Summary
Creating Lists and Constructing Advanced Tables
Technical requirements
Creating bulleted and numbered lists
Constructing a list automatically
Editing AutoFormat Options
Constructing a list manually
Modifying a bulleted or numbered list
Defining a new bullet symbol
Editing bulleted list font attributes
Inserting a custom picture as a bullet
Working with multilevel lists
Creating a multilevel list
Creating an outline (multilevel list) before typing a list
Creating an outline (multilevel list) after typing a list
Removing a multilevel list
Restarting numbering for a new list
LaTeX math
Working with tabbed lists
Selecting tab types
Typing a new tabbed list
Creating a list using the leader dot tab
Removing tabs in a document
Creating tables
Selecting skills
Editing and formatting tables
Merging cells
Splitting cells
Changing row/column height or width
Inserting rows or columns
Deleting rows or columns
Aligning cells in tables
Changing text direction
Distributing rows and columns evenly
Applying borders and shading
Customizing advanced tables
Converting a table to text
Defining the header row
Adding up cell values in a table
Sorting table contents
Summary
Creating Professional Documents
Technical requirements
Word-referencing features
Creating and updating the TOC
Using citations to build a bibliography
Adding citation sources
Generating the bibliography
Editing the citation style
Working with master documents or subdocuments
Constructing endnotes and footnotes
Inserting footnotes/endnotes
Converting footnotes into endnotes
Inserting links in a document
Performing a mail merge
Creating a mail merge manually
Creating a mail merge using the wizard
Constructing forms
Working with the Developer tab and form controls
Creating a basic form
Adding and modifying legacy form controls
Protecting a form
Customizing page layouts
Inserting a cover page quick part
Converting text into columns
Inserting and modifying section breaks
Viewing section breaks
Adding section breaks
Headers and footers
Inserting a header and footer
Inserting page numbers
Choosing a different first page
Numbering from a specific page number
Different header and footer sections
Summary
Versions Restrictions and Comparisons
Technical requirements
Recovering draft versions
Enabling the AutoSave and AutoRecover features
Recovering documents
Restricting access to documents and workbooks
Restricting access to document contents
Restricting access to workbook contents
Restricting changes to parts of a worksheet
Comparing and combining documents
Summary
Section 2: PowerPoint
The PowerPoint Interface and Presentation Options
Technical requirements
Introduction and new features
Creating presentation templates
Setting up slides and working with files
Setting slide size
Changing the slide orientation
Adding tags to a presentation
Searching using tags
Embedding fonts
Saving presentations in different formats
Saving presentation slides as pictures
Saving as a template
Saving a presentation as an outline
Saving as a presentation show
Exporting file types
Setting print options and layouts
Adjusting print settings
Previewing presentations
Using view and zoom options
Presentation Views using the ribbon
Using the status bar commands
Setting presentation zoom options
Switching between multiple presentations
Summary
Formatting Slides Tables Charts and Graphic Elements
Technical requirements
Setting up slides and applying layouts
Adding new slides
Duplicating selected slides
Deleting multiple slides simultaneously
Copying non-contiguous slides to other presentations
Inserting an outline
Reusing presentation slides
Applying slide layouts
Changing slide layouts
Working with themes and text manipulation
Duplicating moving and pasting text
Inserting and formatting lists
Add headers and footers to slides
Applying and modifying themes
Applying a theme to selected slides
Creating your own custom theme
Working with text boxes
Formatting text boxes
Applying a theme fill color
Applying a gradient
Applying a picture
Changing the outline color and weight
Arranging and manipulating objects
Arranging objects
Sending an object forward or backward
Flipping an object
Rotating an object
Aligning objects
Aligning objects to the top
Using the selection and visibility pane
Grouping objects
Resizing objects
Resetting objects
Constructing and modifying tables
Inserting a table
Inserting an Excel spreadsheet
Setting table style options
Inserting and modifying charts
Selecting a chart type
Entering chart data
Changing chart style
Changing the chart's quick layout
Working with chart elements
Data labels
Adding a data table
Displaying the chart legend
Adding objects to a chart
Changing the chart's title
Inserting audio and video
Inserting a video clip
Applying styles to video content
Resizing and positioning video content
Applying a style to an audio clip
Adjusting playback options
Summary
Photo Albums Sections and Show Tools
Technical requirements
Creating and modifying photo albums
Adding picture captions
Inserting text
Removing images
Inserting pictures in black and white
Reordering pictures
Adjusting image rotation brightness and contrast
Changing album layout
Picture layout
Frame shape
Theme
Working with presentation sections
Formatting sections
Applying animations and transitions
Adding animation effects
Applying effect options
Previewing animations automatically
Applying an animation effect to multiple objects
Using the Animation Pane
Setting up advanced animations
Removing animations
Setting animation timing
Setting start options
Selecting delay or duration options
Working with 3D models and cube animations
Inserting a 3D model
Animating a 3D model
Attaching sound to an animation
Using the Animation Painter features
Reordering animations
Working with transitions
Modifying the transition effect
Adding a transition sound
Modifying transition duration
Setting manual or automatic time advance options
Using the Morph transition
Using hyperlinks actions and comments
Adding hyperlinks
Launching a hyperlink
Hyperlinking to a slide in the same presentation
Easy linking
Editing a hyperlink
Adding actions
Using Zoom
Inserting and editing comments
Editing comments
Showing or hiding markup
Deleting comments
Inking feature
Exploring slide show options and custom shows
Setting up a slide show
Playing narrations
Setting up the presenter view
Using timings
Showing media controls
Creating a custom slide show
Using master slides and hiding slides
Creating master slides
Hiding slides
Summary
Section 3: Excel
Formatting Manipulating and Presenting Data Visually
Technical requirements
Introducing the interface and setting options
Identifying rows columns and cells
Workbooks and worksheets
Name Box and Formula Bar
Status bar
Setting view options
Using the help facility
Proofing tools
Changing default options
Changing the default username
Changing the default document location
Changing the default number of workbooks
Saving automatically
Constructing and formatting an Excel worksheet
Inputting data efficiently
Entering data into a set range
Entering data in non-contiguous ranges
Using fill down
Using a data entry form
Using Alt + down arrow
Entering dates and times
Copying data using AutoFill
Incrementing values
Modifying cell formatting
Aligning text
Changing text orientation
Wrapping text
Merging cells
Hiding and showing rows and columns
Inserting and deleting rows and columns
Setting column widths and row heights
Using the Format Painter
Creating and applying cell styles
Applying number formats
Working with worksheets and sheet tabs
Inserting worksheets
Deleting worksheets
Moving or copying worksheets
Renaming worksheets
Applying coloring to worksheet tabs
Sorting and filtering data
Finding and replacing data
Sorting ascending or descending
Filtering data
Defining a filter
Applying a filter
Removing a filter
Applying conditional formatting
Icon sets data bars and color scales
Setting print options
Adjusting breaks in the worksheet
Inserting manual breaks into the worksheet
Constructing headers and footers
Setting the header and footer distance
Setting the worksheet orientation
Setting the worksheet scale
Checking the paper size
Setting page margins
Aligning data horizontally and vertically
Printing a single worksheet
Printing selected worksheets
Creating charts based on worksheet data
Plotting non-contiguous data
Selecting a chart
Resizing a chart
Changing chart placement
Changing the chart type
Changing the chart style
Changing the Quick Layout
Changing chart elements manually
Changing the chart and axis titles
Displaying gridlines
Displaying the legend
Adding data labels
Adding a data table
Deleting a data series
Adding a data series
Changing the chart scale
Formatting the chart background
Adding objects to a chart
Using the sunburst chart type
Using funnel charts
Summary
Applying Formulas and Functions
Technical requirements
Learning basic formula operations
Order of evaluation
Constructing a formula
Learning Excel functions
Using the Show Formulas command
Converting values and percentage increase
Working out the percentage change
Working out a percentage increase or decrease
Percentage increase
Percentage decrease
Getting results using the status bar
Using the Function Library
Using the formula composer (Insert Function icon)
Editing formulas
Understanding relative versus absolute
Applying dates in calculations
To insert the current date
To insert the current date and time
To separate the day from a date
To calculate the number of days years and months between two dates
Using mathematical functions
The INT and ROUND functions
The ROUNDUP and ROUNDDOWN functions
The SUMIF function
Using the COUNTIF statistical function
Using financial functions - PMT
Applying conditional logic in a formula
The IF function
The AND function
The OR function
Using text functions
The CONCAT function
The TRIM function
Investigating formula errors
Applying named ranges in a formula
Defining a named range
Naming a range of cells
Editing a named range
Creating a named range from selected cells
Using range names in a formula
Summary
Analyzing and Organizing Data
Technical requirements
Consolidating data and investigating macros
Creating a summary sheet
Creating a macro
Adding a macro to the ribbon for easy access
Adding a macro to the QAT
Adding the macro to the ribbon tab
Removing a macro from the personal macro workbook
Creating and managing PivotTables and PivotCharts
Creating a PivotTable
Adding PivotTable fields
Grouping with PivotTables
Using slicers and timelines
Creating a PivotChart in Excel
Working with the 3D Maps feature
Using tools for analysis in Excel
Analysis ToolPak
What-if analysis
Understanding data models
Summary
Section 4: Common Tasks
Exporting and Optimizing Files and the Browser View
Technical requirements
Exporting files by changing the file type
Exporting a file as a previous version
Checking the compatibility mode of a file
Converting a file using compatibility mode
Exporting a file in .csv format (Excel only)
Exporting files as a PDF
Exporting slides as image files (PowerPoint only)
Exporting presentations as a video (PowerPoint only)
Packaging a presentation for transfer
Document properties (metadata)
Inspecting a file
Packaging a presentation (PowerPoint only)
Sending handouts from PowerPoint to Word
Optimizing and compressing media in PowerPoint
Investigating the browser view options (Excel only)
Summary
Sharing and Protecting Files
Technical requirements
Sharing and collaborating in Office 2019
Sharing a file via email
Sending as an attachment
Sharing via an email link
Sharing as a PDF
Sharing via the Adobe Acrobat license (Adobe PDF)
Sharing a file to OneDrive
Sending a document as a blog post
Sending a copy of a document via instant messaging
Sharing workbooks with others (Excel only)
Presenting online
Presenting online via Skype for Business
Presenting online via the Office Presentation Service
Protecting files in Office 2019
Marking a file as final
Using Protected View
Applying file protection
Requiring a password to access a file
Removing a password from a file
Summary
Section 5: Access
Database Organization and Setting Relationships
Technical requirements
Introduction to Access and the settings options
Advantages of using a database
Planning the database design
Operating a database
Orientation in the Access environment
Learning about database objects
Investigating tables
Querying data
Presenting with forms
Creating reports
Creating a new database
Setting up Access options
Setting up tabbed mode
Switching objects
Setting Shutter Bar options
Renaming objects
Switching between view modes
Applying application parts
Constructing tables and manipulating data
Creating tables in Datasheet View
Creating tables using the design view
Inserting table fields and data types
Building relationships
Learning relationship types and rules
Defining the primary key join type and referential integrity
Defining primary keys
Using a primary key to create a relationship
Deleting or editing relationships
Discussing join types
Changing join types
Setting up referential integrity
Cascading and updating
Summary
Building Forms and Report Design
Technical requirements
Building forms
Using the form wizard
Working with form views
Adding a new record to a form
Navigating and deleting form records
Applying and editing form headers
Adding existing fields to a form
Searching for data on a form
Form customization and layout
Resizing and moving form fields
Inserting a form's background image
Changing the form's background color
Applying a theme to a form
Using the Position options on a form
The report design controls and output
The Report View modes
Creating a report based on a table or query
Calculating in a report
Formatting values on a report
Creating a report header or footer
Applying the report formatting options
Applying the report's page setup tab options
Summary
Constructing Queries to Analyze Data
Technical requirements
Constructing basic queries
Creating a Select query in Design View
Creating a Select query using the Query Wizard
Manipulating query fields and the Total row
Adding fields
Removing and rearranging fields
Sorting query data
Compiling query criteria
Using wildcards in queries
Calculating totals with a query
Constructing advanced queries
Creating a two-table query in Design View
Constructing a calculated query
Creating a Make Table query
Using an Update query to replace data
Adding new records using an Append query
Building a Crosstab query
How relationships affect a query result
Using a Delete query
Creating a Parameter query
Summary
Section 6: Outlook
Creating and Attaching Item Content
Technical requirements
Investigating the Outlook environment
Accessing the Mini toolbar
Using the To-Do Bar
Using the Message pane to display folder items
The Navigation Pane
The Peek bar
Creating a shortcut to an item
Previewing Outlook items
Previewing emails in the Message pane
Using the Reading Pane
Manipulating Outlook program options
Using the Focused inbox option
Investigating mail options
Manipulating item tags
Categorizing items
Renaming categories
Assigning categories to items
Setting up a Quick Click
Setting flags
Adding a flag to a message and contact
Sending out a flag for recipients
Marking mail items as read/unread
Checking for new messages
Working with views filtering and printing
Changing the view type
Using the Reminders Window
Applying search and filter tools
Printing Outlook items
Printing attachments
Printing calendars
Printing tasks notes and contacts
Creating and sending email messages
Specifying a message theme
Showing/hiding the From and Bcc... fields
Configuring message delivery options
Setting the level of importance
Configuring voting and tracking options
Sending a message to a contact group
Moving copying and deleting email messages
Replying to and forwarding email messages
Sorting email messages
Creating and managing Quick Steps
Attaching item content
Attaching an Outlook item
Attaching external files
Summary
Managing Mail and Contacts
Technical requirements
Cleaning up the mailbox and managing rules
Cleaning up the mailbox
Viewing the mailbox size
Saving message attachments
Saving a message in an external format
Ignoring a conversation
Using cleanup tools
Creating and managing rules
Modifying rules
Deleting rules
Changing Rule order
Managing junk mail and automatic message content
Allowing a specific message (not junk)
Filtering junk mail with Never Block Sender
Viewing the safe senders' list
Blocking senders
Managing signatures
Creating a signature
Specifying the font for new HTML messages
Specifying options for replies and forwards
Setting a default theme for all HTML messages stationery and fonts
Creating contact information and groups
Modifying a default business card
Forwarding a contact
Creating and manipulating contact groups
Creating a contact group
Managing contact group membership
Showing notes about a contact group
Deleting a contact group
Sending a meeting to a contact group
Searching for a contact
Summary
Calendar Objects Tasks Notes and Journal Entries
Technical requirements
Working with the calendar appointments and events
Creating and manipulating appointments and events
Setting the appointment options
Printing the appointment details
Forwarding an appointment
Scheduling a meeting with someone who sent a message
Sharing a calendar
Modifying meeting requests and manipulating the calendar pane
Setting the response options
Updating a meeting request
Canceling a meeting or invitation
Proposing a new time for a meeting
Viewing the tracking status of a meeting
Editing a meeting series
Manipulating the calendar pane
Arranging the calendar view
Changing the calendar color
Changing the calendar's font settings
Displaying or hiding calendars
Creating a calendar group
Creating and managing tasks
Creating tasks
Managing the task details
Sending a status report
Assigning a task to another Outlook contact
Marking a task as complete
Accepting or declining a task assignment
Creating and manipulating notes and journal entries
Creating a note
Changing the current view
Categorizing notes
Working with journal entries
Tracking Outlook items and files
Setting out-of-office options
Summary
Other Books You May Enjoy
Leave a review - let other readers know what you think
更新时间：2021-06-24 17:21:46