Microsoft Excel 2019 inside out

Summary:

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. -- Provided by publisher.

Record details

ISBN: 9781509307692
ISBN: 1509307699
Physical Description: xxxi, 829 pages : illustrations ; 24 cm
Publisher: [New York, New York] : Published with the authorization of Microsoft Corporation by Pearson Education, Inc., [2019]
Copyright: ©2019

Content descriptions

General Note:

"Microsoft Press"--Back cover.

Includes index.

Formatted Contents Note:

What's new in Excel 2019 -- Using the Excel interface -- Customizing Excel -- Keyboard shortcuts -- Understanding formulas -- Controlling formulas -- Understanding functions -- Using everyday functions : math, date and time, and text functions -- Using powerful functions : logical, lookup, and database functions -- Other functions -- Connecting worksheets and workbooks -- Array formulas and names in Excel -- Transforming data -- Summarizing data using subtotals or filter -- Using pivot tables to analyze data -- Using slicers and filtering a pivot table -- Mashing up data with power pivot -- Using what-if, scenario manager, goal seek, and solver -- Automating repetitive functions using VBA macros -- More tips and tricks for Excel 2019 -- Formatting worksheets -- Using data visualizations and conditional formatting -- Graphing data using Excel charts -- Using 3D maps -- Using sparklines -- Formatting spreadsheets for presentations -- Printing -- Sharing dashboards with power BI.