The great power of VBA programming in Office is that nearly every operation that you can perform with a mouse, keyboard, or a dialog box can also be done by using VBA. There are many different ways to author, format, and manipulate documents, email, databases, forms, spreadsheets, and presentations. The Office suite of applications has a rich set of features. This article is for experienced Office users who want to learn about VBA and who want some insight into how programming can help them to customize Office. You can perform these tasks and accomplish a great deal more by using Visual Basic for Applications (VBA) for Office-a simple, but powerful programming language that you can use to extend Office applications. The hands-on focus on tasks means you'll see how to actually use Excel 2010 to suit your needs.Are you facing a repetitive clean up of fifty tables in Word? Do you want a particular document to prompt the user for input when it opens? Are you having difficulty figuring out how to get your contacts from Microsoft Outlook into a Microsoft Excel spreadsheet efficiently? For instance, it shows you how to use Sparklines for data comparison and the Backstage view for printing and sharing your spreadsheets, so you can carry out your tasks with minimum fuss. You'll see how to place your data in tables and named ranges for easy access, all of which will get you working efficiently and productively.Įxcel 2010 Made Simple also covers the new features introduced in Excel 2010. You'll learn how to input, format, sort, and filter your data to find out what you want to know. Over 500 screen visuals and clear-cut instructions guide you through the features of Excel 2010, from formulas and charts to navigating around a worksheet and understanding Visual Basic for Applications (VBA) and macros.Įxcel 2010 Made Simple takes a practical and highly effective approach to using Excel 2010, showing you the best way to complete your most common spreadsheet tasks.

Get the most out of Excel 2010 with Excel 2010 Made Simple-learn the key features, understand what’s new, and utilize dozens of time-saving tips and tricks to get your job done.

Learn visual basic for excel 2010