Exploring Data with Excel 2019

by Larry Rockoff

Overview

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.

Product Details

ISBN-13:	9780578789569
Publisher:	Larry Rockoff
Publication date:	12/01/2020
Sold by:	Barnes & Noble
Format:	eBook
Pages:	368
File size:	16 MB
Note:	This product may take a few minutes to download.

About the Author

Larry Rockoff has been involved with reporting and business intelligence development for many years. His main area of interest is in using reporting tools to explore and analyze data in complex databases. He holds an MBA from the University of Chicago, with a specialization in Management Science. Besides writing about Excel, he has also published books on Access and SQL. A second edition of his bestselling book, "The Language of SQL," is available worldwide and has been translated into three languages.

Table of Contents

1. An Overview of Excel

2. The Excel User Interface

3. Getting External Data

4. Tables

5. Pivot Table Basics

6. Pivot Table Calculations

7. Charts and Pivot Charts

8. Data Commands

9. Formulas

10. Text Functions

11. Numeric and Date Functions

12. Aggregate and Statistical Functions

13. Logical and Lookup Functions

14. Analysis Tools