Book Image

Learn Microsoft Office 2019

By : Linda Foulkes
Book Image

Learn Microsoft Office 2019

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.

Related Content you might be interested in

Current Title:

Small book image
Learn Microsoft Office 2019
Linda Foulkes
May, 2020 | 794 pages
Small book image
Exploring Microsoft Excel’s Hidden Treasures
David Ringstrom
Sep, 2022 | 444 pages
Small book image
Microsoft 365 Word Tips and Tricks
Heather Ackmann | Bill Kulterman
Nov, 2021 | 472 pages
Small book image
Working Smarter with Microsoft Outlook
Staci Warne
Aug, 2022 | 428 pages
Table of Contents (26 chapters)
Preface
Preface
Who this book is for
What this book covers
To get the most out of this book
Get in touch
1
Section 1: Word
Section 1: Word
Free Chapter
2
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
3
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
4
Creating Professional Documents
Creating Professional Documents
Technical requirements
Word-referencing features
Performing a mail merge
Constructing forms
Customizing page layouts
Summary
5
Versions, Restrictions, and Comparisons
Versions, Restrictions, and Comparisons
Technical requirements
Recovering draft versions
Restricting access to documents and workbooks
Comparing and combining documents
Summary
6
Section 2: PowerPoint
Section 2: PowerPoint
7
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
8
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
9
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
10
Section 3: Excel
Section 3: Excel
11
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
12
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
13
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
14
Section 4: Common Tasks
Section 4: Common Tasks
15
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
16
Sharing and Protecting Files
Sharing and Protecting Files
Technical requirements
Sharing and collaborating in Office 2019
Presenting online
Protecting files in Office 2019
Summary
17
Section 5: Access
Section 5: Access
18
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
19
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
20
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
21
Section 6: Outlook
Section 6: Outlook
22
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
23
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
24
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
25
Other Books You May Enjoy
Other Books You May Enjoy
Leave a review - let other readers know what you think

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

...
Previous Section
End of Section 6
Next Section