Essential Excel 2019: A Step-By-Step Guide

Excel 2019 is a powerful software that can help you create, edit, sort, analyze, summarize, and format data, as well as graph it. This in-depth guide provides essential how-to and reference information for users who are new to Excel, those who want to continue building their Excel skills, or anyone who wants to get up to speed on the latest changes and features in Excel 2019. It is heavy on practical examples and light on theory, providing a step-by-step process of what you need to do when working with Excel. You will begin with the basics, advancing as each chapter builds on knowledge from previous chapters. You will appreciate real-life examples and exercises that reinforce what you have learned, and upon finishing the book, you will have the confidence to use much more than the typical 10% that most people use in Excel.

Format: Paperback / softback
Length: 914 pages
Publication date: 22 October 2020
Publisher: APress

Essential Excel 2019 is a comprehensive guide that provides clear and concise information for users to successfully use the expansive features of Excel in their work environment. The second edition of this book delivers essential how-to and reference information for users who are new to Excel, those who want to continue building their Excel skills, or anyone who wants to get up to speed on the latest changes and features in Excel 2019. The book is heavy on practical examples and light on theory, providing a step-by-step process of what you need to do when working with Excel. You will begin with the basics, advancing as each chapter builds on knowledge from previous chapters. You will appreciate real-life examples and exercises that reinforce what you have learned, and upon finishing the book, you will have the confidence to use much more than the typical 10% that most people use in Excel.

What You Will Learn:

Create amazing visualizations of your data: Excel 2019 provides powerful tools for creating charts, graphs, and other visualizations that can help you understand your data better. You will learn how to create charts, graphs, and other visualizations, and how to customize them to meet your specific needs.

Get up to speed on easy and accurate methods for entering data: Excel 2019 offers a variety of methods for entering data, including keyboard shortcuts, mouse clicks, and drag-and-drop. You will learn how to enter data quickly and accurately, and how to avoid common errors.

Extract the information you want from imported data: Excel 2019 allows you to import data from a variety of sources, including Excel files, CSV files, and text files. You will learn how to extract the information you want from imported data, and how to manipulate and format it to meet your needs.

Export your results to other programs or share with others in the cloud: Excel 2019 allows you to export your results to other programs, such as Word, PowerPoint, and PDF, or to share them with others in the cloud. You will learn how to export your results, and how to choose the appropriate format for your needs.

Organize, summarize, filter, and consolidate your data in multiple ways: Excel 2019 provides a variety of tools for organizing, summarizing, filtering, and consolidating your data. You will learn how to organize your data, summarize your data, filter your data, and consolidate your data.

Audit, validate, and protect your data: Excel 2019 provides a variety of tools for auditing, validating, and protecting your data. You will learn how to audit your data, validate your data, and protect your data.

Who This Book Is For:

Anyone new to Excel or looking to take better advantage of the advanced features of the pl.

Weight: 1750g
Dimension: 178 x 254 x 49 (mm)
ISBN-13: 9781484262085
Edition number: 2nd ed.