Exploring Data with Excel 2019
Description
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.
More details
Person
Content
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
