holy macro books uniontown (36 risultati)

Paperback. Condizione: Very Good. Providing the tools and techniques necessary for finding errors and fraud in audits, this guide for auditors looking to better validate their Microsoft Excel spreadsheets provides techniques for performing a risk assessment and gathering spreadsheet and other data from company systems. Performing audit data analysis using data and analytical management functions and pinpointing the common errors in spreadsheets with focused Excel tests is discussed, as are the best practices for error and fraud prevention when developing spreadsheets. This reference is fully updated to reflect Excel 12. 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. Condizione: Very Good. For any Microsoft Office user familiar with Word, Excel, PowerPoint, Access, or Outlook, this book provides tutorials on the tools and tricks that automate these programs for increased productivity. Each lesson includes instructions and a downloadable file on which to test the VBA macros and procedures provided. Tasks covered include how to run several mail merges at once, removing duplicates from data, and saving email attachments. 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. Condizione: As New. 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. Condizione: new. Paperback. A simple walk-through of the common perils and pitfalls of financial modelling, this book examines the most common and necessary Excel functions, emphasizes the importance of a standardized and functional layout, explains accounting concepts simply, and reinforces four key concepts of best practice: consistency, robustness, flexibility, and transparency-CraFT. With more than fifty examples and an extended case study, this hands-on book helps users work with Excel more efficiently and effectively. This simple methodology has been adopted by many seasoned professionals who no longer must resort to balancing figures, circulars, and macros. Includes second edition addendum (page [326]). Shipping may be from our UK warehouse or from our Australian or US warehouses, depending on stock availability.

Paperback. Condizione: new. Paperback. 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. "A book about building efficient formulas, advanced formulas, and array formulas for data analysis and calculating problems"--Cover. Shipping may be from our UK warehouse or from our Australian or US warehouses, depending on stock availability.

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

Paperback. Condizione: 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. Condizione: 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. Condizione: 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.

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

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

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

Paperback. Condizione: new. Paperback. This book is aimed at those who wish to advance their knowledge and expertise in financial modelling by addressing common problems that occur day to day in the world of business/decision analyses, forecasting, and valuations. Building on the sister book, An Introduction to Financial Modelling, this book begins where the other ends considering typical issues and traps in cashflow forecasting, inventory modelling, depreciation calculations, debt sculpting, rolling budgets and charts, and valuation construction, to name just a few relevant topics. Shipping may be from our UK warehouse or from our Australian or US warehouses, depending on stock availability.

Paperback. Condizione: 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.