Learn microsoft office 2019 : a guide to getting started with Word, PowerPoint, Excel, Access, and Outlook / Linda Foulkes.

Format:

Book

Author/Creator:

Foulkes, Linda, author.

Language:

English

Subjects (All):

Microsoft Office.

Business--Computer programs.

Business.

Physical Description:

1 online resource (776 pages)

Edition:

1st ed.

Place of Publication:

Birmingham, England ; Mumbai : Packt, [2020]

Summary:

This step by step guide is a comprehensive journey through the Office 2019 applications which include visual and detailed explanations of concepts and the opportunity to practice throughout using workplace examples. You will grasp the learning tools common for all Office applications.

Contents:

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

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

Chapter 3: Creating Professional Documents

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

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

Section 2: PowerPoint

Chapter 5: The PowerPoint Interface and Presentation Options

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

Chapter 6: Formatting Slides, Tables, Charts, and Graphic Elements

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

Chapter 7: Photo Albums, Sections, and Show Tools

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

Section 3: Excel

Chapter 8: Formatting, Manipulating, and Presenting Data Visually

Introducing the interface and setting options

Identifying rows, columns, and cells

Workbooks and worksheets

Name Box and Formula Bar

Status bar

Setting view options

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.

Notes:

Includes bibliographical references.

Description based on print version record.

Description based on publisher supplied metadata and other sources.

OCLC:

1157092975