You're reading from Excel 2019 Bible The complete guide to Excel 2019

Product type Paperback

Published in Dec 2018

Publisher Wiley

ISBN-13 9781119514787

Length 1120 pages

Edition 1st Edition

Languages

Power Query

Tools

Excel

Concepts

Database Programming

Authors (3):

John Walkenbach

Michael Alexander

Dick Kusleika

View More author details

Table of Contents (10) Chapters

1. Cover FREE CHAPTER

2. Introduction

Is This Book for You?
Software Versions
Conventions Used in This Book
How This Book Is Organized
How to Use This Book
What's on the Website

3. Part I: Getting Started with Excel

CHAPTER 1: Introducing Excel
CHAPTER 2: Entering and Editing Worksheet Data
CHAPTER 3: Performing Basic Worksheet Operations
CHAPTER 4: Working with Excel Ranges and Tables
CHAPTER 5: Formatting Worksheets
CHAPTER 6: Understanding Excel Files and Templates
CHAPTER 7: Printing Your Work
CHAPTER 8: Customizing the Excel User Interface

4. Part II: Working with Formulas and Functions

CHAPTER 9: Introducing Formulas and Functions
CHAPTER 10: Using Formulas for Common Mathematical Operations
CHAPTER 11: Using Formulas to Manipulate Text
CHAPTER 12: Using Formulas with Dates and Times
CHAPTER 13: Using Formulas for Conditional Analysis
CHAPTER 14: Using Formulas for Matching and Lookups
CHAPTER 15: Using Formulas for Financial Analysis
CHAPTER 16: Using Formulas for Statistical Analysis
CHAPTER 17: Using Formulas with Tables and Conditional Formatting
CHAPTER 18: Understanding and Using Array Formulas
CHAPTER 19: Making Your Formulas Error-Free

5. Part III: Creating Charts and Other Visualizations

CHAPTER 20: Getting Started with Excel Charts
CHAPTER 21: Using Advanced Charting Techniques
CHAPTER 22: Creating Sparkline Graphics
CHAPTER 23: Visualizing with Custom Number Formats and Shapes
CHAPTER 24: Implementing Excel Dashboarding Best Practices

6. Part IV: Managing and Analyzing Data

CHAPTER 25: Importing and Cleaning Data
CHAPTER 26: Using Data Validation
CHAPTER 27: Creating and Using Worksheet Outlines
CHAPTER 28: Linking and Consolidating Worksheets
CHAPTER 29: Introducing PivotTables
CHAPTER 30: Analyzing Data with PivotTables
CHAPTER 31: Performing Spreadsheet What-If Analysis
CHAPTER 32: Analyzing Data Using Goal Seeking and Solver
CHAPTER 33: Analyzing Data with the Analysis ToolPak
CHAPTER 34: Protecting Your Work

7. Part V: Understanding Power Pivot and Power Query

CHAPTER 35: Introducing Power Pivot
CHAPTER 36: Working Directly with the Internal Data Model
CHAPTER 37: Adding Formulas to Power Pivot
CHAPTER 38: Introducing Power Query
CHAPTER 39: Transforming Data with Power Query
CHAPTER 40: Making Queries Work Together
CHAPTER 41: Enhancing Power Query Productivity

8. Part VI: Automating Excel

CHAPTER 42: Introducing Visual Basic for Applications
CHAPTER 43: Creating Custom Worksheet Functions
CHAPTER 44: Creating UserForms
CHAPTER 45: Using UserForm Controls in a Worksheet
CHAPTER 46: Working with Excel Events
CHAPTER 47: Seeing Some VBA Examples
CHAPTER 48: Creating Custom Excel Add-Ins

9. Index

10. End User License Agreement

Part II
Working with Formulas and Functions

Formulas and worksheet functions are essential to manipulating data and obtaining useful information from your Excel workbooks. The chapters in this part present a wide variety of formula examples that use many Excel functions.

The rest of the chapter is locked

You're reading from Excel 2019 Bible The complete guide to Excel 2019

Table of Contents (10) Chapters

Unlock this book and the full library FREE for 7 days

Authors (3)

Personalised recommendations for you