Microsoft Excel Inside Out (Office 2021 and Microsoft 365) by Bill Jelen

Microsoft Excel Inside Out (Office 2021 and Microsoft 365) by Bill Jelen

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.

Bill Jelen, Excel MVP and the host of MrExcel.com, has been using spreadsheets since 1985, and he launched the MrExcel.com website in 1998. Bill was a regular guest on Call for Help with Leo Laporte and has produced more than 2,200 episodes of his daily video podcast, Learn Excel from MrExcel. He is the author of 57 books about Microsoft Excel and writes the monthly Excel column for Strategic Finance magazine. Before founding MrExcel.com, Bill spent 12 years in the trenches, working as a financial analyst for the finance, marketing, accounting, and operations departments of a $500 million public company. He lives in Merritt Island, Florida, with his wife, Mary Ellen.

Mike Alexander is a Microsoft Certified Application Developer (MCAD) and author of several books on advanced business analysis with Microsoft Access and Excel. He has more than 15 years of experience consulting and developing Office solutions. Mike has been named a Microsoft MVP for his ongoing contributions to the Excel community.

SKU	Unavailable
ISBN 13	9780137559534
ISBN 10	0137559534
Title	Microsoft Excel Inside Out (Office 2021 and Microsoft 365)
Author	Bill Jelen
Series	Inside Out
Condition	Unavailable
Binding Type	Paperback
Publisher	Pearson Education (US)
Year published	2022-01-06
Number of pages	848
Cover note	Book picture is for illustrative purposes only, actual binding, cover or edition may vary.