Brilliant Microsoft Excel 2007 Tips and Tricks

Book excerpt: This book provides the intermediate/experienced Excel user with everything they need to build on their existing Excel skills to more effectively use and develop all of the more advanced features and functions of Excel 2007. All over the world, Excel developers, power-users and gurus have been working overtime to uncover the hottest new tips, tricks, and tweaks. Now all of these have been collected in one place: Brilliant Microsoft Excel 2007 Tips & Tricks. Here you will find tips and shortcuts from Excel professionals, instructors, and power users; the best of solutions scoured from the Web (so you won't have to). Only the most valuable tips techniques and tweaks made the cut to improve your efficiency, take total control of Excel 2007 and avoid, troubleshoot and fix problems; make Excel work better, faster, smarter and safer. This book is targeted specifically at users of previous versions of Excel who are ready to take their learning to a new level and to develop their skills to harness the power of the new features of Excel 2007. The book begins by introducing all of the new features and functions of Excel 2007. The reader will then go on to learn what's new to this version of Excel and will refine and further their existing Excel skills. Most readers of this book will be developing databases/spreadsheets, macros and applications for themselves and one or two other users, and most will have no previous development experience. The book covers all topics necessary to take advantage of Excel 2007's rich set of features. Much of the book will be devoted to topics such as tables, queries, forms, reports, macros, beginning VBA, beginning security, and introduction to Excel and the Internet and an introduction to Excel and SharePoint. The teaching style of the book is clear and succinct with no superfluous material. It straddles the market between end-user and developer books, meeting the needs of those who want more than an end-user level book delivers, but who don't want or need a developer book. Author Information: Greg Holden (Chicago, IL) has written more than 30 books on computers and the Internet, including Introducing MS Expression Studio; Starting an Online Business for Dummies, and How to Do Everything with Your eBay Business. He is founder and owner of Stylus Media, his own small Internet-based business. Brilliant Excel 2007 Tips & Tricks: Provides expert information for the intermediate to advanced Excel user that is not available in any other book. Provides the reader with all of the new tips and tricks that are available with Excel 2007 whilst reinforcing and improving their basic Excel skills.