
Collapse
Featured Categories
1. | ![]() Advanced Modelling in Finance Using Excel and VBA By: Mary Jackson; Mike Staunton Publisher: John Wiley & Sons Publication Date: 15-JUN-2001 Insert Date: 08-JUN-2009 Bookshelf Slots: 1.0 | Overview: Advanced Modelling in Finance Using Excel and VBA
This new and unique book demonstrates that Excel and VBA can play an important role in the explanation and implementation of numerical methods across finance. Advanced Modelling in Finance provides a comprehensive look at equities, options on equities and options on bonds from the early 1950s to the late 1990s.
The book adopts a step-by-step approach to understanding the more sophisticated aspects of Excel macros and VBA programming, showing how these programming techniques can be used to model and manipulate financial data, as applied to equities, bonds and options. The book is...
|
2. | ![]() By: Rob Bovey; Dennis Wallentin; Stephen Bullen; John Green Publisher: Addison-Wesley Professional Publication Date: 06-MAY-2009 Insert Date: 10-FEB-2009 Bookshelf Slots: 1.0 | This is the Safari online edition of the printed book.
The
Start-to-Finish Guide to Building State-of-the-Art Solutions with
Excel 2007
In this book,
four world-class Microsoft® Excel developers offer
start-to-finish guidance for building powerful, robust, and secure
applications with Excel. The authors–three of whom have been
honored by Microsoft as Excel Most Valuable Professionals
(MVPs)–show how to consistently make the right design
decisions and make the most of Excel’s most powerful new
features. Using their techniques,you can reduce development costs,
time to market, and hassle–and...
|
3. | ![]() Excel® 2007 Power Programming with VBA By: John Walkenbach Publisher: John Wiley & Sons Publication Date: 16-APR-2007 Insert Date: 01-OCT-2008 Bookshelf Slots: 1.0 | Overview: Excel® 2007 Power Programming with VBA
This book is a single reference that’s indispensable for
Excel beginners, intermediate users, power users, and would-be
power users everywhere
Fully updated for the new release, this latest edition provides
comprehensive, soup-to-nuts coverage, delivering over 900 pages of
Excel tips, tricks, and techniques readers won’t find
anywhere else
John Walkenbach, aka "Mr. Spreadsheet," is one of the
world’s leading authorities on Excel
Thoroughly updated to cover the revamped Excel interface, new
file formats, enhanced interactivity with other Office
applications, and upgraded...
|
4. | ![]() Writing Word Macros, 2nd Edition Publisher: O'Reilly Media, Inc. Publication Date: 15-OCT-1999 Insert Date: 30-JAN-2008 Bookshelf Slots: 1.0 | Overview: Writing Word Macros, 2nd Edition
Many Microsoft Word users and VBA programmers don't realize the
extensive opportunities that exist when Word's Object Model is
accessed using Visual Basic for Applications (VBA), which replaced
WordBasic in conjunction with the release of Word 97. By creating
what is commonly called a "Word Macro" you can automate many
features available in Word. Writing Word Macros (previously
titled Learning Word Programming is the introduction to Word
VBA that allows you to do these things and more, including:
Create custom pop-up menusAutomatically create tables from listsAppend one document to the end...
|
5. | ![]() Microsoft® Office Access 2007 VBA By: Scott B. Diamond; Brent Spaulding Publisher: Que Publication Date: 27-NOV-2007 Insert Date: 26-SEP-2007 Bookshelf Slots: 1.0 | Overview: Microsoft® Office Access 2007 VBA Business Solutions
Microsoft® Office Access 2007 VBA
Develop your Access 2007 VBA expertise
instantly with proven techniques
Microsoft Office Access 2007 VBA builds on
the skills you’ve already developed in creating database
applications and helps you take them to the next level—using
Visual Basic for Applications (VBA) to accomplish things you once
performed manually. To facilitate this lofty goal, Access includes
the VBA programming language. Even if you’ve never
programmed, this book will help you learn how to leverage the power
of VBA to make your work with Access more efficient...
|
6. | ![]() Business Solutions VBA and Macros for Microsoft® Office Excel® 2007 Publisher: Que Publication Date: 09-AUG-2007 Insert Date: 21-MAR-2007 Bookshelf Slots: 1.0 | Overview: Business Solutions VBA and Macros for Microsoft® Office Excel® 2007 “In this day and age of ‘too
much information and not enough time,’ the ability to get to
the bottom line quickly and in a concise method is what excels
companies to the top of their industry. The techniques in this book
will allow you to do things you only dreamt of.”
—Jerry Kohl, president of Brighton
Collectibles
Develop your Excel macro programming skills
using VBA instantly with proven techniques
Automate Reports
Handle Errors
Master Pivot Tables
Produce Charts
Build User-Defined Functions
Migrate to Excel 2007
Query Web Data
Build Dialog Boxes
Use Data...
|
7. | ![]() By: Kathleen McGrath; Paul Stubbs Publisher: Addison-Wesley Professional Publication Date: 29-DEC-2006 Insert Date: 14-JAN-2007 Bookshelf Slots: 1.0 |
Praise for VSTO for Mere Mortals™
"This is the book I wish I'd had when I was first introduced to
VSTO and the .NET Framework. It will be invaluable not only to
those considering VSTO, but for anyone transitioning from Office
VBA to Visual Basic.NET. The wide range of subjects covered
provides an entry point for the more in-depth, developer-oriented
documentation available on MSDN and elsewhere."
–Cindy Meister, MS Word MVP
"VSTO for Mere Mortals™ does a great job of
building a bridge between the worlds of VBA and VSTO. Kathleen and
Paul show how a VBA developer can have the richness of...
|
8. | ![]() Business Solutions VBA for the 2007 Microsoft® Office System By: Paul McFedries Publisher: Que Publication Date: 30-MAR-2007 Insert Date: 12-JAN-2007 Bookshelf Slots: 1.0 | Overview: Business Solutions VBA for the 2007 Microsoft® Office System
“VBA for the 2007 Microsoft Office
System is jam-packed with code samples that you’ll be able to
reuse right away in your VBA projects.”
—Guy Barrette, Microsoft MVP &
Regional Director, .NET Expertise
Develop
your VBA expertise
instantly with proven techniques
VBA for the 2007 Microsoft® Office
System shows you how to take full advantage of the 2007
Microsoft Office suite by automating routine Office tasks. No
matter which Office application you’re using, there are some
tasks you perform dozens of times, such as typing a section of
text, running a series of menu commands, or...
|
9. | ![]() Programming Excel with VBA and .NET By: Jeff Webb; Steve Saunders Publisher: O'Reilly Media, Inc. Publication Date: 25-APR-2006 Insert Date: 10-MAY-2006 Bookshelf Slots: 1.0 | Overview: Programming Excel with VBA and .NET
Why program Excel? For solving complex calculations and
presenting results, Excel is amazingly complete with every
imaginable feature already in place. But programming Excel isn't
about adding new features as much as it's about combining existing
features to solve particular problems. With a few modifications,
you can transform Excel into a task-specific piece of software that
will quickly and precisely serve your needs. In other words, Excel
is an ideal platform for probably millions of small
spreadsheet-based software solutions.The best part is, you can program Excel with no...
|
10. | Finally, there's a book that treats Excel as the powerful
development platform it really is, and covers every facet of
developing commercial-quality Excel applications.
This is not a book for beginners. Writing for professional
developers and true Excel experts, the authors share insider's
knowledge they've acquired building Excel applications for many of
the world's largest companies—including Microsoft.
Professional Excel Development demonstrates how to get the utmost
from Excel, addressing everything from application architectures
through worksheet and userform design, charting,...
|
About Safari Books Online •
Terms of Service •
Privacy Policy •
Contact Us •
Corporate Licenses •
Help •
Accessibility |
![]()
![]()
![]()
![]()
Copyright 2009 Safari Books Online. All rights reserved.




