"Data Analysis in Microsoft Excel" by Maxwell Angelou is a comprehensive guide that aims to equip readers with the necessary skills to perform data analysis using Microsoft Excel. Angelou's book is tailored for both beginners and intermediate users, providing a structured approach to mastering data analysis techniques within the versatile Excel environment.
"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 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.
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 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.
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.