Visual Basic for Applications (VBA) is a set of tools based on the Visual Basic language. The great thing about using it to enhance Office applications is that it's easier to learn than Visual Basic and it comes with your Office license. After reading this book, the reader will be proficient in the VBA language and will have extensive knowledge of the Office 2003 Object Model. This book will cover all features of the VBA editor and show how to program some of the more useful new features in the Office 2003 applications.

This book assumes no prior programming experience, so even programming novices can get up to speed quickly on the basics of the VBA language. It is very practical and offers the reader tested programs and projects that he or she can implement right away. This book reinforces the reader's learning by presenting useful, end-of-chapter pedagogical resources, including question-and-answer sessions and quizzes, as well as practical exercises that cement and extend the reader's knowledge. It explorers not only the object models of Word and Excel, but also other members of the Office 2003 suite, including PowerPoint, Access, and Outlook.

Spin your own web! Free CD-ROM included. More people are overcoming their digital fears and producing Internet content rather than just absorbing it. Whether their product is a collection of essays, stories, reviews, jokes, or shopping lists, they want to share it with everyone-from family and friends to strangers across the globe. How do they do it? By starting right here. The Complete Idiot's Guide® to Creating a Web Page and Blog-the only book of its kind- will help anyone build and maintain an Internet website or blog. Coverage includes:
*Step-by-step instructions for building a site from the ground up
*Important HTML tags
*Tips on using fonts, colors, and images
*Incorporating tables, forms, style sheets, and JavaScripts
*The new blog technology
*Plus! A "Webmaster's Toolkit" on a companion CD-ROM, providing files used in this book.

Increase your iPad IQ with this genius-level guide to the Apple iPad

If you want to squeeze every last bit of incredible from your Apple iPad we've got you covered with this newly revised iPad Portable Genius. Want to learn how to connect to a network? How to configure your tablet? How to surf the web more comfortably? All while keeping your identity and accounts private and secure?

With the iPad Portable Genius as your guide, you'll unlock the full potential of your iPad in no time at all. You'll learn how to:

• Get the most out of sending and receiving your email
• Have fun with your images and take crystal-clear photos every time
• Shoot and edit video right on your iPad
• Manage your busy schedule with calendars

Perfect for anyone looking to save time and reveal the true power and flexibility of their iPad, the iPad Portable Genius, Fourth Edition contains all the new, engaging, and extensively illustrated info you need to master your tablet.

If you're always hearing about the cool things that Excel can do, here's your chance to see how to do them! With pages of full-color, step-by-step instructions and crystal-clear screen shots, this guide shows you how to get the most out of Excel 2010. The book covers all the basics as well as Excel 2010's new features and functions, including a new interface and better collaboration tools. Crunch and chart your data over a network, over the Web, or at home-helpful tips on every page will get you there even faster!

• Provides a clear look at Excel 2010, the newest version of the world's leading spreadsheet application from Microsoft, and part of the new Microsoft Office 2010 suite
• Demonstrates how to create spreadsheets and charts, filter and sort data, work with PivotTable, and present your data-on a network, on the Web, or on your laptop
• Explores all features and functions in full-color pages packed with screen shots and other visual graphics that clearly show you how to accomplish tasks
• Includes practical examples, tips, and advice on how to use all the tools more effectively

Get the very most out of Excel 2010 with this easy-to-follow guide!

The easy, visual way to learn this popular database program

Part of the Office 2013 productivity suite, Access enables you to organize, present, analyze, and share data on a network or over the web. With this Visual guide to show you how, you'll master the fundamentals of this robust database application in no time. Clear, step-by-step instructions are illustrated with full-color screen shots that show exactly what you should see on your screen. Learn to enter new records; create, edit, and design tables and forms; develop queries that generate specific reports; add smart tags to your tables; and much more.

• While it is the most widely used database application, Access is not particularly intuitive; the Visual system's two-page lessons and full-color screen shots make this complex software easier to learn
• Concise, step-by-step instructions and clear illustrations show you exactly what to expect
• Covers scores of tasks, including entering and setting up new records, organizing and sharing data, designing tables and forms, and generating reports
• Shows how to perform more complex operations, such as finding dependencies between database objects and adding smart tags to tables

Teach Yourself VISUALLY Access 2013 uses clear steps and high-resolution screen images to get you up and running with this popular database program.

Take a guided tour of macOS High Sierra and discover just how much your Mac can do

Teach Yourself VISUALLY macOS High Sierra is the perfect introduction to Apple's operating system. With clear, step-by-step instructions and plenty of rich visuals, it walks you through the new macOS High Sierra and demonstrates the essential tasks you need to know. You'll learn how to manipulate Preferences to customize your experience, make the most of your digital media, and streamline your workflow while having a little fun. You'll tour Photos, Messages, and Notifications, and get acquainted with Mission Control, the App Store, and Siri. New Mac users will appreciate the straightforward instruction, while veteran users will enjoy getting up to speed on the latest features introduced or upgraded in macOS High Sierra. 
 
 macOS High Sierra is the latest incarnation of Apple's macOS, boasting elegant new visuals, several new features, and more seamless integration of Mac and iOS devices. If you use a Mac, you're going to want a guided tour that shows you just what macOS can do for you. Teach Yourself VISUALLY macOS High Sierra is your go-to guide, from the fundamentals to the neat little tricks that make the Mac experience something far beyond computing.

 •   Edit and enhance photos with the powerful new tools on the Photos app

•    Browse the web safely with Safari's new privacy features  

•    Share files quickly and easily using iCloud Drive

•    Use Siri to accomplish more in less time

   
Like any computer, your Mac is a tool. And like any tool, the more you know about it, the more you get out of it. Discover the beauty, simplicity, and sheer functionality that millions already enjoy—and get ready to master your Mac with Teach Yourself VISUALLY macOS High Sierra.

As easy and intuitive as the iPhone is, it's more complex than most of us realize—and what's better than learning all the insider tips and tricks with the iPhone Portable Genius, 3^rd Edition? Whether you're just starting out with your first iPhone or upgrading to a newer model, this full-color guide will have you tapping, swiping, and typing like an Apple genius in no time. You'll find essential information about iOS, Siri, iCloud, and how to use your phone to manage, organize, and navigate your life.

Written in clear, no-nonsense language, iPhone Portable Genius, 3^rd Edition offers expert tips and tricks that will save you time and hassles—and help you unlock all your device has to offer. Designed for the visual learner, it provides plenty of full-color screenshots that illustrate exactly what you'll see and do on your iPhone. Plus, 'Genius Icons' throughout the text highlight smarter, more innovative ways to do what you need to do. So what are you waiting for? Everything you need to truly make the most of your iPhone is here.

• Connect to a network, configure your settings, and work with iCloud
• Max out the media features, surf the Web, and check your e-mail
• Manage your contacts, appointments, e-books, and libraries
• Sync your apps, photos, music, and more

iPad Portable Genius is a practical, easy to read guide to getting the most out of your iPad. Written in a clear, no-nonsense style, this full-color resource describes the tips and tricks you may not discover on your own. You'll find helpful information about the most commonly used features, along with techniques that can help you do better things faster. Genius icons throughout the text highlight smarter ways to get things done, and plenty of screenshots provide visual examples of the techniques described. With coverage of the latest iOS and the newer-generation iPad Air and iPad mini, this book is a handy reference for any iPad user.

Apple's iPad is unrivaled as the industry leader. Each generation of the iPad includes even more features than before, and the app store offers a world of ways to further customize your iPad to suit your needs. iPad Portable Genius gives you the fundamental skills that not only enhance your current iPad use, but also carry over into upgrades, new apps and the underlying techniques that can help you make the most of the iOS. Learn to:

• Find your way around iPad Air 2, iPad mini 3, and older models of the iPad and iPad mini
• Connect to a network and sync your apps, photos, music, and more
• Organize your contacts and track your appointments
• Get more out of e-mail, audio, video, and Web surfing
• Configure your iPad, download apps, and troubleshoot when things go wrong

You've got the most coveted tablet on the market—don't you want to see what it can do? If you're only using your iPad for e-mail and the Internet, you haven't even scratched the surface. iPad Portable Genius is your handy guide to full iPad functionality.

Get the basics of Excel and then go beyond with this new instructional visual guide

While many users need Excel just to create simple worksheets, many businesses and professionals rely on the advanced features of Excel to handle things like database creation and data analysis. Whatever project you have in mind, this visual guide takes you step by step through what each step should look like. Veteran author Paul McFedries first presents the basics and then gradually takes it further with his coverage of designing worksheets, collaborating between worksheets, working with visual data, database management and analysis, VBA, and more.

• Offers step-by-step instructions on a variety of tasks, some everyday and some more unique
• Shows you how to create basic spreadsheets, insert functions and formulas, work with pivot tables, and more
• Features a two-color interior features numerous screen shots to enhance your learning process for tasks such as creating and managing macros, generating and working with analytics, and using the advanced tools

Offering you a deep dive into Microsoft Excel, this book is the complete package for learning Excel with step-by-step, clear visual instructions.

Excel expert Paul McFedries shows how to use Excel 2013’s core features to solve problems and get the answers you need. Using real-world examples, McFedries helps you get the absolute most out of features and improvements ranging from FlashFill to Excel’s newest functions. Along the way, you discover the fastest, best ways to handle essential day-to-day tasks ranging from generating account numbers to projecting the impact of inflation.

Becoming an Excel expert has never been easier! You’ll find crystal-clear instructions; insider insights; even complete step-by-step projects for building timesheets, projecting cash flow, aging receivables, analyzing defects, and more..

•   Quickly create powerful spreadsheets with FlashFill

•   Use conditional formatting to instantly reveal anomalies, problems, or opportunities

•   Analyze your data with standard tables and PivotTables

•   Use complex criteria to filter data in lists

•   Understand correlations between data

•   Perform sophisticated what-if analyses

•   Use regression to track trends and make forecasts

•   Build loan, investment, and discount formulas

•   Validate data, troubleshoot problems, and build more accurate, trustworthy spreadsheets

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

CATEGORY: Spreadsheets

COVERS: Microsoft Office Excel 2013

The step-by-step, visual way to learn Excel 2013

Excel can be complicated, but this Visual guide shows you exactly how to tackle every essential task with full-color screen shots and step-by-step instructions. You'll see exactly what each step should look like as you learn to use all the new tools in this latest release of the world's most popular spreadsheet program. In easy two-page lessons, author Paul McFedries shows you how to organize, present, analyze, and chart data, over the web or on a network.

• The Visual learning system is perfect for teaching Excel; previous editions of this book have sold more than 230,000 copies
• Covers common Excel 2013 tasks such as creating spreadsheets and charts, filtering and sorting data, and working with PivotTables
• Provides step-by-step instructions for each task
• Each step is illustrated with full-color screenshots

Teach Yourself VISUALLY Excel 2013 offers visual learners the ideal way to master this popular but complex spreadsheet program.