Xelplus – Leila Gharani Xelplus – Leila Gharani

Guerrilla Data Analysis Using Microsoft Excel (eBook)

Upgrade your Excel knowledge with this guide.
Perfect for any skill level. Dive into hands-on analysis with real-world cases and tools.

Guerilla Data Analysis in Excel eBook

Transform Your Data Analysis Skills with Expert Guidance!

Whether you’re a beginner or a seasoned pro, this guide, crafted by top Excel MVPs Oz du Soleil and Bill Jelen, equips you with practical skills to navigate and master Excel’s complexities.

Why Choose This eBook?

  • From Basics to Advanced: Begin with the basics and progress to mastering advanced features like Pivot Tables and Power Query.
  • Practical Learning: Tackle real-world data scenarios across various industries, from non-profits to retail.
  • Latest Excel Features: Discover the newest Excel functionalities like XLOOKUP and dynamic arrays, with a practical, hands-on approach.
  • Actionable Insights: Apply Excel practically to make informed decisions in your work.

In its third edition, this Excel Data Analysis eBook isn’t just a guide, it’s your mentor in mastering data organization and analysis. Ideal for budget managers, data analysts, or beginners, it’s your key to transforming data into clear, actionable insights.

📚 Grab Your Copy Today! Transform your approach to data and make confident, informed decisions!

Practice Files Included

After purchasing, you’ll get instant access to the ‘Guerrilla Data Analysis Using Microsoft Excel’ eBook, spanning 277 pages packed with advanced data analysis techniques, practical advice, real-world examples, and cautionary tales.

You can download the eBook in 2 formats:

📑 PDF version

📑 ePUB version

You’ll also get the Excel and data analysis files used throughout this book. That way, you can follow along as you read.

The easiest way to explore this book, is to use the same data file, and check your progress against the many images provided.

Meet the Experts

Oz du Soleil, Microsoft MVP

Join Oz du Soleil, a passionate Excel MVP known for his captivating Excel courses and engaging YouTube tutorials on “Excel on Fire.”

Oz brings a wealth of experience and a unique, energetic teaching style. He’s also shared his insights globally, speaking at conferences from Amsterdam to Brazil.

Oz du Soleil

Bill ‘Mr. Excel’ Jelen, Microsoft MVP

Partnering with Oz is Bill Jelen, aka ‘Mr. Excel,’ an authoritative figure in the Excel community.

Bill, the author of 61 Excel books and host of MrExcel.com, brings his extensive knowledge and practical insights to the book. He’s a frequent media guest and an acclaimed column writer, making complex Excel concepts accessible to a wide audience.

Bill Jelen

Chapter Summary

Starting with the essentials, Chapters 1 to 3 of this Excel data analysis eBook introduce Excel’s core functions, formulas, and collaboration tools. The focus is on practical applications like creating dynamic spreadsheets and managing Excel Tables.

Chapters 4 to 6 explore data summarization with criteria-based functions and Pivot Tables, equipping readers to quickly organize and analyze data.

In Chapters 7 to 9, the Excel data analysis eBook dives into Power Query for data cleaning and transformation, along with strategies for data deduplication, emphasizing data’s real-world messiness.

Chapters 10 to 12 are about dynamic arrays and data validation techniques, ensuring inputs are clean and processes are efficient.

Chapters 13 to 16 discuss safeguarding your work, starting with sheet and cell protection strategies. Additionally, these chapters explore the use of advanced functions like INDIRECT and OFFSET, which are crucial for complex data manipulation. This section effectively guides you through enhancing data security and mastering sophisticated data handling techniques.

Data types, graphing, and potential pitfalls in data analysis are examined in Chapters 17 to 20, with the newer Excel features like XLOOKUP and the LET function highlighted in Chapters 21 and 22.

The final chapters, 23 to 28, offer advanced insights into managing data models, improving data integrity, and practical layout tips for effective data analysis.


Frequently Asked Questions

How can I view my eBook after purchase?

Immediately after payment you can download the eBook in any of 2 DRM-Free versions: PDF or ePUB. Please ensure that your devices are compatible with the eBook before you purchase. You will also get the Excel and Power BI files used in the book.

Are refunds available for the eBook?

All eBook sales are final, and as such non-refundable.

Does the eBook expire?

No, the eBook does not expire and you can download and transfer to multiple personal devices.