Learn Microsoft Office 2019

A comprehensive guide to getting started with Word, PowerPoint, Excel, Access, and Outlook

Linda Foulkes 지음

Packt(GCO Science) 2020년 05월 29일 출간

작품소개

책소개

▶Book Description
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.

▶What You Will Learn
- Use PowerPoint 2019 effectively to create engaging presentations
- Gain working knowledge of Excel formulas and functions
- Collaborate using Word 2019 tools, and create and format tables and professional documents
- Organize emails, calendars, meetings, contacts, and tasks with Outlook 2019
- Store information for reference, reporting, and analysis using Access 2019
- Discover new functionalities such as Translator, Read Aloud, Scalable Vector Graphics (SVG), and data analysis tools that are useful for working professionals

▶Key Features
- Explore MS Office to enhance productivity and boost your professional development
- Get up and running with the new and improved features in Microsoft Office 2019
- Discover how to overcome common challenges when working with Office 2019 applications

▶Who This Book Is For
Whether you're just getting started or have used Microsoft Office before and are looking to develop your MS Office skills further, this book will help you to make the most of the different Office applications. Familiarity with the Office 2019 suite will be useful, but not mandatory.

목차

▶TABLE of CONTENTS
▷ Section 1: Word
1. Exploring the Interface and Formatting Elements
2. Creating Lists and Constructing Advanced Tables
3. Creating Professional Documents
4. Versions, Restrictions, and Comparisons
▷ Section 2: PowerPoint
5. The PowerPoint Interface and Presentation Options
6. Formatting Slides, Tables, Charts, and Graphic Elements
7. Photo Albums, Sections, and Show Tools
▷ Section 3: Excel
8. Formatting, Manipulating, and Presenting Data Visually
9. Applying Formulas and Functions
10. Analyzing and Organizing Data
▷ Section 4: Common Tasks
11. Exporting and Optimizing Files and the Browser View
12. Sharing and Protecting Files
▷ Section 5: Access
13. Database Organization and Setting Relationships
14. Building Forms and Report Design
15. Constructing Queries to Analyze Data
▷ Section 6: Outlook
16. Creating and Attaching Item Content
17. Managing Mail and Contacts
18. Calendar Objects, Tasks, Notes, and Journal Entries

책 속으로

▶What this book covers
- Chapter 1, Exploring the Interface and Formatting Elements, will make it easy for you to create, manipulate, and work with documents using Microsoft Office 2019. You'll learn about the interface layout, ribbon elements, and how to customize the default behavior. We will delve into controlling font attributes, creating a style to speed up the file formatting process, changing the spacing of paragraphs, and looking at text alignment options. You will learn how to create and print professional-looking documents.

- Chapter 2, Creating Lists and Constructing Advanced Tables, will teach you how to create bulleted, numbered, and tabbed lists using predefined or custom symbols and how to alter the layout of lists. You will be able to easily integrate tables in documents and to modify them in different ways. We will also cover some advanced features of table creation such as sorting operations, managing a table that spans multiple pages of a document, using formulas in a table, and converting text to a table.

- Chapter 3, Creating Professional Documents, explains that Word 2019 includes an array of features that aid in creating attractive and professional documents. This chapter will teach you how to add references such as citations, a table of contents, and a bibliography, and perform a mail merge using different methods. We will construct a form using the Quick Parts feature, insert a cover page, and get to grips with navigation techniques and working with long documents. There is also a section on troubleshooting endnotes and footnotes, headers and footers, and links in a document.

- Chapter 4, Versions, Restrictions, and Comparisons, explains all about setting editing restrictions and passwords on all or part of a document to prevent unwanted changes. After learning how to collaborate, we will compare and combine document revisions.

- Chapter 5, The PowerPoint Interface and Presentation Options, teaches you how to personalize the Backstage view and set various options. You will navigate the interface and perform basic tasks, including creating, saving, printing, and viewing presentations in PowerPoint 2019.

- Chapter 6, Formatting Slides, Tables, Charts, and Graphic Elements, explains how to easily add slides to a PowerPoint presentation and use predefined options to give the slides a particular look and feel. In this chapter, you'll learn how to set up a basic presentation, order a sequence of slides, apply a presentation theme and slide layout, and reuse slides. You will also learn how to work with tables and charts, which make data much easier to present and add to the impact of a presentation.

- Chapter 7, Photo Albums, Sections, and Show Tools, covers how to set up a photo album, add photos and captions, and customize the order and appearance. You will also get to know how to navigate a presentation easily using sections and rename and remove sections in presentations. You'll learn how to set up and manage slide shows, control slide timing, and master the playback of audio narration. We also cover master slides, check the consistency throughout a presentation, and look at options for hiding or showing specific slides.

- Chapter 8, Formatting, Manipulating, and Presenting Data Visually, shows how to personalize the Backstage view and set various spreadsheet options, and distinguish between spreadsheet elements. You will be taken on a journey through formatting elements to manipulate data, and will also learn how to print elements and set print options. You will learn how to enhance Excel 2019 with decorative, professionallooking charts such as the sunburst and funnel charts. You will gain all the skills you need to format, print, and present data professionally.

...

출판사 서평

▶ Preface
Learn Microsoft Office 2019 is a step-by-step comprehensive journey through the Office 2019 applications, which includes visual and detailed explanations of concepts and the opportunity to practice throughout using workplace examples. It contains full coverage of the latest version of the Microsoft Word, Excel, PowerPoint, Access, and Outlook suite of programs.

Before we turn our attention to the chapter details, let's consider the organization of the book. This book is a comprehensive guide containing six main parts, allowing the user to learn about the tools common to all Office applications. The parts include common tasks across all Microsoft Office 2019 applications, Word, PowerPoint, Excel, Access, and Outlook. You will definitely want to work through all parts of this book as it will provide you with a way to work more productively and learn everything you need to be proficient in the worlds of work, study, and home.

작가정보

저자(글) Linda Foulkes

Linda Foulkes is an L&D trainer at Knights plc. She is also a Microsoft Office Master Trainer, Microsoft Certified Educator, and Microsoft Innovative Expert Educator and Trainer with over 25 years of experience. In 2015, Linda represented South Africa at the Microsoft Global Forum in Redmond. She has certified and coached students who competed at the Microsoft Office Specialist Championships in Texas. She has published five training manuals and courseware for the Microsoft Office Specialist Certification and the ICDL Foundation SA. She has presented at conferences and webinars for SchoolNet SA, hosted TeachMeets and MicrosoftMeets, and developed e-learning paths for the Microsoft Office suite of programs, owing to her interest in e-learning.