• Develop tabular models for personal use
• Learn about the modeling...

As the standard for spreadsheet applications, Excel is usedworldwide - but it's not always user-friendly. However, in thehands of veteran bestselling author Greg Harvey, Excel gets a wholelot easier to understand! This handy all-in-one guide covers...

Automating computing tasks to increase productivity is a goal for businesses of all sizes. Visual Basic for Applications (VBA) is a version of Visual Basic designed to be easily understandable for novice programmers, but still powerful enough for IT professionals...

Implementing Models of Financial Derivatives is a comprehensivetreatment of advanced implementation techniques in VBA for modelsof financial derivatives. Aimed at readers who are already familiarwith the basics of VBA it emphasizes a fully object orientedapproach to valuation applications, chiefly in the context of MonteCarlo simulation but...

Advanced Penetration Testing: Hacking the World's Most Secure Networks takes hacking far beyond Kali linux and Metasploit to provide a more complex attack simulation. Featuring techniques not taught in any certification prep or covered by...

Use this guide to automate virtually any routine task: save yourself hours, days, maybe even weeks! Make Excel do things you thought were impossible, discover macro...

The ability to create and understand financial models that assess the valuation of a company, the projects it undertakes, and its future earnings/profit projections is one of the most valued skills in corporate finance. However, while many business professionals are familiar with financial statements and accounting reports, few are truly...

When I first started developing information systems at Microsoft, I often looked at Microsoft Excel and lamented that it was not packaged as a collection of reusable components that I could simply pick up and integrate into my applications. At that time, the current version of Excel had a new revolutionary user interface element called a...

Database macro programming has changed enormously over the last 15 years, having gone from Access Basic macros to VBA. Another major change occurred with Office 95, when macros went to VBA modules in a separate environment accessed via the Visual Basic Editor. It used to be fairly basic: code was entered into a special design window....