- English
- ePUB (mobile friendly)
- Available on iOS & Android
eBook - ePub
Exploring Data with Excel 2019
About this book
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.
Frequently asked questions
Yes, you can cancel anytime from the Subscription tab in your account settings on the Perlego website. Your subscription will stay active until the end of your current billing period. Learn how to cancel your subscription.
At the moment all of our mobile-responsive ePub books are available to download via the app. Most of our PDFs are also available to download and we're working on making the final remaining ones downloadable now. Learn more here.
Perlego offers two plans: Essential and Complete
- Essential is ideal for learners and professionals who enjoy exploring a wide range of subjects. Access the Essential Library with 800,000+ trusted titles and best-sellers across business, personal growth, and the humanities. Includes unlimited reading time and Standard Read Aloud voice.
- Complete: Perfect for advanced learners and researchers needing full, unrestricted access. Unlock 1.4M+ books across hundreds of subjects, including academic and specialized titles. The Complete Plan also includes advanced features like Premium Read Aloud and Research Assistant.
We are an online textbook subscription service, where you can get access to an entire online library for less than the price of a single book per month. With over 1 million books across 1000+ topics, we’ve got you covered! Learn more here.
Look out for the read-aloud symbol on your next book to see if you can listen to it. The read-aloud tool reads text aloud for you, highlighting the text as it is being read. You can pause it, speed it up and slow it down. Learn more here.
Yes! You can use the Perlego app on both iOS or Android devices to read anytime, anywhere — even offline. Perfect for commutes or when you’re on the go.
Please note we cannot support devices running on iOS 13 and Android 7 or earlier. Learn more about using the app.
Please note we cannot support devices running on iOS 13 and Android 7 or earlier. Learn more about using the app.
Yes, you can access Exploring Data with Excel 2019 by Larry Rockoff in PDF and/or ePUB format, as well as other popular books in Computer Science & Desktop Applications. We have over one million books available in our catalogue for you to explore.
Information
Exploring Data
with Excel 2019
Larry Rockoff
Exploring Data with Excel 2019
Deep Dive Press
Copyright © 2020 by Larry Rockoff
All rights reserved. No part of this work may be reproduced, stored in a retrieval system or transmitted by any means without written permission from the publisher.
ISBN: 978-0-578-78956-9
Microsoft, Excel, and Access are either registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries. All other trademarks are the property of their respective owners.
Editor: Nicole Roth
Contents at a Glance
Introduction
1 An Overiew 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 Data Functions
12 Aggregate and Statistical Functions
13 Analysis Tools
Index
Table of Contents
Introduction
Topics and Features
Plan of the Book
1 An Overview of Excel
Excel Components
Cells
Tables
Pivot Tables
Charts and Pivot Charts
External Data
Add-Ins
Data Analysis
Looking Ahead
2 The Excel User Interface
Worksheets and Cells
The Ribbon
Home Commands
View Commands
Page Layout Commands
Review Commands
The Backstage View
Looking Ahead
3 Getting External Data
Data from Text Files
Data from Microsoft Access
Data from SQL Server
Power Query
Looking Ahead
4 Tables
Table Basics
Table Tools
Sorting
Filters
Looking Ahead
5 Pivot Table Basics
The Field List
Field Arrangement and Layout
Expanding and Collapsing Fields
Showing Details
Filters
Slicers
Sorting
Looking Ahead
6 Pivot Table Calculations
Subtotals and Totals
Grouping
Calculated Items and Fields
Percentages and Ranks
Summarization
Looking Ahead
7 Charts and Pivot Charts
Pivot Chart Basics
Layout Options
Column and Bar Charts
Pie Charts
Line and Radar Charts
Standard Charts
Sparklines
Looking Ahead
8 Data Commands
Sorting and Filtering
Subtotals and Grouping
Text to Columns and Flash Fill
Data Validation
Looking Ahead
9 Formulas
Formula Basics
Relative and Absolute Cell References
The Name Manager
Formula Auditing
Functions
Nested Functions
Looking Ahead
10 Text Functions
Case Conversion
Joining Text
Text Substrings
Finding and Replacing Text
Splitting Text
Converting to and from Text
Looking Ahead
11 Numeric and Date Functions
Arithmetic
Rounding
Unit Conversion
Financial Analysis
Dates and Time
Looking Ahead
12 Aggregate and Statistical Functions
Sums
Counts
Averages
Percentiles and Ranks
Frequencies and Variability
Correlation and Regression
Array Functions and the Sum of Products
Looking Ahead
13 Logical and Lookup Functions
Logical Functions
IS Functions
Lookup Functions
Looking Ahead
14 Analysis Tools
Data Analysis
Data Tables
Scenario Manager
Goal Seek
Solver
Final Thoughts
Index
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.
He also maintains a website that features book reviews on technology topics, focusing on analytics and business intelligence as well as broader social issues at:
- larryrockoff.com
Please feel free to visit that site to contact the author with any comments or questions.
For more information on this and other publications of Deep Dive Press, please visit:
- deepdivepress.com
You are also encouraged to connect with or follow the author on LinkedIn at:
- linkedin.com/in/larryrockoff
Introduction
Used by millions around the world, Microsoft Excel has become synonymous with the word spreadsheet and both defines and dominates that software category. One would be hardpressed to find any business or data analyst who doesn’t use or interact with Excel in some manner. One reason for Excel’s popularity is that it is a very easy tool with which to get started. Its intuitive user interface simply requires the user to enter some data in some cells and perhaps add a few formulas. The results are immediate and understandable.
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...