Excel VBA 24 Hour Trainer

Author: Tom Urtis
Publisher: John Wiley & Sons
ISBN: 9781118991411
Release Date: 2015-03-12
Genre: Computers

Master VBA automation quickly and easily to get more out of Excel 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 with each advancing lesson how you can increase your productivity. Clear, concise, step-by-step instructions are combined with illustrations, code examples, and downloadable workbooks to give you a practical, in-depth learning experience and results that apply to real-world scenarios. This is your comprehensive guide to becoming a true Excel power user, with multimedia instruction and plenty of hands-on practice. Program Excel's newest chart and pivot table object models Manipulate the user interface to customize the look and feel of a project Utilize message boxes, input boxes, and loops to yield customized logical results Interact with and manipulate Word, Access, PowerPoint, and Outlook from Excel If you're ready to get more out of this incredibly functional program, Excel VBA 24-Hour Trainer, 2nd Edition provides the expert instruction and fast, hands-on learning you need.

Access 2010 24 Hour Trainer

Author: Geoffrey L. Griffith
Publisher: John Wiley & Sons
ISBN: 9780470591673
Release Date: 2010-11-01
Genre: Computers

This book-and-video package is the perfect introduction to Access 2010 Microsoft's popular Access database is the most popular database system in the world, and even if you have no database experience, this practical guide will soon have you getting the most out of the powerful new 2010 version. Step-by-step tutorials guide you through concepts and techniques at your own pace. Each lesson is followed by a Try It section, where you can practice what you’re learning with exercises. The accompanying DVD provides clear, easy-to-follow videos of the author demonstrating each Try It problem, as well as extra commentary. Fully covers the new 2010 release of Microsoft Access Brings beginners thoroughly up to speed at their own pace Introduces exciting new Access 2010 features, such as creating Web forms to connect with SharePoint Helps users leverage macros and templates to streamline and customize projects If you want to get quickly up to speed on Access 2010, Access 2010 24-Hour Trainer is the perfect place to start.

HTML5 JavaScript and jQuery 24 Hour Trainer

Author: Dane Cameron
Publisher: John Wiley & Sons
ISBN: 9781119001188
Release Date: 2015-02-10
Genre: Computers

Master web app development with hands-on practice and video demonstration HTML5, JavaScript, and jQuery 24-Hour Trainer shows you how to build real-world HTML5 apps — both web-based and mobile — in combination with JavaScript, jQuery, and CSS/CSS3. You'll learn progressively more advanced skills as you work through the series of hands-on video lessons. Exercises and screencasts walk you step-by-step through the process of building web applications, and give you the opportunity to experiment and extend the examples to create your own working web app. You'll gain a solid understanding of the fundamental technologies, and develop a skillset that fully exploits the functionality of web development tools. Although HTML5 is at the forefront of web development, it exists within an ecosystem that also includes CSS/CSS3, JavaScript, and JavaScript libraries like jQuery. Building robust, functional web applications requires a clear understanding of these technologies, and more importantly, the manner in which they fit together. This is your step-by-step guide to building web apps, with a hands-on approach that helps you learn by doing. Master the fundamentals of HTML and HTML5 Explore multimedia capabilities and CSS3 Integrate offline data storage, background processes, and other APIs Adapt web applications for mobile phones and tablets Whether you're looking for a quick refresher or a first-time lesson, HTML5, JavaScript, and jQuery 24-Hour Trainer will quickly get you up to speed.

PHP and MySQL 24 Hour Trainer

Author: Andrea Tarr
Publisher: John Wiley & Sons
ISBN: 9781118172933
Release Date: 2011-10-07
Genre: Computers

Step-by-step lessons for using PHP and MySQL in a unique book-and-video combination Assuming no previous experience with PHP or MySQL, this book-and-video package is ideal reading for anyone who wants to go beyond HTML/CSS in order to provide clients with the most dynamic web sites possible. The approachable tone breaks down the basics of programming and PHP and MySQL in individual lessons starting with the installation of the programs necessary to run PHP. You begin with a static web site and then watch and learn as PHP functionality is added as you work through the lessons. When working with databases, the MySQL database is introduced with demonstrations that show how to interact with it. The accompanying videos enhance your learning experience, as each lesson in the book is portrayed in the video exercises. Lessons include: ? Getting started with PHP ? Setting up your workspace ? Adding PHP to a web page ? Learning PHP syntax ? Working with variables ? Debugging code ? Working with complex data ? Making decisions ? Repeating program steps ? Learning about scope ? Reusing code with functions ? Creating forms ? Introducing object-oriented programming ? Defining classes ? Using classes ? Using advanced techniques ? Handling errors ? Writing secure code ? Introducing databases ? Introducing MySQL ? Creating and connecting to the ? Creating tables ? Entering data ? Selecting data ? Using multiple tables ? Changing data ? Deleting data ? Preventing database security issues ? Creating user logins ? Turn the case study into a content management system Note: As part of the print version of this title, video lessons are included on DVD. For e-book versions, video lessons can be accessed at wrox.com using a link provided in the interior of the e-book.

Microsoft Excel VBA Programming for the Absolute Beginner

Author: Duane Birnbaum
Publisher: Cengage Learning
ISBN: 9781598637632
Release Date: 2007-01-01
Genre: Computers

If you are new to programming with Microsoft Excel VBA and are looking for a solid introduction, this is the book for you. Developed by computer science professors, books in the "for the absolute beginner" series teach the principles of programming throug

SharePoint 2010 Business Intelligence 24 Hour Trainer

Author: Adam Jorgensen
Publisher: John Wiley & Sons
ISBN: 1118102010
Release Date: 2011-12-05
Genre: Computers

Learn to build and deliver SharePoint BI applications Written by a team of leading SharePoint and Business Intelligence (BI) experts, this unique book-and-DVD package shows you how to successfully build and deliver BI applications using SharePoint 2010. Assuming no previous SharePoint experience, the authors deliver a clear explanation of what SharePoint will do for your BI and information management capabilities. Each lesson in the book is reinforced with a helpful tutorial on the DVD and cover topics such as interactive reporting with Excel, document sharing for collaborative reporting, and controlling data sources. As you learn best practices for configuring and securing SharePoint 2010 BI applications and planning and implementing your SharePoint BI project plan, you'll be well on your way to gaining a solid foundation of understanding and working with SharePoint 2010 and BI. Provides an invaluable training book-and-DVD package that takes you through building and delivering BI applications using SharePoint 2010 Features an accompanying video tutorial for each lesson covered in the book, along with a "Try It" section at the end of each lesson Covers interactive reporting with excel Covers Power Pivot advanced analytics Details report and document sharing for collaborative reporting Shows how to use SharePoint lists and libraries for data sources repositories in your BI projects Explains how to control data sources, reports and business intelligence content with permissions and workflow approvals. With this unique book-and-DVD combo, you'll be well on your way to successfully building and delivering BI applications using SharePoint 2010. Note: As part of the print version of this title, video lessons are included on DVD. For e-book versions, video lessons can be accessed at wrox.com using a link provided in the interior of the e-book.

WordPress 24 Hour Trainer

Author: George Plumley
Publisher: John Wiley & Sons
ISBN: 9781118152966
Release Date: 2011-10-13
Genre: Computers

The eagerly anticipated second edition, completely updated for WordPress 3.1 As an open source content management system, WordPress allows users to easily build feature-rich web sites with no programming experience. This unique book-and-video package is a friendly, self-paced beginners guide to the latest release of WordPress. Lessons are focused on practical, everyday tasks that users will need to create and maintain their sites: entering new content, creating new pages, managing menus, making content search-engine friendly. Plus you'll find lots of tips based on years of experience teaching people to use WordPress. You'll also learn how to extend the functionality of WordPress by using the thousands of plugins available. Connecting to social media, creating membership and e-commerce sites, setting up events calendars, making your site mobile-friendly—these are just some of the plugins you'll be introduced to. Each lesson in the book is supplemented by an instructional video intended to enhance your learning experience. Plus, a trouble-shooting appendix addresses various issues to help you solve any challenges you may face. Note: As part of the print version of this title, video lessons are included on DVD. For e-book versions, video lessons can be accessed at wrox.com using a link provided in the interior of the e-book.

Excel Tables

Author: Zack Barresse
Publisher: Tickling Keys, Inc.
ISBN: 9781615473403
Release Date: 2014-08-01
Genre: Computers

Creating tables in Excel allows for easier formatting and reporting, but the new syntax that it implies can be intimidating to the uninitiated. In this guide, one of the developers of the official Microsoft Excel 2013 templates—all of which employ tables—helps introduce readers to the multiple benefits of tables. The book begins by explaining what tables are, how to create them, and how they can be used in reporting before moving on to slightly more advanced topics, including slicers and filtering, working with VBA macros, and using tables in the Excel web app. Novice Excel users and experts alike will find relevant, useful, and authoritative information in this one-of-a-kind resource.

Java Programming 24 Hour Trainer

Author: Yakov Fain
Publisher: John Wiley & Sons
ISBN: 9781118951460
Release Date: 2015-04-28
Genre: Computers

Quick and painless Java programming with expert multimedia instruction Java Programming 24-Hour Trainer, 2nd Edition is your complete beginner's guide to the Java programming language, with easy-to-follow lessons and supplemental exercises that help you get up and running quickly. Step-by-step instruction walks you through the basics of object-oriented programming, syntax, interfaces, and more, before building upon your skills to develop games, web apps, networks, and automations. This second edition has been updated to align with Java SE 8 and Java EE 7, and includes new information on GUI basics, lambda expressions, streaming API, WebSockets, and Gradle. Even if you have no programming experience at all, the more than six hours of Java programming screencasts will demonstrate major concepts and procedures in a way that facilitates learning and promotes a better understanding of the development process. This is your quick and painless guide to mastering Java, whether you're starting from scratch or just looking to expand your skill set. Master the building blocks that go into any Java project Make writing code easier with the Eclipse tools Learn to connect Java applications to databases Design and build graphical user interfaces and web applications Learn to develop GUIs with JavaFX If you want to start programming quickly, Java Programming 24-Hour Trainer, 2nd Edition is your ideal solution.

VBA and Macros

Author: Bill Jelen
Publisher: Pearson Education
ISBN: 9780789743145
Release Date: 2010
Genre: Computers

Use Excel 2010 VBA and macros to automate virtually any routine task, and save yourself hours, days, maybe even weeks. Then learn how to make Excel do things you thought were simply impossible! This book reveals scripting techniques you won't find anywhere else and shows you how to create automated reports that are amazingly powerful and useful. It helps you instantly visualize information so you can understand and act on it. It also shows you how to capture data from anywhere and use it anywhere, and helps you automate Excel 2010's most powerful new features Learning advanced Excel scripting has never been easier You'll find simple, step-by-step instructions, real-world examples and case studies, and 50 workbooks packed with bonus examples, macros, and solutions, straight from MrExcel. About MrExcel Library: Every book in the MrExcel Library pinpoints a specific set of crucial Excel tasks and presents focused skills and examples for performing them rapidly and effectively. Selected by Bill Jelen, Microsoft Excel MVP and mastermind behind the leading Excel solutions website MrExcel.com, these books will

Excel VBA Programming For Dummies

Author: John Walkenbach
Publisher: John Wiley & Sons
ISBN: 9781119077442
Release Date: 2015-09-28
Genre: Computers

Take your data analysis and Excel programming skills to new heights In order to take Excel to the next level, you need to understand and implement the power of Visual Basic for Applications (VBA). This 4th edition of Excel VBA Programming For Dummies introduces you to a wide array of new Excel options, beginning with the most important tools and operations for the Visual Basic Editor. Inside, you'll get the lowdown on the essential elements and concepts for programming with Excel, discover techniques for handling errors and exterminating bugs, working with range objects, controlling program flow, and much more. With the release of Microsoft Office 2016, Excel will see changes in its operating system, and this fun, hands-on guide will make it easier than ever to harness the power of Visual Basic for Applications and create custom applications and macros on the world's most popular spreadsheet tool. Packed with friendly advice on the easiest ways to develop custom dialog boxes, toolbars, and menus, you'll be creating Excel applications custom-fit to your unique needs in no time at all! Provides step-by-step instructions for creating VBA macros to maximize productivity Helps to increase efficiency by demonstrating how to customize your applications so they look and work the way you want Fully updated for Excel 2016 All sample programs, VBA code, and worksheets are available at dummies.com If you're a beginning to intermediate VBA programmer looking to get up to speed on creating customized solutions with Excel applications, Excel VBA Programming For Dummies, 4th Edition makes it easier.

VBA For Excel

Author: Hirdesh Bhardwaj
Publisher: Educreation Publishing
ISBN:
Release Date: 2016-11-17
Genre: Education

VBA enables you to automate various activities in Excel like generating reports, preparing charts & graphs, doing calculations, etc. This automation activity is also often referred as Macro. VBA help in Automate a procedure that you do frequently in Excel.

Excel 2016 VBA and Macros includes Content Update Program

Author: Bill Jelen
Publisher: Que Publishing
ISBN: 9780134386034
Release Date: 2015-11-03
Genre: Computers

MASTER CORE EXCEL 2016 TOOLS FOR BUILDING POWERFUL, RELIABLE SPREADSHEETS! 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 techniques you won’t find anywhere else, and create automated reports that are amazingly powerful. Bill Jelen and Tracy Syrstad help you instantly visualize information, so you can act on it… capture data from anywhere, and use it anywhere… automate Excel 2016’s best new features. You’ll find simple, step-by-step instructions, real-world case studies, and 50 workbooks packed with bonus examples, macros, and solutions–straight from MrExcel! Get started fast with Excel macro development Work efficiently with ranges, cells, and formulas Build super-fast applications with arrays Automate Excel’s new pivot table enhancements Collect user data with custom dialogs Make your macros more reliable and resilient Pull data from the Internet with web queries Use advanced classes, collections, and custom functions Build sophisticated business analysis solutions Read and write to Access or SQL Server databases Control other Office programs, and Windows itself Write code that also works on older Excel versions Start writing Office Store-style Excel Apps About MrExcel Library Every book in the MrExcel Library pinpoints a specific set of crucial Excel tasks and presents focused skills and examples for performing them rapidly and effectively. Selected by Bill Jelen, Microsoft Excel MVP and mastermind behind the leading Excel solutions website MrExcel.com, these books will Dramatically increase your productivity–saving you 50 hours a year or more Present proven, creative strategies for solving real-world problems Show you how to get great results, no matter how much data you have Help you avoid critical mistakes that even experienced users make This book is part of Que’s Content Update Program. As Microsoft updates features of Excel, sections of this book will be updated or new sections will be added to match the updates to the software. See inside for details.