Microsoft Excel 2019 Inside Out

Nonfiction, Computers, Application Software, Spreadsheets, Financial Applications
Cover of the book Microsoft Excel 2019 Inside Out by Bill Jelen, Pearson Education
View on Amazon View on AbeBooks View on Kobo View on B.Depository View on eBay View on Walmart
Author: Bill Jelen ISBN: 9781509306053
Publisher: Pearson Education Publication: October 11, 2018
Imprint: Microsoft Press Language: English
Author: Bill Jelen
ISBN: 9781509306053
Publisher: Pearson Education
Publication: October 11, 2018
Imprint: Microsoft Press
Language: English

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
View on Amazon View on AbeBooks View on Kobo View on B.Depository View on eBay View on Walmart

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.

More books from Pearson Education

Cover of the book Level 3: Martin Luther King by Bill Jelen
Cover of the book Make Change Happen by Bill Jelen
Cover of the book Windows 8.1 Administration Pocket Consultant Storage, Security, & Networking by Bill Jelen
Cover of the book How to Get People to Do Stuff by Bill Jelen
Cover of the book Business Express: Managing upwards successfully by Bill Jelen
Cover of the book Fluent Visual Basic by Bill Jelen
Cover of the book Meet the iPad and iOS 5 by Bill Jelen
Cover of the book Law Express Question and Answer: English Legal System by Bill Jelen
Cover of the book Developing Sustainable Business Models (Chapter 11 from Disrupt Together) by Bill Jelen
Cover of the book Eclipse Plug-ins by Bill Jelen
Cover of the book The Genius of Instinct: Reclaim Mother Nature's Tools for Enhancing Your Health, Happiness, Family, and Work by Bill Jelen
Cover of the book Microsoft SQL Server 2008 Analysis Services Unleashed by Bill Jelen
Cover of the book Apple Training Series by Bill Jelen
Cover of the book Accessing the WAN, CCNA Exploration Companion Guide by Bill Jelen
Cover of the book Word 2016 In Depth (includes Content Update Program) by Bill Jelen
We use our own "cookies" and third party cookies to improve services and to see statistical information. By using this website, you agree to our Privacy Policy