Search This Blog

Thursday, July 8, 2010

Microsoft Office Excel 2007: Top 100 Simplified Tips & Tricks


Microsoft Office Excel 2007: Top 100 Simplified Tips & Tricks

Publisher: Visual (July 23, 2007)
Language: English
ISBN-10: 0470126744
ISBN-13: 978-0470126745

Product Description
You already know Excel 2007. Now you'd like to go beyond with shortcuts, tricks, and tips that let you work smarter and faster. And because you learn more easily when someone shows you how, this is the book for you. Inside, you'll find clear, illustrated instructions for 100 tasks that reveal cool secrets, teach timesaving tricks, and explain great tips guaranteedto make you more productive with Excel 2007.
  1. Minimal text and maximum illustrations
  2. Task-oriented, step-by-step approach
  3. Navigational aids connect instructions to illustrations
  4. Self-contained, two-page lessons
  5. Uniform layout makes it easy to read less, learn more

Excel 2007 Data Analysis For Dummies


Excel 2007 Data Analysis For Dummies

# Paperback: 356 pages
# Publisher: For Dummies (February 20, 2007)
# Language: English
# ISBN-10: 047004599X
# ISBN-13: 978-0470045992

Product 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

Excel 2007 Dashboards and Reports For Dummies


Free Image Hosting at www.ImageShack.us

# Paperback: 318 pages
# Publisher: For Dummies (March 4, 2008)
# Language: English
# ISBN-10: 0470228148
# ISBN-13: 978-0470228142
Product Description
What’s the use of putting out reports that no one reads? Properly created dashboards are graphical representations that put data in a context for your audience, and they look really cool! How cool? You’ll find out when you see the dazzling examples in Excel 2007 Dashboards & Reports For Dummies. And, before long, everyone’s eyes will be riveted to your dashboards and reports too!
This revolutionary guide shows you how to turn Excel into your own personal Business Intelligence tool. You’ll learn the fundamentals of using Excel 2007 to go beyond simple tables to creating dashboard-studded reports that wow management. Get ready to catch dashboard fever as you find out how to use basic analysis techniques, build advanced dashboard components, implement advanced reporting techniques, and import external date into your Excel reports. Discover how to:
  • Unleash the power of Excel as a business intelligence tool
  • Create dashboards that communicate and get noticed
  • Think about your data in a new way
  • Present data more effectively and increase the value of your reports
  • Create dynamic labels that support visualization
  • Represent time and seasonal trending
  • Group and bucket data
  • Display and measure values versus goals
  • Implement macro-charged reporting
Using Excel 2007 as a BI tool is the most cost-efficient way for organizations of any size create powerful and insightful reports and distribute throughout the enterprise. And Excel 2007 Dashboards and Reports for Dummies is the fastest you for you to catch dashboard fever!

Excel 2007 VBA Programming For Dummies


Excel 2007 VBA Programming For Dummies

# Paperback: 384 pages
# Publisher: For Dummies (February 20, 2007)
# Language: English
# ISBN-10: 0470046740
# ISBN-13: 978-0470046746
Product 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