Wydawca: Holy Macro Books
MrExcel's Holy Macro! Books, Kasper de Jonge
This book empowers readers to build professional dashboards and reports using Power BI. Starting with the basics of dashboards and reports, it delves into preparing data for visualizations, crafting detailed reports, and designing cohesive dashboards. The book provides clear methods for sharing work efficiently within organizations, ensuring that readers understand how to convert raw data into actionable insights.Practical examples and techniques throughout the book equip professionals with the skills they need to enhance their business intelligence capabilities. Readers will discover how to structure data for clarity, develop key reporting techniques, and integrate advanced features to maximize Power BI's potential.Whether you're a beginner or looking to refine your skills, this book offers a step-by-step approach to mastering Power BI's core capabilities, ensuring a seamless transition from data to decision-making.
Train Your Own GPT. How to Train ChatGPT to Think Like You
MrExcel's Holy Macro! Books, Bill Jelen
This book offers a hands-on guide to building GPTs that learn, adapt, and respond in your unique style. It begins by breaking down how ChatGPT understands instructions, then guides readers through training personalized GPTs that automate tasks, create structured outputs, and integrate across business applications.Readers gain practical experience in linking GPTs with Excel, Power Automate, and APIs while exploring advanced memory, context, and action features. With clear guidance, examples, and exercises, the book bridges theory and application to make AI personalization achievable for any professional.By the end, readers can confidently design custom AI agents that extend beyond ChatGPT’s limits—capable of mirroring workflows, preferences, and communication style for real-world automation and creativity.
MrExcel's Holy Macro! Books, Mike Girvin
This book begins with the fundamentals, introducing key concepts like let expressions, keywords, and identifiers, before guiding you through more advanced techniques such as creating custom functions, handling diverse data types, and building reusable queries. Each chapter combines theoretical insights with practical examples, empowering you to handle complex data challenges with confidence.As you progress, you’ll learn how to master lookup formulas, manipulate data with unpivot, append, join, and group operations, and explore advanced table transformations. A dedicated section on data connectors provides in-depth knowledge of importing data from various sources and locales, ensuring flexibility and adaptability.The book concludes with practical data modeling projects that include handling inconsistent tables, appending multiple files, and building dynamic SharePoint connections. With a final focus on privacy levels and data security, this book equips you to use Power Query effectively and securely in real-world scenarios.
Your Excel Survival Kit. A Guide to Surviving and Thriving in an Excel World
MrExcel's Holy Macro! Books, Anne Walsh
This book starts off with the basics of data entry, formulas, and charts, it provides practical tips to simplify workflows and create clear visuals. Progress to advanced techniques like data cleaning, handling missing entries, and using logical functions, including modern dynamic arrays.Learn to summarize and visualize data with pivot tables, troubleshoot common issues, and customize layouts. Explore VLOOKUP, XLOOKUP, and methods for tackling common challenges. Advanced chapters introduce Power Query for data merging, automation, and quick insights, while Power Pivot enables combining multiple datasets for detailed reports.Finally, unlock Power BI to create professional-grade dashboards and visualizations. Designed for beginners and advanced users alike, this book equips you with the skills to streamline processes, analyze data effectively, and make informed decisions.