|
Search Result for:
ISBN / EAN :
Title :
Author :
Publisher : HOLY MACRO! BOOKS
From Date :
To Date :
Keyword :
Number of Titles Found: 9
|
|
| Title: Ctrl+Shift+Enter Mastering Excel Array Formulas |
| Sub-title: Do the Impossible with Excel Formulas Thanks to Array Formula Magic |
| By (author): Mike ExcelisFun Girvin |
| ISBN10-13: 1615470077 : 9781615470075 |
| Designed with Excel gurus in mind, this handbook outlines how to create formulas that can be used to solve everyday problems with a series of data values that standard Excel formulas cannot or would be too arduous to attempt. Beginning with an introduction to array formulas, this manual examines topics such as how they differ from ordinary formulas, the benefits and drawbacks of their use, functions that can and cannot handle array calculations, and array constants and functions. Among the practical applications surveyed include how to extract data from tables and unique lists, how to get results that match any criteria, and how to utilize various methods for unique counts. This book contains 529 screen shots. |
|
Pages: 308
Size: 234.95x209.55mm
Illustrations: 529 screen shots
|
| Published: Holy Macro! Books - July 2013 |
| Format: Paperback |
| Subjects: Spreadsheet software : Graphical & digital media applications |
| List Price: 26.99 Pounds Sterling |
| Availability: In Stock
Qty Available: 4 |
| Title: 1 of: 9 |
|
|
|
| Title: Financial Modelling in Power BI |
| Sub-title: Forecasting Business Intelligently |
| By (author): Jonathan Liau, Liam Bastick |
| ISBN10-13: 1615470727 : 9781615470723 |
| Just like a shovel, this book is genuinely ground-breaking. It hits you over the head with the proverbial gardening tool, implementing the way forward for financial modelling. Many working in banking and finance create their financial models in Excel and then import them into Power BI for graphical interpretation and further analysis. Not on our watch. Weâ re going to jettison the universal spreadsheet and build the entire model in Power BI. We canâ t stress how far off the range weâ re taking the horses. If you are reading this, you are a true pioneer. Some have managed to build the odd financial statement in Power BI, but all three? This is where you can gain a major advantage in the workplace. If you build the calculations for financial statements in Power BI, you can produce statements by product, by customer, by geography... Get the picture? The limitation will be restricted to the granularity of the underlying data and your imagination. This book unearths some of the tricks, measures, logic and tools needed to build the model (there is no need to bury your mistakes). We just canâ t promise you a rose garden... With the usual jokes in spades, itâ s just a shame we couldnâ t get Doug (get it?) to assist. |
|
Pages: 338
Size: 254x165.1mm
|
| Published: Holy Macro! Books - September 2022 |
| Format: Paperback |
| Subjects: Management accounting & bookkeeping |
| List Price: 53.99 Pounds Sterling |
| Availability: In Stock
Qty Available: 13 |
| Title: 2 of: 9 |
|
|
|
| Title: Master Your Data with Power Query in Excel and Power BI |
| Sub-title: Leveraging Power Query to Get & Transform Your Task Flow |
| By (author): Miguel Escobar, Ken Puls |
| ISBN10-13: 1615470581 : 9781615470587 |
| Master your data and transform your workflow with Power Query! This book provides a comprehensive guide to data cleansing using Power Query in both Excel and Power BI. Learn to leverage Power Query to automate repetitive tasks, extract data from various sources, and transform it into a usable format. Discover techniques for handling data types, errors, and query optimization, and unlock the power of M language. Perfect for Excel and Power BI users looking to streamline their data analysis processes. |
|
Pages: 369
Size: 273.05x209.55mm
|
| Published: Holy Macro! Books - November 2021 |
| Format: Paperback |
| Subjects: Business & management : Computing & information technology : Excel : Graphical & digital media applications |
| List Price: 28.95 Pounds Sterling |
| Availability: In Stock
Qty Available: 6 |
| Title: 3 of: 9 |
|
|
|
| Title: Microsoft 365 Excel: The Only App That Matters |
| Sub-title: Calculations, Analytics, Modeling, Data Analysis and Dashboard Reporting for the New Era of Dynamic Data Driven Decision Making & Insight |
| By (author): Mike ExcelisFun Girvin |
| ISBN10-13: 1615470700 : 9781615470709 |
Master Microsoft 365 Excel for data-driven decision making and business success.Unlock the full potential of Microsoft 365 Excel with this comprehensive guide. Learn to create powerful formula solutions, build robust business models, and perform in-depth data analysis with ease. Discover the secrets of Power Query, Power Pivot, and Power BI to transform data into actionable insights.- Master worksheet formulas, M Code, and DAX.
- Create dynamic PivotTables and insightful Power BI visualizations.
- Perform data analysis on small and big data from various sources.
This is for anyone who wants to harness the power of Excel for calculations, analytics, modeling, and dashboard reporting. Start at the beginning and progress to an advanced level, solving calculation-based problems and answering crucial questions. Empower yourself to build efficient solutions and make data-driven decisions in the new era of dynamic data. |
|
Pages: 806
Size: 273.05x209.55mm
|
| Published: Holy Macro! Books - August 2022 |
| Format: Paperback |
| Subjects: Excel : Graphical & digital media applications : Database design & theory |
| List Price: 44.99 Pounds Sterling |
| Availability: In Stock
Qty Available: 1 |
| Title: 4 of: 9 |
|
|
|
| Title: MrExcel 2024 |
| Sub-title: Igniting Excel |
| By (author): Bill Jelen |
| ISBN10-13: 1615470794 : 9781615470792 |
Excel tips to skyrocket white-collar productivity.
Originally designed for Bill Jelen's live Power Excel seminars, the target audience already uses Excel 40 hours a week. These tips are the "aha" tips that uncover secret methods in Excel. The book covers general Excel functions, pivot tables, and formulas such as VLOOKUP and the new XLOOKUP. It introduces elements of modern Excel such as the Power Pivot Data Model and cleaning data with Power Query. Updated annually, this edition for 2021 adds information on LET and LAMBDA functions, amazing new data types, dynamic array formulas, and more. |
|
Pages: 332
|
| Published: Holy Macro! Books - May 2024 |
| Format: Paperback |
| Subjects: Excel : Graphical & digital media applications : Database design & theory |
| List Price: 27.99 Pounds Sterling |
| Availability: In Stock
Qty Available: 8 |
| Title: 5 of: 9 |
|
|
|
| Title: Power BI for the Excel Analyst |
| Sub-title: Your Essential Guide to Power BI |
| By (author): Wyn Hopkins |
| ISBN10-13: 161547076X : 9781615470761 |
Unlock the power of Power BI for Excel analysts!Transform data into rich, interactive visual reports with this essential guide. Designed for Excel analysts, this resource touches on Power Query and Power Pivot, providing practical guidance to improve business decision-making.- Master data modeling techniques
- Learn DAX formulas for calculations
- Discover Power Query steps for data transformation
- Design effective reports with visualization options
Transition seamlessly from Excel to Power BI and leverage its capabilities for robust and refreshable reports. Start building your business intelligence ecosystem today! |
| Table of Contents: |
| Introduction to the Power BI environment Build your first report in just a few minutes Preparing Dashboard Data Diving in to Power Query and understanding M code Creating Interactive Visualizations Using custom visualizations Using PowerBI.com to add value to your reports |
|
Pages: 192
Size: 254x203.2mm
|
| Published: Holy Macro! Books - November 2022 |
| Format: Paperback |
| Subjects: Graphical & digital media applications |
| List Price: 35.99 Pounds Sterling |
| Availability: In Stock
Qty Available: 12 |
| Title: 6 of: 9 |
|
|
|
| Title: Power Pivot and Power BI |
| Sub-title: The Excel User's Guide to DAX, Power Query, Power BI & Power Pivot in Excel 2010-2016 |
| By (author): Rob Collie, Avichal Singh |
| ISBN10-13: 1615470751 : 9781615470754 |
| Microsoft PowerPivot is a free add-on to Excel from Microsoft that allows users to produce new kinds of reports and analyses that were simply impossible before, and this book is the first to tackle DAX formulas, the core capability of PowerPivot, from the perspective of the Excel audience. Written by the world's foremost PowerPivot blogger and practitioner, the book's concepts and approach are introduced in a step-by-step manner tailored to the learning style of Excel users everywhere. The techniques presented allow users to produce, in hours or even minutes, results that formerly would have taken entire teams weeks or months to produce. The "pattern-like" techniques and best practices contained in this book have been developed and refined over two years of onsite training with Excel users around the world, and the key lessons from those seminars costing thousands of dollars per day are now available within the pages of this easy-to-follow guide. This updated edition covers new features introduced with Office 2015. |
|
Pages: 308
Size: 266.7x209.55mm
|
| Published: Holy Macro! Books - December 2021 |
| Format: Paperback |
| Subjects: Database design & theory |
| List Price: 24.99 Pounds Sterling |
| Availability: In Stock
Qty Available: 22 |
| Title: 7 of: 9 |
|
|
|
| Title: Supercharge Power BI |
| Sub-title: Power BI is Better When You Learn To Write DAX |
| By (author): Matt Allington |
| ISBN10-13: 1615470697 : 9781615470693 |
Data analysis expressions (DAX) is the formula language of Power BI. Learning the DAX language is key to empower Power BI users so they can take advantage of these new Business Intelligence (BI) capabilities. This third edition has been updated for the new Power BI Ribbon interface while still providing a bridge for readers wanting to learn DAX in the Power BI, Power Pivot, or Excel. |
|
Pages: 280
Size: 273.05x209.55mm
|
| Published: Holy Macro! Books - April 2021 |
| Format: Paperback |
| Subjects: Database design & theory |
| List Price: 27.99 Pounds Sterling |
| Availability: In Stock
Qty Available: 9 |
| Title: 8 of: 9 |
|
|
|
| Title: The Absolute Guide to Dashboarding and Reporting with Power BI |
| Sub-title: How to Design and Create a Financial Dashboard with Power BI – End to End |
| By (author): Kasper de Jonge |
| ISBN10-13: 1615470573 : 9781615470570 |
Written by a member of Microsoftâ s Power BI team, this resource provides a practical step by step guide on creating a financial dashboard. The book covers in detail how to combine and shape the relevant data, build the dashboard in Power BI, providing layout and design tips and tricks, prepare the model to work with fiscal dates, and show values used in many financial reports, including year-to-date, variance-to-target, percentage-of-total, and running totals reports. |
|
Pages: 156
Size: 273.05x209.55mm
|
| Published: Holy Macro! Books - March 2019 |
| Format: Paperback |
| Subjects: Data warehousing |
| List Price: 26.99 Pounds Sterling |
| Availability: In Stock
Qty Available: 4 |
| Title: 9 of: 9 |
|
|
|
|
|
Item added to 
.png "Click here for catalogues")
