--- product_id: 553049488 title: "Data Analysis in Microsoft Excel: Deliver Awesome Analytics in 3 Easy Steps Using VLOOKUPS, Pivot Tables, Charts And More" price: "HK$277" currency: HKD in_stock: true reviews_count: 13 url: https://www.desertcart.hk/products/553049488-data-analysis-in-microsoft-excel-deliver-awesome-analytics-in-3 store_origin: HK region: Hong Kong --- # Data Analysis in Microsoft Excel: Deliver Awesome Analytics in 3 Easy Steps Using VLOOKUPS, Pivot Tables, Charts And More **Price:** HK$277 **Availability:** ✅ In Stock ## Quick Answers - **What is this?** Data Analysis in Microsoft Excel: Deliver Awesome Analytics in 3 Easy Steps Using VLOOKUPS, Pivot Tables, Charts And More - **How much does it cost?** HK$277 with free shipping - **Is it available?** Yes, in stock and ready to ship - **Where can I buy it?** [www.desertcart.hk](https://www.desertcart.hk/products/553049488-data-analysis-in-microsoft-excel-deliver-awesome-analytics-in-3) ## Best For - Customers looking for quality international products ## Why This Product - Free international shipping included - Worldwide delivery with tracking - 15-day hassle-free returns ## Description Data Analysis in Microsoft Excel: Deliver Awesome Analytics in 3 Easy Steps Using VLOOKUPS, Pivot Tables, Charts And More [Holloway, Alex] on desertcart.com. *FREE* shipping on qualifying offers. Data Analysis in Microsoft Excel: Deliver Awesome Analytics in 3 Easy Steps Using VLOOKUPS, Pivot Tables, Charts And More Review: Excellent resource for anyone new to the field! - The book is organized in three sections: a broad introduction to Excel and the field of data analysis, a guide to learning Excel and using it with a dataset, and a bit of guidance on what the reader can do moving forward. In the first part, the author presents the three-step data analysis system: Prepare, Analyze, and Consider - this is catchy, concise, and sure to resonate with readers! Also discussed is the issue of data quality, and the author wisely mentions that the data analyst should practice transparency in their analytical approach. There is also a great tip on knowing one's audience before delivering any analysis results - I can confirm this is smart advice. The second part of the book begins with a really nice step-by-step exploration of the Excel user interface - this ensures readers totally new to Excel will be able to follow along. Next is a guide for extracting data from a given source; this is written in such a way to still be suitable to Excel beginners. The remainder of this middle section is dedicated to following that three-step system noted above, using the dataset that had just been harvested. The Prepare section maintains that aforementioned focus on knowing one's audience and, on a related note, presents the importance of establishing the actual problem to be solved with the analysis. There are great exercises here on feature engineering and other data preparation/cleaning steps. The Analyze section includes an important mention of maintained focus on the intended audience and problem at hand as well as the fact that the analytics process is not linear - it is iterative and the analyst will indeed need to return to previous steps throughout the process. There are good exercises in the ubiquitous SUM, COUNT, and conditional aggregation functions and a great introduction to PivotTables - PivotTables in particular can be daunting for people new to Excel, but the step-by-step instructions given here are helpful. The Consider section contains some important mentions that are often overlooked by new data analysts. There are discussions of the context of the problem - looking at the "bigger picture" - and the distinction between information and insight garnered from data. There is also a mention of the thing that often happens when a data analyst thinks a project is finish: a manager asks a new question, so the analyst must go back and revisit the analysis. The final section of the book contains a good collection of openly available resources that help can get the reader up and running on their own. There is also mention of further Excel functionality beyond the scope of the book, as well as a good overview of other data analytics tools/skills to explore. As a seasoned Excel user and data analyst, I think this serves as an excellent resource for those newer to the field. One of my favorite quotes from the book is at the end of Chapter 4: "Research and learning are ongoing components of being an effective data analyst." That rings true, and this book will be a great part of the analyst's ongoing learning. Excellent work! Review: Valuable information for a Data Analyst in today's world - As a business analyst in the corporate world today, there were many great reminders to pull you back to the basics. I would give this book to any entry level data analysts. You have to learn to shoot free throws before you learn the 360 dunk. This is a perfect entryway. 4/5 Stars my only gripe would be that some of the functions addressed in the book are a bit dated as of 2024, this is minor and only a minor complaint overall I loved the book! ## Technical Specifications | Specification | Value | |---------------|-------| | ASIN | B0CCCPKTTX | | Best Sellers Rank | #71,909 in Books ( See Top 100 in Books ) #10 in Microsoft Excel Guides #18 in Data Processing #23 in Spreadsheet Books | | Customer Reviews | 4.4 4.4 out of 5 stars (159) | | Dimensions | 6 x 0.51 x 9 inches | | ISBN-13 | 979-8852388452 | | Item Weight | 12 ounces | | Language | English | | Part of series | Data Analysis In Microsoft Excel | | Print length | 224 pages | | Publication date | July 21, 2023 | | Publisher | Independently published | ## Images ![Data Analysis in Microsoft Excel: Deliver Awesome Analytics in 3 Easy Steps Using VLOOKUPS, Pivot Tables, Charts And More - Image 1](https://m.media-amazon.com/images/I/61EgJvJTCyL.jpg) ## Customer Reviews ### ⭐⭐⭐⭐⭐ Excellent resource for anyone new to the field! *by B***N on July 22, 2023* The book is organized in three sections: a broad introduction to Excel and the field of data analysis, a guide to learning Excel and using it with a dataset, and a bit of guidance on what the reader can do moving forward. In the first part, the author presents the three-step data analysis system: Prepare, Analyze, and Consider - this is catchy, concise, and sure to resonate with readers! Also discussed is the issue of data quality, and the author wisely mentions that the data analyst should practice transparency in their analytical approach. There is also a great tip on knowing one's audience before delivering any analysis results - I can confirm this is smart advice. The second part of the book begins with a really nice step-by-step exploration of the Excel user interface - this ensures readers totally new to Excel will be able to follow along. Next is a guide for extracting data from a given source; this is written in such a way to still be suitable to Excel beginners. The remainder of this middle section is dedicated to following that three-step system noted above, using the dataset that had just been harvested. The Prepare section maintains that aforementioned focus on knowing one's audience and, on a related note, presents the importance of establishing the actual problem to be solved with the analysis. There are great exercises here on feature engineering and other data preparation/cleaning steps. The Analyze section includes an important mention of maintained focus on the intended audience and problem at hand as well as the fact that the analytics process is not linear - it is iterative and the analyst will indeed need to return to previous steps throughout the process. There are good exercises in the ubiquitous SUM, COUNT, and conditional aggregation functions and a great introduction to PivotTables - PivotTables in particular can be daunting for people new to Excel, but the step-by-step instructions given here are helpful. The Consider section contains some important mentions that are often overlooked by new data analysts. There are discussions of the context of the problem - looking at the "bigger picture" - and the distinction between information and insight garnered from data. There is also a mention of the thing that often happens when a data analyst thinks a project is finish: a manager asks a new question, so the analyst must go back and revisit the analysis. The final section of the book contains a good collection of openly available resources that help can get the reader up and running on their own. There is also mention of further Excel functionality beyond the scope of the book, as well as a good overview of other data analytics tools/skills to explore. As a seasoned Excel user and data analyst, I think this serves as an excellent resource for those newer to the field. One of my favorite quotes from the book is at the end of Chapter 4: "Research and learning are ongoing components of being an effective data analyst." That rings true, and this book will be a great part of the analyst's ongoing learning. Excellent work! ### ⭐⭐⭐⭐ Valuable information for a Data Analyst in today's world *by J***H on April 23, 2024* As a business analyst in the corporate world today, there were many great reminders to pull you back to the basics. I would give this book to any entry level data analysts. You have to learn to shoot free throws before you learn the 360 dunk. This is a perfect entryway. 4/5 Stars my only gripe would be that some of the functions addressed in the book are a bit dated as of 2024, this is minor and only a minor complaint overall I loved the book! ### ⭐⭐⭐⭐⭐ Hands-on Excel Training for Data Analysts (or those who want to raise their Excel skills) *by N***S on September 5, 2025* I will start out by saying that I am not a data analyst per se, but in the field of marketing where I work, we all need to become better at analyzing data. As Excel is the default for doing this, I read this book to understand what I might be missing out on and what new Excel skills I should acquire to improve my own work. As this book is written for data analysts, it does provide a 3-step framework for working with data, but even as a non-analyst I found this framework a great way to get more out of the data I want to analyze. What I really enjoyed about this book is that the author handholds you through exercises using public data and provides hand-on training using Excel features you might have never used or even known about! Needless to say if you are looking to improve your Excel game and need to analyze data as a big reason for using Excel, this is a very recommended read! ## Frequently Bought Together - Data Analysis in Microsoft Excel: Deliver Awesome Analytics in 3 Easy Steps Using VLOOKUPS, Pivot Tables, Charts And More - Fundamentals of Data Analytics: Learn Essential Skills, Embrace the Future, and Catapult Your Career in the Data-Driven World—A Comprehensive Guide to Data Literacy for Beginners (Fundamentals Series) - Excel Formulas QuickStudy Laminated Study Guide (QuickStudy Computer) --- ## Why Shop on Desertcart? - 🛒 **Trusted by 1.3+ Million Shoppers** — Serving international shoppers since 2016 - 🌍 **Shop Globally** — Access 737+ million products across 21 categories - 💰 **No Hidden Fees** — All customs, duties, and taxes included in the price - 🔄 **15-Day Free Returns** — Hassle-free returns (30 days for PRO members) - 🔒 **Secure Payments** — Trusted payment options with buyer protection - ⭐ **TrustPilot Rated 4.5/5** — Based on 8,000+ happy customer reviews **Shop now:** [https://www.desertcart.hk/products/553049488-data-analysis-in-microsoft-excel-deliver-awesome-analytics-in-3](https://www.desertcart.hk/products/553049488-data-analysis-in-microsoft-excel-deliver-awesome-analytics-in-3) --- *Product available on Desertcart Hong Kong* *Store origin: HK* *Last updated: 2026-05-17*