Microsoft Excel 2019 inside out / Bill Jelen.

By:

Jelen, Bill [author.]

Material type: Text

text
still image

Media type:

unmediated

Carrier type:

volume

ISBN:

9781509307692
1509307699

Other title:

Microsoft Excel 2019

Subject(s):

Genre/Form:

DDC classification:

005.54 23

LOC classification:

HF5548.4.M523 JEL

Contents:

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

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

Item type:

Books

Tags from this library: No tags from this library for this title. Log in to add tags.

Average rating: 0.0 (0 votes)

Holdings
Item type	Current library	Collection	Call number	Status	Date due	Barcode
Books	GSU Library Epoch General Stacks	Non-fiction	HF5548.4.M523JEL (Browse shelf(Opens below))	Available		50000005846

Includes index.

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

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

There are no comments on this title.

to post a comment.