"Excel Pivot Tables Recipe Book: A Problem-Solution Approach" by Debra Dalgleish is a comprehensive guide designed to help users master the powerful features of Excel pivot tables through practical, real-world scenarios. The book is structured as a collection of "recipes," each addressing a specific problem or task that users might encounter when working with pivot tables. This approach makes it easy for readers to find and apply solutions to their own pivot table challenges.
"Data Analysis in Microsoft Excel: Deliver Awesome Analytics" authored by Alex Holloway is a comprehensive guide aimed at empowering users to perform effective data analysis using Microsoft Excel. Holloway's book is structured to cater to users of all skill levels, providing a systematic approach to mastering Excel's data analysis capabilities and delivering impactful insights.
Henry E. Mejia's "Excel Charts and Graphs Ninja" is a practical and comprehensive guide designed to help users master the art of creating effective charts and graphs in Excel. The book is aimed at both beginners and advanced users who want to enhance their data visualisation skills and make more informed decisions using visual data representations.
Paul McFedries' "Excel Pivot Tables and Pivot Charts: Your visual blueprint for creating dynamic spreadsheets" is a practical and visually oriented guide designed to help users harness the powerful features of Excel pivot tables and pivot charts. This book is part of the "Your visual blueprint" series, known for its step-by-step visual format that makes complex concepts accessible and easy to understand.
"Excel Formulas & Functions For Dummies" is a comprehensive guide designed to help readers unlock the full potential of Microsoft Excel's formula and function capabilities. Authored by Ken Bluttman and Peter G. Aitken, this book caters to users of all levels, from beginners to experienced Excel enthusiasts, providing clear explanations, practical examples, and useful tips for mastering Excel formulas and functions
"Excel 365 Charts" by M.L. Humphrey is a comprehensive guide tailored for users looking to master the art of chart creation and data visualisation using Excel 365. Humphrey's book is designed to cater to both beginners and advanced users, providing a detailed exploration of Excel's charting capabilities and how to leverage them to create compelling and informative visual representations of data.