Excel 2016 power programming with vba, Alexander, Michael (mckinney, Tx) Kusleika, Richard
Новое издание
Автор: Alexander Michael, Kusleika Richard Название: Excel 2019 Power Programming with VBA ISBN: 1119514924 ISBN-13(EAN): 9781119514923 Издательство: Wiley Цена: 47520 T Описание: Maximize your Excel experience with VBA
Excel 2019 Power Programming with VBA is fully updated to cover all the latest tools and tricks of Excel 2019. Encompassing an analysis of Excel application development and a complete introduction to Visual Basic for Applications (VBA), this comprehensive book presents all of the techniques you need to develop both large and small Excel applications. Over 800 pages of tips, tricks, and best practices shed light on key topics, such as the Excel interface, file formats, enhanced interactivity with other Office applications, and improved collaboration features.
Understanding how to leverage VBA to improve your Excel programming skills can enhance the quality of deliverables that you produce--and can help you take your career to the next level.
Explore fully updated content that offers comprehensive coverage through over 900 pages of tips, tricks, and techniques
Leverage templates and worksheets that put your new knowledge in action, and reinforce the skills introduced in the text
Improve your capabilities regarding Excel programming with VBA, unlocking more of your potential in the office
Excel 2019 Power Programming with VBA is a fundamental resource for intermediate to advanced users who want to polish their skills regarding spreadsheet applications using VBA.
Автор: Posch, Peter N. , Loeeffler, Gunter Название: Credit risk modeling using excel and vba (Книга: Пош, Питер Н., Леффлер, Гюнтер.Моделирование кредитного риска с использованием Excel и VBA) ISBN: 0470660929 ISBN-13(EAN): 9780470660928 Издательство: Wiley Рейтинг: Цена: 77090.00 T Наличие на складе: Есть у поставщика Поставка под заказ. Описание: It is common to blame the inadequacy of credit risk models for the fact that the financial crisis has caught many market participants by surprise. On closer inspection, though, it often appears that market participants failed to understand or to use the models correctly. The recent events therefore do not invalidate traditional credit risk modeling as described in the first edition of the book.
A second edition is timely, however, because the first dealt relatively briefly with instruments featuring prominently in the crisis (CDSs and CDOs). In addition to expanding the coverage of these instruments, the book will focus on modeling aspects which were of particular relevance in the financial crisis (e.g. estimation error) and demonstrate the usefulness of credit risk modelling through case studies.
This book provides practitioners and students with an intuitive, hands-on introduction to modern credit risk modelling. Every chapter starts with an explanation of the methodology and then the authors take the reader step by step through the implementation of the methods in Excel and VBA. They focus specifically on risk management issues and cover default probability estimation (scoring, structural models, and transition matrices), correlation and portfolio analysis, validation, as well as credit default swaps and structured finance.
The book has an accompanying website, http://loeffler-posch.com/, which has been specially updated for this Second Edition and contains slides and exercises for lecturers.
Автор: Urtis Tom Название: Excel VBA 24-Hour Trainer ISBN: 1118991370 ISBN-13(EAN): 9781118991374 Издательство: Wiley Рейтинг: Цена: 39070.00 T Наличие на складе: Есть у поставщика Поставка под заказ. Описание: Master VBA automation quickly and easily to get more out of Excel Excel VBA 24-Hour Trainer, 2nd Edition is the quick-start guide to getting more out of Excel, using Visual Basic for Applications.
Автор: Roman, Steven (california State University, Usa) Название: Writing excel macros with vba ISBN: 0596003595 ISBN-13(EAN): 9780596003593 Издательство: Wiley Рейтинг: Цена: 33780.00 T Наличие на складе: Есть у поставщика Поставка под заказ. Описание: Updated for Excel 2002, this text offers Excel power-users, as well as programmers who are unfamiliar with the Excel object model, with an introduction to writing Visual Basic for Applications (VBA) macros and programs for Excel.
Автор: Walkenbach John Название: Excel 2013 Power Programming with VBA ISBN: 1118490398 ISBN-13(EAN): 9781118490396 Издательство: Wiley Рейтинг: Цена: 47520.00 T Наличие на складе: Есть у поставщика Поставка под заказ. Описание: Maximize your Excel 2013 experience using VBA application development The new Excel 2013 boasts updated features, enhanced power, and new capabilities.
Автор: Morgado Название: Programming Excel with VBA ISBN: 1484222040 ISBN-13(EAN): 9781484222041 Издательство: Springer Рейтинг: Цена: 51230.00 T Наличие на складе: Есть у поставщика Поставка под заказ. Описание:
Learn to harness the power of Visual Basic for Applications (VBA) in Microsoft Excel to develop interesting, useful, and interactive Excel applications. This book will show you how to manipulate Excel with code, allowing you to unlock extra features, accuracy, and efficiency in working with your data. Programming Excel 2016 with VBA is a complete guide to Excel application development, using step-by-step guidance, example applications, and screenshots in Excel 2016.
In this book, you will learn:
How to interact with key Excel objects, such as the application object, workbook object, and range objectMethods for working with ranges in detail using codeUsage of Excel as a database repositoryHow to exchange data between Excel applicationsHow to use the Windows API to expand the capabilities of ExcelA step-by-step method for producing your own custom Excel ribbon
Who This Book Is For:
Developers and intermediate-to-advanced Excel users who want to dive deeper into the capabilities of Excel 2016 using code.
Автор: Guojun Gan Название: An Introduction to Excel VBA Programming: with Applications in Finance and Insurance ISBN: 0367261286 ISBN-13(EAN): 9780367261283 Издательство: Taylor&Francis Рейтинг: Цена: 50010.00 T Наличие на складе: Есть у поставщика Поставка под заказ. Описание: This textbook has been written for undergraduate students majoring in actuarial science and related areas who wish to learn the basic fundamentals and applications of Excel VBA. It can also be used as supplementary reading for courses related to computer programming, financial modelling, and information technology for business.
Автор: Martin Robert Название: Excel Programming with VBA Starter ISBN: 1849688443 ISBN-13(EAN): 9781849688444 Издательство: Неизвестно Рейтинг: Цена: 26960.00 T Наличие на складе: Есть у поставщика Поставка под заказ.
Автор: Walkenbach, John Название: Excel 8211 vba fur dummies a3 ISBN: 3527715487 ISBN-13(EAN): 9783527715480 Издательство: Wiley Рейтинг: Цена: 21110.00 T Наличие на складе: Невозможна поставка.
Автор: Lee Название: Essentials of Excel VBA, Python, and R ISBN: 3031142829 ISBN-13(EAN): 9783031142826 Издательство: Springer Рейтинг: Цена: 111790.00 T Наличие на складе: Поставка под заказ. Описание: This advanced textbook for business statistics teaches, statistical analyses and research methods utilizing business case studies and financial data with the applications of Excel VBA, Python and R. Each chapter engages the reader with sample data drawn from individual stocks, stock indices, options, and futures. Now in its second edition, it has been expanded into two volumes, each of which is devoted to specific parts of the business analytics curriculum. To reflect the current age of data science and machine learning, the used applications have been updated from Minitab and SAS to Python and R, so that readers will be better prepared for the current industry. This second volume is designed for advanced courses in financial derivatives, risk management, and machine learning and financial management. In this volume we extensively use Excel, Python, and R to analyze the above-mentioned topics. It is also a comprehensive reference for active statistical finance scholars and business analysts who are looking to upgrade their toolkits. Readers can look to the first volume for dedicated content on financial statistics, and portfolio analysis.
Автор: Aspin Название: High Impact Data Visualization in Excel with Power View, 3D Maps, Get & Transform and Power BI ISBN: 1484223993 ISBN-13(EAN): 9781484223994 Издательство: Springer Рейтинг: Цена: 41920.00 T Наличие на складе: Есть у поставщика Поставка под заказ. Описание: Take business intelligence delivery to a new level that is interactive, engaging, even fun, all while driving commercial success through sound decision making. Do this through the power of visualization using this updated edition covering new features and added support for visualization in Excel 2016, and describing the latest developments in Get & Transform and DAX. The example data set has also been updated to demonstrate all that Microsoft's self-service business intelligence suite is now capable of. Data Visualization in Excel 2016: Power View, 3D Maps, Get & Transform, and Power BI, 2nd Edition helps in harnessing the power of Microsoft’s flagship, self-service business intelligence suite to deliver compelling and interactive insight with remarkable ease. Learn the essential techniques needed to enhance the look and feel of reports and dashboards so that you can seize your audience’s attention and provide them with clear and accurate information. Also learn to integrate data from a variety of sources and create coherent data models displaying clear metrics and attributes. Power View is Microsoft's ground-breaking tool for ad-hoc data visualization and analysis. It's designed to produce elegant and visually arresting output. It's also built to enhance user experience through polished interactivity. Power Map is a similarly powerful mechanism for analyzing data across geographic and political units. Get & Transform lets you load, shape and streamline data from multiple sources. Power Pivot can extend and develop data into a dynamic model. Power BI allows you to share your findings with colleagues, and present your insights to clients. Data Visualization in Excel 2016: Power View, 3D Maps, Get & Transform, and Power BI helps you master this suite of powerful tools from Microsoft. You'll learn to identify data sources, and to save time by preparing your underlying data correctly. You'll also learn to deliver your powerful visualizations and analyses through the cloud to PCs, tablets and smartphones.Simple techniques take raw data and convert it into information.Slicing and dicing metrics delivers interactive insight.Visually arresting output grabs and focuses attention on key indicators.What You Will Learn
Produce designer output that will astound your bosses and peers.Drive business intelligence from Excel using BI in the Cloud.Gather source data from corporate and public sources.Integrate charts, maps, and tables to deliver visually stunning information.Discover new insights as you chop and tweak your data as never before.Adapt delivery to mobile devices.Outshine competing products and enhance existing skills.
Who This Book Is For
Any Power BI Desktop, Excel or SharePoint user. Business Intelligence developers, power users, IT managers, finance experts, and more can use this book to outshine the competition by producing high-impact business intelligence reporting on a variety of devices from a variety of sources.
Автор: Smart Mike Название: Learn Excel 2019 Expert Skills with the Smart Method: Tutorial Teaching Advanced Skills Including Power Pivot ISBN: 1909253359 ISBN-13(EAN): 9781909253353 Издательство: Неизвестно Рейтинг: Цена: 30640.00 T Наличие на складе: Есть у поставщика Поставка под заказ. Описание: First published in English in 1970, the first chapter of the book by Jean Francois le Ny is concerned with conditioned reactions. The second contributor, Gerard de Montpellier, looks at different types of learning. The third section of the book by Genevieve Oleron deals with the phenomenon of transfer. In the final chapter, Cesar Flores examines memory, forgetting and reminiscence.
Автор: Aspin, Adam Название: Data mashup with microsoft excel using power query and m ISBN: 1484260171 ISBN-13(EAN): 9781484260173 Издательство: Springer Рейтинг: Цена: 69870.00 T Наличие на складе: Есть у поставщика Поставка под заказ. Описание: Intermediate-Advanced user level
Казахстан, 010000 г. Астана, проспект Туран 43/5, НП2 (офис 2) ТОО "Логобук" Тел:+7 707 857-29-98 ,+7(7172) 65-23-70 www.logobook.kz
