Amazon cover image
Image from Amazon.com

Microsoft Excel 2019 inside out / Bill Jelen.

By: Material type: TextTextPublisher: [New York] : Pearson Education, Inc., [2019] ©2019Description: xxxi, 829 pages : illustrations ; 24 cmContent type:
  • 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.
Star ratings
    Average rating: 0.0 (0 votes)
Holdings
Item type Current library Collection Call number Status Date due Barcode
Books Books GSU Library Epoch General Stacks NFIC 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.
Share