Excel VBA 24-Hour Trainer

Author: Tom Urtis

Publisher: John Wiley & Sons

ISBN: 1118991419

Category: Computers

Page: 504

View: 5668

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.
Release

Access 2010 24-Hour Trainer

Author: Geoffrey L. Griffith,Truitt L. Bradly

Publisher: John Wiley & Sons

ISBN: 0470591676

Category: Computers

Page: 480

View: 5443

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.
Release

Knight's Microsoft Business Intelligence 24-Hour Trainer

Author: Brian Knight,Devin Knight,Adam Jorgensen,Patrick LeBlanc,Mike Davis

Publisher: John Wiley & Sons

ISBN: 1118287479

Category: Computers

Page: 432

View: 5802

A book-and-video introduction to Microsoft's Business Intelligence tools If you are just starting to get a handle on Microsoft Business Intelligence (BI) tools, this book and accompanying video provides you with the just the right amount of information to perform basic business analysis and reporting. You'll explore the components and related tools that comprise the Microsoft BI toolset as well as the new BI features of Office 2010. After a basic primer on BI and data modeling, the expert team of authors provides you with step-by-step lessons in the book and videos on the accompanying DVD on how to use SQL Server Integration Services, SQL Server Analysis Services, SQL Server Reporting Services, Excel BI (including PowerPivot), and SharePoint. Integrates instructional videos with each of the lessons found in the book to enhance your learning experience Explores the Microsoft Business Intelligence (BI) toolset as well as the new BI features of Office 2010 Encourages you to practice what you've learned in "Try It Out" sections Contains video demonstrations that walk you through how to tackle each lesson featured in the book With Knight's Microsoft Business Intelligence 24-Hour Trainer, veteran authors present you with an ideal introductory book-and-video package so that you can get started working with the BI toolset immediately!/p 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.
Release

Excel VBA Programming For Dummies

Author: John Walkenbach

Publisher: John Wiley & Sons

ISBN: 1119077443

Category: Computers

Page: 408

View: 7616

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.
Release

VBA and Macros

Microsoft Excel 2010

Author: Bill Jelen,Tracy Syrstad

Publisher: Pearson Education

ISBN: 0789743140

Category: Computers

Page: 630

View: 9431

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
Release

WordPress 24-Hour Trainer

Author: George Plumley

Publisher: John Wiley & Sons

ISBN: 1118996399

Category: Computers

Page: 456

View: 9423

The easy, self-paced guide to the powerful WordPress platform WordPress 24-Hour Trainer, 3rd Edition provides a comprehensive, unique book-and-video package that focuses on the practical, everyday tasks you will face when creating and maintaining WordPress websites. This easy-to-use, friendly guide will show you how to create and edit pages, integrate your site with social media, keep your site secure, make content more search engine friendly to help drive website traffic, troubleshoot the most common WordPress issues, and much more. This updated edition of WordPress 24-Hour Trainer covers the latest features of WordPress 4.0 and 4.1 in an easy-to-use format: Fully-illustrated guides to key tasks you'll need to perform with WordPress. At the end of each lesson a list of related plugins you can install to make WordPress an even more powerful tool. Step-by-step guides at the end of lessons to help you practice what you just learned. Videos that show you first hand some of the concepts in each lesson. WordPress 24-Hour Trainer, 3rd Edition is your perfect real-world guide to fully leveraging this powerful platform.
Release

SharePoint 2010 Business Intelligence 24-Hour Trainer

Author: Adam Jorgensen,Mark Stacey,Devin Knight,Patrick LeBlanc,Brad Schacht

Publisher: John Wiley & Sons

ISBN: 9781118102015

Category: Computers

Page: 408

View: 5569

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.
Release

PHP and MySQL 24-Hour Trainer

Author: Andrea Tarr

Publisher: John Wiley & Sons

ISBN: 1118172930

Category: Computers

Page: 456

View: 3472

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.
Release

Microsoft Access VBA Programming for the Absolute Beginner

Author: Michael Vine

Publisher: Cengage Learning

ISBN: 1133788963

Category: COMPUTERS

Page: 400

View: 4522

Get the jump on computer programming and database concepts with MICROSOFT ACCESS 2010 VBA PROGRAMMING FOR THE ABSOLUTE BEGINNER, FOURTH EDITION. In this book, you'll learn the fundamental concepts of computer programming with Microsoft Access VBA, includi
Release

Ctrl+Shift+Enter Mastering Excel Array Formulas

Do the Impossible with Excel Formulas Thanks to Array Formula Magic

Author: Mike Girvin

Publisher: Tickling Keys, Inc.

ISBN: 1615473297

Category: Computers

Page: 338

View: 6866

Designed with Excel gurus in mind, this handbook outlines how to create formulas that can be used to solve everyday problems with a series of data values that standard Excel formulas cannot or would be too arduous to attempt. Beginning with an introduction to array formulas, this manual examines topics such as how they differ from ordinary formulas, the benefits and drawbacks of their use, functions that can and cannot handle array calculations, and array constants and functions. Among the practical applications surveyed include how to extract data from tables and unique lists, how to get results that match any criteria, and how to utilize various methods for unique counts. This book contains 529 screen shots.
Release

Excel Tables

A Complete Guide for Creating, Using and Automating Lists and Tables

Author: Zack Barresse,Kevin Jones

Publisher: Tickling Keys, Inc.

ISBN: 1615473408

Category: Computers

Page: 300

View: 3062

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.
Release

STEPHENS' C# PROGRAMMING WITH VISUAL STUDIO 2010 : 24-HOUR TRAINER (With CD )

Author: Rod Stephens

Publisher: N.A

ISBN: 9788126526727

Category:

Page: 552

View: 6906

Market_Desc: Novice programmers; no previous programming experience required. Special Features: " Rod Stephens is a well-known authority on Microsoft programming--his Visual Basic Programmer's Reference has sold more than 23,000 copies in two editions. " Unique Book/Video Package: Each lesson in the print product is supplemented by an instructional video, included on the accompanying DVD." Perfect for beginners: no previous programming experience is required." Fully covers the latest release of Visual C#." The author will create a new online C# community, called CSharpHelper, patterned after his successfull VBHelper website. About The Book: This book is a self-paced guide to C# programming in the Visual Studio environment. Easy-to-follow lessons, reinforced by step-by-step instructions, screencasts, and supplemental exercises, allow readers of all learning styles to master Visual C# programming quickly and painlessly. The book's scope is limited to an introduction to Visual C# programming. It starts from scratch, assuming the reader has little or no programming experience, and provides an introduction to Visual C# programming and to Visual Studio.The book is divided into lessons that begin with a discussion of a particular concept or technique. After describing the main concept, the lesson includes a Try It section that invites the reader to perform a programming exercise to solidify the lesson's ideas.The Try It has several subsections. Goals describes the exercise so the reader knows what should happen. Hints gives pointers about possible confusing aspects of the problem if they are needed. Step-by-Step provides a numbered series of steps that show how to solve the problem.A screencast on the accompanying DVD shows the author working through the Try It problem. Additional commentary at the end of the screencast highlights extensions of the lesson's main concepts.After the Try It's Step-by-Step section, the text concludes with a series of exercises that the reader can solve for further practice and to expand the lesson's main ideas.
Release

Microsoft Office Excel 2007 Visual Basic for Applications Step by Step

Author: Reed Jacobson

Publisher: Pearson Education

ISBN: 0735642575

Category: Computers

Page: 384

View: 2781

Quickly teach yourself how to automate tasks and create custom spreadsheet solutions with Excel 2007 Visual Basic for Applications (VBA). With Step By Step, you set the pace—building and practicing the skills you need, just when you need them! Create macros to automate repetitive tasks Automatically format charts, shapes, and text Manipulate tables and other objects—even build PivotTable reports Write your own functions and procedures Use loops and conditions to add decision logic to macros Build custom command buttons, dialog boxes, and user forms Your all-in-one learning experience includes: Files for building skills and practicing the book’s lessons Fully searchable eBook Windows Vista Product Guide eReference—plus other resources on CD For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.
Release

Writing Excel Macros with VBA

Author: Steven Roman,Steven PhD

Publisher: "O'Reilly Media, Inc."

ISBN: 0596003595

Category: Computers

Page: 549

View: 8456

Offering a solid introduction to writing VBA macros and programs in Excel, this guide shows readers how to get more power out of Excel at the programming level.
Release

Excel Power Pivot and Power Query For Dummies

Author: Michael Alexander

Publisher: John Wiley & Sons

ISBN: 1119210666

Category: Computers

Page: 288

View: 1041

A guide to PowerPivot and Power Query no data cruncher should be without! Want to familiarize yourself with the rich set of Microsoft Excel tools and reporting capabilities available from PowerPivot and Power Query? Look no further! Excel PowerPivot & Power Query For Dummies shows you how this powerful new set of tools can be leveraged to more effectively source and incorporate 'big data' Business Intelligence and Dashboard reports. You'll discover how PowerPivot and Power Query not only allow you to save time and simplify your processes, but also enable you to substantially enhance your data analysis and reporting capabilities. Gone are the days of relatively small amounts of data—today's data environment demands more from business analysts than ever before. Now, with the help of this friendly, hands-on guide, you'll learn to use PowerPivot and Power Query to expand your skill-set from the one-dimensional spreadsheet to new territories, like relational databases, data integration, and multi-dimensional reporting. Demonstrates how Power Query is used to discover, connect to, and import your data Shows you how to use PowerPivot to model data once it's been imported Offers guidance on using these tools to make analyzing data easier Written by a Microsoft MVP in the lighthearted, fun style you've come to expect from the For Dummies brand If you spend your days analyzing data, Excel PowerPivot & Power Query For Dummies will get you up and running with the rich set of Excel tools and reporting capabilities that will make your life—and work—easier.
Release

Microsoft Excel VBA Programming for the Absolute Beginner

Author: Duane Birnbaum,Michael A. Vine

Publisher: Cengage Learning

ISBN: 1598637630

Category: Computers

Page: 544

View: 6048

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
Release

Access 2010 Programmer's Reference

Author: Teresa Hennig,Rob Cooper,Geoffrey L. Griffith,Jerry Dennison

Publisher: John Wiley & Sons

ISBN: 9780470938966

Category: Computers

Page: 1272

View: 4738

A comprehensive guide to programming for Access 2010 and 2007 Millions of people use the Access database applications, and hundreds of thousands of developers work with Access daily. Access 2010 brings better integration with SQL Server and enhanced XML support; this Wrox guide shows developers how to take advantage of these and other improvements. With in-depth coverage of VBA, macros, and other programming methods for building Access applications, this book also provides real-world code examples to demonstrate each topic. Access 2010 Programmer's Referenceis a comprehensive guide to the best-of-breed techniques for programming Access applications. Coverage Includes: Introduction to Microsoft Access 2010 New Features Upgrading and Converting to Access 2010 Macros in Access 2010 Using the VBA Editor VBA Basics Using VBA in Access Creating Classes in VBA Extending VBA with APIs Working with the Windows Registry Using DAO to Access Data Using ADO to Access Data Using SQL with VBA Using VBA to Enhance Forms Enhancing Reports with VBA Customizing the Ribbon Customizing the Office Backstage Working with Office 2010 Working with SharePoint Working with .NET Building Client-Server Applications with Access The Access 2010 Templates Access Runtime Deployment Database Security Access 2010 Security Features
Release