Microsoft Excel 2019 Inside Out

by Jelen, Bill

• ISBN13: 9781509307692
• ISBN10: 1509307699
• Edition: 1st
• Format: Paperback
• Copyright: 2018-11-20
• Publisher: Microsoft Press

Summary

You’re beyond the basics—so dive in and really put your spreadsheet skills to work! This supremely organized reference is packed with hundreds of timesaving solutions, troubleshooting tips, and workarounds. It’s all muscle and no fluff. Learn how the experts tackle Excel—and challenge yourself to new levels of mastery. Includes companion eBook and sample files.

Topics include:

• Customizing the Excel workspace
• Best practices for designing and managing worksheets
• Creating formulas and functions
• Performing statistical, what-if, and other data analysis
• Core to advanced charting techniques
• Using graphics and sparklines
• Managing databases and tables
• Automating Excel with macros and custom functions
• Collaborating in Excel online, in the cloud, and more
• Extending Excel

Author Biography

Bill Jelen, Excel MVP and the host of MrExcel.com, has been using spreadsheets since 1985, and he launched the MrExcel.com website in 1998. He loves performing his live Power Excel seminars around the United States. He has produced more than 2,200 episodes of his daily video podcast, Learn Excel from MrExcel. He is the author of 57 books about Microsoft Excel and writes the monthly Excel column for Strategic Finance magazine. Before founding MrExcel.com, Bill Jelen spent 12 years in the trenches, working as a financial analyst for finance, marketing, accounting, and operations departments of a $500 million public company. He lives in Merritt Island, Florida, with his wife, Mary Ellen.

Table of Contents

Previous Edition Table of Contents

Introduction

Examining the Excel environment

• Chapter 1: What's new in Microsoft Excel 2013
• Chapter 2: Exploring Excel fundamentals
• Chapter 3: Custom-tailoring the Excel workspace
• Chapter 4: Security and privacy

Building worksheets

• Chapter 5: Planning your worksheet design
• Chapter 6: How to work a worksheet
• Chapter 7: How to work a workbook

Formatting and editing worksheets

• Chapter 8: Worksheet editing techniques
• Chapter 9: Worksheet formatting techniques

Adding graphics and printing

• Chapter 10: Creating and formatting graphics
• Chapter 11: Printing and presenting

Creating formulas and performing data analysis

• Chapter 12: Building formulas
• Chapter 13: Using functions
• Chapter 14: Everyday functions
• Chapter 15: Formatting and calculating date and time
• Chapter 16: Functions for financial analysis
• Chapter 17: Functions for analyzing statistics
• Chapter 18: Performing a what-if analysis

Creating charts

• Chapter 19: Designing charts
• Chapter 20: Formatting charts
• Chapter 21: Using sparklines

Managing databases and tables

• Chapter 22: Managing information in tables
• Chapter 23: Analyzing data with PivotTable reports
• Chapter 24: An introduction to PowerPivot
• Chapter 25: Working with external data

Using Excel collaboratively

• Chapter 26: Collaborating on a network or by email
• Chapter 27: Working in the cloud

Automating Excel

• Chapter 28: Recording macros
• Chapter 29: Creating custom functions
• Chapter 30: Debugging macros and custom functions

Integrating and extending Excel

• Chapter 31: Linking, hyperlinking, and embedding
• Chapter 32: Using Excel data in Word documents

Appendixes

• Menu-to-ribbon command reference
• Keyboard shortcuts
• Function reference

Index to troubleshooting topics

About the authors