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.
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.
"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.
"Excel: The Easiest Way to Master Microsoft Excel in 7 Days" authored by Leonard Webb is a comprehensive guide aimed at individuals seeking to quickly and efficiently acquire proficiency in Microsoft Excel. Webb's book is structured as a step-by-step program designed to guide readers through the essentials of Excel within a week, making it accessible to beginners and those looking to refresh their skills alike.
"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 Data Filters: Quickly and Easily Sort and Filter Data" by Scott Hartshorn is a practical guide designed to help users efficiently sort and filter data using Microsoft Excel. Hartshorn’s book aims to make these fundamental yet powerful features accessible to both novice and experienced Excel users, enabling them to manage large data sets with ease and precision.