Microsoft Excel 2019 Inside Out,9781509307692

Microsoft Excel 2019 Inside Out

by
Edition: 1st
ISBN13: 9781509307692
ISBN10: 1509307699
Format: Paperback
Pub. Date: 2018-11-20
Publisher(s): Microsoft Press
List Price: $52.49

Buy New

Usually Ships in 2-3 Business Days
$49.99
Add to Cart

Buy Used

Usually Ships in 24-48 Hours
$37.49
Add to Cart

Rent Book

Select for Price
Add to Cart
There was a problem. Please try again later.

eBook

We're Sorry
Not Available

Buy from our Marketplace starting at $6.70

How Marketplace Works:

  • This item is offered by an independent seller and not shipped from our warehouse
  • Item details like edition and cover design may differ from our description; see seller's comments before ordering.
  • Sellers much confirm and ship within two business days; otherwise, the order will be cancelled and refunded.
  • Marketplace purchases cannot be returned to eCampus.com. Contact the seller directly for inquiries; if no response within two days, contact customer service.
  • Additional shipping costs apply to Marketplace purchases. Review shipping costs at checkout.

Summary

Conquer Microsoft Excel 2019–from the inside out!

Dive into Microsoft Excel 2019–and really put your spreadsheet expertise to work. This supremely organized reference packs hundreds of timesaving solutions, tips, and workarounds–all you need to make the most of Excel’s most powerful tools for analyzing data and making better decisions. Renowned Excel expert Bill Jelen offers a complete tour of Excel 2019 and Excel in Office 365, from efficient interface customizations to advanced analysis, visualizations, and dashboards. Discover how experts tackle today’s key tasks–and challenge yourself to new levels of mastery.

  • Enter formulas more efficiently, and fully control operators and dates
  • Master the most widely-used functions in Excel
  • Integrate external data from the web and other sources
  • Easily transform complex datasets with Power Query
  • Quickly summarize millions of records with Pivot Tables
  • Perform ad hoc analyses with slicers and other filters
  • Create advanced data mashups with Power Pivot
  • Solve complex problems with What-If, Scenario Manager, Goal Seek, and Solver
  • Automate repetitive tasks by editing recorded VBA code
  • Demystify data with conditional formatting and other visualization techniques
  • Use the newest maps, charts, and data types in Excel
  • Show geographical changes over time with animated 3D maps
  • Use dynamic array functions: SORT, FILTER, UNIQUE, SORTBY and SEQUENCE
  • Find insights using Excel’s new artificial intelligence
  • Collaborate via Excel 2019’s breakthrough CoAuthoring tools
  • Publish Power BI Desktop dashboards based on Excel data

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

An electronic version of this book is available through VitalSource.

This book is viewable on PC, Mac, iPhone, iPad, iPod Touch, and most smartphones.

By purchasing, you will be able to view this book online, as well as download it, for the chosen number of days.

Digital License

You are licensing a digital product for a set duration. Durations are set forth in the product description, with "Lifetime" typically meaning five (5) years of online access and permanent download to a supported device. All licenses are non-transferable.

More details can be found here.

A downloadable version of this book is available through the eCampus Reader or compatible Adobe readers.

Applications are available on iOS, Android, PC, Mac, and Windows Mobile platforms.

Please view the compatibility matrix prior to purchase.