Excel 2007 VBA Programming For Dummies (For Dummies

Book Description
Step-by-step instructions for creating VBA macros

Harness the power of VBA and create custom Excel applications

Make Excel 2007 work for you! This clear, nonintimidating guide shows you how to use VBA to create Excel apps that look and work the way you want. Packed with plenty of sample programs, it explains how to work with range objects, control program flow, develop custom dialog boxes, create custom toolbars and menus, and much more.

Discover how to
* Grasp essential programming concepts
* Use the Visual Basic(r) Editor
* Navigate the new Excel user interface
* Communicate with your users
* Deal with errors and bugs

From the Back Cover
Step-by-step instructions for creating VBA macros

Harness the power of VBA and create custom Excel applications

Make Excel 2007 work for you! This clear, nonintimidating guide shows you how to use VBA to create Excel apps that look and work the way you want. Packed with plenty of sample programs, it explains how to work with range objects, control program flow, develop custom dialog boxes, create custom toolbars and menus, and much more.

Discover how to
* Grasp essential programming concepts
* Use the Visual Basic® Editor
* Navigate the new Excel user interface
* Communicate with your users
* Deal with errors and bugs

Link:
http://depositfiles.com/files/878670

Read full post

Excel 2007 Data Analysis For Dummies

Book Description
* Shows ordinary users how to tap the rich data analysis functionality of Excel, make sense of their organization's critical financial and statistical information, and put together compelling data presentations
* Now revised with over 30 percent new content to cover the enhancements in Excel 2007, including the completely redesigned user interface, augmented charting and PivotTable capabilities, improved security, and better data exchange through XML
* Provides thorough coverage of Excel features that are critical to data analysis-working with external databases, creating PivotTables and PivotCharts, using Excel statistical and financial functions, sharing data, harnessing the Solver, taking advantage of the Small Business Finance Manager, and more

From the Back Cover
Unleash the power of Excel to make sense of your data

The fun and easy way to gain new insights into your data

This handy guide helps you analyze the information you work with in your job to make better decisions. From grabbing external data to working with PivotCharts, database functions, and regression analysis, it shows you step by step how Excel can turn raw data into intelligible information.

Discover how to
* Import data into Excel
* Work with PivotTables
* Use database and statistical functions
* Customize PivotCharts
* Set up a Solver worksheet
* Perform regression analysis calculations

Link:
http://depositfiles.com/files/878679
or
http://www.megaupload.com/?d=HUW1IQ4B

Read full post