Author and Excel guru John Walkenbach, known to his devoted fans as "Mr. Spreadsheet," guides you through taking your Excel skills to the next level by creating your own customized spreadsheet solutions using Visual Basic for Applications (VBA). This updated edition of this bestselling book shows you more » how to use VBA, write macros, customize your Excel apps to look and work the way you want, avoid errors, and more. « less
Moving from Visual Basic and VBA to C#
Working with data and databases in C# certainly can be daunting if you're coming from VB6, VBA, or Access. With this hands-on guide, you'll shorten the learning curve considerably as you master accessing, adding, updating, and deleting data with C# - basic skills you need if you intend to program with more » this language.
No previous knowledge of C# is necessary. By following the examples in this book, you'll learn how to tackle several database tasks in C#, such as working with SQL Server, building data entry forms, and using data in a web service. The book's code samples will help you get started on your own projects. « less
Extend and enhance your Excel spreadsheets using the power of Macros and VBA programming.
Get to grips with the VBA language to create professional spreadsheets.
Follow practical examples to common problems that you will find yourself using time and time again.
Get the most out of Excel 2010 with Excel 2010 Made Simple - learn the key features, understand what's new, and utilize dozens of time-saving tips and tricks to get your job done. Over 500 screen visuals and clear-cut instructions guide you through the features of Excel 2010, from formulas and charts more » to navigating around a worksheet and understanding Visual Basic for Applications (VBA) and macros.
Excel 2010 Made Simple takes a practical and highly effective approach to using Excel 2010, showing you the best way to complete your most common spreadsheet tasks. You'll learn how to input, format, sort, and filter your data to find out what you want to know. You'll see how to place your data in tables and named ranges for easy access, all of which will get you working efficiently and productively. « less
Object Oriented Applications with VBA
Implementing Models of Financial Derivatives is a comprehensive treatment of advanced implementation techniques in VBA for models of financial derivatives. Aimed at readers who are already familiar with the basics of VBA it emphasizes a fully object oriented approach to valuation applications, chiefly more » in the context of Monte Carlo simulation but also more broadly for lattice and PDE methods. Its unique approach to valuation, emphasizing effective implementation from both the numerical and the computational perspectives makes it an invaluable resource. The book comes with a library of almost a hundred Excel spreadsheets containing implementations of all the methods and models it investigates, including a large number of useful utility procedures. Exercises structured around four application streams supplement the exposition in each chapter, taking the reader from basic procedural level programming up to high level object oriented implementations. « less
You're beyond the basics, so dive right in and customize, automate, and extend Access - using Visual Basic for Applications (VBA). This supremely organized reference is packed with hundreds of time-saving solutions, troubleshooting tips, and workarounds. It's all muscle and no fluff. Discover how the more » experts use VBA to exploit the power of Access - and challenge yourself to new levels of mastery! « less
Take your Excel skills to the next level with VBA programming
Now that you've mastered Excel basics, it's time to move to the next level-creating your own, customized Excel 2010 solutions using Visual Basic for Applications (VBA). The new edition of this non-threatening guide is your key to getting more » there. Using step-by-step instruction and the accessible, friendly For Dummies style, this practical book shows you how to use VBA, write macros, customize your Excel apps to look and work the way you want, avoid errors, and more. « less
You're a sophisticated user of Excel - a real pro with spreadsheet - so now dig into its powerful programming capabilities and really put your data to work! From writing code in Microsoft Visual Basic for Applications (VBA) to taking advantage of new XML data-sharing features, this book packs hundreds more » of timesaving programming solutions, troubleshooting tips, and handy workarounds all in concise, fast-answer format.
Discover the best and fastest ways to build custom business solutions with Excel - and challenge yourself to new levels of mastery! « less
Automate everyday administrative tasks - and take greater control of your Windows networks - with this hands-on guide to scripting. Your instructor, a Microsoft Certified Trainer with more than a decade of enterprise consulting experience, expertly builds your scripting expertise with labs and lessons more » you complete at your own pace. From writing your first scripts from scratch with Microsoft Visual Basic Scripting Edition (VBScript) and Windows Script Host (WSH) - to exploring the programmatic advantages of using Windows Management Instrumentation (WMI) and Active Directory Service Interface (ADSI) - you'll learn timesaving ways to set up, deploy, and manage your Windows-based systems. « less
For Visual Basic and VBA programmers, this book boils down the essentials of the VB and VBA languages into a single volume, including undocumented and little-documented areas essential to everyday programming. The convenient alphabetical reference to all functions, procedures, statements, and keywords more » allows programmers to use this book both as a standard reference guide and as a tool for troubleshooting and identifying programming problems. « less