âAs Excel applications become more complex and the Windows development platform more powerful, Excel developers need books like this to help them evolve their solutions to the next level of sophistication. Professional Excel Development is a book for developers who want to build powerful, state-of-the-art Excel applications using the latest Microsoft technologies.â
âGabhan Berry, Program Manager, Excel Programmability, Microsoft
âThe first edition of Professional Excel Development is my most-consulted and most-recommended book on Office development. The second edition expands both the depth and range. It shines because it takes every issue one step further than you expect. The book relies on the authorsâ current, real-world experience to cover not only how a feature works, but also the practical implications of using it in professional work.â
âShauna Kelly, Director, Thendara Green
âThis book illustrates techniques that will result in well-designed, robust, and maintainable Excel-based applications. The authorsâ advice comes from decades of solid experience of designing and building applications. The practicality of the methods is well illustrated by the example timesheet application that is developed step-by-step through the book. Every serious Excel developer should read this and learn from it. I did.â
â Bill Manville, Application Developer, Bill Manville Associates
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 build more effective, successful solutions.
Fully updated for Excel 2007, this book starts where other books on Excel programming leave off. Through a hands-on case study project, youâll discover best practices for planning, architecting, and building Excel applications that are robust, secure, easy to maintain, and highly usable. If youâre a working developer, no other book on Excel programming offers you this much depth, insight, or value.
â¢ Â Â Design worksheets that will be more useful and reliable
â¢ Â Â Leverage built-in and application-specific add-ins
â¢ Â Â Construct applications that behave like independent Windows programs
â¢ Â Â Make the most of the new Ribbon user interface
â¢ Â Â Create cross-version applications that work with legacy versions of Excel
â¢ Â Â Utilize XML within Excel applications
â¢ Â Â Understand and use Windows API calls
â¢ Â Â Master VBA error handling, debugging, and performance optimization
â¢ Â Â Develop applications based on data stored in Access, SQL Server, and other databases
â¢ Â Â Build powerful visualization solutions with Excel charting engine
â¢ Â Â Learn how to work with VB.NET and leverage its IDE
â¢ Â Â Automate Microsoft Excel with VB.NET
â¢ Â Â Create managed COM add-ins for Microsoft Excel with VB.NET
â¢ Â Â Develop Excel solutions with Visual Studio Tools for Office (VSTO)
â¢ Â Â Integrate Excel with Web Services
â¢ Â Â Deploy applications more securely and efficiently
Node.js, MongoDB and Angular Web Development
The definitive guide to using the MEAN stack to build web applications
Updated for Angular 2, Angular 4, and subsequent versions, this new edition of Node.js, MongoDB and Angular Web Development shows you how to integrate these three technologies into complete working solutions. It begins with concise, crystal-clear tutorials on each technology and then quickly moves on to building common web applications.
Youâll learn how to use Node.js and MongoDB to build more scalable, high-performance sites, how to leverage Angularâs innovative MVC approach to structure more effective pages and applications, and how to use all three together to deliver outstanding next-generation Web solutions.
Part I: Getting Started
1 Introducing the Node.js-to-Angular Stack
Part II: Learning Node.js
3 Getting Started with Node.js
4 Using Events, Listeners, Timers, and Callbacks in Node.js
5 Handling Data I/O in Node.js
6 Accessing the File System from Node.js
7 Implementing HTTP Services in Node.js
8 Implementing Socket Services in Node.js
9 Scaling Applications Using Multiple Processors in Node.js
10 Using Additional Node.js Modules
Part III: Learning MongoDB
11 Understanding NoSQL and MongoDB
12 Getting Started with MongoDB
13 Getting Started with MongoDB and Node.js
14 Manipulating MongoDB Documents from Node.js
15 Accessing MongoDB from Node.js
16 Using Mongoose for Structured Schema and Validation
17 Advanced MongoDB Concepts
Part IV: Using Express to Make Life Easier
18 Implementing Express in Node.js
19 Implementing Express Middleware
Part V: Learning Angular
20 Jumping into TypeScript
21 Getting Started with Angular
22 Angular Components
24 Data Binding
25 Built-in Directives
Part VI: Advanced Angular
26 Custom Directives
27 Events and Change Detection
28 Implementing Angular Services in Web Applications
29 Creating Your Own Custom Angular Services
30 Having Fun with Angular
Android is the fastest growing operating system (OS) with one of the largest installed bases of any mobile OS. Android uses one of the most popular programming languages, Java, as the primary language for building apps of all types. So, you should first obtain a solid grasp of the Java language and its foundation APIs to improve the chances of succeeding as an Android app developer.
This book will show you how to get your Android development environment set up and you will soon have your first working game. The difficulty level grows steadily with the introduction of key Java topics such as loops, methods, and OOP. You'll then use them in the development of games. You will learn how to build a math test game, a Simon-like memory game, a retro pong-style game, and for the grand finale, a Snake-style, retro arcade game with real Google Play leaderboards and achievements. The book has a hands-on approach and is packed with screenshots.
John Horton is a technology enthusiast based in UK. When he is not writing apps, books, or blog articles for Game Code School, he can usually be found playing computer games or indulging in a Nerf war.
ServiceNow provides service management for every department in the enterprise, including IT, Human Resources, Facilities, Field Service, and more.
This book focuses on all the steps required to develop apps and workflows for any of your business requirements using ServiceNow. You will start with the first module, which covers the basics of ServiceNow and how applications are structured; how you can customize the dashboard as required; and also how to create users. After you get used to the dashboard, you will move on to the next module, Applications and Tables, where you will learn about working with different tables and how you can create a scope other than the global scope for your application. The next module is Scripting and APIs, where you will learn Scripting in ServiceNow and use powerful APIs to develop applications. The final module, Administration Essentials, covers debugging, advanced database features, and scheduled script creation.
By the end of the book you will have mastered creating organized and customer-friendly applications
Mushroom Biotechnology: Developments and Applications is a comprehensive book to provide a better understanding of the main interactions between biological, chemical and physical factors directly involved in biotechnological procedures of using mushrooms as bioremediation tools, high nutritive food sources, and as biological helpers in healing serious diseases of the human body.
The book points out the latest research results and original approaches to the use of edible and medicinal mushrooms as efficient bio-instruments to reduce the environment and food crises. This is a valuable scientific resource to any researcher, professional, and student interested in the fields of mushroom biotechnology, bioengineering, bioremediation, biochemistry, eco-toxicology, environmental engineering, food engineering, mycology, pharmacists, and more.
Android is a powerful, flexible, open source platform for mobile devices and its popularity is growing at an unprecedented pace. This update to the bestselling first edition dives in to cover the exciting new features of the latest release of the Android mobile platform.
Providing in-depth coverage of how to build mobile applications using the next major release of the Android SDK, this invaluable resource takes a hands-on approach to discussing Android with a series of projects, each of which introduces a new feature and highlights techniques and best practices to get the most out of Android.
Providing concise and compelling examples, Professional Android Application Development is an updated guide aimed at helping you create mobile applications for mobile devices running the latest version of Android.
Prepare for the Pivotal Certified Spring Web Application Developer exam and learn about Spring MVC DispatcherServlet configuration, Spring MVC programming model essentials, Spring MVC views and form processing, Spring Web Flow essentials, and Spring Web Flow actions and configuration. The Pivotal Certified Spring Web Application Developer Exam: A Study Guide is the ideal preparation for the exam and after reading and using it, you'll be able to pass and become a certified Spring Web Developer.
When you become a Pivotal Certified Spring Web Application Developer, you'll receive one of the most valuable credentials available in enterprise Java. Achieving this certification demonstrates your ability to apply Spring's web projects to develop real-world Java web applications and validates your familiarity with Spring Web.
Manage research, learning and skills at IT1me. Create an account using LinkedIn to manage and organize your IT knowledge. IT1me works like a shopping cart for information -- helping you to save, discuss and share.