Professional Excel Development

Professional Excel Development PDF Author: Rob Bovey
Publisher: Addison-Wesley Professional
ISBN: 0321508793
Category : Computers
Languages : en
Pages : 1173

Get Book Here

Book Description
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.

The Definitive Guide to Windows Installer

The Definitive Guide to Windows Installer PDF Author: Phil Wilson
Publisher: Apress
ISBN: 1430206764
Category : Computers
Languages : en
Pages : 309

Get Book Here

Book Description
* 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.

The Definitive Guide to MySQL 5

The Definitive Guide to MySQL 5 PDF Author: Michael Kofler
Publisher: Apress
ISBN: 1430200715
Category : Computers
Languages : en
Pages : 756

Get Book Here

Book Description
* MySQL 5, due to be released in summer 2005, is slated to be the most significant release in the product’s history. The Definitive Guide to MySQL 5, Third Edition is the first book to offer in-depth instruction on the new features. * This book shows readers how to connect to MySQL via all of the major APIs, including PHP, Perl, Java, JSP, and C#/. * Novice and intermediate database administrators are introduced to both MySQL’s key features, and crucial database management concepts by way of real-world examples such as discussion forums, online polls, and other data administration projects.

Definitive Guide to Excel VBA

Definitive Guide to Excel VBA PDF Author: Michael Kofler
Publisher: Apress
ISBN: 1430206667
Category : Computers
Languages : en
Pages : 922

Get Book Here

Book Description
- Kofler's book offers more up-to-date coverage than other books on the market - Provides in-depth coverage of topics normally overlooked, such as the File Scripting Objects, accessing external databases using the ADO library, automating data analysis with pivot tables, and automating diagrams.

Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel, VBA, and .NET, Second Edition

Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel, VBA, and .NET, Second Edition PDF Author: Rob
Publisher:
ISBN: 9780321579126
Category : Electronic books
Languages : en
Pages :

Get Book Here

Book Description


Professional Microsoft® Smartphone Programming

Professional Microsoft® Smartphone Programming PDF Author: Baijian Yang
Publisher: John Wiley & Sons
ISBN: 0470135344
Category : Computers
Languages : en
Pages : 522

Get Book Here

Book Description
"Professor Yang and Dr. Zheng are two of the passionate young researchers in the field with a lot of hands-on experience. Professor Ni, on the other hand, is a veteran in wireless technologies, 2.5G/3G cellular phones, and embedded systems. The energy, the hands-on experience, and the long-term vision ensure that the book is of highest quality." --From the foreword by Ya-Qin Zhang, Corporate Vice President for Research, Microsoft China The second-generation Smartphone applications are exclusively designed to leverage the advantages of mobility and ubiquitous wireless access. This book provides you with an in-depth look at software development issues and design guidelines, and helps you gain the skills you need to develop your own efficient and feature-rich Smartphone applications that utilize the latest cutting-edge technologies. Complete with code and examples, the book first walks you through the Microsoft Smartphone platform from a software developer's perspective. It next uncovers the .NET Compact Framework as well as the Smartphone programming environment. You'll then find detailed information on Microsoft Smartphone-related application design and programming topics in the domains of the .NET Compact Framework (managed code). Plus, you'll explore advanced development topics such as security and performance considerations that you'll be able to incorporate into your own applications. What you will learn from this book * How to use the programming framework and classes available in Windows Mobile and Smartphone SDK * The fundamentals of .NET Compact Framework 2.0 * Techniques for developing your own robust Smartphone applications * Steps for customizing components and P/Invoke * How to enhance data and communication security * Ways to improve the performance of your applications * Fundamental techniques for supporting world-ready applications Who this book is for This book is for software architects and developers working in the area of mobile application development as well as professionals who want a quick and thorough overview of the Microsoft Smartphone software development platform. Wrox Professional guides are planned and written by working programmers to meet the real-world needs of programmers, developers, and IT professionals. Focused and relevant, they address the issues technology professionals face every day. They provide examples, practical solutions, and expert education in new technologies, all designed to help programmers do a better job.

Excel 2007 VBA Programmer's Reference

Excel 2007 VBA Programmer's Reference PDF Author: John Green
Publisher: John Wiley & Sons
ISBN: 1118169360
Category : Computers
Languages : en
Pages : 1178

Get Book Here

Book Description
This book is aimed squarely at Excel users who want to harness the power of the VBA language in their Excel applications. At all times, the VBA language is presented in the context of Excel, not just as a general application programming language. The Primer has been written for those who are new to VBA programming and the Excel object model. It introduces the VBA language and the features of the language that are common to all VBA applications. It explains the relationship between collections, objects, properties, methods, and events and shows how to relate these concepts to Excel through its object model. It also shows how to use the Visual Basic Editor and its multitude of tools, including how to obtain help. The middle section of the book takes the key objects in Excel and shows, through many practical examples, how to go about working with those objects. The techniques presented have been developed through the exchange of ideas of many talented Excel VBA programmers over many years and show the best way to gain access to workbooks, worksheets, charts, ranges, and so on. The emphasis is on efficiency—that is, how to write code that is readable and easy to maintain and that runs at maximum speed. In addition, the chapters devoted to accessing external databases detail techniques for accessing data in a range of formats. The final four chapters of the book address the following advanced issues: linking Excel to the Internet, writing code for international compatibility, programming the Visual Basic Editor, and how to use the functions in the Win32 API (Windows 32-bit Application Programming Interface).

Data Visualization and Statistical Literacy for Open and Big Data

Data Visualization and Statistical Literacy for Open and Big Data PDF Author: Prodromou, Theodosia
Publisher: IGI Global
ISBN: 1522525130
Category : Computers
Languages : en
Pages : 385

Get Book Here

Book Description
Data visualization has emerged as a serious scholarly topic, and a wide range of tools have recently been developed at an accelerated pace to aid in this research area. Examining different ways of analyzing big data can result in increased efficiency for many corporations and organizations. Data Visualization and Statistical Literacy for Open and Big Data highlights methodological developments in the way that data analytics is both learned and taught. Featuring extensive coverage on emerging relevant topics such as data complexity, statistics education, and curriculum development, this publication is geared toward teachers, academicians, students, engineers, professionals, and researchers that are interested in expanding their knowledge of data examination and analysis.

Programming Excel with VBA

Programming Excel with VBA PDF Author: Flavio Morgado
Publisher: Apress
ISBN: 1484222059
Category : Computers
Languages : en
Pages : 802

Get Book Here

Book Description
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 object Methods for working with ranges in detail using code Usage of Excel as a database repository How to exchange data between Excel applications How to use the Windows API to expand the capabilities of Excel A 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.

Financial Applications using Excel Add-in Development in C / C++

Financial Applications using Excel Add-in Development in C / C++ PDF Author: Steve Dalton
Publisher: John Wiley & Sons
ISBN: 0470027975
Category : Business & Economics
Languages : en
Pages : 586

Get Book Here

Book Description
Financial Applications using Excel Add-in Development in C/C++ is a must-buy book for any serious Excel developer.Excel is the industry standard for financial modelling, providing a number of ways for users to extend the functionality of their own add-ins, including VBA and C/C++. This is the only complete how-to guide and reference book for the creation of high performance add-ins for Excel in C and C++ for users in the finance industry. Steve Dalton explains how to apply Excel add-ins to financial applications with many examples given throughout the book. It also covers the relative strengths and weaknesses of developing add-ins for Excel in VBA versus C/C++, and provides comprehensive code, workbooks and example projects on the accompanying CD-ROM. The impact of Excel 2007’s multi-threaded workbook calculations and large grids on add-in development are fully explored. Financial Applications using Excel Add-in Development in C/C++ features: Extensive example codes in VBA, C and C++, explaining all the ways in which a developer can achieve their objectives. Example projects that demonstrate, from start to finish, the potential of Excel when powerful add-ins can be easily developed. Develops the readers understanding of the relative strengths and weaknesses of developing add-ins for Excel in VBA versus C/C++. A CD-ROM with several thousand lines of example code, numerous workbooks, and a number of complete example projects.