Overview

Conquer Microsoft Excel—from the inside out! Dive Into Microsoft Excel for Office 2021 and Microsoft 365 and really put your spreadsheet expertise to work. This supremely well-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 and its latest innovations, from advanced analysis and visualizations to dashboards. Discover how experts tackle today's key tasks—and challenge yourself to new levels of mastery.   Save time with galleries, keyboard accelerators, and other shortcuts. Enter formulas more efficiently, and fully control operators and dates. Use new data types to return photos, arrays, or weather history— and even create your own. Master Excel's most widely-used functions. Integrate external data from the web and other sources. Use the new XLOOKUP function to retrieve data more efficiently, with fewer errors. Store powerful specialized logic in LAMBDA functions—and avoid their limitations. Easily transform complex datasets with Power Query. Quickly summarize millions of records with pivot tables. Perform ad hoc analyses and create advanced data mashups. Use Analyze Data's artificial intelligence to get answers and auto-generate pivot tables. 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. Make the most of Excel's newest maps and charts. Add visual power with icons, 3D models, and animated 3D maps.

Full Product Details

Author:   Bill Jelen ,  Paul McFedries
Publisher:   Pearson Education (US)
Imprint:   Addison Wesley
Dimensions:   Width: 18.60cm , Height: 5.20cm , Length: 23.20cm
Weight:   1.540kg
ISBN:  

9780137559534

ISBN 10:   0137559534
Pages:   848
Publication Date:   13 January 2022
Audience:   Professional and scholarly ,  Professional & Vocational
Format:   Paperback
Publisher's Status:   Active
Availability:   Available To Order  
We have confirmation that this item is in stock with the supplier. It will be ordered in for you and dispatched immediately.

Table of Contents

Part I   The Excel interface Chapter 1        What's new in Microsoft 365 Excel Chapter 2        Using the Excel interface Chapter 3        Customizing Excel Chapter 4        Keyboard shortcuts   Part II  Calculating with Excel Chapter 5        Understanding formulas Chapter 6        Controlling formulas Chapter 7        Understanding functions Chapter 8        Using everyday functions: math, date and time, and text functions Chapter 9        Using powerful functions: logical, lookup, and database functions Chapter 10      Using names, LET, LAMBDA, and Data Types in Excel Chapter 11      Connecting worksheets and workbooks Chapter 12      Dynamic array formulas and names in Excel Part III Data analysis with Excel Chapter 13      Transforming data with Power Query Chapter 14      Summarizing data using subtotals or filter Chapter 15      Using pivot tables to analyze data Chapter 16      Using slicers and filtering a pivot table Chapter 17      Mashing up data with Power Pivot Chapter 18      Using What-If, Scenario Manager, Goal Seek, and Solver Chapter 19      Automating repetitive functions using VBA macros Chapter 20      More tips and tricks for Excel   Part IV Excel visuals Chapter 21      Formatting worksheets Chapter 22      Using data visualizations and conditional formatting Chapter 23      Graphing data using Excel charts Chapter 24      Using 3D Maps Chapter 25      Using sparklines Chapter 26      Formatting spreadsheets for presentation Chapter 27      Printing Chapter 28      Collaborating in Excel   Part V  Appendixes Appendix A     Excel functions Appendix B      Excel functions with DAX or Power Query equivalents Appendix C      Adding functionality to Excel with add-ins Index

Reviews

Author Information

Tab Content 6

Author Website:  

Countries Available

All regions