Learn Microsoft Office 2019: A comprehensive guide to getting started with Word, PowerPoint, Excel, Access, and Outlook

Cover
Title Page
Copyright and Credits
Dedication
About Packt
Contributors
Table of Contents
Preface
Section 1: Word
Chapter 1: 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 
Chapter 2: 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 
Chapter 3: 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
Chapter 4: 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
Chapter 5: 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
Chapter 6: 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
Chapter 7: 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
Chapter 8: 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
Chapter 9: 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
Chapter 10: 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
Chapter 11: 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
Chapter 12: 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
Chapter 13: 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
Chapter 14: 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
Chapter 15: 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
Chapter 16: 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
Chapter 17: 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
Chapter 18: 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
Index