Exploring Data with Excel 2019
Author: Larry Rockoff
Published in December 2020, paperback and eBook, 350 pages.
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.
1. An Overview of Excel
2. The Excel User Interface
3. Getting External Data
5. Pivot Table Basics
6. Pivot Table Calculations
7. Charts and Pivot Charts
8. Data Commands
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:
These sites in the US offer digital editions:
Print editions can be purchased from these online bookstores outside of the US:
These sites outside of the US offer digital editions: