Author : Rob Bovey
Publisher : Addison-Wesley Professional
Page : 1173 pages
File Size : 50,13 MB
Release : 2009
Category : Computers
ISBN : 0321508793
The definitive guide to developing applications with Microsoft Excel, this book is written by four authors who are Excel MVPs and run their own companies developing Excel-based applications.
Author : Phil Wilson
Publisher : Apress
Page : 309 pages
File Size : 50,82 MB
Release : 2004-04-26
Category : Computers
ISBN : 1430206764
* Comprehensive Guide to Windows Installer technology – applicable for all languages and tools on the Microsoft platform. * Focus on use from Visual Studio and Visual Studio .NET means it does not require purchase of a separate high-priced installation tool (from InstallShield or Wise). The Windows Installer ships with Visual Studio .NET resulting in increasing market share—and the need for this book. * Extensive coverage of .NET project types including web applications and services – information not found anywhere else.
Author : John Green
Publisher : Wrox
Page : 760 pages
File Size : 49,73 MB
Release : 1999
Category : Business
ISBN : 9781861002549
Office 2002 is the next version (after Office 2000) of Microsoft's program suite that includes Word, Access, Outlook and Excel. The aim of 2002 is to take advantage of Office's core position within most business systems and make it the interface to business processes and web services. One of the most significant advances is the XML capability that has been added to Access and Excel, with the latter becoming the key to future Web Service integration and an essential part of any Office developer's skill set. -- Written by two active and popular members of the Excel community -- Includes coverage of all the new features including smart tags, pivot tables, and web components -- Examines all the new XML capabilities that 2002 brings to the Excel world
Author : Michael Alexander
Publisher : John Wiley & Sons
Page : 785 pages
File Size : 10,30 MB
Release : 2019-04-24
Category : Computers
ISBN : 1119514940
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.
Author : Shahar Prish
Publisher : John Wiley & Sons
Page : 482 pages
File Size : 42,41 MB
Release : 2007-05
Category :
ISBN : 9788126512362
Market_Desc: · Primary Audience: The target readership includes SQL Programmers, Report Developers, software integrators, and sophisticated Microsoft Excel Users.· Secondary Audience: Excel users and programmers. Special Features: · Authored by THE expert on the topic, Shahar Prish. He is the Senior Software Development Engineer for Excel Services.· Fills an unmet need in the market for comprehensive coverage on the technical and strategic features vital to Excel Services.· Provides readers with extensive and in-depth information calculating Excel workbooks on a server using Excel Client, rewriting Excel models into code, writing generic solutions for calculating sheets, and by covering all programming aspects of Excel Services - from APIs through UDFs.· Audience - Sophisticated Microsoft Excel users, SQL Programmers, IT Professionals, and report Developers will use this book to get the most out of Excel Services. About The Book: Excel Services has the potential to revolutionize many industries because Excel 2007 has a number of key investments around UDFs, or User Defined Functions. They revolve around two main areas: allowing UDFs to take advantage of Excel improvements, and extending those UDF-based Excel solutions to the server side with Excel Services.This book instructs readers on how to develop solutions using Excel Services. It covers all facets of programming Excel Services to unlock the power behind the software. To this point, these solutions have definitely been lacking in areas such as running Excel on Excel Client, rewriting Excel models into code, and writing generic solutions for calculating sheets. This book covers ways to use the Services to get around any stumbling blocks.
Author : Jordan Goldmeier
Publisher : Apress
Page : 203 pages
File Size : 17,78 MB
Release : 2014-11-10
Category : Computers
ISBN : 1484207343
Advanced Excel Essentials is the only book for experienced Excel developers who want to channel their skills into building spreadsheet applications and dashboards. This book starts from the assumption that you are well-versed in Excel and builds on your skills to take them to an advanced level. It provides the building blocks of advanced development and then takes you through the development of your own advanced spreadsheet application. For the seasoned analyst, accountant, financial professional, management consultant, or engineer—this is the book you’ve been waiting for! Author Jordan Goldmeier builds on a foundation of industry best practices, bringing his own forward-thinking approach to Excel and rich real-world experience, to distill a unique blend of advanced essentials. Among other topics, he covers advanced formula concepts like array formulas and Boolean logic and provides insight into better code and formulas development. He supports that insight by showing you how to build correctly with hands-on examples.
Author : John Walkenbach
Publisher : John Wiley & Sons
Page : 1109 pages
File Size : 34,57 MB
Release : 2013-04-01
Category : Computers
ISBN : 1118490398
Maximize your Excel 2013 experience using VBA application development The new Excel 2013 boasts updated features, enhanced power, and new capabilities. Naturally, that means John Walkenbach returns with a new edition of his bestselling VBA Programming book and covers all the methods and tools you need to know in order to program with Excel. With this comprehensive guide, "Mr. Spreadsheet" shows you how to maximize your Excel experience using professional spreadsheet application development tips from his own personal bookshelf. Featuring a complete introduction to Visual Basic for Applications and fully updated for the latest features of Excel 2013, this essential reference includes an analysis of Excel application development and is packed with procedures, tips, and ideas for expanding Excel's capabilities with VBA. Offers an analysis of Excel application development and a complete introduction to VBA Features invaluable advice from "Mr. Spreadsheet" himself, bestselling author John Walkenbach, who demonstrates all the techniques you need to create Excel applications, both large and small Covers navigating the Excel interface, formatting worksheets, interacting with other Office applications, working with collaboration tools, and using sample workbooks and John Walkenbach's award-winning Power Utility Pak to help enhance your Excel skills Provides tips, tricks, and techniques for expanding Excel's capabilities with VBA that you wont find anywhere else Excel 2013 Power Programming with VBA is packed with procedures, tips, and ideas for achieving Excel excellence with VBA.
Author : Donny C. F. Lai
Publisher : John Wiley & Sons
Page : 372 pages
File Size : 37,12 MB
Release : 2011-12-28
Category : Business & Economics
ISBN : 1118179080
"Professional Financial Computing Using Excel and VBA is an admirable exposition that bridges the theoretical underpinnings of financial engineering and its application which usually appears as a "black-box" software application. The book opens the black-box and reveals the architecture of risk-modeling and financial engineering based on industry-standard stochastic models by utilizing Excel and VBA functionality to create a robust and practical modeling tool-kit. Financial engineering professionals who purchase this book will have a jumpstart advantage for their customized financial engineering and modeling needs." Dr. Cameron Wicentowich Vice President, Treasury Analytics Canadian Imperial Bank of Commerce (CIBC) "Spreadsheet modeling for finance has become a standard course in the curriculum of many Quantitative Finance programs since the Excel-based Visual Basic programming is now widely used in constructing optimal portfolios, pricing structured products and managing risks. Professional Financial Computing Using Excel and VBA is written by a unique team of finance, physics and computer academics and practitioners. It is a good reference for those who are studying for a Masters degree in Financial Engineering and Risk Management. It can also be useful for financial engineers to jump-start a project on designing structured products, modeling interest term structure or credit risks." Dr. Jin Zhang Director of Master of Finance Program and Associate Professor The University of Hong Kong "Excel has been one of the most powerful tools for financial planning and computing over the last few years. Most users utilize a fraction of its capabilities. One of the reasons is the limited availability of books that cover the advanced features of Excel for Finance. Professional Financial Computing Using Excel and VBA goes the extra mile and deals with the Excel tools many professionals call for. This book is a must for professionals or students dealing with financial engineering, financial risk management, computational finance or mathematical finance. I loved the way the authors covered the material using real life, hands-on examples." Dr. Isaac Gottlieb Temple University Author, Next Generation Excel: Modeling in Excel for Analysts and MBAs
Author : Duane Birnbaum
Publisher : Cengage Learning
Page : 750 pages
File Size : 28,23 MB
Release : 2003
Category : Computers
ISBN : 9781592000654
The book is written by a long-time Excel user with significant programming and teaching experience, both of which provide the author the insight needed to present the topic in a manner that can be more easily understood by the reader. Microsoft Excel VBA Professional Projects uses practical examples of VBA-code included in useful and fully functional projects to better illustrate how and when to use specific tools. The book will not assume any prior knowledge of VBA programming. It will not intimidate intermediate-level programmers or patronize advanced programmers looking to learn a new language. The book will illustrate and teach intermediate to advanced techniques in VBA programming using Microsoft's Excel spreadsheet application. It will provide an introduction to VBA and Excel-VBA before proceeding through four or five programming projects using Excel that illustrate basic and advanced programming techniques.
Author : S. Christian Albright
Publisher :
Page : 681 pages
File Size : 10,33 MB
Release : 2007
Category : Decision support systems
ISBN : 9780495106852
