Название: Exploring Data with Excel 2019
Автор: Larry Rockoff
Издательство: Deep Dive Press
Год: 2020
Страниц: 491
Язык: английский
Формат: pdf, epub
Размер: 15.8 MB

The purpose of this book is to help the beginning Excel user move beyond the basics and become more comfortable with some of Excel’s more complex features. The focus is on using Excel as a data analysis tool. The full realm of Excel features is considered. Besides the commonly used tactic of entering numbers and formulas in cells, special emphasis is given to the use of Excel tables, charts, pivot tables, and pivot charts. This book also emphasizes procedures that allow you to interact with external data, whether that is with text files or an entire corporate database.

Exploring Data with Excel 2019 is an introduction to Microsoft Excel with an emphasis on topics relevant to data exploration and analysis. The goal is to help the analyst gain a true understanding of data and the information it contains. All aspects of Excel are covered, including formulas and functions, as well as a discussion of advanced analysis tools. This book is written in an easy-to-understand tutorial style, with new topics introduced in a logical and intuitive sequence. Numerous screenshots are included, so you won't need to sit with a computer as you read the book.

Special emphasis is given to using pivot tables and charts to summarize and visualize data. This lets you explore your data in a highly interactive manner.

In short, this is the only book you'll need to gain a working knowledge of Excel and how it can be used for data exploration and analysis.