Microsoft Excel Inside Out (Office 2021 and Microsoft 365)

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.