holy macro books uniontown (45 résultats)

Paperback. Etat : Very Good. The book has been read, but is in excellent condition. Pages are intact and not marred by notes or highlighting. The spine remains undamaged.

Paperback. Etat : Very Good. The book has been read, but is in excellent condition. Pages are intact and not marred by notes or highlighting. The spine remains undamaged.

Soft cover. Etat : Fine. No Jacket. This book covers real life marketing opportunities that can be managed with Excel. In the process of learning the solutions to the opportunities, you will become confident with the many capabilities of Excel and be able to use Excel to manage your marketing plan. Taking you from the basics to powerful features like charging and pivot tables, this is a must have for better marketing decisions! Proceeds from the sale of this book benefit environmental restoration and education.

Paperback. Etat : new. Paperback. 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. Shipping may be from multiple locations in the US or from the UK, depending on stock availability.

Paperback. Etat : new. Paperback. 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. Shipping may be from multiple locations in the US or from the UK, depending on stock availability.

Paperback. Etat : Very Good. The book has been read, but is in excellent condition. Pages are intact and not marred by notes or highlighting. The spine remains undamaged.

Paperback. Etat : Good. The book has been read but remains in clean condition. All pages are intact and the cover is intact. Some minor wear to the spine.

Paperback. Etat : new. Paperback. Power Query is the amazing new data cleansing tool in both Excel and Power BI Desktop. Do you find yourself performing the same data cleansing steps day after day? Power Query will make it faster to clean your data the first time. While Power Query is powerful, the interface is subtle-there are tools hiding in plain sight that are easy to miss. Go beyond the obvious and take Power Query to new levels with this book. Power Query is the amazing new data cleansing tool in both Excel and Power BI Desktop. Shipping may be from multiple locations in the US or from the UK, depending on stock availability.

Paperback. Etat : new. Paperback. 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 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 2024 adds information on Copilot and Python in Excel. Shipping may be from multiple locations in the US or from the UK, depending on stock availability.

Paperback. Etat : new. Paperback. This book is about Power Query and M Code.Power Query and the functional language M Code (M) are the heart and soul of Microsoft' s power data analysis tools: Excel, Power BI Desktop and Dataflows. The beautiful data driven and insightful PivotTables, Power BI solutions and Dashboards that you create usually require that you use Power Query and M Code to get, transform and load the data before you create the final reports and visuals. For many data analysis jobs, using the SQL language to perform ETL (extract, transform and load) is the preferred tool. Maybe even R or Python. But if you use Power BI or Excel, you better also be masterful with M Code and Power Query. Together, they give you the power to connect to multiple data sources, structuring your data with ease, and load to the worksheet, the data model in Excel or Power BI or Dataflow' s Data Hub.As an accountant, professor, data analyst, author, Excel MVP and YouTuber for about 20 years, my specialty is in telling stories with videos and books to make complicated things less complicated and to inspire you to have fun with the power you can gain over data. Shipping may be from multiple locations in the US or from the UK, depending on stock availability.

Paperback. Etat : Fair. A readable copy of the book which may include some defects such as highlighting and notes. Cover and pages may be creased and show discolouration.

Paperback. Etat : new. Paperback. 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. Shipping may be from multiple locations in the US or from the UK, depending on stock availability.

Paperback. Etat : new. Paperback. The essential guide for getting started with Power BI. Power BI is an amazing cloud-based business analytics service provided by Microsoft that allows people to transform data into rich, interactive visual reports that presents a 360-degree business view and improves business decision making. This book is designed to get the Excel analyst started with Power BI, touching on Power Query and Power Pivot. Shipping may be from multiple locations in the US or from the UK, depending on stock availability.

Paperback. Etat : new. Paperback. RAISING ARRAYS FOR MODELLINGThis book tries hard to raze a laugh (yes, that s what was meant ). Instead, through numerous examples and case studies, it details the impact of the ecosystem introduced by dynamic arrays in Excel, injecting life into the jaded, stale world of financial modelling.From comparing the old methodologies to the new frontiers, this book considers how dynamic arrays have reshaped Excel and made it Turing complete, with its liberal use of LET, LAMBDA, eta lambdas et al. LET invites complexity but reduces memory requirements, LAMBDA allows you to build anything, and dynamic arrays make it easy to quite literally extend your ideas and your way of thinking. See for yourself.Through a dynamic array of Best Practice tips, tricks, functions and features, Financial Modelling using Dynamic Arrays shows you how to revamp and reinvent your financial models with Excel 365. Recreate your development kit in this brave new world. Erase the old and embrace the arrays! Shipping may be from multiple locations in the US or from the UK, depending on stock availability.

Paperback. Etat : new. Paperback. Inspiring Excel tips designed to save 100 hours per year. 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 VLOOKUPand 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 2022 adds information on collaboration features, LET and LAMBDA functions, amazing new data types, dynamic array formulas, and more. Shipping may be from multiple locations in the US or from the UK, depending on stock availability.

Paperback. Etat : new. Paperback. 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 VLOOKUPand 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. Shipping may be from multiple locations in the US or from the UK, depending on stock availability.

Paperback. Etat : new. Paperback. This is a book about Microsoft 365 Excel, or Excel 365. With a new formula calculations engine and many new built-in functions, creating formula solutions and business models in Excel 365 is dramatically easier than at any time in the history of spreadsheets. In addition, with the new data tools like Power Query, Power Pivot, and Power BI, performing data analysis to make data driven decisions can be easily done on data with different structures, with different sources, and on small and big data alike. With this exciting new Excel 365 version, we will learn three types for formulas: Worksheet, M Code, and DAX, and we will learn three types of Reporting/Dashboarding tools: Standard PivotTables, Data Model PivotTables, and Power BI Visualizations. This means that the New Excel 365 is the only app that matters in our age of analytics and data driven decisions. Who is this book/class for? Everyone. The book starts at the beginning and moves to an advanced level by telling a logical story about how to use Excel to solve calculation-based problems and answer crucial questions. Shipping may be from multiple locations in the US or from the UK, depending on stock availability.

Paperback. Etat : new. Paperback. 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. Shipping may be from multiple locations in the US or from the UK, depending on stock availability.

Paperback. Etat : Very Good. The book has been read, but is in excellent condition. Pages are intact and not marred by notes or highlighting. The spine remains undamaged.

Paperback. Etat : new. Paperback. Power Query is the amazing new data cleansing tool in both Excel and Power BI Desktop. Do you find yourself performing the same data cleansing steps day after day? Power Query will make it faster to clean your data the first time. While Power Query is powerful, the interface is subtle-there are tools hiding in plain sight that are easy to miss. Go beyond the obvious and take Power Query to new levels with this book. Power Query is the amazing new data cleansing tool in both Excel and Power BI Desktop. Shipping may be from our Sydney, NSW warehouse or from our UK or US warehouse, depending on stock availability.

Paperback. Etat : new. Paperback. Inspiring Excel tips designed to save 100 hours per year. 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 VLOOKUPand 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 2022 adds information on collaboration features, LET and LAMBDA functions, amazing new data types, dynamic array formulas, and more. Shipping may be from our Sydney, NSW warehouse or from our UK or US warehouse, depending on stock availability.

Paperback. Etat : new. Paperback. Power Query is the amazing new data cleansing tool in both Excel and Power BI Desktop. Do you find yourself performing the same data cleansing steps day after day? Power Query will make it faster to clean your data the first time. While Power Query is powerful, the interface is subtle-there are tools hiding in plain sight that are easy to miss. Go beyond the obvious and take Power Query to new levels with this book. Power Query is the amazing new data cleansing tool in both Excel and Power BI Desktop. Shipping may be from our UK warehouse or from our Australian or US warehouses, depending on stock availability.

Paperback. Etat : new. Paperback. 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 VLOOKUPand 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. Shipping may be from our Sydney, NSW warehouse or from our UK or US warehouse, depending on stock availability.

Paperback. Etat : new. Paperback. This is a book about Microsoft 365 Excel, or Excel 365. With a new formula calculations engine and many new built-in functions, creating formula solutions and business models in Excel 365 is dramatically easier than at any time in the history of spreadsheets. In addition, with the new data tools like Power Query, Power Pivot, and Power BI, performing data analysis to make data driven decisions can be easily done on data with different structures, with different sources, and on small and big data alike. With this exciting new Excel 365 version, we will learn three types for formulas: Worksheet, M Code, and DAX, and we will learn three types of Reporting/Dashboarding tools: Standard PivotTables, Data Model PivotTables, and Power BI Visualizations. This means that the New Excel 365 is the only app that matters in our age of analytics and data driven decisions. Who is this book/class for? Everyone. The book starts at the beginning and moves to an advanced level by telling a logical story about how to use Excel to solve calculation-based problems and answer crucial questions. Shipping may be from our Sydney, NSW warehouse or from our UK or US warehouse, depending on stock availability.

Paperback. Etat : new. Paperback. 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. Shipping may be from our Sydney, NSW warehouse or from our UK or US warehouse, depending on stock availability.

Paperback. Etat : new. Paperback. 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. Shipping may be from our UK warehouse or from our Australian or US warehouses, depending on stock availability.

Paperback. Etat : new. Paperback. The essential guide for getting started with Power BI. Power BI is an amazing cloud-based business analytics service provided by Microsoft that allows people to transform data into rich, interactive visual reports that presents a 360-degree business view and improves business decision making. This book is designed to get the Excel analyst started with Power BI, touching on Power Query and Power Pivot. Shipping may be from our Sydney, NSW warehouse or from our UK or US warehouse, depending on stock availability.

Paperback. Etat : new. Paperback. The essential guide for getting started with Power BI. Power BI is an amazing cloud-based business analytics service provided by Microsoft that allows people to transform data into rich, interactive visual reports that presents a 360-degree business view and improves business decision making. This book is designed to get the Excel analyst started with Power BI, touching on Power Query and Power Pivot. Shipping may be from our UK warehouse or from our Australian or US warehouses, depending on stock availability.

Paperback. Etat : new. Paperback. 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 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 2024 adds information on Copilot and Python in Excel. Shipping may be from our UK warehouse or from our Australian or US warehouses, depending on stock availability.

Paperback. Etat : new. Paperback. This book is about Power Query and M Code.Power Query and the functional language M Code (M) are the heart and soul of Microsoft' s power data analysis tools: Excel, Power BI Desktop and Dataflows. The beautiful data driven and insightful PivotTables, Power BI solutions and Dashboards that you create usually require that you use Power Query and M Code to get, transform and load the data before you create the final reports and visuals. For many data analysis jobs, using the SQL language to perform ETL (extract, transform and load) is the preferred tool. Maybe even R or Python. But if you use Power BI or Excel, you better also be masterful with M Code and Power Query. Together, they give you the power to connect to multiple data sources, structuring your data with ease, and load to the worksheet, the data model in Excel or Power BI or Dataflow' s Data Hub.As an accountant, professor, data analyst, author, Excel MVP and YouTuber for about 20 years, my specialty is in telling stories with videos and books to make complicated things less complicated and to inspire you to have fun with the power you can gain over data. Shipping may be from our UK warehouse or from our Australian or US warehouses, depending on stock availability.