Excel: The Comprehensive Guide for Beginners and Power Users to Master Formulas, Charts, Pivot Tables, and More with Step-by-Step Examples (Rheinwerk Computing)

If you’re using Excel, this is the all-in-one manual you need—brimming with solutions for every conceivable task! Learn how to design tables, use formulas to perform calculations, create analyses, graphically present your data, and share your results. With detailed coverage of both basic functions and advanced features, this book provides guidance for beginners and serves as a reliable reference if you’re already familiar with Excel. Up to date for Excel 2024 and Microsoft 365!

• Your A-to-Z guide to Microsoft Excel
• Master basic features, data analysis, visualizations, and more
• Work with formulas, table functions, and VBA

Excel Fundamentals
Follow a workflow that guides you through Excel’s user interface, introduces basic concepts, and demonstrates the core features for working with tables, diagrams, and files.

All Your Excel Tasks
Dive into everything Excel has to offer. Master spreadsheet functions, formula usage, and table design. Get step-by-step instructions for analyzing, visualizing, and publishing your data; then see how to automate and customize your tasks with macros and VBA.

Practical Examples
See Excel’s features in action. Detailed examples and annotated screenshots guide you through each and every spreadsheet function, table design and analysis, data model management, and more.

Helmut Vonhoegen is a freelance author and IT consultant. He has published more than 80 books since 1992 and written numerous articles in specialist journals. His focus is Microsoft Office, Windows, web programming, and XML.