Excel 2019 Power Programming with VBA
by Michael Alexander, Dick Kusleika
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 l...
Price: $35.49 | Publisher: Wiley | Release: 2019
Microsoft Excel 2019 Pivot Table Data Crunching
by Bill Jelen, Michael Alexander
Renowned Excel experts Bill Jelen (MrExcel) and Michael Alexander help you crunch data from any source with Excel 2019 pivot tables. Use Excel 2019 pivot tables and pivot charts to produce powerful, dynamic reports in minutes instead of hours, to take control of your data and your business. Even if you've never created a pivot table before, this book will help you leverage all their remarkable flexibility a...
Price: $26.13 | Publisher: Microsoft Press | Release: 2019
Microsoft Excel 2019 VBA and Macros
by Bill Jelen, Tracy Syrstad
Renowned Excel experts Bill Jelen (MrExcel) and Tracy Syrstad explain how to build more powerful, reliable, and efficient Excel spreadsheets.Use this guide to automate virtually any routine Excel task: save yourself hours, days, maybe even weeks. Make Excel do things you thought were impossible, discover macro techniques you won't find anywhere else, and create automated reports that are amazingly powerful....
Price: $25.19 | Publisher: Microsoft Press | Release: 2018
Microsoft Excel 2019 Inside Out
by Bill Jelen
Dive into Microsoft Excel 2019 - and really put your spreadsheet expertise to work. This supremely organized reference packs hundreds of timesaving solutions, tips, and workarounds - all you need to make the most of Excel's most powerful tools for analyzing data and making better decisions. Renowned Excel expert Bill Jelen offers a complete tour of Excel 2019 and Excel in Office 365, from efficient interfac...
Price: $35.45 | Publisher: Microsoft Press | Release: 2018
Windows PowerShell in Action, 3rd Edition
by Bruce Payette, Richard Siddaway
In 2006, Windows PowerShell reinvented the way administrators and developers interact with Windows. Today, PowerShell is required knowledge for Windows admins and devs. This powerful, dynamic language provides command-line control of the Windows OS and most Windows servers, such as Exchange and SCCM. And because it's a first-class .NET language, you can build amazing shell scripts and tools without reaching...
Price: $31.03 | Publisher: Manning | Release: 2017
by Bruce Mcpherson
Whether you're moving from Microsoft Office to Google Docs or simply want to learn how to automate Docs with Google Apps Script, this practical guide shows you by example how to work with each of the major Apps Script services.Office still supports VBA, but it's not likely to do so for much longer. If you're a VBA or .NET developer, you'll learn how to port existing VBA code and structure to their JavaScrip...
Price: $29.99 | Publisher: O'Reilly Media | Release: 2016
How to Implement Market Models Using VBA
by Francois Goossens
How to Implement Market Models Using VBA makes solving complex valuation issues accessible to any financial professional with a taste for mathematics. With a focus on the clarity of code, this practical introductory guide includes chapters on VBA fundamentals and essential mathematical techniques, helping readers master the numerical methods to build an algorithm that can be used in a wide range of pricing ...
Price: $62.57 | Publisher: Wiley | Release: 2015
Excel VBA 24-Hour Trainer, 2nd Edition
by Tom Urtis
Excel VBA 24-Hour Trainer, 2nd Edition is the quick-start guide to getting more out of Excel, using Visual Basic for Applications. This unique book/video package has been updated with fifteen new advanced video lessons, providing a total of eleven hours of video training and 45 total lessons to teach you the basics and beyond. This self-paced tutorial explains Excel VBA from the ground up, demonstrating wit...
Price: $27.46 | Publisher: Wrox | Release: 2015
Extending SSIS with .NET Scripting
by Joost van Rossum, Regis Baccaro
Extending SSIS with .NET Scripting is a timeless and comprehensive scripting toolkit for SQL Server Integration Services to solve a wide array of everyday problems that SSIS developers encounter. The detailed explanation of the Script Task and Script Component foundations helps you develop your own scripting solutions, but this book also shows a broad arsenal of readymade and well-documented scripting solut...
Price: $47.88 | Publisher: Apress | Release: 2015
Code-First Development with Entity Framework
by Sergey Barskiy
Entity Framework Code-First enables developers to read and write data in a relational database system using C# or VB.NET. It is Microsoft's answer to demand for an ORM from .NET developers.This book will help you acquire the necessary skills to program your applications using Entity Framework. You will start with database configuration and learn how to write classes that define the database structure. You w...
Price: $19.99 | Publisher: Packt Publishing | Release: 2015