Excel Books

Exploring Data with Excel 2019

Published by Deep Dive Press in December 2020, paperback and eBook, 350 pages.

Click here to purchase the book on Amazon in the US

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 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.

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

Purchasing the Book

Print editions can be purchased from these online bookstores in the US:

Amazon
Barnes and Noble

These sites in the US offer digital editions:

Amazon (Kindle)

Print editions can be purchased from these online bookstores outside of the US:

Amazon Canada
Amazon France
Amazon Germany
Amazon India
Amazon Spain
Amazon UK

These sites outside of the US offer digital editions:

Amazon Canada (Kindle)
Amazon France (Kindle)
Amazon Germany (Kindle)
Amazon India (Kindle)
Amazon Spain (Kindle)
Amazon UK (Kindle)