Skip to content
ISBN: 1509307699
ISBN13: 9781509307692

Microsoft Excel 2019 Inside Out

$6.29List Price: $49.99
Save $43.70!
ISBN: 1509307699
ISBN13: 9781509307692
Formats

Conditions

A read copy that remains in clean condition.

Formats

Conditions

A read copy that remains in clean condition.

See all 1 editionsfrom $6.29

Book Overview

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

Format:
Paperback
Language:
English
ISBN:
1509307699
ISBN13:
9781509307692
Release Date:
November 2018
Publisher:
Pearson Education
Length:
864 Pages
Weight:
3.00 lbs.
Dimensions:
9.1″ × 2.0″ × 7.4″
ComputersComputers & Technology

More by Bill Jelen

Customer Reviews

0 customer ratings | 0 reviews
Write a Review

There are currently no reviews. Be the first to review this work.