Catalog

Record Details

Catalog Search


Back To Results
Showing Item 3 of 27

Microsoft Excel 2019 inside out  Cover Image Book Book

Microsoft Excel 2019 inside out

Jelen, Bill, (author.).

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]

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.
Subject: Microsoft Excel (Computer file)
Microsoft Excel (Computer file)
Electronic spreadsheets > Computer programs.
Electronic spreadsheets > Computer programs.
Genre: Handbooks and manuals.
Handbooks and manuals.

Available copies

  • 1 of 1 copy available at State Library of Alabama.

Holds

  • 0 current holds with 1 total copy.
Show Only Available Copies
Location Call Number / Copy Notes Barcode Shelving Location Status Due Date
APLS 005.54 JEL 31291002935730 STACKS Available -

Back To Results
Showing Item 3 of 27

Additional Resources