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.

Pivot tables are the most powerful feature in Excel. A basic pivot table will allow you to summarize 500,000 rows of transactional data in 30 seconds with just a few mouse clicks. Business productivity would skyrocket if everyone knew how to use pivot tables. However, only 12% of people using Excel can create a basic pivot table. Of this group only a small percentage actually harness all the power that pivot tables afford them. By the end of the book, users will be pivot table gurus automating pivot tables using VBA, creating pivot tables with external data in OLAP cubes, and even creating dynamic reporting systems so that managers can answer their own queries with a few mouse clicks. Throughout the book there are no-nonsense, step-by-step tutorials and lots of practical examples aimed directly at business users.

Are you a visual learner? Do you prefer instructions that show you how to do something - and skip the long-winded explanations? If so, then this book is for you. Open it up and you'll find clear, step-by-step screen shots that show you how to tackle more than 150 Excel 2007 tasks. Each task-based spread includes easy, visual directions for performing necessary operations, including: * Using the Ribbon and galleries * Entering data and resizing columns * Applying formulas and functions * Formatting worksheets * Adding clip art and 3D effects * Interpreting data with charts * Helpful sidebars offer practical tips and tricks * Succinct explanations walk you through step by step * Full-color screen shots demonstrate each task * Two-page lessons break big topics into bite-sized modules

Provides a step-by-step guide to using Visual Basic for Applications (VBA) and macros to import data and produce reports in Microsoft Excel 2010.

Brilliant guides allow you to find the info you need easily and without fuss and guide you through the task using a highly visual, step-by-step approach - providing exactly what you need to know, when you need it !! Brilliant Excel 2007 will show you how to .... · Create workbooks more efficiently using the new results-oriented interface · Use data analysis tools and techniques for better decision making · Use organizing, processing, and presenting tools to create data in Excel · Integrate data from external sources and add hyperlinks · Use conditional formatting to visualize results · Create your own macros to automate your work · Add impact to your data with PivotTable and PivotChart reports · Create organizational data reporting and publishing solutions · Organize information and impact with clip art, SmartArt diagrams, tables and charts · Use Groove and SharePoint Team Services to collaborate and share documents and information

Conquer Microsoft Excel formulas and functions—from the inside out! You’re beyond the basics, so dive right in and really put Excel formulas and functions to work! This supremely organized reference packs hundreds of timesaving solutions, troubleshooting tips, and workarounds. It’s all muscle and no fluff. Discover how the experts increase their data analysis capabilities using Excel 2003, 2007, or 2010—and challenge yourself to new levels of mastery. Customize Excel formulas using 350+ built-in functions Create reusable formulas for common calculations Learn smarter ways to calculate date and time values Systematically search worksheets with lookup and reference functions Perform advanced calculations using mathematical, statistical, and financial functions Build complex formulas by nesting one function inside of another Analyze profit margins and more with new functions in Excel 2010 Develop your own functions with Visual Basic for Applications (VBA) NOTE: The sample Excel files that accompany the book were updated on 12/4/2012. Click the Companion Content link to download the files.

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!