Explore Products

Best Sellers

New Releases

Books

Videos

Audiobooks

Learning Hub

Free Learning

You're reading from Learn Microsoft Office 2019 A comprehensive guide to getting started with Word, PowerPoint, Excel, Access, and Outlook

Product type Paperback

Published in May 2020

Publisher Packt

ISBN-13 9781839217258

Length 794 pages

Edition 1st Edition

Tools

Excel

Concepts

Document Preparation

Author (1):

Linda Foulkes

View More author details

Table of Contents (26) Chapters

Preface

1. Section 1: Word

2. Exploring the Interface and Formatting Elements FREE CHAPTER

3. Creating Lists and Constructing Advanced Tables

4. Creating Professional Documents

5. Versions, Restrictions, and Comparisons

6. Section 2: PowerPoint

7. The PowerPoint Interface and Presentation Options

8. Formatting Slides, Tables, Charts, and Graphic Elements

9. Photo Albums, Sections, and Show Tools

10. Section 3: Excel

11. Formatting, Manipulating, and Presenting Data Visually

12. Applying Formulas and Functions

13. Analyzing and Organizing Data

14. Section 4: Common Tasks

15. Exporting and Optimizing Files and the Browser View

16. Sharing and Protecting Files

17. Section 5: Access

18. Database Organization and Setting Relationships

19. Building Forms and Report Design

20. Constructing Queries to Analyze Data

21. Section 6: Outlook

22. Creating and Attaching Item Content

23. Managing Mail and Contacts

24. Calendar Objects, Tasks, Notes, and Journal Entries

25. Other Books You May Enjoy

Leave a review - let other readers know what you think

Section 3: Excel

Excel 2019 is a very powerful application with most audiences only using a small fraction of its capability. In this part of the book, you will learn how to navigate around the interface, creating, formatting, and manipulating data. The heart of Excel 2019 is the ability to calculate and analyze data, which you will master through this part of the book. You will be introduced to new and improved functions, namely CONCAT, IFS, MAXIFS, MINIFS, SWITCH, and TEXTJOIN; and learn how to visualize and analyze data and create data models.

In this section, we will cover the following chapters:

Chapter 8, Formatting, Manipulating, and Presenting Data Visually
Chapter 9, Applying Formulas and Functions
Chapter 10, Analyzing and Organizing Data

The rest of the chapter is locked

A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.

Unlock this book and the full library FREE for 7 days

Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of

Start free trial

Renews at $19.99/month. Cancel anytime

Authors (1)

Foulkes

Linda Foulkes is a Senior Learning & Development Trainer at Knights. She is also a Microsoft Office Master Trainer, Certified Educator, and Microsoft Innovative Expert Educator with an educational and corporate background spanning 25 years. Linda is the author of our previous edition book, Learn Microsoft Office 2019. As well as being certified as an IT trainer, Linda represented South Africa at the Microsoft Global Forum in Redmond in 2015. She has certified students to compete at the Microsoft Office Specialist Championships in Texas, presented at conferences, and hosted Webinars, TeachMeets & MicrosoftMeets. She has a keen interest in e-learning and has developed e-learning paths and content for the Microsoft Office suite of programs.

See other products by Foulkes