Learn Microsoft Office 2019

Table of contents

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