Sign In Start Free Trial

Book Overview & Buying
Table Of Contents
Feedback & Rating

Learn Microsoft Office 2019

By : Linda Foulkes

3.8 (12)

Learn Microsoft Office 2019

3.8 (12)

By: Linda Foulkes

Overview of this book

Learn Microsoft Office 2019 provides a comprehensive introduction to the latest versions of Microsoft Word, Excel, PowerPoint, Access, and Outlook. With the help of illustrated explanations, this Microsoft Office book will take you through the updated Office 2019 applications and guide you through implementing them using practical examples. You'll start by exploring the Word 2019 interface and creating professional Word documents using elements such as citations and cover pages, tracking changes, and performing mail merge. You'll then learn how to create impressive PowerPoint presentations and advance to performing calculations and setting up workbooks in Excel 2019, along with discovering its data analysis features. Later chapters will focus on Access 2019, assisting you in everything from organizing a database to constructing advanced queries. You'll then get up to speed with Outlook, covering how to create and manage tasks, as well as how to handle your mail and contacts effortlessly. Finally, you'll find solutions to commonly encountered issues and best practices for streamlining various workplace tasks. By the end of this book, you'll have learned the essentials of Office business apps and be ready to work with them to boost your productivity.

Preface

Preface

Who this book is for

What this book covers

To get the most out of this book

Get in touch

Section 1: Word

Section 1: Word

Free Chapter

Exploring the Interface and Formatting Elements

Exploring the Interface and Formatting Elements

Technical requirements

An overview of the interface features

Creating documents

Setting the printing options

Formatting text, styles, and paragraphs

Summary

Creating Lists and Constructing Advanced Tables

Creating Lists and Constructing Advanced Tables

Technical requirements

Creating bulleted and numbered lists

Working with tabbed lists

Creating tables

Editing and formatting tables

Customizing advanced tables

Summary

Creating Professional Documents

Creating Professional Documents

Technical requirements

Word-referencing features

Performing a mail merge

Constructing forms

Customizing page layouts

Summary

Versions, Restrictions, and Comparisons

Versions, Restrictions, and Comparisons

Technical requirements

Recovering draft versions

Restricting access to documents and workbooks

Comparing and combining documents

Summary

Section 2: PowerPoint

Section 2: PowerPoint

The PowerPoint Interface and Presentation Options

The PowerPoint Interface and Presentation Options

Technical requirements

Introduction and new features

Saving presentations in different formats

Setting print options and layouts

Using view and zoom options

Summary

Formatting Slides, Tables, Charts, and Graphic Elements

Formatting Slides, Tables, Charts, and Graphic Elements

Technical requirements

Setting up slides and applying layouts

Working with themes and text manipulation

Working with text boxes

Arranging and manipulating objects

Constructing and modifying tables

Inserting and modifying charts

Inserting audio and video

Summary

Photo Albums, Sections, and Show Tools

Photo Albums, Sections, and Show Tools

Technical requirements

Creating and modifying photo albums

Working with presentation sections

Applying animations and transitions

Using hyperlinks, actions, and comments

Exploring slide show options and custom shows

Using master slides and hiding slides

Summary

Section 3: Excel

Section 3: Excel

Formatting, Manipulating, and Presenting Data Visually

Formatting, Manipulating, and Presenting Data Visually

Technical requirements

Introducing the interface and setting options

Constructing and formatting an Excel worksheet

Working with worksheets and sheet tabs

Sorting and filtering data

Setting print options

Creating charts based on worksheet data

Summary

Applying Formulas and Functions

Applying Formulas and Functions

Technical requirements

Learning basic formula operations

Constructing a formula

Using the Function Library

Applying named ranges in a formula

Summary

Analyzing and Organizing Data

Analyzing and Organizing Data

Technical requirements

Consolidating data and investigating macros

Creating and managing PivotTables and PivotCharts

Working with the 3D Maps feature

Using tools for analysis in Excel

Understanding data models

Summary

Section 4: Common Tasks

Section 4: Common Tasks

Exporting and Optimizing Files and the Browser View

Exporting and Optimizing Files and the Browser View

Technical requirements

Exporting files by changing the file type

Optimizing and compressing media in PowerPoint

Investigating the browser view options (Excel only)

Summary

Sharing and Protecting Files

Sharing and Protecting Files

Technical requirements

Sharing and collaborating in Office 2019

Presenting online

Protecting files in Office 2019

Summary

Section 5: Access

Section 5: Access

Database Organization and Setting Relationships

Database Organization and Setting Relationships

Technical requirements

Introduction to Access and the settings options

Constructing tables and manipulating data

Building relationships

Defining the primary key, join type, and referential integrity

Summary

Building Forms and Report Design

Building Forms and Report Design

Technical requirements

Building forms

Form customization and layout

The report design, controls, and output

Summary

Constructing Queries to Analyze Data

Constructing Queries to Analyze Data

Technical requirements

Constructing basic queries

Manipulating query fields and the Total row

Constructing advanced queries

Summary

Section 6: Outlook

Section 6: Outlook

Creating and Attaching Item Content

Creating and Attaching Item Content

Technical requirements

Investigating the Outlook environment

Manipulating item tags

Working with views, filtering, and printing

Creating and sending email messages

Creating and managing Quick Steps

Attaching item content

Summary

Managing Mail and Contacts

Managing Mail and Contacts

Technical requirements

Cleaning up the mailbox and managing rules

Managing junk mail and automatic message content

Creating contact information and groups

Summary

Calendar Objects, Tasks, Notes, and Journal Entries

Calendar Objects, Tasks, Notes, and Journal Entries

Technical requirements

Working with the calendar, appointments, and events

Modifying meeting requests and manipulating the calendar pane

Creating and managing tasks

Creating and manipulating notes and journal entries

Setting out-of-office options

Summary

Other Books You May Enjoy

Other Books You May Enjoy

Leave a review - let other readers know what you think

Customer Reviews

3.8 (12)

5 star

50%

4 star

16.7%

3 star

8.3%

2 star

16.7%

1 star

8.3%

Using tools for analysis in Excel

You should be confident with accessing the Analysis ToolPak in Excel 2019, specifically for the quick analysis of financial, statistical, and engineering data. We will use the ToolPak to obtain the descriptive statistics of a range of weather data in a workbook and look at how to use the what-if analysis tools such as Goal Seek and Scenario Manager.

The tools in the Analysis ToolPak in Excel 2019 are used to gain more statistical scrutiny from your worksheet data. If you are not used to creating complex formulas in Excel, but you need to perform statistical t-tests or chi-square tests and/or correlations, then the Analysis ToolPak has the answers without having to waste valuable time trying to recreate these formulas.

Analysis ToolPak

...

Visually different images

CONTINUE READING

83

Tech Concepts

36

Programming languages

73

Tech Tools

Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.

Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.

50+ new titles added per month and exclusive early access to books as they are being written.

Learn Microsoft Office 2019

Search

Your notes and bookmarks